Prestashop 1.7.6.5 - How to add variable and pass it to products on product listings (category,brands,etc).

[Fadlan]

I'm out of options,
With some help I made the code that adds my variable inside ProductController override:
 

    /*Dodatkowa cena SMEG*/
    public function initContent() {
        parent::initContent();

        if ($this->product) {
            // Load your custom variable from the database based on $this->product->id
            $smegOriginalPrice = $this->loadSmegOriginalPriceFromDb($this->product->id);

            // Assign the custom variable to Smarty
            $this->context->smarty->assign(array(
                'smegOriginalPrice' => $smegOriginalPrice,
            ));
        }
    }

    private function loadSmegOriginalPriceFromDb($productId) {
        $db = \Db::getInstance();
        $smegPrice = $db->getRow('SELECT original_price FROM `'._DB_PREFIX_.'product_smeg_prices` WHERE id_product = '.(int)$productId);
        if($smegPrice){
            $smegPrice = floatval($smegPrice['original_price']);
            $formatted = Context::getContext()->getCurrentLocale()->formatPrice($smegPrice, 'PLN');
            return $formatted;
        } else {
            return NULL;
        }
    }

 

This works properly for product page tpl and {$smegOriginalPrice} returns correct value.

I tried to use same tactics for CategoryController override but it failed, and returns only empty array for {$product.smegOriginalPrice}

    public function initContent() {
        parent::initContent();

        // Assuming you have access to the products list, e.g., $this->cat_products
        $products = $this->category->getProducts($this->context->language->id, 1, 1000);

        foreach ($products as &$product) {
            $smegOriginalPrice = $this->loadSmegOriginalPriceFromDb($product['id_product']);
            $product['smegOriginalPrice'] = $smegOriginalPrice;
        }

        // Assign the custom variable to Smarty
        $this->context->smarty->assign(array(
            'products' => $products,
        ));

    }

    private function loadSmegOriginalPriceFromDb($productId) {
        $db = \Db::getInstance();
        $smegPrice = $db->getRow('SELECT original_price FROM `'._DB_PREFIX_.'product_smeg_prices` WHERE id_product = '.(int)$productId);
        if($smegPrice){
            $smegPrice = floatval($smegPrice['original_price']);
            $formatted = Context::getContext()->getCurrentLocale()->formatPrice($smegPrice, 'PLN');
            return $formatted;
        } else {
            return NULL;
        }
    }

 

 

Is there a unified way to pass variable to product object? I have no idea how to progress, please help.

 

 

[byhero41]

        foreach ($products as &$product) {
            $smegOriginalPrice = $this->loadSmegOriginalPriceFromDb($product['id_product']);
            array_push($product['smegOriginalPrice'],$smegOriginalPrice);
        }

Maybe this code can work