private function handleZipCodeImport()
{
ini_set('memory_limit', '1024M');
if (class_exists("ZipCode")) {
$zip_code = new ZipCode();
}
if (isset($zip_code) && $zip_code instanceof ZipCode) {
echo '<pre>ZIPCODE IMPORT DEBUG:<br/>';
try {
$zip_code->setDataDir(dirname(__FILE__));
$zip_code->setMaxRecordsToParse(0)->parseZipCodeData();
$zip_code_records = $zip_code->getRecords();
} catch (Exception $e) {
echo 'Caught exception: ' . $e->getMessage() . PHP_EOL;
}
if (!empty($zip_code_records) && is_array($zip_code_records)) {
$table_name = $this->_spq_scm_zipcodes_table;
foreach ($zip_code_records as $zip_code_record) {
$insert = "INSERT INTO {$table_name} " . "(fips_code, zip, city, state, longitude, latitude, population, allocation_factor)" . " VALUES (" . sprintf("%s,", $this->_wpdb->escape($zip_code_record['fips_code'])) . sprintf("%s,", $this->_wpdb->escape($zip_code_record['zip'])) . sprintf("'%s',", $this->_wpdb->escape($zip_code_record['city'])) . sprintf("'%s',", $this->_wpdb->escape($zip_code_record['state'])) . sprintf("%s,", $this->_wpdb->escape($zip_code_record['longitude'])) . sprintf("%s,", $this->_wpdb->escape($zip_code_record['latitude'])) . sprintf("%s,", $this->_wpdb->escape($zip_code_record['population'])) . sprintf("%s", trim($this->_wpdb->escape($zip_code_record['allocation_factor']))) . ')';
$results = $this->_wpdb->query($insert);
}
}
echo '</pre>';
}
}
