classes/publicationFormat/IdentificationCodeDAO.inc.php

<?php

import('classes.publicationFormat.IdentificationCode');

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

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

      $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 = ?
            ' . ($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 identification_codes WHERE publication_format_id = ?', (int) $publicationFormatId);

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

   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->getInsertIdentificationCodeId());
      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 getInsertIdentificationCodeId() {
      return $this->getInsertId('identification_codes', 'identification_code_id');
   }
}

?>