ChapterDAO.inc.php

<?php
 
import('classes.monograph.Chapter');
import('classes.monograph.ChapterAuthor');
 
class ChapterDAO extends DAO implements PKPPubIdPluginDAO {
   function getChapter($chapterId, $publicationId = null) {
      $params = array((int) $chapterId);
      if ($publicationId !== null) {
         $params[] = (int) $publicationId;
      }
 
      $result = $this->retrieve(
         'SELECT * FROM submission_chapters WHERE chapter_id = ?'
         . ($publicationId !== null?' AND publication_id = ? ':''),
         $params
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   function getByPublicationId($publicationId, $orderBySequence = true) {
      $result = $this->retrieve(
         'SELECT  spc.*
         FROM submission_chapters spc
         INNER JOIN publications p ON (spc.publication_id = p.publication_id)
         WHERE p.publication_id = ?'
         . ($orderBySequence ? ' ORDER BY spc.seq ASC' : ''),
         (int) $publicationId
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getByContextId($pressId) {
      $result = $this->retrieve(
         'SELECT  spc.*
         FROM submission_chapters spc
         INNER JOIN publications p ON (spc.publication_id = p.publication_id)
         INNER JOIN submissions s ON (p.submission_id = s.submission_id)
         WHERE s.context_id = ?',
         (int) $pressId
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getLocaleFieldNames() {
      return array('title', 'subtitle','abstract');
   }
 
   function getAdditionalFieldNames() {
      $additionalFields = parent::getAdditionalFieldNames();
      // FIXME: Move this to a PID plug-in.
      $additionalFields[] = 'pub-id::publisher-id';
      $additionalFields[] = 'datePublished';
      $additionalFields[] = 'pages';
      return $additionalFields;
   }
 
   function newDataObject() {
      return new Chapter();
   }
 
   function _fromRow($row) {
      $chapter = $this->newDataObject();
      $chapter->setId((int) $row['chapter_id']);
      $chapter->setData('publicationId', (int) $row['publication_id']);
      $chapter->setSequence((int) $row['seq']);
 
      $this->getDataObjectSettings('submission_chapter_settings', 'chapter_id', $row['chapter_id'], $chapter);
 
      HookRegistry::call('ChapterDAO::_fromRow', array(&$chapter, &$row));
 
      return $chapter;
   }
 
   function updateLocaleFields($chapter) {
      $this->updateDataObjectSettings('submission_chapter_settings', $chapter, array(
         'chapter_id' => $chapter->getId()
      ));
   }
 
   function insertChapter($chapter) {
      $this->update(
         'INSERT INTO submission_chapters
            (publication_id, seq)
            VALUES
            (?, ?)',
         array(
            (int) $chapter->getData('publicationId'),
            (int) $chapter->getSequence(),
         )
      );
 
      $chapter->setId($this->getInsertId());
      $this->updateLocaleFields($chapter);
      return $chapter->getId();
   }
 
   function updateObject($chapter) {
      $this->update(
         'UPDATE submission_chapters
            SET   publication_id = ?,
               seq = ?
            WHERE
               chapter_id = ?',
         array(
            (int) $chapter->getData('publicationId'),
            (int) $chapter->getSequence(),
            (int) $chapter->getId()
         )
      );
      $this->updateLocaleFields($chapter);
   }
 
   function deleteObject($chapter) {
      $this->deleteById($chapter->getId());
   }
 
   function deleteById($chapterId) {
      $this->update('DELETE FROM submission_chapter_authors WHERE chapter_id = ?', (int) $chapterId);
      $this->update('DELETE FROM submission_chapter_settings WHERE chapter_id = ?', (int) $chapterId);
      $this->update('DELETE FROM submission_chapters WHERE chapter_id = ?', (int) $chapterId);
      $this->update('DELETE FROM submission_file_settings WHERE setting_name = ? AND setting_value = ?', ['chapterId', (int) $chapterId]);
   }
 
   function resequenceChapters($publicationId) {
      $params = array();
      if ($publicationId !== null) {
         $params[] = (int) $publicationId;
      }
 
      $result = $this->retrieve(
         'SELECT chapter_id FROM submission_chapters
         WHERE 1=1'
         . ($publicationId !== null ? ' AND publication_id = ?':'')
         . ' ORDER BY seq',
         $params
      );
 
      for ($i=1; !$result->EOF; $i++) {
         list($chapterId) = $result->fields;
         $this->update(
            'UPDATE submission_chapters SET seq = ? WHERE chapter_id = ?',
            array(
               (int) $i,
               (int) $chapterId
            )
         );
 
         $result->MoveNext();
      }
 
      $result->Close();
   }
 
   function getInsertId() {
      return $this->_getInsertId('submission_chapters', 'chapter_id');
   }
 
   function pubIdExists($pubIdType, $pubId, $excludePubObjectId, $contextId) {
      $result = $this->retrieve(
         'SELECT COUNT(*)
         FROM submission_chapter_settings scs
         INNER JOIN submission_chapters sc ON scs.chapter_id = sc.chapter_id
         INNER JOIN publications p ON sc.publication_id = p.publication_id
         INNER JOIN submissions s ON p.submission_id = s.submission_id
         WHERE scs.setting_name = ?
         AND scs.setting_value = ?
         AND sc.chapter_id <> ?
         AND s.context_id = ?',
         array(
            'pub-id::'.$pubIdType,
            $pubId,
            (int) $excludePubObjectId,
            (int) $contextId
         )
      );
      $returner = $result->fields[0] ? true : false;
      $result->Close();
      return $returner;
   }
 
   function changePubId($pubObjectId, $pubIdType, $pubId) {
      $idFields = array(
         'chapter_id', 'locale', 'setting_name'
      );
      $updateArray = array(
         'chapter_id' => (int) $pubObjectId,
         'locale' => '',
         'setting_name' => 'pub-id::'.$pubIdType,
         'setting_type' => 'string',
         'setting_value' => (string)$pubId
      );
      $this->replace('submission_chapter_settings', $updateArray, $idFields);
   }
 
   function deletePubId($pubObjectId, $pubIdType) {
      $settingName = 'pub-id::'.$pubIdType;
      $this->update(
         'DELETE FROM submission_chapter_settings WHERE setting_name = ? AND chapter_id = ?',
         array(
            $settingName,
            (int)$pubObjectId
         )
      );
      $this->flushCache();
   }
 
   function deleteAllPubIds($contextId, $pubIdType) {
      $settingName = 'pub-id::'.$pubIdType;
 
      $chapters = $this->getByContextId($contextId);
      while ($chapter = $chapters->next()) {
         $this->update(
            'DELETE FROM submission_chapter_settings WHERE setting_name = ? AND chapter_id = ?',
            array(
               $settingName,
               (int)$chapter->getId()
            )
         );
      }
      $this->flushCache();
   }
}