// JavaScript Document
function CRIA_QUERY()
{
var sql = "SELECT * FROM imoveissite LEFT JOIN CADUnidade on imoveissite.codigo=CADUnidade.IDUnidade LEFT JOIN CADZona ON CADUnidade.IDzona = CADZona.IDZona WHERE imoveissite.codigo > 0";
	if(document.getElementById('codigo').value!='')
	{
		sql += " and codigo = "+document.getElementById('codigo').value;
	}
	else
	{
//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('tp_consulta').value!='')
		{
			sql += " and "+document.getElementById('tp_consulta').value+" <> 0 ";
		}
		if(document.getElementById('tpimovel').value!='')
		{
			sql += " and tpimovel = '"+document.getElementById('tpimovel').value+"'";
		}
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('Zona').value!='selecione')
		{
			sql += " and CADzona.idzona = "+document.getElementById('Zona').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		if(document.getElementById('mindorm').value!='0')
		{
			sql += " and dormitorio = "+document.getElementById('mindorm').value;
		}
//--------------------------------------------------------------------------------------------------------------------------
		
		if(document.getElementById('tp_consulta').value =='locacao')
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and locacao "+document.getElementById('valor').value;
			}
		}
		else if(document.getElementById('tp_consulta').value =='venda')
		{
			if((document.getElementById('valor').value!='') && (document.getElementById('valor').value!='0'))
			{
				sql += " and venda "+document.getElementById('valor').value;
			}
		}
		
//-----------------------------------------------------------------------------------------------------	
		if(document.getElementById('bairro').value!='selecione')
		{
			sql += " and bairro = '"+document.getElementById('bairro').value+"'";
		}
		if(document.getElementById('finalidade').value!='')
			{
				sql += " and Tipo = "+document.getElementById('finalidade').value;
			}
	}

//-----------------------------------------------------------------------------------------------------	
	if(document.getElementById('tp_consulta').value!='todos')
	{
		sql += " order by "+document.getElementById('tp_consulta').value+" asc"
	}
	else{
		sql += " order by venda asc"
	}
//-----------------------------------------------------------------------------------------------------	

	document.getElementById('SQL').innerHTML = sql
	document.buscahome.submit();
}