var xmlHttp;

function createXMLHttpRequest(){
	
	if (window.ActiveXObject){
		xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
	} else if (window.XMLHttpRequest){
		xmlHttp = new XMLHttpRequest();
	}
}

function refreshBaseList() {
	var state = document.getElementById("state").value;
	
	if (state==""){
		clearBaseList();
		clearSquadronList();
	}
	
	var url = "squadron_sql.php?queryType=base&stateid=" + state;
	createXMLHttpRequest();
	xmlHttp.onreadystatechange = handleStateChange;
	xmlHttp.open("GET",url, true);
	xmlHttp.send(null); 
	
}


function refreshSquadronList() {
	var base = document.getElementById("base").value;
	if (base==""){
		clearSquadronList();
	}
	
	var url = "squadron_sql.php?queryType=squadron&baseid=" + base;
	createXMLHttpRequest();
	xmlHttp.onreadystatechange = handleBaseChange;
	xmlHttp.open("GET",url, true);
	xmlHttp.send(null); 
	
	
}

function handleStateChange(){
	if(xmlHttp.readyState==4){
		if(xmlHttp.status == 200){
			updateBaseList();
		}
	}
}

function handleBaseChange() {
	if(xmlHttp.readyState==4){
		if(xmlHttp.status == 200){
			updateSquadronList();
		}
	}
}


function updateBaseList(){
	
	clearBaseList();
	clearSquadronList();
	
	
	var bases = document.getElementById("base");
	var results = xmlHttp.responseXML.getElementsByTagName("base");
	var option = null;
	for (var i = 0; i < results.length; i++){
		option = document.createElement("option");
		option.setAttribute("value",results[i].getAttribute("id"));
		option.appendChild(document.createTextNode(results[i].firstChild.nodeValue));
		bases.appendChild(option);
	}
	
	
}



function updateSquadronList(){
	clearSquadronList();
	var squadrons = document.getElementById("squadron_id");
	var results = xmlHttp.responseXML.getElementsByTagName("squadron");
	var option = null;
	for (var i = 0; i < results.length; i++){
		option = document.createElement("option");
		option.setAttribute("value",results[i].getAttribute("id"));
		option.appendChild(document.createTextNode(results[i].firstChild.nodeValue));
		squadrons.appendChild(option);
	}
}

function clearBaseList(){
	var bases = document.getElementById("base");
	while(bases.childNodes.length > 0){
		bases.removeChild(bases.childNodes[0]);
	}
	
	
}

function clearSquadronList(){
	var squadrons = document.getElementById("squadron_id");
	while (squadrons.childNodes.length > 0){
		squadrons.removeChild(squadrons.childNodes[0]);
	}
	
}

function popUp(URL) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, '" + id + "', 'toolbar=0,scrollbars=0,location=0,statusbar=1,menubar=0,resizable=1,width=800,height=600,left = 440,top = 225');");
}