public static function get_city_list_by_zip($zip)
{
$records = array();
$sql = "SELECT prime_zip, city_name FROM ref_city WHERE zip='{$zip}' ORDER BY city_name, zip";
$pre_data = db()->Get_Table($sql);
if (!empty($pre_data)) {
foreach ($pre_data as $pre_row) {
$prime_zip = $pre_row['prime_zip'];
$city_name = $pre_row['city_name'];
$sql = "SELECT city_id FROM ref_city WHERE zip='{$prime_zip}' AND city_name='{$city_name}'";
$data = db()->Get_Table($sql);
if (!empty($data)) {
foreach ($data as $row) {
$record = new City($row['city_id']);
$record->retrieve_record($row['city_id']);
$records[] = array('key' => $record->id(), 'value' => $record->city_name(), 'county_id' => $record->county_id(), 'state_id' => $record->state_id());
}
}
}
}
return $records;
}
public function getCityId()
{
return $this->city->id();
}
