classes/press/FooterCategoryDAO.inc.php

<?php

import ('classes.press.FooterCategory');

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

   function &getById($categoryId, $pressId = null) {
      $params = array((int) $categoryId);
      if ($pressId) $params[] = (int) $pressId;

      $result =& $this->retrieve(
         'SELECT *
         FROM footer_categories
         WHERE footer_category_id = ?
         ' . ($pressId?' AND press_id = ?':''),
         $params
      );

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

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

      return $returner;
   }

   function &getByPath($path, $pressId) {
      $returner = null;
      $result =& $this->retrieve(
         'SELECT * FROM footer_categories WHERE path = ? AND press_id = ?',
         array((string) $path, (int) $pressId)
      );

      if ($result->RecordCount() != 0) {
         $returner =& $this->_fromRow($result->GetRowAssoc(false));
      }

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

      return $returner;
   }

   function categoryExistsByPath($path, $pressId = null) {
      $params = array($path);
      if ($pressId) $params[] = (int) $pressId;

      $result =& $this->retrieve(
         'SELECT COUNT(*) FROM footer_categories WHERE path = ?
         ' . ($pressId?' AND press_id = ?':''),
         $params
      );
      $returner = isset($result->fields[0]) && $result->fields[0] == 1 ? true : false;

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

      return $returner;
   }

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

   function _fromRow(&$row) {
      $category = $this->newDataObject();

      $category->setId($row['footer_category_id']);
      $category->setPressId($row['press_id']);
      $category->setPath($row['path']);

      $this->getDataObjectSettings('footer_category_settings', 'footer_category_id', $row['footer_category_id'], $category);

      HookRegistry::call('FooterCategoryDAO::_fromRow', array(&$category, &$row));

      return $category;
   }

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

   function updateLocaleFields(&$category) {
      $this->updateDataObjectSettings(
         'footer_category_settings', $category,
         array(
            'footer_category_id' => $category->getId()
         )
      );
   }

   function insertObject(&$category) {
      $this->update(
         'INSERT INTO footer_categories
            (press_id, path)
            VALUES
            (?, ?)',
         array(
            (int) $category->getPressId(),
            $category->getPath()
         )
      );

      $category->setId($this->getInsertFooterCategoryId());
      $this->updateLocaleFields($category);
      return $category->getId();
   }

   function updateObject($category) {
      $returner = $this->update(
         'UPDATE footer_categories
         SET   press_id = ?,
            path = ?
         WHERE footer_category_id = ?',
         array(
            (int) $category->getPressId(),
            $category->getPath(),
            (int) $category->getId()
         )
      );
      $this->updateLocaleFields($category);
      return $returner;
   }

   function deleteObject(&$category) {
      return $this->deleteById(
         $category->getId(),
         $category->getPressId()
      );
   }

   function deleteById($categoryId, $pressId = null) {
      $params = array((int) $categoryId);
      if ($pressId) $params[] = (int) $pressId;

      $this->update(
         'DELETE FROM footer_categories
         WHERE footer_category_id = ?
            ' . ($pressId?' AND press_id = ?':''),
         $params
      );

      // If the category was deleted (this validates press_id,
      // if specified), delete any associated settings as well.
      if ($this->getAffectedRows()) {
         $this->update(
            'DELETE FROM footer_category_settings WHERE footer_category_id = ?',
            array((int) $categoryId)
         );

         return true;
      }
   }

   function deleteByPressId($pressId) {
      $categories =& $this->getByPressId($pressId);
      while ($category =& $categories->next()) {
         $this->deleteObject($category, $pressId);
         unset($category);
      }
   }

   function &getByPressId($pressId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT *
         FROM footer_categories
         WHERE press_id = ?',
         array((int) $pressId)
      );

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

   function &getNotEmptyByPressId($pressId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT DISTINCT f.footer_category_id, f.*
         FROM  footer_categories f, footerlinks fl
         WHERE f.footer_category_id = fl.footer_category_id AND f.press_id = ?',
         array((int) $pressId)
      );

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

   function &getCountByPressId($pressId) {
      $result =& $this->retrieve(
         'SELECT COUNT(*)
         FROM footer_categories
         WHERE press_id = ?',
         (int) $pressId
      );

      $returner = $result->fields[0];

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

   function getInsertFooterCategoryId() {
      return $this->getInsertId('footer_categories', 'footer_category_id');
   }
}

?>