public static function getAllZones()
{
$zones = array();
$db = Zend_Registry::get('my_db2');
$adminLevel = $_SESSION['ADMIN_LEVEL'];
$adminId = $_SESSION['ADMIN_ID'];
$z = new Zones($db);
if ($adminLevel == Utility::$SUPER_ADMIN) {
$select = $z->select()->order('zone_desc ASC');
$rows = $z->fetchAll($select);
} else {
$select = $z->select()->where('admin_id = ' . $adminId)->order('zone_desc ASC');
}
$rows = $z->fetchAll($select);
foreach ($rows as $row) {
switch (DB_TYPE) {
case 'mysql':
$zone = new Zone($row->zone_id, false);
break;
case 'oci8':
$zone = new Zone($row->ZONE_ID, false);
break;
}
array_push($zones, $zone);
}
return $zones;
}
public static function getZoneId($zoneName)
{
$db = Zend_Registry::get('my_db');
$z = new Zones($db);
$cleanZoneName = $db->quote($zoneName);
$result = $z->fetchAll("upper(source_id) = upper({$cleanZoneName})");
switch (DB_TYPE) {
case 'mysql':
$_SESSION['ZONE_ID'] = intval($result[0]->zone_id);
$_SESSION['ZONE_DESC'] = $result[0]->zone_desc;
$_SESSION['ZONE_VERSION_ID'] = $result[0]->version_id;
$_SESSION['ZONE_SLEEPING'] = $result[0]->sleeping;
$_SESSION['ZONE_AUTH_TYPE'] = $result[0]->zone_authentication_type_id;
break;
case 'oci8':
$_SESSION['ZONE_ID'] = intval($result[0]->ZONE_ID);
$_SESSION['ZONE_DESC'] = $result[0]->ZONE_DESC;
$_SESSION['ZONE_VERSION_ID'] = $result[0]->VERSION_ID;
$_SESSION['ZONE_SLEEPING'] = $result[0]->SLEEPING;
$_SESSION['ZONE_AUTH_TYPE'] = $result[0]->ZONE_AUTHENTICATION_TYPE_ID;
break;
}
}
