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;
}
