SubmissionDAO.inc.php

<?php
 
import('classes.submission.Submission');
import('lib.pkp.classes.submission.PKPSubmissionDAO');
 
class SubmissionDAO extends PKPSubmissionDAO {
 
   public function newDataObject() {
      return new Submission();
   }
 
   function deleteById($submissionId) {
      $publicationIds = Services::get('publication')->getIds(['submissionIds' => $submissionId]);
      $articleGalleyDao = DAORegistry::getDAO('ArticleGalleyDAO'); /* @var $articleGalleyDao ArticleGalleyDAO */
 
      foreach ($publicationIds as $publicationId) {
         $galleys = $articleGalleyDao->getByPublicationId($publicationId)->toArray();
         foreach ($galleys as $galley) {
            $articleGalleyDao->deleteById($galley->getId());
         }
      }
 
      $articleSearchDao = DAORegistry::getDAO('ArticleSearchDAO'); /* @var $articleSearchDao ArticleSearchDAO */
      $articleSearchDao->deleteSubmissionKeywords($submissionId);
 
      $articleSearchIndex = Application::getSubmissionSearchIndex();
      $articleSearchIndex->articleDeleted($submissionId);
      $articleSearchIndex->submissionChangesFinished();
 
      parent::deleteById($submissionId);
 
      $this->flushCache();
   }
 
   function changeStatus($articleId, $status) {
      $this->update(
         'UPDATE submissions SET status = ? WHERE submission_id = ?',
         array((int) $status, (int) $articleId)
      );
 
      $this->flushCache();
   }
 
   function removeSubmissionsFromSection($sectionId) {
      $this->update(
         'DELETE FROM publication_settings WHERE setting_name = \'sectionId\' AND setting_value = ?', (int) $sectionId
      );
 
      $this->flushCache();
   }
}