EditDecisionDAO.inc.php

<?php
 
// Bring in editor decision constants
// FIXME: These should be standardized into lib-pkp.
import('classes.workflow.EditorDecisionActionsManager');
 
class EditDecisionDAO extends DAO {
 
   function updateEditorDecision($submissionId, $editorDecision, $stageId = null, $reviewRound = null) {
      if ($editorDecision['editDecisionId'] == null) {
         $this->update(
            sprintf(
               'INSERT INTO edit_decisions
               (submission_id, review_round_id, stage_id, round, editor_id, decision, date_decided)
               VALUES (?, ?, ?, ?, ?, ?, %s)',
               $this->datetimeToDB($editorDecision['dateDecided'])
            ),
            array(
               (int) $submissionId,
               is_a($reviewRound, 'ReviewRound') ? (int) $reviewRound->getId() : 0,
               is_a($reviewRound, 'ReviewRound') ? $reviewRound->getStageId() : (int) $stageId,
               is_a($reviewRound, 'ReviewRound') ? (int) $reviewRound->getRound() : REVIEW_ROUND_NONE,
               (int) $editorDecision['editorId'],
               $editorDecision['decision']
            )
         );
      }
   }
 
   function deleteDecisionsBySubmissionId($submissionId) {
      return $this->update(
         'DELETE FROM edit_decisions WHERE submission_id = ?',
         (int) $submissionId
      );
   }
 
   function getEditorDecisions($submissionId, $stageId = null, $round = null, $editorId = null) {
      $params = array((int) $submissionId);
      if ($stageId) $params[] = (int) $stageId;
      if ($round) $params[] = (int) $round;
      if ($editorId) $params[] = (int) $editorId;
 
      $result = $this->retrieve(
         'SELECT  edit_decision_id, editor_id, decision,
            date_decided, review_round_id, stage_id, round
         FROM  edit_decisions
         WHERE submission_id = ?
            ' . ($stageId?' AND stage_id = ?':'') . '
            ' . ($round?' AND round = ?':'') . '
            ' . ($editorId?' AND editor_id = ?':'') . '
            ORDER BY date_decided ASC',
         $params
      );
 
      $decisions = array();
      while (!$result->EOF) {
         $decisions[] = array(
            'editDecisionId' => $result->fields['edit_decision_id'],
            'reviewRoundId' => $result->fields['review_round_id'],
            'stageId' => $result->fields['stage_id'],
            'round' => $result->fields['round'],
            'editorId' => $result->fields['editor_id'],
            'decision' => $result->fields['decision'],
            'dateDecided' => $this->datetimeFromDB($result->fields['date_decided'])
         );
         $result->MoveNext();
      }
      $result->Close();
      return $decisions;
   }
 
   function transferEditorDecisions($oldUserId, $newUserId) {
      $this->update(
         'UPDATE edit_decisions SET editor_id = ? WHERE editor_id = ?',
         array((int) $newUserId, (int) $oldUserId)
      );
   }
 
   function findValidPendingRevisionsDecision($submissionId, $expectedStageId, $revisionDecision = SUBMISSION_EDITOR_DECISION_PENDING_REVISIONS) {
      $postReviewDecisions = array(SUBMISSION_EDITOR_DECISION_SEND_TO_PRODUCTION);
      $revisionDecisions = array(SUBMISSION_EDITOR_DECISION_PENDING_REVISIONS, SUBMISSION_EDITOR_DECISION_RESUBMIT);
      if (!in_array($revisionDecision, $revisionDecisions)) return null;
 
      $editDecisionDao = DAORegistry::getDAO('EditDecisionDAO'); /* @var $editDecisionDao EditDecisionDAO */
      $editorDecisions = $editDecisionDao->getEditorDecisions($submissionId);
      $workingDecisions = array_reverse($editorDecisions);
      $pendingRevisionDecision = null;
 
      foreach ($workingDecisions as $decision) {
         if (in_array($decision['decision'], $postReviewDecisions)) {
            // Decisions at later stages do not override the pending revisions one.
            continue;
         } elseif ($decision['decision'] == $revisionDecision) {
            if ($decision['stageId'] == $expectedStageId) {
               $pendingRevisionDecision = $decision;
               // Only the last pending revisions decision is relevant.
               break;
            } else {
               // Both internal and external pending revisions decisions are
               // valid at the same time. Continue to search.
               continue;
            }
 
         } else {
            break;
         }
      }
 
      return $pendingRevisionDecision;
   }
 
   function responseExists($decision, $submissionId) {
      $stageId = $decision['stageId'];
      $round = $decision['round'];
      $sentRevisions = false;
 
      $reviewRoundDao = DAORegistry::getDAO('ReviewRoundDAO'); /* @var $reviewRoundDao ReviewRoundDAO */
      $reviewRound = $reviewRoundDao->getReviewRound($submissionId, $stageId, $round);
 
      $submissionFileDao = DAORegistry::getDAO('SubmissionFileDAO'); /* @var $submissionFileDao SubmissionFileDAO */
      import('lib.pkp.classes.submission.SubmissionFile'); // Bring the file constants.
      $submissionFiles =  $submissionFileDao->getRevisionsByReviewRound($reviewRound, SUBMISSION_FILE_REVIEW_REVISION);
 
      if (is_array($submissionFiles)) {
         foreach ($submissionFiles as $file) {
            if ($file->getDateUploaded() > $decision['dateDecided']) {
               $sentRevisions = true;
               break;
            }
         }
      }
 
      return $sentRevisions;
   }
}