<!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()%> </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> </div> </td> <td><%=screen.getTagOrder()%></td> <td width="20%"> <div align="right"><script language="javascript">swapLang('Search By');</script> </div> </td> <td><%=screen.getTagSearchBy()%></td> </tr> <tr> <td> <div align="right"><script language="javascript">swapLang('Condition');</script> </div> </td> <td><%=screen.getTagConSearch()%></td> <td> <div align="right"><script language="javascript">swapLang('Key Value');</script> </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"> <script language="javascript">swapLang('Found Data');</script> <%=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> <a href="javascript:setDeselectAll();"><img src="../IMAGES/BUTTON/DESELECTALL.gif" border="0" width="73" height="23"></a> <a href="javascript:addParen();"><img src="../IMAGES/BUTTON/ADD.gif" width="73" height="23" border="0"></a> <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>