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);
}
$sql = "SELECT * FROM fac_Zone {$sqlextend} ORDER BY Description ASC;";
$zoneList = array();
foreach ($this->query($sql) as $zoneRow) {
if ($indexedbyid) {
$zoneList[$zoneRow["ZoneID"]] = Zone::RowToObject($zoneRow);
} else {
$zoneList[] = Zone::RowToObject($zoneRow);
}
}
return $zoneList;
}
static function GetZoneList($indexedbyid = false)
{
global $dbh;
$sql = "SELECT * FROM fac_Zone ORDER BY Description ASC;";
$zoneList = array();
foreach ($dbh->query($sql) as $row) {
if ($indexedbyid) {
$zoneList[$row['ZoneID']] = Zone::RowToObject($row);
} else {
$zoneList[] = Zone::RowToObject($row);
}
}
return $zoneList;
}
