/**
* Function returns the result of the search query from database.
* @param string $search
* @param int $sort
* @param int $mode
* @return string
*/
function searchKeyWord($search, $sort, $mode)
{
$limitstart = 0;
$limitend = $_POST['selpage'];
if (empty($_POST['selpage'])) {
$limitend = 10;
}
$sortby = $_POST['selsort'];
if (empty($sortby)) {
$sortby = 0;
}
if ($sortby == 0) {
$sql = "SELECT * FROM PRODUCTS_TABLE WHERE TITLE LIKE '%" . $search . "%' OR DESCRIPTION LIKE '%" . $search . "%' OR TAG LIKE '%" . $search . "%' OR BRAND LIKE '%" . $search . "%' order by msrp limit " . $limitstart . "," . $limitend;
} elseif ($sortby == 1) {
$sql = "SELECT * FROM PRODUCTS_TABLE WHERE TITLE LIKE '%" . $search . "%' OR DESCRIPTION LIKE '%" . $search . "%' OR TAG LIKE '%" . $search . "%' OR BRAND LIKE '%" . $search . "%' order by msrp desc limit " . $limitstart . "," . $limitend;
} elseif ($sortby == 2) {
$sql = "SELECT * FROM PRODUCTS_TABLE WHERE TITLE LIKE '%" . $search . "%' OR DESCRIPTION LIKE '%" . $search . "%' OR TAG LIKE '%" . $search . "%' OR BRAND LIKE '%" . $search . "%' order by title limit " . $limitstart . "," . $limitend;
} elseif ($sortby == 3) {
$sql = "SELECT * FROM PRODUCTS_TABLE WHERE TITLE LIKE '%" . $search . "%' OR DESCRIPTION LIKE '%" . $search . "%' OR TAG LIKE '%" . $search . "%' OR BRAND LIKE '%" . $search . "%' order by title desc limit " . $limitstart . "," . $limitend;
}
if ($search != '') {
$obj = new Bin_Query();
$obj->executeQuery($sql);
$i = 0;
foreach ($obj->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'] = '$' . $row['msrp'] . ' - $' . $minval;
} else {
$r[$i]['msrp'] = '$' . $row['msrp'];
}
$i++;
}
return Display_DKeywordSearch::displaySearch($r, $mode);
} else {
$obj3 = new Core_CKeywordSearch();
$res = 'Enter Keyword to Search';
$obj3->countSearch($search);
return $res;
}
}
/**
* 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 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);
}
