classes/scheduler/BuildingDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

import('scheduler.Building');

class BuildingDAO extends DAO {
   function &getBuilding($buildingId) {
      $result =& $this->retrieve(
         'SELECT * FROM buildings WHERE building_id = ?', $buildingId
      );

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

   function getBuildingSchedConfId($buildingId) {
      $result =& $this->retrieve(
         'SELECT sched_conf_id FROM buildings WHERE building_id = ?', $buildingId
      );

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

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

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

      return $returner;
   }

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

   function &_returnBuildingFromRow(&$row) {
      $building = new Building();
      $building->setId($row['building_id']);
      $building->setSchedConfId($row['sched_conf_id']);
      $this->getDataObjectSettings('building_settings', 'building_id', $row['building_id'], $building);

      return $building;
   }

   function updateLocaleFields(&$building) {
      $this->updateDataObjectSettings('building_settings', $building, array(
         'building_id' => $building->getId()
      ));
   }

   function insertBuilding(&$building) {
      $this->update(
         sprintf('INSERT INTO buildings
            (sched_conf_id)
            VALUES
            (?)'),
         array(
            $building->getSchedConfId()
         )
      );
      $building->setId($this->getInsertBuildingId());
      $this->updateLocaleFields($building);
      return $building->getId();
   }

   function updateBuilding(&$building) {
      $returner = $this->update(
         sprintf('UPDATE buildings
            SET
               sched_conf_id = ?
            WHERE building_id = ?'),
         array(
            $building->getSchedConfId(),
            $building->getId()
         )
      );
      $this->updateLocaleFields($building);
      return $returner;
   }

   function deleteBuilding($building) {
      return $this->deleteBuildingById($building->getId());
   }

   function deleteBuildingById($buildingId) {
      // Delete dependent rooms first.
      $roomDao =& DAORegistry::getDAO('RoomDAO');
      $rooms =& $roomDao->deleteRoomsByBuildingId($buildingId);

      $this->update('DELETE FROM building_settings WHERE building_id = ?', $buildingId);
      $ret = $this->update('DELETE FROM buildings WHERE building_id = ?', $buildingId);
      return $ret;
   }

   function deleteBuildingsBySchedConfId($schedConfId) {
      $buildings =& $this->getBuildingsBySchedConfId($schedConfId);
      while (($building =& $buildings->next())) {
         $this->deleteBuilding($building);
         unset($building);
      }
   }

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

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

   function getInsertBuildingId() {
      return $this->getInsertId('buildings', 'building_id');
   }
}

?>

---