/**
* Add Tax Rule
*/
function addTaxRule()
{
if ($this->post['allstates'] == "true") {
$this->post['state'] = null;
} else {
if (!isset($this->post['state'])) {
// A specific state was not provided
throw new FieldMissingException("state");
}
}
// Create a new Tax Rule DBO
$taxrule_dbo = new TaxRuleDBO();
$taxrule_dbo->setCountry($this->post['country']);
$taxrule_dbo->setState($this->post['state']);
$taxrule_dbo->setRate($this->post['rate']);
$taxrule_dbo->setAllStates($this->post['allstates'] == "true" ? "Yes" : "Specific");
$taxrule_dbo->setDescription($this->post['description']);
// Insert Tax Rule into database
add_TaxRuleDBO($taxrule_dbo);
// Success
$this->setMessage(array("type" => "[TAX_RULE_CREATED]"));
$this->post['success'] = "true";
}
/**
* Load multiple TaxRuleDBO's from database
*
* @param string $filter A WHERE clause
* @param string $sortby Field name to sort results by
* @param string $sortdir Direction to sort in (ASEC or DESC)
* @param int $limit Limit the number of results
* @param int $start Record number to start the results at
* @return array Array of TaxRuleDBO's
*/
function &load_array_TaxRuleDBO($filter = null, $sortby = null, $sortdir = null, $limit = null, $start = null)
{
$DB = DBConnection::getDBConnection();
// Build query
$sql = $DB->build_select_sql("taxrule", "*", $filter, $sortby, $sortdir, $limit, $start);
// Run query
if (!($result = @mysql_query($sql, $DB->handle()))) {
// Query error
throw new DBException(mysql_error($DB->handle()));
}
if (mysql_num_rows($result) == 0) {
// No services found
throw new DBNoRowsFoundException();
}
// Build an array of DBOs from the result set
$dbo_array = array();
while ($data = mysql_fetch_array($result)) {
// Create and initialize a new DBO with the data from the DB
$dbo = new TaxRuleDBO();
$dbo->load($data);
// Add TaxRuleDBO to array
$dbo_array[] = $dbo;
}
return $dbo_array;
}
