} 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']++;