classes/scheduler/TimeBlockDAO.inc.php

Go to the documentation of this file.

<?php

import('scheduler.TimeBlock');

class TimeBlockDAO extends DAO {
   function &getTimeBlock($timeBlockId) {
      $result =& $this->retrieve(
         'SELECT * FROM time_blocks WHERE time_block_id = ?', $timeBlockId
      );

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

   function getTimeBlockSchedConfId($timeBlockId) {
      $result =& $this->retrieve(
         'SELECT sched_conf_id FROM time_blocks WHERE time_block_id = ?', $timeBlockId
      );

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

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

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

      return $returner;
   }

   function timeBlocksExistForSchedConf($schedConfId) {
      $result =& $this->retrieve(
         'SELECT  COUNT(*)
         FROM  time_blocks
         WHERE sched_conf_id = ?',
         array($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 &_returnTimeBlockFromRow(&$row) {
      $timeBlock = new TimeBlock();
      $timeBlock->setId($row['time_block_id']);
      $timeBlock->setSchedConfId($row['sched_conf_id']);
      $timeBlock->setStartTime($this->datetimeFromDB($row['start_time']));
      $timeBlock->setEndTime($this->datetimeFromDB($row['end_time']));
      $timeBlock->setAssignedColour($row['assigned_colour']);
      $timeBlock->setUnassignedColour($row['unassigned_colour']);
      $this->getDataObjectSettings('time_block_settings', 'time_block_id', $row['time_block_id'], $timeBlock);
      return $timeBlock;
   }

   function updateLocaleFields(&$timeBlock) {
      $this->updateDataObjectSettings('time_block_settings', $timeBlock, array(
         'time_block_id' => $timeBlock->getId()
      ));
   }

   function insertTimeBlock(&$timeBlock) {
      $this->update(
         sprintf('INSERT INTO time_blocks (
               sched_conf_id,
               start_time,
               end_time, assigned_colour,
               unassigned_colour
            ) VALUES (?, %s, %s, ?, ?)',
            $this->datetimeToDB($timeBlock->getStartTime()),
            $this->datetimeToDB($timeBlock->getEndTime())
         ), array(
            $timeBlock->getSchedConfId(),
            $timeBlock->getAssignedColour(),
            $timeBlock->getUnassignedColour()
         )
      );
      $timeBlock->setId($this->getInsertTimeBlockId());
      $this->updateLocaleFields($timeBlock);
      return $timeBlock->getId();
   }

   function updateTimeBlock(&$timeBlock) {
      $returner = $this->update(
         sprintf('UPDATE   time_blocks
            SET   sched_conf_id = ?,
               start_time = %s,
               end_time = %s,
               assigned_colour = ?,
               unassigned_colour = ?
            WHERE time_block_id = ?',
            $this->datetimeToDB($timeBlock->getStartTime()),
            $this->datetimeToDB($timeBlock->getEndTime())
         ), array(
            $timeBlock->getSchedConfId(),
            $timeBlock->getAssignedColour(),
            $timeBlock->getUnassignedColour(),
            $timeBlock->getId()
         )
      );
      $this->updateLocaleFields($timeBlock);
      return $returner;
   }

   function deleteTimeBlock($timeBlock) {
      return $this->deleteTimeBlockById($timeBlock->getId());
   }

   function deleteTimeBlockById($timeBlockId) {
      $this->update('DELETE FROM time_block_settings WHERE time_block_id = ?', $timeBlockId);
      $this->update('DELETE FROM time_block_settings WHERE time_block_id = ?', $timeBlockId);
      return $this->update('DELETE FROM time_blocks WHERE time_block_id = ?', $timeBlockId);
   }

   function deleteTimeBlocksBySchedConfId($schedConfId) {
      $timeBlocks =& $this->getTimeBlocksBySchedConfId($schedConfId);
      while (($timeBlock =& $timeBlocks->next())) {
         $this->deleteTimeBlock($timeBlock);
         unset($timeBlock);
      }
   }

   function &getTimeBlocksBySchedConfId($schedConfId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM time_blocks WHERE sched_conf_id = ? ORDER BY start_time',
         $schedConfId,
         $rangeInfo
      );

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

   function getInsertTimeBlockId() {
      return $this->getInsertId('time_blocks', 'time_block_id');
   }
}

?>

---