/**
* This function is used to show the main category landing page
*
*
* @return string
*/
function showMainCatLanding()
{
$maincatid = $_GET['maincatid'];
$query = new Bin_Query();
// DONT DELETE below hidden query
//$sql = "SELECT DISTINCT a.category_name AS Category,a.category_id AS maincatid, b.category_name AS SubCategory, b.category_id as subcatid, b.category_image AS image FROM category_table a INNER JOIN category_table b ON a.category_id = b.category_parent_id INNER JOIN products_table AS pt ON b.category_id = pt.category_id WHERE b.category_parent_id=".$maincatid." ";
$sql = "SELECT DISTINCT a.category_name AS Category,a.category_id AS maincatid, b.category_name AS SubCategory, b.category_id as subcatid, b.category_image AS image FROM category_table a INNER JOIN category_table b ON a.category_id = b.category_parent_id WHERE b.category_parent_id=" . $maincatid . " AND b.category_status=1 ";
//$sql = "SELECT category_name, category_id,category_image FROM `category_table` WHERE category_parent_id =".$maincatid." AND category_status =1";
if ($query->executeQuery($sql)) {
$output = Display_DFeaturedItems::showMainCatLanding($query->records);
} else {
//$output='No Main Category Listed';
$output = Display_DFeaturedItems::showFeaturedItemsElse();
}
return $output;
}
