编辑文件 - ProductFinderMEP.php

✏️ 正在编辑: ProductFinderMEP.php

路径: /home/bpioifn/www/pigmentse/modules/masseditproduct/classes/ProductFinderMEP.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php
/**
 * 2007-2019 PrestaShop
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 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/afl-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    SeoSA <885588@bk.ru>
 * @copyright 2012-2019 SeoSA
 * @license   http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

class ProductFinderMEP
{
    public $categories;
    public $search_only_default_category;
    public $search_query;
    public $type_search;
    public $manufacturers;
    public $suppliers;
    public $carrier;
    public $features;
    public $no_feature_value;
    public $how_many_show;
    public $active;
    public $disable;
    public $no_image;
    public $yes_image;
    public $no_discount;
    public $yes_discount;
    public $page;
    public $exclude_ids;
    public $product_name_type_search;
    public $qty_from;
    public $qty_to;
    public $date_from;
    public $date_to;
    public $price_from;
    public $price_to;
    public $orderby;
    public $orderway;

const SEARCH_TYPE_NAME = 0;
    const SEARCH_TYPE_ID = 1;
    const SEARCH_TYPE_REFERENCE = 2;
    const SEARCH_TYPE_EAN13 = 3;
    const SEARCH_TYPE_UPC = 4;
    const SEARCH_TYPE_DESCRIPTION = 5;
    const SEARCH_TYPE_DESCRIPTION_SHORT = 6;
    protected static $search_type_fields = array(
        self::SEARCH_TYPE_NAME => 'pl.`name`',
        self::SEARCH_TYPE_ID => 'p.`id_product`',
        self::SEARCH_TYPE_REFERENCE => 'p.`reference`',
        self::SEARCH_TYPE_EAN13 => 'p.`ean13`',
        self::SEARCH_TYPE_UPC => 'p.`upc`',
        self::SEARCH_TYPE_DESCRIPTION => 'pl.`description`',
        self::SEARCH_TYPE_DESCRIPTION_SHORT => 'pl.`description_short`',
    );

const PRODUCT_NAME_TYPE_SEARCH_OCCURRENCE = 'occurrence';
    const PRODUCT_NAME_TYPE_SEARCH_EXACT_MATCH = 'exact_match';

protected $context;

protected function __construct()
    {
        $this->initRequestParams();
        $this->context = Context::getContext();
    }

protected static $instance = null;

public static function getInstance()
    {
        if (is_null(self::$instance)) {
            self::$instance = new self();
        }
        return self::$instance;
    }

protected function initRequestParams()
    {
        $categories = Tools::getValue('categories');
        $this->categories = (is_array($categories) ? $categories : array());

$this->search_only_default_category = Tools::getValue('search_only_default_category');
        $this->search_query = Tools::getValue('search_query');
        $this->type_search = (int)Tools::getValue('type_search', 0);

$manufacturers = Tools::getValue('manufacturers');
        $this->manufacturers = ($manufacturers ? array_map('intval', $manufacturers) : array());

$suppliers = Tools::getValue('suppliers');
        $this->suppliers = ($suppliers ? array_map('intval', $suppliers) : array());

$carriers = Tools::getValue('carriers');
        $this->carriers = ($carriers ? array_map('intval', $carriers) : array());

$this->features = Tools::getValue('features');
        $this->id_feature = Tools::getValue('id_feature');
        $this->no_feature_value = Tools::getValue('no_feature_value');
        $this->how_many_show = (int)Tools::getValue('how_many_show', 20);
        $this->active = (int)Tools::getValue('active', 0);
        $this->disable = (int)Tools::getValue('disable', 0);
        $this->no_image = (int)Tools::getValue('no_image', 0);
        $this->yes_image = (int)Tools::getValue('yes_image', 0);
        $this->no_discount = (int)Tools::getValue('no_discount', 0);
        $this->yes_discount = (int)Tools::getValue('yes_discount', 0);
        $this->page = (int)Tools::getValue('page', 1);

$exclude_ids = Tools::getValue('exclude_ids', array());
        $exclude_ids = $exclude_ids ? array_map('intval', $exclude_ids) : array();
        $this->exclude_ids = $exclude_ids;
        $this->product_name_type_search = Tools::getValue('product_name_type_search');
        $this->qty_from = Tools::getValue('qty_from');
        $this->qty_to = Tools::getValue('qty_to');
        $this->date_from = Tools::getValue('date_from');
        $this->date_to = Tools::getValue('date_to');
        $this->type_price = Tools::getValue('type_price');
        $this->price_from = Tools::getValue('price_from');
        $this->price_to = Tools::getValue('price_to');
        $this->orderby = Tools::getValue('orderby');
        $this->orderway = Tools::getValue('orderway');
    }

public function updateFinalPrice()
    {
        $result = Db::getInstance()->executeS('SELECT `id_product` FROM `' . _DB_PREFIX_ . 'product_shop`');
        $nothing = null;
        foreach ($result as $row) {
            $final_price = Product::getPriceStatic(
                $row['id_product'],
                true,
                null,
                (int)Configuration::get('PS_PRICE_DISPLAY_PRECISION'),
                null,
                false,
                true,
                1,
                true,
                null,
                null,
                null,
                $nothing
            );
            Db::getInstance()->update('product_shop', array('final_price' => $final_price), 'id_product = ' . $row['id_product']);
        }
    }

public function findProducts()
    {
        if ($this->type_price == 1) {
            $this->updateFinalPrice();
        }
        $products = Db::getInstance()->executeS($this->buildSql());

$country = new Country(Configuration::get('PS_COUNTRY_DEFAULT'));
        $address = new Address();
        $address->id_country = $country->id;

foreach ($products as &$product) {
            $nothing = null;
            $advanced_stock_management = (bool)Db::getInstance()->getValue(
                '
					SELECT `advanced_stock_management`
					FROM ' . _DB_PREFIX_ . 'product_shop
					WHERE id_product=' . (int)$product['id_product'] . Shop::addSqlRestriction()
            );

$product['price_final'] = Product::getPriceStatic(
                $product['id_product'],
                true,
                null,
                (int)Configuration::get('PS_PRICE_DISPLAY_PRECISION'),
                null,
                false,
                true,
                1,
                true,
                null,
                null,
                null,
                $nothing
            );

$product['advanced_stock_management'] = ((bool)StockAvailable::dependsOnStock(
                (int)$product['id_product']
            ) && $advanced_stock_management);
            $product['image'] = ImageManager::thumbnail(
                _PS_PROD_IMG_DIR_ . Image::getImgFolderStatic($product['cover']) . $product['cover'] . '.jpg',
                'product_mini_' . $product['id_product'] . '_' . $product['cover'] . '.jpg',
                45
            );
            $id_image = Product::getCover($product['id_product']);
            $path = Image::getImgFolderStatic($id_image['id_image']);
            $full_patch = '../img/p/' . $path . $id_image['id_image'].'-small_default.jpg';
            $product['image_small'] = $full_patch;
        }
        $tmp_products = array();
        foreach ($products as $prod) {
            $tmp_products[$prod['id_product']] = $prod;
        }
        return $tmp_products;
    }

public function getTotal()
    {
        return (int)Db::getInstance()->getValue($this->buildSql(true));
    }

public function buildSql($get_total = false)
    {
        $sql_category = false;
        if (is_array($this->categories) && count($this->categories)) {
            $ids_categories = array();
            foreach ($this->categories as $category) {
                $ids_categories[] = (int)$category['id'];
            }
            $sql_category = implode(',', $ids_categories);
        }

$qty_query = array();

if ($this->qty_from != '') {
            $qty_query[] = 'sa.`quantity` >= ' . (int)$this->qty_from;
        }

if ($this->qty_to != '') {
            $qty_query[] = 'sa.`quantity` <= ' . (int)$this->qty_to;
        }

$date_query = array();

if ($this->date_from != '') {
            $date_query[] = 'p.`date_add` >= "' . pSQL($this->date_from) . '"';
        }

if ($this->date_to != '') {
            $date_query[] = 'p.`date_add` <= "' . pSQL($this->date_to) . '"';
        }

$price_query = array();

if ($this->price_from != '') {
            if ($this->type_price == 1) {
                $price_query[] = 'pss.`final_price` >= ' . (float)$this->price_from;
            } else {
                $price_query[] = 'pss.`price` >= ' . (float)$this->price_from;
            }
        }

if ($this->price_to != '') {
            if ($this->type_price == 1) {
                $price_query[] = 'pss.`final_price` <= ' . (float)$this->price_to;
            } else {
                $price_query[] = 'pss.`price` <= ' . (float)$this->price_to;
            }
        }

$sql_manufactures = false;
        if (is_array($this->manufacturers) && count($this->manufacturers)) {
            $sql_manufactures = implode(',', $this->manufacturers);
        }

$sql_suppliers = false;
        if (is_array($this->suppliers) && count($this->suppliers)) {
            $sql_suppliers = implode(',', $this->suppliers);
        }

$sql_carriers = false;
        if (is_array($this->carriers) && count($this->carriers)) {
            $sql_carriers = implode(',', $this->carriers);
        }

$sql_search_query = false;
        if ($this->search_query) {
            switch ($this->type_search) {
                case self::SEARCH_TYPE_ID:
                    $ids = explode(' ', $this->search_query);
                    $ids = array_map('intval', $ids);
                    $sql_search_query = '(' . implode(',', $ids) . ')';
                    $sql_type_search = 'p.`id_product` IN';
                    $hash[] = 'type_search-1';
                    break;
                case self::SEARCH_TYPE_NAME:
                case self::SEARCH_TYPE_REFERENCE:
                case self::SEARCH_TYPE_EAN13:
                case self::SEARCH_TYPE_UPC:
                case self::SEARCH_TYPE_DESCRIPTION:
                case self::SEARCH_TYPE_DESCRIPTION_SHORT:
                    if ($this->product_name_type_search == self::PRODUCT_NAME_TYPE_SEARCH_EXACT_MATCH) {
                        $sql_search_query = '"' . pSQL($this->search_query) . '"';
                    } elseif ($this->product_name_type_search == self::PRODUCT_NAME_TYPE_SEARCH_OCCURRENCE) {
                        $sql_search_query = '"%' . pSQL($this->search_query) . '%"';
                    }
                    $sql_type_search = self::$search_type_fields[$this->type_search] . ' LIKE ';
                    break;
                default:
                    throw new LogicException('Unknown search type');
            }
            $hash[] = 'search_query-' . urlencode($this->search_query);
        }

$id_shop = MassEditTools::getIdShopSql();
        $order_by = $this->orderby && $this->orderway ? ' ORDER BY ' . $this->orderby . ' ' . $this->orderway : '';
        if ($order_by == "") {
            $order_by = ' ORDER BY ' . 'id_product' . ' ' . 'ASC';
        }
        $select = 'p.`id_product`,
                p.reference,
                pss.`active`,
                pss.`price`,
                pl.`name`, pl.`link_rewrite`,
                sa.`quantity`,
                cl.`name` as category,
                m.`name` as manufacturer,
                s.`name` as supplier,' . (($sql_carriers !== false) ?
                'c.`name` as carrier,' : '') .
            '(SELECT i.`id_image` FROM ' . _DB_PREFIX_ . 'image i
			 WHERE i.`id_product` = p.`id_product`
			  ORDER BY i.`cover` DESC LIMIT 0,1) cover';

if ($get_total) {
            $select = 'COUNT(p.`id_product`)';
        }

$sql = 'SELECT
                ' . $select . '
            FROM ' . _DB_PREFIX_ . 'product p
            JOIN `' . _DB_PREFIX_ . 'product_shop` pss ON (p.`id_product` = pss.`id_product` AND pss.id_shop = ' . pSQL($id_shop) . ')
            LEFT JOIN ' . _DB_PREFIX_ . 'tax_rules_group trg ON trg.`id_tax_rules_group` = p.`id_tax_rules_group`
            LEFT JOIN ' . _DB_PREFIX_ . 'manufacturer m ON m.`id_manufacturer` = p.`id_manufacturer`
            LEFT JOIN ' . _DB_PREFIX_ . 'supplier s ON s.`id_supplier` = p.`id_supplier`';
        if ($sql_carriers !== false) {
            $sql .= 'LEFT JOIN ' . _DB_PREFIX_ . 'product_carrier pc ON pc.`id_product` = p.`id_product`
            LEFT JOIN ' . _DB_PREFIX_ . 'carrier c on c.`id_carrier` = pc.`id_carrier_reference`';
        }
        if ($this->no_image == 1 || $this->yes_image == 1) {
            $sql .= 'LEFT JOIN ' . _DB_PREFIX_ . 'image pi ON pi.`id_product` = p.`id_product`';
        }
        if ($this->no_discount == 1 || $this->yes_discount == 1) {
            $sql .= 'LEFT JOIN ' . _DB_PREFIX_ . 'specific_price sp ON sp.`id_product` = p.`id_product`';
        }

$sql .= 'LEFT JOIN ' . _DB_PREFIX_ . 'tax t ON t.`id_tax` = p.`id_tax_rules_group`
            LEFT JOIN ' . _DB_PREFIX_ . 'product_lang pl ON p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = ' . (int)$this->context->language->id . ' AND pl.`id_shop` = ' . pSQL($id_shop) . '
            LEFT JOIN ' . _DB_PREFIX_ . 'category_lang cl ON cl.`id_category` = pss.`id_category_default`
             AND cl.`id_lang` = ' . (int)$this->context->language->id . ' AND cl.`id_shop` = ' . pSQL($id_shop) . '
            LEFT JOIN ' . _DB_PREFIX_ . 'stock_available sa ON (sa.`id_product` = p.`id_product`
             AND sa.`id_product_attribute` = 0
            ' . StockAvailable::addSqlShopRestriction(null, null, 'sa') . ')
            WHERE 1
             ' . ($this->no_image ? 'AND pi.cover = 1' : '') . '
             ' . ($this->yes_image ? 'AND cover is null and pi.id_product is null' : '') . '
             
              ' . ($this->yes_discount &&  !$this->no_discount ? 'AND sp.id_product = p.id_product' : '') . '
              ' . ($this->no_discount && !$this->yes_discount ? 'AND sp.id_product is null' : '') . '
           
             
                         
            ' . ($sql_search_query ? 'AND ' . $sql_type_search . ' ' . $sql_search_query . ' ' : '') . '
            ' . ($sql_category ? ('AND ' . (
                $this->search_only_default_category
                    ? 'p.`id_category_default` IN(' . pSQL($sql_category) . ')'
                    : '(SELECT COUNT(cp.`id_category`)
                    FROM ' . _DB_PREFIX_ . 'category_product cp
                     WHERE cp.`id_product` = p.`id_product` AND cp.`id_category` IN(' . pSQL($sql_category) . '))'
                )) : '') . '
            ' . ($sql_manufactures !== false ? 'AND p.`id_manufacturer` IN(' . pSQL($sql_manufactures) . ')' : '') . '
            ' . ($sql_suppliers !== false ? 'AND p.`id_supplier` IN(' . pSQL($sql_suppliers) . ')' : '') . '
            ' . ($sql_carriers !== false ? 'AND c.`id_carrier` IN(' . pSQL($sql_carriers) . ')' : '') . '
            ' . ($this->active && !$this->disable ? ' AND pss.`active` = 1 ' : '') . '
            ' . ($this->disable && !$this->active ? ' AND pss.`active` = 0 ' : '') . '
            ' . (is_array($this->features) && count($this->features) ?
                'AND (SELECT fp.`id_feature`
                FROM ' . _DB_PREFIX_ . 'feature_product fp WHERE fp.`id_product` = p.`id_product`
                AND fp.`id_feature_value` IN (' . implode(',', array_map('intval', $this->features)) . ')) ' : '') . '
            ' . (is_array($this->no_feature_value) && count($this->no_feature_value) ?
                'AND NOT (SELECT COUNT(p2.`id_product`)
            FROM ' . _DB_PREFIX_ . 'product p2 LEFT JOIN ' . _DB_PREFIX_ . 'feature_product fp2 ON p2.`id_product`=fp2.`id_product`
             WHERE fp2.`id_product` = p.`id_product` AND fp2.id_feature
             IN(' . implode(',', array_map('intval', $this->no_feature_value)) . ')) ' : '') . '
            ' . (count($qty_query) ? ' AND ' . implode(' AND ', $qty_query) : '') . '
            ' . (count($date_query) ? ' AND ' . implode(' AND ', $date_query) : '') . '
            ' . (count($price_query) ? ' AND ' . implode(' AND ', $price_query) : '') . '
            ' . (is_array($this->exclude_ids) && count($this->exclude_ids)
                ? ' AND pss.`id_product` NOT IN(' . pSQL(implode(',', $this->exclude_ids)) . ')' : '') . '
             ' . (!$get_total
                ?
                //' GROUP BY p.`id_product` '.
                $order_by
                . ' LIMIT ' . (((int)$this->page - 1) * (int)$this->how_many_show) . ',' . (int)$this->how_many_show : ' ');

return $sql;
    }

public function getHash()
    {
        $hash = array();
        if (is_array($this->categories) && count($this->categories)) {
            $ids_categories = array();
            foreach ($this->categories as $category) {
                $ids_categories[] = (int)$category['id'];
            }
            $hash[] = 'categories-' . implode('_', $ids_categories);
        }

if ($this->qty_from != '') {
            $hash[] = 'qty_from-' . (int)$this->qty_from;
        }

if ($this->qty_to != '') {
            $hash[] = 'qty_to-' . (int)$this->qty_to;
        }

if ($this->price_from != '') {
            $hash[] = 'price_from-' . str_replace('.', '_', (string)$this->price_from);
        }

if ($this->price_to != '') {
            $hash[] = 'price_to-' . str_replace('.', '_', (string)$this->price_to);
        }

if (is_array($this->manufacturers) && count($this->manufacturers)) {
            $hash[] = 'manufacturers-' . implode('_', $this->manufacturers);
        }

if (is_array($this->suppliers) && count($this->suppliers)) {
            $hash[] = 'suppliers-' . implode('_', $this->suppliers);
        }

if (is_array($this->carriers) && count($this->carriers)) {
            $hash[] = 'carriers-' . implode('_', $this->carriers);
        }

if ($this->search_query) {
            switch ($this->type_search) {
                case self::SEARCH_TYPE_ID:
                    $hash[] = 'type_search-1';
                    break;
                case self::SEARCH_TYPE_NAME:
                case self::SEARCH_TYPE_REFERENCE:
                case self::SEARCH_TYPE_EAN13:
                case self::SEARCH_TYPE_UPC:
                case self::SEARCH_TYPE_DESCRIPTION:
                case self::SEARCH_TYPE_DESCRIPTION_SHORT:
                    $hash[] = 'type_search-' . $this->type_search;
                    break;
                default:
                    throw new LogicException('Unknown search type');
            }
            $hash[] = 'search_query-' . urlencode($this->search_query);
        }

$hash[] = 'product_name_type_search-' . $this->product_name_type_search;

if ($this->active) {
            $hash[] = 'active-1';
        }
        if ($this->disable) {
            $hash[] = 'disable-1';
        }
        if ($this->no_image) {
            $hash[] = 'no_image-1';
        }

if ($this->yes_image) {
            $hash[] = 'yes_image-1';
        }
        if ($this->no_discount) {
            $hash[] = 'no_discount-1';
        }

if ($this->yes_discount) {
            $hash[] = 'yes_discount-1';
        }

if ($this->page > 1) {
            $hash[] = 'page-' . $this->page;
        }

if ($this->how_many_show > 20) {
            $hash[] = 'how_many_show-' . $this->how_many_show;
        }
        return $hash;
    }

public function getRequestParam($name, $default = null)
    {
        if (property_exists($this, $name)) {
            return $this->{$name};
        }
        return $default;
    }
}

← 返回文件管理器