/** * This function is used to Display the Featured Product Page * * @return string */ function showFeaturedProduct() { include_once 'classes/Core/CFeaturedItems.php'; include 'classes/Core/CUserRegistration.php'; include 'classes/Display/DUserRegistration.php'; include 'classes/Core/CWishList.php'; include 'classes/Display/DWishList.php'; include_once 'classes/Display/DFeaturedItems.php'; include_once 'classes/Core/CNewProducts.php'; include_once 'classes/Display/DNewProducts.php'; include 'classes/Core/CKeywordSearch.php'; include 'classes/Display/DKeywordSearch.php'; include 'classes/Core/CHome.php'; include 'classes/Core/CAddCart.php'; include 'classes/Display/DAddCart.php'; include_once 'classes/Core/CLastViewedProducts.php'; include_once 'classes/Display/DLastViewedProducts.php'; include 'classes/Lib/TagClouds.php'; include 'classes/Core/CTagClouds.php'; include_once 'classes/Core/CCurrencySettings.php'; Core_CCurrencySettings::getDefaultCurrency(); $output['categories'] = Display_DUserRegistration::showMainCat(); $output['signup'] = Display_DUserRegistration::signUp(); $output['cartSnapShot'] = Core_CAddCart::cartSnapShot(); if ($_SESSION['user_id'] != '') { $output['wishlistsnapshot'] = Core_CWishList::snapshotForHome(); } $output['sitelogo'] = Core_CHome::getLogo(); $output['pagetitle'] = Core_CHome::pageTitle(); $output['timezone'] = Core_CHome::setTimeZone(); $output['currentDate'] = date('D,M d,Y - h:i A'); $output['skinname'] = Core_CHome::skinName(); $output['googleanalytics'] = Core_CHome::getGoogleAnalyticsCode(); $output['googlead'] = Core_CHome::getGoogleAd(); $output['footer'] = Core_CHome::footer(); $output['footerconnect'] = Core_CHome::getfooterconnect(); $output['sociallink'] = Core_CHome::showSocialLinks(); $default = new Core_CFeaturedItems(); $output['subcatbreadcrumb'] = $default->subcatBreadCrumb(); $output['dropdowncat'] = Core_CKeywordSearch::categoryDropDown(); $output['subcatlandcontent'] = $default->getSubcatlandContent(); if ($_SESSION['compareProductId'] == '') { $output['viewProducts']['viewProducts'] = Display_DWishList::viewProductElse(); } else { $output['viewProducts'] = Core_CWishList::addtoCompareProduct(); } $default = new Core_CNewProducts(); $output['newproducts'] = $default->newProducts(); $output['loginStatus'] = Core_CUserRegistration::loginStatus(); $output['tagClouds'] = Core_CTagClouds::displayTagClouds(); $output['showBestSellingProducts'] = Core_CFeaturedItems::showBestSellingProducts(); $output['headermenu'] = Core_CUserRegistration::showHeaderMenu(); $output['headermenuhidden'] = Core_CUserRegistration::showHeaderMenuHidden(); $output['currencysettings'] = Core_CUserRegistration::showCurrencySettings(); $output['headertext'] = Core_CUserRegistration::showHeaderText(); $output['cartSnapShot'] = Core_CAddCart::cartSnapShot(); if ($_SESSION['compareProductId'] == '') { $output['viewProducts']['viewProducts'] = Display_DWishList::viewProductElse(); } else { $output['viewProducts'] = Core_CWishList::addtoCompareProduct(); } $sort = $_POST['selsort']; $output['sitelogo'] = Core_CHome::getLogo(); $output['pagetitle'] = Core_CHome::pageTitle(); $output['timezone'] = Core_CHome::setTimeZone(); $output['currentDate'] = date('D,M d,Y - h:i A'); $output['skinname'] = Core_CHome::skinName(); $output['banner'] = Core_CHome::getBanner(); $output['googlead'] = Core_CHome::getGoogleAd(); $output['footer'] = Core_CHome::footer(); $output['timezone'] = Core_CHome::setTimeZone(); $sort = $_POST['selsort']; $mode = $_POST['selmode']; $output['narrowsearch'] = Core_CKeywordSearch::narrowSearch($sort, $mode); $cou = $_SESSION['countsearch']; $output['countrecords'] = Core_CKeywordSearch::countSearch($cou); $output['disppagesize'] = Display_DKeywordSearch::displayPageSize(); if ((int) $_SESSION['countsearch'] > 0) { $output['dispselection'] = Display_DKeywordSearch::displaySelection(); } $output['disppricerange'] = Core_CKeywordSearch::priceRange(); if ($_POST['subcatsel'] != "" or $_SESSION['subcategory'] != "") { $output['features'] = Core_CKeywordSearch::featureList(); } $output['brandwithcount'] = Core_CKeywordSearch::dispBrandWithCount(); $output['dispsubcat'] = Core_CKeywordSearch::dispSubCategory(); $output['mylink'] = Core_CKeywordSearch::linkMode(); $output['sortby'] = Display_DKeywordSearch::sortBy(); $output['viewproducts'] = Core_CFeaturedItems::viewProducts(); $output['searchoptions'] = Core_CFeaturedItems::dispSearch(); $output['narrow'] = Core_CFeaturedItems::dispNarrow(); $output['pricenarrow'] = Core_CFeaturedItems::dispPriceNarrow(); $output['brandnarrow'] = Core_CFeaturedItems::dispBrandNarrow(); Bin_Template::createTemplate('subcategory.html', $output); }
/** * This function is used to find the extended search * @param integer $sort * @param string $mode * @return string */ function extendedSearch($sort, $mode) { $attrib_value_id = $_GET['attrib_value_id']; $catid = $_GET['category']; $pagesize = 10; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sortby = $_POST['selsort']; if (empty($sortby)) { $sortby = 0; } $catid = $_POST['subcatsel']; if (empty($catid)) { $catid = $_GET['category']; } $ob = new Core_CKeywordSearch(); $subcategoryname = $ob->categoryName($catid); $mm = $_SESSION['category']; $categoryname = $ob->categoryName($mm); $head = $_GET['head']; $attib_value_id = $_GET['attrib_value_id']; // echo 'the value is '.$attib_value_id; $brand = $_GET['brand']; if ((int) $attib_value_id > 0) { $_SESSION['selectedbrand'] = 'You have Selected <b>' . $categoryname . '</b> >><b> ' . $subcategoryname . '</b>>>' . '<b> ' . $head . ' </b>'; } elseif (count($brand) > 0) { $_SESSION['selectedbrand'] = 'You have Selected <b>' . $categoryname . '</b> >><b> ' . $subcategoryname . '</b>'; } if ((int) $attrib_value_id > 0) { if ($sortby == 0) { //$sql="select * from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on d.category_id=c.category_parent_id where b.attrib_value_id=".$attrib_value_id." and category_id=".catid." group by a.title order by a.msrp"; // $sql="select a.* from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id where b.attrib_value_id=".$attrib_value_id." and c.category_parent_id=".$catid ." order by a.msrp"; $sql = "select a.*,sum(r.rating)/count(r.user_id) as rating,count(r.user_id) as rcount from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id where b.attrib_value_id=" . $attrib_value_id . " and c.category_id=" . $catid . " and a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id order by a.msrp"; } elseif ($sortby == 1) { //$sql="select * from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on d.category_id=c.category_parent_id where b.attrib_value_id=".$attrib_value_id." ".$mycat." group by a.title order by a.msrp desc "; // $sql="select a.* from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id where b.attrib_value_id=".$attrib_value_id." and c.category_parent_id=".$catid ." order by a.msrp desc"; $sql = "select a.*,sum(r.rating)/count(r.user_id) as rating,count(r.user_id) as rcount from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id left join product_reviews_table r on a.product_id=r.product_id where b.attrib_value_id=" . $attrib_value_id . " and c.category_id=" . $catid . " and a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id order by a.msrp desc"; } elseif ($sortby == 2) { // $sql="select * from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on d.category_id=c.category_parent_id where b.attrib_value_id=".$attrib_value_id." ".$mycat." group by a.title order by a.title"; // $sql="select a.* from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id where b.attrib_value_id=".$attrib_value_id." and c.category_parent_id=".$catid ." order by a.title"; $sql = "select a.*,sum(r.rating)/count(r.user_id) as rating,count(r.user_id) as rcount from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id left join product_reviews_table r on a.product_id=r.product_id where b.attrib_value_id=" . $attrib_value_id . " and c.category_id=" . $catid . " and a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id order by a.title"; } elseif ($sortby == 3) { //$sql="select * from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on d.category_id=c.category_parent_id where b.attrib_value_id=".$attrib_value_id." ".$mycat." group by a.title order by a.title desc "; //$sql="select a.* from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id where b.attrib_value_id=".$attrib_value_id." and c.category_parent_id=".$catid ." order by a.title desc"; $sql = "select a.*,sum(r.rating)/count(r.user_id) as rating,count(r.user_id) as rcount from products_table a inner join product_attrib_values_table b on a.product_id=b.product_id inner join category_table c on c.category_id=a.category_id inner join category_table d on c.category_parent_id=d.category_id left join product_reviews_table r on a.product_id=r.product_id where b.attrib_value_id=" . $attrib_value_id . " and c.category_id=" . $catid . " and a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id order by a.title desc"; } } $obj = new Bin_Query(); if ($obj->executeQuery($sql)) { $_SESSION['countsearch'] = $obj->totrows; $sql1 = $sql . ' LIMIT ' . $start . ',' . $end; $total = ceil($obj->totrows / $pagesize); include 'classes/Lib/paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $query = new Bin_Query(); if ($query->executeQuery($sql1)) { $i = 0; if ((int) $query->totrows > 0) { foreach ($query->records as $row) { $r[$i] = $row; $prid = $row['product_id']; $obj1 = new Core_CKeywordSearch(); $minval = $obj1->disRates($prid); if ($minval > 0 or $minval != '') { $r[$i]['msrp'] = '$' . number_format($row['msrp'], 2) . ' - $' . number_format($minval, 2); } else { $r[$i]['msrp'] = '$' . number_format($row['msrp'], 2); } $i++; } } } return Display_DKeywordSearch::extendedSearch($r, $mode, $this->data['paging'], $this->data['prev'], $this->data['next']); } }
/** * This function is used to Display the Extended Search Page * * @return HTML data */ function extendedSearch() { include_once 'classes/Core/CFeaturedItems.php'; include 'classes/Core/CUserRegistration.php'; include 'classes/Display/DUserRegistration.php'; include 'classes/Core/CWishList.php'; include 'classes/Display/DWishList.php'; include_once 'classes/Display/DFeaturedItems.php'; include_once 'classes/Core/CNewProducts.php'; include_once 'classes/Display/DNewProducts.php'; include 'classes/Core/CAddCart.php'; include 'classes/Display/DAddCart.php'; include_once 'classes/Core/CCurrencySettings.php'; Core_CCurrencySettings::getDefaultCurrency(); $output['wishlistsnapshot'] = Core_CWishList::wishlistSnapshot(); $output['cartSnapShot'] = Core_CAddCart::cartSnapShot(); if ($_SESSION['compareProductId'] == '') { $output['viewProducts']['viewProducts'] = Display_DWishList::viewProductElse(); } else { $output['viewProducts'] = Core_CWishList::addtoCompareProduct(); } $default = new Core_CNewProducts(); $output['newproducts'] = $default->newProducts(); $output['loginStatus'] = Core_CUserRegistration::loginStatus(); $output['headermenu'] = Core_CUserRegistration::showHeaderMenu(); $output['headermenuhidden'] = Core_CUserRegistration::showHeaderMenuHidden(); $output['headertext'] = Core_CUserRegistration::showHeaderText(); $output['currencysettings'] = Core_CUserRegistration::showCurrencySettings(); include 'classes/Core/CKeywordSearch.php'; include 'classes/Display/DKeywordSearch.php'; include 'classes/Core/CHome.php'; $output['sitelogo'] = Core_CHome::getLogo(); $output['pagetitle'] = Core_CHome::pageTitle(); $output['timezone'] = Core_CHome::setTimeZone(); $output['currentDate'] = date('D,M d,Y - h:i A'); $output['skinname'] = Core_CHome::skinName(); $output['banner'] = Core_CHome::getBanner(); $output['footerconnect'] = Core_CHome::getfooterconnect(); $output['sociallink'] = Core_CHome::showSocialLinks(); $output['googlead'] = Core_CHome::getGoogleAd(); $sort = $_POST['selsort']; $mode = $_POST['selmode']; $output['dispsubcat'] = Core_CKeywordSearch::dispSubCategory(); $output['extendedsearch'] = Core_CKeywordSearch::extendedSearch($sort, $mode); $cou = $_SESSION['countsearch']; $output['countrecords'] = Core_CKeywordSearch::countSearch($cou); $output['disppagesize'] = Display_DKeywordSearch::displayPageSize(); $output['searchsession'] = Display_DKeywordSearch::searchSession($search); $output['disppricerange'] = Core_CKeywordSearch::priceRange(); if ($_POST['subcatsel'] != "" or $_SESSION['subcategory'] != "") { $output['features'] = Core_CKeywordSearch::featureList(); } if ((int) $_SESSION['countsearch'] > 0) { $output['dispselection'] = Display_DKeywordSearch::displaySelection(); } $output['brandwithcount'] = Core_CKeywordSearch::dispBrandWithCount(); $output['dropdowncat'] = Core_CKeywordSearch::categoryDropDown(); $output['mylink'] = Core_CKeywordSearch::linkMode(); $output['sortby'] = Display_DKeywordSearch::sortBy(); Bin_Template::createTemplate('searchpage.html', $output); }
/** * Function generates a drop down list for the available categories * * * @return string */ function categoryDropDown() { $sql = 'select * from category_table where category_parent_id=0 order by category_name'; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DKeywordSearch::categoryDropDown($obj->records); }