classes/monograph/ChapterDAO.inc.php

<?php

import('classes.monograph.Chapter');
import('classes.monograph.ChapterAuthor');

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

   function &getChapter($chapterId, $monographId = null) {
      $params = array((int) $chapterId);
      if ($monographId !== null) {
         $params[] = (int) $monographId;
      }

      $result =& $this->retrieve(
         'SELECT * FROM monograph_chapters WHERE chapter_id = ?' . ($monographId !== null?' AND monograph_id = ? ':''),
         $params
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner =& $this->_returnFromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      unset($result);
      return $returner;
   }

   function &getChapters($monographId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT chapter_id, monograph_id, chapter_seq FROM monograph_chapters WHERE monograph_id = ? ORDER BY chapter_seq',
         (int) $monographId,
         $rangeInfo
      );

      $returner = new DAOResultFactory($result, $this, '_returnFromRow', array('id'));
      return $returner;
   }

   function getLocaleFieldNames() {
      return array('title', 'subtitle');
   }

   function newDataObject() {
      return new Chapter();
   }

   function &_returnFromRow(&$row) {
      $chapter = $this->newDataObject();
      $chapter->setId($row['chapter_id']);
      $chapter->setMonographId($row['monograph_id']);
      $chapter->setSequence($row['chapter_seq']);
      $this->getDataObjectSettings('monograph_chapter_settings', 'chapter_id', $row['chapter_id'], $chapter);

      HookRegistry::call('ChapterDAO::_returnFromRow', array(&$chapter, &$row));

      return $chapter;
   }

   function updateLocaleFields(&$chapter) {
      $this->updateDataObjectSettings('monograph_chapter_settings', $chapter, array(
         'chapter_id' => $chapter->getId()
      ));
   }

   function insertChapter(&$chapter) {
      $this->update(
         'INSERT INTO monograph_chapters
            (monograph_id, chapter_seq)
            VALUES
            (?, ?)',
         array(
            (int) $chapter->getMonographId(),
            (int) $chapter->getSequence()
         )
      );

      $chapter->setId($this->getInsertChapterId());
      $this->updateLocaleFields($chapter);
      return $chapter->getId();
   }

   function updateObject(&$chapter) {
      $returner = $this->update(
         'UPDATE monograph_chapters
            SET   monograph_id = ?,
               chapter_seq = ?
            WHERE
               chapter_id = ?',
         array(
            (int) $chapter->getMonographId(),
            (int) $chapter->getSequence(),
            (int) $chapter->getId()
         )
      );
      $this->updateLocaleFields($chapter);
      return $returner;
   }

   function deleteObject(&$chapter) {
      return $this->deleteById($chapter->getId());
   }

   function deleteById($chapterId) {
      $returner1 = $this->update('DELETE FROM monograph_chapter_authors WHERE chapter_id = ?', (int) $chapterId);
      $returner2 = $this->update('DELETE FROM monograph_chapter_settings WHERE chapter_id = ?', (int) $chapterId);
      $returner3 = $this->update('DELETE FROM monograph_chapters WHERE chapter_id = ?', (int) $chapterId);
      return ($returner1 && $returner2 && $returner3);
   }

   function deleteByMonographId($monographId) {
      $chapters =& $this->getChapters($monographId);
      while ($chapter =& $chapters->next()) {
         $this->deleteObject($chapter);
         unset($chapter);
      }
   }

   function resequenceChapters($monographId = null) {
      $result =& $this->retrieve(
         'SELECT chapter_id FROM monograph_chapters' .
         ($monographId !== null?' WHERE monograph_id = ?':'') .
         ' ORDER BY seq',
         ($monographId !== null)?(int) $monographId:null
      );

      for ($i=1; !$result->EOF; $i++) {
         list($chapterId) = $result->fields;
         $this->update(
            'UPDATE monograph_chapters SET chapter_seq = ? WHERE chapter_id = ?',
            array(
               (int) $i,
               (int) $chapterId
            )
         );

         $result->MoveNext();
      }

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

   function getInsertChapterId() {
      return $this->getInsertId('chapters', 'chapter_id');
   }
}

?>