public static function getZoneFormData($id = null, $edit = false)
{
global $lC_Database;
$result = array();
$result['zData'] = array();
if (isset($id) && $id != null) {
if ($edit === true) {
$result['zData'] = lC_Countries_Admin::getZone($id);
} else {
$Qcheck = $lC_Database->query('select count(*) as total from :table_address_book where entry_zone_id = :entry_zone_id');
$Qcheck->bindTable(':table_address_book', TABLE_ADDRESS_BOOK);
$Qcheck->bindInt(':entry_zone_id', $id);
$Qcheck->execute();
if ($Qcheck->valueInt('total') > 0) {
$result['rpcStatus'] = -2;
$result['totalAddressBookEntries'] = $Qcheck->valueInt('total');
}
$Qcheck = $lC_Database->query('select count(*) as total from :table_zones_to_geo_zones where zone_id = :zone_id');
$Qcheck->bindTable(':table_zones_to_geo_zones', TABLE_ZONES_TO_GEO_ZONES);
$Qcheck->bindInt(':zone_id', $id);
$Qcheck->execute();
if ($Qcheck->valueInt('total') > 0) {
$result['rpcStatus'] = -3;
$result['totalZones'] = $Qcheck->valueInt('total');
}
}
}
return $result;
}
