classes/press/FeatureDAO.inc.php

<?php

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

   function getMonographIdsByAssoc($assocType, $assocId) {
      $returner = array();
      $result =& $this->retrieve(
         'SELECT monograph_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();
      unset($result);

      return $returner;
   }

   function getSequencesByAssoc($assocType, $assocId) {
      return array_flip($this->getMonographIdsByAssoc($assocType, $assocId));
   }

   function insertFeature($monographId, $assocType, $assocId, $seq) {
      $this->update(
         'INSERT INTO features
            (monograph_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 monograph_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 monograph_id = ? AND
            assoc_type = ? AND
            assoc_id = ?',
         array(
            (int) $monographId,
            (int) $assocType,
            (int) $assocId
         )
      );
   }

   function resequenceByAssoc($assocType, $assocId) {
      $returner = array();
      $result =& $this->retrieve(
         'SELECT monograph_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 monograph_id = ? AND assoc_type = ? AND assoc_id = ?',
            array(
               $i,
               $monographId,
               (int) $assocType,
               (int) $assocId
            )
         );
         $returner[$monographId] = $i;

         $result->MoveNext();
      }

      $result->Close();
      unset($result);

      return $returner;
   }
}

?>