classes/announcement/AnnouncementTypeDAO.inc.php

<?php

// $Id: AnnouncementTypeDAO.inc.php,v 1.8 2008/07/01 01:16:09 asmecher Exp $


import('announcement.AnnouncementType');

class AnnouncementTypeDAO extends DAO {
   function &getAnnouncementType($typeId) {
      $result = &$this->retrieve(
         'SELECT * FROM announcement_types WHERE type_id = ?', $typeId
      );

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

   function getAnnouncementTypeJournalId($typeId) {
      $result = &$this->retrieve(
         'SELECT journal_id FROM announcement_types WHERE type_id = ?', $typeId
      );

      return isset($result->fields[0]) ? $result->fields[0] : 0;  
   }

   function getAnnouncementTypeName($typeId) {
      $result = &$this->retrieve(
         'SELECT COALESCE(l.setting_value, p.setting_value) FROM announcement_type_settings l LEFT JOIN announcement_type_settings p ON (p.type_id = ? AND p.setting_name = ? AND p.locale = ?) WHERE l.type_id = ? AND l.setting_name = ? AND l.locale = ?', 
         array(
            $typeId, 'name', Locale::getLocale(),
            $typeId, 'name', Locale::getPrimaryLocale()
         )
      );

      $returner = isset($result->fields[0]) ? $result->fields[0] : false;

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

      return $returner;
   }


   function announcementTypeExistsByTypeId($typeId, $journalId) {
      $result = &$this->retrieve(
         'SELECT COUNT(*)
            FROM announcement_types
            WHERE type_id = ?
            AND   journal_id = ?',
         array(
            $typeId,
            $journalId
         )
      );
      $returner = isset($result->fields[0]) && $result->fields[0] != 0 ? true : false;

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

      return $returner;
   }

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

   function &_returnAnnouncementTypeFromRow(&$row) {
      $announcementType = &new AnnouncementType();
      $announcementType->setTypeId($row['type_id']);
      $announcementType->setJournalId($row['journal_id']);
      $this->getDataObjectSettings('announcement_type_settings', 'type_id', $row['type_id'], $announcementType);

      return $announcementType;
   }

   function updateLocaleFields(&$announcementType) {
      $this->updateDataObjectSettings('announcement_type_settings', $announcementType, array(
         'type_id' => $announcementType->getTypeId()
      ));
   }

   function insertAnnouncementType(&$announcementType) {
      $this->update(
         sprintf('INSERT INTO announcement_types
            (journal_id)
            VALUES
            (?)'),
         array(
            $announcementType->getJournalId()
         )
      );
      $announcementType->setTypeId($this->getInsertTypeId());
      $this->updateLocaleFields($announcementType);
      return $announcementType->getTypeId();
   }

   function updateAnnouncementType(&$announcementType) {
      $returner = $this->update(
         sprintf('UPDATE announcement_types
            SET
               journal_id = ?
            WHERE type_id = ?'),
         array(
            $announcementType->getJournalId(),
            $announcementType->getTypeId()
         )
      );
      $this->updateLocaleFields($announcementType);
      return $returner;
   }

   function deleteAnnouncementType($announcementType) {
      return $this->deleteAnnouncementTypeById($announcementType->getTypeId());
   }

   function deleteAnnouncementTypeById($typeId) {
      $this->update('DELETE FROM announcement_type_settings WHERE type_id = ?', $typeId);
      $ret = $this->update('DELETE FROM announcement_types WHERE type_id = ?', $typeId);

      // Delete all announcements with this announcement type
      if ($ret) {
         $announcementDao = &DAORegistry::getDAO('AnnouncementDAO');
         return $announcementDao->deleteAnnouncementByTypeId($typeId);
      } else {
         return $ret;
      }
   }

   function deleteAnnouncementTypesByJournal($journalId) {
      $types =& $this->getAnnouncementTypesByJournalId($journalId);
      while (($type =& $types->next())) {
         $this->deleteAnnouncementType($type);
         unset($type);
      }
   }

   function &getAnnouncementTypesByJournalId($journalId, $rangeInfo = null) {
      $result = &$this->retrieveRange(
         'SELECT * FROM announcement_types WHERE journal_id = ? ORDER BY type_id', $journalId, $rangeInfo
      );

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

   function getInsertTypeId() {
      return $this->getInsertId('announcement_types', 'type_id');
   }
}

?>

---