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