FeatureDAO.inc.php

<?php
 
class FeatureDAO extends DAO {
   function __construct() {
      parent::__construct();
   }
 
   function getMonographIdsByAssoc($assocType, $assocId) {
      $returner = array();
      $result = $this->retrieve(
         'SELECT submission_id, seq FROM features WHERE assoc_type = ? AND assoc_id = ? ORDER BY seq',
         array((int) $assocType, (int) $assocId)
      );
 
      while (!$result->EOF) {
         list($monographId, $seq) = $result->fields;
         $returner[$seq] = $monographId;
         $result->MoveNext();
      }
 
      $result->Close();
      return $returner;
   }
 
   function getSequencesByAssoc($assocType, $assocId) {
      return array_flip($this->getMonographIdsByAssoc($assocType, $assocId));
   }
 
   function insertFeature($monographId, $assocType, $assocId, $seq) {
      $this->update(
         'INSERT INTO features
            (submission_id, assoc_type, assoc_id, seq)
            VALUES
            (?, ?, ?, ?)',
         array(
            (int) $monographId,
            (int) $assocType,
            (int) $assocId,
            (int) $seq
         )
      );
   }
 
   function deleteByMonographId($monographId) {
      $this->update(
         'DELETE FROM features WHERE submission_id = ?',
         (int) $monographId
      );
   }
 
   function deleteByAssoc($assocType, $assocId) {
      $this->update(
         'DELETE FROM features WHERE assoc_type = ? AND assoc_id = ?',
         array((int) $assocType, (int) $assocId)
      );
   }
 
   function deleteFeature($monographId, $assocType, $assocId) {
      $this->update(
         'DELETE FROM features
         WHERE submission_id = ? AND
            assoc_type = ? AND
            assoc_id = ?',
         array(
            (int) $monographId,
            (int) $assocType,
            (int) $assocId
         )
      );
   }
 
   function isFeatured($monographId, $assocType, $assocId) {
      $result = $this->retrieve(
         'SELECT submission_id FROM features WHERE submission_id = ? AND assoc_type = ? AND assoc_id = ?',
         array((int) $monographId, (int) $assocType, (int) $assocId)
      );
      if ($result->RecordCount() > 0) {
         return true;
      }
 
      return false;
   }
 
   function getFeaturedAll($monographId) {
      $result = $this->retrieve(
         'SELECT assoc_type, assoc_id, seq FROM features WHERE submission_id = ?',
         array((int) $monographId)
      );
 
      $featured = array();
      while (!$result->EOF) {
         $featured[] = array(
            'assoc_type' => (int) $result->fields['assoc_type'],
            'assoc_id' => (int) $result->fields['assoc_id'],
            'seq' => (int) $result->fields['seq'],
         );
         $result->MoveNext();
      }
 
      return $featured;
   }
 
   function getSequencePosition($monographId, $assocType, $assocId) {
      $result = $this->retrieve(
         'SELECT seq FROM features WHERE submission_id = ? AND assoc_type = ? AND assoc_id = ?',
         array((int) $monographId, (int) $assocType, (int) $assocId)
      );
      if ($result->RecordCount() > 0) {
         return current($result->fields);
      }
 
      return false;
   }
 
   function setSequencePosition($monographId, $assocType, $assocId, $sequencePosition) {
      $this->update(
         'UPDATE features SET seq = ? WHERE submission_id = ? AND assoc_type = ? AND assoc_id = ?',
         array((int) $sequencePosition, (int) $monographId, (int) $assocType, (int) $assocId)
      );
   }
 
   function resequenceByAssoc($assocType, $assocId) {
      $returner = array();
      $result = $this->retrieve(
         'SELECT submission_id FROM features WHERE assoc_type = ? AND assoc_id = ? ORDER BY seq',
         array((int) $assocType, (int) $assocId)
      );
 
      for ($i=2; !$result->EOF; $i+=2) {
         list($monographId) = $result->fields;
         $this->update(
            'UPDATE features SET seq = ? WHERE submission_id = ? AND assoc_type = ? AND assoc_id = ?',
            array(
               $i,
               $monographId,
               (int) $assocType,
               (int) $assocId
            )
         );
         $returner[$monographId] = $i;
 
         $result->MoveNext();
      }
 
      $result->Close();
      return $returner;
   }
}