i want to display all latest products and i want that the products that have special price to not be shown here!
I have modified in catalog/model/product.php-> getLatestProducts function
Code: Select all
foreach ($query->rows as $result) {
$product_data[$result['product_id']] = $this->getProduct($result['product_id']);
}
with
Code: Select all
foreach ($query->rows as $result) {
//$this->log->debug("SELECT product_id FROM ". DB_PREFIX ."product_special WHERE product_id =".$result['product_id']);
$queryCheckSpecial = $this->db->query("SELECT product_id FROM ". DB_PREFIX ."product_special WHERE product_id =".$result['product_id']);
if (!$queryCheckSpecial->row){
$product_data[$result['product_id']] = $this->getProduct($result['product_id']);
}else{
continue;
}
}
any help will be appreciated !
thak you