function initQuery($params)
{
$tables = TaxRateByZip::getTables();
$c = $tables["tax_zip_sets"]["columns"];
$this->addSelectField($c['id'], 'id');
$this->WhereValue($c['isActive'], DB_EQ, 0);
$this->WhereAND();
$this->Where("UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP({$c['dt']})", DB_GT, 3600);
}
/**
* adds rates to DB from an array
*
* @param array $data
*/
function addRatesArrayToDB($data, $sid)
{
global $application;
if (empty($data)) {
return;
}
loadCoreFile('db_multiple_insert.php');
$tables = TaxRateByZip::getTables();
$table = "tax_zip_rates";
$columns = $tables[$table]['columns'];
$fields = array($columns["sid"], $columns['zip5'], $columns['zip5low'], $columns['zip5high'], $columns['zip5mask'], $columns['zip4low'], $columns['zip4high'], $columns['rate']);
$query = new DB_Multiple_Insert($table);
$query->setInsertFields($fields);
foreach ($data as $key => $value) {
$params = array($columns["sid"] => $sid, $columns['zip5'] => $value["ZipCode"], $columns['zip5low'] => $value["Zip5Low"], $columns['zip5high'] => $value["Zip5High"], $columns['zip5mask'] => $value["Zip5Mask"], $columns['zip4low'] => $value["Zip4Low"], $columns['zip4high'] => $value["Zip4High"], $columns['rate'] => $value["SalesTaxRatePercent"]);
$query->addInsertValuesArray($params);
}
$application->db->PrepareSQL($query);
$application->db->DB_Exec();
}
