oCfg = $oCfg;
}
/**
* Get a room by its OID. Returns null if the room was not found.
* @param $nOid (integer) The OID of the room
* @return mod_roomReservationRoom
*/
static function getRoomByOid($nOid) {
$o = null;
$h = db_query("SELECT * FROM rooms WHERE oid = $1;", $nOid);
if(pg_num_rows($h) > 0) {
$arResult = pg_fetch_array($h);
$o = new mod_roomReservationRoom($arResult["name"],
$arResult["room_no"], $arResult["floor"], $arResult["building"],
$arResult["location"]);
}
return $o;
}
/**
* Get a room by its name. Returns null if the room was not found.
* @param $sName (string) The name of the room
* @return mod_roomReservationRoom
*/
static function getRoomByName($sName) {
$o = null;
$h = db_query("SELECT * FROM rooms WHERE name = $1;", $sName);
if(pg_num_rows($h) > 0) {
$arResult = pg_fetch_array($h);
$o = new mod_roomReservationRoom($arResult["name"],
$arResult["room_no"], $arResult["floor"], $arResult["building"],
$arResult["location"]);
}
return $o;
}
/**
* Get all rooms from the database
* @return array of mod_roomReservationRoom
*/
static function getRooms() {
$aoReturn = array();
$hQuery = db_query("SELECT * FROM rooms ORDER BY name;");
while($arResult = pg_fetch_array($hQuery)) {
$aoReturn[] = new mod_roomReservationRoom($arResult["name"],
$arResult["room_no"], $arResult["floor"], $arResult["building"],
$arResult["location"]);
}
return $aoReturn;
}
}
?>