} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'City ID was not valid..', 'data' => array());
}
$app->response->setStatus($ret['code']);
echo json_encode($ret);
});
$app->get('/address-attributes-city-id/V0/:id/', function ($id) use($app) {
list($city_id, $x) = explode("?", $id);
$in_city = strtoupper($app->request()->params('city'));
$in_state = strtoupper($app->request()->params('state'));
$city_id = intval($city_id);
if ($city_id) {
if (city_state_valid($in_city, $in_state)) {
if ($dbh = connect_to_address_database()) {
$address_keys = new \Code4KC\Address\AddressKeys($dbh, true);
if ($exisiting_address_alias_rec = $address_keys->find_by_city_address_id($city_id)) {
$address_id = $exisiting_address_alias_rec['address_id'];
$ret = get_address_attributes($dbh, $address_id);
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'Address not found', 'data' => array());
}
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'State or City was not valid.', 'data' => array());
}
} else {
$ret = array('code' => 500, 'status' => 'failed', 'message' => 'Unable to connect to database.', 'data' => array());
}
} else {
$ret = array('code' => 404, 'status' => 'error', 'message' => 'City ID was not valid..', 'data' => array());
}
$app->response->setStatus($ret['code']);
$num = count($data);
$row++;
print "{$row}\n";
if ($row == 1) {
} else {
$rec = array();
for ($c = 0; $c < $num; $c++) {
$rec[$names[$c]] = $data[$c];
}
$city_address_id = $rec['id'];
if (empty($city_address_id)) {
print "EROOR: empty city id on line {$row}\n";
$totals['input']['error']++;
continue;
}
if ($address_keys_rec = $address_keys->find_by_city_address_id($city_address_id)) {
$address_id = $address_keys_rec['address_id'];
if ($address_rec = $address->find_by_id($address_id)) {
$new_rec = array('id' => $address_id, 'longitude' => $rec['longitude'], 'latitude' => $rec['latitude']);
if ($address_differences = $address->diff($address_rec, $new_rec)) {
$address->update($address_id, $address_differences);
$totals['address']['update']++;
} else {
$totals['address']['N/A']++;
}
$new_rec = array('id' => $city_address_id, 'land_use_code' => $rec['land_use_code'], 'classification' => $rec['classification'], 'land_use' => $rec['land_use'], 'sub_class' => $rec['sub_class']);
if ($city_address_attributes_rec = $city_address_attributes->find_by_id($city_address_id)) {
$city_address_attributes_id = $city_address_attributes_rec['id'];
if ($city_address_attribute_differences = $city_address_attributes->diff($city_address_attributes_rec, $new_rec)) {
$city_address_attributes->update($city_address_attributes_id, $city_address_attribute_differences);
$totals['city_address_attributes']['update']++;
