function cnDeleteCountry($countryID) { $tax_classes = taxGetTaxClasses(); foreach ($tax_classes as $class) { taxDeleteRate($class["classID"], $countryID); } db_query("update " . CUSTOMER_ADDRESSES_TABLE . " set countryID=NULL where countryID=" . (int) $countryID); $q = db_query("select zoneID from " . ZONES_TABLE . " where countryID=" . (int) $countryID); while ($r = db_fetch_row($q)) { db_query("update " . CUSTOMER_ADDRESSES_TABLE . " set zoneID=NULL where zoneID=" . (int) $r["zoneID"]); } db_query("delete from " . ZONES_TABLE . " where countryID=" . (int) $countryID); db_query("delete from " . COUNTRIES_TABLE . " where countryID=" . (int) $countryID); }
function settingCONF_CALCULATE_TAX_ON_SHIPPING() { if (isset($_POST["save"])) { _setSettingOptionValue("CONF_CALCULATE_TAX_ON_SHIPPING", $_POST["settingCONF_CALCULATE_TAX_ON_SHIPPING"]); } $res = "<select name='settingCONF_CALCULATE_TAX_ON_SHIPPING'>"; $res .= " <option value='0'>" . ADMIN_NOT_DEFINED . "</option>"; $selectedID = _getSettingOptionValue("CONF_CALCULATE_TAX_ON_SHIPPING"); $count_row = 0; $taxClasses = taxGetTaxClasses(); foreach ($taxClasses as $taxClass) { $res .= "<option value='" . $taxClass["classID"] . "'"; if ($selectedID == $taxClass["classID"]) { $res .= " selected "; } $res .= ">"; $res .= " " . $taxClass["name"]; $res .= "</option>"; } $res .= "</select>"; return $res; }
function znDeleteZone($zoneID) { $tax_classes = taxGetTaxClasses(); foreach ($tax_classes as $classr) { taxDeleteZoneRate($classr["classID"], $zoneID); } db_query("update " . CUSTOMER_ADDRESSES_TABLE . " set zoneID=NULL where zoneID=" . (int) $zoneID); db_query("delete from " . ZONES_TABLE . " where zoneID=" . (int) $zoneID); }