var SQLExpression="";
var parameterArray=new Array();

/////////////////////////////////////////////
//////////////////////去掉字符串中的空格
function  jtrim(s)
{
    var  i,b=0,e=s.length;
    for(i=0;i<s.length;i++)
        if(s.charAt(i)!=' '){b=i;break;}
    if(i==s.length)
        return  "";
    for(i=s.length-1;i>b;i--)
        if(s.charAt(i)!=' '){e=i;break;}
    return  s.substring(b,e+1);
}
////////////////////////////////////////////////////////
///////////////////高級查詢的初始化
function init()
{
	parameterArray=window.dialogArguments;
	//document.getElementById("baseTableName").value=checkUndefined(parameterArray["baseTableName"]);
	//document.getElementById("superTableName").value=checkUndefined(parameterArray["superTableName"]);
	document.getElementById("keyNames").value=checkUndefined(parameterArray["keyNames"]);
	document.getElementById("menuID").value=checkUndefined(parameterArray["menuID"]);
	document.getElementById("searchText").value=checkUndefined(parameterArray["searchText"]);
	document.getElementById("searchSQL").value=checkUndefined(parameterArray["searchSQL"]);
	document.getElementById("orderColumn").value=checkUndefined(parameterArray["orderColumn"]);
	document.getElementById("orderKind").value=checkUndefined(parameterArray["orderKind"]);
	document.getElementById("multiSort").value=checkUndefined(parameterArray["multiSort"]);
	document.getElementById("pageShowType").value=checkUndefined(parameterArray["pageShowType"]);
	
	SQLExpression=parameterArray["searchSQL"];
}
//////////////////////////////////////////////////////////
//////////////////////根據用戶的選擇產生相應的查詢條件
function Search(jointWord,jointWordChs)
{
	//jointWord代表按下的是“與”還是“或”
	
	var tempTableName=document.getElementById("superTableName").value;
	
	var columnNameIndex=document.getElementById("select1").selectedIndex;
	var relationIndex  =document.getElementById("select2").selectedIndex;
	
	//代表查詢數據項的內容
    var columnName=document.getElementById("select1").options(columnNameIndex).value;
    //代表關系符的內容
    var relationContent=document.getElementById("select2").options(relationIndex).innerText;
	
	//代表查詢數據項內容所轉化的值
	var itemValue=tempTableName+"."+columnName;
    //代表表達式的內容
	var expressionContent=document.getElementById("text1").value;
	           
	if(	(document.getElementById("text1").value=="") && 
		(document.getElementById("select2").options[columnNameIndex].innerText!="=空") && 
		(document.getElementById("select2").options[relationIndex].innerText!="<>空"))
	{
		alert("表達式不能為空,請填寫!");
	}
	else
	{
		if(document.getElementById("searchText").value=="")
		{
			document.getElementById("searchText").value=columnName+" "+relationContent+" "+expressionContent;
			switch(relationContent)
			{
				case "=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case "<>":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case ">":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case ">=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"'";break;
				case "<":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"' or "+itemValue+" is null";break;
				case "<=":
					SQLExpression =itemValue+relationContent+"'"+expressionContent+"' or "+itemValue+" is null";break;
				case "包含":
					SQLExpression =itemValue+" "+"like"+" "+"'%"+expressionContent+"%'";break;
				case "不包含":
					SQLExpression =itemValue+" "+"not like"+" "+"'%"+expressionContent+"%'";break;
				case "=空":
					SQLExpression =itemValue+" is null";break;
				case "<>空":
					SQLExpression =itemValue+" is not null";break;
				case "包含%":
					SQLExpression =itemValue+" like "+"'"+expressionContent+"%'";break;
				case "不含%":
					SQLExpression =itemValue+" not like "+"'"+expressionContent+"%'";break;
			}
		}
		else
		{
			document.getElementById("searchText").value="("+document.getElementById("searchText").value+")"+" "+jointWordChs+" "+columnName+" "+relationContent+" "+expressionContent;
			switch(relationContent)
			{
				case "=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case "<>":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case ">":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case ">=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"')";break;
				case "<":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"'  or "+itemValue+" is null)";break;
				case "<=":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+relationContent+"'"+expressionContent+"'  or "+itemValue+" is null)";break;
				case "包含":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"like"+" "+"'%"+expressionContent+"%')";break;
				case "不包含":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"not like"+" "+"'%"+expressionContent+"%')";break;
				case "=空":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" is  null)";break;
				case "<>空":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" is not null)";break;
				case "包含_%":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"like"+" "+"'"+expressionContent+"')";break;
				case "不含_%":
					SQLExpression ="("+SQLExpression+")"+" "+jointWord+" ("+itemValue+" "+"not like"+" "+"'"+expressionContent+"')";break;
			}
		}
	}
	
    SQLExpression="("+SQLExpression+")";
	//存儲要回傳的SQL表達式
    document.getElementById("searchSQL").value=SQLExpression;
}
///////////////////////////////////////////////////////////////
/////////////////////清空查詢條件
function expression_clear()
{
    document.getElementById("searchSQL").value="";
    document.getElementById("searchText").value="";
    SQLExpression="";
}
//////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////點擊確定的操作：將查詢的條件放入域中，并且傳遞條件至servlet查詢
function form_submit()
{
	if(document.getElementById("searchText").value=="")
    {
        alert("請輸入查詢的條件");
    }
    else
    {
        document.deleteActionForm.submit();
        window.close();
    }
}

//如果傳入參數的值為null或者undefined，則轉化為空串
function checkUndefined(str){
	if(str==undefined||str==null){
		str=""	
	}	
	return str;
}