Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
cache	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
controller	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
db	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
exception	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
helper	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
log	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
module	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
order	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
pdf	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
range	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
shop	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
stock	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tax	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
tree	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
webservice	[ DIR ]	drwxrwxrwx	2020-12-09 15:21
.htaccess	510 B	-rwxrwxrwx	2023-01-18 07:38
Address.php	16.32 KB	-rwxrwxrwx	2019-04-30 18:42
AddressFormat.php	22.17 KB	-rwxrwxrwx	2019-04-30 18:42
AdminTab.php	115.85 KB	-rwxrwxrwx	2019-04-30 18:42
Alias.php	4.41 KB	-rwxrwxrwx	2019-04-30 18:42
Attachment.php	6.57 KB	-rwxrwxrwx	2019-04-30 18:42
Attribute.php	12.62 KB	-rwxrwxrwx	2019-04-30 18:42
AttributeGroup.php	11.49 KB	-rwxrwxrwx	2019-04-30 18:42
Blowfish.php	21.79 KB	-rwxrwxrwx	2019-04-30 18:42
CMS.php	8.98 KB	-rwxrwxrwx	2019-04-30 18:42
CMSCategory.php	23.42 KB	-rwxrwxrwx	2019-04-30 18:42
CMSRole.php	1.61 KB	-rwxrwxrwx	2019-04-30 18:42
CSV.php	2.89 KB	-rwxrwxrwx	2019-04-30 18:42
Carrier.php	55.24 KB	-rwxrwxrwx	2019-04-30 18:42
Cart.php	167.24 KB	-rwxrwxrwx	2019-04-30 18:42
CartRule.php	70 KB	-rwxrwxrwx	2019-04-30 18:42
Category.php	68.83 KB	-rwxrwxrwx	2019-04-30 18:42
Chart.php	5.36 KB	-rwxrwxrwx	2019-04-30 18:42
Combination.php	11.54 KB	-rwxrwxrwx	2019-04-30 18:42
CompareProduct.php	5.06 KB	-rwxrwxrwx	2019-04-30 18:42
Configuration.php	22.73 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationKPI.php	5.49 KB	-rwxrwxrwx	2019-04-30 18:42
ConfigurationTest.php	10.66 KB	-rwxrwxrwx	2019-04-30 18:42
Connection.php	9.69 KB	-rwxrwxrwx	2019-04-30 18:42
ConnectionsSource.php	5.02 KB	-rwxrwxrwx	2019-04-30 18:42
Contact.php	3.26 KB	-rwxrwxrwx	2019-04-30 18:42
Context.php	7.29 KB	-rwxrwxrwx	2019-04-30 18:42
ControllerFactory.php	2.16 KB	-rwxrwxrwx	2019-04-30 18:42
Cookie.php	13.04 KB	-rwxrwxrwx	2019-04-30 18:42
Country.php	14.07 KB	-rwxrwxrwx	2019-04-30 18:42
County.php	3.65 KB	-rwxrwxrwx	2019-04-30 18:42
Currency.php	15.33 KB	-rwxrwxrwx	2019-04-30 18:42
Customer.php	32.46 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerMessage.php	4.33 KB	-rwxrwxrwx	2019-04-30 18:42
CustomerThread.php	8.04 KB	-rwxrwxrwx	2019-04-30 18:42
Customization.php	9.72 KB	-rwxrwxrwx	2019-04-30 18:42
CustomizationField.php	2.33 KB	-rwxrwxrwx	2019-04-30 18:42
DateRange.php	2.23 KB	-rwxrwxrwx	2019-04-30 18:42
Delivery.php	3.12 KB	-rwxrwxrwx	2019-04-30 18:42
Discount.php	8.97 KB	-rwxrwxrwx	2019-04-30 18:42
Dispatcher.php	36.2 KB	-rwxrwxrwx	2019-04-30 18:42
Employee.php	16.38 KB	-rwxrwxrwx	2019-04-30 18:42
Feature.php	10.6 KB	-rwxrwxrwx	2019-04-30 18:42
FeatureValue.php	6.66 KB	-rwxrwxrwx	2019-04-30 18:42
FileUploader.php	11.06 KB	-rwxrwxrwx	2019-04-30 18:42
Gender.php	2.25 KB	-rwxrwxrwx	2019-04-30 18:42
Group.php	12.98 KB	-rwxrwxrwx	2019-04-30 18:42
GroupReduction.php	9.33 KB	-rwxrwxrwx	2019-04-30 18:42
Guest.php	7.27 KB	-rwxrwxrwx	2019-04-30 18:42
Hook.php	30.84 KB	-rwxrwxrwx	2019-04-30 18:42
Image.php	27.35 KB	-rwxrwxrwx	2019-04-30 18:42
ImageManager.php	21.9 KB	-rwxrwxrwx	2019-04-30 18:42
ImageType.php	6.14 KB	-rwxrwxrwx	2019-04-30 18:42
Language.php	39.76 KB	-rwxrwxrwx	2019-04-30 18:42
Link.php	29.46 KB	-rwxrwxrwx	2019-04-30 18:42
LocalizationPack.php	19.08 KB	-rwxrwxrwx	2019-04-30 18:42
Mail.php	24.81 KB	-rwxrwxrwx	2019-04-30 18:42
Manufacturer.php	17.13 KB	-rwxrwxrwx	2019-04-30 18:42
Media.php	39.73 KB	-rwxrwxrwx	2019-04-30 18:42
Message.php	5.65 KB	-rwxrwxrwx	2019-04-30 18:42
Meta.php	17.5 KB	-rwxrwxrwx	2019-04-30 18:42
Notification.php	6.08 KB	-rwxrwxrwx	2019-04-30 18:42
ObjectModel.php	69.64 KB	-rwxrwxrwx	2019-04-30 18:42
Pack.php	17.82 KB	-rwxrwxrwx	2019-04-30 18:42
Page.php	4.2 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentCC.php	2.49 KB	-rwxrwxrwx	2019-04-30 18:42
PaymentModule.php	53.64 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopAutoload.php	8.31 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopBackup.php	10.53 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopCollection.php	20.43 KB	-rwxrwxrwx	2019-04-30 18:42
PrestaShopLogger.php	6.07 KB	-rwxrwxrwx	2019-04-30 18:42
Product.php	232.97 KB	-rwxrwxrwx	2019-04-30 18:42
ProductDownload.php	9.86 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSale.php	11.37 KB	-rwxrwxrwx	2019-04-30 18:42
ProductSupplier.php	7.63 KB	-rwxrwxrwx	2019-04-30 18:42
Profile.php	5.19 KB	-rwxrwxrwx	2019-04-30 18:42
QuickAccess.php	2.58 KB	-rwxrwxrwx	2019-04-30 18:42
Referrer.php	16.19 KB	-rwxrwxrwx	2019-04-30 18:42
RequestSql.php	19.64 KB	-rwxrwxrwx	2019-04-30 18:42
Rijndael.php	4.88 KB	-rwxrwxrwx	2019-04-30 18:42
Risk.php	2.35 KB	-rwxrwxrwx	2019-04-30 18:42
Scene.php	9.85 KB	-rwxrwxrwx	2019-04-30 18:42
Search.php	38.85 KB	-rwxrwxrwx	2019-04-30 18:42
SearchEngine.php	2.57 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCacheResourceMysql.php	4.76 KB	-rwxrwxrwx	2019-04-30 18:42
SmartyCustom.php	12.28 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPrice.php	22.79 KB	-rwxrwxrwx	2019-04-30 18:42
SpecificPriceRule.php	13.64 KB	-rwxrwxrwx	2019-04-30 18:42
State.php	6.65 KB	-rwxrwxrwx	2019-04-30 18:42
Store.php	4.82 KB	-rwxrwxrwx	2019-04-30 18:42
Supplier.php	15.21 KB	-rwxrwxrwx	2019-04-30 18:42
Tab.php	19.1 KB	-rwxrwxrwx	2019-04-30 18:42
Tag.php	10.19 KB	-rwxrwxrwx	2019-04-30 18:42
Theme.php	12.58 KB	-rwxrwxrwx	2019-04-30 18:42
Tools.php	130.71 KB	-rwxrwxrwx	2019-04-30 18:42
Translate.php	11.48 KB	-rwxrwxrwx	2019-04-30 18:42
TranslatedConfiguration.php	3.99 KB	-rwxrwxrwx	2019-04-30 18:42
Upgrader.php	11.02 KB	-rwxrwxrwx	2019-04-30 18:42
Uploader.php	8.47 KB	-rwxrwxrwx	2019-04-30 18:42
Validate.php	31.72 KB	-rwxrwxrwx	2019-04-30 18:42
Zone.php	3.17 KB	-rwxrwxrwx	2019-04-30 18:42
index.php	29.14 KB	-rwxrwxrwx	2023-01-18 07:38

Rename

<?php
/*
* 2007-2017 PrestaShop
*
* 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.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* 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 http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2017 PrestaShop SA
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

class SpecificPriceRuleCore extends ObjectModel
{
    public $name;
    public $id_shop;
    public $id_currency;
    public $id_country;
    public $id_group;
    public $from_quantity;
    public $price;
    public $reduction;
    public $reduction_tax;
    public $reduction_type;
    public $from;
    public $to;

protected static $rules_application_enable = true;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table' => 'specific_price_rule',
        'primary' => 'id_specific_price_rule',
        'fields' => array(
            'name' =>            array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true),
            'id_shop' =>        array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'id_country' =>    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'id_currency' =>    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'id_group' =>        array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'from_quantity' =>    array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true),
            'price' =>        array('type' => self::TYPE_FLOAT, 'validate' => 'isNegativePrice', 'required' => true),
            'reduction' =>        array('type' => self::TYPE_FLOAT, 'validate' => 'isPrice', 'required' => true),
            'reduction_tax' =>            array('type' => self::TYPE_INT, 'validate' => 'isBool', 'required' => true),
            'reduction_type' => array('type' => self::TYPE_STRING, 'validate' => 'isReductionType', 'required' => true),
            'from' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDateFormat', 'required' => false),
            'to' =>            array('type' => self::TYPE_DATE, 'validate' => 'isDateFormat', 'required' => false),
        ),
    );

protected $webserviceParameters = array(
        'objectsNodeName' => 'specific_price_rules',
        'objectNodeName' => 'specific_price_rule',
        'fields' => array(
            'id_shop' =>                array('xlink_resource' => 'shops', 'required' => true),
            'id_country' =>            array('xlink_resource' => 'countries', 'required' => true),
            'id_currency' =>            array('xlink_resource' => 'currencies', 'required' => true),
            'id_group' =>                array('xlink_resource' => 'groups', 'required' => true),
        ),
    );

public function delete()
    {
        $this->deleteConditions();
        Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'specific_price WHERE id_specific_price_rule='.(int)$this->id);
        return parent::delete();
    }

public function deleteConditions()
    {
        $ids_condition_group = Db::getInstance()->executeS('SELECT id_specific_price_rule_condition_group
																		 FROM '._DB_PREFIX_.'specific_price_rule_condition_group
																		 WHERE id_specific_price_rule='.(int)$this->id);
        if ($ids_condition_group) {
            foreach ($ids_condition_group as $row) {
                Db::getInstance()->delete('specific_price_rule_condition_group', 'id_specific_price_rule_condition_group='.(int)$row['id_specific_price_rule_condition_group']);
                Db::getInstance()->delete('specific_price_rule_condition', 'id_specific_price_rule_condition_group='.(int)$row['id_specific_price_rule_condition_group']);
            }
        }
    }

public static function disableAnyApplication()
    {
        SpecificPriceRule::$rules_application_enable = false;
    }

public static function enableAnyApplication()
    {
        SpecificPriceRule::$rules_application_enable = true;
    }

public function addConditions($conditions)
    {
        if (!is_array($conditions)) {
            return;
        }

$result = Db::getInstance()->insert('specific_price_rule_condition_group', array(
            'id_specific_price_rule' =>    (int)$this->id
        ));
        if (!$result) {
            return false;
        }
        $id_specific_price_rule_condition_group = (int)Db::getInstance()->Insert_ID();
        foreach ($conditions as $condition) {
            $result = Db::getInstance()->insert('specific_price_rule_condition', array(
                'id_specific_price_rule_condition_group' => (int)$id_specific_price_rule_condition_group,
                'type' => pSQL($condition['type']),
                'value' => (float)$condition['value'],
            ));
            if (!$result) {
                return false;
            }
        }
        return true;
    }

public function apply($products = false)
    {
        if (!SpecificPriceRule::$rules_application_enable) {
            return;
        }

$this->resetApplication($products);
        $products = $this->getAffectedProducts($products);
        foreach ($products as $product) {
            SpecificPriceRule::applyRuleToProduct((int)$this->id, (int)$product['id_product'], (int)$product['id_product_attribute']);
        }
    }

public function resetApplication($products = false)
    {
        $where = '';
        if ($products && count($products)) {
            $where .= ' AND id_product IN ('.implode(', ', array_map('intval', $products)).')';
        }
        return Db::getInstance()->execute('DELETE FROM '._DB_PREFIX_.'specific_price WHERE id_specific_price_rule='.(int)$this->id.$where);
    }

/**
     * @param array|bool $products
     */
    public static function applyAllRules($products = false)
    {
        if (!SpecificPriceRule::$rules_application_enable) {
            return;
        }

$rules = new PrestaShopCollection('SpecificPriceRule');
        foreach ($rules as $rule) {
            /** @var SpecificPriceRule $rule */
            $rule->apply($products);
        }
    }

public function getConditions()
    {
        $conditions = Db::getInstance()->executeS('
			SELECT g.*, c.*
			FROM '._DB_PREFIX_.'specific_price_rule_condition_group g
			LEFT JOIN '._DB_PREFIX_.'specific_price_rule_condition c
				ON (c.id_specific_price_rule_condition_group = g.id_specific_price_rule_condition_group)
			WHERE g.id_specific_price_rule='.(int)$this->id
        );
        $conditions_group = array();
        if ($conditions) {
            foreach ($conditions as &$condition) {
                if ($condition['type'] == 'attribute') {
                    $condition['id_attribute_group'] = Db::getInstance()->getValue('SELECT id_attribute_group
																										FROM '._DB_PREFIX_.'attribute
																										WHERE id_attribute='.(int)$condition['value']);
                } elseif ($condition['type'] == 'feature') {
                    $condition['id_feature'] = Db::getInstance()->getValue('SELECT id_feature
																								FROM '._DB_PREFIX_.'feature_value
																								WHERE id_feature_value='.(int)$condition['value']);
                }
                $conditions_group[(int)$condition['id_specific_price_rule_condition_group']][] = $condition;
            }
        }
        return $conditions_group;
    }

/**
     * Return the product list affected by this specific rule.
     *
     * @param bool|array $products Products list limitation.
     * @return array Affected products list IDs.
     * @throws PrestaShopDatabaseException
     */
    public function getAffectedProducts($products = false)
    {
        $conditions_group = $this->getConditions();
        $current_shop_id = Context::getContext()->shop->id;

$result = array();

if ($conditions_group) {
            foreach ($conditions_group as $id_condition_group => $condition_group) {
                // Base request
                $query = new DbQuery();
                $query->select('p.`id_product`')
                    ->from('product', 'p')
                    ->leftJoin('product_shop', 'ps', 'p.`id_product` = ps.`id_product`')
                    ->where('ps.id_shop = '.(int)$current_shop_id);

$attributes_join_added = false;

// Add the conditions
                foreach ($condition_group as $id_condition => $condition) {
                    if ($condition['type'] == 'attribute') {
                        if (!$attributes_join_added) {
                            $query->select('pa.`id_product_attribute`')
                                ->leftJoin('product_attribute', 'pa', 'p.`id_product` = pa.`id_product`')
                                ->join(Shop::addSqlAssociation('product_attribute', 'pa', false));

$attributes_join_added = true;
                        }

$query->leftJoin('product_attribute_combination', 'pac'.(int)$id_condition, 'pa.`id_product_attribute` = pac'.(int)$id_condition.'.`id_product_attribute`')
                            ->where('pac'.(int)$id_condition.'.`id_attribute` = '.(int)$condition['value']);
                    } elseif ($condition['type'] == 'manufacturer') {
                        $query->where('p.id_manufacturer = '.(int)$condition['value']);
                    } elseif ($condition['type'] == 'category') {
                        $query->leftJoin('category_product', 'cp'.(int)$id_condition, 'p.`id_product` = cp'.(int)$id_condition.'.`id_product`')
                            ->where('cp'.(int)$id_condition.'.id_category = '.(int)$condition['value']);
                    } elseif ($condition['type'] == 'supplier') {
                        $query->where('EXISTS(
							SELECT
								`ps'.(int)$id_condition.'`.`id_product`
							FROM
								`'._DB_PREFIX_.'product_supplier` `ps'.(int)$id_condition.'`
							WHERE
								`p`.`id_product` = `ps'.(int)$id_condition.'`.`id_product`
								AND `ps'.(int)$id_condition.'`.`id_supplier` = '.(int)$condition['value'].'
						)');
                    } elseif ($condition['type'] == 'feature') {
                        $query->leftJoin('feature_product', 'fp'.(int)$id_condition, 'p.`id_product` = fp'.(int)$id_condition.'.`id_product`')
                            ->where('fp'.(int)$id_condition.'.`id_feature_value` = '.(int)$condition['value']);
                    }
                }

// Products limitation
                if ($products && count($products)) {
                    $query->where('p.`id_product` IN ('.implode(', ', array_map('intval', $products)).')');
                }

// Force the column id_product_attribute if not requested
                if (!$attributes_join_added) {
                    $query->select('NULL as `id_product_attribute`');
                }

$result = array_merge($result, Db::getInstance()->executeS($query));
            }
        } else {
            // All products without conditions
            if ($products && count($products)) {
                $query = new DbQuery();
                $query->select('p.`id_product`')
                    ->select('NULL as `id_product_attribute`')
                    ->from('product', 'p')
                    ->leftJoin('product_shop', 'ps', 'p.`id_product` = ps.`id_product`')
                    ->where('ps.id_shop = '.(int)$current_shop_id);
                $query->where('p.`id_product` IN ('.implode(', ', array_map('intval', $products)).')');
                $result = Db::getInstance()->executeS($query);
            } else {
                $result = array(array('id_product' => 0, 'id_product_attribute' => null));
            }

}

return $result;
    }

public static function applyRuleToProduct($id_rule, $id_product, $id_product_attribute = null)
    {
        $rule = new SpecificPriceRule((int)$id_rule);
        if (!Validate::isLoadedObject($rule) || !Validate::isUnsignedInt($id_product)) {
            return false;
        }

$specific_price = new SpecificPrice();
        $specific_price->id_specific_price_rule = (int)$rule->id;
        $specific_price->id_product = (int)$id_product;
        $specific_price->id_product_attribute = (int)$id_product_attribute;
        $specific_price->id_customer = 0;
        $specific_price->id_shop = (int)$rule->id_shop;
        $specific_price->id_country = (int)$rule->id_country;
        $specific_price->id_currency = (int)$rule->id_currency;
        $specific_price->id_group = (int)$rule->id_group;
        $specific_price->from_quantity = (int)$rule->from_quantity;
        $specific_price->price = (float)$rule->price;
        $specific_price->reduction_type = $rule->reduction_type;
        $specific_price->reduction_tax = $rule->reduction_tax;
        $specific_price->reduction = ($rule->reduction_type == 'percentage' ? $rule->reduction / 100 : (float)$rule->reduction);
        $specific_price->from = $rule->from;
        $specific_price->to = $rule->to;

return $specific_price->add();
    }
}