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(); }