FM / tax

/home/sharedstore/public_html/prestashop.sharedstore.ma/classes/tax/

/home/sharedstore/public_html/prestashop.sharedstore.ma/classes/tax

Name	Size	Mode	Actions
AverageTaxOfProductsTaxCalculator.php	3426	0644	edit dl rm
index.php	1375	0644	edit dl rm
Tax.php	6820	0644	edit dl rm
TaxCalculator.php	4783	0644	edit dl rm
TaxConfiguration.php	1633	0644	edit dl rm
TaxManagerFactory.php	3487	0644	edit dl rm
TaxManagerInterface.php	1561	0644	edit dl rm
TaxManagerModule.php	2081	0644	edit dl rm
TaxRule.php	5954	0644	edit dl rm
TaxRulesGroup.php	9118	0644	edit dl rm
TaxRulesTaxManager.php	4685	0644	edit dl rm

Edit: /home/sharedstore/public_html/prestashop.sharedstore.ma/classes/tax/TaxRule.php (5954B)

<?php
/**
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://devdocs.prestashop.com/ for more information.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @copyright Since 2007 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 */
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'],
            'zipcode_to' => ['type' => self::TYPE_STRING, 'validate' => 'isPostCode'],
            'id_tax' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'behavior' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'description' => ['type' => self::TYPE_STRING, 'validate' => 'isString'],
        ],
    ];

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)) {
            die(Tools::displayError('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
        );
    }
}

cmd: