RepresentativeDAO.inc.php

<?php
 
import('classes.monograph.Representative');
 
class RepresentativeDAO extends DAO {
   function getById($representativeId, $monographId = null){
      $sqlParams = array((int) $representativeId);
      if ($monographId) {
         $sqlParams[] = (int) $monographId;
      }
 
      $result = $this->retrieve(
         'SELECT r.*
            FROM representatives r
         JOIN submissions s ON (r.submission_id = s.submission_id)
         WHERE r.representative_id = ?
            ' . ($monographId?' AND s.submission_id = ?':''),
         $sqlParams
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   function getSuppliersByMonographId($monographId) {
      $result = $this->retrieveRange(
         'SELECT * FROM representatives WHERE submission_id = ? AND is_supplier = ?', array((int) $monographId, 1));
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getAgentsByMonographId($monographId) {
      $result = $this->retrieveRange(
            'SELECT * FROM representatives WHERE submission_id = ? AND is_supplier = ?', array((int) $monographId, 0));
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function newDataObject() {
      return new Representative();
   }
 
   function _fromRow($row, $callHooks = true) {
      $representative = $this->newDataObject();
      $representative->setId($row['representative_id']);
      $representative->setRole($row['role']);
      $representative->setRepresentativeIdType($row['representative_id_type']);
      $representative->setRepresentativeIdValue($row['representative_id_value']);
      $representative->setName($row['name']);
      $representative->setPhone($row['phone']);
      $representative->setEmail($row['email']);
      $representative->setUrl($row['url']);
      $representative->setIsSupplier($row['is_supplier']);
      $representative->setMonographId($row['submission_id']);
 
      if ($callHooks) HookRegistry::call('RepresentativeDAO::_fromRow', array(&$representative, &$row));
 
      return $representative;
   }
 
   function insertObject($representative) {
      $this->update(
         'INSERT INTO representatives
            (submission_id, role, representative_id_type, representative_id_value, name, phone, email, url, is_supplier)
         VALUES
            (?, ?, ?, ?, ?, ?, ?, ?, ?)',
         array(
            (int) $representative->getMonographId(),
            $representative->getRole(),
            $representative->getRepresentativeIdType(),
            $representative->getRepresentativeIdValue(),
            $representative->getName(),
            $representative->getPhone(),
            $representative->getEmail(),
            $representative->getUrl(),
            (int) $representative->getIsSupplier()
         )
      );
 
      $representative->setId($this->getInsertId());
      return $representative->getId();
   }
 
   function updateObject($representative) {
      $this->update(
         'UPDATE representatives
            SET role = ?,
            representative_id_type = ?,
            representative_id_value = ?,
            name = ?,
            phone = ?,
            email = ?,
            url = ?,
            is_supplier = ?
         WHERE representative_id = ?',
         array(
            $representative->getRole(),
            $representative->getRepresentativeIdType(),
            $representative->getRepresentativeIdValue(),
            $representative->getName(),
            $representative->getPhone(),
            $representative->getEmail(),
            $representative->getUrl(),
            (int) $representative->getIsSupplier(),
            (int) $representative->getId()
         )
      );
   }
 
   function deleteObject($representative) {
      return $this->deleteById($representative->getId());
   }
 
   function deleteById($entryId) {
      return $this->update(
         'DELETE FROM representatives WHERE representative_id = ?', (int) $entryId
      );
   }
 
   function getInsertId() {
      return $this->_getInsertId('representatives', 'representative_id');
   }
}