prestashop/classes/tax/TaxRule.php

<?php
/**
 * For the full copyright and license information, please view the
 * docs/licenses/LICENSE.txt file that was distributed with this source code.
 */
class TaxRuleCore extends ObjectModel
{
    public $id_tax_rules_group;
    public $id_country;
    public $id_state;
    public $zipcode_from;
    public $zipcode_to;
    public $id_tax;
    public $behavior;
    public $description;

    /**
     * @see ObjectModel::$definition
     */
    public static $definition = [
        'table' => 'tax_rule',
        'primary' => 'id_tax_rule',
        'fields' => [
            'id_tax_rules_group' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'id_country' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'id_state' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId'],
            'zipcode_from' => ['type' => self::TYPE_STRING, 'validate' => 'isPostCode', 'size' => 12],
            'zipcode_to' => ['type' => self::TYPE_STRING, 'validate' => 'isPostCode', 'size' => 12],
            'id_tax' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'behavior' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'description' => ['type' => self::TYPE_STRING, 'validate' => 'isString', 'size' => 100],
        ],
    ];

    protected $webserviceParameters = [
        'fields' => [
            'id_tax_rules_group' => ['xlink_resource' => 'tax_rule_groups'],
            'id_state' => ['xlink_resource' => 'states'],
            'id_country' => ['xlink_resource' => 'countries'],
        ],
    ];

    public static function deleteByGroupId($id_group)
    {
        if (empty($id_group)) {
            throw new PrestaShopException('Parameter "id_group" (id_tax_rules_group you want to delete) is invalid.');
        }

        return Db::getInstance()->execute(
            '
			DELETE FROM `' . _DB_PREFIX_ . 'tax_rule`
			WHERE `id_tax_rules_group` = ' . (int) $id_group
        );
    }

    public static function retrieveById($id_tax_rule)
    {
        return Db::getInstance()->getRow('
			SELECT * FROM `' . _DB_PREFIX_ . 'tax_rule`
			WHERE `id_tax_rule` = ' . (int) $id_tax_rule);
    }

    public static function getTaxRulesByGroupId($id_lang, $id_group)
    {
        return Db::getInstance()->executeS(
            '
		SELECT g.`id_tax_rule`,
				 c.`name` AS country_name,
				 s.`name` AS state_name,
				 t.`rate`,
				 g.`zipcode_from`, g.`zipcode_to`,
				 g.`description`,
				 g.`behavior`,
				 g.`id_country`,
				 g.`id_state`
		FROM `' . _DB_PREFIX_ . 'tax_rule` g
		LEFT JOIN `' . _DB_PREFIX_ . 'country_lang` c ON (g.`id_country` = c.`id_country` AND `id_lang` = ' . (int) $id_lang . ')
		LEFT JOIN `' . _DB_PREFIX_ . 'state` s ON (g.`id_state` = s.`id_state`)
		LEFT JOIN `' . _DB_PREFIX_ . 'tax` t ON (g.`id_tax` = t.`id_tax`)
		WHERE `id_tax_rules_group` = ' . (int) $id_group . '
		ORDER BY `country_name` ASC, `state_name` ASC, `zipcode_from` ASC, `zipcode_to` ASC'
        );
    }

    public static function deleteTaxRuleByIdTax($id_tax)
    {
        return Db::getInstance()->execute(
            '
			DELETE FROM `' . _DB_PREFIX_ . 'tax_rule`
			WHERE `id_tax` = ' . (int) $id_tax
        );
    }

    /**
     * @param int $id_tax
     *
     * @return int
     */
    public static function isTaxInUse($id_tax)
    {
        $cache_id = 'TaxRule::isTaxInUse_' . (int) $id_tax;
        if (!Cache::isStored($cache_id)) {
            $result = (int) Db::getInstance()->getValue('SELECT COUNT(*) FROM `' . _DB_PREFIX_ . 'tax_rule` WHERE `id_tax` = ' . (int) $id_tax);
            Cache::store($cache_id, $result);

            return $result;
        }

        return Cache::retrieve($cache_id);
    }

    /**
     * @param string $zip_codes a range of zipcode (eg: 75000 / 75000-75015)
     *
     * @return array an array containing two zipcode ordered by zipcode
     */
    public function breakDownZipCode($zip_codes)
    {
        $zip_codes = preg_split('/-/', $zip_codes);

        $from = $zip_codes[0];
        $to = isset($zip_codes[1]) ? $zip_codes[1] : 0;
        if (count($zip_codes) == 2) {
            $from = $zip_codes[0];
            $to = $zip_codes[1];
            if ($zip_codes[0] > $zip_codes[1]) {
                $from = $zip_codes[1];
                $to = $zip_codes[0];
            } elseif ($zip_codes[0] == $zip_codes[1]) {
                $from = $zip_codes[0];
                $to = 0;
            }
        } elseif (count($zip_codes) == 1) {
            $from = $zip_codes[0];
            $to = 0;
        }

        return [$from, $to];
    }

    /**
     * Replace a tax_rule id by an other one in the tax_rule table.
     *
     * @param int $old_id
     * @param int $new_id
     */
    public static function swapTaxId($old_id, $new_id)
    {
        return Db::getInstance()->execute(
            '
		UPDATE `' . _DB_PREFIX_ . 'tax_rule`
		SET `id_tax` = ' . (int) $new_id . '
		WHERE `id_tax` = ' . (int) $old_id
        );
    }
}