[Summary view]

Differences Between: [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * Bump submission timemodified for conversions that are stale.
  19   *
  20   * @package    assignfeedback_editpdf
  21   * @copyright  2022 Catalyst IT Australia Pty Ltd
  22   * @author     Cameron Ball <cameronball@catalyst-au.net>
  23   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  24   */
  25  
  26  namespace assignfeedback_editpdf\task;
  27  
  28  use core\task\adhoc_task;
  29  
  30  /**
  31   * Adhoc task to bump the submission timemodified associated with a stale conversion.
  32   *
  33   * @package    assignfeedback_editpdf
  34   * @copyright  2022 Catalyst IT Australia Pty Ltd
  35   * @author     Cameron Ball <cameronball@catalyst-au.net>
  36   * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  class bump_submission_for_stale_conversions extends adhoc_task {
  39  
  40      /**
  41       * Run the task.
  42       */
  43      public function execute() {
  44          global $DB;
  45  
  46          // Used to only get records after whenever document conversion was enabled for this site.
  47          $earliestconversion = $DB->get_record_sql("SELECT MIN(timecreated) AS min
  48                                                       FROM {files}
  49                                                      WHERE filearea = 'documentconversion'");
  50  
  51          if ($earliestconversion) {
  52              ['sql' => $extensionsql, 'params' => $extensionparams] = array_reduce(
  53                  ['doc', 'docx', 'rtf', 'xls', 'xlsx', 'ppt', 'pptx', 'html', 'odt', 'ods', 'png', 'jpg', 'txt', 'gif'],
  54                  function(array $c, string $ext) use ($DB): array {
  55                      return [
  56                          'sql' => $c['sql'] . ($c['sql'] ? ' OR ' : '') . $DB->sql_like('f1.filename', ':' . $ext),
  57                          'params' => $c['params'] + [$ext => '%.' . $ext]
  58                      ];
  59                  },
  60                  ['sql' => '', 'params' => []]
  61              );
  62  
  63              // A converted file has its filename set to the contenthash of the file it converted.
  64              // Find all files in the relevant file areas for which there is no corresponding
  65              // file with the contenthash as the file name.
  66              //
  67              // Also check if the file has a greater modified time than the submission, if it does
  68              // that means it is both stale (as per the above) and will never be reconverted.
  69              $sql = "SELECT f3.id, f3.timemodified as fmodified, asu.id as submissionid
  70                        FROM {files} f1
  71                   LEFT JOIN {files} f2 ON f1.contenthash = f2.filename
  72                             AND f2.component = 'core' AND f2.filearea = 'documentconversion'
  73                        JOIN {assign_submission} asu ON asu.id = f1.itemid
  74                        JOIN {assign_grades} asg ON asg.userid = asu.userid AND asg.assignment = asu.assignment
  75                        JOIN {files} f3 ON f3.itemid = asg.id
  76                       WHERE f1.filearea = 'submission_files'
  77                             AND f3.timecreated >= :earliest
  78                             AND ($extensionsql)
  79                             AND f2.filename IS NULL
  80                             AND f3.component = 'assignfeedback_editpdf'
  81                             AND f3.filearea = 'combined'
  82                             AND f3.filename = 'combined.pdf'
  83                             AND f3.timemodified >= asu.timemodified";
  84  
  85              $submissionstobump = $DB->get_records_sql($sql, ['earliest' => $earliestconversion->min] + $extensionparams);
  86              foreach ($submissionstobump as $submission) {
  87  
  88                  // Set the submission modified time to one second later than the
  89                  // converted files modified time, this will cause assign to reconvert
  90                  // everything and delete the old files when the assignment grader is
  91                  // viewed. See get_page_images_for_attempt in document_services.php.
  92                  $newmodified = $submission->fmodified + 1;
  93                  $record = (object)[
  94                      'id' => $submission->submissionid,
  95                      'timemodified' => $newmodified
  96                  ];
  97  
  98                  mtrace('Set submission ' . $submission->submissionid . ' timemodified to ' . $newmodified);
  99                  $DB->update_record('assign_submission', $record);
 100              }
 101          }
 102      }
 103  }