Jump to content

Problème des déclinaisons

IBB
 Share

Recommended Posts

IBB Apprentice

IBB

Posted
Posted

Bonsoir,

J'ai un problème avec mes déclinaisons. En effet, dans ma boutique certains produits sont définis avec des déclinaisons dont les attributs sont définis tels que : Style du cadre (sans cadre, cadre simple, ...), Couleur du cadre (blanc, noir, ....). Logiquement quand on selectionne un cadre on doit pouvoir selectionner la couleur correspondante. Mais depuis un certain temps, j'ai un sérieux problème avec l'attribut Style du cadre. À chaque fois que je clique sur le style pour le selectionner je reçois une erreur dans la console du navigateur et donc le changement ne s'effectue plus. Peu importe où tu cliques le style ne change pas.

att.png.39940818197dd25660aba156dc46937d.png

Voici en image l'erreur sur la console à chaque clique :  

error500.thumb.png.5f582a1bf525cca770350ad1a3a8af18.png

Du coup, je me demande si quelqu'un ici à une idée de ce qui se passe. 

Je sollicite votre aide pour ce sérieux problème. Merci !

Link to comment
Share on other sites
IBB Apprentice

IBB

Posted
  • Author
Posted

Je pense que le problème venais de override ProductController.php. Quand je l'ai désactivé tout fonctionne à la merveille enfin !

Merci infinement Mr Alexandre Carette !!!!! 

Link to comment
Share on other sites
IBB Apprentice

IBB

Posted
  • Author
Posted

Justement j'ai remarqué qu'il y a eu un agustement du contenu par rapport à un Backup que j'ai fait il y a quelques mois. Je vous mets le code mais c'est un peu long quand même.

  

<?php
/**
 * 2007-2018 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 [email protected] 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 <[email protected]>
 * @copyright 2007-2018 PrestaShop SA
 * @license   http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

use PrestaShop\PrestaShop\Adapter\Product\PriceFormatter;
use PrestaShop\PrestaShop\Adapter\Image\ImageRetriever;
use PrestaShop\PrestaShop\Core\Product\ProductExtraContentFinder;
use PrestaShop\PrestaShop\Core\Product\ProductListingPresenter;
use PrestaShop\PrestaShop\Adapter\Product\ProductColorsRetriever;
use PrestaShop\PrestaShop\Core\Addon\Module\ModuleManagerBuilder;
use PrestaShop\PrestaShop\Core\Product\ProductInterface;

class ProductController extends ProductControllerCore
{
	protected $quantity_discounts;
	public function init()
	{
		$this->context->cookie->id_unique_ipa = 0;
        $this->context->cookie->write();
		$link_rewrite = Tools::safeOutput(urldecode(Tools::getValue('product_rewrite')));
		$prod_pattern = '/.*?\/([0-9]+)\-([_a-zA-Z0-9-\pL]*)\.html/';
		preg_match($prod_pattern, $_SERVER['REQUEST_URI'], $url_array);

		if (isset($url_array[2]) && $url_array[2] != '') {
			$link_rewrite = $url_array[2];
		}
		
		if ($link_rewrite) {
			$id_lang = $this->context->language->id;
			$id_shop = $this->context->shop->id;
			$sql = 'SELECT id_product
					FROM '._DB_PREFIX_.'product_lang
					WHERE link_rewrite = \''.pSQL($link_rewrite).'\' AND id_lang = '.(int)$id_lang.' AND id_shop = '.(int)$id_shop;
			$id_product = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
			if ($id_product > 0) {
				$_POST['id_product'] = $id_product;
				$_GET['product_rewrite'] = '';
			} else {
				$prod_pattern_sec = '/.*?\/([0-9]+)\-([_a-zA-Z0-9-\pL]*\-[0-9\pL]*)\.html/';
				preg_match($prod_pattern_sec, $_SERVER['REQUEST_URI'], $url_array_sec);
			
				if (isset($url_array_sec[2]) && $url_array_sec[2] != '') {
					$segments = explode('-', $url_array_sec[2]);
					array_pop($segments);
					$link_rewrite = implode('-', $segments);
				}
				$sql = 'SELECT id_product
					FROM '._DB_PREFIX_.'product_lang
					WHERE link_rewrite = \''.pSQL($link_rewrite).'\' AND id_lang = '.(int)$id_lang.' AND id_shop = '.(int)$id_shop;
				$id_product = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
				if ($id_product > 0) {
					$_POST['id_product'] = $id_product;
					$_GET['product_rewrite'] = '';
				}
			}
		}
		$allow_accented_chars = (int)Configuration::get('PS_ALLOW_ACCENTED_CHARS_URL');
		if ($allow_accented_chars > 0) {
			$id_product = (int)Tools::getValue('id_product');
			if ($id_product <= 0) {
				$id = (int)$this->crawlDbForId($_GET['product_rewrite']);
				if ($id > 0) {
					$_POST['id_product'] = $id;
				}
			}
		}
		parent::init();
	}
	
	public function getTemplateVarProduct()
    {
        $productSettings = $this->getProductPresentationSettings();
        $extraContentFinder = new ProductExtraContentFinder();
		$_id_ipa = (int)Context::getContext()->cookie->__get('id_unique_ipa');
		$requestedIdProductAttribute = 0;
		$group = Tools::getValue('group');
		$id_product = (int)Tools::getValue('id_product');
		if (isset($_POST['ajax']) && !empty($group)) {
			if (Tools::version_compare(_PS_VERSION_, '8.0.0', '>=')) {
				$requestedIdProductAttribute = (int) Product::getIdProductAttributeByIdAttributes(
                    $id_product,
                    $group
                );
			}
			else {
				$requestedIdProductAttribute = (int) Product::getIdProductAttributesByIdAttributes(
                    $id_product,
                    $group
                );
			}
		}
        $product = $this->objectPresenter->present($this->product);
        $product['id_product'] = (int) $this->product->id;
        $product['out_of_stock'] = (int) $this->product->out_of_stock;
        $product['new'] = (int) $this->product->new;
		if (Tools::version_compare(_PS_VERSION_, '1.7.4.0', '<')) {
			$product['id_product_attribute'] = ($_id_ipa > 0) ? $_id_ipa : $this->getIdProductAttribute();
		}
		else {
			$product['id_product_attribute'] = ($requestedIdProductAttribute > 0) ? $requestedIdProductAttribute : $this->getIdProductAttribute();
		}
        $product['minimal_quantity'] = $this->getProductMinimalQuantity($product);
        $product['quantity_wanted'] = $this->getRequiredQuantity($product);
        $product['extraContent'] = $extraContentFinder->addParams(array('product' => $this->product))->present();
		$product['ecotax'] = Tools::convertPrice((float) $product['ecotax'], $this->context->currency, true, $this->context);
        $product_full = Product::getProductProperties($this->context->language->id, $product, $this->context);

        $product_full = $this->addProductCustomizationData($product_full);

        $product_full['show_quantities'] = (bool) (
            Configuration::get('PS_DISPLAY_QTIES')
            && Configuration::get('PS_STOCK_MANAGEMENT')
            && $this->product->quantity > 0
            && $this->product->available_for_order
            && !Configuration::isCatalogMode()
        );
        $product_full['quantity_label'] = ($this->product->quantity > 1) ? $this->trans('Items', array(), 'Shop.Theme.Catalog') : $this->trans('Item', array(), 'Shop.Theme.Catalog');
        $product_full['quantity_discounts'] = $this->quantity_discounts;

        if ($product_full['unit_price_ratio'] > 0) {
            $unitPrice = ($productSettings->include_taxes) ? $product_full['price'] : $product_full['price_tax_exc'];
            $product_full['unit_price'] = $unitPrice / $product_full['unit_price_ratio'];
        }

        $group_reduction = GroupReduction::getValueForProduct($this->product->id, (int) Group::getCurrent()->id);
        if ($group_reduction === false) {
            $group_reduction = Group::getReduction((int) $this->context->cookie->id_customer) / 100;
        }
        $product_full['customer_group_discount'] = $group_reduction;
		$product_full['title'] = $this->getProductPageTitle();
		
		// round display price (without formatting, we don't want the currency symbol here, just the raw rounded value
        $product_full['rounded_display_price'] = Tools::ps_round(
            $product_full['price'],
            Context::getContext()->currency->precision
        );
		
        $presenter = $this->getProductPresenter();
		Context::getContext()->cookie->__unset('id_unique_ipa');
        return $presenter->present(
            $productSettings,
            $product_full,
            $this->context->language
        );
    }
	
	private function getProductPageTitle(array $meta = null)
    {
        $title = $this->product->name;
        if (isset($meta['title'])) {
            $title = $meta['title'];
        } elseif (isset($meta['meta_title'])) {
            $title = $meta['meta_title'];
        }
        if (!Configuration::get('PS_PRODUCT_ATTRIBUTES_IN_TITLE')) {
            return $title;
        }

        $idProductAttribute = $this->getIdProductAttributeByGroupOrRequestOrDefault();
        if ($idProductAttribute) {
            $attributes = $this->product->getAttributeCombinationsById($idProductAttribute, $this->context->language->id);
            if (is_array($attributes) && count($attributes) > 0) {
                foreach ($attributes as $attribute) {
                    $title .= ' ' . $attribute['group_name'] . ' ' . $attribute['attribute_name'];
                }
            }
        }

        return $title;
    }
	
	private function getIdProductAttribute()
    {
        $requestedIdProductAttribute = (int)Tools::getValue('id_product_attribute');

        if (!Configuration::get('PS_DISP_UNAVAILABLE_ATTR')) {
            $productAttributes = array_filter(
                $this->product->getAttributeCombinations(),
                function ($elem) {
                    return $elem['quantity'] > 0;
                });
            $productAttribute = array_filter(
                $productAttributes,
                function ($elem) use ($requestedIdProductAttribute) {
                    return $elem['id_product_attribute'] == $requestedIdProductAttribute;
                });
            if (empty($productAttribute) && !empty($productAttributes)) {
                return (int)array_shift($productAttributes)['id_product_attribute'];
            }
        }
        return $requestedIdProductAttribute;
    }
	
	public function displayAjaxRefresh()
    {
		$requestedIdProductAttribute = 0;
		$isPreview = ('1' === Tools::getValue('preview'));
		$group = Tools::getValue('group');
		$id_product = (int)Tools::getValue('id_product');
		if (!empty($group)) {
			if (Tools::version_compare(_PS_VERSION_, '8.0.0', '>=')) {
				$requestedIdProductAttribute = (int) Product::getIdProductAttributeByIdAttributes(
                    $id_product,
                    $group
                );
			}
			else {
				$requestedIdProductAttribute = (int) Product::getIdProductAttributesByIdAttributes(
                    $id_product,
                    $group
                );
			}
		}
		$_id_ipa = (int)Context::getContext()->cookie->__get('id_unique_ipa');
		$product = $this->getTemplateVarProduct();
		if (Tools::version_compare(_PS_VERSION_, '1.7.4.0', '<')) {
			$product['id_product_attribute'] = ($_id_ipa > 0) ? $_id_ipa : $product['id_product_attribute'];
		}
		else {
			$product['id_product_attribute'] = ($requestedIdProductAttribute > 0) ? $requestedIdProductAttribute : $product['id_product_attribute'];
			$this->context->cookie->id_unique_ipa = $product['id_product_attribute'];
			$this->context->cookie->write();
		}
        
        $minimalProductQuantity = $this->getMinimalProductOrDeclinationQuantity($product);
        ob_end_clean();
        header('Content-Type: application/json');
		if (Tools::version_compare(_PS_VERSION_, '8.0.0', '>=')) {
			$isQuickView = ('1' === Tools::getValue('quickview'));
			if ($isQuickView) {
				$this->setQuickViewMode();
			}
			$this->ajaxRender(json_encode([
				'product_prices' => $this->render('catalog/_partials/product-prices'),
				'product_cover_thumbnails' => $this->render('catalog/_partials/product-cover-thumbnails'),
				'product_customization' => $this->render(
					'catalog/_partials/product-customization',
					array(
						'customizations' => $product['customizations'],
					)
				),
				'product_details' => $this->render('catalog/_partials/product-details'),
				'product_variants' => $this->render('catalog/_partials/product-variants'),
				'product_discounts' => $this->render('catalog/_partials/product-discounts'),
				'product_add_to_cart' => $this->render('catalog/_partials/product-add-to-cart'),
				'product_additional_info' => $this->render('catalog/_partials/product-additional-info'),
				'product_images_modal' => $this->render('catalog/_partials/product-images-modal'),
				'product_url' => $this->context->link->getProductLink(
					$product['id_product'],
					null,
					null,
					null,
					$this->context->language->id,
					null,
					$product['id_product_attribute'],
					false,
					false,
					true,
					$isPreview ? array('preview' => '1') : array()
				),
				'product_minimal_quantity' => $minimalProductQuantity,
				'product_has_combinations' => !empty($this->combinations),
				'id_product_attribute' => $product['id_product_attribute'],
				'id_customization' => $product['id_customization'],
				'product_title' => $this->getProductPageTitle(
					$this->getTemplateVarPage()['meta'] ?? []
				),
				'is_quick_view' => $isQuickView,
				]
			));
		}
		else {
			echo Tools::jsonEncode(array(
				'product_prices' => $this->render('catalog/_partials/product-prices'),
				'product_cover_thumbnails' => $this->render('catalog/_partials/product-cover-thumbnails'),
				'product_customization' => $this->render(
					'catalog/_partials/product-customization',
					array(
						'customizations' => $product['customizations'],
					)
				),
				'product_details' => $this->render('catalog/_partials/product-details'),
				'product_variants' => $this->render('catalog/_partials/product-variants'),
				'product_discounts' => $this->render('catalog/_partials/product-discounts'),
				'product_add_to_cart' => $this->render('catalog/_partials/product-add-to-cart'),
				'product_additional_info' => $this->render('catalog/_partials/product-additional-info'),
				'product_images_modal' => $this->render('catalog/_partials/product-images-modal'),
				'product_url' => $this->context->link->getProductLink(
					$product['id_product'],
					null,
					null,
					null,
					$this->context->language->id,
					null,
					$product['id_product_attribute'],
					false,
					false,
					true,
					$isPreview ? array('preview' => '1') : array()
				),
				'product_minimal_quantity' => $minimalProductQuantity,
				'product_has_combinations' => !empty($this->combinations),
				'id_product_attribute' => $product['id_product_attribute'],
			));
		}
		
        die();
    }

	protected function assignPriceAndTax()
    {
        $id_customer = (isset($this->context->customer) ? (int) $this->context->customer->id : 0);
        $id_group = (int) Group::getCurrent()->id;
        $id_country = $id_customer ? (int) Customer::getCurrentCountry($id_customer) : (int) Tools::getCountry();

        $tax = (float) $this->product->getTaxesRate(new Address((int) $this->context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')}));
        $this->context->smarty->assign('tax_rate', $tax);

        $product_price_with_tax = Product::getPriceStatic($this->product->id, true, null, 6);
        if (Product::$_taxCalculationMethod == PS_TAX_INC) {
            $product_price_with_tax = Tools::ps_round($product_price_with_tax, 2);
        }

        $id_currency = (int) $this->context->cookie->id_currency;
        $id_product = (int) $this->product->id;
        $id_product_attribute = Tools::getValue('id_product_attribute', null);
        $id_shop = $this->context->shop->id;

        $quantity_discounts = SpecificPrice::getQuantityDiscounts($id_product, $id_shop, $id_currency, $id_country, $id_group, $id_product_attribute, false, (int) $this->context->customer->id);
        foreach ($quantity_discounts as &$quantity_discount) {
            if ($quantity_discount['id_product_attribute']) {
                $combination = new Combination((int) $quantity_discount['id_product_attribute']);
                $attributes = $combination->getAttributesName((int) $this->context->language->id);
                foreach ($attributes as $attribute) {
                    $quantity_discount['attributes'] = $attribute['name'].' - ';
                }
                $quantity_discount['attributes'] = rtrim($quantity_discount['attributes'], ' - ');
            }
            if ((int) $quantity_discount['id_currency'] == 0 && $quantity_discount['reduction_type'] == 'amount') {
                $quantity_discount['reduction'] = Tools::convertPriceFull($quantity_discount['reduction'], null, Context::getContext()->currency);
            }
        }

        $product_price = $this->product->getPrice(Product::$_taxCalculationMethod == PS_TAX_INC, false);
        $this->quantity_discounts = $this->formatQuantityDiscounts($quantity_discounts, $product_price, (float) $tax, $this->product->ecotax);

        $this->context->smarty->assign(array(
            'no_tax' => Tax::excludeTaxeOption() || !$tax,
            'tax_enabled' => Configuration::get('PS_TAX') && !Configuration::get('AEUC_LABEL_TAX_INC_EXC'),
            'customer_group_without_tax' => Group::getPriceDisplayMethod($this->context->customer->id_default_group),
        ));
    }
	
	protected function crawlDbForId($rew)
	{
		$id_lang = $this->context->language->id;
		$id_shop = $this->context->shop->id;
		$sql = new DbQuery();
        $sql->select('`id_product`');
        $sql->from('product_lang');
		$sql->where('`id_lang` = '.(int)$id_lang.' AND `id_shop` = '.(int)$id_shop.' AND `link_rewrite` = "'.pSQL($rew).'"');
		return Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
	}
}

 

Link to comment
Share on other sites
IBB Apprentice

IBB

Posted
  • Author
Posted
22 minutes ago, Alexandre Carette said:

essaye ca peut etre ligne 100 

	public function getTemplateVarProduct()
    {
        $productSettings = $this->getProductPresentationSettings();
        $extraContentFinder = new ProductExtraContentFinder();
		$_id_ipa = (int)Context::getContext()->cookie->__get('id_unique_ipa');
		$requestedIdProductAttribute = 0;
		$group = Tools::getValue('group');
		// Modif code Alexandre Carette
		// On teste group
		if (isset($group && $group)) {
			$group = $group
		} else {
			$group = 0;
		}

... reste du code

Oui ligne 92. Donc je retire cette fonction et je garde le reste du code n'est-ce pas

Link to comment
Share on other sites
IBB Apprentice

IBB

Posted
  • Author
Posted
9 minutes ago, Alexandre Carette said:

non tu ajoutes juste ca apres $group = Tools::getValue('group'); 

... code

// On teste group
		if (isset($group && $group)) {
			$group = $group
		} else {
			$group = 0;
		}

... reste du code

 

J'ai effectué la modification mais malheureusement cela engendre toujours la même erreur. Du coup je demande si c'est pas mieux que garde le fichier désactivé

Link to comment
Share on other sites
Alexandre Carette Collaborator

Alexandre Carette

Posted
Posted (edited)

(mon code d avant est faux) as tu un override de la classe Product.php ? /overrides/classes/Product.php, si oui y a t il une fonction nommée getIdProductAttributesByIdAttributes() ? car cette fonction n existe pas dans la classe native d un Prestashop 8

désolé dans le message d'erreur c'est une classe core sans override, le pb est que dans ce fichier il y a une fonction qui s'appelle  getIdProductAttributesByIdAttributes( $id_product, $group ) , si cette fonction ne trouve pas l'id product attribute, il retourne une exception, donc il faudrait overrider cette fonction pour ne pas retourner une erreur mais un 0 par exemple.

faire un override de Product.php 

public function getIdProductAttributesByIdAttributes( $id_product, $group ) {

...

if (empty($idProductAttribute)) {

// throwNewPrestashopObjectNotFoundException('bla bla');

return 0;

}

return $idProductAttribute;

...

 

Edited by Alexandre Carette (see edit history)
Link to comment
Share on other sites
IBB Apprentice

IBB

Posted
  • Author
Posted
45 minutes ago, Alexandre Carette said:

(mon code d avant est faux) as tu un override de la classe Product.php ? /overrides/classes/Product.php, si oui y a t il une fonction nommée getIdProductAttributesByIdAttributes() ? car cette fonction n existe pas dans la classe native d un Prestashop 8

désolé dans le message d'erreur c'est une classe core sans override, le pb est que dans ce fichier il y a une fonction qui s'appelle  getIdProductAttributesByIdAttributes( $id_product, $group ) , si cette fonction ne trouve pas l'id product attribute, il retourne une exception, donc il faudrait overrider cette fonction pour ne pas retourner une erreur mais un 0 par exemple.

faire un override de Product.php 

public function getIdProductAttributesByIdAttributes( $id_product, $group ) {

...

if (empty($idProductAttribute)) {

// throwNewPrestashopObjectNotFoundException('bla bla');

return 0;

}

return $idProductAttribute;

...

 

Salut ! C'est pas un souci 😀!

Oui le fichier  /override/classes/Product.php existe bien mais la fonction getIdProductAttributesByIdAttributes() n'est pas overridée. Mais elle est définie de cette façon dans la classe mère ProductCore :  

public static function getIdProductAttributesByIdAttributes($id_product, $id_attributes, $find_best = false)
    {
        return self::getIdProductAttributeByIdAttributes($id_product, $id_attributes, $find_best);
    }

Comme vous le disiez plus tôt, dans le fichier override/controllers/front/ProductController.php où elle a été appelé, elle est barrée parce qu'elle est obsolète suite à cet teste  

if (Tools::version_compare(_PS_VERSION_, '8.0.0', '>='))

Et c'est la méthode de la classe mère qui est appelé. 

Donc je pense que le problème viens du fait qu'elle soit obsolète ou bien le retour de cette fonction est vide  

return self::getIdProductAttributeByIdAttributes($id_product, $id_attributes, $find_best);

Et si c'est le cas alors le problème viendrait sûrement de la fonction getIdProductAttributeByIdAttributes ()  

Et voici le contenu de cette fonction :  

 public static function getIdProductAttributeByIdAttributes($idProduct, $idAttributes, $findBest = false)
    {
        $idProduct = (int) $idProduct;

        if (!is_array($idAttributes) && is_numeric($idAttributes)) {
            $idAttributes = [(int) $idAttributes];
        }

        if (!is_array($idAttributes) || empty($idAttributes)) {
            throw new PrestaShopException(sprintf('Invalid parameter $idAttributes with value: "%s"', print_r($idAttributes, true)));
        }

        $idAttributesImploded = implode(',', array_map('intval', $idAttributes));
        $idProductAttribute = Db::getInstance()->getValue(
            '
            SELECT
                pac.`id_product_attribute`
            FROM
                `' . _DB_PREFIX_ . 'product_attribute_combination` pac
                INNER JOIN `' . _DB_PREFIX_ . 'product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
            WHERE
                pa.id_product = ' . $idProduct . '
                AND pac.id_attribute IN (' . $idAttributesImploded . ')
            GROUP BY
                pac.`id_product_attribute`
            HAVING
                COUNT(pa.id_product) = ' . count($idAttributes)
        );

        if ($idProductAttribute === false && $findBest) {
            //find the best possible combination
            //first we order $idAttributes by the group position
            $orderred = [];
            $result = Db::getInstance()->executeS(
                '
                SELECT
                    a.`id_attribute`
                FROM
                    `' . _DB_PREFIX_ . 'attribute` a
                    INNER JOIN `' . _DB_PREFIX_ . 'attribute_group` g ON a.`id_attribute_group` = g.`id_attribute_group`
                WHERE
                    a.`id_attribute` IN (' . $idAttributesImploded . ')
                ORDER BY
                    g.`position` ASC'
            );

            foreach ($result as $row) {
                $orderred[] = $row['id_attribute'];
            }

            while ($idProductAttribute === false && count($orderred) > 1) {
                array_pop($orderred);
                $idProductAttribute = Db::getInstance()->getValue(
                    '
                    SELECT
                        pac.`id_product_attribute`
                    FROM
                        `' . _DB_PREFIX_ . 'product_attribute_combination` pac
                        INNER JOIN `' . _DB_PREFIX_ . 'product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
                    WHERE
                        pa.id_product = ' . (int) $idProduct . '
                        AND pac.id_attribute IN (' . implode(',', array_map('intval', $orderred)) . ')
                    GROUP BY
                        pac.id_product_attribute
                    HAVING
                        COUNT(pa.id_product) = ' . count($orderred)
                );
            }
        }

        if (empty($idProductAttribute)) {
            throw new PrestaShopObjectNotFoundException('Can not retrieve the id_product_attribute');
        }

        return $idProductAttribute;
    }

 

Link to comment
Share on other sites
Alexandre Carette Collaborator

Alexandre Carette

Posted
Posted

essaye de remplacer la fonction de l'override par  

public static function getIdProductAttributeByIdAttributes($idProduct, $idAttributes, $findBest = false)
    {
        $idProduct = (int) $idProduct;

        if (!is_array($idAttributes) && is_numeric($idAttributes)) {
            $idAttributes = [(int) $idAttributes];
        }

        if (!is_array($idAttributes) || empty($idAttributes)) {
            throw new PrestaShopException(sprintf('Invalid parameter $idAttributes with value: "%s"', print_r($idAttributes, true)));
        }

        $idAttributesImploded = implode(',', array_map('intval', $idAttributes));
        $idProductAttribute = Db::getInstance()->getValue(
            '
            SELECT
                pac.`id_product_attribute`
            FROM
                `' . _DB_PREFIX_ . 'product_attribute_combination` pac
                INNER JOIN `' . _DB_PREFIX_ . 'product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
            WHERE
                pa.id_product = ' . $idProduct . '
                AND pac.id_attribute IN (' . $idAttributesImploded . ')
            GROUP BY
                pac.`id_product_attribute`
            HAVING
                COUNT(pa.id_product) = ' . count($idAttributes)
        );

        if ($idProductAttribute === false && $findBest) {
            //find the best possible combination
            //first we order $idAttributes by the group position
            $orderred = [];
            $result = Db::getInstance()->executeS(
                '
                SELECT
                    a.`id_attribute`
                FROM
                    `' . _DB_PREFIX_ . 'attribute` a
                    INNER JOIN `' . _DB_PREFIX_ . 'attribute_group` g ON a.`id_attribute_group` = g.`id_attribute_group`
                WHERE
                    a.`id_attribute` IN (' . $idAttributesImploded . ')
                ORDER BY
                    g.`position` ASC'
            );

            foreach ($result as $row) {
                $orderred[] = $row['id_attribute'];
            }

            while ($idProductAttribute === false && count($orderred) > 1) {
                array_pop($orderred);
                $idProductAttribute = Db::getInstance()->getValue(
                    '
                    SELECT
                        pac.`id_product_attribute`
                    FROM
                        `' . _DB_PREFIX_ . 'product_attribute_combination` pac
                        INNER JOIN `' . _DB_PREFIX_ . 'product_attribute` pa ON pa.id_product_attribute = pac.id_product_attribute
                    WHERE
                        pa.id_product = ' . (int) $idProduct . '
                        AND pac.id_attribute IN (' . implode(',', array_map('intval', $orderred)) . ')
                    GROUP BY
                        pac.id_product_attribute
                    HAVING
                        COUNT(pa.id_product) = ' . count($orderred)
                );
            }
        }

        if (empty($idProductAttribute)) {
            //throw new PrestaShopObjectNotFoundException('Can not retrieve the id_product_attribute');
            return 0;
        }

        return $idProductAttribute;
    }

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...