/**
* 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);
}
