Gecko [ garmin.alinaous.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
Smarty	[ DIR ]	drwx---r-x
assets	[ DIR ]	drwx---r-x
cache	[ DIR ]	drwx---r-x
checkout	[ DIR ]	drwx---r-x
container	[ DIR ]	drwx---r-x
controller	[ DIR ]	drwx---r-x
db	[ DIR ]	drwx---r-x
exception	[ DIR ]	drwx---r-x
form	[ DIR ]	drwx---r-x
helper	[ DIR ]	drwx---r-x
lang	[ DIR ]	drwx---r-x
log	[ DIR ]	drwx---r-x
module	[ DIR ]	drwx---r-x
order	[ DIR ]	drwx---r-x
pdf	[ DIR ]	drwx---r-x
product	[ DIR ]	drwx---r-x
proxy	[ DIR ]	drwx---r-x
range	[ DIR ]	drwx---r-x
shop	[ DIR ]	drwx---r-x
stock	[ DIR ]	drwx---r-x
tax	[ DIR ]	drwx---r-x
tree	[ DIR ]	drwx---r-x
webservice	[ DIR ]	drwx---r-x
.htaccess	170 B	-rw----r--
.mad-root	0 B	-rw-r--r--
Access.php	13.2 KB	-rw----r--
Address.php	20.13 KB	-rw----r--
AddressChecksumCore.php	1.7 KB	-rw----r--
AddressFormat.php	25.62 KB	-rw----r--
Alias.php	5.03 KB	-rw----r--
Attachment.php	7.91 KB	-rw----r--
Attribute.php	13.47 KB	-rw----r--
AttributeGroup.php	13.32 KB	-rw----r--
CMS.php	11.41 KB	-rw----r--
CMSCategory.php	24.09 KB	-rw----r--
CMSRole.php	1.78 KB	-rw----r--
CSV.php	3.04 KB	-rw----r--
Carrier.php	61.57 KB	-rw----r--
Cart.php	212.71 KB	-rw----r--
CartRule.php	88.48 KB	-rw----r--
Category.php	84.77 KB	-rw----r--
Chart.php	4.16 KB	-rw----r--
ChecksumInterface.php	1.13 KB	-rw----r--
Combination.php	14.5 KB	-rw----r--
Configuration.php	26.03 KB	-rw----r--
ConfigurationKPI.php	8.64 KB	-rw----r--
ConfigurationTest.php	11.92 KB	-rw----r--
Connection.php	10.31 KB	-rw----r--
ConnectionsSource.php	5.72 KB	-rw----r--
Contact.php	3.77 KB	-rw----r--
Context.php	13.8 KB	-rw----r--
Cookie.php	16.42 KB	-rw----r--
Country.php	16.12 KB	-rw----r--
Currency.php	35.48 KB	-rw----r--
Curve.php	2.42 KB	-rw----r--
Customer.php	46.67 KB	-rw----r--
CustomerAddress.php	1.26 KB	-rw----r--
CustomerMessage.php	5.71 KB	-rw----r--
CustomerSession.php	2.31 KB	-rw----r--
CustomerThread.php	9.63 KB	-rw----r--
Customization.php	13.35 KB	-rw----r--
CustomizationField.php	2.72 KB	-rw----r--
DateRange.php	2.47 KB	-rw----r--
Delivery.php	3.24 KB	-rw----r--
Dispatcher.php	43.1 KB	-rw----r--
Employee.php	22.1 KB	-rw----r--
EmployeeSession.php	2.32 KB	-rw----r--
Feature.php	11.16 KB	-rw----r--
FeatureValue.php	8.02 KB	-rw----r--
FileUploader.php	3.54 KB	-rw----r--
Gender.php	2.71 KB	-rw----r--
Group.php	14.51 KB	-rw----r--
GroupReduction.php	9.84 KB	-rw----r--
Guest.php	7.9 KB	-rw----r--
Hook.php	42.13 KB	-rw----r--
Image.php	28.51 KB	-rw----r--
ImageManager.php	23.98 KB	-rw----r--
ImageType.php	6.94 KB	-rw----r--
Language.php	57.96 KB	-rw----r--
Link.php	56.55 KB	-rw----r--
LocalizationPack.php	25.19 KB	-rw----r--
Mail.php	31.22 KB	-rw----r--
Manufacturer.php	20.82 KB	-rw----r--
ManufacturerAddress.php	1.28 KB	-rw----r--
Media.php	34.44 KB	-rw----r--
Message.php	6.26 KB	-rw----r--
Meta.php	17.97 KB	-rw----r--
Notification.php	7.42 KB	-rw----r--
ObjectModel.php	75.02 KB	-rw----r--
Pack.php	22.78 KB	-rw----r--
Page.php	4.48 KB	-rw----r--
PaymentFree.php	1.25 KB	-rw----r--
PaymentModule.php	59.53 KB	-rw----r--
PhpEncryption.php	3.39 KB	-rw----r--
PhpEncryptionEngine.php	4.26 KB	-rw----r--
PhpEncryptionLegacyEngine.php	4.77 KB	-rw----r--
PrestaShopAutoload.php	12.25 KB	-rw----r--
PrestaShopBackup.php	12.07 KB	-rw----r--
PrestaShopCollection.php	21.07 KB	-rw----r--
PrestaShopLogger.php	6.5 KB	-rw----r--
Product.php	269.79 KB	-rw----r--
ProductAssembler.php	3.37 KB	-rw----r--
ProductDownload.php	9.77 KB	-rw----r--
ProductPresenterFactory.php	3.6 KB	-rw----r--
ProductSale.php	12.7 KB	-rw----r--
ProductSupplier.php	8.76 KB	-rw----r--
Profile.php	7.56 KB	-rw----r--
QqUploadedFileForm.php	4.93 KB	-rw----r--
QqUploadedFileXhr.php	5.56 KB	-rw----r--
QuickAccess.php	4.65 KB	-rw----r--
Referrer.php	17.45 KB	-rw----r--
RequestSql.php	20.14 KB	-rw----r--
Risk.php	2.36 KB	-rw----r--
Search.php	51.05 KB	-rw----r--
SearchEngine.php	2.79 KB	-rw----r--
SpecificPrice.php	30.68 KB	-rw----r--
SpecificPriceRule.php	13.67 KB	-rw----r--
State.php	7.38 KB	-rw----r--
Store.php	6.25 KB	-rw----r--
Supplier.php	17.66 KB	-rw----r--
SupplierAddress.php	1.27 KB	-rw----r--
Tab.php	21.37 KB	-rw----r--
Tag.php	11.66 KB	-rw----r--
Tools.php	144.64 KB	-rw----r--
Translate.php	13.81 KB	-rw----r--
TranslatedConfiguration.php	4.56 KB	-rw----r--
Upgrader.php	11.54 KB	-rw----r--
Uploader.php	11.41 KB	-rw----r--
Validate.php	34.53 KB	-rw----r--
ValidateConstraintTranslator.p...	2.55 KB	-rw----r--
WarehouseAddress.php	1.27 KB	-rw----r--
Windows.php	1.34 KB	-rw----r--
Zone.php	3.4 KB	-rw----r--
adminer.php	465.43 KB	-rw-r--r--
index.php	1.34 KB	-rw----r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : SpecificPriceRule.php

<?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 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 = [
        'table' => 'specific_price_rule',
        'primary' => 'id_specific_price_rule',
        'fields' => [
            'name' => ['type' => self::TYPE_STRING, 'validate' => 'isCleanHtml', 'required' => true],
            'id_shop' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'id_country' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'id_currency' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'id_group' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'from_quantity' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true],
            'price' => ['type' => self::TYPE_FLOAT, 'validate' => 'isNegativePrice', 'required' => true],
            'reduction' => ['type' => self::TYPE_FLOAT, 'validate' => 'isPrice', 'required' => true],
            'reduction_tax' => ['type' => self::TYPE_INT, 'validate' => 'isBool', 'required' => true],
            'reduction_type' => ['type' => self::TYPE_STRING, 'validate' => 'isReductionType', 'required' => true],
            'from' => ['type' => self::TYPE_DATE, 'validate' => 'isDateFormat', 'required' => false],
            'to' => ['type' => self::TYPE_DATE, 'validate' => 'isDateFormat', 'required' => false],
        ],
    ];

protected $webserviceParameters = [
        'objectsNodeName' => 'specific_price_rules',
        'objectNodeName' => 'specific_price_rule',
        'fields' => [
            'id_shop' => ['xlink_resource' => 'shops', 'required' => true],
            'id_country' => ['xlink_resource' => 'countries', 'required' => true],
            'id_currency' => ['xlink_resource' => 'currencies', 'required' => true],
            'id_group' => ['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', [
            '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', [
                '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 = [];
        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 = [];

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 = [['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();
    }
}

${this.title}

Code Editor : SpecificPriceRule.php