Prestashop 1.7 Get list of Pack Products

[ZiedDams]

Hi ,

can any one help me with this SQL query to select a list of pack products only

i mean this

SELECT id_product from ps_product where ? = ? 

 

[ps8modules]

Hi, choose products in a pack for a specific product?

Why SQL, when Prestashop has functions for it?

[ZiedDams]

Just now, 4you.software said:

Hi, choose products in a pack for a specific product?

Why SQL, when Prestashop has functions for it?

i want to display a list of packs in custom FrontController but i don't know how to get them, if you tell me the function name this will be helpful , thank you

[ps8modules]

Ok.

$id_lang = $this->context->language->id;
$id_product = Tools::getValue('id_product');

if (Pack::isPack($id_product)){
    $pack = Pack::getItems($id_product, $id_lang);
    $this->context->smarty->assign('my_custom_pack', $pack);
}

 

Edited September 21, 2022 by 4you.software (see edit history)

[ps8modules]

for all products sample:

$getPackedProducts = Db::getInstance()->executeS('SELECT id_product_pack FROM '._DB_PREFIX_.'pack GROUP BY id_product_pack');

$pack = array();

$id_lang = $this->context->language->id;

foreach ($getPackedProducts as $product){
    $id_product = $product['id_product_pack'];

    $pack[] = Pack::getItems($id_product, $id_lang);
}

$this->context->smarty->assign('my_custom_pack', $pack);

 

Edited September 21, 2022 by 4you.software (see edit history)

[ZiedDams]

15 hours ago, 4you.software said:

for all products sample:

$getPackedProducts = Db::getInstance()->executeS('SELECT id_product_pack FROM '._DB_PREFIX_.'pack GROUP BY id_product_pack');

$pack = array();

$id_lang = $this->context->language->id;

foreach ($getPackedProducts as $product){
    $id_product = $product['id_product_pack'];

    $pack[] = Pack::getItems($id_product, $id_lang);
}

$this->context->smarty->assign('my_custom_pack', $pack);

 

Thank you so much.

[ps8modules]

I gladly helped 😄