<? 
error_reporting(0); 

session_start();
ob_start();

//vars op 0
//vars op 0
$crmerk = ""; $crmodel = ""; $crtype = ""; $crbouwjaarmaand = ""; $crbouwjaarjaar = 9999; $crcategorie = "0"; $crbak = "0"; $crbrandstof = "0"; 
$crcilinhoud = ""; $crvermogen = ""; $crprijs = ""; $crkmstand = ""; $crkleuren = "G"; $crdeur = "0"; $crapkmaand = date("m");
$crapkjaar = date("Y")+1; $accessoires = ""; $croveropties = "";$cromschrijving = ""; $crnaam = ""; $cremailadres = ""; $crtelefoon =""; $crplaats = ""; 
$crpostcode = ""; $crprovincie = ""; $crprijsto = ""; $crbouwjaar = false; $crbouwjaarto = false; $crkmstandto = false;$crvermogento = false;$orderuld="";
$aanbieder = 3; $afstand = ""; $postcode = ""; $cookiepcode = "";
//doorstuur sessie op 0
if (isset($_REQUEST["doorstrpag"])) {
        unset($_SESSION["doorstrpag"]);
}
$topmenu = "zoeken";

include("includes/header.php");
include("includes/dbconnect.php"); 	


// meta
$pagtitel = "Zoek hier uw nieuwe oldtimer, Classicplaza.nl";
$metaomsch = "Uitgebreid zoeken naar uw oldtimer";
$ajaxzkscherm = 1;

//form verwerlen
if (isset($_REQUEST["occasion"]) || isset($_REQUEST["bck"])){
$noggoogleads = 1;
	$url = "";
	if (isset($_REQUEST["offset"])) 
	$offset = round(Stripdanger($_REQUEST["offset"])); 
	if (is_numeric($offset)===false || $offset<1)
	{
	 $offset = 0;
	}
	$limit = 10; // aantal autos per pagina
	
	if(isset($_REQUEST["sort"])){
	$orderlist = StripDanger($_REQUEST["sort"]);
	$orderuld = "&sort=$orderlist";
	    switch($orderlist){ 
    
		case "mu" : $ordert = " merk ASC, model ASC "; 
		break; 
		case "md" : $ordert = " merk DESC, model DESC "; 		
		break; 
		case "pu" : $ordert = " prijs ASC ";
		break; 
		case "pd" : $ordert = " prijs DESC ";
		break;		
		case "bu" : $ordert = " bouwjaar ASC ";
		break;	
		case "bd" : $ordert = " bouwjaar DESC ";
		break;			
		case "ku" : $ordert = " kmstand ASC ";
		break;	
		case "kd" : $ordert = " kmstand DESC ";
		break;			
		
		default : $ordert = " geplaatst DESC ";
    
    } 
	
	
	}
	if(empty($ordert))
	$ordert = " geplaatst DESC ";
	
	$crsql = "";
	

	////////// QUERIES ///////////
	
	$crmerk = StripDanger(urldecode($_REQUEST["crmerk"]));
	$crmodel = StripDanger(urldecode($_REQUEST["crmodel"]));
	$crtype = StripDanger(urldecode($_REQUEST["crtype"]));
	$crcategorie = StripDanger($_REQUEST["crcategorie"]);
	$crbak = StripDanger($_REQUEST["crbak"]);
	$crbrandstof = StripDanger($_REQUEST["crbrandstof"]);
	$crprijs = StripDanger(round($_REQUEST["crprijs"]));
	$crprijsto = StripDanger(round($_REQUEST["crprijsto"]));
	$crkleuren = StripDanger($_REQUEST["crkleuren"]);
	$crdeur = StripDanger($_REQUEST["crdeur"]);
	$aanbieder = round(StripDanger($_REQUEST["aanbieder"]));
	
	
	// bij nieuwe opgegeven postcode nieuwe coordinaten zoeken
	if (isset($_COOKIE["postcode"])) $cookiepcode = $_COOKIE["postcode"];
	
	if (isset($_POST["postcode"]) && ($_POST["postcode"] <> $cookiepcode) && ($_POST["postcode"]!="Postcode")){
		
	// postcode gepost met form
	// nu omzetten naar cookie en long en lat opzoeken en ook in cookie
		$postcode = substr(round(StripDanger($_POST["postcode"])),0,4);
		if($postcode>1000){

	
			$gadress	= urlencode("$postcode, Netherlands");
			$urladdress = "http://maps.google.com/maps/geo?q=$gadress&output=csv&key=".STD_GOOGLE_MAPS;
			
			$geocode = htmlspecialchars(file_get_contents($urladdress));
			
			$splitxx = explode(",", $geocode);
			$glatitude  = "$splitxx[2]";
			$glongitude  = "$splitxx[3]";					
		
			header("Cache-control: private"); // ie 6 fix 
			header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"'); 
			$cdomain = ".".STD_DOMEIN;
			setcookie("postcode", $postcode, time()+60*60*24*90,"/", $cdomain, 0); 	
			setcookie("glatitude", $glatitude, time()+60*60*24*90,"/", $cdomain, 0); 	
			setcookie("glongitude", $glongitude, time()+60*60*24*90,"/", $cdomain, 0); 	
	
		
		}
		
	
	}	
	$afstand = round(StripDanger($_REQUEST["afstand"]));
	switch($afstand){ 
	//  grappenmaker uitsluiten
		case "15" : $afstand = 15; 
		break; 
		case "25" : $afstand = 25; 		
		break; 
		case "50" : $afstand = 50; 		
		break; 
		case "75" : $afstand = 75; 		
		break; 		
		case "100" : $afstand = 100; 		
		break; 		
		case "150" : $afstand = 150; 		
		break; 
		case "200" : $afstand = 200; 		
		break; 
		default : $afstand = "";
	}
	

        // kleuren  deur  accessoires           provincie 
		if(isset($_REQUEST["dealerid"])){
			$verkoperid = round(StripDanger($_REQUEST["dealerid"]));
			$crsql = " AND bedrijfid = '$verkoperid' ";
			$url .= "&dealerid=$verkoperid";	
		}
				   
		// type aanbieder = bedrijf
		if (isset($aanbieder) && $aanbieder==1 ) {
		$crsql = " AND zakelijk = '1' ";
		$url .= "&aanbieder=1";		
		}
		// type aanbieder = particulier
		elseif (isset($aanbieder) && $aanbieder==2 ) {
		$crsql = " AND zakelijk = '0' ";
		$url .= "&aanbieder=2";		
		}
		else $aanbieder = 3;
			// merk
		if (isset($crmerk) && $crmerk!=="" ) {
			$crsql .= " AND merk = '$crmerk' ";
			$seo_merk_url = urlencode($crmerk);
			$url .= "&crmerk=$seo_merk_url";
			
			}else $crmerk = "";
		//model
		if (isset($crmodel) && $crmodel!=="" ) {		
		$crsql .= " AND model LIKE '%$crmodel%' ";
		$url .= "&crmodel=$crmodel";
		}else $crmodel = "";
		//type
		if (isset($crtype) && $crtype!=="" ) {		
		$crsql .= " AND mdtype LIKE '%$crtype%' ";
		$url .= "&crtype=$crtype";
		}else $crtype = "";
		//bouwjaar
		$crbouwjaar = StripDanger(round($_REQUEST["crbouwjaar"]));
		$crbouwjaarto = StripDanger(round($_REQUEST["crbouwjaarto"]));
			if($crbouwjaarto<=$crbouwjaar)
				$crbouwjaarto = 0;
			
			if($crbouwjaar<1 && $crbouwjaarto<1 ){
				$crbouwjaar = ""; $crbouwjaarto = "";
			}
			elseif($crbouwjaar>1 && $crbouwjaarto<1 ){
				$crbouwjaars = $crbouwjaar*100;
				$crsql .= " AND bouwjaar >= '$crbouwjaars' ";
				$url .= "&crbouwjaar=$crbouwjaar";	
				$crbouwjaarto = "";		
			}
			elseif($crbouwjaar<1 && $crbouwjaarto>1 ){
				$crbouwjaartos = $crbouwjaarto*100;
				$crsql .= " AND bouwjaar <= '$crbouwjaartos' ";
				$url .= "&crbouwjaarto=$crbouwjaarto";	
				$crbouwjaar = "";		
			}
			elseif($crbouwjaar>1 && $crbouwjaarto>1 ){ // huurprijs BETWEEN '$zk_huurprijs_from' AND '$zk_huurprijs_to'
				$crbouwjaars = $crbouwjaar*100;
				$crbouwjaartos = $crbouwjaarto*100;
				$crsql .= " AND bouwjaar BETWEEN '$crbouwjaars' AND '$crbouwjaartos' ";
				$url .= "&crbouwjaar=$crbouwjaar&crbouwjaarto=$crbouwjaarto";	
			}	
		//crcategorie
			if (isset($crcategorie) && $crcategorie!=="" ) {
		$crsql .= " AND categorie = '$crcategorie' ";
		$url .= "&crcategorie=$crcategorie";
		}else $crcategorie = "";	
		//crbak
			if (isset($crbak) && $crbak!=="" ) {
		$crsql .= " AND transmissie = '$crbak' ";
		$url .= "&crbak=$crbak";
		}else $crbak = "";
		//crbrandstof
			if (isset($crbrandstof) && $crbrandstof!=="" ) {
		$crsql .= " AND brandstof = '$crbrandstof' ";
		$url .= "&crbrandstof=$crbrandstof";
		}else $crbrandstof = "";		
		//vermogen
		$crvermogen = StripDanger(round($_REQUEST["crvermogen"]));
		$crvermogento = StripDanger(round($_REQUEST["crvermogento"]));
			if($crvermogento<=$crvermogen)
				$crvermogento = 0;
			
			if($crvermogen<1 && $crvermogento<1 ){
				$crvermogen = ""; $crvermogento = "";
			}
			elseif($crvermogen>1 && $crvermogento<1 ){
				$crsql .= " AND vermogen >= '$crvermogen' ";
				$url .= "&crvermogen=$crvermogen";	
				$crvermogento = "";		
			}
			elseif($crvermogen<1 && $crvermogen>1 ){
				$crsql .= " AND crvermogen <= '$crvermogento' ";
				$url .= "&crvermogento=$crvermogento";	
				$crvermogen = "";		
			}
			elseif($crvermogen>1 && $crvermogento>1 ){ // huurprijs BETWEEN '$zk_huurprijs_from' AND '$zk_huurprijs_to'
				$crsql .= " AND vermogen BETWEEN '$crvermogen' AND '$crvermogento' ";
				$url .= "&crvermogen=$crvermogen&crvermogento=$crvermogento";	
			}	
		//prijs

			if($crprijsto<=$crprijs)
				$crprijsto = 0;
			
			if($crprijs<1 && $crprijsto<1 ){
				$crprijs = ""; $crprijsto = "";
			}
			elseif($crprijs>1 && $crprijsto<1 ){
				$crsql .= " AND prijs >= '$crprijs' ";
				$url .= "&crprijs=$crprijs";	
				$crprijsto = "";		
			}
			elseif($crprijs<1 && $crprijsto>1 ){
				$crsql .= " AND prijs <= '$crprijsto' ";
				$url .= "&crprijsto=$crprijsto";	
				$crprijs = "";		
			}
			elseif($crprijs>1 && $crprijsto>1 ){ // huurprijs BETWEEN '$zk_huurprijs_from' AND '$zk_huurprijs_to'
				$crsql .= " AND prijs BETWEEN '$crprijs' AND '$crprijsto' ";
				$url .= "&crprijs=$crprijs&crprijsto=$crprijsto";	
			}

		//kmstand
		$crkmstand = StripDanger(round($_REQUEST["crkmstand"]));
		$crkmstandto = StripDanger(round($_REQUEST["crkmstandto"]));
			if($crkmstandto<=$crkmstand)
				$crkmstandto = 0;
			
			if($crkmstand<1 && $crkmstandto<1 ){
				$crkmstand = ""; $crkmstandto = "";
			}
			elseif($crkmstand>1 && $crkmstandto<1 ){
				$crsql .= " AND kmstand >= '$crkmstand' ";
				$url .= "&crkmstand=$crkmstand";	
				$crkmstandto = "";		
			}
			elseif($crkmstand<1 && $crkmstandto>1 ){
				$crsql .= " AND kmstand <= '$crkmstandto' ";
				$url .= "&crkmstandto=$crkmstandto";	
				$crkmstand = "";		
			}
			elseif($crkmstand>1 && $crkmstandto>1 ){ // huurprijs BETWEEN '$zk_huurprijs_from' AND '$zk_huurprijs_to'
				$crsql .= " AND kmstand BETWEEN '$crkmstand' AND '$crkmstandto' ";
				$url .= "&crkmstand=$crkmstand&crkmstandto=$crkmstandto";	
			}
		//kleuren
			if (isset($crkleuren) && $crkleuren!=="" ) {
		$crsql .= " AND kleuren = '$crkleuren' ";
		$url .= "&crkleuren=$crkleuren";
		}else $crkleuren = "";
		//deuren
			if (isset($crdeur) && $crdeur!=="" ) {
		$crsql .= " AND deur = '$crdeur' ";
		$url .= "&crdeur=$crdeur";
		}else $crdeur = "";
		
	// bepaalde afstand opgeven
	if (isset($afstand) && $afstand!=0 ) {
	
			$url .= "&afstand=$afstand";
	
			if(isset($_COOKIE["glatitude"]) && isset($_COOKIE["glongitude"])){
			$glatitude = round($_COOKIE["glatitude"],6);
			$glongitude = round($_COOKIE["glongitude"],6);
			
				
			include_once("includes/GeoCalc.class.php");
			
			// Calculate the boundary distance in degrees longitude / latitude
			$oGC = new GeoCalc();
			$dAddLat = $oGC->getLatPerKm() * ($afstand*0.70); //afronden met wegen rekening houdend
			$dAddLon = $oGC->getLonPerKmAtLat($glatitude) * $afstand;
			
			// Calculate the boundaries
			$dNorthBounds = round($glatitude + $dAddLat,6);
			$dSouthBounds = round($glatitude - $dAddLat,6);
			$dWestBounds = round($glongitude - $dAddLon,6);
			$dEastBounds = round($glongitude + $dAddLon,6);	
					
			//sql bouwen
			$crsql .= " AND glatti BETWEEN '$dSouthBounds' AND '$dNorthBounds'  ";
			$crsql .= " AND glongg BETWEEN '$dWestBounds' AND '$dEastBounds'  ";
			
			
			}
	}		
		//accessoires
		if(isset($_POST['accessoires']))
		{	
			
			foreach($_POST['accessoires'] as $value)
			{
			
			$value = StripDanger($value);
			$accessoires .= $value.' ';
			}
			$accessoires = htmlspecialchars($accessoires,ENT_QUOTES);
			$url .= "&accessoires=".$accessoires;				
		}	
		elseif(isset($_GET['accessoires']))
		{	
			
			$accessoiressql = htmlspecialchars($_REQUEST["accessoires"],ENT_QUOTES);
			
			$accessoiressql = StripDanger(urldecode($_REQUEST["accessoires"]));
			
			$accessoiressql = "+".ereg_replace(', ', ' +', $accessoiressql)." ";
			//$accessoiressql = ereg_replace(' ', '+', $accessoiressql)." ccc";
			$crsql .= " AND MATCH (accessoires,overopties) AGAINST(' $accessoiressql ' IN BOOLEAN MODE) ";
			
			$url .= "&accessoires=".htmlspecialchars(StripDanger($_REQUEST["accessoires"]),ENT_QUOTES);
		} //WHERE MATCH (title,description) AGAINST ('$sqlzoek' IN BOOLEAN MODE)
			
	// als gezocht via formulier, doorsturen via header redirect, 
	// omdat anders via de detail pagina niet terug gegaan kan worden
	if (isset($_POST["occasion"])) 
	 	header("Location: ../zoeken/?occasion$url$orderuld"); 		

	////////// EINDE QUERIES ///////////
	if(!isset($_REQUEST["bck"])){
	//totaal ads
	$totaal_aantal_auto = mysql_query("select count(autoid) from autos where valid = '1' $crsql ");
	$totaal_aantal_autos = mysql_fetch_assoc($totaal_aantal_auto);
	$totaal_aantal_autoz = $totaal_aantal_autos["count(autoid)"];	 // totaal aantal gevonden autos;
	
	if($totaal_aantal_autoz<1){
	
	echo "<br />";
	echo "<br />";
	echo "<br />";
	echo "&nbsp;&nbsp;Geen resultaten gevonden, klik <a href='../zoeken/?bck$url'><b>hier</b></a> om terug te gaan.";
	
	include("includes/footer.php"); 
	exit;	
	}
	elseif($totaal_aantal_autoz>2499){
	
	echo "<br />";
	echo "<br />";
	echo "<br />";
	echo "&nbsp;&nbsp;Teveel autos gevonden, klik <a href='../zoeken/?bck$url'><b>hier</b></a> om uw zoekopdracht te verfijnen.";
	
	include("includes/footer.php"); 
	exit;	
	}
	// querie per pagina :
	$sql_zk_autos = "select autoid,bedrijfid,merk,mdtype,model,bouwjaar,transmissie,brandstof, prijs,kmstand,kleuren,deur,
						bedrijven.bedrijf, bedrijven.vestigingsadresplaats
					from autos inner join bedrijven on (autos.bedrijfid = bedrijven.bedrijvenid)  
					where valid = '1' $crsql order by $ordert LIMIT $offset,$limit";
	$sql_zk_autos_result = mysql_query ($sql_zk_autos);
	$num_zk_autos_links =  mysql_num_rows($sql_zk_autos_result);

	////////// OUPUT ///////////
	if($totaal_aantal_autoz==1) $resm = "resultaat"; else $resm = "resultaten";
	
	echo "<h1 class=\"specia\">$totaal_aantal_autoz $resm gevonden</h1>";
	echo "<ul class='shiftleft'>
			<li><a href=\"../zoeken/?bck$url\">Zoekopdracht aanpassen?</a></li>
			<li><a href=\"".WEBSITE_URL."/rss.xml?$url\" title=\"RSS feed van deze zoekopdracht\"><img src=\"web_images/feed-icon-10x10.gif\" alt=\"RSS\" /> RSS</a></li>
			</ul>";
	
		
	//setcookie("terugkeren", $plaats, time()+3600); 
	header("Cache-control: private"); // ie 6 fix 
	header('P3P: CP="NOI ADM DEV PSAi COM NAV OUR OTRo STP IND DEM"'); 
	$cdomain = ".".STD_DOMEIN;
	setcookie("plaats", $plaats, time()+3600,"/", $cdomain, 0); 
	
	//huidige url 
	//$currenturl = substr($_SERVER['REQUEST_URI'],1);
	
	echo "<div id=\"results\">";
	
		
	echo "<div class=\"sortbox\">			
						<p class='sortmerk'>merk<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=mu\"><img src=\"web_images/up.gif\" alt=\"sorteer op merk model abc\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=md\"><img src=\"web_images/down.gif\" alt=\"sorteer op merk model zyx\" /></a> </p>
						<p class='sortmore'>km stand<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=ku\"><img src=\"web_images/up.gif\" alt=\"sorteer op kilometerstand laag-hoog \" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=kd\"><img src=\"web_images/down.gif\" alt=\"sorteer op kilometerstand hoog-laag\" /></a></p>
						<p class='sortmore'>prijs<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=pu\"><img src=\"web_images/up.gif\" alt=\"sorteer op prijs laag-hoog\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=pd\"><img src=\"web_images/down.gif\" alt=\"sorteer op prijs hoog-laag\" /></a></p>
						<p class='sortmore'>bouwjaar<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=bu\"><img src=\"web_images/up.gif\" alt=\"sorteer op bouwjaar oud-jong\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=bd\"><img src=\"web_images/down.gif\" alt=\"sorteer op bouwjaar jong-oud\" /></a></p>

			 </div> ";
// banner top resultaten
	  echo "<div class=\"banbox\" >    
			".get_banner("auto_lijst1")."
			</div>";
		
	echo "<!-- google_ad_section_start --> ";
	while ($row = mysql_fetch_assoc($sql_zk_autos_result)){
				$autoid = $row["autoid"];
				$autobedrijfid = $row["bedrijfid"];	
				$bedrijf = $row["bedrijf"];	
				if($bedrijf=='1')
					$bedrijf = "Autobedrijf";
					else $bedrijf = "Particulier";
				$vestigingsadresplaats = $row["vestigingsadresplaats"];	
				$automerk = ucwords($row["merk"]);
				
				$automodel = ucwords($row["model"])." ".strtolower($row["mdtype"]);
				$autobouwjaar = $row["bouwjaar"];	
				$bouwjrmnd = substr($row["bouwjaar"],4);		
				if($autobouwjaar==999999)$autobouwjaar = "nieuw";
				elseif($bouwjrmnd>12)$autobouwjaar = substr($row["bouwjaar"],0,4);
				else $autobouwjaar = $bouwjrmnd."-".substr($row["bouwjaar"],0,4);
				
				$autotransmissie = $row["transmissie"];
					switch($autotransmissie){ 
					
							case "A" : $autotransmissie = "&#8226; Automaat<br />"; 
							break; 
							case "H" : $autotransmissie = "&#8226; Handgeschakeld<br />"; 
							break;
							case "C" : $autotransmissie = "&#8226; CVT<br />"; 
							break; 
							default : $autotransmissie = ""; 			
					} 
				$autobrandstof = $row["brandstof"];
					switch($autobrandstof){ 
					
							case "3" : $autobrandstof = "&#8226; LPG-G3<br />"; 
							break; 
							case "B" : $autobrandstof = "&#8226; Benzine<br />"; 
							break;
							case "D" : $autobrandstof = "&#8226; Diesel<br />"; 
							break;
							case "G" : $autobrandstof = "&#8226; LPG<br />"; 
							break; 
							default : $autobrandstof = ""; 			
					} 				
				
				$autoprijs = formatprice($row["prijs"]);
				if($row["prijs"]==1) $autoprijs = "op aanvraag";
				$autokmstand = formatkmstand($row["kmstand"]);
				
				$autokleuren = ucwords($row["kleuren"]);
				$autodeur = $row["deur"];
								
				//if ($col == "#eeeeee")
				$col = "#FFFFFF";	
				//else
				//$col = "#eeeeee";	
				
				// fotos zoeke in aparte querie
				$zk_foto_small = mysql_query("select autofotosmall from autofoto where autofotoid = '$autoid' order by fotoid ASC Limit 1");
				$row_fotos_small= mysql_fetch_assoc($zk_foto_small);
				
				$autofotosmall = $row_fotos_small["autofotosmall"];
				$seourl = WEBSITE_URL."/".strtolower("kopen/$autoid/".seourls($automerk)."/".seourls($automodel)."/occasion.php");
				if(!$autofotosmall) 
					$autofotosmall = "geenfoto.gif";
			echo "<div class=\"autobox\" onclick=\"document.location='$seourl'\">
						<div class=\"autoimg\"><img src=\"auto_fotos/$autofotosmall\" alt=\"$automerk $automodel voor $autoprijs\"  /></div>
						<div class=\"automark\"><h3><a href=\"$seourl\">$automerk $automodel</a></h3>
						$autotransmissie
						$autobrandstof
						&#8226; $autokleuren<br />
						&#8226; $autodeur deurs						
						</div>
						<div class=\"autooverig\">$autokmstand</div>
						<div class=\"autooverig\">$autoprijs</div>
						<div class=\"autooverig\">$autobouwjaar</div>
						<div class=\"autooverig\"><b>$bedrijf</b><br />
						$vestigingsadresplaats</div>				
					</div>";
						
				
			  unset($autofotosmall);

								
				}
	// terug naar resultaten 
	$_SESSION["doorstrpag"] =  "../zoeken/?occasion&offset=$offset$orderuld$url";

	echo "<!-- google_ad_section_end -->";
	////////// END OUPUT /////////// BEGIN previous next dinges onderaan de pagina.
	if($totaal_aantal_autoz>$limit){


	echo "<div class=\"sortbox\">			
						<p class='sortmerk'>merk<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=mu\"><img src=\"web_images/up.gif\" alt=\"sorteer op merk model abc\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=md\"><img src=\"web_images/down.gif\" alt=\"sorteer op merk model zyx\" /></a> </p>
						<p class='sortmore'>km stand<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=ku\"><img src=\"web_images/up.gif\" alt=\"sorteer op kilometerstand laag-hoog \" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=kd\"><img src=\"web_images/down.gif\" alt=\"sorteer op kilometerstand hoog-laag\" /></a></p>
						<p class='sortmore'>prijs<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=pu\"><img src=\"web_images/up.gif\" alt=\"sorteer op prijs laag-hoog\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=pd\"><img src=\"web_images/down.gif\" alt=\"sorteer op prijs hoog-laag\" /></a></p>
						<p class='sortmore'>bouwjaar<br />
						<a href=\"../zoeken/?occasion$url&amp;sort=bu\"><img src=\"web_images/up.gif\" alt=\"sorteer op bouwjaar oud-jong\" /></a>
						<a href=\"../zoeken/?occasion$url&amp;sort=bd\"><img src=\"web_images/down.gif\" alt=\"sorteer op bouwjaar jong-oud\" /></a></p>

			 </div> <br style=\"clear:both\" /> ";	
			 
			echo "<div id=\"prevnext\"><p>";	
		
		$totaalpagina = ceil($totaal_aantal_autoz/$limit); // totaal aantal paginas
		
		if ($offset>0) { 
			$prevoffset=$offset-$limit;
			if(isset($_GET["seofavoca"])){
				if($prevoffset>0) $seooffset = "$prevoffset/";
			echo " <a href=\"../occasion/$seooffset$seo_merk_url.php\">&lt; vorige</a>  \n";
			}
			else{
					echo " <a href=\"../zoeken/?occasion&amp;$orderuld$url\" title=\"eerste pagina\"> eerste </a> |  \n";
					echo " <a href=\"../zoeken/?occasion&amp;offset=$prevoffset$orderuld$url\" title=\"vorige pagina\"> vorige </a> |  \n";
					
				}
			}
			else 
			echo "<font color='#CCCCCC'>&lt; </font>";	
		if(!isset($_GET["seofavoca"])){
				$huidigepagina = $offset/$limit+1;	
				
				for ($i = $huidigepagina-5; $i <= $huidigepagina-1; $i++) {
				if($i>0){
				
					$texopi = ($i*$limit)-$limit;
					echo " <a href=\"../zoeken/?occasion&amp;offset=$texopi$orderuld$url\" title=\"pagina $i\"> $i </a> |  \n";
					
					}
				}
						echo " $huidigepagina ";	
		
				for ($i = $huidigepagina+1; $i <= $huidigepagina+5; $i++) {
				if($i<=$totaalpagina){
		
					$texopi = ($i*$limit)-$limit;
					echo " | <a href=\"../zoeken/?occasion&amp;offset=$texopi$orderuld$url\" title=\"pagina $i\"> $i </a>  \n";
					
					}
				}
		}
		else{
				$huidigepagina = $offset/$limit+1;	
				
				for ($i = $huidigepagina-5; $i <= $huidigepagina-1; $i++) {
				if($i>0){
				
					$texopi = ($i*$limit)-$limit;
					echo " <a href=\"../occasion/$texopi/$seo_merk_url.php\" title=\"pagina $i\"> $i </a> |  \n";
					
					}
				}
						echo " $huidigepagina ";	
		
				for ($i = $huidigepagina+1; $i <= $huidigepagina+5; $i++) {
				if($i<=$totaalpagina){
		
					$texopi = ($i*$limit)-$limit;
					echo " | <a href=\"../occasion/$texopi/$seo_merk_url.php\" title=\"pagina $i\"> $i </a>  \n";
					
					}
				}
		}
		$newoffset=$offset+$limit;	
		if ($totaal_aantal_autoz>$newoffset) 
			if(isset($_GET["seofavoca"]))
			echo " <a href=\"../occasion/$newoffset/$seo_merk_url.php\"> volgende &gt;</a> \n";
			else{
					$laatstepagina = $totaalpagina*$limit-$limit;
					echo " | <a href=\"../zoeken/?occasion&amp;offset=$newoffset$orderuld$url\" title=\"volgende pagina\">  volgende </a> \n";
					echo " | <a href=\"../zoeken/?occasion&amp;offset=$laatstepagina$orderuld$url\" title=\"laatste pagina ($totaalpagina)\"> ... $totaalpagina laatste </a> \n";
					
				}
			else 
			echo "<font color='#CCCCCC'> &gt;</font>";
		
		echo "</p></div>";
	} 
// banner top resultaten
	  echo "<div class=\"banbox\" >    
			".get_banner("auto_lijst2")."
			</div>";
	
	echo "</div>";
	
	include("includes/footer.php"); 
	exit;
	}
}
//einde form verwerken / show form :
//postcode uit cookie halen
if(isset($_COOKIE["postcode"]))
	$postcode = substr(round($_COOKIE["postcode"]),0,4);

 ?>

<h1>Uitgebreid  oldtimer zoeken</h1>
<ul class="shiftleft">
	<li><a onclick='clearformp()'><b>Alles wissen?</b></a></li>
</ul>


<form action="WEBSITE_URL/zoeken/" id="zoeken" name="zoeken" method="post" class="zoekgr">
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="28%"><h3>Merk:</h3>
        <select name='crmerk' class="selectleft" style="width:128px" onchange="getModelList(this)">
          <option value="">Merk</option>
          <? // provincies ophalen
    $up_cehck_result = mysql_query("select DISTINCT merk  from merkenlist order by merk ASC");
    while ($row_user = mysql_fetch_assoc($up_cehck_result)){
     $zk_merknaam = $row_user["merk"];
    echo "<option value=\"$zk_merknaam\" ";
	if($crmerk == $zk_merknaam) echo "selected=\"selected\" ";
	echo ">".ucwords($zk_merknaam)."</option>\n";
    
    
    }
    ?>
        </select></td>
      <td width="23%"><h3>
        <script type="text/javascript">
	<!--
        document.zoeken.crmodel.value="";
    //-->
          </script>
      Model/type:</h3>
      <input type="text" name="crtype" id="crtype" class="selectleft" value="" /></td>
      <td colspan="2"><h3><span class="trgrey">Regionaal zoeken</span></h3>
        <input name="postcode" type="text" id="postcode"  value="" class="zkkl" onfocus="if(this.value=='Postcode') this.value='';" maxlength="4" onkeypress="return numbersonly(this, event)" />
afstand:
<select name="afstand" id="afstand"  class="selectleft" style="width:80px" >
  <option  value="" <? if($afstand == "") echo "selected=\"selected\""; ?>><span class="trgrey">alles </span></option>
  <option  value="15" <? if($afstand == "15") echo "selected=\"selected\""; ?>><span class="trgrey">15 km </span></option>
  <option  value="25" <? if($afstand == "25") echo "selected=\"selected\""; ?>><span class="trgrey">25 km</span></option>
  <option  value="50" <? if($afstand == "50") echo "selected=\"selected\""; ?>><span class="trgrey">50 km</span></option>
  <option  value="75" <? if($afstand == "75") echo "selected=\"selected\""; ?>><span class="trgrey">75 km</span></option>
  <option  value="100" <? if($afstand == "100") echo "selected=\"selected\""; ?>><span class="trgrey">100 km</span></option>
  <option  value="150" <? if($afstand == "150") echo "selected=\"selected\""; ?>><span class="trgrey">150 km</span></option>
  <option  value="200" <? if($afstand == "200") echo "selected=\"selected\""; ?>><span class="trgrey">200 km</span></option>
</select></td>
      <td width="15%" class="trgrey"><h3>&nbsp;</h3></td>
    </tr>
    <tr>
      <td valign="top"><h3>Prijs:</h3>
        <input name="crprijs" type="text" id="crprijs"  value="" class="zkkl" maxlength="7" onkeypress="return numbersonly(this, event)" />
        tot
        <input name="crprijsto" type="text" id="crprijsto"  value="" class="zkkl" maxlength="7" onkeypress="return numbersonly(this, event)" />
        euro</td>
      <td valign="top"><h3>Bouwjaar:</h3>
        <input name="crbouwjaar" type="text" id="crbouwjaar"  value="" class="zkkl" maxlength="4" onkeypress="return numbersonly(this, event)" />
        tot
<input name="crbouwjaarto" type="text" id="crbouwjaarto"  value="" class="zkkl" maxlength="4" onkeypress="return numbersonly(this, event)" /></td>
      <td colspan="2" valign="top"><h3>Kilometerstand (km):</h3>
        <input name="crkmstand" type="text" id="crkmstand"  value="" class="zkkl" maxlength="6" onkeypress="return numbersonly(this, event)" />
        tot
<input name="crkmstandto" type="text" id="crkmstandto"  value="" class="zkkl" maxlength="6" onkeypress="return numbersonly(this, event)" /></td>
      <td rowspan="2" valign="top" class="trgrey"><h3>Soort aanbieder</h3>
        <input type="radio" name="aanbieder" id="aanbieder1" value="1" <? if($aanbieder == "1") echo "checked=\"checked\""; ?>/>
        Autobedrijf<br />
        <input type="radio" name="aanbieder" id="aanbieder0" value="2" <? if($aanbieder == "2") echo "checked=\"checked\""; ?>/>
        Particulier<br />
        <input type="radio" name="aanbieder" id="aanbieder2" value="3" <? if($aanbieder == "3") echo "checked=\"checked\""; ?>/>
        Beide</td>
    </tr>
    <tr>
      <td><h3>Brandstof:</h3>
        <select name="crbrandstof" class="selectleft"  style="width:128px" >
          <option value="" <? if($crbrandstof == "") echo "selected=\"selected\""; ?>>alle brandstoffen</option>
          <option value="3" <? if($crbrandstof == "3") echo "selected=\"selected\""; ?>>LPG-G3</option>
          <option value="B" <? if($crbrandstof == "B") echo "selected=\"selected\""; ?>>Benzine</option>
          <option value="D" <? if($crbrandstof == "D") echo "selected=\"selected\""; ?>>Diesel</option>
          <option value="G" <? if($crbrandstof == "G") echo "selected=\"selected\""; ?>>LPG</option>
      </select></td>
      <td><h3>Transmissie:</h3>
        <select name="crbak" class="selectleft" style="width:128px" >
          <option  value="" <? if($crbak == "") echo "selected=\"selected\""; ?>>alle transmissies </option>
          <option  value="A" <? if($crbak == "A") echo "selected=\"selected\""; ?>>Automaat </option>
          <option  value="H" <? if($crbak == "H") echo "selected=\"selected\""; ?>>Handgeschakeld </option>
          <option  value="C" <? if($crbak == "C") echo "selected=\"selected\""; ?>>CVT</option>
        </select></td>
      <td colspan="2"><h3>Vermogen (pk):</h3>
        <input name="crvermogen" type="text" id="crvermogen"  value="" class="zkkl" maxlength="6" onkeypress="return numbersonly(this, event)" />
        &nbsp;tot
<input name="crvermogento" type="text" id="crvermogento"  value="" class="zkkl" maxlength="6" onkeypress="return numbersonly(this, event)" /></td>
    </tr>
    <tr>
      <td valign="top"><h3>Carrosserie:</h3>
        <select name="crcategorie" class="selectleft" style="width:128px" >
          <option  value="" <? if($crcategorie == "") echo "selected=\"selected\""; ?>>alle vormen </option>
          <option  value="9" <? if($crcategorie == "9") echo "selected=\"selected\""; ?>>Camper </option>
          <option  value="P" <? if($crcategorie == "P") echo "selected=\"selected\""; ?>>Personenbus</option>
          <option  value="B" <? if($crcategorie == "B") echo "selected=\"selected\""; ?>>Hatchback </option>
          <option  value="1" <? if($crcategorie == "1") echo "selected=\"selected\""; ?>>Sedan </option>
          <option  value="5" <? if($crcategorie == "5") echo "selected=\"selected\""; ?>>Coupe </option>
          <option  value="6" <? if($crcategorie == "6") echo "selected=\"selected\""; ?>>Cabriolet </option>
          <option  value="7" <? if($crcategorie == "7") echo "selected=\"selected\""; ?>>Stationwagen </option>
          <option  value="8" <? if($crcategorie == "8") echo "selected=\"selected\""; ?>>Terreinwagen </option>
         
        </select></td>
      <td valign="top"><h3>Kleur:</h3>
        <select name="crkleuren" class="selectleft" style="width:128px">
          <option  value="" <? if($crkleuren == "") echo "selected=\"selected\""; ?>>alle kleuren</option>
          <option  value="beige" <? if($crkleuren == "beige") echo "selected=\"selected\""; ?>>beige</option>
          <option  value="blauw" <? if($crkleuren == "blauw") echo "selected=\"selected\""; ?>>blauw</option>
          <option  value="bruin" <? if($crkleuren == "bruin") echo "selected=\"selected\""; ?>>bruin</option>
          <option  value="creme" <? if($crkleuren == "creme") echo "selected=\"selected\""; ?>>creme</option>
          <option  value="divers" <? if($crkleuren == "divers") echo "selected=\"selected\""; ?>>divers</option>
          <option  value="geel" <? if($crkleuren == "geel") echo "selected=\"selected\""; ?>>geel</option>
          <option  value="goud" <? if($crkleuren == "goud") echo "selected=\"selected\""; ?>>goud</option>
          <option  value="grijs" <? if($crkleuren == "grijs") echo "selected=\"selected\""; ?>>grijs</option>
          <option  value="groen" <? if($crkleuren == "groen") echo "selected=\"selected\""; ?>>groen</option>
          <option  value="oranje" <? if($crkleuren == "oranje") echo "selected=\"selected\""; ?>>oranje</option>
          <option  value="overig" <? if($crkleuren == "overig") echo "selected=\"selected\""; ?>>overig</option>
          <option  value="paars" <? if($crkleuren == "paars") echo "selected=\"selected\""; ?>>paars</option>
          <option  value="parelmoer" <? if($crkleuren == "parelmoer") echo "selected=\"selected\""; ?>>parelmoer</option>
          <option  value="rood" <? if($crkleuren == "rood") echo "selected=\"selected\""; ?>>rood</option>
          <option  value="roze" <? if($crkleuren == "roze") echo "selected=\"selected\""; ?>>roze</option>
          <option  value="wit" <? if($crkleuren == "wit") echo "selected=\"selected\""; ?>>wit</option>
          <option  value="zilver" <? if($crkleuren == "zilver") echo "selected=\"selected\""; ?>>zilver</option>
          <option  value="zwart" <? if($crkleuren == "zwart") echo "selected=\"selected\""; ?>>zwart</option>
        </select></td>
      <td colspan="2" valign="top"><h3>Aantal deuren:</h3>
        <select name="crdeur"  class="selectleft" style="width:128px" >
          <option  value="" <? if($crdeur == "") echo "selected=\"selected\""; ?>>alles </option>
          <option  value="2" <? if($crdeur == "2") echo "selected=\"selected\""; ?>>2-deurs </option>
          <option  value="3" <? if($crdeur == "3") echo "selected=\"selected\""; ?>>3-deurs </option>
          <option  value="4" <? if($crdeur == "4") echo "selected=\"selected\""; ?>>4-deurs </option>
          <option  value="5" <? if($crdeur == "5") echo "selected=\"selected\""; ?>>5-deurs </option>
        </select></td>
      <td class="trgrey"><h3>Sorteren op:</h3>
        <select name="sort" class="selectleft" style="width:148px" >
          <option value=""></option>
          <option value="mu">Merk model abc</option>
          <option value="md">Merk model zyx</option>
          <option value="pu">Prijs laag - hoog</option>
          <option value="pd">Prijs hoog - laag</option>
          <option value="ku">Km. stand laag - hoog</option>
          <option value="kd">Km. stand hoog - laag</option>
          <option value="bu">Bouwjaar laag - hoog</option>
          <option value="bd">Bouwjaar hoog - laag</option>
        </select>      </td>
    </tr>
    <tr>
      <td colspan="4" class="trblue"><h3>Opties en accesoires:</h3></td>
      <td class="trgrey">&nbsp;</td>
    </tr>
    <tr>
      <td valign="top" class="trblue"><?
	 
	 	//totaal aantal opties tellen en delen door 2  linkid  linkurl  linknaam  
		$r = q($sql = "select count(optieid) from opties where zoeken = '1' ");
		$links = mysql_fetch_assoc($r);
		$numlinks = $links["count(optieid)"];
		$links = ceil($numlinks/3); 
		$midden = $links*2;
		$rechts = $links;

		$cache = array(); //accessoires dinges array
		
		//zoekopdracht aanpassen
		if(isset($_REQUEST["bck"])){
			
			$cachein = urldecode($_GET["accessoires"]);
			$cachein = str_replace(",",", XX ", $cachein);
			$test = split("XX", $cachein);
						foreach($test as $key => $value)
			{
				$value = StripDanger($value);
				array_push($cache, $value);		
			}
			
	
		}
		//if gepost:
		elseif(isset($_POST['accessoires']))
		{
			foreach($_POST['accessoires'] as $key => $value)
			{
				$value = StripDanger($value);
				array_push($cache, $value);		
			}
		}

		//print_r($cache);
		// opties uit database halen:
		
		$optieresult = mysql_query("select opienm from opties where zoeken ='1' order by opienm ASC Limit 0,$links");
		while ($optierow = mysql_fetch_assoc($optieresult))
		{
		$zk_optienaam = $optierow["opienm"];
		$zk_optienaam_arr = $zk_optienaam.",";
		echo "<input ".(in_array($zk_optienaam_arr, $cache, true) ? 'checked=\"checked\"' : '')." type=\"checkbox\" name=\"accessoires[]\" value=\"$zk_optienaam,\"/> ".$zk_optienaam."<br />";
		
		}
		?></td>
      <td valign="top" class="trblue"><?
		$optieresult = mysql_query("select opienm from opties where zoeken ='1' order by opienm ASC Limit $links,$links");
		while ($optierow = mysql_fetch_assoc($optieresult))
		{
		$zk_optienaam = $optierow["opienm"];
		$zk_optienaam_arr = $zk_optienaam.",";
		echo "<input ".(in_array($zk_optienaam_arr, $cache) ? 'checked=\"checked\"' : '')." type=\"checkbox\" name=\"accessoires[]\" value=\"$zk_optienaam,\"/> ".$zk_optienaam."<br />";
		
		}
		?></td>
      <td width="5%" valign="top" class="trblue">&nbsp;</td>
      <td width="29%" valign="top" class="trblue"><?
		$optieresult = mysql_query("select opienm from opties where zoeken ='1' order by opienm ASC Limit $midden,$links");
		while ($optierow = mysql_fetch_assoc($optieresult))
		{
		$zk_optienaam = $optierow["opienm"];
		$zk_optienaam_arr = $zk_optienaam.",";
		echo "<input ".(in_array($zk_optienaam_arr, $cache) ? 'checked=\"checked\"' : '')." type=\"checkbox\" name=\"accessoires[]\" value=\"$zk_optienaam,\"/> ".$zk_optienaam."<br />";
		
		}
		?></td>
      <td align="left" class="trgrey"><input name="occasion" type="hidden" value="1" />
       <p><input type="submit" name="occasion2" id="occasion2" value="Zoeken" class="knop_zoeken" onclick="javascript:document.getElementById('occasion2').disabled=true;javascript:document.getElementById('occasion2').value='Moment';javascript:document.zoeken.submit();" /></p>
        </td>
    </tr>
  </table>
</form>
<div class="banbox" >    
	<? echo get_banner("zoeken"); ?>
</div>

<? include("includes/footer.php"); ?>