PublicationDateDAO.inc.php

<?php
 
import('classes.publicationFormat.PublicationDate');
 
class PublicationDateDAO extends DAO {
   function __construct() {
      parent::__construct();
   }
 
   function getById($publicationDateId, $publicationId = null){
      $sqlParams = array((int) $publicationDateId);
      if ($publicationId) {
         $sqlParams[] = (int) $publicationId;
      }
 
      $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 = ?
            ' . ($publicationId?' AND pf.publication_id = ?':''),
         $sqlParams
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   function getByPublicationFormatId($representationId) {
      $result = $this->retrieveRange(
         'SELECT * FROM publication_dates WHERE publication_format_id = ?',
         (int) $representationId
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   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->getInsertId());
      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 getInsertId() {
      return $this->_getInsertId('publication_dates', 'publication_date_id');
   }
}