From: rohieb <devnull@localhost>
Date: Sat, 26 Jul 2008 00:13:35 +0000 (+0200)
Subject: mod_roomReservationRoomsManager: added getRoomByName() and getRoomByOid()
X-Git-Tag: REL_3.0^2~4
X-Git-Url: http://git.rohieb.name/iserv-mod-room-reservation.git/commitdiff_plain/70c3ce9b9fcbd9a88443989f08694c16870ddf4e

mod_roomReservationRoomsManager: added getRoomByName() and getRoomByOid()
---

diff --git a/includes/mod_roomReservationRoomsManager.inc b/includes/mod_roomReservationRoomsManager.inc
old mode 100755
new mode 100644
index 732b3dc..edce221
--- a/includes/mod_roomReservationRoomsManager.inc
+++ b/includes/mod_roomReservationRoomsManager.inc
@@ -113,6 +113,40 @@ class mod_roomReservationRoomsManager {
   }
 */
 
+  /**
+   * Get a room by its OID. Returns <tt>null</tt> 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 <tt>null</tt> 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