include('db.php');
$limite = $_GET["limit"];
//Limito la busqueda
$TAMANO_PAGINA = $limite;


$pagina = $_GET['pagina'];
$pueb = $_GET['pueb'];
$cate = $_GET['cate'];
$ordenar = $_GET['ordenar'];

//
$precio = $_GET["precio"];

//
if($pueb == "all")
{
	$pueb = "";
	$puebquery = "projectos.project_city like '%%'";
}
if($cate == "todos")
{
	$cate = "";
	$catego = "projectos.project_category like '%%'";
}else{
	$catego = "projectos.project_category like '$cate'";
}

if($pueb == 1)
{
	$puebquery = "(((projectos.project_city) = 'camuy' or (projectos.project_city) = 'hatillo' or (projectos.project_city) = 'arecibo' or (projectos.project_city) = 'barceloneta' or (projectos.project_city) = 'florida' or (projectos.project_city) = 'manati' or (projectos.project_city) = 'vega baja' or (projectos.project_city) = 'morovis' or (projectos.project_city) = 'corozal' or (projectos.project_city) = 'vega alta' or (projectos.project_city) = 'toa alta' or (projectos.project_city) = 'dorado' or (projectos.project_city) = 'toa baja'))";
}
else if($pueb == 2)
{
	$puebquery = "(((projectos.project_city) = 'bayamon' or (projectos.project_city) = 'guaynabo' or (projectos.project_city) = 'trujillo alto' or (projectos.project_city) = 'san juan' or (projectos.project_city) = 'santurce' or (projectos.project_city) = 'hato rey' or (projectos.project_city) = 'miramar' or (projectos.project_city) = 'catano' or (projectos.project_city) = 'condado' or (projectos.project_city) = 'carolina'))";
}
else if($pueb == 3)
{
	$puebquery = "(((projectos.project_city) = 'lares' or (projectos.project_city) = 'adjuntas' or (projectos.project_city) = 'utuado' or (projectos.project_city) = 'jayuya' or (projectos.project_city) = 'ciales' or (projectos.project_city) = 'orocovis' or (projectos.project_city) = 'barranquitas' or (projectos.project_city) = 'naranjito' or (projectos.project_city) = 'aguas buenas' or (projectos.project_city) = 'caguas' or (projectos.project_city) = 'comerio' or (projectos.project_city) = 'cidra' or (projectos.project_city) = 'aibonito' or (projectos.project_city) = 'cayey'))";
}
else if($pueb == 4)
{
	$puebquery = "(((projectos.project_city) = 'yauco' or (projectos.project_city) = 'guayanilla' or (projectos.project_city) = 'penuelas' or (projectos.project_city) = 'ponce' or (projectos.project_city) = 'juana diaz' or (projectos.project_city) = 'villalba' or (projectos.project_city) = 'coamo' or (projectos.project_city) = 'santa isabel' or (projectos.project_city) = 'salinas' or (projectos.project_city) = 'guayama' or (projectos.project_city) = 'arroyo' or (projectos.project_city) = 'patillas' or (projectos.project_city) = 'maunabo'))";
}
else if($pueb == 5)
{
	$puebquery = "(((projectos.project_city) = 'gurabo' or (projectos.project_city) = 'san lorenzo' or (projectos.project_city) = 'yabucoa' or (projectos.project_city) = 'juncos' or (projectos.project_city) = 'las piedras' or (projectos.project_city) = 'humacao' or (projectos.project_city) = 'naguabo' or (projectos.project_city) = 'ceiba' or (projectos.project_city) = 'carolina' or (projectos.project_city) = 'loiza' or (projectos.project_city) = 'canovanas' or (projectos.project_city) = 'rio grande' or (projectos.project_city) = 'luquillo' or (projectos.project_city) = 'fajardo' or (projectos.project_city) = 'rio mar'))";
}
else if($pueb == 6)
{
	$puebquery = "(((projectos.project_city) = 'quebradillas' or (projectos.project_city) = 'isabela' or (projectos.project_city) = 'aguadilla' or (projectos.project_city) = 'san sebastian' or (projectos.project_city) = 'moca' or (projectos.project_city) = 'aguada' or (projectos.project_city) = 'rincon' or (projectos.project_city) = 'anasco' or (projectos.project_city) = 'las marias' or (projectos.project_city) = 'mayaguez' or (projectos.project_city) = 'maricao' or (projectos.project_city) = 'hormigueros' or (projectos.project_city) = 'san german' or (projectos.project_city) = 'sabana grande' or (projectos.project_city) = 'cabo rojo' or (projectos.project_city) = 'lajas' or (projectos.project_city) = 'guanica' or (projectos.project_city) = 'boqueron'))";
}
else
{
	$puebquery = "projectos.project_city like '%$pueb%'";
}
//
if($precio == 0) {
	if ($ordenar == 1) {
		$orden = "ORDER BY projectos.project_name ASC";
	} else if($ordenar == 2) {
		$orden = "ORDER BY projectos.project_name DESC";
	} else if($ordenar == 3) {
		$orden = "ORDER BY RAND()";
	}
} else if($precio != 0) {
	if($precio == 1) {
		$orden = "ORDER BY projectos.precios ASC";
	}else if($precio == 2) {
		$orden = "ORDER BY projectos.precios DESC";
	}
}

if (!$pagina) {
	$inicio = 0;
	$pagina=1;
}
else {
	$inicio = ($pagina - 1) * $TAMANO_PAGINA;
}


$ssql = "SELECT projectos.precios, projectos.extra, projectos.id, projectos.description, projectos.project_name, projectos.developer, projectos.project_city, projectos.phone_number, project_type.type, project_category.category, projectos.project_type, projectos.thumb ";
$ssql .= "FROM project_category INNER JOIN (project_type INNER JOIN projectos ON project_type.id = projectos.project_type) ON project_category.id = projectos.project_category ";
$ssql .= " WHERE " . $puebquery . " OR ((projectos.project_type='1') AND (projectos.project_type='0')) or " . $catego ;