/**
* This function is used to show the view product
*
*
* @return string
*/
function viewProducts()
{
$id = (int) $_GET['subcatid'];
if (isset($_GET['rtype'])) {
$get = $_GET['rtype'];
if (array_key_exists($get, $_SESSION['search_option'])) {
$search = $_SESSION['search_option'];
unset($search[$get]);
$_SESSION['search_option'] = $search;
if ($_GET['rtype'] == "Price") {
$_SESSION['range'] = "";
}
}
}
if (!isset($_SESSION['search_option'])) {
$_SESSION['search_option'] = array();
}
if (array_key_exists($_GET['type'], $_SESSION['search_option'])) {
$div = '';
} else {
$arr = $_SESSION['search_option'];
$arr[$_GET['type']] = $_GET['val'];
$_SESSION['search_option'] = $arr;
if ($_GET['type'] == 'Price') {
$_SESSION['range'] = $_GET['range'];
}
}
$searchoption = $_SESSION['search_option'];
$arr = "";
for ($i = 0; $i < count($searchoption); $i++) {
$key = key($searchoption);
$val = $searchoption[$key];
if ($key != '' && $key != 'Brand' && $key != 'Price') {
if ($i != 0) {
$arr .= " attrib_value_id=" . $val . " AND";
}
}
next($searchoption);
}
if (is_int($id) && $id > 0) {
$sql = 'SELECT * from products_table where';
$sql .= ' product_id IN (';
$sql .= Core_CFeaturedItems::evaluate($id);
$sql .= ' )';
$query = new Bin_Query();
if ($query->executeQuery($sql)) {
return Display_DFeaturedItems::viewProducts($query->records);
} else {
return '<div align="center"><font color="orange" size=2><b>No Records Found</b></div>';
}
}
}
