plugins/generic/staticPages/StaticPagesDAO.inc.php

Go to the documentation of this file.

<?php
import('db.DAO');

class StaticPagesDAO extends DAO {

   function getStaticPage($staticPageId) {
      $result =& $this->retrieve(
         'SELECT * FROM static_pages WHERE static_page_id = ?', $staticPageId
      );

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

   function &getStaticPagesByConferenceId($conferenceId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM static_pages WHERE conference_id = ?', $conferenceId, $rangeInfo
      );

      $returner = new DAOResultFactory($result, $this, '_returnStaticPageFromRow');
      return $returner;
   }

   function getStaticPageByPath($conferenceId, $path) {
      $result =& $this->retrieve(
         'SELECT * FROM static_pages WHERE conference_id = ? AND path = ?', array($conferenceId, $path)
      );

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

   function insertStaticPage(&$staticPage) {
      $this->update(
         'INSERT INTO static_pages
            (conference_id, path)
            VALUES
            (?, ?)',
         array(
            $staticPage->getConferenceId(),
            $staticPage->getPath()
         )
      );

      $staticPage->setId($this->getInsertStaticPageId());
      $this->updateLocaleFields($staticPage);

      return $staticPage->getId();
   }

   function updateStaticPage(&$staticPage) {
      $returner = $this->update(
         'UPDATE static_pages
            SET
               conference_id = ?,
               path = ?
            WHERE static_page_id = ?',
            array(
               $staticPage->getConferenceId(),
               $staticPage->getPath(),
               $staticPage->getId()
               )
         );
      $this->updateLocaleFields($staticPage);
      return $returner;
   }

   function deleteStaticPageById($staticPageId) {
      $returner = $this->update(
         'DELETE FROM static_pages WHERE static_page_id = ?', $staticPageId
      );
      return $this->update(
         'DELETE FROM static_page_settings WHERE static_page_id = ?', $staticPageId
      );
   }

   function &_returnStaticPageFromRow(&$row) {
      $staticPagesPlugin =& PluginRegistry::getPlugin('generic', 'StaticPagesPlugin');
      $staticPagesPlugin->import('StaticPage');

      $staticPage = new StaticPage();
      $staticPage->setId($row['static_page_id']);
      $staticPage->setPath($row['path']);
      $staticPage->setConferenceId($row['conference_id']);

      $this->getDataObjectSettings('static_page_settings', 'static_page_id', $row['static_page_id'], $staticPage);
      return $staticPage;
   }

   function getInsertStaticPageId() {
      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()
      ));
   }

   function duplicatePathExists ($path, $conferenceId, $staticPageId = null) {
      $params = array(
               $conferenceId,
               $path
               );
      if (isset($staticPageId)) $params[] = $staticPageId;

      $result = $this->retrieve(
         'SELECT *
            FROM static_pages
            WHERE conference_id = ?
            AND path = ?' .
            (isset($staticPageId)?' AND NOT (static_page_id = ?)':''),
            $params
         );

      if($result->RecordCount() == 0) {
         // no duplicate exists
         $returner = false;
      } else {
         $returner = true;
      }
      return $returner;
   }
}
?>

---