language->id, 0, 0, 'id_product', 'ASC'); $query = " SELECT `product_id`, COUNT(*) as `count` FROM `ps_order_detail` GROUP BY `product_id` ORDER BY `count` DESC, `product_id` ASC LIMIT 72 "; $products = Db::getInstance()->executeS($query); $productIds = array(); foreach ($products as $product) { $productIds[] = $product['product_id']; } // Iteruj po produktach foreach ($allProducts as $product) { // $productId = $product['product_id']; $productId = $product['id_product']; // Produkt jest w kategorii "NOWOŚCI", dodaj go do kategorii $isProductInCategory = Db::getInstance()->getValue( "SELECT COUNT(*) FROM " . _DB_PREFIX_ . "category_product WHERE id_category = $categoryId AND id_product = $productId" ); // Sprawdzamy czy produkt jest w nowej liście "BESTSELLERS" if (in_array($productId, $productIds)) { // Sprawdzamy czy on ma już przepisaną kategorie BESTSELLERS" if ($isProductInCategory == 0) { Db::getInstance()->execute( "INSERT INTO " . _DB_PREFIX_ . "category_product (id_category, id_product) VALUES ($categoryId, $productId)" ); } } else { Db::getInstance()->execute( "DELETE FROM " . _DB_PREFIX_ . "category_product WHERE id_category = $categoryId AND id_product = $productId" ); } // echo "

";
  // print_r($productId);
  // echo "";
}