classes/monograph/MonographFileSignoffDAO.inc.php

<?php

import('classes.signoff.SignoffDAO');

class MonographFileSignoffDAO extends SignoffDAO {
   function MonographFileSignoffDAO() {
      parent::SignoffDAO();
   }


   //
   // Public methods
   //
   function &getById($signoffId) {
      $returner =& parent::getById($signoffId, ASSOC_TYPE_MONOGRAPH_FILE);
      return $returner;
   }

   function &build($symbolic, $monographFileId, $userId = null,
         $userGroupId = null, $fileId = null, $fileRevision = null) {
      $returner =& parent::build(
         $symbolic,
         ASSOC_TYPE_MONOGRAPH_FILE, $monographFileId,
         $userId, $userGroupId,
         $fileId, $fileRevision
      );
      return $returner;
   }

   function signoffExists($symbolic, $monographFileId, $userId = null, $userGroupId = null) {
      return parent::signoffExists($symbolic, ASSOC_TYPE_MONOGRAPH_FILE, $userId, $userGroupId);
   }

   function newDataObject() {
      $signoff = parent::newDataObject();
      $signoff->setAssocType(ASSOC_TYPE_MONOGRAPH_FILE);
      return $signoff;
   }

   function &getBySymbolic($symbolic, $monographFileId, $userId = null,
         $userGroupId = null, $fileId = null, $fileRevision = null) {
      $returner = parent::getBySymbolic(
         $symbolic,
         ASSOC_TYPE_MONOGRAPH_FILE, $monographFileId,
         $userId, $userGroupId,
         $fileId, $fileRevision
      );
      return $returner;
   }

   function getAllBySymbolic($symbolic, $monographFileId = null, $userId = null, $userGroupId = null) {
      return parent::getAllBySymbolic($symbolic, ASSOC_TYPE_MONOGRAPH_FILE, $monographFileId, $userId, $userGroupId);
   }

   function getAllByMonograph($monographId, $symbolic = null, $userId = null, $userGroupId = null, $notCompletedOnly = false) {
      $sql = 'SELECT s.* FROM signoffs s, monograph_files mf WHERE s.assoc_type = ? AND s.assoc_id = mf.file_id AND mf.monograph_id = ?';
      $params = array(ASSOC_TYPE_MONOGRAPH_FILE, (int) $monographId);

      if ($symbolic) {
         $sql .= ' AND s.symbolic = ?';
         $params[] = $symbolic;
      }
      if ($userId) {
         $sql .= ' AND user_id = ?';
         $params[] = (int) $userId;
      }

      if ($userGroupId) {
         $sql .= ' AND user_group_id = ?';
         $params[] = (int) $userGroupId;
      }

      if ($notCompletedOnly) {
         $sql .= ' AND date_completed IS NULL';
      }

      $result =& $this->retrieve($sql, $params);

      $returner = new DAOResultFactory($result, $this, '_fromRow', array('id'));
      return $returner;
   }
}

?>