var myRequest = null;

function CreateXmlHttpReq(handler) {
  var xmlhttp = null;
  xmlhttp = new XMLHttpRequest();
  xmlhttp.onreadystatechange = handler;
  return xmlhttp;
}

function myHandler() {
	if (myRequest.readyState == 4 && myRequest.status == 200) {
		//alert(myRequest.responseText);
		eval(myRequest.responseText);
		for ( var i=2; i < ajax_data.length; i=i+2 ){
			  nTipoTag = document.getElementById(ajax_data[i]).type;
			  if (nTipoTag == 'checkbox') {
				  
				  //alert(ajax_data[i+1])
				  
				  if ( ajax_data[i+1] == 'S' )
				  	 document.getElementById(ajax_data[i]).checked=true
				  else
				  	 document.getElementById(ajax_data[i]).checked=false;
			  }
		  	  document.getElementById(ajax_data[i]).value=ajax_data[i+1];
		}
	}
}
// Decodifica Campi
function ajax_php(whereCondition,qry_ajax) {
	//alert(qry_ajax)
		 var ar_fildKeys = whereCondition.split(";");
		 var key_Condition = "";
		 for(i=0; i < ar_fildKeys.length; i++) {
			 var ar_fildKey = ar_fildKeys[i].split(",");
			 if (key_Condition!="") key_Condition += " AND ";
		 	 key_Condition += ar_fildKey[0] + " = '" + document.getElementById(ar_fildKey[1]).value + "'";
		 }

	//alert(key_Condition);

    var r = Math.random();
    myRequest = CreateXmlHttpReq(myHandler);
    myRequest.open("GET","capera_ajax.php?&valore="+escape(key_Condition)+"&qry_ajax="+escape(qry_ajax)+"&rand="+escape(r));
    myRequest.send(null);
}

// Handler SelectDB
function handler_selectDB() {
	if (myRequest.readyState == 4 && myRequest.status == 200) {
		//alert(myRequest.responseText);
		eval(myRequest.responseText);
		// Azzero Combo Relazionata
		for(i=document.getElementById(ajax_data[0]).length-1;i>=0;i--) document.getElementById(ajax_data[0]).options[i]=null;
		// Popolo Combo Relazionata
		var optionSelect= new Array();
		optionSelect[0] = document.createElement("option") ; 
		optionSelect[0].setAttribute("value",""); 
		var text = document.createTextNode(" "); 
		optionSelect[0].appendChild(text);
		document.getElementById(ajax_data[0]).appendChild(optionSelect[0]);

		if ( ajax_data.length > 1) {
			for ( var i=1; i < ajax_data.length; i=i+2 ){
				//alert( ajax_data[i] );
				var optionSelect= new Array();
				optionSelect[0] = document.createElement("option") ; 
				optionSelect[0].setAttribute("value", ajax_data[i]);
				optionSelect[0].setAttribute("title", ajax_data[i]); 
				if (ajax_data[i+1]=="")
					var text = document.createTextNode(ajax_data[i])
				else
					var text = document.createTextNode(ajax_data[i+1])
				optionSelect[0].appendChild(text);
				document.getElementById(ajax_data[0]).appendChild(optionSelect[0]);
			}
		}
	}
}

function ajax_selectDB(valore,qry_ajax,destinazione) {
    var r = Math.random();
    myRequest = CreateXmlHttpReq(handler_selectDB);
    myRequest.open("GET","capera_selectDB.php?valore="+escape(valore)+"&qry_ajax="+escape(qry_ajax)+"&destinazione="+escape(destinazione)+"&rand="+escape(r));
    myRequest.send(null);
}

function ajax_jml_selectDB(valore,qry_ajax,destinazione) {
    var r = Math.random();
    myRequest = CreateXmlHttpReq(handler_selectDB);
    myRequest.open("GET","http://www.ctptaranto.com/modo_ctp/moduli/seek_linee/capera_selectDB.php?valore="+escape(valore)+"&qry_ajax="+escape(qry_ajax)+"&destinazione="+escape(destinazione)+"&rand="+escape(r));
    myRequest.send(null);
}