/** * This function is used to show the last viewed products * * @return string */ function lastViewedProducts() { $cnt = count($_SESSION['LastViewed']); if ($cnt > 4) { $j = $cnt - 1; while ($k < 4) { $arr[$j] = $_SESSION['LastViewed'][$j]; $j--; $k++; } } else { for ($i = 0; $i < $cnt; $i++) { $arr[$i] = $_SESSION['LastViewed'][$i]; } } if ($arr != '') { $product_ids = '"' . implode('","', $arr) . '"'; $sql = "SELECT a.product_id,a.title,a.thumb_image,a.msrp,b.soh,sum(c.rating)/count(c.user_id) as\n\t\t\trating FROM products_table as a INNER JOIN product_inventory_table as b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE a.product_id in(" . $product_ids . ") and a.intro_date <= '" . date('Y-m-d') . "' AND a.status=1 group by a.product_id ORDER BY title ASC"; $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_CLastViewedProducts::disRates($prid); if ($minval > 0 or $minval != '') { //$r[$j]['msrp']= '$'.number_format($row['msrp'],2).' - $'.number_format($minval,2); $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++; } $output = Display_DLastViewedProducts::lastViewedProducts($query->records, $r); } } } } else { $output = Display_DLastViewedProducts::lastViewedProductsElse(); } return $output; }