classes/submission/layoutAssignment/LayoutAssignmentDAO.inc.php

<?php

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


import('submission.layoutAssignment.LayoutAssignment');

class LayoutAssignmentDAO extends DAO {
   var $articleFileDao;

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

   function &getLayoutAssignmentById($layoutId) {
      $result = &$this->retrieve(
         'SELECT l.*, u.first_name, u.last_name, u.email
            FROM layouted_assignments l
            LEFT JOIN users u ON (l.editor_id = u.user_id)
            WHERE layouted_id = ?',
         $layoutId
      );

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

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

      return $returner;
   }

   function getLayoutEditorIdByArticleId($articleId) {
      $result =& $this->retrieve(
         'SELECT editor_id FROM layouted_assignments WHERE article_id = ?',
         $articleId
      );
      $returner = null;
      if ($result->RecordCount() != 0) {
         $row = $result->GetRowAssoc(false);
         $returner = $row['editor_id'];
      }
      $result->Close();
      return $returner;
   }

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

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

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

      return $returner;
   }

   function &_returnLayoutAssignmentFromRow(&$row) {
      $layoutAssignment = &new LayoutAssignment();
      $layoutAssignment->setLayoutId($row['layouted_id']);
      $layoutAssignment->setArticleId($row['article_id']);
      $layoutAssignment->setEditorId($row['editor_id']);
      $layoutAssignment->setEditorFullName($row['first_name'].' '.$row['last_name']);
      $layoutAssignment->setEditorEmail($row['email']);
      $layoutAssignment->setDateNotified($this->datetimeFromDB($row['date_notified']));
      $layoutAssignment->setDateUnderway($this->datetimeFromDB($row['date_underway']));
      $layoutAssignment->setDateCompleted($this->datetimeFromDB($row['date_completed']));
      $layoutAssignment->setDateAcknowledged($this->datetimeFromDB($row['date_acknowledged']));
      $layoutAssignment->setLayoutFileId($row['layout_file_id']);

      if ($row['layout_file_id'] && $row['layout_file_id']) {
         $layoutAssignment->setLayoutFile($this->articleFileDao->getArticleFile($row['layout_file_id']));
      }

      HookRegistry::call('LayoutAssignmentDAO::_returnLayoutAssignmentFromRow', array(&$layoutAssignment, &$row));

      return $layoutAssignment;
   }

   function insertLayoutAssignment(&$layoutAssignment) {
      $this->update(
         sprintf('INSERT INTO layouted_assignments
            (article_id, editor_id, date_notified, date_underway, date_completed, date_acknowledged, layout_file_id)
            VALUES
            (?, ?, %s, %s, %s, %s, ?)',
            $this->datetimeToDB($layoutAssignment->getDateNotified()), $this->datetimeToDB($layoutAssignment->getDateUnderway()), $this->datetimeToDB($layoutAssignment->getDateCompleted()), $this->datetimeToDB($layoutAssignment->getDateAcknowledged())),
         array(
            $layoutAssignment->getArticleId(),
            $layoutAssignment->getEditorId(),
            $layoutAssignment->getLayoutFileId()
         )
      );

      $layoutAssignment->setLayoutId($this->getInsertLayoutId());
      return $layoutAssignment->getLayoutId();
   }

   function updateLayoutAssignment(&$layoutAssignment) {
      return $this->update(
         sprintf('UPDATE layouted_assignments
            SET   article_id = ?,
               editor_id = ?,
               date_notified = %s,
               date_underway = %s,
               date_completed = %s,
               date_acknowledged = %s,
               layout_file_id = ?
            WHERE layouted_id = ?',
            $this->datetimeToDB($layoutAssignment->getDateNotified()), $this->datetimeToDB($layoutAssignment->getDateUnderway()), $this->datetimeToDB($layoutAssignment->getDateCompleted()), $this->datetimeToDB($layoutAssignment->getDateAcknowledged())),
         array(
            $layoutAssignment->getArticleId(),
            $layoutAssignment->getEditorId(),
            $layoutAssignment->getLayoutFileId(),
            $layoutAssignment->getLayoutId()
         )
      );
   }

   function deleteLayoutAssignmentById($layoutId) {
      return $this->update(
         'DELETE FROM layouted_assignments WHERE layouted_id = ?',
         $layoutId
      );
   }

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

   function getInsertLayoutId() {
      return $this->getInsertId('layouted_assignments', 'layouted_id');
   }

   function getProofedArticlesByIssueId($issueId) {
      $articleIds = array();

      $result = &$this->retrieve(
         'SELECT pa.article_id AS article_id FROM published_articles pa, proof_assignments pra WHERE pa.article_id = pra.article_id AND pa.issue_id = ? AND pra.date_layouteditor_completed IS NOT NULL',
         array($issueId)
      );

      while (!$result->EOF) {
         $row = $result->GetRowAssoc(false);
         $articleIds[] = $row['article_id'];
         $result->MoveNext();
      }

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

      return $articleIds;
   }
}

?>

---