X-Git-Url: https://git.rohieb.name/iserv-mod-room-reservation.git/blobdiff_plain/5760b2a8d146d7c186daab1743c84683d0d84cea..e060799a1075f80197002c851d56fb9606bcb7c4:/includes/mod_roomReservationRoomsManager.inc?ds=sidebyside

diff --git a/includes/mod_roomReservationRoomsManager.inc b/includes/mod_roomReservationRoomsManager.inc
old mode 100755
new mode 100644
index 8271a04..edce221
--- a/includes/mod_roomReservationRoomsManager.inc
+++ b/includes/mod_roomReservationRoomsManager.inc
@@ -113,11 +113,45 @@ 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
    */
-  function getRooms() {
+  static function getRooms() {
     $aoReturn = array();
     $hQuery = db_query("SELECT * FROM rooms ORDER BY name;");
     while($arResult = pg_fetch_array($hQuery)) {