getProduct() affiche les categories products et les sous catégorie products

[et-taousy]

je veux dans un catégorie donné, m'affiche que les produits du catégories courant et non pas des sous catégories aussi.

/**
* Return current category products
*
* @param integer $id_lang Language ID
* @param integer $p Page number
* @param integer $n Number of products per page
* @param boolean $get_total return the number of results instead of the results themself
* @param boolean $active return only active products
* @param boolean $random active a random filter for returned products
* @param int $random_number_products number of products to return if random is activated
* @param boolean $check_access set to false to return all products (even if customer hasn't access)
* @return mixed Products or number of products
*/
public function getProducts($id_lang, $p, $n, $order_by = null, $order_way = null, $get_total = false, $active = true, $random = false, $random_number_products = 1, $check_access = true, Context $context = null)
{
if (!$context)
$context = Context::getContext();
if ($check_access && !$this->checkAccess($context->customer->id))
return false;

$front = true;
if (!in_array($context->controller->controller_type, array('front', 'modulefront')))
$front = false;

if ($p < 1) $p = 1;

if (empty($order_by))
$order_by = 'position';
else
/* Fix for all modules which are now using lowercase values for 'orderBy' parameter */
$order_by = strtolower($order_by);

if (empty($order_way))
$order_way = 'ASC';

$order_by_prefix = false;
if ($order_by == 'id_product' || $order_by == 'date_add' || $order_by == 'date_upd')
$order_by_prefix = 'p';
elseif ($order_by == 'name')
$order_by_prefix = 'pl';
elseif ($order_by == 'manufacturer' || $order_by == 'manufacturer_name')
{
$order_by_prefix = 'm';
$order_by = 'name';
}
elseif ($order_by == 'position')
$order_by_prefix = 'cp';

if ($order_by == 'price')
$order_by = 'orderprice';

if (!Validate::isBool($active) || !Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way))
die (Tools::displayError());

$id_supplier = (int)Tools::getValue('id_supplier');

/* Return only the number of products */
if ($get_total)
{
$sql = 'SELECT COUNT(cp.`id_product`) AS total
FROM `'._DB_PREFIX_.'product` p
'.Shop::addSqlAssociation('product', 'p').'
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = '.(int)$this->id.
($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '').
($active ? ' AND product_shop.`active` = 1' : '').
($id_supplier ? 'AND p.id_supplier = '.(int)$id_supplier : '');
return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
}

$sql = 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity'.(Combination::isFeatureActive() ? ', MAX(product_attribute_shop.id_product_attribute) id_product_attribute, MAX(product_attribute_shop.minimal_quantity) AS product_attribute_minimal_quantity' : '').', pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, MAX(image_shop.`id_image`) id_image,
MAX(il.`legend`) as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(),
INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).'
DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `'._DB_PREFIX_.'category_product` cp
LEFT JOIN `'._DB_PREFIX_.'product` p
ON p.`id_product` = cp.`id_product`
'.Shop::addSqlAssociation('product', 'p').
(Combination::isFeatureActive() ? 'LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa
ON (p.`id_product` = pa.`id_product`)
'.Shop::addSqlAssociation('product_attribute', 'pa', false, 'product_attribute_shop.`default_on` = 1').'
'.Product::sqlStock('p', 'product_attribute_shop', false, $context->shop) : Product::sqlStock('p', 'product', false, Context::getContext()->shop)).'
LEFT JOIN `'._DB_PREFIX_.'category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('cl').')
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').')
LEFT JOIN `'._DB_PREFIX_.'image` i
ON (i.`id_product` = p.`id_product`)'.
Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').'
LEFT JOIN `'._DB_PREFIX_.'image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = '.(int)$id_lang.')
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = '.(int)$context->shop->id.'
AND cp.`id_category` = '.(int)$this->id
.($active ? ' AND product_shop.`active` = 1' : '')
.($front ? ' AND product_shop.`visibility` IN ("both", "catalog")' : '')
.($id_supplier ? ' AND p.id_supplier = '.(int)$id_supplier : '')
.' GROUP BY product_shop.id_product';

if ($random === true)
$sql .= ' ORDER BY RAND() LIMIT '.(int)$random_number_products;
else
$sql .= ' ORDER BY '.(!empty($order_by_prefix) ? $order_by_prefix.'.' : '').'`'.bqSQL($order_by).'` '.pSQL($order_way).'
LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n;

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
if ($order_by == 'orderprice')
Tools::orderbyPrice($result, $order_way);

if (!$result)
return array();

/* Modify SQL result */
return Product::getProductsProperties($id_lang, $result);
}

Edited March 6, 2015 by et-taousy (see edit history)

[et-taousy]

svpp c'est urgenttttttttt. d'ou je peux faire la modification , pour n'afficher que les produits du catégorie selectionné. Requete quand je change Categorie.php rien n'apparesse.

 

Mercciiiiii.

[Lactor]

Hi,

I don't think you'll get any answer here, your post is in french, but we are in the english forum. Please comment in the right section.

 

Regards,

Okar

[et-taousy]

I posted in frensh and english but there is no responce,

thanks for any help.

https://www.prestashop.com/forums/topic/422998-catagory-and-sub-category-products/

[Lactor]

You posted twice in english forum, in french : https://www.prestashop.com/forums/topic/423423-categorie-et-sous-categories-produits/  \-:

You should post in french forum, if you're french.

Moreover, you multiply topics for the same problem. Post once in each section (once in french in the french forum, once in english, in english forum), and wait until a generous and skilled soul answer you...

 

Regards,

Okar