/** * This function is used to show the product in home page * * * @return HTML data */ function newProducts() { $sql = " SELECT a.product_id, a.title, a.thumb_image,a.image,a.product_status,a.category_id,a.gift ,a.msrp,a.intro_date,b.soh,sum(c.rating)/count(c.user_id) as rating\tFROM products_table a INNER JOIN\tproduct_inventory_table b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 and a.product_status!='1'and a.gift='0' and product_status!='3' group by a.product_id ORDER BY rand( ) LIMIT 0,12 "; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $j = 0; $cnt = count($query->records); if ($cnt > 0) { for ($i = 0; $i < $cnt; $i++) { foreach ($query->records as $row) { $r[$j] = $row; $prid = $row['product_id']; $minval = Core_CNewProducts::disRates($prid); if ($minval > 0 or $minval != '') { $r[$j]['msrp'] = $_SESSION['currencysetting']['selected_currency_settings']['currency_tocken'] . number_format($row['msrp'] * $_SESSION['currencysetting']['selected_currency_settings']['conversion_rate'], 2) . ' - ' . $_SESSION['currencysetting']['selected_currency_settings']['currency_tocken'] . number_format($minval * $_SESSION['currencysetting']['selected_currency_settings']['conversion_rate'], 2); } else { $r[$j]['msrp'] = $_SESSION['currencysetting']['selected_currency_settings']['currency_tocken'] . number_format($row['msrp'] * $_SESSION['currencysetting']['selected_currency_settings']['conversion_rate'], 2); } $j++; } return Display_DNewProducts::newProducts($query->records, $r); } } } else { return Display_DNewProducts::newProductsElse(); } }