/************************* abre pagina no div ****************************************
chamada 
	exibe_div("simulacao.php",'simulacao');
*/
function exibe_div(url, containerid){
	var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
		le_pagina(page_request, containerid)
	}
	page_request.open('POST', url, true)
	page_request.send(null)
}

function le_pagina(page_request, containerid){
	
if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1))
	document.getElementById(containerid).innerHTML=page_request.responseText
	
}


/* chamada da função
	sql = ' SELECT  replace(r.Qtde_Compra  - Sum(if( `cp`.`Qtde` is null,0,`cp`.`Qtde`)) ,".",",")  as fieldQtde FROM  reserva r INNER JOIN projeto_material pm ON (r.Cod_Projeto_Material = pm.Codigo) left join `compra_produto` AS `cp` on (pm.Cod_Proposta_Lista_Item = cp.Cod_Proposta_Lista_Item) 	WHERE 		(pm.Cod_Proposta_Lista_Item="' + v[1] + '")';
	preenche_campos_sql(sql);
	chamais use tab no lugar do espaço, pois o script desconsidera
	para colocar "+" na url coloque [soma]
	moeda = são os colunas que precisão ser formatada como moeda, començando com o numero 1. ex: 1,2 
*/
function preenche_campos_sql(sql, tipo,moeda){
		sql = encodeURIComponent(sql);

//		document.getElementById('teste').innerText =  "ajax_completa_dados.php?sql=" +sql ;

	var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
		preenche_campos_aux(page_request, tipo)
	}
	url ="funcao/ajax_completa_dados.php?sql=" + sql + "&moeda=" + moeda;
//	document.getElementById('teste').innerText = url ;
//window.open(url);
	page_request.open('GET',url  , true)

	page_request.send(null)
}


function preenche_campos(url, tipo){
	var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
		return preenche_campos_aux(page_request, tipo)
	}
//	window.open(url,'_blank')
	page_request.open('GET', url, true)
	page_request.send(null)
}

function preenche_campos_aux(page_request, tipo){

	if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1)){
//		document.getElementById('teste').innerText += "\n" + page_request.responseText;

		results = page_request.responseText.split("|");
//alert(results );
//	document.getElementById('id_teste').innerHTML = page_request.responseText;	
		for( i = 0; i < results.length; i++ ){
		  string = results[i].split( "=" );
		  if(tipo != "id"){
			 document.forms['form1'].elements[string[0]].value = string[1];
			 if(document.forms['form1'].elements[string[0]].onchange != null && document.forms['form1'].elements[string[0]].onchange != undefined)
				 document.forms['form1'].elements[string[0]].onchange()
		  }else {
			 document.getElementById(string[0]).innerHTML= string[1];
		  }
		}
		return true;
	}
}


//---------------------------------------------------------------------------------------------

//---------------------------------------------------------------------------------------------
function preenche_list(url, id, atual){

var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
			
		if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1)){
		
			var list = document.getElementById(id);

			results = page_request.responseText.split("|");

			list.options.length = 0;
			list.options[0]=new Option("----------","");
			for( i = 1; i < results.length; i++ )
			{
				opcoes = results[i-1].split("=");
				list.options[i]=new Option(opcoes[1],opcoes[0]);
				if(atual == opcoes[0])
					list.options[i].selected = true;
			}
			
			return true;
		}
	}
	page_request.open('GET', url, true)
	page_request.send(null)
}

/*
function pesquisar_centro_custo(){
	sql = ' SELECT  Cod_Centro_Custo, Centro_Custo from centro_custo';	
	preenche_list_sql(sql, 'id_fieldCod_Centro_Custo', form1.fieldCod_Centro_Custo.valu);
}

É necessario o arquivo ajax_preenchi_lista_sql.php
*/
function preenche_list_sql(sql, id, atual){
	sql = encodeURIComponent(sql);
	var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
			
		if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1)){
//			document.getElementById('id_teste').innerHTML = page_request.responseText;
			var list = document.getElementById(id);
			results = page_request.responseText.split("|");

			list.options.length = 0;
			list.options[0]=new Option("----------","");
			for( i = 1; i < results.length; i++ )
			{
				opcoes = results[i-1].split("=");
				list.options[i]=new Option(opcoes[1],opcoes[0]);
				if(atual == opcoes[0])
					list.options[i].selected = true;
			}
			
			return true;
		}
	}
	page_request.open('GET', "funcao/ajax_preenchi_lista_sql.php?sql=" + sql, true)
	page_request.send(null)
}


function seleciona_list_sql(sql, id){
	sql = encodeURIComponent(sql);
//document.getElementById('id_teste').innerHTML = "ajax_preenchi_lista_sql.php?sql=" + sql;
	var page_request = false
	if (window.XMLHttpRequest) // if Mozilla, Safari etc
		page_request = new XMLHttpRequest()
	else 
		if (window.ActiveXObject){ // if IE
			try {
				page_request = new ActiveXObject("Msxml2.XMLHTTP")
			} 
			catch (e){
				try{
					page_request = new ActiveXObject("Microsoft.XMLHTTP")
				}
				catch (e){}
			}
		}else
			return false
	page_request.onreadystatechange=function(){
			
		if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1)){
//			document.getElementById('id_teste').innerHTML = page_request.responseText;
			var list = document.getElementById(id);
			results = page_request.responseText.split("|");

			for( i = 0; i < list.length; i++ )
			{
				opcoes = results[0].split("=");
//				alert(list.options[i].value + "  |  " + opcoes[0])
				if(list.options[i].value == opcoes[0]){
					list.options[i].selected = true;
					list.onchange();
				}
				else
					list.options[i].selected = false;
			}		
			return true;
		}
	}
	page_request.open('GET', "funcao/ajax_preenchi_lista_sql.php?sql=" + sql, true)
	page_request.send(null)
}