IdentificationCodeDAO.inc.php

<?php
 
import('classes.publicationFormat.IdentificationCode');
 
class IdentificationCodeDAO extends DAO {
   function __construct() {
      parent::__construct();
   }
 
   function getById($identificationCodeId, $publicationId = null){
      $sqlParams = array((int) $identificationCodeId);
      if ($publicationId) {
         $sqlParams[] = (int) $publicationId;
      }
 
      $result = $this->retrieve(
         'SELECT  i.*
         FROM  identification_codes i
            JOIN publication_formats pf ON (i.publication_format_id = pf.publication_format_id)
         WHERE i.identification_code_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($publicationFormatId) {
      $result = $this->retrieveRange(
         'SELECT * FROM identification_codes WHERE publication_format_id = ?', (int) $publicationFormatId);
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function newDataObject() {
      return new IdentificationCode();
   }
 
   function _fromRow($row, $callHooks = true) {
      $identificationCode = $this->newDataObject();
      $identificationCode->setId($row['identification_code_id']);
      $identificationCode->setCode($row['code']);
      $identificationCode->setValue($row['value']);
      $identificationCode->setPublicationFormatId($row['publication_format_id']);
 
      if ($callHooks) HookRegistry::call('IdentificationCodeDAO::_fromRow', array(&$identificationCode, &$row));
 
      return $identificationCode;
   }
 
   function insertObject($identificationCode) {
      $this->update(
         'INSERT INTO identification_codes
            (publication_format_id, code, value)
         VALUES
            (?, ?, ?)',
         array(
            (int) $identificationCode->getPublicationFormatId(),
            $identificationCode->getCode(),
            $identificationCode->getValue()
         )
      );
 
      $identificationCode->setId($this->getInsertId());
      return $identificationCode->getId();
   }
 
   function updateObject($identificationCode) {
      $this->update(
         'UPDATE identification_codes
            SET code = ?, value = ?
         WHERE identification_code_id = ?',
         array(
            $identificationCode->getCode(),
            $identificationCode->getValue(),
            (int) $identificationCode->getId()
         )
      );
   }
 
   function deleteObject($identificationCode) {
      return $this->deleteById($identificationCode->getId());
   }
 
   function deleteById($entryId) {
      return $this->update(
         'DELETE FROM identification_codes WHERE identification_code_id = ?', array((int) $entryId)
      );
   }
 
   function getInsertId() {
      return $this->_getInsertId('identification_codes', 'identification_code_id');
   }
}