classes/submission/proofAssignment/ProofAssignmentDAO.inc.php

<?php

// $Id: ProofAssignmentDAO.inc.php,v 1.20 2008/07/01 01:16:11 asmecher Exp $


import('submission.proofAssignment.ProofAssignment');

class ProofAssignmentDAO extends DAO {
   var $userDao;

   function ProofAssignmentDAO() {
      parent::DAO();
      $this->userDao = &DAORegistry::getDAO('UserDAO');
   }

   function &getProofAssignment($proofId) {
      $result = &$this->retrieve(
         'SELECT p.*, u.first_name, u.last_name, u.email FROM proof_assignments p LEFT JOIN users u ON (p.proofreader_id = u.user_id) WHERE p.proof_id = ?',
         $proofId
         );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnProofAssignmentFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function &getProofAssignmentByArticleId($articleId) {
      $result = &$this->retrieve(
         'SELECT p.*, u.first_name, u.last_name, u.email FROM proof_assignments p LEFT JOIN users u ON (p.proofreader_id = u.user_id) WHERE p.article_id = ?',
         $articleId
         );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnProofAssignmentFromRow($result->GetRowAssoc(false));
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function &_returnProofAssignmentFromRow(&$row) {
      $proofAssignment = &new ProofAssignment();
      $proofAssignment->setProofId($row['proof_id']);
      $proofAssignment->setArticleId($row['article_id']);
      $proofAssignment->setProofreaderId($row['proofreader_id']);

      $proofAssignment->setDateAuthorNotified($this->datetimeFromDB($row['date_author_notified']));
      $proofAssignment->setDateAuthorUnderway($this->datetimeFromDB($row['date_author_underway']));
      $proofAssignment->setDateAuthorCompleted($this->datetimeFromDB($row['date_author_completed']));
      $proofAssignment->setDateAuthorAcknowledged($this->datetimeFromDB($row['date_author_acknowledged']));

      $proofAssignment->setDateProofreaderNotified($this->datetimeFromDB($row['date_proofreader_notified']));
      $proofAssignment->setDateProofreaderUnderway($this->datetimeFromDB($row['date_proofreader_underway']));
      $proofAssignment->setDateProofreaderCompleted($this->datetimeFromDB($row['date_proofreader_completed']));
      $proofAssignment->setDateProofreaderAcknowledged($this->datetimeFromDB($row['date_proofreader_acknowledged']));

      $proofAssignment->setDateLayoutEditorNotified($this->datetimeFromDB($row['date_layouteditor_notified']));
      $proofAssignment->setDateLayoutEditorUnderway($this->datetimeFromDB($row['date_layouteditor_underway']));
      $proofAssignment->setDateLayoutEditorCompleted($this->datetimeFromDB($row['date_layouteditor_completed']));
      $proofAssignment->setDateLayoutEditorAcknowledged($this->datetimeFromDB($row['date_layouteditor_acknowledged']));

      $proofAssignment->setProofreaderFirstName($row['first_name']);
      $proofAssignment->setProofreaderLastName($row['last_name']);      
      $proofAssignment->setProofreaderEmail($row['email']);

      HookRegistry::call('ProofAssignmentDAO::_returnProofAssignmentFromRow', array(&$proofAssignment, &$row));

      return $proofAssignment;
   }

   function insertProofAssignment(&$proofAssignment) {
      $this->update(
         sprintf('INSERT INTO proof_assignments
            (article_id, proofreader_id, date_author_notified, date_author_underway, date_author_completed, date_author_acknowledged, date_proofreader_notified, date_proofreader_underway, date_proofreader_completed, date_proofreader_acknowledged, date_layouteditor_notified, date_layouteditor_underway, date_layouteditor_completed, date_layouteditor_acknowledged)
            VALUES
            (?, ?, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)',
            $this->datetimeToDB($proofAssignment->getDateAuthorNotified()),
            $this->datetimeToDB($proofAssignment->getDateAuthorUnderway()),
            $this->datetimeToDB($proofAssignment->getDateAuthorCompleted()),
            $this->datetimeToDB($proofAssignment->getDateAuthorAcknowledged()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderNotified()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderUnderway()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderCompleted()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderAcknowledged()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorNotified()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorUnderway()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorCompleted()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorAcknowledged())),
         array(
            $proofAssignment->getArticleId(),
            $proofAssignment->getProofreaderId()
         )
      );

      $proofAssignment->setProofId($this->getInsertProofId());
      return $proofAssignment->getProofId();
   }

   function updateProofAssignment(&$proofAssignment) {
      return $this->update(
         sprintf('UPDATE proof_assignments
            SET   article_id = ?,
               proofreader_id = ?,
               date_author_notified = %s,
               date_author_underway = %s,
               date_author_completed = %s,
               date_author_acknowledged = %s,
               date_proofreader_notified = %s,
               date_proofreader_underway = %s,
               date_proofreader_completed = %s,
               date_proofreader_acknowledged = %s,
               date_layouteditor_notified = %s,
               date_layouteditor_underway = %s,
               date_layouteditor_completed = %s,
               date_layouteditor_acknowledged = %s
            WHERE proof_id = ?',
            $this->datetimeToDB($proofAssignment->getDateAuthorNotified()),
            $this->datetimeToDB($proofAssignment->getDateAuthorUnderway()),
            $this->datetimeToDB($proofAssignment->getDateAuthorCompleted()),
            $this->datetimeToDB($proofAssignment->getDateAuthorAcknowledged()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderNotified()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderUnderway()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderCompleted()),
            $this->datetimeToDB($proofAssignment->getDateProofreaderAcknowledged()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorNotified()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorUnderway()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorCompleted()),
            $this->datetimeToDB($proofAssignment->getDateLayoutEditorAcknowledged())),
         array(
            $proofAssignment->getArticleId(),
            $proofAssignment->getProofreaderId(),
            $proofAssignment->getProofId()
         )
      );
   }

   function deleteProofAssignmentById($proofId) {
      return $this->update(
         'DELETE FROM proof_assignments WHERE proof_id = ?',
         $proofId
      );
   }

   function deleteProofAssignmentsByArticle($articleId) {
      return $this->update(
         'DELETE FROM proof_assignments WHERE article_id = ?',
         $articleId
      );
   }

   function getInsertProofId() {
      return $this->getInsertId('proof_assignments', 'proof_id');
   }
}

?>

---