<?php
require_once("conn.php");
require_once("includes.php");

if(!isset($_GET['page']))
{
    $page = 1;
}
else
{
    $page = $_GET['page'];
}

$max_results = 10;
$from = (($page * $max_results) - $max_results);
$query = array();

if(!empty($_GET[c]))
{
	$query[] = "cars_listings.CategoryID = '$_GET[c]' ";
}


if(!empty($_GET[AgentID]))
{
	$query[] = "cars_listings.AgentID = '$_GET[AgentID]' ";
}


if(!empty($_GET[VehicleModel]))
{
	$query[] = "cars_listings.VehicleModel = '$_GET[VehicleModel]' ";
}

if(!empty($_GET[VehicleMake]))
{
	$query[] = "cars_listings.VehicleMake =  '$_GET[VehicleMake]' " ;
}

if(!empty($_GET[search_gorivo]))
{
	$query[] = "cars_listings.gorivo = '$_GET[search_gorivo]' ";
}


if(!empty($_GET[km1]))
{
	$query[] = "cars_listings.mileage >= '$_GET[km1]' ";
}


if(!empty($_GET[km2]))
{
	$query[] = "cars_listings.mileage <= '$_GET[km2]' ";
}


if(!empty($_GET[snag1]))
{
	$query[] = "cars_listings.snaga >= '$_GET[snag1]' ";
}


if(!empty($_GET[snag2]))
{
	$query[] = "cars_listings.snaga <= '$_GET[snag2]' ";
}

if(!empty($_GET[kub1]))
{
	$query[] = "cars_listings.kubikaza >= '$_GET[kub1]' ";
}

if(!empty($_GET[kub2]))
{
	$query[] = "cars_listings.kubikaza <= '$_GET[kub2]' ";
}

if(!empty($_GET[search_stanjevozila]))
{
	$query[] = "cars_listings.stanjevozila = '$_GET[search_stanjevozila]' ";
}

if(!empty($_GET[search_mjenjac]))
{
	$query[] = "cars_listings.mjenjac = '$_GET[search_mjenjac]' ";
}

if(!empty($_GET[search_karoserija]))
{
	$query[] = "cars_listings.karoserija = '$_GET[search_karoserija]' ";
}

if(!empty($_GET[search_pogon]))
{
	$query[] = "cars_listings.pogon = '$_GET[search_pogon]' ";
}

if(!empty($_GET[search_kozna_sjedala]))
{
	$query[] = "cars_listings.kozna_sjedala = '$_GET[search_kozna_sjedala]' ";
}

if(!empty($_GET[search_klima_manualna]))
{
	$query[] = "cars_listings.klima_manualna = '$_GET[search_klima_manualna]' ";
}

if(!empty($_GET[search_klima_auto]))
{
	$query[] = "cars_listings.klima_auto = '$_GET[search_klima_auto]' ";
}

if(!empty($_GET[search_abss]))
{
	$query[] = "cars_listings.abss = '$_GET[search_abss]' ";
}

if(!empty($_GET[search_asr]))
{
	$query[] = "cars_listings.asr = '$_GET[search_asr]' ";
}

if(!empty($_GET[search_esp]))
{
	$query[] = "cars_listings.esp = '$_GET[search_esp]' ";
}

if(!empty($_GET[search_alu_felge]))
{
	$query[] = "cars_listings.alu_felge = '$_GET[search_alu_felge]' ";
}

if(!empty($_GET[search_zracni_jastuk]))
{
	$query[] = "cars_listings.zracni_jastuk = '$_GET[search_zracni_jastuk]' ";
}

if(!empty($_GET[search_alarm]))
{
	$query[] = "cars_listings.alarm = '$_GET[search_alarm]' ";
}

if(!empty($_GET[search_siber]))
{
	$query[] = "cars_listings.siber = '$_GET[search_siber]' ";
}

if(!empty($_GET[search_tempomat]))
{
	$query[] = "cars_listings.tempomat = '$_GET[search_tempomat]' ";
}

if(!empty($_GET[search_el_podizaci]))
{
	$query[] = "cars_listings.el_podizaci = '$_GET[search_el_podizaci]' ";
}

if(!empty($_GET[search_cent_zakljuc]))
{
	$query[] = "cars_listings.cent_zakljuc = '$_GET[search_cent_zakljuc]' ";
}

if(!empty($_GET[search_auto_radio]))
{
	$query[] = "cars_listings.auto_radio = '$_GET[search_auto_radio]' ";
}

if(!empty($_GET[search_servo]))
{
	$query[] = "cars_listings.servo = '$_GET[search_servo]' ";
}

if(!empty($_GET[VehicleColor]))
{
	$query[] = "cars_listings.VehicleColor = '$_GET[VehicleColor]' ";
}

if(!empty($_GET[search_country]))
{
	$query[] = "cars_agents.country = '$_GET[search_country]' ";
}

if(!empty($_GET[search_city]))
{
	$query[] = "cars_agents.city = '$_GET[search_city]' ";
}

if(!empty($_GET[min]))
{
	$query[] = "cars_listings.price >= '$_GET[min]' ";
}

if(!empty($_GET[max]))
{
	$query[] = "cars_listings.price <= '$_GET[max]' ";
}

if(!empty($_GET[eur1]))
{
	$query[] = "cars_listings.Euro >= '$_GET[eur1]' ";
}

if(!empty($_GET[eur2]))
{
	$query[] = "cars_listings.Euro <= '$_GET[eur2]' ";
}

if(!empty($_GET[year1]))
{
	$query[] = "cars_listings.VehicleYear >= '$_GET[year1]' ";
}

if(!empty($_GET[year2]))
{
	$query[] = "cars_listings.VehicleYear <= '$_GET[year2]' ";
}

if(!empty($_GET[before]))
{
	$MyDate = strtotime("-$_GET[before]");
	$query[] = "cars_listings.DateAdded >= '$MyDate' ";
}

if(!empty($query))
{
	$MyQuery = implode(" and ", $query);
	$MyQuery = " and ".$MyQuery;
}


////////////////////////////////////////////////////////////
//////////		order by
////////////////////////////////////////////////////////////

$order = array();

if(!empty($_GET[orderby]))
{
	$MyOrder = explode("|", $_GET[orderby]);

	while(list(,$ov) = each($MyOrder))
	{
		if($ov == "DateAdded")
		{
			$order[] = " cars_listings.DateAdded desc ";
		}

		if($ov == "Price")
		{
			$order[] = " cars_listings.Price asc ";
		}

		if($ov == "address")
		{
			$order[] = " cars_agents.address asc ";
		}

	}
}
else
{
	if(!empty($_GET[p]))
	{
		$order[] = " cars_listings.Price asc ";
	}

	if(!empty($_GET[r]))
	{
		$order[] = " cars_listings.mileage asc ";
	}

	if(!empty($_GET[vehicle]))
	{
		$order[] = " cars_vehicle.VehicleName ";
	}

}


if(count($order) > '0')
{
	$MyOrder = implode(", ", $order);

}

if(empty($MyOrder))
{
	$MyOrder = " order by cars_agents.PriorityLevel desc, cars_listings.DateAdded desc";
}
else
{
	$MyOrder = " order by cars_agents.PriorityLevel desc, $MyOrder, cars_listings.DateAdded desc";
}


if(!empty($_GET[Start]))
{
	$Start = $_GET[Start];
}
else
{
	$Start = '0';
}

$ByPage = '10';
if($aset[Sitefee]=="1")
		{
$q1 = "select * from cars_listings, cars_agents, cars_vehicle where cars_listings.AgentID = cars_agents.AgentID  and cars_agents.AccountStatus = 'active' and cars_listings.VehicleMake = cars_vehicle.VehicleID $MyQuery $MyOrder limit $from, $max_results ";
$total_results = mysql_num_rows(mysql_query("select * from cars_listings, cars_agents, cars_vehicle where cars_listings.AgentID = cars_agents.AgentID  and cars_agents.AccountStatus = 'active' and cars_listings.VehicleMake = cars_vehicle.VehicleID $MyQuery $MyOrder"));
//echo $total_results;
$total_pages = ceil($total_results / $max_results);

		}
		else
		{
$q1 = "select * from cars_listings, cars_agents, cars_priority, cars_vehicle where cars_listings.AgentID = cars_agents.AgentID and cars_agents.PriorityLevel = cars_priority.PriorityLevel and cars_agents.AccountStatus = 'active' and cars_listings.VehicleMake = cars_vehicle.VehicleID $MyQuery $MyOrder limit $from, $max_results ";
$total_results = mysql_num_rows(mysql_query("select * from cars_listings, cars_agents, cars_priority, cars_vehicle where cars_listings.AgentID = cars_agents.AgentID and cars_agents.PriorityLevel = cars_priority.PriorityLevel and cars_agents.AccountStatus = 'active' and cars_listings.VehicleMake = cars_vehicle.VehicleID $MyQuery"));

$total_pages = ceil($total_results / $max_results);
		}
$qnav = "select * from cars_listings, cars_agents where cars_listings.AgentID = cars_agents.AgentID $MyQuery";

$r1 = mysql_query($q1) or die(mysql_error());
$lrows = mysql_num_rows($r1);

if($lrows > '0')
{
	$ListingTable .= "<table align=center width=599px height=23 bgcolor=#EAEAEA class=border_za_detalj_4_1>\n";
	$ListingTable .= "<tr>\n<td width=100<strong>Rezultati pretrage</strong></td>\n\t";

	$ListingTable .= "<td width=200 align=center><a href=\"trazi?c=$_GET[c]&vehicle=1 \">vozilo</a></td>\n\t";

	$ListingTable .= "<td width=125 align=center><a href=\"trazi?c=$_GET[c]&r=1 \">kilometraža</a></td>\n\t";

	$ListingTable .= "<td align=center width=100><a href=\"trazi?c=$_GET[c]

&min=$_GET[min]&max=$_GET[max]&p=1 \">cijena</a></td>\n";

	$ListingTable .= "</tr>\n</table>\n\n";

	$ListingTable .= "<table align=center width=599px height=23 bgcolor=#FFFFFF border=0 cellspacing=0 cellpadding=0 class=border_za_detalj_5>\n";

	while($a1 = mysql_fetch_array($r1))
	{
		$ListingTable .= "<tr onMouseOver=\"this.style.background='#F7F7F7'; this.style.cursor='pointer'\" onMouseOut=\"this.style.background='#FFFFFF'\" onClick=\"window.open('oglas?id=$a1[ListingID]', '_top')\">\n\t";
		$ListingTable .= "<td height=60>";

		$ListingTable .= "<table align=center width=\"100%\" border=0 cellspacing=0 cellpadding=0>\n";

		$ListingTable .= "<caption align=center>";
		if($aset[Sitefee]=="0")
		{
		if($a1[PriorityLevel] > '1')
		{
			$ListingTable .= "<span class=RedLink>$a1[PriorityName] listing</span></caption>\n";
		}
		}
		$ListingTable .= "<tr>\n\t<td width=75>";

		if(!empty($a1[image]))
		{
			$images = explode("|", $a1[image]);
			$MyImage = $images[0];

			$ListingTable .= "<div style=padding:8px><img src=\"cars_images/$MyImage\" width=75 height=60></div>";
		}
		else
		{
			$ListingTable .= "<div style=padding:8px><img src=\"no_image.gif\"></div>";
		}

		$ListingTable .= "</td><strong>\n\t";

		$MyMiles = number_format($a1[mileage], 0, "", ".");

		$ListingTable .= "</strong><td width=225 valign=top align=center><b><div style=padding:8px>$a1[VehicleName] $a1[VehicleModel]</b><br>Županija: $a1[country]</div></td>\n\t";
		$ListingTable .= "<td width=100 valign=top align=left><div style=padding:8px>$MyMiles km<br>Godina: $a1[VehicleYear]</div></td>\n\t";

		$MyPrice = number_format($a1[Price], 2, ",", ".");

		$ListingTable .= "<td align=center width=100 valign=top><div style=padding:8px><b>$MyPrice $aset[Currencya]</b><br>Oglas dodan: </div></td>\n";

		$ListingTable .= "</tr>\n";

		$ShortDesc = substr($a1[DetailedDesc], 0, 200);

		$ListingTable .= "<tr>\n\t<td colspan=4><div style=padding:8px>$ShortDesc</div></td>\n</tr>\n";

		$ListingTable .= "</table>\n\n</td>\n</tr><tr>\n\t<td height=23 class=border_za_detalj_4><div align=right><img src=brrrmmmm.com/brrmmm.png /></div></td>\n</tr>\n\n";

	}

	$ListingTable .= "</table><br />
	<div align=center>
	<a href=javascript:history.go(-1);> <strong>natrag</strong></a> | <a href=#><strong>vrh stranice</strong></a>
	</div>";

		$rnav = mysql_query($qnav) or die(mysql_error());
		$rows = mysql_num_rows($rnav);

			if($rows > $ByPage)
			{
				$ListingTable .=  "<br><table align=center width=599px>";
				$ListingTable .= "<td align=center> | ";

				$pages = ceil($rows/$ByPage);

				for($i = 0; $i <= ($pages); $i++)
				{
					$PageStart = $ByPage*$i;

					$i2 = $i + 1;

					if($PageStart == $Start)
					{
						$links[] = "$i2\n\t ";
					}
					elseif($PageStart < $rows)
					{
						$links[] = "<a href=\"trazi?Start=$PageStart&c=$_GET[c]&page=$i2\">$i2</a>\n\t ";
					}
				}

				$links2 = implode(" | ", $links);

				$ListingTable .= $links2;

				$ListingTable .= "|</td>";

				$ListingTable .= "</table><br>\n";

			}
}
else
{
	$ListingTable = "<br><br><center>Nema rezultata! <a href=javascript:history.go(-1);> << natrag</a></center>";
}

require_once("templates/HeaderTemplate.php");
require_once("templates/SearchTemplate.php");
require_once("templates/FooterTemplate.php");

?>