classes/scheduler/SpecialEventDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('scheduler.SpecialEvent');

class SpecialEventDAO extends DAO {
   function &getSpecialEvent($specialEventId) {
      $result =& $this->retrieve(
         'SELECT * FROM special_events WHERE special_event_id = ?', $specialEventId
      );

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

   function getSpecialEventSchedConfId($specialEventId) {
      $result =& $this->retrieve(
         'SELECT sched_conf_id FROM special_events WHERE special_event_id = ?', $specialEventId
      );

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

   function specialEventExistsForSchedConf($specialEventId, $schedConfId) {
      $result =& $this->retrieve(
         'SELECT  COUNT(*)
            FROM special_events
            WHERE special_event_id = ?
            AND   sched_conf_id = ?',
         array(
            $specialEventId,
            $schedConfId
         )
      );
      $returner = isset($result->fields[0]) && $result->fields[0] != 0 ? true : false;

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

      return $returner;
   }

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

   function &_returnSpecialEventFromRow(&$row) {
      $specialEvent = new SpecialEvent();
      $specialEvent->setId($row['special_event_id']);
      $specialEvent->setSchedConfId($row['sched_conf_id']);
      $specialEvent->setStartTime($this->datetimeFromDB($row['start_time']));
      $specialEvent->setEndTime($this->datetimeFromDB($row['end_time']));
      $this->getDataObjectSettings('special_event_settings', 'special_event_id', $row['special_event_id'], $specialEvent);

      return $specialEvent;
   }

   function updateLocaleFields(&$specialEvent) {
      $this->updateDataObjectSettings('special_event_settings', $specialEvent, array(
         'special_event_id' => $specialEvent->getId()
      ));
   }

   function insertSpecialEvent(&$specialEvent) {
      $this->update(
         sprintf('INSERT INTO special_events
            (sched_conf_id, start_time, end_time)
            VALUES
            (?, %s, %s)',
            $this->datetimeToDB($specialEvent->getStartTime()), $this->datetimeToDB($specialEvent->getEndTime())
         ), array(
            (int) $specialEvent->getSchedConfId()
         )
      );
      $specialEvent->setId($this->getInsertSpecialEventId());
      $this->updateLocaleFields($specialEvent);
      return $specialEvent->getId();
   }

   function updateSpecialEvent(&$specialEvent) {
      $returner = $this->update(
         sprintf('UPDATE   special_events
            SET   sched_conf_id = ?,
               start_time = %s,
               end_time = %s
            WHERE special_event_id = ?',
            $this->datetimeToDB($specialEvent->getStartTime()), $this->datetimeToDB($specialEvent->getEndTime())
         ), array(
            (int) $specialEvent->getSchedConfId(),
            (int) $specialEvent->getId()
         )
      );
      $this->updateLocaleFields($specialEvent);
      return $returner;
   }

   function deleteSpecialEvent($specialEvent) {
      return $this->deleteSpecialEventById($specialEvent->getId());
   }

   function deleteSpecialEventById($specialEventId) {
      $this->update('DELETE FROM special_event_settings WHERE special_event_id = ?', $specialEventId);
      $ret = $this->update('DELETE FROM special_events WHERE special_event_id = ?', $specialEventId);
      return $ret;
   }

   function deleteSpecialEventsBySchedConfId($schedConfId) {
      $specialEvents =& $this->getSpecialEventsBySchedConfId($schedConfId);
      while (($specialEvent =& $specialEvents->next())) {
         $this->deleteSpecialEvent($specialEvent);
         unset($specialEvent);
      }
   }

   function &getSpecialEventsBySchedConfId($schedConfId, $rangeInfo = null) {
      $result =& $this->retrieveRange('SELECT * FROM special_events WHERE sched_conf_id = ? ORDER BY start_time, end_time', $schedConfId, $rangeInfo);
      $returner = new DAOResultFactory($result, $this, '_returnSpecialEventFromRow');
      return $returner;
   }

   function getInsertSpecialEventId() {
      return $this->getInsertId('special_events', 'special_event_id');
   }
}

?>

---