/*
this page stores all criteria defined by user and dynamically add criteria rows.
it also needs to recreate the criteria when page returns from a post as well as
populate field dropdowns for additional criteria rows
*/

var httpfn = null, httpval = null;
var arrAutoCompleteCtrl = new Array();
var nRowIndex = 0;

arrAutoCompleteCtrl[nRowIndex] = new AutoComplete('ac_menu','txtCriteria',null);
nRowIndex++;

// gets the digit 'n' in a string (from an HTML id) in the format "ccccc_n" or "ccccc"
function getIndexFromId(str){
	var i = str.indexOf('_');
	if(i!=-1) str = str.substr(i+1);
	else str = '0';
	return parseInt(str);
}

// adds an index to an id, to create a format of: "ccccc_n" or "ccccc"
function addIndexToId(str, i){
	if(i>0) str += '_'+i;
	return str;
}

function updateImageButtons(){
	var e = document.getElementById('txtAdvSearchValid');
	if(e==null) return;
	if(e.value=='') return;

	var arr = new Array();
	arr = e.value.split('~');

	for(var i=0;i<arr.length;i++){
		var img = document.getElementById(addIndexToId('imgCriteria',i));
		if(img==null) break;
		img.style.display=(arr[i]=='1')?'block':'none';
	}
}

function updateImageButtonDisplayValue(nRowId,bShowImg){
	var txtAdvSearchValid = document.getElementById('txtAdvSearchValid');
	if(txtAdvSearchValid==null) return;

	if(txtAdvSearchValid.value==''){
		txtAdvSearchValid.value=(bShowImg)?'1':'0';
	}
	else{
		var arrTemp = new Array();
		var sValue = txtAdvSearchValid.value;

		arrTemp=sValue.split('~');
		arrTemp[nRowId]=(bShowImg)?'1':'0';

		var sTemp = '';
		for(var i=0;i<arrTemp.length;i++){
			sTemp += ''+arrTemp[i];
			if(i!=arrTemp.length-1) sTemp+='~';
		}

		txtAdvSearchValid.value=sTemp;
	}
}

function DownArrow_OnClickCallback(text){
	var value = new Array();
	value = text.split('~');
	if(value.length<2) return;

	var id = parseInt(value[0]);

	var value2 = new Array();
	for(var i=1;i<value.length;i++) value2[i-1]=value[i];

	var menu_id = addIndexToId('ac_menu', id);
	var txt_id = addIndexToId('txtCriteria',id);

	var objAC = arrAutoCompleteCtrl[id];
	objAC.generate(value2);
	objAC.show();
}

function DownArrow_OnClick(obj){

	var row_id = '' + getIndexFromId(obj.id);

	// if the AC control is toggled OFF, don't send the AJAX call.
	var objAC = arrAutoCompleteCtrl[parseInt(row_id)];
	if(objAC==null) return;
	if(objAC.toggleShowHide()==false) return;

	var strElementId = addIndexToId('ddlFieldName', row_id);
	var objFN = document.getElementById(strElementId);
	if(objFN==null) return;

	var val = objFN.options[objFN.selectedIndex].value;
	var arr = new Array();
	arr = val.split('::');
	if(arr.length!=3) return;
	if(arr[1] != 'C') return;

	// hide all the opened controls
	for(var i=0;i<arrAutoCompleteCtrl.length;i++){
		var tmp = arrAutoCompleteCtrl[i];
		if(tmp==null) break;
		tmp.hide();
	}

	if(httpval!=null && httpval.readyState!=0) httpval.abort();
	httpval = zXmlHttp.createRequest();

	if(httpval){
		var url = 'WebServices/GetAdvSearchFieldStrValues.aspx?cmd=GetValues&UserData='+row_id+'&FieldId=' + arr[0] + '&ServiceName=' + document.forms[0].txtServiceName.value;
		httpval.open('GET', url, true);
		httpval.onreadystatechange = function(){
			if ((httpval.readyState == 4) && (httpval.status == 200)) DownArrow_OnClickCallback(httpval.responseText);
		};
		httpval.send(null);
	}	
}

function FieldName_OnChangeCallback(text){

	var value = new Array();
	value = text.split('~');
	if(value.length != 2) return;

	var row_id = value[0];
	var showimg = value[1];
	var imgNameId = addIndexToId('imgCriteria', row_id);
	var imgObj = document.getElementById(imgNameId);
	if(imgObj==null) return;

	var bShowImg = (showimg=='true');

	imgObj.style.display = bShowImg ? 'block' : 'none';

	updateImageButtonDisplayValue(parseInt(row_id),bShowImg);

	//var arrTemp = new Array();
	//arrTemp = 

	//var out = '';
	//for(var i=0;i<value.length;i++) out+=value[i]+'\n';
	//alert(out);	
}


function FieldName_OnChange(obj){
	if(obj==null) return;
	if(isNaN(obj.selectedIndex) || obj.selectedIndex < 0) return;

	var activeLayer = document.forms[0].ddlActiveLayer.value
	if(activeLayer==null || activeLayer==''){
		alert('Please select an active layer, in the "Layers" tab.');
		return;
	}

	var row_id=getIndexFromId(obj.id);
	
	var val = obj.options[obj.selectedIndex].value;
	var arr = new Array();
	arr = val.split('::');
	if(arr.length!=3) return;
	if(arr[1] != 'C'){
		updateImageButtonDisplayValue(row_id,false);
		return;
	}

	if(httpfn!=null && httpfn.readyState!=0) httpfn.abort();
	httpfn = zXmlHttp.createRequest();

	if(httpfn){
		var userData = ''+row_id;
		var url = 'WebServices/GetAdvSearchFieldStrValues.aspx?cmd=IsValid&UserData='+userData+'&FieldId=' + arr[0] + '&ActiveLayer=' + activeLayer + '&ServiceName=' + document.forms[0].txtServiceName.value;
		httpfn.open('GET', url, true);
		httpfn.onreadystatechange = function(){
			if ((httpfn.readyState == 4) && (httpfn.status == 200)) FieldName_OnChangeCallback(httpfn.responseText);
		};
		httpfn.send(null);
	}
}

function addCriteriaRow(fieldNameValue,operator,fieldValue){
	var i=0
	var fnLength = 0
	try{
		if(!validateAdvQuery()){
			return false;
		}		
		if(operator.length==0){
			operator="=";
		}
		//dynamically build the dropdowns from the static HTML
		var ddls;
		ddls = document.getElementsByName("ddlFieldName")//this is the only method that returns an array
		if(ddls.length>1){
			var ddl2=ddls[0];
			fnLength=ddl2.options.length;
		}else{
			var ddl2=document.Form1.ddlFieldName
			fnLength=ddl2.options.length;
		}	
		//create dynamic FieldName dropdown and append it to the table
		var ddlFN = document.createElement("SELECT")
		ddlFN.id = "ddlFieldName_"+nRowIndex;
		ddlFN.name="ddlFieldName";
		ddlFN.onchange=function(){FieldName_OnChange(this);};
		var theIndex = 0;
		var theField = 0;
		if(fnLength>0){
			for(i=0;i<fnLength;i++){
				var op = document.createElement("OPTION")
				op.value=ddl2.options[i].value;
				op.text=ddl2.options[i].text;
				theField = op.value.substring(0,op.value.indexOf("::"))
				if(theField==fieldNameValue){
					//op.selected==true;
					theIndex=i;
				}
				ddlFN.options.add(op);
			}
			ddlFN.selectedIndex=theIndex;
		}
		var tr = document.createElement("TR");
		var cell = document.createElement("TD");
		cell.appendChild(ddlFN);
		tr.appendChild(cell);

		var cell = document.createElement("TD");
		var ddlOPR = document.createElement("SELECT");
		ddlOPR.name="ddlOperator";

		//create Operator drop down
		var ddlOP = document.getElementsByName("ddlOperator")//this is the only method that returns an array
		if(ddlOP.length>1){
			var ddlOP2=ddlOP[0];
			fnLength=ddl2.options.length;
		}else{
			var ddlOP2=document.Form1.ddlOperator;
			fnLength=ddlOP2.options.length;
		}
		for(i=0;i<ddlOP2.options.length;i++){
			var op = document.createElement("OPTION");
			op.value=ddlOP2.options[i].value;
			op.text=ddlOP2.options[i].text;
			if(op.value==operator){
				theIndex=i;
			}
			ddlOPR.options.add(op);
		}	
		ddlOPR.selectedIndex=theIndex;
		
		cell=document.createElement("TD");
		cell.appendChild(ddlOPR);
		tr.appendChild(cell);

		//third cell
		cell=document.createElement("TD");
		//Field value textbox
		var txt = document.createElement("INPUT");
		txt.id="txtCriteria_"+nRowIndex;
		txt.type="text";
		txt.maxLength=50;
		txt.size=10;
		txt.name="txtCriteria";
		txt.value=fieldValue;
		cell.appendChild(txt);

		var br = document.createElement("BR");
		cell.appendChild(br);

		//div element for the autocomplete menu options
		var divAcMenu = document.createElement('div');
		divAcMenu.style.visibility='hidden';
		divAcMenu.className='AutoCompleteMenu';
		divAcMenu.id='ac_menu_'+nRowIndex;
		cell.appendChild(divAcMenu);
		tr.appendChild(cell);

		cell=document.createElement("TD");
		var img = document.createElement("img");
		img.id="imgCriteria_"+nRowIndex;
		img.src="Images/arrowDn.gif";
		img.style.display="none";
		img.style.cursor="hand";
		img.onclick=function(){DownArrow_OnClick(this);};
		cell.appendChild(img);
		tr.appendChild(cell);

		var tbl = document.getElementById("tblAdvancedSearchCriteria").tBodies[0];
		tbl.appendChild(tr);

		arrAutoCompleteCtrl[nRowIndex] = new AutoComplete(divAcMenu.id,txt.id,null);
		nRowIndex++;

		// Store boolean values for each row, we will keep track if we need to display the arrow
		// button for the autocomplete control, during page refreshes.
		var txtAdvSearchValid = document.getElementById("txtAdvSearchValid");
		if(txtAdvSearchValid) txtAdvSearchValid.value += '~0';

	}catch (ex){
		alert(ex.message + "\ni=" + i + "\n" + "fnLength=" + fnLength);
	}
}
function clearQuery(){
	try{
		var fnLength = 0;
		var ddls = document.getElementsByName("ddlFieldName");
		if(ddls.length>1){
			var ddl2=ddls[0];
			fnLength=ddl2.options.length ;
		}else{
			var ddl2=document.Form1.ddlFieldName;
			fnLength=ddl2.options.length;
		}
		var tbl = document.getElementById("tblAdvancedSearchCriteria").tBodies[0];
		var rows=(tbl.rows.length-1);
		for(i=rows;i>1;i--){
			tbl.removeChild(tbl.rows[i]);
		}		
		document.forms[0].ddlFieldName.selectedIndex=0;
		document.forms[0].ddlOperator.selectedIndex=0;
		document.forms[0].txtCriteria.value="";
		document.forms[0].txtAdvSearchCriteria.value="";		
	}catch(ex){
		alert("clearQuery Method:\n" + ex.message);
	}
}
function submitAdvQuery(){
	//iterate through ddlFieldName, ddlOperator, txtFieldValues arrays (controls) and build 
	//txtAdvancedQuery hidden field value
	var i = 0
	try{
		if(!validateAdvQuery()){
			return false;
		}		
		var ddlField=new Array();
		var ddlOp = new Array();
		var txtVals = new Array();
		//load dropdowns into array and filter for the ones we need.
		arSelects = document.getElementsByTagName("SELECT");
		if(arSelects.length>0){
			for(i=0;i<arSelects.length;i++){
				var theName = arSelects[i].name;
				switch(theName.toLowerCase()){
					case "ddlfieldname":
						ddlField[ddlField.length]=arSelects[i];
						break;						
					case "ddloperator":
						ddlOp[ddlOp.length]=arSelects[i];
						break;											
				}
			}
		}
		//load txtCriteria textboxes into array
		arSelects = document.getElementsByTagName("INPUT");
		if(arSelects.length>0){
			for(i=0;i<arSelects.length;i++){
				if(arSelects[i].name.toLowerCase()=="txtcriteria"){
					txtVals[txtVals.length]=arSelects[i];
				}
			}
		}
		//get Search TYPE 
		
		var sQry = new String()
		var ddlAdvSrch = document.forms[0].ddlAdvSearchLayers;
		var searchType = ddlAdvSrch.options[ddlAdvSrch.selectedIndex].value;
		var catalogType = ""
		var arSearchTypes = searchType.split(":")
		searchType = arSearchTypes[1] //searchType.substring(searchType.indexOf(":") + 1,searchType.length)
		catalogType = arSearchTypes[2] //SDE, GEO, SPATIAL
		sQry=searchType + ":" + catalogType + "~";
		
		//build text string for postback
		//get AND/OR operator		
		var operators = document.getElementsByName("chkSQLOperator")
		for(i=0;i<operators.length;i++){
			if(operators[i].checked){
				sQry+=operators[i].value + "~";
				break;
			}
		}	
		
		//loop and build the query string
		var ddlVal,fieldIndex,dataType,fieldName, arFieldVals
		for(i=0;i<ddlField.length;i++){
			ddlVal = ddlField[i].options[ddlField[i].selectedIndex].value;
			arFieldVals = ddlVal.split("::");
			fieldIndex = arFieldVals[0];
			dataType = arFieldVals[1];
			fieldName = arFieldVals[2];
			sQry += fieldIndex + ":";
			sQry += ddlOp[i].options[ddlOp[i].selectedIndex].value + ":";		
			sQry += stripChar(stripChar(txtVals[i].value,"~"),":") + ":";
			sQry += fieldName + ":";
			sQry += dataType + "~";			
		}		
		document.forms[0].txtAdvSearchCriteria.value=sQry;
		showRetrieving();
		__doPostBack("anchSubmitAdvQuery","");	
			
	}catch(ex){
		alert("SubmitAdvQuery method:\n" + ex.message) ;
	}finally{
		return false;
	}
}

function stripChar(theString,charToStrip){
	var newString="";
	var i=0;
	for(i=0;i<theString.length;i++){
		if(theString.charAt(i)!=charToStrip){
			newString+=theString.charAt(i);
		}
	}
	return newString
}

function validateAdvQuery(){
	try{
		var fieldID,field,dataType,dataTypeVal,ddlOP,txtVals;
		var arSelects;
		var ddlField=new Array();
		var ddlOp = new Array();
		var txtVals = new Array();		
		//load dropdowns into array and filter for the ones we need.
		arSelects = document.getElementsByTagName("SELECT");
		if(arSelects.length>0){
			for(i=0;i<arSelects.length;i++){
				var theName = arSelects[i].name;
				switch(theName.toLowerCase()){
					case "ddlfieldname":
						ddlField[ddlField.length]=arSelects[i];
						break;						
					case "ddloperator":
						ddlOp[ddlOp.length]=arSelects[i];
						break;												
				}
			}
		}
		//load txtCriteria textboxes into array
		arSelects = document.getElementsByTagName("INPUT")
		if(arSelects.length>0){
			for(i=0;i<arSelects.length;i++){
				if(arSelects[i].name.toLowerCase()=="txtcriteria"){
					txtVals[txtVals.length]=arSelects[i];
				}
			}
		}	
		var rowData	
		for(i=0;i<ddlField.length;i++){
			field=ddlField[i].options[ddlField[i].selectedIndex].value;
			rowData=field.split("::");
			//id::dataType
			dataType = rowData[1];
			operator = ddlOp[i].options[ddlOp[i].selectedIndex].value;
			fieldName = ddlField[i].options[ddlField[i].selectedIndex].text;
			fieldValue = txtVals[i].value;
			if(!rowStatementOk(dataType,operator,fieldValue)){
				var sMsg
				switch(dataType.toLowerCase()){
					case "c":sMsg = fieldName + " requires a character value";break;
					case "n":sMsg = fieldName + " requires a positive numeric value";break;						
					case "d":sMsg = fieldName + " requires a valid date";break;
					case "0":sMsg = "Search feature not available";
				}
				alert(sMsg)
				return false;
			}
		}				
		return true;		
	}catch(ex){
		alert(ex.message)
	}
}

function rowStatementOk(dataType,operator,fieldValue){
	try{
		if(fieldValue==""){
			return false;
		}			
		switch (dataType.toLowerCase()){
			case "c": //characterfield
				//don't do anything. will run with any operator
				break;
			case "n": //numeric field
				var theNum = new Number();
				theNum = fieldValue;
				if(isNaN(fieldValue)){
					return false;
				}else if(fieldValue<0){
					return false;
				}
				break;
			case "d": //date field					
				try{
					return isDate(fieldValue);
				}catch(ex){
					return false;
				}
				break;
		}			
		return true;			
	}catch(ex){
		throw(ex)
	}
}
function rebuildAdvQry(){
	var fieldNameValue,operator,fieldValue
	var rows = new Array()
	var vals = new Array()
	var i=1
	var theValue
	try{	
		var txt = document.forms[0].txtAdvSearchCriteria.value;
		if(txt==""){
			return;
		}
		rows = txt.split("~")
		//start at index 1, as 0 is the AND/OR operator at top
		for(i=2;i<rows.length-1;i++){
			vals = rows[i].split(":");
			fieldNameValue = vals[0];
			operator = vals[1];
			fieldValue=vals[2];
			if(i==2){//just initalize the static html controls				
				var ddl=document.forms[0].ddlFieldName;
				for(j=0;j<ddl.options.length;j++){
					theValue = ddl.options[j].value;
					if(fieldNameValue==theValue.substring(0,theValue.indexOf("::"))){
						ddl.selectedIndex=j;
						break;
					}
				}
			}else{//build the dynamic ones
				addCriteriaRow(fieldNameValue,operator,fieldValue);
			}
		}		
	}catch (ex){
		alert('Page Load: rebuildAdvQry() Error: ' + ex.message);
	}
}

function requeryAdvQueryFieldList(obj){
	
	try{
		var layerName = obj.options[obj.selectedIndex].value;
		if(obj.options){
			if(obj.options.length>0){
				GetAdvancedSearchFieldList(document.forms[0].txtUser.value,document.forms[0].txtServiceName.value,layerName);
			}else{
				alert("No layers to requery");
			}
		}else{
			alert("'ddlAdvSearchLayers' does not exist");
		}
		
		resetActiveLayer(obj);
		
	}catch(ex){
		alert(ex.message);
	}
	
}
function resetActiveLayer(obj){
	var layerName = obj.options[obj.selectedIndex].value
	try{
		layerName=layerName.substring(0, layerName.indexOf(":"))
		GetAdvancedSearchFieldList(document.forms[0].txtUser.value,document.forms[0].txtServiceName.value,layerName);
		clearQuery();
	}catch(ex){
		alert(ex.message);
	}
}


//character, minimum year and maximum year
var dtCh= "/";
var minYear=1600;
var maxYear=2100;
function isInteger(s){
	var i;
    for (i = 0; i < s.length; i++){   
        // Check that current character is number.
        var c = s.charAt(i);
        if (((c < "0") || (c > "9"))) return false;
    }
    // All characters are numbers.
    return true;
}
function stripCharsInBag(s, bag){
	var i;
    var returnString = "";
    // Search through string's characters one by one.
    // If character is not in bag, append to returnString.
    for (i = 0; i < s.length; i++){   
        var c = s.charAt(i);
        if (bag.indexOf(c) == -1) returnString += c;
    }
    return returnString;
}
function daysInFebruary (year){
	// February has 29 days in any year evenly divisible by four,
    // EXCEPT for centurial years which are not also divisible by 400.
    return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 );
}
function DaysArray(n) {
	for (var i = 1; i <= n; i++) {
		this[i] = 31
		if (i==4 || i==6 || i==9 || i==11) {this[i] = 30}
		if (i==2) {this[i] = 29}
   } 
   return this
}
function isDate(dtStr){
	var daysInMonth = DaysArray(12);
	var pos1=dtStr.indexOf(dtCh);
	var pos2=dtStr.indexOf(dtCh,pos1+1);
	var strMonth=dtStr.substring(0,pos1);
	var strDay=dtStr.substring(pos1+1,pos2);
	var strYear=dtStr.substring(pos2+1);
	strYr=strYear;
	if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)
	if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)
	for (var i = 1; i <= 3; i++) {
		if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1);
	}
	month=parseInt(strMonth)
	day=parseInt(strDay)
	year=parseInt(strYr)
	if (pos1==-1 || pos2==-1){
		//alert("The date format should be : mm/dd/yyyy")
		return false;
	}
	if (strMonth.length<1 || month<1 || month>12){
		//alert("Please enter a valid month")
		return false;
	}
	if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){
		//alert("Please enter a valid day")
		return false;
	}
	if (strYear.length != 4 || year==0 || year<minYear || year>maxYear){
		//alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear)
		return false;
	}
	if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){
		//alert("Please enter a valid date")
		return false;
	}
	return true;
}