StaticPagesDAO.inc.php

<?php
 
import('lib.pkp.classes.db.DAO');
import('plugins.generic.staticPages.classes.StaticPage');
 
class StaticPagesDAO extends DAO {
 
   function getById($staticPageId, $contextId = null) {
      $params = array((int) $staticPageId);
      if ($contextId) $params[] = $contextId;
 
      $result = $this->retrieve(
         'SELECT * FROM static_pages WHERE static_page_id = ?'
         . ($contextId?' AND context_id = ?':''),
         $params
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   function getByContextId($contextId, $rangeInfo = null) {
      $result = $this->retrieveRange(
         'SELECT * FROM static_pages WHERE context_id = ?',
         (int) $contextId,
         $rangeInfo
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   function getByPath($contextId, $path) {
      $result = $this->retrieve(
         'SELECT * FROM static_pages WHERE context_id = ? AND path = ?',
         array((int) $contextId, $path)
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   function insertObject($staticPage) {
      $this->update(
         'INSERT INTO static_pages (context_id, path) VALUES (?, ?)',
         array(
            (int) $staticPage->getContextId(),
            $staticPage->getPath()
         )
      );
 
      $staticPage->setId($this->getInsertId());
      $this->updateLocaleFields($staticPage);
 
      return $staticPage->getId();
   }
 
   function updateObject($staticPage) {
      $this->update(
         'UPDATE  static_pages
         SET   context_id = ?,
            path = ?
         WHERE static_page_id = ?',
         array(
            (int) $staticPage->getContextId(),
            $staticPage->getPath(),
            (int) $staticPage->getId()
         )
      );
      $this->updateLocaleFields($staticPage);
   }
 
   function deleteById($staticPageId) {
      $this->update(
         'DELETE FROM static_pages WHERE static_page_id = ?',
         (int) $staticPageId
      );
      $this->update(
         'DELETE FROM static_page_settings WHERE static_page_id = ?',
         (int) $staticPageId
      );
   }
 
   function deleteObject($staticPage) {
      $this->deleteById($staticPage->getId());
   }
 
   function newDataObject() {
      return new StaticPage();
   }
 
   function _fromRow($row) {
      $staticPage = $this->newDataObject();
      $staticPage->setId($row['static_page_id']);
      $staticPage->setPath($row['path']);
      $staticPage->setContextId($row['context_id']);
 
      $this->getDataObjectSettings('static_page_settings', 'static_page_id', $row['static_page_id'], $staticPage);
      return $staticPage;
   }
 
   function getInsertId() {
      return $this->_getInsertId('static_pages', 'static_page_id');
   }
 
   function getLocaleFieldNames() {
      return array('title', 'content');
   }
 
   function updateLocaleFields(&$staticPage) {
      $this->updateDataObjectSettings('static_page_settings', $staticPage, array(
         'static_page_id' => $staticPage->getId()
      ));
   }
}