continue;
}
$single_line_address = $address_converter->AddressLineStandardization($rec['address']);
$single_line_address .= ', KANSAS CITY, MO';
// We keep unit 'internal'
$normalized_address = $census->normalize_address($single_line_address);
// Strips off unit 'internal'
$address_in = array_merge(array('single_line_address' => $single_line_address), $normalized_address, $rec);
$city_address_id = $rec['kivapin'];
$county_address_id = $rec['apn'];
// We need to start out with an alias and address records
$address_id = 0;
if ($exisiting_address_alias_rec = $address_alias->find_by_single_line_address($single_line_address)) {
$totals['address_alias']['N/A']++;
$address_id = $exisiting_address_alias_rec['address_id'];
if ($exisiting_address_rec = $address->find_by_id($address_id)) {
if ($address_differences = $address->diff($exisiting_address_rec, $rec)) {
$address->update($address_id, $address_differences);
$totals['address']['update']++;
} else {
$totals['address']['N/A']++;
}
} else {
$address->add($rec);
$totals['address']['insert']++;
}
} else {
if ($exisiting_address_rec = $address->find_by_single_line_address($single_line_address)) {
// Just in case we had a failuer to clean up
$address_id = $exisiting_address_rec['id'];
$totals['address']['N/A']++;
/**
* @param $dbh
* @param $address_id
* @return array
*/
function get_address_attributes(&$dbh, $address_id)
{
$address = new \Code4KC\Address\Address($dbh, true);
if ($address_rec = $address->find_by_id($address_id)) {
if ($attributes = $address->get_attributes($address_id)) {
$data = array_merge($address_rec, $attributes);
$ret = array('code' => 200, 'status' => 'success', 'message' => '', 'data' => $data);
} else {
$data = $address_rec;
$ret = array('code' => 200, 'status' => 'success', 'message' => 'Unable to provide address attributes', 'data' => $data);
}
} else {
$data = $address_rec;
$ret = array('code' => 402, 'status' => 'error', 'message' => 'Internal error, address alias found, but address record is missing', 'data' => $data);
}
return $ret;
}
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']++;
} else {
$totals['city_address_attributes']['N/A']++;
