classes/publicationFormat/PublicationDateDAO.inc.php

<?php

import('classes.publicationFormat.PublicationDate');

class PublicationDateDAO extends DAO {
   function PublicationDateDAO() {
      parent::DAO();
   }

   function &getById($publicationDateId, $monographId = null){
      $sqlParams = array((int) $publicationDateId);
      if ($monographId) {
         $sqlParams[] = (int) $monographId;
      }

      $result =& $this->retrieve(
         'SELECT p.*
         FROM  publication_dates p
            JOIN publication_formats pf ON (p.publication_format_id = pf.publication_format_id)
         WHERE p.publication_date_id = ?
            ' . ($monographId?' AND pf.monograph_id = ?':''),
         $sqlParams
      );

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

   function &getByPublicationFormatId($publicationFormatId) {
      $result =& $this->retrieveRange(
         'SELECT * FROM publication_dates WHERE publication_format_id = ?',
         (int) $publicationFormatId
      );

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

   function newDataObject() {
      return new PublicationDate();
   }

   function &_fromRow(&$row, $callHooks = true) {
      $publicationDate = $this->newDataObject();
      $publicationDate->setId($row['publication_date_id']);
      $publicationDate->setRole($row['role']);
      $publicationDate->setDateFormat($row['date_format']);
      $publicationDate->setDate($row['date']);
      $publicationDate->setPublicationFormatId($row['publication_format_id']);

      if ($callHooks) HookRegistry::call('PublicationDateDAO::_fromRow', array(&$publicationDate, &$row));

      return $publicationDate;
   }

   function insertObject(&$publicationDate) {
      $this->update(
         'INSERT INTO publication_dates
            (publication_format_id, role, date_format, date)
         VALUES
            (?, ?, ?, ?)',
         array(
            (int) $publicationDate->getPublicationFormatId(),
            $publicationDate->getRole(),
            $publicationDate->getDateFormat(),
            $publicationDate->getDate()
         )
      );

      $publicationDate->setId($this->getInsertPublicationDateId());
      return $publicationDate->getId();
   }

   function updateObject(&$publicationDate) {
      $this->update(
         'UPDATE publication_dates
            SET role = ?, date_format =?, date = ?
         WHERE publication_date_id = ?',
         array(
            $publicationDate->getRole(),
            $publicationDate->getDateFormat(),
            $publicationDate->getDate(),
            (int) $publicationDate->getId()
         )
      );
   }

   function deleteObject($publicationDate) {
      return $this->deleteById($publicationDate->getId());
   }

   function deleteById($entryId) {
      return $this->update(
         'DELETE FROM publication_dates WHERE publication_date_id = ?', array((int) $entryId)
      );
   }

   function getInsertPublicationDateId() {
      return $this->getInsertId('publication_dates', 'publication_date_id');
   }
}

?>