Get max price from product

[Cesarph]

I am trying to display the highest price of the specific product on the product list page.

I tried to add a function but it does not work (Prestashop 1.7.6.2). 

 

For example :

 

I have a product with three  different prices according by dimention :

towel_1 dimention: 16x21  price=5$

towel_1 dimention: 50x100  price=10$

towel_1 dimention: 70x140  price=15$

 

I would like to display the price of 15$ on my catalog of that product.

Can someone help me to create this function ?

Regards,

César

[ps8modules]

https://mypresta.eu/modules/front-office-features/product-price-range-from-to.html

[ps8modules]

$product_prices = array();

    $getProductPrice = Db::getInstance()->executeS('SELECT id_product, price FROM '._DB_PREFIX_.'product')

    foreach ($getProductPrice as $p){
        $getMaxProductPrice = Db::getInstance()->getValue('SELECT MAX(price) as max_pice FROM '._DB_PREFIX_.'product_attribute WHERE id_product = '.$p['id_product']);
        if ($getMaxProductPrice > 0){
            $max = ($getMaxProductPrice + $p['price']);
        } else {
            $max = $p['price'];
        } 
            
        $product_prices[] = array('id_product' => $p['id_product'], 'min_price' => $p['price'], 'max_price' => $max);
    }

    foreach ($product_prices as $product){
        echo 'ID product: '.$product['id_product'].' - from '.$product['min_price'].' to '.$product['max_price'].'<br>';
    }

    //print_r($product_prices);

This is a sample without discounts, only with attributes.

Edited September 29, 2021 by WebSoft (see edit history)

[ps8modules]

Sample show formated price with tax:

<?php
    @ini_set('display_errors', 'on');
@error_reporting(E_ALL | E_STRICT);

    include('./config/config.inc.php');
    include('./init.php');

    $product_prices = array();

    $getProductPrice = Db::getInstance()->executeS('SELECT id_product, price FROM '._DB_PREFIX_.'product');


    foreach ($getProductPrice as $p){
        $getMaxProductPrice = Db::getInstance()->getRow('SELECT * FROM '._DB_PREFIX_.'product_attribute WHERE id_product = '.$p['id_product'].' ORDER BY price DESC');

        if ($getMaxProductPrice['price'] > 0){
            $max = Product::getPriceStatic($p['id_product'], true, $getMaxProductPrice['id_product_attribute']);
        } else {
            $max = Product::getPriceStatic($p['id_product'], true);
        } 
            
        $product_prices[] = array('id_product' => $p['id_product'], 'min_price' => Tools::displayPrice($p['price']), 'max_price' => Tools::displayPrice($max));
    }

    foreach ($product_prices as $product){
        echo 'ID product: '.$product['id_product'].' - from '.$product['min_price'].' to '.$product['max_price'].'<br>';
    }

    //print_r($product_prices);

Result:

Edited September 29, 2021 by WebSoft
update script (see edit history)

[Cesarph]

Hey WebSoft, thank you very much for you reply. i resolved my problem!