Changeset 405 for trunk/wifidog-auth/wifidog/classes/Node.php

Timestamp:

01/27/05 11:00:52 (8 years ago)

Author:

aprilp

Message:

*** empty log message ***

Files:

• trunk/wifidog-auth/wifidog/classes/Node.php (modified) (5 diffs)

trunk/wifidog-auth/wifidog/classes/Node.php

@@ -34 +34 @@
    * @return a Node object, or null if there was an error
    */
-  static function getObject($id) {
+  static function getNode($id) {
       $object = null;
       $object = new self($id);
@@ -44 +44 @@
    * @return the newly created Node object, or null if there was an error
    */
-  static function createObject($id) {
+  static function createNode($id) {
       global $db;
 
@@ -62 +62 @@
     $db->ExecSqlUniqueRes($sql, $row, false);
     if ($row == null) {
-            throw new Exception(_("The id $node_id_str could not be found in the database"), "EXCEPTION_CREATE_OBJECT_FAILED");
+            throw new Exception(_("The id $node_id_str could not be found in the database"));
     }
     $this->mRow = $row;  
@@ -96 +96 @@
 
     $db->ExecSql("SELECT * FROM nodes", $nodes, false);
+
     if ($nodes == null) {
-        throw new Exception(_("No nodes could not be found in the database"), "EXCEPTION_NO_NODES");
+        throw new Exception(_("No nodes could not be found in the database"));
+    }
+    return $nodes;
+  }
+
+  static function getAllNodesOrdered($order_by) {
+    global $db;
+
+    $db->ExecSql("SELECT * FROM nodes ORDER BY $order_by", $nodes, false);
+
+    if ($nodes == null) {
+        throw new Exception(_("No nodes could not be found in the database"));
+    }
+    return $nodes;
+  }
+
+  static function getAllNodesWithStatus() {
+    global $db;
+    $db->ExecSql("SELECT node_id, name, last_heartbeat_user_agent, (NOW()-last_heartbeat_timestamp) AS since_last_heartbeat, last_heartbeat_ip, CASE WHEN ((NOW()-last_heartbeat_timestamp) < interval '5 minutes') THEN true ELSE false END AS online, creation_date FROM nodes ORDER BY node_id", $nodes, false);
+    if ($nodes == null) {
+        throw new Exception(_("No nodes could not be found in the database"));
     }
     return $nodes;
@@ -107 +128 @@
     $db->ExecSql("SELECT * FROM node_deployment_status", $statuses, false);
     if ($statuses == null) {
-        throw new Exception(_("No deployment statues  could be found in the database"), "EXCEPTION_NO_STATUSES");
+        throw new Exception(_("No deployment statues  could be found in the database"));
     }
     $statuses_array = array();