<?

	include_once("function_mobile_detect.php");
	$mobile_device = isMobileDevice();
	if($mobile_device)
	{
		header("Location: view_all_stock_mobile.php?type=".$type);
		die();
	}	


	include("config.php");
	if ( $_SESSION['ZAAUID'] == 0 )	
	{
		$_SESSION['ZAAUID'] = 0;
		include("header.php");
	}	
	else
		include "header_login.php";

	$mobile_device = isMobileDevice();
		
	include("function_stock_price.php");
	include("function_stock_panels.php");
	include("scripts_stock_panels.php");


	if($_REQUEST['cartype'])
		$bodytype = $_REQUEST['cartype'];


	if($_REQUEST['listview']) 
		$LISTVIEW = $_REQUEST['listview'];
	if(!$LISTVIEW)
		$LISTVIEW = 1;


	$price_color_list['Original'] 	= '#9D9C9D;text-decoration: line-through;';
	$price_color_list['Discounted'] = '#0099F4;';
	$price_color_list['50%'] 		= '#009148;';
	$price_color_list['100%'] 		= '#0060B9;';
	 

	$q = "SELECT payment_discount , payment_departure_days,refrence_exr_calc  FROM misc_setting   ";
	$r = pg_query($q);
	$row = pg_fetch_array($r);
	$payment_discount 		= json_decode($row['payment_discount'] , true);
	$payment_departure_days = $row['payment_departure_days']?:0;
	$refrence_exr_calc 		= $row['refrence_exr_calc']?:0;

	$dis_options = array();
	$dis_options['payment_departure_days'] 	= $payment_departure_days;
	$dis_options['payment_discount'] 		= $payment_discount;
	$dis_options['refrence_exr_calc'] 		= $refrence_exr_calc;
	
	
	$q = "SELECT cpfixedamountup FROM countryport  WHERE cpcountry = '$ZAACOUNTRY' ";
	$r = pg_query($q);
	$row = pg_fetch_array($r);
 	$misc_options['cpfixedamountup'] = $row['cpfixedamountup'];
 
	$sSQL = " SELECT * FROM exrate_prefrence WHERE exrate_country = 'JAMAICA' ";
	$result = pg_query($db,$sSQL);
	$line_ex_pref 		= pg_fetch_array($result, null, PGSQL_ASSOC);
	$exrate_slabs_jm 	= json_decode($line_ex_pref['exrate_slabs'] , true);


	$sSQL = " SELECT * FROM exrate_prefrence WHERE exrate_country = '$ZAACOUNTRY' ";
	$result = pg_query($db,$sSQL);
	if(pg_num_rows($result) == 0)
	{
		$sSQL = " SELECT * FROM exrate_prefrence WHERE exrate_country = 'Global' ";
		$result = pg_query($db,$sSQL);
	}
	 
	$line_ex_pref = pg_fetch_array($result, null, PGSQL_ASSOC);
	$exrate_slabs = json_decode($line_ex_pref['exrate_slabs'] , true);




	/*
	$ex_query  	= " SELECT  *  from exrate WHERE exdate <= NOW() ORDER by exdate desc LIMIT  1 ";
	$result 	= pg_query($db,$ex_query);
	$line_exr 	= pg_fetch_array($result, null, PGSQL_ASSOC);
	*/
	$exr_list = getExrList();
 

	$q = "SELECT  userid, auctionsheet ,realmilage_place, realaucpoints_place, auctionsheet_place , priceuptype, priceup,priceup_slabs,stk_liner,port,country,
				bidding_per ,  gct_per , auction_per,roadtax_per, freight_per,ff_per, recycle_per,
				storage_per, thc_per,blfee_per,radiation_per,custom_label1,custom_charges1, 
				trans_per1 ,trans_per2 , misc_per1 ,misc_per2 , misc_per3 ,
				custom_label2,custom_charges2,custom_label3 , custom_charges3 , eff_special_price , trans_setting , 
				bidding_price_1 , bidding_price_2 ,bidding_price_3, bidding_price_4 , bidding_price_5,
				fixed_price_1 , fixed_price_2, fixed_price_3, fixed_price_4, fixed_price_5, 
				bidding_per_1 , bidding_per_2, bidding_per_3, bidding_per_4, bidding_per_5, 
				bidding_m3_1 , bidding_m3_2, bidding_m3_3, bidding_m3_4, bidding_m3_5, 
				bidding_trans_1 , bidding_trans_2, bidding_trans_3, bidding_trans_4, bidding_trans_5  ,
				hand_charges1,hand_charges2,hand_charges3,hand_charges4,hand_charges5,hand_charges6,hand_charges7 , show_stock_no , hide_discount_price
			FROM customer WHERE userid = ".$_SESSION['ZAAUID'];
	 
	$result 			= pg_query($db,$q);
	$line_customer 		= pg_fetch_array($result, null, PGSQL_ASSOC);
	$cus_sel_liner 		= json_decode($line_customer['stk_liner'] , true);
	$show_stock_no 		= $line_customer['show_stock_no'];
	foreach($cus_sel_liner as $buy_country => $liner)
	{		 
		$qfr 	= "SELECT * FROM stk_freight WHERE buy_country = '".$buy_country."' 
						AND liner = '".$liner."' AND ship_country = '".$line_customer['country']."'  
						AND ship_port = '".$line_customer['port']."' 	";
	 	$result = pg_query($db, $qfr ) or die(pg_last_error());
		$row 	= pg_fetch_array($result);
		$freight_list[$buy_country] = $row;

	}




	if($_POST['apply_filter'])
	{
		$_SESSION['vash_filters'] = $_POST;
	}
	if($_REQUEST['rem_session'])
	{
		$carmaker 	= $_SESSION['vash_filters']['carmaker'];
		$carname 	= $_SESSION['vash_filters']['carname'];
		$global_search 		= $_SESSION['vash_filters']['global_search'];
		$nensikiy1 	= $_SESSION['vash_filters']['nensikiy1'];
		$nensikim1 	= $_SESSION['vash_filters']['nensikim1'];
		$nensikiy2 	= $_SESSION['vash_filters']['nensikiy2'];
		$nensikim2 	= $_SESSION['vash_filters']['nensikim2'];
		$place 		= $_SESSION['vash_filters']['place'];
		$stockno 	= $_SESSION['vash_filters']['stockno'];
		$stockno2	= $_SESSION['vash_filters']['stockno2'];
		$mileage1 	= $_SESSION['vash_filters']['mileage1'];
		$mileage2 	= $_SESSION['vash_filters']['mileage2'];
		$transmission = $_SESSION['vash_filters']['transmission'];
		$color 		= $_SESSION['vash_filters']['color'];
		$cc_from 	= $_SESSION['vash_filters']['cc_from'];
		$cc_to 		= $_SESSION['vash_filters']['cc_to'];
		$price_from = str_replace(',','',$_SESSION['vash_filters']['price_from']);
		$price_to 	= str_replace(',','',$_SESSION['vash_filters']['price_to']);
		$carfuel 	= $_SESSION['vash_filters']['carfuel'];
		
		$drivetype 		= $_SESSION['vash_filters']['drivetype'];
		$drivetype2 		= $_SESSION['vash_filters']['drivetype2'];
		
		$discount_tag 	= $_SESSION['vash_filters']['discount_tag'];
		$bodytype 		= $_SESSION['vash_filters']['bodytype'];
		$stype 			= $_SESSION['vash_filters']['stype'];
		$currency 		= $_SESSION['vash_filters']['currency'];

		$sort1 			= $_SESSION['vash_filters']['sort1'];
		$sort2 			= $_SESSION['vash_filters']['sort2'];
	}

	if(!$currency)
		$currency = 'usd';

	$price_curr = 'rate'.$currency;
?>
<script type="101e2c517abc96c41a0c5d7c-text/javascript">

	function CompareStock()
	{
		query = ''
		$('.sel_rec:checked').each(function(){
			query += '&caridchk[]=' + $(this).val()
		})
		
		window.open('compare_stock.php?'+query , "_compare");
		return false;
	}	
</script>
<style>
.pagination {
    display: inline-block;
    padding-left: 0;
    margin: 10px 0 0px 0px !important;
    border-radius: 4px;
}
.pagination > li > a, .pagination > li > span { font-size:12px;}
tr td:last-child{
   border-right:0px; 
}
.layerone{ padding-bottom:0px;}
#midsection{ padding:0px;}
.actms{ min-height:480px !important;}
.frm-field{ color:#333; width:130px;     font-size: 14px; padding: 4px !important;}
input.sbtn{height: 29px;   line-height: 22px;}
.search_icons {position: absolute !important; left: 20px; font-size: 16px; margin: 7px 0px; color:#eee;}
.form-indent { text-indent: 20px;}
.ms-choice{ border:none;}
.advstksearch1{ margin-bottom:3px;}

.suppercarsmallbox:hover {
	-moz-transform: scale(1.3);
	-webkit-transform: scale(1.3);
	transform: scale(1.3);
	transform: scale(1.3); /* (150% zoom - Note: if the zoom is too large, it will go outside of the viewport) */
	z-index:999; 
}
.midmid{ width:100%;}
.suppercarlft { width:98%; font-weight:normal}
.dataTables_filter{ display:none;}
.dataTables_info{ display:none;}
.discount_tag{ bottom:100px;}

.order_count{ color:#fff; font-size:14px; cursor:pointer; display:none; padding:0px 4px; border-radius:5px;}
.wharf_status{border:1px solid #ff1b1b; }
.discount_price{ position: absolute;  background-color: #ff0000; padding: 2px 5px; margin-left: -2px;  color: #ffffff;  font-size: 12px; font-weight: normal;  right: 17px;  border-radius: 0px;   top: 90px;  z-index: 9;    min-width: 60px;  text-align: center;}
.order_tag{ transform: rotate(0deg); top: 90px; min-width:65px;  border: none; font-weight:normal; left: 18px; width: auto; border-radius: 0px; padding:2px 6px !important; background-color: #e62565; font-size: 12px; color: #fff; text-transform: capitalize;}
.reserve_tag{ color:#2196f3 !important; }
.wharf_order{ color:#ffffff !important; }




/* Responsive Styles */
@media(max-width:1024px) {
	.midmid{ width:100% ;}

}
@media(max-width:991px) {
	.midmid{ width:100% ;}
}
@media(max-width:767px) {
	.midmid{width: 100% !important;  margin-left: 0px;}
	.suppercarlft { width:92%;}

}

<?
	if($LISTVIEW  == 2 || $LISTVIEW  == 3)
	{
	?> 
		.car_image{ width:110px !important; height:82px !important;}
	<? 
	}

 

	if($mobile_device)
	{
	?>
		.link{ font-size:16px !important;}
		.order_tag{  left: 55px; }

		.layertwo .maker_name{color: #FFFFFF !important; padding: 2px 0px; background-color: #9D9C9D; width: 100%; display: inline-block; position: relative; top:4px; }
		.layerthree { padding-top: 4px;}
		.layertwo{ height:215px; clear:both;}
	
	
		.list_view{ min-height:130px !important; padding: 0px !important;  border: 1px solid #eee;  border-radius: 15px;   margin-bottom: 3px;   margin-left: 5px;  margin-right: 5px;  width: 97%;}
		.list_view .layerone{float: right;    width: 69%; height:auto; padding-bottom:0px;}
		.list_view .layertwo{float: left;  width: 30%; height:auto;margin-top: 12px; margin-top: -25px;}
		.list_view .layerthree{float: right;    width: 69%; padding-top: 0px;}
		.list_view .lazy{width: 100px !important; border-radius:10px;  height: 80px !important; }
		.list_view .photo_count{ display:none;}
		.list_view .icons_list{ display:none;}
		.list_view .auction_type{ display:none;}
		.list_view .auction_details{ display:none;}
		.list_view .added_by{ margin:0px;}
		.list_view .list_view_only{ display:inline !important;}
		.list_view .maker_name{ display:none !important;}
		.list_view .order_tag {top: 100px; width: 100px; transform: none;color: #ff1b1b; border: none; font-size: 12px;}
		.list_view .icons{position: INITIAL; width: 69%; float: right; }
	
	
	<?
	}
	else
	{
	?>	
		.layertwo{ height:205px; clear:both;}
		.layertwo .maker_name{color: #FFFFFF !important; padding: 2px 0px; background-color: #9D9C9D; width: 100%; display: inline-block; position: relative; top:4px; }
		.layerthree { padding-top: 2px; float:left; width:100%;}
		 
		.discount_tag{font-size: 12px; font-weight:normal; padding:2px;}
		.discount_tag_img{ bottom:130px !important; border-radius:0px !important;} 
		.suppercarsmallbox{border-radius: 0px !important;}
	 
	<? 	
	}

	if($LISTVIEW == 1)
	{
?>
		.icons{ position:absolute;   width:95%; bottom:10px;}
		.country_tag{top:12px; right:20px; position:absolute;}
		.country_tag img{border:1px solid #ccc;border-radius: 50%;}
 
<?
	}
	else
	{
?>
		.icons{ position: relative; width: 95%; bottom: 0px; text-align: center;}
		.country_tag{ float:right; margin-right:3px;}
		.country_tag img{border:1px solid #ccc;border-radius: 50%;}
<?
	}
?>
 

@media (max-width: 767px){
	.car_image {width: 260px !important;height: auto !important;border-radius: 0px;}
	.layertwo { height:215px;}
	.layertwo .maker_name { width: 260px;   }
	.order_tag{ left:54px;}
	.btn{ margin:3px 0px;}

}

</style>






<script type="101e2c517abc96c41a0c5d7c-text/javascript">
	var remarkopt = new Array( );
	function Remark(m,n,t)
	{
		this.carmaker = m;
		this.carname = n;
		this.cartype = t;
	}
	<?
	 $result = pg_query($db,"SELECT DISTINCT carmaker,carname  
									FROM tenderstock 
									WHERE  shopid=0 AND tenderstock.deletedate IS NULL
								 ORDER BY carmaker,carname");
	$icc = 0;
	while (   $line = pg_fetch_array($result, null, PGSQL_ASSOC))
	{
		echo "remarkopt[$icc] = new Remark('$line[carmaker]','$line[carname]');\n";
		$icc++;
	}
	pg_free_result($result);
	?>


	function MakerSel(form_load)
	{
		FilterSelMul('maker' , 'maker_label' , 'Maker')

		maker = new Array()
		$('.maker:checked').each(function(){
			maker.push($(this).val())
		})
		
		sel_names = new Array()
		$('.name:checked').each(function(){
			sel_names.push($(this).val())
		})

		if(form_load != 1)
		{
			$("#name_panel .panel_body").html('')
			$("#code_panel .panel_body").html('') 	
		}	
	
		jcc = 1;
		html = "<li  ><input type=checkbox class='chkbox' onClick=\"SelectAllChkbox('.name' , $(this));NameSel()\" > ALL</li>";
		for ( i=1; i< remarkopt.length; i++)
		{
			if ( maker.indexOf(remarkopt[i].carmaker) != -1)
			{
 				html += "<li  "+(sel_names.indexOf(remarkopt[i].carname) != -1 ? 'class=highlight_field' : '')+"> <input type=checkbox class='chkbox name' name='carname[]' value='"+remarkopt[i].carname+"'  "+(sel_names.indexOf(remarkopt[i].carname) != -1 ? 'checked' : '')+" onClick='NameSel()' > "+ remarkopt[i].carname +"</li>";
				jcc++;		
			}
		}	 
		$("#name_panel .panel_body").html('<ul>'+html+'</ul>')
	
		 
	}
	
	var remarkopt2 = new Array();
	function Remark2(m,n,c)
	{
		this.carmaker = m;
		this.carname = n;
		this.code = c;
	}
	<?
	 $result = pg_query($db,"SELECT DISTINCT carmaker,carname,katasiki  
									FROM tenderstock 
 									WHERE  shopid=0 AND tenderstock.deletedate IS NULL  
								 ORDER BY carmaker,carname,katasiki");
	$icc = 0;
	while (   $line = pg_fetch_array($result, null, PGSQL_ASSOC))
	{
		echo "remarkopt2[$icc] = new Remark2('$line[carmaker]','$line[carname]','$line[katasiki]');\n";
		$icc++;
	}
	pg_free_result($result);
	?>

	function NameSel()
	{
	
		FilterSelMul('name' , 'name_label' , 'Name')
 	
		maker = new Array()
		$('.maker:checked').each(function(){
			maker.push($(this).val())
		})

		carname = new Array()
		$('.name:checked').each(function(){
			carname.push($(this).val())
		})

		sel_codes = new Array()
		$('.code:checked').each(function(){
			sel_codes.push($(this).val())
		})
		
		$("#code_panel .panel_body").html('').removeClass('active')	
		code_list = new Array()
		for ( i=1; i< remarkopt2.length; i++)
		{
			if ( maker.indexOf(remarkopt2[i].carmaker) != -1 &&  carname.indexOf(remarkopt2[i].carname) != -1)
			{
				code_list.push(remarkopt2[i].code)
			}
 		}
		code_list = [...new Set(code_list)].sort();

 		jcc = 1;
		html = "<li  ><input type=checkbox class='chkbox' onClick=\"SelectAllChkbox('.code' , $(this));CodeSel();\" > ALL</li>";
		for(i in code_list)
		{
			html += "<li  "+(sel_codes.indexOf(code_list[i]) != -1 ? 'class=highlight_field' : '')+"> <input type=checkbox class='chkbox code'  name='carcode[]' value='"+code_list[i]+"'  "+(sel_codes.indexOf(code_list[i]) != -1 ? 'checked' : '')+" onClick='CodeSel()' > "+ code_list[i] +"</li>";
			jcc++;		
		}	 
		$("#code_panel .panel_body").html('<ul>'+html+'</ul>')
		CodeSel()	
		
	}
	function CodeSel()
	{
		FilterSelMul('code','code_label','Code')
 	}

 
	function setPage(page)
	{
		$('#page').val(page)
		$('#stock_form').submit();
	}
	
	$(document).ready(function(){
		$('.ms-parent').width('')
		MakerSel(1)
		NameSel()
  		FilterSelMul('year','year_label','Year')
		FilterSelMul('fuel','carfuel_label','Fuel')		
		FilterSelMul('gear','gear_label','Gear')
		FilterSelMul('drivetype','drivetype_label','Steering')
		FilterSelMul('drivetype2','drivetype2_label','Drive')
 		FilterSelMul('drivetype2','drivetype2_label','Drive')
		FilterSelMul('color','color_label','Color')
		FilterSelMul('bodytype','bodytype_label','Body Type')
		FilterSelMul('place','place_label','Place')
		FilterSelMul('discount','discounted_label','Discounted')
		selectCC()
	})

	$(document).on('click', function(e) {
	  const $panel = $('.panel_search');
	  const $target = $(e.target);
	  
	  if (!$panel.is(e.target) && $panel.has(e.target).length === 0 && !$target.hasClass('search_label')) {
		$panel.hide(); // or $panel.addClass('hidden');
	  }
	});

</script>
<!-- Header Carousel -->
<div class="container nopadding">
  <header id="myCarousel" class="carouselin slide"> </header>
</div>

<!-- Page Content --> 

<?
			 

			if($_SESSION['ipcountry'] == 'JAPAN')	
				$supercar_sql = " AND coalesce(show_japan,'')  = '1' ";
			/*
			elseif($_SESSION['ipcountry'] == 'UNITED ARAB EMIRATES')
				$supercar_sql = " AND coalesce(country,'') != 'UNITED ARAB EMIRATES' AND place1 != 'FA' AND coalesce(exotic_super,'') != '1' ";
			*/	
			else 
				$supercar_sql = "";

 


			$pictures = 1;
			$gif  = 0;

			if($type == 'new')
			{
				$title =  'New Arrival';
				$class = 'midtwo';
				$class2 = 'actmstwo';
				$title_color = '#5EB6EF';
			}
			elseif($type == 'discount')
			{
				$title =  'Discounted';
				$class = 'midsix';
				$class2 = 'actmssix';
				$title_color = '#B2D411';
			}
			elseif($type == 'offerable')
			{
				$title =  'Offerable Stock';
				$class = 'midseven';
				$class2 = 'actmsseven';
				$title_color = '#D68755';
			}
			elseif($type == 'super')
			{
				$title =  'Exotic & Supercars';
				$class = 'suppercarh';
				$class2 = 'actms';
 				$gif = 0;
				$title_color = '#F14D4D';

			}
			elseif($type == 'brand_new')
			{
				$title =  'Brand New';
				$class = 'midthree';
				$class2 = 'actmsthree';
				$title_color = '#8D55E8';
			}
			elseif($type == 'machinery')
			{
				$title =  'Machinery & Others';
				$class = 'midfive';
				$class2 = 'actmsfive';
				$title_color = '#ECAF38';
			}
			elseif($type == 'dutytrucks')
			{
				$title =  'Light & Heavy Duty Trucks';
				$class = 'midfour';
				$class2 = 'actmsfour';
				$title_color = '#EA48AE';
			}
			elseif($type == 'special_offer')
			{
				$title 	=  'Special Offer';
				$class 	= 'mideight';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#d10f0f';
 
			}
			elseif($type == 'executive')
			{
				$title 	=  'Executive Class';
				$class 	= 'midten';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#8c5903';
 
			}elseif($type == 'exotics')
			{
				$title 	=  'Exotic Class';
				$class 	= 'midten';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#8c5903';
 
			}
			elseif($type == 'easter')
			{
				$title 	=  'Easter Offer';
				$class 	= 'mideight';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#d10f0f';
 
			}
			elseif($type == 'christmas')
			{
				$title 	=  'Christmas Offer';
				$class 	= 'mideight';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#d10f0f';
 
			}
			elseif($type == 'lhd')
			{
				$title 	=  'Left Hand Drive';
				$class 	= 'midtwelve';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#ff6600';
 
			}
			elseif($type == 'commercial')
			{
				$title 	=  'Commercial Vehicles';
				$class 	= 'mideleven';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#bd9e69';
 
			}
			elseif($type == 'accidental')
			{
				$title 	=  'Accidental Vehicles';
				$class 	= 'midthirteen';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#bd9e69';
 
			}
			elseif($type == 'motorcycle')
			{
				$title 	=  'Motorcycles';
				$class 	= 'midthirteen';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#bd9e69';
 			}
			 
			elseif($type == 'kfz')
			{
				$title 	=  'Kingston Free Zone Stock';
				$class 	= 'midthirteen';
				$class2 = 'actms';
				$gif  = 0;
				$title_color = '#bd9e69';
 
			}
 			else
			{
				$title =  'Stock List';
				$class = 'mideleven';
				$class2 = 'actmstk';
				$title_color = '#bd9e69';
			}
			
			$whereSQL = "  AND  rno < $partsstart ";
			if($type != 'executive' && $type != 'machinery' && $type != 'motorcycle' && $type != 'super' && $type != 'exotics')		 	   
				$whereSQL .= " AND (tenderstock.deletedate IS NULL  or tenderstock.eff_deletedate > current_date OR   coalesce(exotic_super,'') = '1' )  "; //AND (buytype != 'JAPAN' OR (buytype = 'JAPAN' AND coalesce(customer.country , 'JAPAN') NOT IN ('UNITED ARAB EMIRATES')))
			if($type == 'new')
					$whereSQL .= "    AND  ( tenderstock.buydate > '".date("Y-m-d" , strtotime("-120 days"))."')   "; 
			if($type == 'discount')
					$whereSQL .= "     AND  hotsw=1     "; 
			if($type == 'offerable')
					$whereSQL .= "     AND  oasw=1   "; 
			if($type == 'super')
					$whereSQL .= "     AND rno > 71000  AND  coalesce(exotic_super,'') = '1'    "; 
			if($type == 'exotics')
					$whereSQL .= "     AND  ( coalesce(exotic_super,'') = '1'  OR  ivuserid IN ( 30132  ) )"; 
					
			if($type == 'brand_new')
					$whereSQL .= "     AND  cartype = 'Brand New'   "; 
			if($type == 'machinery')
					$whereSQL .= "     AND  bodytype = '28'    "; 
			if($type == 'dutytrucks')
					$whereSQL .= "     AND  bodytype IN ('7' , '17' , '4', '3' ,'19', '20', '9' , '30', '31', '32', '33')    "; 
			if($type == 'special_offer')
					$whereSQL .= "     AND  (place1 = 'AU' or   special_offer = '1' )    "; 
			/*
			if($type == 'executive')
					$whereSQL .= "     AND  executive_class = '1'     "; //AND   bodytype IN ('1' , '8') AND biddingprice > 2000000	
			*/		
  		
			if($type == 'easter')
					$whereSQL .= "     AND (( tenderstock.discount_tag = 'Easter Sale' AND (tenderstock.deletedate IS NULL  or tenderstock.eff_deletedate > current_date ) ))    ";
			if($type == 'christmas')
					$whereSQL .= "     AND (( tenderstock.discount_tag = 'Christmas Sale' AND (tenderstock.deletedate IS NULL  or tenderstock.eff_deletedate > current_date ) ))    ";
			if($type == 'executive')
					$whereSQL .= "     AND (show_fake_stock = '1' OR  (executive_class = '1' AND (tenderstock.deletedate IS NULL  or tenderstock.eff_deletedate > current_date ) ))    ";
 
			if($type == 'motorcycle')
					$whereSQL .= "     AND   bodytype IN ('6')   	   "; 
			if($type == 'commercial')
					$whereSQL .= "     AND   bodytype IN ('2' , '15' , '24')   	   "; 
			if($type == 'lhd')
					$whereSQL .= "     AND  drivetype = 'left'	  "; 
			if($type == 'accidental')
					$whereSQL .= "     AND   accidentsw= '1'  "; 
			elseif($type == 'kfz')					
					$whereSQL .= "     AND   tenderinvoice.ivuserid = 27153 AND tenderstock.deletedate is null  "; 

 			if(strpos(strtoupper($global_search) , 'ORDER') !== FALSE)
				$whereSQL .= " AND ivorderdate is not null ";
			elseif($global_search)
				$whereSQL .= " AND upper(tenderstock.carmaker || tenderstock.carname  || coalesce(bodytype,0)  || coalesce(chassis,'')  || nensikiy  || tenderstock.color  || coalesce(carmodel,'')  || place1 || '-'  || rno) LIKE '%".strtoupper($global_search)."%' ";
 
			if(countphp($carmaker) > 0)
				$whereSQL .= " AND carmaker IN ('".implode("','" , $carmaker)."')";
			 
			if(countphp($carname) > 0)
				$whereSQL .= " AND carname IN ('".implode("','" , $carname)."')";

			if(countphp($carcode) > 0)
				$whereSQL .= " AND katasiki IN ('".implode("','" , $carcode)."')";
		
			if(countphp($caryear) > 0)
				$whereSQL .= " AND nensikiy IN ('".implode("','" , $caryear)."')";

  			if(countphp($place_list))
				$whereSQL .= " AND place1 IN ('".implode("','" , $place_list)."')  ";
			if(countphp($transmission_list))
				$whereSQL .= " AND transmission IN ('".implode("','" , $transmission_list)."')  ";
			if(countphp($bodytype_list))
				$whereSQL .= " AND bodytype IN ('".implode("','" , $bodytype_list)."')  ";
			if(countphp($color_list))
				$whereSQL .= " AND tenderstock.color IN ('".implode("','" , $color_list)."')  ";

			if(countphp($carfuel))
				$whereSQL .= " AND carfuel IN ('".implode("','" , $carfuel)."')  ";
			if(countphp($drivetype))
				$whereSQL .= " AND drivetype IN ('".implode("','" , $drivetype)."')  ";
			if(countphp($drivetype2))
				$whereSQL .= " AND drivetype2 IN ('".implode("','" , $drivetype2)."')  ";
			if(countphp($discount_tag))
				$whereSQL .= " AND tenderstock.discount_tag IN ('".implode("','" , $discount_tag)."')  ";

 			if($stockno && !$stockno2)
				$whereSQL .= " AND rno = '$stockno' ";
			if($stockno)
				$whereSQL .= " AND rno >= '$stockno' ";
			if($stockno2)
				$whereSQL .= " AND rno <= '$stockno2' ";
			/*
 			if($cc_from)
				$whereSQL .= " AND carcc >= '$cc_from' ";
			if($cc_to)
				$whereSQL .= " AND carcc <= '$cc_to' ";
			*/
			$cc_ranges = array();
			for($i=1;$i<=5;$i++)
			{
				$ccfrom = $_POST['cc_from'.$i];
				$ccto = $_POST['cc_to'.$i];
				if($ccfrom && $ccto)
				{
					$cc_ranges[] = array($ccfrom,$ccto);
 				}	
			}
			
			if(countphp($cc_ranges))
			{
 				$cc_clause = '';
				foreach($cc_ranges as $range)
				{
					 
					$cc_clause .= " OR (tenderstock.carcc >=  '".intval($range[0]) ."' AND tenderstock.carcc <=  '".intval($range[1]) ."') "; 
				}
				if($cc_clause)
				$whereSQL .= " AND ( FALSE ".$cc_clause.") ";
 			}


		 
 			if(countphp($sel_rec))
				$whereSQL .= " AND carid IN (".implode(',',$sel_rec).") ";
 		
			if($_SESSION['ipcountry'] == 'JAPAN')
				$whereSQL .= "  AND coalesce(show_japan,'')  = '1' ";
    
	 

			if($stock_status == 'arrived')
				$whereSQL .= "  AND tenderinvoice.ivarrivedate <=  current_date ";
			
			if($stock_status == 'shipped')
				$whereSQL .= "  AND tenderinvoice.ivshipdate <=  current_date AND tenderinvoice.ivarrivedate > current_date ";
			
			if($stock_status == 'waitingship')
				$whereSQL .= "   AND (tenderinvoice.ivshipdate is null  OR tenderinvoice.ivshipdate > current_date) ";
			if($supercar_sql )
				$whereSQL .= "  $supercar_sql ";

			if($submit == 'inspected_direct')
				$whereSQL .= " AND tenderinvoice.ivinsp_status = 'Pass' ";
			if($submit == 'promotion_stock')
				$whereSQL .= " AND tenderstock.discount_tag != '' ";
			if($submit == 'kingston_stock')
				$whereSQL .= "  AND ivuserid = 27153 ";

			$whereSQL .= "  AND coalesce(hide_customer,'') != '1' ";


 			//print $whereSQL;


			$SLISTPAGE 	= $page_size?:90;
			$SPAGE 		= 1;
			if ( strlen($page) > 0 )
			{
				$SPAGE = $page;
			}
			
			$sql =  "SELECT count(rno) as cnt
						FROM tenderstock 
							LEFT JOIN dealer_stock ON id = carid::text AND  source = 'zm'
							LEFT JOIN tenderinvoice ON carid=ivcarid AND ivvalid=1  
							LEFT JOIN customer  on tenderinvoice.ivuserid = userid
						WHERE true $whereSQL $supercar_sql ";
			$result = pg_query($db,$sql);
			if ( $line = pg_fetch_array($result, null, PGSQL_ASSOC))
			{
				$cartotal = $line['cnt'];
				if ( $SLISTPAGE > 0 )
				{
					$cnt = $cartotal / $SLISTPAGE;
				}
			}

			 
			if($payment_discount_units || $submit == 'discounted_stock' )
				$cartotal = -1;
			$paging_html =  getPaginationString($SPAGE , $cartotal, $SLISTPAGE   , 2 , 'view_all_stock_home.php' , '?type='.$type.'&cartype='.$cartype.'&rem_session=1&page=' );

?>
<title></title>
<div id="midsection">
	<div class="container nopadding ">
	
	  <div class="midmid" >
		  <div class="midone">
			 
			<form  id="stock_form"  name="PSRC" ACTION="view_all_stock_home.php" method="post"> <!-- ?type= -->
			<input type="hidden" name="listview" value=""	   />
			<input type="hidden" name="type" id="type" value=""	   />
			<input type="hidden" name="stock_status" id="stock_status" value=""	   />
			<input type="hidden" name="cartype" id="cartype" value=""	   />
			
			
			<input type="hidden" name="page" id="page" value=""	   />
			<input type="hidden" name="apply_filter" id="apply_filter" value="1"	   />
			<div class="search_filter_panel"  >
		         <div   >
	 
				<div class="row advstksearch1" style="color:black"  >
					<div class="col-md-6 toogle_text" >
					
						<a href="view_all_stock_home.php?direct=1" style="color:#0066ff; text-decoration:underline;">All Stock</a> <i class="fa-solid fa-chevron-right" ></i>
					  <? print $title ?>
					</div>  
					<?
					if($_SESSION['ipcountry'] != 'JAPAN' && !$mobile_device)
					{
					?>
						<div class="col-md-6 toogle_text wow pulse animated" style="text-align:right"   data-wow-delay='300ms' data-wow-iteration="infinite" data-wow-duration="2s" >
						  <a  target="_blank" href="view_all_stock_home.php?type=super" style="color:red; text-decoration:underline; margin-right:20px;">Exotic &amp; Supercars</a>
						  &nbsp; 
						  <a  target="_blank" href="jamaica_wharf_stock.php" style="color:#009b3a; text-decoration:underline;margin-right:20px;">Kingston Free Zone Stock</a>
						  &nbsp; 
						</div>  
					<?
					}
					?>
				</div>
		 		<?
					if(!$mobile_device)
					{
				?>
						<div class="row advstksearch1 hidden-md hidden-sm hidden-lg"    > 
							<div class="col-md-12" >
								<div style="float:right;padding: 0px 0px 0px 15px; ">
									<A href="?listview=1&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-image"></i> </A>
									<A href="?listview=2&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-list" ></i> </A>
									<A href="?listview=3&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-th-list" ></i> </A> 
									<A href="?listview=4&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-bars" ></i> </A> 
								</div>	
							</div>	
						</div>
				<?
					}
				?>
				<div class="row advstksearch1"  >
				
				<div class="col-md-4 col-sm-4  col-xs-6" style="margin-top: 5px">
					<span class="search_icons glyphicon  glyphicon-search" aria-hidden="true" onclick="if (!window.__cfRLUnblockHandlers) return false; $('#search').click()" style=" right: 15px; left: auto; color:#FFFFFF; cursor:pointer; background: #ff5722 ; text-align: center; height:33px; padding: 8px; top: -6px; border-top-right-radius: 5px; border-bottom-right-radius: 5px;" data-cf-modified-101e2c517abc96c41a0c5d7c-=""></span>
					<input type="TEXT" maxlength="8" value=""  style="text-indent: 0px;" name="global_search" class="form-control search_field form-indent" placeholder="Global Search">
				</div>	
				<div class="col-md-2  col-sm-4 col-xs-6" style="margin-top: 7px">
					
				</div>
				<div class="col-md-8 hidden-xs"  >
					
				 
					<div style="float:right;padding: 0px 0px 0px 15px;">
						<A href="?listview=1&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-image"></i> </A>
						<A href="?listview=2&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-list" ></i> </A>
						<A href="?listview=3&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-th-list" ></i> </A> 
						<A href="?listview=4&rem_session=1&type=" style="font-size:20px;"><i class="fa fa-bars" ></i> </A> 
					</div>			
				
					<div style="float:right;  ">
					
					<?
						
						if($cartotal > 40)
						{
							?>
							<span style="font-size: 15px;position: relative; " >
								Page  
								<select name="page_size" onchange="if (!window.__cfRLUnblockHandlers) return false; submit()" style="height:24px !important;" class="search_field" data-cf-modified-101e2c517abc96c41a0c5d7c-="">
								  <option value="30" >30 </option>
								  <option value="90" >90 </option>
								  <option value="180" >180 </option>
								  <option value="600" >600 </option>
								   <option value="-1" >ALL </option>
								</select>			
								 
							<?
							//	if($paging_html)
							//		print 'Page No';
							?>	
							</span>		
							<? 
							//print $paging_html;
						}	
					?>
					</div>
				</div>
				
				 
				
				
				
				
				
				</div>								 			  
				<div class="row advstksearch1"  >
				 
						 
					<div class="col-md-2  col-sm-4 col-xs-6">
							
							<span class="search_label maker_label " onclick="if (!window.__cfRLUnblockHandlers) return false; show_panel('#maker_panel')" data-cf-modified-101e2c517abc96c41a0c5d7c-="">Maker</span>

							<div  class="panel_search quick_panel_search" id="maker_panel"  >
								<div class="panel_head">
									<strong>Select Maker</strong><br />
									<input type="text" name="global_search_field" class="global_search_field" size="25" placeholder="Search" onkeyup="if (!window.__cfRLUnblockHandlers) return false; globalSearch('#maker_panel' , $(this))" data-cf-modified-101e2c517abc96c41a0c5d7c-="" />
								</div>
								<div class="panel_body" style="height:300px">
									<ul>
											<li ><input type=checkbox class='chkbox' onClick="if (!window.__cfRLUnblockHandlers) return false; SelectAllChkbox('.maker' , $(this));MakerSel(0);" data-cf-modified-101e2c517abc96c41a0c5d7c-=""> ALL</li>
											<?
												$preffered_makers = array('TOYOTA','HONDA','NISSAN','MERCEDES BENZ','MERCEDES AMG' ,'BENTLEY', 'ROLLS ROYCE','LAMBORGHINI', 'FERRARI' );
												foreach($preffered_makers as $maker  )
												{
													print "<li    ><input type=checkbox class='chkbox maker' name='carmaker[]' ".(in_arrayphp($maker,$carmaker) ? 'checked' : '' )." value='".$maker."' onClick="if (!window.__cfRLUnblockHandlers) return false; \&quot;MakerSel(0)\&quot;" data-cf-modified-101e2c517abc96c41a0c5d7c-=""> ".$maker."</li>";
												}

												$sSQL = "SELECT DISTINCT carmaker 
															FROM tenderstock 
 															WHERE shopid=0 AND tenderstock.deletedate IS NULL   AND carmaker > ' ' ORDER BY carmaker";
												$result = pg_query($db,$sSQL) ;
												while ( $line = pg_fetch_array($result, null, PGSQL_ASSOC))
												{
													print "<li    ><input type=checkbox class='chkbox maker' name='carmaker[]' ".(in_arrayphp($line['carmaker'] , $carmaker) ? 'checked' : '' )." value='".$line[' carmaker']."' onClick="if (!window.__cfRLUnblockHandlers) return false; MakerSel(0)" data-cf-modified-101e2c517abc96c41a0c5d7c-=""> ".$line['carmaker']."</li>";
												}
												pg_free_result($result);
												
											 
											?>
									</ul>
								</div>
								 
							</div>		


					 </div>
					<div class="col-md-2 col-sm-4  col-xs-6">
						
						<span class="search_label name_label " onclick="if (!window.__cfRLUnblockHandlers) return false; show_panel('#name_panel')" data-cf-modified-101e2c517abc96c41a0c5d7c-="">Name</span>

							<div  class="panel_search quick_panel_search" id="name_panel"  >
								<div class="panel_head">
									<strong>Select Name</strong><br />
									<input type="text" name="global_search_field" class="global_search_field" size="25" placeholder="Search" onkeyup="if (!window.__cfRLUnblockHandlers) return false; globalSearch('#name_panel' , $(this))" data-cf-modified-101e2c517abc96c41a0c5d7c-="" />
								</div>
								<div class="panel_body" style="height:400px">
									<ul>
											 
									</ul>
								</div>
								 
							</div>		
						
						 
					
					</div>		
 					<div class="col-md-2 col-sm-4  col-xs-6">
					
							<span class="search_label code_label " onclick="if (!window.__cfRLUnblockHandlers) return false; show_panel('#code_panel')" data-cf-modified-101e2c517abc96c41a0c5d7c-="">Code</span>

							<div  class="panel_search quick_panel_search" id="code_panel"  >
								<div class="panel_head">
									<strong>Select Code</strong><br />
									<input type="text" name="global_search_field" class="global_search_field" size="25" placeholder="Search" onkeyup="if (!window.__cfRLUnblockHandlers) return false; globalSearch('#code_panel' , $(this))" data-cf-modified-101e2c517abc96c41a0c5d7c-="" />
								</div>
								<div class="panel_body" style="height:400px">
									<ul>
											  
											 
									</ul>
								</div>
								 
							</div>		
					 </div>
 					<div class="col-md-2 col-sm-4  col-xs-6">
						 
							<span class="search_label year_label " onclick="if (!window.__cfRLUnblockHandlers) return false; show_panel('#year_panel')" data-cf-modified-101e2c517abc96c41a0c5d7c-="">Year</span>

							<div  class="panel_search quick_panel_search" id="year_panel"  >
								<div class="panel_head">
									<strong>Select Year</strong><br />
									<input type="text" name="global_search_field" class="global_search_field" size="25" placeholder="Search" onkeyup="if (!window.__cfRLUnblockHandlers) return false; globalSearch('#year_panel' , $(this))" data-cf-modified-101e2c517abc96c41a0c5d7c-="" />
								</div>
								<div class="panel_body" style="height:400px">
									<ul>
											<li  ><input type=checkbox class='chkbox' onClick="if (!window.__cfRLUnblockHandlers) return false; SelectAllChkbox('.year' , $(this));FilterSelMul('year','year_label','Year');" data-cf-modified-101e2c517abc96c41a0c5d7c-=""> ALL</li>
											<script src="/cdn-cgi/scripts/7d0fa10a/cloudflare-static/rocket-loader.min.js" data-cf-settings="101e2c517abc96c41a0c5d7c-|49" defer></script>