classes/scheduler/RoomDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('scheduler.Room');

class RoomDAO extends DAO {
   function &getRoom($roomId) {
      $result =& $this->retrieve(
         'SELECT * FROM rooms WHERE room_id = ?', $roomId
      );

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

   function getRoomBuildingId($roomId) {
      $result =& $this->retrieve(
         'SELECT building_id FROM rooms WHERE room_id = ?', $roomId
      );

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

   function getRoomSchedConfId($roomId) {
      $result =& $this->retrieve(
         'SELECT b.sched_conf_id FROM rooms r LEFT JOIN buildings b ON (r.building_id = b.building_id) WHERE r.room_id = ?', $roomId
      );

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

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

   function &_returnRoomFromRow(&$row) {
      $room = new Room();
      $room->setId($row['room_id']);
      $room->setBuildingId($row['building_id']);
      $this->getDataObjectSettings('room_settings', 'room_id', $row['room_id'], $room);

      return $room;
   }

   function updateLocaleFields(&$room) {
      $this->updateDataObjectSettings('room_settings', $room, array(
         'room_id' => $room->getId()
      ));
   }

   function insertRoom(&$room) {
      $this->update(
         sprintf('INSERT INTO rooms
            (building_id)
            VALUES
            (?)'),
         array(
            $room->getBuildingId()
         )
      );
      $room->setId($this->getInsertRoomId());
      $this->updateLocaleFields($room);
      return $room->getId();
   }

   function updateRoom(&$room) {
      $returner = $this->update(
         sprintf('UPDATE rooms
            SET
               building_id = ?
            WHERE room_id = ?'),
         array(
            $room->getBuildingId(),
            $room->getId()
         )
      );
      $this->updateLocaleFields($room);
      return $returner;
   }

   function deleteRoom($room) {
      return $this->deleteRoomById($room->getId());
   }

   function deleteRoomById($roomId) {
      $this->update('DELETE FROM room_settings WHERE room_id = ?', $roomId);
      $ret = $this->update('DELETE FROM rooms WHERE room_id = ?', $roomId);
      return $ret;
   }

   function deleteRoomsByBuildingId($buildingId) {
      $rooms =& $this->getRoomsByBuildingId($buildingId);
      while (($room =& $rooms->next())) {
         $this->deleteRoom($room);
         unset($room);
      }
   }

   function &getRoomsByBuildingId($buildingId, $rangeInfo = null) {
      $result =& $this->retrieveRange(
         'SELECT * FROM rooms WHERE building_id = ? ORDER BY building_id',
         $buildingId,
         $rangeInfo
      );

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

   function getInsertRoomId() {
      return $this->getInsertId('rooms', 'room_id');
   }
}

?>

---