classes/submission/copyAssignment/CopyAssignmentDAO.inc.php

<?php

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


import('submission.copyAssignment.CopyAssignment');

class CopyAssignmentDAO extends DAO {
   var $articleFileDao;

   function CopyAssignmentDAO() {
      parent::DAO();
      $this->articleFileDao = &DAORegistry::getDAO('ArticleFileDAO');
   }

   function &getCopyAssignmentById($copyedId) {
      $result = &$this->retrieve(
         'SELECT c.*, u.first_name, u.last_name FROM copyed_assignments c LEFT JOIN users u ON (c.copyeditor_id = u.user_id) WHERE c.copyed_id = ?',
         $copyedId
      );

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

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

      return $returner;
   }

   function &getCopyAssignmentByArticleId($articleId) {
      $result = &$this->retrieve(
         'SELECT c.*, a.copyedit_file_id, u.first_name, u.last_name FROM copyed_assignments c LEFT JOIN articles a ON (c.article_id = a.article_id) LEFT JOIN users u ON (c.copyeditor_id = u.user_id) WHERE c.article_id = ?',
         $articleId
      );

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

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

      return $returner;
   }

   function &_returnCopyAssignmentFromRow(&$row) {
      $copyAssignment = &new CopyAssignment();

      // Copyedit Assignment
      $copyAssignment->setCopyedId($row['copyed_id']);
      $copyAssignment->setArticleId($row['article_id']);
      $copyAssignment->setCopyeditorId($row['copyeditor_id']);
      $copyAssignment->setCopyeditorFullName($row['first_name'].' '.$row['last_name']);
      $copyAssignment->setDateNotified($this->datetimeFromDB($row['date_notified']));
      $copyAssignment->setDateUnderway($this->datetimeFromDB($row['date_underway']));
      $copyAssignment->setDateCompleted($this->datetimeFromDB($row['date_completed']));
      $copyAssignment->setDateAcknowledged($this->datetimeFromDB($row['date_acknowledged']));
      $copyAssignment->setDateAuthorNotified($this->datetimeFromDB($row['date_author_notified']));
      $copyAssignment->setDateAuthorUnderway($this->datetimeFromDB($row['date_author_underway']));
      $copyAssignment->setDateAuthorCompleted($this->datetimeFromDB($row['date_author_completed']));
      $copyAssignment->setDateAuthorAcknowledged($this->datetimeFromDB($row['date_author_acknowledged']));
      $copyAssignment->setDateFinalNotified($this->datetimeFromDB($row['date_final_notified']));
      $copyAssignment->setDateFinalUnderway($this->datetimeFromDB($row['date_final_underway']));
      $copyAssignment->setDateFinalCompleted($this->datetimeFromDB($row['date_final_completed']));
      $copyAssignment->setDateFinalAcknowledged($this->datetimeFromDB($row['date_final_acknowledged']));
      $copyAssignment->setInitialRevision($row['initial_revision']);
      $copyAssignment->setEditorAuthorRevision($row['editor_author_revision']);
      $copyAssignment->setFinalRevision($row['final_revision']);

      // Files

      // Initial Copyedit File
      if ($row['initial_revision'] != null) {
         $copyAssignment->setInitialCopyeditFile($this->articleFileDao->getArticleFile($row['copyedit_file_id'], $row['initial_revision']));
      }

      // Editor / Author Copyedit File
      if ($row['editor_author_revision'] != null) {
         $copyAssignment->setEditorAuthorCopyeditFile($this->articleFileDao->getArticleFile($row['copyedit_file_id'], $row['editor_author_revision']));
      }

      // Final Copyedit File
      if ($row['final_revision'] != null) {
         $copyAssignment->setFinalCopyeditFile($this->articleFileDao->getArticleFile($row['copyedit_file_id'], $row['final_revision']));
      }

      HookRegistry::call('CopyAssignmentDAO::_returnCopyAssignmentFromRow', array(&$copyAssignment, &$row));

      return $copyAssignment;
   }

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

   function getInsertCopyedId() {
      return $this->getInsertId('copyed_assignments', 'copyed_id');
   }
}

?>

---