<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*"%>
<jsp:useBean id="TRA061HELP" class="com.csc.library.system.Task" scope="page" />
<%
TRA061HELP.setChannel(request, response);
HelpEntry screen = (HelpEntry) TRA061HELP.process("HelpEntry", request.getParameter("__helpName"));
screen.process();
%>
<html>
	<head>
		<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></title>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
		<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"/>
		<script language="JavaScript" src="../JS/SCREEN.js"></script>
		<script type='text/javascript' src='../JS/jquery-1.11.3.min.js'></script>
		<script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
		<script language="JavaScript" type="text/JavaScript">

		function back(unit){
			window.close();
		}

		function backPage(data){
			window.close();
		}

		// Overwrite Function
		function backPage_Return(valueList){
			var tmp = new Array(50);
			var tmp1 = new Array(50);
			var inputName="";
			var inputValue="";
			with(document.cscform){

				with(window.opener.document.cscform){
					tmp=valueList.split(",");
					for (var i=0; i < tmp.length; i++) {
						tmp1=tmp[i].split("#");
						for (var j=0; j < tmp1.length; j++) {
							inputName=tmp1[j++];
							inputValue=tmp1[j];
							for(var z=0;z<elements.length;z++){
								if(elements[z].name == inputName){
									if (__oldvalue.value==""){
										elements[z].value = inputValue;
									}else elements[z].value = __oldvalue.value+","+inputValue;
								}
							}
						}
					}
				}
				window.close();
			}

			with(window.opener){
				if(postReturn != "undefined"){
					postReturn();
				}
			}
		}

		function addParen(){
			var tmp = new Array();
			var tmp1 = new Array();
			var inputName="";
			var inputValue="";
			var helpReturn = document.cscform.__helpReturn.value;
			var helpTarget = helpReturn.split(":")[0];
			var rule_filter = document.cscform.__rule_filter.value;
			var rule_operator = document.cscform.__rule_operator.value;
			var $builder = window.opener.$('#builder');
			var systemdata = "$systemdata";
			var tmpsql = "";

			if((typeof window.opener.document.cscform != "undefined") &&(typeof window.opener.document.cscform.__sysisedit != "undefined")) {
				with(window.opener.document.cscform){
					__sysisedit.value="true";
				}
			} else {
				if((typeof window.opener.parent.leftFrame)!="undefined") {
					with(window.opener.parent.leftFrame.document.cscform){
						__sysisedit.value="true";
					}
				}
			}

			var $inputtarget = $builder.find('input[name="'+helpTarget+'"]');
			var and_or = $inputtarget.closest('.rules-group-container').find('.active [name$=_cond]').val();
			$inputtarget.val(systemdata).change();

			window.opener.$('#builder select[name$=_filter]').each(function(index){
				if( $(this).val() === "-1" || ($(this).val() !== "-1" && $(this).closest('.rule-container').find('.rule-value-container input').val() === "") ){
					console.log($(this).closest('.rule-container').attr('id'));
					$(this).closest('.rule-container').find('button[data-delete="rule"]').click();
				}
			});

			window.opener.$('#builder .rules-group-container').each(function(){
				if($(this).find('li').length === 0){
					console.log($(this).attr('id'));
					$(this).find('button[data-delete="group"]').click();
				}
			});

			var mainsql = $builder.queryBuilder('getSQL',false, false).sql;
			$('.selectit').each(function(){
				if($(this).prop('checked')){
					var conditionvalue = $(this).val().split("#")[1];
					tmpsql = chkSQL(tmpsql,and_or) + getSQL(rule_filter,rule_operator,conditionvalue);
				}
			});
			mainsql = mainsql.replace(getSQL(rule_filter,rule_operator,systemdata), tmpsql);

			window.opener.$('#condition').val( mainsql );
			window.opener.refresh();

			with(window.opener){
				if(postReturn != "undefined"){
					postReturn();
				}
			}
			var chk = "<%=request.getParameter("__helpReturn")%>";
			if(chk!= "" && chk.indexOf("chk_") > -1){
				chk = chk.substr(0,6);
				window.opener.document.getElementById(chk).checked = true;
			}
			window.close();
		}

		function chkSQL(sql,and_or){
			if(sql !== ""){
				sql += " " + and_or + " ";
			}
			return sql;
		}

		function getSQL(rule_filter,rule_operator,conditionvalue){
			var sql = rule_filter + " ";
			if(rule_operator === "equal"){
				sql += "= '?'";
			} else if(rule_operator === "not_equal"){
				sql += "!= '?'";
			} else if(rule_operator === "less"){
				sql += "< '?'";
			} else if(rule_operator === "less_or_equal"){
				sql += "<= '?'";
			} else if(rule_operator === "greater"){
				sql += "> '?'";
			} else if(rule_operator === "greater_or_equal"){
				sql += ">= '?'";
			} else if(rule_operator === "contains"){
				sql += "LIKE('%?%')";
			}
			return sql.replace('?',conditionvalue);
		}

		function setSelectAll(){
			with(document.forms[0]){
				if((typeof _selectit.length)!="undefined"){
					for(i=0;i<_selectit.length;i++){
						_selectit[i].checked = true;
					}
				}else{
					_selectit.checked = true;
				}
			}
		}

		function setDeselectAll(){
			with(document.forms[0]){
				if((typeof _selectit.length)!="undefined"){
					for(i=0;i<_selectit.length;i++){
						_selectit[i].checked = false;
					}
				}else{
					_selectit.checked = false;
				}
			}
		}

		function setAction(){
			window.close();
		}
		//-->
		</script>
	</head>
	<%
	String helpReturn="";
	if(request.getParameter("__helpReturn")!=null){
		helpReturn=request.getParameter("__helpReturn");
	}
	String fieldSearch="";
	if(request.getParameter("__fieldSearch")!=null){
		fieldSearch=request.getParameter("__fieldSearch");
	}
	%>
	<body leftmargin="0" topmargin="0">
		<form name="cscform" method="post" action="TRA061HELP.jsp">


			<!----------BEGIN CSC INITIAL ZONE ------------------------>

			<%=screen.InitialVariable()%>

			<!----------END CSC INITIAL ZONE -------------------------->

			<input type="hidden" name="__cmd" value=""/>
			<input type="hidden" name="__help" value=""/>
			<input type="hidden" name="__goPage" value=""/>
			<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/>
			<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"/>
			<input type="hidden" name="__helpReturn" value="<%=helpReturn%>"/>
			<input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>"/>
			<input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"/>
			<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"/>
			<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"/>
			<input type="hidden" name="__oldvalue" value="<%=request.getParameter("__oldValue")%>"/>
			<input type="hidden" name="__selectitmode" value="<%=request.getParameter("__selectitmode")%>"/>
			<input type="hidden" name="__rule_filter" value="<%=request.getParameter("__rule_filter")%>"/>
			<input type="hidden" name="__rule_operator" value="<%=request.getParameter("__rule_operator")%>"/>

			<br><table height="" align="center" cellpadding="0" cellspacing="0" class="large">
				<tr bgcolor="#3366CC">
					<td  height="20" class="header"><%=screen.getInquiry().getCurrentDbRecord().getDescription()%>&nbsp;</td>
				</tr>
				<tr bgcolor="#3366CC">
					<td>
						<table class="maxsize" border="1" cellspacing="1" cellpadding="1">
							<tr>
								<td>
									<table class="maxsize" align="center" cellpadding="0" cellspacing="0">
										<tr>
											<td colspan="4"  class="blankspace" ></td>
										</tr>
										<tr>
											<td width="15%">
												<div align="right"><script language="javascript">swapLang('Order By');</script>&nbsp; </div>
											</td>
											<td><%=screen.getTagOrder()%></td>
											<td width="20%">
												<div align="right"><script language="javascript">swapLang('Search By');</script>&nbsp;</div>
											</td>
											<td><%=screen.getTagSearchBy()%></td>
										</tr>
										<tr>
											<td>
												<div align="right"><script language="javascript">swapLang('Condition');</script>&nbsp; </div>
											</td>
											<td><%=screen.getTagConSearch()%></td>
											<td>
												<div align="right"><script language="javascript">swapLang('Key Value');</script>&nbsp;</div>
											</td>
											<td><%=screen.getTagValueSearch()%> <a href="javascript:search();"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" width="20" height="20" border="0" align="middle"></a></td>
										</tr>
										<tr>
											<td colspan="4"  class="blankspace" ></td>
										</tr>
										<tr>
											<td colspan="2">&nbsp;&nbsp;&nbsp;<script language="javascript">swapLang('Found Data');</script>&nbsp;&nbsp;<%=screen.getRecCount()%></td>
											<td colspan="2"><div align="right"><%=screen.getPageTag()%></div></td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
					</td>
				</tr>
			</table><br>
			<table height="" align="center" cellpadding="0" cellspacing="0" class="large">
				<tr>
					<td class="normal">
						<div align="center"><%=request.getParameter("__selectitmode").equalsIgnoreCase("TRUE") ? screen.printSelectTableHTML() : screen.printTableHTML()%></div>
					</td>
				</tr>
				<%
				if(request.getParameter("__selectitmode").equalsIgnoreCase("TRUE")){
					%>
					<tr>
						<td>
							<div align="center">
								<a href="javascript:setSelectAll();"><img src="../IMAGES/BUTTON/SELECTALL.gif" border="0" width="73" height="23"></a>
								&nbsp;<a href="javascript:setDeselectAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" width="73" height="23"></a>
								&nbsp; <a href="javascript:addParen();"><img src="../IMAGES/BUTTON/ADD.gif" width="73" height="23"  border="0"></a>
								&nbsp; <a href="javascript:setAction();"><img src="../IMAGES/BUTTON/CANCEL.gif" width="73" height="23" border="0"></a>
							</div>
						</td>
					</tr>
					<%
				}
				%>
			</table>
			<div align="center"></div>
			<!--script language="javascript">passValue();</script-->
		</form>
	</body>
</html>