<?php
	define("iStartFolder", 2); //DESDE que directorio empiezan nuestras variables
	define("idDevelopment", 18); //De que desarrollo se listaran las propiedades
	define("iRowsPerPage", 10); //El numero de propiedades que se mostrara por busqueda.
	require('includes/BD.php');
	require ('funciones/gallery.php');
	require ('funciones/varias.php');
	openDBConnection($BDServer,$BDUser,$BDPass,$BD);
	$iErrors=0;
	 //break up the URL using '/' as delimiter
	$url_array=explode("/",$REQUEST_URI);
	$bFilterPrice=false;
	$iFilterPrice=900000;
	$bFilterType=false;
	$sFilterType="";
	$bFilterBedrooms=false;
	$iFilterBedrooms=20;
	$sURICurrentType="allproperties";
	$sURICurrentBedroomNumber="anybedrooms";
	$sURICurrentPrice="allprices";
	$sURICurrentOrder="lowtohigh";
	$sURICurrentDevelopment="alldevelopments";
	$sOrder=" ASC ";
	$iOffset=0; //Desde que propiedad empezaran a aparecer.
	$sSQLDevelopmentFilter=""; //Si se filtra por Desarrollo esta variable se agregar a la consulta para que solo se 
								//muestren las propiedades de ese desarrollo.
	$bMoreThan=false; //Para saber si debera de ser mayor al precio.
	$bOnlyResales=false; // Esta variable es para determinar si solo se deberan de mostrar las reventas
	$bBedroomsWithEstar=false;	 //Agregado par apoder filtrar por bedrooms con estar
	$bFilterByEstar=false;  //Agregado par apoder filtrar por bedrooms con estar
	
	
	//Si se esta proporcionando algun parametro por la URL							
	if (count($url_array) >= (iStartFolder+1)){
		$sTemp="";
		$sTemp=$url_array[iStartFolder];
		
		if( ($sTemp!=$sURICurrentDevelopment) && ($sTemp!="") ){ //Si lo que se puso en la direccion es distinto del valor default
				$sURICurrentDevelopment=$sTemp;
				$sDevelopmentName=strtr($sTemp,"_"," "); //Convertimos el '_' en un espacio				
				$sSQLDevelopmentFilter=" AND (Developments.developmentName LIKE '%$sDevelopmentName%' ) ";
		}
	}
	
	//Si se esta proporcionando algun parametro por la URL
	if (count($url_array) >= (iStartFolder+1)){
		$sTemp="";
		$sTemp=$url_array[iStartFolder+1];
		switch($sTemp){
			case "townhouses":
					$sURICurrentType="townhouses";
					$bFilterType=true;
					$sFilterType="townhouses";
					break;
			case "villas":
					$sURICurrentType="villas";
					$bFilterType=true;
					$sFilterType="villas";
					break;
			case "condominiums":
					$sURICurrentType="condominiums";
					$bFilterType=true;
					$sFilterType="condominiums";
					break;
			case "resales":
					$sURICurrentType="resales";
					$bOnlyResales=true;
					$sFilterType="resales";
					break;
			default:
					$sURICurrentType="allproperties";			
		}		
	}

	//Si se esta proporcionando algo en el numero de habitaciones.
	if (count($url_array) >= (iStartFolder+2)  ){
		$sTemp="";
		$sTemp=$url_array[(iStartFolder+2)];
		switch($sTemp){
			case "2bedrooms":
					$sURICurrentBedroomNumber="2bedrooms";
					$bFilterBedrooms=true;
					$iFilterBedrooms=2;
					$bFilterByEstar=true;
					break;
					
			case "2bedrooms_with_den":
					$sURICurrentBedroomNumber="2bedrooms_with_den";
					$bFilterBedrooms=true;
					$iFilterBedrooms=2;
					$bBedroomsWithEstar=true;
					$bFilterByEstar=true;
					break;
					
					
			case "3bedrooms":
					$sURICurrentBedroomNumber="3bedrooms";
					$bFilterBedrooms=true;
					$iFilterBedrooms=3;
					break;
			case "4bedrooms":
					$sURICurrentBedroomNumber="4bedrooms";
					$bFilterBedrooms=true;
					$iFilterBedrooms=4;
					break;	
			default:
					$sURICurrentBedroomNumber="anybedrooms";
				//Any number of bedrooms	
		}
	}
	
	//Si se esta proporcionando algo en el precio.
	if (count($url_array) >= (iStartFolder+3)  ){
		$sTemp="";
		$sTemp=$url_array[(iStartFolder+3)];
		switch($sTemp){
			case "upto400k":
					$sURICurrentPrice="upto400k";
					$bFilterPrice=true;
					$iFilterPrice=400000;
					break;
			case "upto600k":
					$sURICurrentPrice="upto600k";
					$bFilterPrice=true;
					$iFilterPrice=600000;
					break;
			case "upto900k":
					$sURICurrentPrice="upto900k";
					$bFilterPrice=true;
					$iFilterPrice=900000;
					break;
			case "over900k":
					$sURICurrentPrice="over900k";
					$bFilterPrice=true;
					$iFilterPrice=900000;
					$bMoreThan=true;
					break;
			default:
				$sURICurrentPrice="allprices";
				//Any price	
		}
	}
	
	//Nos aseguramos que se proporcione el orden (lowtohigh o hightolow)
	if (count($url_array) >= (iStartFolder+4)  ){
		$sTemp="";
		$sTemp=$url_array[(iStartFolder+4)];
		switch($sTemp){
			case "hightolow":
					$sURICurrentOrder="hightolow";
					$sOrder=" DESC ";
					break;			
			default:
				$sURICurrentOrder="lowtohigh";
				$sOrder=" ASC ";
				//Any price	
		}
	}
	
	//Checamos si se nos proporciono un Offset
	if (count($url_array) >= (iStartFolder+5)  ){
		$sTemp=$url_array[(iStartFolder+5)];
		if(validateNumber($sTemp,$iErrors)){
			$iOffset=$sTemp;
		}else{
			$iOffset=0;
		}
		$sTemp="";
		$iOffset=$url_array[(iStartFolder+5)];
		$iOffset-=1;
		if($iOffset<0) $iOffset=0; //Debe de ser minimo 0 para MySQL.  
	} else{
		$iOffset=0;
	}
	
	$sSQLFilters=""; //Aqui agregaremos los filtros
	if($bFilterType){
		$sSQLFilters.=" AND ( PropertyTypes.Type_eng LIKE '%$sFilterType%')";
		
	}
	
//Este codigo es para filtrar las reventas.
	if($bOnlyResales){
		$sSQLFilters.=" AND (Properties.resale=1) " ;
	}/*else{
		$sSQLFilters.=" AND (Properties.resale=0) " ;
	}*/
	if($bFilterPrice){
		if($bMoreThan){
			$sSQLFilters.=" AND  (Properties.Price>$iFilterPrice)";
		} else{
			$sSQLFilters.=" AND  (Properties.Price<=$iFilterPrice)";
		}
	}
	
	if($bFilterBedrooms){
		$sSQLFilters.=" AND  (Properties.Bedrooms=$iFilterBedrooms)";
	}
	
	if($bFilterByEstar){
		if($bBedroomsWithEstar){
			$sSQLFilters.=" AND  (Properties.estar=1)";
		}else{
			$sSQLFilters.=" AND  (Properties.estar=0)";
		}
	}
	
	$sSQLTotalCount="	SELECT COUNT(*) AS totalCount  "
		. " FROM Developments INNER JOIN Buildings ON Buildings.idDevelopment = Developments.idDevelopment " 
		. " INNER JOIN  PropertyTypes ON Buildings.idPropertyType = PropertyTypes.idPropertyType " 
		. " INNER JOIN Properties ON Buildings.idBuilding = Properties.idBuilding " 
		. " INNER JOIN Status ON Properties.idStatus = Status.idStatus  " 
		. " WHERE ((Status.idStatus=5) OR (Status.idStatus=6) ) AND (Properties.activo=1)" . $sSQLDevelopmentFilter . $sSQLFilters 
		. " ORDER BY Properties.Price $sOrder ";
	//echo $sSQLTotalCount;
	$totalCountResult=mysql_query($sSQLTotalCount);
	if (mysql_num_rows($totalCountResult)==1){
		$row=mysql_fetch_row($totalCountResult);
		$iTotalCount=$row[0];	
	}else{
		$iTotalCount=0;	
	}
		
	$sSQL="	SELECT Buildings.buildingName, Properties.Number,Properties.Price, Properties.Bedrooms,Properties.Baths, " 
		. " Properties.squareMeters,Properties.squareFeets, PropertyTypes.Type_eng, Status.Status_eng, " 
		. " Properties.mainPicture_thumb,Properties.idProperty,Developments.Abbreviation  "
		. " FROM Developments INNER JOIN Buildings ON Buildings.idDevelopment = Developments.idDevelopment " 
		. " INNER JOIN  PropertyTypes ON Buildings.idPropertyType = PropertyTypes.idPropertyType " 
		. " INNER JOIN Properties ON Buildings.idBuilding = Properties.idBuilding " 
		. " INNER JOIN Status ON Properties.idStatus = Status.idStatus  " 
		. " WHERE ((Status.idStatus=5) OR (Status.idStatus=6) ) AND (Properties.activo=1) " . $sSQLDevelopmentFilter . $sSQLFilters 
		. " ORDER BY Properties.Price $sOrder, Buildings.buildingName, Properties.Number "
		. " LIMIT $iOffset," . iRowsPerPage;
	//echo $sSQL;
	$result=mysql_query($sSQL);
	
	 function writeBedroomsLink($uritext,$linktext){
		global $sURICurrentBedroomNumber;
		global $sURICurrentType;
		global $sURICurrentPrice;
		global $sURICurrentOrder;
		global $sURICurrentDevelopment;
		if ($sURICurrentBedroomNumber==$uritext){
			$sHref="";
			$sTemp=" class=\"current\" ";						
		}else{
			$sHref="href=\"/search_properties/$sURICurrentDevelopment/$sURICurrentType/$uritext/$sURICurrentPrice/$sURICurrentOrder\" ";
			$sTemp="";
		}
		echo "<a $sTemp $sHref>$linktext </a>";
	 }
	 
	 function writePricesLink($uritext,$linktext){
		global $sURICurrentBedroomNumber;
		global $sURICurrentType;
		global $sURICurrentPrice;
		global $sURICurrentOrder;
		global $sURICurrentDevelopment;
		if ($sURICurrentPrice==$uritext){
			$sHref="";
			$sTemp=" class=\"current\" ";						
		}else{
			$sHref="href=\"/search_properties/$sURICurrentDevelopment/$sURICurrentType/$sURICurrentBedroomNumber/$uritext/$sURICurrentOrder\" ";
			$sTemp="";
		}
		echo "<a $sTemp $sHref >$linktext </a>";
	 }
	 
	 function writeTypesLink($uritext,$linktext){
		global $sURICurrentBedroomNumber;
		global $sURICurrentType;
		global $sURICurrentPrice;
		global $sURICurrentOrder;
		global $sURICurrentDevelopment;
		if ($sURICurrentType==$uritext){
			$sHref="";
			$sTemp=" class=\"current\" ";						
		}else{
			$sHref="href=\"/search_properties/$sURICurrentDevelopment/$uritext/$sURICurrentBedroomNumber/$sURICurrentPrice/$sURICurrentOrder\" ";
			$sTemp="";
		}
		echo "<a $sTemp $sHref >$linktext </a>";
	 }
	 
	 function writeDevelopmentsList($sSelectedDev){
	 	global $sURICurrentBedroomNumber;
		global $sURICurrentType;
		global $sURICurrentPrice;
		global $sURICurrentOrder;
		$sSQL="select developmentName AS developmentName,Abbreviation AS Abrreviation from Developments;";
		$result=mysql_query($sSQL);
		if ( mysql_num_rows($result)>0 ){
			echo "<ul> \n";
			while($row = mysql_fetch_array( $result )){
					
					$sDevName=$row["developmentName"];
					$sDevNameURI=strtr($sDevName," ","_");
					$sDevAbbreviation=$row["Abrreviation"];
				    	$sURI="/search_properties/$sDevNameURI/$sURICurrentType/$sURICurrentBedroomNumber/$sURICurrentPrice/$sURICurrentOrder";

					if($sSelectedDev==$sDevNameURI){
						$sSelected=" class=\"current\" ";
					}else{
						$sSelected="";					
					}
					echo "<li><a href=\"$sURI\" $sSelected>$sDevName ($sDevAbbreviation)</a></li>\n";					
			}
				if($sSelectedDev=="alldevelopments"){
						$sSelected=" class=\"current\" ";
					}else{
						$sSelected="";					
					}
			echo "<li><a href=\"/search_properties/alldevelopments/$sURICurrentType/$sURICurrentBedroomNumber/$sURICurrentPrice/$sURICurrentOrder\" $sSelected > All Developments</a></li>\n";	
			echo "</ul> \n";	
		}
	 	
	 }
	 
	  function writeOrder($uritext,$linktext){
		global $sURICurrentBedroomNumber;
		global $sURICurrentType;
		global $sURICurrentPrice;
		global $sURICurrentOrder;
		global $sURICurrentDevelopment;
		if ($sURICurrentOrder==$uritext){
			$sHref="";
			$sTemp=" class=\"current\" ";						
		}else{
			$sHref="href=\"/search_properties/$sURICurrentDevelopment/$sURICurrentType/$sURICurrentBedroomNumber/$sURICurrentPrice/$uritext\" ";
			$sTemp="";
		}
		echo "<a $sTemp $sHref>$linktext </a>";
	 }	
		
	include("funciones/layout.php");
	writeHeader("Grupo Real del Mar");
?>

	   <div id="content_inner">
		<div id="properties">
			<h3>Properties</h3>
			<div id="findby">
				<div id="bysize">
					<h4>Find by size</h4>
					<ul>					    
						<li><?php writeBedroomsLink("2bedrooms","2 Bedrooms"); ?></li>
						<li><?php writeBedroomsLink("2bedrooms_with_den","2 Bedrooms +"); ?></li>
						<li><?php writeBedroomsLink("3bedrooms","3 Bedrooms"); ?></li>
						<li><?php writeBedroomsLink("4bedrooms","4 Bedrooms"); ?></li>
						<li><?php writeBedroomsLink("anybedrooms","All sizes"); ?></li>
					</ul>
				</div>
				<div id="bytype">
					<h4>Find by type</h4>
					<ul>
						  <li><?php writeTypesLink("condominiums","Condominiums"); ?></li>
						  <li><?php writeTypesLink("townhouses","Townhouses"); ?></li>
						  <li><?php writeTypesLink("villas","Villas"); ?></li>
						  <li><?php writeTypesLink("resales","Resales"); ?></li>
						  <li><?php writeTypesLink("allproperties","All Properties"); ?></li>
					</ul>
				</div>
				<div id="byprice">
					<h4>Find by price</h4>
					<ul>
					  	<li><?php writePricesLink("upto400k","Up to 400k"); ?></li>
						<li><?php writePricesLink("upto600k","Up to 600k"); ?></li>
						<li><?php writePricesLink("upto900k","Up to 900k"); ?></li>
						<li><?php writePricesLink("over900k","Over 900k"); ?></li>
						<li><?php writePricesLink("allprices","All prices"); ?></li>
					</ul>
				</div>
				<div id="bydev">
					<h4>Find by development</h4>
					<ul>
					 	<?php  writeDevelopmentsList($sURICurrentDevelopment); ?>
					</ul>
				</div>
				<p class="bt"></p>
			</div>
			<div id="listing">
				<?php
					$iFrom=$iOffset+1;
					if($iFrom<=1) $iFrom = 1;
					$iTotalRecords=mysql_num_rows($result);
					if($iTotalRecords < iRowsPerPage){ //Verificamos que sean los que se estan mostrando.
						$iTo=$iFrom + $iTotalRecords;
						$iTo-=1;
					}else{
						$iTo=($iFrom) + (iRowsPerPage);
						$iTo-=1;
					}
					if($iFrom > $iTotalCount){
						$iFrom=$iTotalCount;
						$iTo=$iFrom;						
					}
					$iPrevious=iRowsPerPage;
					$iNext=iRowsPerPage;
					if( (($iTotalCount - $iPrevious)<=0 ) ){
						if(($iOffset+1) > 	$iTotalCount){ //El offset es 1 menos que el que aparece en la direccion
							$iPrevious=$iFrom;
						}else{
							$iPrevious=$iFrom-1;
						}							
											
					}					
					if( ($iTotalCount - $iTo)< iRowsPerPage ){
						$iNext=$iTotalCount - $iTo;
					}
					function writePreviousNext($iPrevious,$iNext){
						global $sURICurrentBedroomNumber;
						global $sURICurrentType;
						global $sURICurrentPrice;
						global $sURICurrentOrder;
						global $sURICurrentDevelopment;
						global $iFrom;
						global $iTo;
						global $iTotalCount;
						
						if($iPrevious<1){
							echo "<a class=\"current\">&lt; Previous </a> |";							
						}else{
							$iOffset=$iFrom-iRowsPerPage;
							if($iOffset<=0){
								$iOffset=1;
							}
							echo "<a href=\"/search_properties/$sURICurrentDevelopment/$sURICurrentType/$sURICurrentBedroomNumber/$sURICurrentPrice/$sURICurrentOrder/$iOffset\">"
							. "&lt; Previous $iPrevious</a> | ";	
						}
						
						if($iNext<1){
							echo "<a class=\"current\">Next &gt;</a>";							
						}else{
							$iOffset=$iTo+1;
							echo "<a href=\"/search_properties/$sURICurrentDevelopment/$sURICurrentType/$sURICurrentBedroomNumber/$sURICurrentPrice/$sURICurrentOrder/$iOffset\">"
							. "Next $iNext &gt;</a>";	
						}
					}					
				?>
				
				
				
				
				
				
				
				
				
				
				<div class="listing_nav"><span class="left">Results <strong><?php echo $iFrom . " - " . $iTo;?></strong> of <strong><?php echo $iTotalCount;?></strong> </span> <span class="right">Sort by:  <?php writeOrder("lowtohigh","Low to high"); ?> |  <?php writeOrder("hightolow","High to Low"); ?></span></div>
				
				
				
				<?php
					while($row = mysql_fetch_array( $result )) {
						$sClass=strtolower($row["Status_eng"]);						
						if($row["Number"]!="000"){ //Comprobamos que el numero no sea 000(esto para el titulo de las villas)
							$sPropertyTitle=$row["Abbreviation"] . " - " . $row["buildingName"] . " - " . $row["Number"] ;						
						}else{
							$sPropertyTitle=$row["Abbreviation"] . " - " . $row["buildingName"];						
						}
						$sLinkAddress="/property_details/" . $row["idProperty"];
						$sOnClickUrl="onClick=\"window.open(this.href, 'popupwindow','width=675,height=550,scrollbars,resizable'); return false;\"";
						echo "\t\t\t\t" . '<div class="item">' . "\n";
						echo "\t\t\t\t\t" . '<a href="' .$sLinkAddress . '" ' . $sOnClickUrl . '><img src="' . $row["mainPicture_thumb"] .'" alt="' . $sPropertyTitle . '"'
						. ' width="154" height="101" border="0" /></a>' . "\n"; 
						echo "\t\t\t\t\t" . '<h4><a href="' . $sLinkAddress . '" ' . $sOnClickUrl . '>' . $sPropertyTitle . '</a></h4>' . "\n";
						echo "\t\t\t\t" . '<p class="info1">' . "\n";
						
						echo "\t\t\t\t\t" . 'Price: $ ' . displayQuantitys($row["Price"]) . ' USD<br />' . "\n";							
						//echo "\t\t\t\t\t" . 'Price: $ ' . displayQuantitys($row["Price"]) . ' USD<br />' . "\n";
						echo "\t\t\t\t\t" . 'Bedrooms: ' . $row["Bedrooms"] . '<br />' . "\n";
						echo "\t\t\t\t\t" . 'Baths: ' . $row["Baths"] . '<br />' . "\n";
						echo "\t\t\t\t</p> \n";
						
						echo "\t\t\t\t" . '<p class="info2">' . "\n";
						echo "\t\t\t\t\t" . 'Total m<sup>2</sup>: ' . displayQuantitys($row["squareMeters"]) . '<br />' . "\n";
						echo "\t\t\t\t\t" . 'Total sqft: ' . displayQuantitys($row["squareFeets"]) . '<br />' . "\n";
						echo "\t\t\t\t\t" . 'Type: ' . $row["Type_eng"] . '' . "\n";
						echo "\t\t\t\t</p> \n";
						
						echo "\t\t\t\t" . '<p class="info3">' . "\n";
						echo "\t\t\t\t\t" . '<span class="' . $sClass . '">' . $row["Status_eng"] . '</span><br />' . "\n";
						echo "\t\t\t\t\t" . '<a href="/contact.php">Contact &gt; ' . "\n";
						echo "\t\t\t\t\t" . '<br />ASK FOR PRE-CONSTRUCTION DISCOUNTS! </a> ' . "\n";
						echo "\t\t\t\t</p> \n";
						
						echo "\t\t\t\t" . '</div>' . "\n";
					}
					
				?>
				
				
				
				
				<div class="listing_nav"><span class="left">Results <strong><?php echo $iFrom . " - " . $iTo;?></strong> of <strong><?php echo $iTotalCount;?></strong></span> <span class="right"><?php writePreviousNext($iPrevious,$iNext); ?> </span></div>
				
			</div>
		</div>
	 </div>
	<?php 
		writeFooter(); 
	?>