function Search($indexedbyid = false, $loose = false) { global $dbh; // Store any values that have been added before we make them safe foreach ($this as $prop => $val) { if (isset($val)) { $o[$prop] = $val; } } // Make everything safe for us to search with $this->MakeSafe(); // This will store all our extended sql $sqlextend = ""; foreach ($o as $prop => $val) { extendsql($prop, $this->{$prop}, $sqlextend, $loose); } $sql = "SELECT * FROM fac_Ports {$sqlextend} ORDER BY DeviceID, PortNumber ASC;"; $portList = array(); foreach ($dbh->query($sql) as $portRow) { if ($indexedbyid) { $portList[$portRow["DeviceID"] . $portRow["PortNumber"]] = DevicePorts::RowToObject($portRow); } else { $portList[] = DevicePorts::RowToObject($portRow); } } return $portList; }
function Search($indexedbyid = false, $loose = false) { // Store the value of devicetype before we muck with it $os = $this->NumberScheme; // Make everything safe for us to search with $this->MakeSafe(); // This will store all our extended sql $sqlextend = ""; foreach ($this as $prop => $val) { // We force NumberScheme to a known value so this is to check if they wanted to search for the default if ($prop == "NumberScheme" && $val == "Sequential" && $os != "Sequential") { continue; } if ($val) { extendsql($prop, $val, $sqlextend, $loose); } } $sql = "SELECT * FROM fac_PowerPanel {$sqlextend} ORDER BY PanelLabel ASC;"; $panelList = array(); foreach ($this->query($sql) as $row) { if ($indexedbyid) { $panelList[$deviceRow["DeviceID"]] = PowerPanel::RowToObject($row); } else { $panelList[] = PowerPanel::RowToObject($row); } } return $panelList; }
function Search($num_rec_per_page = 0, $page = 1) { $this->MakeSafe(); // This will store all our extended sql $sqlextend = ""; foreach ($this as $prop => $val) { if ($val && $val != date("Y-m-d", strtotime(0))) { extendsql($prop, $val, $sqlextend, true); } } $sqlextend .= " ORDER BY Time DESC"; // Make sure someone didn't do something crazy with the input $page = intval($page); $num_rec_per_page = intval($num_rec_per_page); if ($page && $num_rec_per_page) { $start_from = ($page - 1) * $num_rec_per_page; $sqlextend .= " LIMIT {$start_from}, {$num_rec_per_page}"; } $sql = "SELECT * FROM fac_GenericLog{$sqlextend};"; $events = array(); foreach ($this->query($sql) as $dbRow) { $events[] = LogActions::RowToObject($dbRow); } return $events; }
function Search($indexedbyid = false, $loose = false) { $o = array(); // Store any values that have been added before we make them safe foreach ($this as $prop => $val) { if (isset($val)) { $o[$prop] = $val; } } // Make everything safe for us to search with $this->MakeSafe(); // This will store all our extended sql $sqlextend = ""; foreach ($o as $prop => $val) { extendsql($prop, $this->{$prop}, $sqlextend, $loose); } $sql = "SELECT * FROM fac_People {$sqlextend} ORDER BY LastName ASC, FirstName ASC;"; $peopleList = array(); foreach ($this->query($sql) as $peopleRow) { if ($indexedbyid) { $peopleList[$peopleRow["PersonID"]] = People::RowToObject($peopleRow); } else { $peopleList[] = People::RowToObject($peopleRow); } } return $peopleList; }
function Search($indexedbyid = false, $loose = false) { $o = new stdClass(); // Store any values that have been added before we make them safe foreach ($this as $prop => $val) { if (isset($val)) { $o->{$prop} = $val; } } // Make everything safe for us to search with $this->MakeSafe(); // This will store all our extended sql $sqlextend = ""; foreach ($o as $prop => $val) { extendsql($prop, $this->{$prop}, $sqlextend, $loose); } // The join is purely to sort the templates by the manufacturer's name $sql = "SELECT * FROM fac_CabRow {$sqlextend} ORDER BY Name ASC;"; $rowList = array(); foreach ($this->query($sql) as $row) { if ($indexedbyid) { $rowList[$row["CabRowID"]] = CabRow::RowToObject($row); } else { $rowList[] = CabRow::RowToObject($row); } } return $rowList; }