<?
include_once("mysql.php");
include_once("func_build.php");
include_once("functions.php");
include_once("lang/lang.".get_LG().".php");

$srch     = isset($_GET["srch"]) 	 ? clean_data($_GET["srch"]) : "";
$srchtype = isset($_GET["srchtype"]) ? clean_data($_GET["srchtype"]) : "";
$country  = isset($_GET["country"])  ? $_GET["country"]  : "";
$category = isset($_GET["category"]) ? $_GET["category"] : "";
$subcateg = isset($_GET["subcateg"]) ? $_GET["subcateg"] : "";
$sortby   = isset($_GET["sortby"]) 	 ? $_GET["sortby"] 	 : "";
$more     = isset($_GET["more"]) 	 ? $_GET["more"] 	 : "";

// more (from the home page / marketplace)
$sql_more = "";
if ($more=="hotdeal")
	$sql_more = " AND P.is_hotdeal=1 ";
elseif ($more=="spotlight")
	$sql_more = " AND P.is_spotlight=1 ";

// orderby
$fair_search = 0;
$sql_order = "C.is_full_profile DESC, C.rank_points DESC";
if ($sortby=="recent") 		 $sql_order = "P.date_posted DESC";
elseif ($sortby=="low2high") $sql_order = "IF (P.fob_min=0, 99999999, P.fob_min) ASC";
elseif ($sortby=="high2low") $sql_order = "P.fob_min DESC";
else $fair_search = 1; // turn on special mechanism
	
if (strlen($srch)<=2 and $sql_more=="" and $category=="" and $subcateg==""){

}
else{
	// prepare statment
	$rec_per_page = 15;
	$this_page = isset($_GET["page"]) ? $_GET["page"] : 1;
	$start_with = $rec_per_page*($this_page-1);

	$qu_cou = (!is_numeric($country))  ? "" : " AND CO.id='$country' ";
	$qu_cat = (!is_numeric($category)) ? "" : " AND P.categ_id='$category' ";
	$qu_subcat = (!is_numeric($subcateg)) ? "" : " AND P.subcateg_id='$subcateg' ";

	if ($srchtype=="" or $srchtype=="Product"){
		$sr = 1;
		
		if ($fair_search==1){
			// FAIR SEARCH
			
			// param category
			$select_categ_id = (is_numeric($category)) ? "categ_id='$category'" : "categ_id IS NULL";
			$insert_categ_id = (is_numeric($category)) ? "'$category'" : "NULL";
			
			// param subcategory
			$select_subcateg_id = (is_numeric($subcateg)) ? "subcateg_id='$subcateg'" : "subcateg_id IS NULL";
			$insert_subcateg_id = (is_numeric($subcateg)) ? "'$subcateg'" : "NULL";
			
			// param country
			$select_country_id = (is_numeric($country)) ? "country_id='$country'" : "country_id IS NULL";
			$insert_country_id = (is_numeric($country)) ? "'$country'" : "NULL";
			
			$qu_search = search_func($srch, "P.product, P.keyword");
			
			// 1. Delete all params older than 3 days 
			// (search_sorted_companies & search_sorted_products will be purged automatically as cascade)
			$sql = "DELETE FROM search_params WHERE DATEDIFF(NOW(), date_added)>=3";
			mysql_query($sql);
			
			// 2. Check if our param exists in search_params
			$sql = "SELECT COUNT(1) as cn, search_id
					FROM search_params 
					WHERE product_search='$srch' AND $select_categ_id AND $select_subcateg_id AND $select_country_id";
			$result = mysql_query($sql);
			$row = mysql_fetch_array($result);
			$cn_search_params = $row["cn"];
			$search_id = $row["search_id"];
			if ($cn_search_params==0){
				// 2.1. Not exist - add search_params
				$sql = "INSERT INTO search_params SET
						product_search='$srch',
						categ_id=$insert_categ_id,
						subcateg_id=$insert_subcateg_id,
						country_id=$insert_country_id,
						date_added=NOW()";
				mysql_query($sql);
				$search_id = mysql_insert_id();
				
				
				// 2.2. Sort by companies having this product, assign company sort_order
				/*
				$cn_companies = 0;
				$sql = "SELECT C.id as comp_id
						FROM companies C 
						JOIN members M ON M.id=C.user_id 
						WHERE M.is_active=1 AND C.id<>1 $qu_cou AND 
						(
						EXISTS (select 1 from products P where P.comp_id=C.id AND P.purpose=1 AND P.status=1 $qu_cat $qu_subcat $qu_search)
						OR
						EXISTS (select 1 
									from products P 
									join product_categories_sub PS ON PS.id=P.subcateg_id
									join product_categ_sub_keywords PSK ON PSK.subcateg_id=PS.id
									where P.comp_id=C.id AND P.purpose=1 AND P.status=1 $qu_cat $qu_subcat AND PSK.subcateg_keyword='$srch')
						)
						ORDER BY C.is_full_profile DESC, C.rank_points DESC
						LIMIT 100";
				$result = mysql_query($sql);
				while($row = mysql_fetch_array($result)){
					$cn_companies++;
					$comp_id = $row["comp_id"];
					$sql2 = "INSERT INTO search_sorted_companies SET search_id='$search_id', comp_id='$comp_id', comp_sort_order='$cn_companies'";
					mysql_query($sql2);
				}
				*/
				
				$cn_companies1 = 0;
				$sql = "SELECT C.id as comp_id
						FROM companies C 
						JOIN members M ON M.id=C.user_id 
						WHERE M.is_active=1 AND C.id<>1 $qu_cou AND 
						EXISTS (select 1 from products P where P.comp_id=C.id AND P.purpose=1 AND P.status=1 $qu_cat $qu_subcat $qu_search)
						ORDER BY C.is_full_profile DESC, C.rank_points DESC
						LIMIT 100";
				$result = mysql_query($sql);
				while($row = mysql_fetch_array($result)){
					$cn_companies1++;
					$comp_id = $row["comp_id"];
					$sql2 = "INSERT INTO search_sorted_companies 
							SET search_id='$search_id', comp_id='$comp_id', comp_sort_order='$cn_companies1', sort_type=1";
					mysql_query($sql2);
				}
				
				// 2.2.a. Get companies having this search term in Subcategories Keywords and not having it in Product Name or Product Keywords
				$companies_left = 100 - $cn_companies1;
				if ($companies_left > 0){
					$cn_companies2 = 0;
					$sql = "SELECT C.id as comp_id
							FROM companies C 
							JOIN members M ON M.id=C.user_id 
							WHERE M.is_active=1 AND C.id<>1 $qu_cou AND 
							EXISTS (select 1 
									from products P 
									join product_categories_sub PS ON PS.id=P.subcateg_id
									join product_categ_sub_keywords PSK ON PSK.subcateg_id=PS.id
									where P.comp_id=C.id AND P.purpose=1 AND P.status=1 $qu_cat $qu_subcat AND PSK.subcateg_keyword='$srch'
									)
							AND NOT EXISTS (select 1 from search_sorted_companies X where X.search_id='$search_id' AND X.comp_id=C.id AND X.sort_type=1)
							LIMIT $companies_left";
					$result = mysql_query($sql);
					while($row = mysql_fetch_array($result)){
						$cn_companies2++;
						$comp_id = $row["comp_id"];
						$sql2 = "INSERT INTO search_sorted_companies 
								SET search_id='$search_id', comp_id='$comp_id', comp_sort_order='$cn_companies2', sort_type=2";
						mysql_query($sql2);
					}
				}
				
				// 2.3. Sort by products using fair search mechanism
				$i = -1;
				$sql = "SELECT P.id as prod_id, S.comp_sort_order
						FROM products P
						JOIN companies C ON C.id=P.comp_id 
						JOIN search_sorted_companies S ON S.comp_id=C.id
						LEFT JOIN countries CO ON CO.id=C.country 
						JOIN members M ON M.id=C.user_id 
						WHERE S.search_id='$search_id' AND S.sort_type=1 AND P.purpose=1 AND P.status=1 AND M.is_active=1 AND C.id<>1 
						$sql_more $qu_cou $qu_cat $qu_subcat $qu_search
						ORDER BY S.comp_sort_order ASC, P.id DESC
						LIMIT 1000";
				$result = mysql_query($sql);
				while($row = mysql_fetch_array($result)){
					$i++;
					$prod_id = $row["prod_id"];
					$comp_sort_order = $row["comp_sort_order"];
					
					if ($old_comp_sort_order != $comp_sort_order) $i = 0;
					
					// THAT'S THE FORMULA THAT DOES FAIR SORTING MAGIC:
					$prod_sort_order = $comp_sort_order + $cn_companies1*$i; 
					/*
					// say there're 4 companies
					COMP1 - prod1:1, prod2:5, prod3:9
					COMP2 - prod4:2, prod5:6
					COMP3 - prod6:3
					COMP4 - prod7:4, prod8:8, prod9:12, prod10:16
					*/
					
					$sql2 = "INSERT INTO search_sorted_products 
							SET search_id='$search_id', prod_id='$prod_id', prod_sort_order='$prod_sort_order', sort_type=1";
					mysql_query($sql2);
					
					$old_comp_sort_order = $comp_sort_order;
				}
			}
			
			// 2.3a. Products with keywords in subcategories, not in product names
			$prod_left = 999 - $i;
			if ($prod_left > 0 and $cn_companies2!=0){
				$j = -1;
				$sql = "SELECT P.id as prod_id, S.comp_sort_order
						FROM products P
						JOIN companies C ON C.id=P.comp_id 
						JOIN search_sorted_companies S ON S.comp_id=C.id
						LEFT JOIN countries CO ON CO.id=C.country 
						JOIN members M ON M.id=C.user_id 
						join product_categories_sub PS ON PS.id=P.subcateg_id
						join product_categ_sub_keywords PSK ON PSK.subcateg_id=PS.id AND PSK.subcateg_keyword='$srch'
						WHERE S.search_id='$search_id' AND S.sort_type=2 AND P.purpose=1 AND P.status=1 AND M.is_active=1 AND C.id<>1 
						$sql_more $qu_cou $qu_cat $qu_subcat 
						AND NOT EXISTS (select 1 from search_sorted_products X where X.search_id='$search_id' AND X.prod_id=P.id AND X.sort_type=1)
						ORDER BY S.comp_sort_order ASC, P.id DESC
						LIMIT $prod_left";
				$result = mysql_query($sql);
				while($row = mysql_fetch_array($result)){
					$j++;
					$prod_id = $row["prod_id"];
					$comp_sort_order = $row["comp_sort_order"];
					
					if ($old_comp_sort_order != $comp_sort_order) $j = 0;
					
					// THAT'S THE FORMULA THAT DOES FAIR SORTING MAGIC:
					$prod_sort_order = $comp_sort_order + $cn_companies2*$j; 
					
					$sql2 = "INSERT INTO search_sorted_products 
							SET search_id='$search_id', prod_id='$prod_id', prod_sort_order='$prod_sort_order', sort_type=2";
					mysql_query($sql2);
					
					$old_comp_sort_order = $comp_sort_order;
				}
			}
			
			
			// 3. Now let's display sorted result
			$query_select = "SELECT P.id as prod_id, P.product, P.descr, H.photo, P.product_url,
							P.min_qty, P.min_unit, P.fob_currency, P.fob_min, P.fob_max, 
							C.id as comp_id, C.name as comp_name, C.comp_url, CO.country ";
			$query_from = 	"FROM products P 
							JOIN companies C ON C.id=P.comp_id 
							JOIN search_sorted_products S ON S.prod_id=P.id AND S.search_id='$search_id'
							LEFT JOIN countries CO ON CO.id=C.country 
							LEFT JOIN product_photo H ON H.prod_id=P.id and H.is_main=1 AND H.photo_video='p' 
							JOIN members M ON M.id=C.user_id 
							WHERE 1 ";
			$query_order = "ORDER BY S.sort_type, S.prod_sort_order 
							LIMIT $start_with, $rec_per_page";
		}
		else{
			// regular search
			$query_select = "SELECT P.id as prod_id, P.product, P.descr, H.photo, P.product_url,
						P.min_qty, P.min_unit, P.fob_currency, P.fob_min, P.fob_max, 
						C.id as comp_id, C.name as comp_name, C.comp_url, CO.country ";
			$query_from = 	"FROM products P 
							JOIN companies C ON C.id=P.comp_id 
							LEFT JOIN countries CO ON CO.id=C.country 
							LEFT JOIN product_photo H ON H.prod_id=P.id and H.is_main=1 AND H.photo_video='p' 
							JOIN members M ON M.id=C.user_id 
							WHERE P.purpose=1 AND P.status=1 AND M.is_active=1 AND C.id<>1 $sql_more $qu_cou $qu_cat $qu_subcat $qu_search ";
			$query_order = "ORDER BY $sql_order LIMIT $start_with, $rec_per_page";
		}
	}
	elseif ($srchtype=="Seller"){
		$sr = 2;
		$qu_search = search_func($srch, "C.name", "company");
		
		$query_select = "SELECT C.id as comp_id, C.name as comp_name, C.header_image, C.comp_url, C.introduction, C.city, C.state, CO.country ";
		$query_from	  =	"FROM companies C 
						JOIN countries CO ON CO.id=C.country $qu_cou 
						JOIN members M ON M.id=C.user_id 
						WHERE C.supplier=1 AND C.id<>1 $qu_search ";
		$query_order = "ORDER BY $sql_order LIMIT $start_with, $rec_per_page";
	}
	elseif ($srchtype=="Buyer"){
		$sr = 3;
		$qu_search = search_func($srch, "C.name", "company");
		
		$query_select = "SELECT C.id as comp_id, C.name as comp_name, C.header_image, C.comp_url, C.introduction, C.city, C.state, CO.country ";
		$query_from	  =	"FROM companies C 
						JOIN countries CO ON CO.id=C.country $qu_cou 
						JOIN members M ON M.id=C.user_id 
						WHERE C.buyer=1 AND C.id<>1 $qu_search ";
		$query_order = "ORDER BY $sql_order LIMIT $start_with, $rec_per_page";
	}
	elseif ($srchtype=="Lead"){
		$sr = 4;
		$qu_search = search_func($srch, "P.product, P.keyword");
		
		$query_select = "SELECT P.id as prod_id, P.product, P.descr, P.photo, P.product_url,
						P.min_qty, P.min_unit, P.fob_currency, P.fob_min, P.fob_max, 
						C.id as comp_id, C.name as comp_name, C.comp_url, CO.country ";
		$query_from = 	"FROM products P 
						JOIN companies C ON C.id=P.comp_id 
						LEFT JOIN countries CO ON CO.id=C.country 
						JOIN members M ON M.id=C.user_id 
						WHERE P.purpose=2 AND M.is_active=1 AND P.status=1 AND C.id<>1 $sql_more $qu_cou $qu_cat $qu_subcat $qu_search ";
		$query_order = "ORDER BY $sql_order LIMIT $start_with, $rec_per_page";
	}
	$query_final = $query_select . $query_from . $query_order;
	//echo $query_final;

	// items count
	$query_cn = "SELECT COUNT(1) as cn " . $query_from;
	//if ($sr == 1) $query_cn.= " GROUP BY C.id";
	$result = mysql_query($query_cn);
	$row = mysql_fetch_array($result);
	$cn_rec = $row["cn"];

	// count pages
	$page_count = floor($cn_rec/$rec_per_page);
	if ($cn_rec % $rec_per_page != 0) {	// last torn page
		$page_count = $page_count + 1;
		
		if ($this_page==$page_count) 	// on the last torn page display last X torn records (e.g. 4), not 10 as on all other pages
			$rec_per_page = $cn_rec - ($page_count-1)*$rec_per_page;
	}
}
$serlzd_cookie_params = get_cookie_params();
?>
<!DOCTYPE html>
<html class="no-js" lang="en">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Search </title>

<script src="themeforest/js/jquery.min.js"></script>
<script type="text/javascript" src="js.js"></script>

<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" /> 
<link rel="stylesheet" href="themeforest/css/bootstrap.css" type="text/css" />
<link rel="stylesheet" href="themeforest/css/animate.css" type="text/css" />
<link rel="stylesheet" href="themeforest/css/font-awesome.min.css" type="text/css" />
<link rel="stylesheet" href="themeforest/css/font.css" type="text/css" />
<link rel="stylesheet" href="themeforest/css/app.css" type="text/css" />
<!--[if lt IE 9]>
    <script src="themeforest/js/ie/html5shiv.js"></script>
    <script src="themeforest/js/ie/respond.min.js"></script>
    <script src="themeforest/js/ie/excanvas.js"></script>
<![endif]-->
<link href="css/main_styles_boot.css" rel="stylesheet">
<link href='//fonts.googleapis.com/css?family=Open+Sans:400,600,300,700' rel='stylesheet' type='text/css'>
<link href="css/style.css" rel="stylesheet">
<link href="css/megamenu.css" rel="stylesheet">
<link href="css/searchpages.css" rel="stylesheet">

<!-- MEGA MENU (CSS IS @IMPORT IN STYLESHEET) -->
<script type="text/javascript" src="js/megamenu.js"></script>
<script type="text/javascript" src="js/megamenu_plugins.js"></script>
<script type="text/javascript" src="js/custom/megamenu_popup.js"></script>
<script type="text/javascript" src="js/custom/company_narrow_result.js"></script>
<!-- MEGA MENU -->

<?
// see functions.php (javascript func that adds/removes favorite prod via AJAX/jQuery ajx_product_fav.php)
echo fav_prod();
?>
</head>
<body class="search_page">
	<?
	forest_header();
	?>
<div class='maindiv' style='color:#000'>

<?if (strlen($srch)<=2 and $sql_more=="" and $category=="" and $subcateg==""){?>
	Error: Search parameter must be at least 3 characters!
	<div style='height:1000px'></div>
<?}else{?>
	<!--LEFT PART-->
	<div class="col-md-3 col-sm-12 col-xs-12 column search-bar">
	<div class="information_popup_container">
	<div class="information">
		<!-- The thing or things you want to hover over go here such as images, tables, 
			 paragraphs, objects other divisions etc. --> 
		<div class="all-categories-button">  <i class="fa fa-caret-down"></i></div>
	</div>
	<div class="popup_information">
		<!-- The thing or things you want to popup go here such as images, tables, 
		paragraphs, objects other divisions etc. --> 
	 
		<div class="megamenu_container_vertical megamenu_light_bar megamenu_light"><!-- Begin Menu Container -->
		<ul class="megamenu megamenu_vertical"><!-- Begin Mega Menu -->
			<li class="megamenu_button"><a href="#_"></a></li>
			<?
			// Categories
			$i = 0;
			$sql = "SELECT PC.id, ".get_lang_column("category")." as categ
					FROM product_categories PC 
					WHERE EXISTS (select 1 from products where categ_id=PC.id) 
					ORDER BY 2";
			$result = mysql_query($sql);
			while($row = mysql_fetch_array($result)){
				$i++;
				$t_id = $row["id"];
				$t_cat = $row["categ"];
				?>
				<li>
					<a class='megamenu_drop' href='search.php?category='></a>
					
					<?if (1==2){?>
					<div class="dropvertical_container"><!-- Vertical Drop Down Container -->
						<div class="dropdown_fullwidth dropdown_first"><!-- Begin Item Container -->
							<div class="col_12"><h3><a href='search.php?category='></a></h3></div>
							<?
							$sql2 = "SELECT id, subcategory FROM product_categories_sub WHERE categ_id='$t_id' ORDER BY subcategory";
							$result2 = mysql_query($sql2);
							while($row2 = mysql_fetch_array($result2)){
								$t_subid = $row2["id"];
								$t_subcat = $row2["subcategory"];
								?>
								<div class="col_4">
									<ul class="list_unstyled">
										<li><a href="search.php?subcateg="><b><u></u></b></a></li>	
									</ul>
								</div>
								<?
							}
							?>
						</div> <!-- End Item Container -->
					</div> <!-- End Vertical Drop Down Container -->
					<?}?>
				</li>
				<?
			}
			?>
		</ul>
		</div><!-- End Menu Container -->
	</div>
	</div>
	 
	<div class="visible-sm visible-xs narrow-results">
        <div>Narrow Results</div>
    </div>
	<div class="menu-container" style='border-right:1px solid #eee; border-radius:5px; padding:10px; min-height:1000px'>
		<div style='font-size:15px; font-weight:bold; border-bottom:1px solid #eee;'>
		</div>
		
		<?
		$qu_categ = $qu_country = "";
		if ($category!="") $qu_categ.= "&category=".$category;
		if ($country!="")  $qu_country.= "&country=".$country;
		
		// filter by category
		$filtered_category = "";
		$query_from_categ = str_replace($qu_cat, "", $query_from);
		$query_from_categ = str_replace("WHERE", "JOIN product_categories CAT ON CAT.id=P.categ_id WHERE", $query_from_categ);
		$query = "SELECT DISTINCT CAT.id, CAT.category, CAT.category_cn ".$query_from_categ." ORDER BY CAT.category";
		$result = mysql_query($query);
		
		/*$this_cat_en = $row["category"];
		$this_cat_cn = $row["category_cn"];
		if ($LG=="cn") $this_cat = $this_cat_cn;
		else $this_cat = $this_cat_en;*/
		?>
		<div style='padding:15px 0px; border-bottom:1px solid #D9D9D9; line-height:18px;'>
		<b></b>
		<div style='height:10px;'></div>
		<a href='?srch=&srchtype='></a><br/>
		<?
		while($row = mysql_fetch_array($result)){
			if ($row["id"]==$category) $filtered_category = $row["category"];
			?>
			<a href='?srch=&srchtype=&category='>
			</a><br/>
			<?
		}
		echo "</div>";
		
		// filter by country
		$filtered_country = "";
		$query = "SELECT DISTINCT CO.id, CO.country ".str_replace($qu_cou, "", $query_from)." ORDER BY CO.country";
		$result = MYSQL_QUERY($query);
		?>
		<div style='padding:15px 0px; border-bottom:1px solid #D9D9D9; line-height:18px;'>
		<b></b>
		<div style='height:10px;'></div>
		<a href='?srch=&srchtype='>All Countries</a><br/>
		<?
		while($row = mysql_fetch_array($result)){
			if ($row["id"]==$country) $filtered_country = $row["country"];
			?>
			<a href='?srch=&srchtype=&country='>
			</a><br/>
			<?
		}
		echo "</div>";
		?>
	</div>
	</div>
	
	
	<!--RIGHT PART-->
	<div class="col-md-9 col-sm-12 col-xs-12 column">
	<script>
	function drop_filter(qu_key, qu_val){
		var qs = window.location.href;
		qs = qs.replace("&"+qu_key+"="+qu_val, "");
		window.location.href = qs;
	}
	function getParameterByName(name) {
		var match = RegExp('[?&]' + name + '=([^&]*)').exec(window.location.search);
		return match && decodeURIComponent(match[1].replace(/\+/g, ' '));	// if not found, returns null
	}
	function sort_by(val){
		var qs = window.location.href;
		var current_sortby = getParameterByName("sortby");
		if (current_sortby===null)
			qs = qs+"&sortby="+val;
		else
			qs = qs.replace("&sortby="+current_sortby, "&sortby="+val);
		window.location.href = qs;
	}
	</script>
	<?
	function filter_square($qu_key, $qu_val, $item_name){
		?>
		<div style='float:left; height:25px; line-height:25px; padding:0px 14px; color:#FFF; background-color:#00AFC2; margin-right:12px;'>
						<span style='cursor:pointer;' onClick='drop_filter("", )'>&nbsp;X</span>
		</div>
		<?
	}
	?>
	
	<div class="row">
		<div class="col-md-12 col-sm-12 col-xs-6 column">
			<div class="search-term" style='margin-bottom:10px;'>
				<?if ($srch!=""){?>
					<b>""</b>
				<?}?>
				<span style='color:#999'>
					<?
					echo $cn_rec." ";
					if ($sr==2 or $sr==3)
						echo "compan".($cn_rec==1 ? "y" : "ies");
					else
						echo "item".($cn_rec==1 ? "" : "s");
					?>
				</span>
			</div>
		</div>
		
		<div class="col-md-12 col-sm-12 col-xs-6 column">
			<?
			// green squares as filter result
			if ($filtered_country!="")  echo filter_square("country",  $country,  $filtered_country);	// country=20, Belarus
			if ($filtered_category!="") echo filter_square("category", $category, $filtered_category);  // category=3, Energy 
			
			if ($sr==1){
			?>
			<div class="search-sort-form">
				<select name='sortby' onChange='sort_by(this.value)'>
					<option value=''>Sort By...
					<option value='relevancy' <?if ($sortby=="relevancy") echo "selected"?>>Relevancy
					<option value='recent'	  <?if ($sortby=="recent")    echo "selected"?>>Most Recent
					<option value='low2high'  <?if ($sortby=="low2high")  echo "selected"?>>Price Low to High
					<option value='high2low'  <?if ($sortby=="high2low")  echo "selected"?>>Price High to Low
				</select>
			</div>
			<?}?>
		</div>
		<div style='height:20px; clear:both;'></div>
		
		<div class="row">
		<?
		$i_count = 0;
		
		// PRODUCT LIST 
		if ($sr==1 or ($sr==4 and isset($_COOKIE_memb_id) and is_numeric($_COOKIE_memb_id))){
			$result = mysql_query($query_final);
			while($row = mysql_fetch_array($result)){
				$prod_id = $row["prod_id"];
				$product = $row["product"];
				$descr = $row["descr"];
				$descr = chopa($descr, 100);
				$photo = $row["photo"];
				$min_qty = $row["min_qty"];
				$min_unit = $row["min_unit"];
				$fob_currency = $row["fob_currency"];
				$fob_min = $row["fob_min"];
				$fob_max = $row["fob_max"];
				$comp_id = $row["comp_id"];
				$comp_url = $row["comp_url"];
				$comp_name = $row["comp_name"];
				$country_name = $row["country"];
				$product_url = $row["product_url"];
				//$membership = $row["membership"];
				//$color_border = $row["color_border"];
				
				$min_str = ($min_qty!=0) ? "<b>Minimum Order:</b> $min_qty  $min_unit" : "";
					
				$btype = "";
				$query2 = "SELECT B.typ FROM cc_business_types B 
							JOIN company2business C2B ON C2B.typ_id=B.id 
							JOIN companies C ON C.id=C2B.comp_id AND C.id='$comp_id'";
				$result2 = mysql_query($query2);
				while($row2 = mysql_fetch_array($result2)){
					$btype = $btype . $row2["typ"] . ", ";
				}
				$btype = commastrip($btype, 2);
				
				// is favorite product?
				if ($sr==1){
					$query2   = "SELECT COUNT(1) as cnp FROM members_favprod WHERE memb_id='$_COOKIE_memb_id' AND prod_id='$prod_id'";
					$result2  = mysql_query($query2);
					$row2     = mysql_fetch_array($result2, MYSQL_ASSOC);
					$is_fav_prod = ($row2['cnp']==0 ? false : true);
					if ($is_fav_prod){
						$fav_prod_color = $fav_prod_color1;
						$fav_prod_title = $fav_prod_title1;
					}
					else{
						$fav_prod_color = $fav_prod_color0;
						$fav_prod_title = $fav_prod_title0;
					}
					
					$fob_str = ($fob_min!=0) ? "<b>FOB Price: </b>".cast_price($fob_min, $fob_currency)  : "";
					
					$src_pic = "Media/Stores/$comp_id/small/$photo";
				}
				else{
					$fob_str = "";
					$range = cast_price($fob_min, $fob_currency, $fob_max);
					if ($range!="")
						$fob_str = "<b>Price Range: </b>".$range;
					
					$src_pic = "Media/Stores/$comp_id/Buying/$photo";
				}

				$i_count++;
				$borderbottom = ($i_count % $rec_per_page == 0) ? "search_block1_bb" : "";
				
				if ($photo=="") $src_pic = $BLANK_PROD;
				?>
				<div class="col-md-12 col-sm-12 col-xs-12" style='min-height:179px; border-bottom:1px solid #eee; padding-top:20px;'>
					<div style='float:left; width:200px; position:relative;'>
						<?if ($sr==1){?>
						<i class='fa fa-heart' style='position:absolute; top:-5px; left:155px; font-size:14px; cursor:pointer; color:;'
						title='' onClick="return fav_prod()" id='prod_heart_'></i>
						<?}?>
						
						<a href='