/** @param $id The id of the node * @param $idType 'NODE_ID' or 'GATEWAY_ID'*/ protected function __construct($id, $idType = 'NODE_ID') { $db = AbstractDb::getObject(); $this->mDb =& $db; $id_str = $db->escapeString($id); switch ($idType) { case 'NODE_ID': $sqlWhere = "node_id='{$id_str}'"; break; case 'GATEWAY_ID': $sqlWhere = "gw_id='{$id_str}'"; break; default: throw new exception('Unknown idType parameter'); } $sqlWhere = $sql = "SELECT * FROM nodes WHERE {$sqlWhere}"; $row = null; $db->execSqlUniqueRes($sql, $row, false); if ($row == null) { throw new Exception(sprintf(_("The node with %s: %s could not be found in the database!"), $idType, $id_str)); } $this->_deploymentStatuses = array("DEPLOYED" => _("Deployed"), "IN_PLANNING" => _("In planning"), "IN_TESTING" => _("In testing"), "NON_WIFIDOG_NODE" => _("Non-Wifidog node"), "PERMANENTLY_CLOSED" => _("Permanently closed"), "TEMPORARILY_CLOSED" => _("Temporarily closed")); $this->_row = $row; $this->id = $row['node_id']; parent::__construct($this->id, 'Node'); }
/** * Constructor * * @param string $p_network_id * * @return void * * @access private */ protected function __construct($p_network_id) { $db = AbstractDb::getObject(); if ($p_network_id == "") { $p_network_id = self::getDefaultNetwork()->getId(); } $network_id_str = $db->escapeString($p_network_id); $sql = "SELECT *, EXTRACT(EPOCH FROM validation_grace_time) as validation_grace_time_seconds FROM networks WHERE network_id='{$network_id_str}'"; $row = null; $db->execSqlUniqueRes($sql, $row, false); if ($row == null) { throw new Exception("The network with id {$network_id_str} could not be found in the database"); } $this->_row = $row; $this->_id = $p_network_id; parent::__construct($this->_id, 'Network'); }
/** @param $id The id of the node group * @param $idType 'GROUP_ID' or 'NAME'*/ protected function __construct($id, $idType = 'GROUP_ID') { $db = AbstractDb::getObject(); $this->mDb =& $db; $id_str = $db->escapeString($id); switch ($idType) { case 'GROUP_ID': $sqlWhere = "node_group_id='{$id_str}'"; break; case 'NAME': $sqlWhere = "name='{$id_str}'"; break; default: throw new exception('Unknown idType parameter'); } $sqlWhere = $sql = "SELECT * FROM node_groups WHERE {$sqlWhere}"; $row = null; $db->execSqlUniqueRes($sql, $row, false); if ($row == null) { throw new Exception(sprintf(_("The node group with %s: %s could not be found in the database!"), $idType, $id_str)); } $this->_row = $row; $this->id = $row['node_group_id']; parent::__construct($this->id, 'NodeGroup'); }