classes/press/SocialMediaDAO.inc.php

<?php

import ('classes.press.SocialMedia');

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

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

      $result =& $this->retrieve(
         'SELECT *
         FROM social_media
         WHERE social_media_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 SocialMedia();
   }

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

      $socialMedia->setId($row['social_media_id']);
      $socialMedia->setPressId($row['press_id']);
      $socialMedia->setCode($row['code']);
      $socialMedia->setIncludeInCatalog($row['include_in_catalog']);

      $this->getDataObjectSettings('social_media_settings', 'social_media_id', $row['social_media_id'], $socialMedia);

      HookRegistry::call('SocialMediaDAO::_fromRow', array(&$socialMedia, &$row));

      return $socialMedia;
   }

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

   function updateLocaleFields(&$socialMedia) {
      $this->updateDataObjectSettings(
         'social_media_settings', $socialMedia,
         array(
            'social_media_id' => $socialMedia->getId(),
         )
      );
   }

   function insertObject(&$socialMedia) {
      $this->update(
         'INSERT INTO social_media
            (press_id, code, include_in_catalog)
            VALUES
            (?, ?, ?)',
         array(
            (int) $socialMedia->getPressId(),
            $socialMedia->getCode(),
            $socialMedia->getIncludeInCatalog(),
         )
      );

      $socialMedia->setId($this->getInsertSocialMediaId());
      $this->updateLocaleFields($socialMedia);
      return $socialMedia->getId();
   }

   function updateObject($socialMedia) {
      $returner = $this->update(
         'UPDATE  social_media
         SET   press_id = ?,
            code = ?,
            include_in_catalog = ?
         WHERE social_media_id = ?',
         array(
            (int) $socialMedia->getPressId(),
            $socialMedia->getCode(),
            (int) $socialMedia->getIncludeInCatalog(),
            (int) $socialMedia->getId(),
         )
      );
      $this->updateLocaleFields($socialMedia);
      return $returner;
   }

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

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

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

      if ($this->getAffectedRows()) {
         return $this->update(
            'DELETE FROM social_media_settings WHERE social_media_id = ?',
            array((int) $socialMediaId)
         );
      }
   }

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

   function &getByPressId($pressId, $rangeInfo = null) {
      $params = array((int) $pressId);

      $result =& $this->retrieveRange(
         'SELECT *
         FROM social_media
         WHERE press_id = ?',
         $params,
         $rangeInfo
      );

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

   function &getEnabledForCatalogByPressId($pressId, $rangeInfo = null) {
      $params = array((int) $pressId);

      $result =& $this->retrieveRange(
         'SELECT *
         FROM social_media
         WHERE include_in_catalog = 1 AND press_id = ?',
         $params,
         $rangeInfo
      );

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

   function &getEnabledForPressByPressId($pressId, $rangeInfo = null) {
      $params = array((int) $pressId);

      $result =& $this->retrieveRange(
         'SELECT *
         FROM social_media
         WHERE include_in_catalog = 0 AND press_id = ?',
         $params,
         $rangeInfo
      );

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

   function getInsertSocialMediaId() {
      return $this->getInsertId('social_media', 'social_media_id');
   }
}
?>