classes/press/FooterLinkDAO.inc.php

<?php

import ('classes.press.FooterLink');

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

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

      $result =& $this->retrieve(
         'SELECT  *
         FROM  footerlinks
         WHERE footerlink_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 newDataObject() {
      return new FooterLink();
   }

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

      $footerLink->setId($row['footerlink_id']);
      $footerLink->setPressId($row['press_id']);
      $footerLink->setUrl($row['url']);
      $footerLink->setCategoryId($row['footer_category_id']);

      $this->getDataObjectSettings('footerlink_settings', 'footerlink_id', $row['footerlink_id'], $footerLink);

      HookRegistry::call('FooterLinkDAO::_fromRow', array(&$footerLink, &$row));

      return $footerLink;
   }

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

   function updateLocaleFields(&$footerLink) {
      $this->updateDataObjectSettings(
         'footerlink_settings', $footerLink,
         array(
            'footerlink_id' => $footerLink->getId()
         )
      );
   }

   function insertObject(&$footerLink) {
      $this->update(
         'INSERT INTO footerlinks
            (press_id, footer_category_id, url)
            VALUES
            (?, ?, ?)',
         array(
            (int) $footerLink->getPressId(),
            (int) $footerLink->getCategoryId(),
            $footerLink->getUrl()
         )
      );

      $footerLink->setId($this->getInsertFooterLinkId());
      $this->updateLocaleFields($footerLink);
      return $footerLink->getId();
   }

   function updateObject($footerLink) {
      $returner = $this->update(
         'UPDATE  footerlinks
         SET   press_id = ?,
            footer_category_id = ?,
            url = ?
         WHERE footerlink_id = ?',
         array(
            (int) $footerLink->getPressId(),
            (int) $footerLink->getCategoryId(),
            $footerLink->getUrl(),
            (int) $footerLink->getId()
         )
      );
      $this->updateLocaleFields($footerLink);
      return $returner;
   }

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

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

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

      // If the link was deleted (this validates press_id,
      // if specified), delete any associated settings as well.
      if ($this->getAffectedRows()) {
         return $this->update(
            'DELETE FROM footerlink_settings WHERE footerlink_id = ?',
            array((int) $footerLinkId)
         );
      }
   }

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

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

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

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

   function getInsertFooterLinkId() {
      return $this->getInsertId('footerlinks', 'footerlink_id');
   }

   function getLargestCategoryTotalByPressId($pressId) {
      $result =& $this->retrieve(
         'SELECT count(*) AS total
         FROM footerlinks
         WHERE press_id = ? GROUP BY footer_category_id
         ORDER BY total DESC LIMIT 1', array((int)$pressId));

      $returner = null;
      if ($result->RecordCount() != 0) {
         $row =& $result->GetRowAssoc(false);
         $returner = $row['total'];
      }

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

      return $returner;

   }
}
?>