<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@ page import="com.csc.library.entry.*" %> <%@ page import="com.csc.library.utilities.*" %> <%@ page import="com.csc.library.session.*" %> <%@ page import="java.text.SimpleDateFormat" %> <%@ page import="java.util.Locale" %> <%@ page import="java.util.Date" %> <%@ page import="java.util.GregorianCalendar" %> <%@ page import="java.text.DecimalFormat" %> <jsp:useBean id="ASR001_STD" scope="page" class="com.csc.library.system.Task" /> <html ng-app="myHR"> <% ASR001_STD.setChannel(request ,response); ReportEntry screen=(ReportEntry)ASR001_STD.process("ReportEntry",request.getParameter("__screen")); UProfile uf=screen.getUProfile(); screen.process(); ThaiUtilities th=new ThaiUtilities(); CheckNull chk = new CheckNull(); CscCalendar calendar = new CscCalendar(); DecimalFormat dfdate = new DecimalFormat("00"); String filter_date= calendar.getEngYYYY()+"-"+dfdate.format(calendar.getMonth()); SimpleDateFormat df = new SimpleDateFormat("hh:mm a", Locale.ENGLISH); GregorianCalendar gc= new GregorianCalendar(); String cmd = chk.chkNullString(request.getParameter("__cmd")); String screenname = chk.chkNullString(request.getParameter("__screen")); String conf = chk.chkNullString(request.getParameter("__confirm")); String conditionid = ""; String conditiondesc =""; String condition=""; String orderby=""; String groupby=""; String pagebreak=""; String language=""; String template=""; String defaultreport=""; String defaultcon="0"; String norelationreport="0"; if(cmd.equals("search") || cmd.equals("saveconstd")){ conditionid=chk.chkNullString(request.getParameter("__conditionid")); DbInquiry coninq = new InitialInquiry(screen.getUProfile()).getDbInquiry("lreport_condition"); coninq.setColumn("*"); coninq.setFilter("conditionid = '"+conditionid+"' and screen_name='"+screenname+"' and userreport='"+screen.getUProfile().get("employeeid")+"'"); coninq.refresh(); if(coninq.next()){ condition=coninq.getString("condition_value"); orderby=coninq.getString("orderby_value"); groupby=coninq.getString("groupby_value"); pagebreak=chk.chkNullString(coninq.getString("pagebreak"),"0"); defaultreport=chk.chkNullString(coninq.getString("defaultreport"),"0"); norelationreport=chk.chkNullString(coninq.getString("norelationreport"),"0"); language=coninq.getString("report_language"); template=coninq.getString("template"); } coninq.closeConnection(); }else{ DbInquiry coninq = new InitialInquiry(screen.getUProfile()).getDbInquiry("lreport_condition"); coninq.setColumn("*"); coninq.setFilter("screen_name='"+screenname+"' and userreport='"+screen.getUProfile().get("employeeid")+"' and defaultreport='1'"); coninq.refresh(); if(coninq.next()){ conditionid=coninq.getString("conditionid"); conditiondesc=coninq.getString("condition_desc"); condition=coninq.getString("condition_value"); orderby=coninq.getString("orderby_value"); groupby=coninq.getString("groupby_value"); pagebreak=chk.chkNullString(coninq.getString("pagebreak"),"0"); defaultreport=chk.chkNullString(coninq.getString("defaultreport"),"0"); norelationreport=chk.chkNullString(coninq.getString("norelationreport"),"0"); language=coninq.getString("report_language"); template=coninq.getString("template"); defaultcon="1"; } coninq.closeConnection(); } DbInquiry conbu = new InitialInquiry(screen.getUProfile()).getDbInquiry("config_gohelp"); conbu.setColumn("last_bu"); conbu.refresh(); conbu.next(); %> <head> <title>Report Condition</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <link rel="stylesheet" href="JS/QueryBuilder/dist/css/query-builder.default.min.css"/> <link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap.min.css"/> <link rel="stylesheet" href="JS/QueryBuilder/bootstrap-3.3.5/css/bootstrap-theme.min.css"/> <link rel="stylesheet" href="JS/QueryBuilder/dist/css/custom.css"/> <link rel="stylesheet" href="JS/jquery-ui-1.11.4.custom/jquery-ui.css"/> <style type="text/css"> .no-close .ui-dialog-titlebar-close { display: none; } .ui-widget-header{ background: #3173AD; color: #FFFFFF; } .padding0{ padding: 1px; } .btn-disable{ -moz-filter: grayscale(99%); -webkit-filter: grayscale(99%); filter: gray; filter: grayscale(99%); } </style> <script type='text/javascript' src='JS/SCREEN.js'></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script src="JS/VIEWCALENDAR.js"></script> <script src="JS/ANGULAR/angular.js"></script> <script type='text/JavaScript' SRC='JS/ANGULAR/SCREEN_ANGULAR.js'></script> </head> <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload=""> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="ASR001_STD.jsp"> <input style="display:none" type="text" name="fakeusernameremembered"/> <input style="display:none" type="password" name="fakepasswordremembered"/> <input type="hidden" name="__groupText"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%-- <%//=screen.InitialVariable()%> --%> <!----------END CSC INITIAL ZONE --------------------------> <br/> <table width="80%" align="center"> <tr> <td> <div align="center" class="panel panel-primary"> <div class="panel-heading"> <h3 class="panel-title" align="right">ASR001, <%=screen.getTagReportHeaderValue()%> </h3> </div> <table width="100%" bgcolor="red"> <tr> <td colspan="6"> </td> </tr> <tr> <td colspan="6" class="rowtable1"> <span swlang code="SW012471">Condition id</span> * <input type="text" id="__conditionid" name="__conditionid" size="8" maxlength="8" value="<%=chk.chkNullString(request.getParameter("__conditionid"),conditionid)%>"> <a href="javascript:goHelp('LREPORT_CONDITIONHELP','__conditionid')" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image6" width="20" height="20" border="0" align="absmiddle"></a> <input type="text" id="__conditiondesc" name="__conditiondesc" size="20" maxlength="20" value="<%=chk.chkNullString(request.getParameter("__conditiondesc"),conditiondesc)%>"> <input type="checkbox" id="__default" name="__default" value="1" > <span swlang code="SW012472">default</span> <button type="button" class="btn btn-sm btn-primary" onclick="goSavecon();"swlang code="SW000117">Save</button> <button type="button" class="btn btn-sm btn-danger" onclick="goDelcon();"swlang code="SW000123">Delete</button> <button type="button" class="btn btn-sm btn-success" onclick="goClearcon();"swlang code="SW013047">Clear</button> <span swlang code="SW012473">Page Break</span> <input type="checkbox" id="__pagebreak" name="__pagebreak" value="1"></td> </tr> <tr> <td colspan="6"> </td> </tr> <tr> <td class="rowtable1"> <span swlang code="SW000004">Order By</span></td> <td class="rowtable1"> <%=screen.getTagOrderBySTD()%></td> <td class="rowtable1" colspan="3"> <input type="text" disabled size="40" name="__orderText" id="__orderText"></td> <td> <font size="2" face="microsoft Sans Serif"> [ <a href="#" onClick="javascript:reduorder();" swlang code='SW000123'>Delete</a> ] [ <a href="#" onClick="javascript:dellOrderBy();" swlang code='SW000124'>Delete All</a> ] </font> </td> </tr> <tr> <td class="rowtable1"> <span swlang code="SW000122">Group By</span></td> <td class="rowtable1"> <%=screen.getTagGroupBySTD()%></td> <td class="rowtable1" colspan="4"> </td> </tr> <tr> <td class="rowtable1"> <span swlang code="SW000126">Language</span></td> <td class="rowtable1"> <%=screen.getTagLanguageSTD()%></td> <td class="rowtable1"> <span swlang code="SW000127">Template</span></td> <td class="rowtable1"> <%=screen.getTagTemplate()%></td> <td class="rowtable1"> </td> <td> <font size="2" face="microsoft Sans Serif"> <input type="checkbox" id="chkNoRelation" name="__chknorelation" value="NORELATION"> <span swlang code="SW013249">NO RELATION</span> </font> </td> </tr> <tr> <td colspan="5"> <div id="builder"></div></td> <td valign="center" align="center"> <br/> <div class="btn-group-vertical" role="group" aria-label="..."> <button id="option" type="button" class="btn btn-sm btn-success" onclick="goOption();"swlang code="SW011314">Option</button> <button id="print" type="button" class="btn btn-sm btn-primary" onclick="goPreview();"swlang code="SW005455">Print</button> <button type="button" class="btn btn-sm btn-info" onclick="goSubmit();"swlang code="SW013178">Export</button> <%if(screen.getAddCondition().equals("true")){%> <button type="button" class="btn btn-sm btn-warning" onclick="GoCondition();"> Condition </button> <%}%> </div> </td> </tr> <tr> <td colspan="5"> <textarea class="form-control" id="__condition" name="__condition" rows="10"></textarea></td> <td> </td> </tr> <tr> <td colspan="6"> </td> </tr> </table> </div> </td> </tr> </table> <% String table=screen.getMainTable(); //out.print(screen.getFieldTable(table)); %> <input type="hidden" name="__resultSet" value=""/> <input type="hidden" name="__calendar"/> <input type="hidden" name="mem" value=""/> <INPUT TYPE="hidden" name="__reportname" VALUE="<%=screen.getEngHeaderValue()%>"/> <INPUT TYPE="hidden" name="__screen" id="__screen" VALUE="<%=request.getParameter("__screen")%>"/> <input type="hidden" name="__cmd" ID="__cmd" value="<%=chk.chkNullString(cmd)%>"/> <input type="hidden" name="__data" value=""/> <input type="hidden" name="__filtercon" value=""/> <input type="hidden" name="helpParam" value=""/> <input type="hidden" name="__fixCon" value=""/> <input type="hidden" name="helpName" value="<%=screen.getMainHelp()%>"/> <input type="hidden" name="mainHelp" value="<%=screen.getMainHelp()%>"/> <input type="hidden" name="__thaiHeader" value="<%=screen.getThaiHeaderValue()%>"/> <input type="hidden" name="__engHeader" value="<%=screen.getEngHeaderValue()%>"/> <input type="hidden" name="__startPage" value="1"/> <input type="hidden" name="__classname" value="ReportExport"/> <input type="hidden" name="__reportstd" value="true"/> <input type="hidden" name="__confirm" id="__confirm" value=""/> <input type="hidden" name="__lang" id="__lang" value="<%=screen.getUProfile().get("lang")%>"/> <%=screen.getTagComponentHidden()%> <%=screen.getTagFixFilterHiddenSTD()%> <%=screen.getTagChildChkHidden()%> <input type="hidden" name="com_tname" value="<%=screen.getUProfile().get("com_tname")%>"/> <input type="hidden" name="com_ename" value="<%=screen.getUProfile().get("com_ename")%>"/> <INPUT TYPE="hidden" NAME="company" VALUE="<%=screen.getUProfile().get("companyname")%>"/> <INPUT TYPE="hidden" NAME="__COMPANY" VALUE="<%=screen.getUProfile().get("companyname")%>"/> <input type="hidden" name="__COMPANY_THA" value="<%=screen.getUProfile().get("com_tname")%>"/> <input type="hidden" name="__COMPANY_ENG" value="<%=screen.getUProfile().get("com_ename")%>"/> <INPUT TYPE="hidden" NAME="__mmxml" VALUE="<%=request.getParameter("__mmxml")%>"/> <INPUT TYPE="hidden" NAME="__expxml" VALUE="<%=request.getParameter("__expxml")%>"/> <input type="hidden" name="__export_type" value="EXPORT_PDF"/> <input type="hidden" name="__file_type" value="pdf"/> <input type="hidden" name="__pageprinting" value="PAGEPRINTINGSTD.jsp"/> <input type="hidden" name="__reportHeader" id="__reportHeader" value="<%=screen.getTagReportHeaderValue()%>"/> <input type="hidden" name="fieldtable" id="fieldtable" value="<%=screen.getFieldTableSTD(table)%>"/> <input type="hidden" name="condition" id="condition" value="<%=chk.chkNullString(condition)%>"/> <input type="hidden" name="orderby2" id="orderby2" value="<%=chk.chkNullString(orderby)%>"/> <input type="hidden" name="groupby2" id="groupby2" value="<%=chk.chkNullString(groupby)%>"/> <input type="hidden" name="pagebreak2" id="pagebreak2" value="<%=pagebreak%>"/> <input type="hidden" name="language2" id="language2" value="<%=chk.chkNullString(language)%>"/> <input type="hidden" name="template2" id="template2" value="<%=chk.chkNullString(template)%>"/> <input type="hidden" name="defaultreport" id="defaultreport" value="<%=defaultreport%>"/> <input type="hidden" name="norelationreport" id="norelationreport" value="<%=norelationreport%>"/> <input type="hidden" name="searchstatus" id="searchstatus" value="0"/> <input type="hidden" name="inputname" id="inputname" value="0"/> <input type="hidden" name="defaultcon" id="defaultcon" value="<%=defaultcon%>"/> <input type="hidden" name="user" id="user" value="<%=chk.chkNullString(screen.getUProfile().get("employeeid"))%>"/> <input type="hidden" name="__module" id="__module" value=""/> <input type="hidden" name="__ACTORID" value="<%=uf.get("actorid")%>"/> <input type="hidden" name="__ACTORNAME" value="<%=uf.get("fullname")%>"/> <input type="hidden" name="__ACTORNAME_THA" value="<%=uf.get("tfullname")%>"/> <input type="hidden" name="__ACTORNAME_ENG" value="<%=uf.get("efullname")%>"/> <input type="hidden" name="__datethai" value="<%="วัน"+calendar.getLongThiDOW()+"ที่ "+calendar.getDate()+ " " + calendar.getThaiLongMonth() + " พ.ศ. "+ calendar.getThaiYYYY() + " " +calendar.getHHMM() + " น."%>"/> <input type="hidden" name="__dateeng" value="<%=calendar.getEngFull()+ " " + df.format((Date)gc.getTime())%>"/> <input type="hidden" name="__languagereport" value="<%=screen.getUProfile().get("lang")%>"/> <input type="hidden" name="__dateformat" value="YYYY-MM-DD"/> <input type="hidden" name="__groupbydesc" id="__groupbydesc" value=""/> <input type="hidden" name="__orderby" id="__orderby" value="0"/> <input type="hidden" name="__extraorderby" id="__extraorderby" value=""/> <input type="hidden" name="__norelation" id="__norelation" value=""/> <input type="hidden" name="__groupby" id="__groupby" value="0"/> <input type="hidden" name="OptionRequire" id="OptionRequire" value="<%=screen.getOptionRequireSTD()%>"/> <input type="hidden" name="__pdfpassword" id="__pdfpassword" value="false"/> <input type="hidden" name="__passwordtext" id="__passwordtext" value=""/> <input type="hidden" name="__addcondition" id="__addcondition" value="<%=screen.getAddCondition()%>"/> <input type="hidden" name="__addconditionfilter" id="__addconditionfilter" value="status in ('A','V') or employeeid in (select employeeid from memployee where status='Y' and resigndate like '%<%=filter_date%>%')"/> <input type="hidden" name="__lastbu" value="<%=conbu.getString("last_bu")%>"/> <%=screen.getConditionHidden(10)%> <% String setlang = screen.getUProfile().get("lang"); String fieldswaplang = ""; if(screen.getUProfile().get("lang").equalsIgnoreCase("tha")){ fieldswaplang = "thai"; }else{ fieldswaplang = "eng"; } DbInquiry swaplang = new InitialInquiry(screen.getUProfile()).getDbInquiry("swaplang_detail"); swaplang.setColumn("codeid,thai,eng"); swaplang.setFilter("codeid in ('BU1','BU2','BU3','BU4','BU5')"); swaplang.refresh(); while(swaplang.next()) { %> <input type="hidden" name="<%="__"+swaplang.getString("codeid")%>" value="<%=swaplang.getString(fieldswaplang)%>"> <input type="hidden" name="<%="__"+swaplang.getString("codeid")+"_THA"%>" value="<%=swaplang.getString("thai")%>"> <input type="hidden" name="<%="__"+swaplang.getString("codeid")+"_ENG"%>" value="<%=swaplang.getString("eng")%>"> <% } conbu.closeConnection(); %> <div id="dialog" style="display: none;"> <br/> <input type="password" id="inputpassword" name="inputpassword" size="46" maxlength="40"/> <br/> </div> </form> <script type='text/javascript' src='JS/jquery-1.11.3.min.js'></script> <script type='text/javascript' src="JS/jquery-ui-1.11.4.custom/jquery-ui.js"></script> <script type='text/javascript' src='JS/QueryBuilder/bootstrap-3.3.5/js/bootstrap.min.js'></script> <script type='text/javascript' src='JS/QueryBuilder/dist/js/query-builder.standalone-mod.js'></script> <script type='text/javascript' src='JS/QueryBuilder/dist/js/sql-parser.js'></script> <script type='text/javascript' src='JS/QueryBuilder/dist/js/moment.js'></script> <script type='text/javascript' src='JS/VIEWCALENDAR.js'></script> <script type='text/javascript' src='/hr/dwr/engine.js'></script> <script type='text/javascript' src='/hr/dwr/util.js'></script> <script type="text/javascript" src="/hr/dwr/interface/GetPasswordFromMuser.js"></script> <script language="JavaScript" type="text/JavaScript"> var newpageIndex=1; var groupLength=0; var orderLength=0; var orderArray = new Array(50); var groupArray = new Array(50); function goHelp(helpName,inputName,linkhelp) { var helpReturn; var fixcon; var screen=document.getElementById("__screen").value; var user=document.getElementById("user").value; if (inputName=="__conditionid" ) { helpReturn="__conditionid:conditionid,__conditiondesc:condition_desc"; fixcon="screen_name='"+screen+"' and userreport='"+user+"'"; document.getElementById("searchstatus").value="0"; }else if( inputName.indexOf("builder_rule_") > -1 ){ helpReturn=inputName+":"+linkhelp; document.getElementById("searchstatus").value="1"; document.getElementById("inputname").value=inputName; } linkHelp_Return(helpName,helpReturn,fixcon); } function sysHelp(input,data) { with(document.cscform){ var param="SYSHELP_STD.jsp?__input="+input+"&__helpName="+data; window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function postReturn(){ with(document.cscform){ if(searchstatus.value=="0"){ __cmd.value="search"; target = ""; action=""; submit(); }else{ $.setcondition('1'); } } } function postCalendarSTD(data){ with(document.cscform){ document.getElementById("inputname").value=data; $.setcondition('1'); } } function goSubmit(){ with(document.cscform){ var orequire = OptionRequire.value; var pass = __pdfpassword.value; if(orequire!='true'){ if(pass!='true'){ showexport(); }else{ $.showdialog("export"); } }else{ alert(MyCode[224]); } } } function showexport(){ with(document.cscform){ action = "ASR003_STD.jsp"; window.open("","save","left=150,top=150,width=700,height=200,toolbar=no,status=yes,scrollbars=yes"); target="save"; submit(); } } function goSavecon(){ with(document.cscform){ var conditionid=__conditionid.value; if(!conditionid=="" || !conditionid==null){ var bCon=confirm(MyCode[1]); if (bCon==true){ __cmd.value="saveconstd"; action=""; target = ""; submit(); } }else{ alert(MyCode[0]); } } } function goDelcon(){ with(document.cscform){ var bCon=confirm(MyCode[4]); if (bCon==true){ __cmd.value="delconstd"; action=""; target = ""; submit(); } } } function goClearcon(){ with(document.cscform){ var lang = __lang.value; __conditionid.value=""; __conditiondesc.value=""; __default.checked=false; __chknorelation.checked=false; __pagebreak.checked=false; __orderbystd.selectedIndex=0; __groupbystd.selectedIndex=0; __template.selectedIndex=0; __language.value=lang.toUpperCase(); $.reset(); } } function goPreview(){ with(document.cscform){ var orequire = OptionRequire.value; var pass = __pdfpassword.value; if(orequire!='true'){ bCon=confirm(MyCode[10]); if (bCon==true) { if(pass!='true'){ showpreview(); }else{ $.showdialog("print"); } } }else{ alert(MyCode[224]); } } } function checkpassword(type){ with(document.cscform){ var password = __passwordtext.value; if (password != null && password!="") { if(type=="print"){ GetPasswordFromMuser.ComparePassword(new Array(password), callpass); }else{ GetPasswordFromMuser.ComparePassword(new Array(password), callpassexport); } } } } function showpreview(){ with(document.cscform){ var a="/hr/servlet/reportservletstd/?"; action = a; target = "_blank"; method="post"; submit(); } } function callpass(data){ with(document.cscform){ if(data==true){ showpreview(); }else{ alert(MyCode[226]); $.showdialog("print"); } } } function callpassexport(data){ with(document.cscform){ if(data==true){ showexport(); }else{ alert(MyCode[226]); $.showdialog("export"); } } } function goOption(){ with(document.cscform){ OptionRequire.value="false"; window.open("<%=screen.getComponentPageSTD("ASR002")%>.jsp?__screen="+__screen.value); } } function setcon(input,e){ with(document.cscform){ if (e.keyCode == 13) { inputname.value=input.name; $.setcondition(1); } } } function setNewPage(value,text,first){ //alert(first); with(document.cscform){ if(first==true){ newpageIndex=1; __onnewpage.options.length=1; } __onnewpage.options[newpageIndex++]=new Option(text,value,false); } } function setBU(){ var strbu = ['BU1','BU2','BU3','BU4','BU5','ACTORNAME','COMPANY']; var lang = $('#__language').val(); for (i=0; i<strbu.length; i++){ var name = "__"+strbu[i]; $('input[name='+name+']').val( $('input[name='+(name+"_"+lang)+']').val() ); } } function changeHeader(){ setBU(); } function GoCondition(){ with(document.cscform){ window.open("ASR002_STD.jsp?__screen="+__screen.value); } } function reduorder(){ with(document.cscform){ if(orderLength>0){ orderArray[--orderLength]=" "; setOrderText(); __orderby.value = __orderText.value; if(__orderby.value == ""){ __orderby.value = "0"; } } } } function setOrderText(){ with(document.cscform){ b=""; for( i=0;i<orderLength;i++){ b=b+orderArray[i]; } __orderText.value=b; } } function insertOrderBy(){ var i=0; var isdup=false; with(document.cscform){ if(__orderbystd.value !=0){ for(i=0;i<=orderLength;i++){ //alert(__orderby.value+" "+ orderArray[i]); if((__orderbystd.value==orderArray[i])||(","+__orderbystd.value==orderArray[i])){ alert(__orderbystd.value+" "+ MyCode[11]); isdup=true; } } if(isdup==false){ if(orderLength != 0) orderArray[orderLength++]=","+__orderbystd.value; else orderArray[orderLength++]=__orderbystd.value; } setOrderText(); } __orderbystd.options[0].selected= true; } } function dellOrderBy(){ with(document.cscform){ for( i=0;i<orderLength;i++){ orderArray[i]=" "; } orderLength=0; setOrderText(); __orderby.value = __orderText.value; if(__orderby.value == ""){ __orderby.value = "0"; } } } function redugroup(){ with(document.cscform){ if(groupLength>0){ groupArray[--groupLength]=" "; setGroupText(); } } } function setGroupText(){ with(document.cscform){ b=""; for( i=0;i<groupLength;i++){ b=b+groupArray[i]; } __groupText.value=b; } } function dellGroupBy(){ with(document.cscform){ for( i=0;i<groupLength;i++){ groupArray[i]=" "; } groupLength=0; setGroupText(); //__onnewpage.options.length=1; //newpageIndex=1; } } </script> <script> var options = { filters: [] } $.reset = function(){ $('#builder').queryBuilder('reset'); $('#__condition').val(''); } $.setOption = function(){ var module=$("#__module").val(); var field=$("#fieldtable").val(); var data = field.split(","); for(var i=0;i<data.length;i++){ var field = data[i].split("@"); var fieldid = field[0].split(":"); var id = (field[5] === undefined) ? fieldid[0] : field[5] var exfilter = (field[6] === undefined) ? "" : field[6] var encrypt = (field[7] === undefined) ? "" : field[7] var dbtype = (field[8] === undefined) ? "" : field[8] if(field[4]==="date"){ options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype,validation:{format: 'yyyy-mm-dd'},module:module}) }else if(field[4]==="double"){ options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype}) }else{ options.filters.push({id: id,label: fieldid[0]+" : "+fieldid[1],type: field[4] , operators: ['equal', 'not_equal','less','less_or_equal','greater','greater_or_equal','contains','is_null', 'is_not_null'],exfilter:exfilter,encrypt:encrypt,dbtype:dbtype,help:field[1],linkhelp:field[2],validcode:field[3]}) } } var lang = $("#__lang").val(); if(lang=="tha"){ options.lang_code='th'; }else{ options.lang_code='en'; } } $.setSearch = function(){ var cmd = $('#__cmd').val(); var defaultcon = $('#defaultcon').val(); if((cmd=='search') || (cmd=='saveconstd') || (defaultcon=='1') || (cmd=='delconstd')){ if(cmd=='delconstd'){ __conditionid.value=""; __conditiondesc.value=""; } $('#__condition').val($('#condition').val()); $("#__orderbystd option[value='" + $('#orderby2').val() + "']").prop("selected",true); $("#__groupbystd option[value='" + $('#groupby2').val() + "']").prop("selected",true); $('#__orderby').val($('#orderby2').val()); $('#__groupby').val($('#groupby2').val()); if($('#pagebreak2').val()=="1"){ $('#__pagebreak').prop('checked', true); } if($('#defaultreport').val()=="1"){ $('#__default').prop('checked', true); } if($('#norelationreport').val()=="NORELATION"){ $('#chkNoRelation').prop('checked', true); } $("#__language option[value='" + $('#language2').val() + "']").prop("selected",true); $("#__template option[value='" + $('#template2').val() + "']").prop("selected",true); $('#builder').queryBuilder('setRulesFromSQL', $('#condition').val()); } } $.setcondition = function(data){ if(data=='1'){ var input = $('#inputname').val(); $('input[name="'+input+'"]').change(); } var sql=$('#builder').queryBuilder('getSQL',false, false).sql; $('#__condition').val(sql); } $.checkstatus=function(){ var cmd = $('#__cmd').val(); if(cmd=='saveconstd'){ alert(MyCode[18]); }else if(cmd=='delconstd'){ alert(MyCode[19]); } } $.setmodule=function (){ var path = window.parent.location.pathname; var module = path.split("/"); $('#__module').val(module[2]); } $.showdialog=function(type){ $( "#dialog" ).dialog({ dialogClass: "no-close", title: MyCode[225], width: 400, buttons: [ { text: "OK", click: function() { $("#__passwordtext").val($("#inputpassword").val()) checkpassword(type); $(this).dialog( "close" ); } },{ text: "CANCEL", click: function() { $(this).dialog( "close" ); } } ] }); } $(function(){ $.setmodule(); $.setOption(); $('#builder').queryBuilder(options); $.checkstatus(); $.setSearch(); $('#builder').on('afterDeleteRule.queryBuilder', function(e, rule, error, value) { $.setcondition('0'); }); $('#builder').on('afterDeleteGroup.queryBuilder', function(e, rule, error, value) { $.setcondition('0'); }); $('#builder').on('afterUpdateRuleOperator.queryBuilder', function(e, rule, error, value) { $.setcondition('0'); }); $('#builder').on('afterUpdateGroupCondition.queryBuilder', function(e, rule, error, value) { $.setcondition('0'); }); $('#__orderbystd').on('change', function() { $('#__orderby').val($('#__orderText').val()); //$('#__orderText').val($(this).val()); }); $('#__groupbystd').on('change', function() { $('#__groupby').val($(this).val()); $('#__extraorderby').val(""); //$('#__groupText').val($(this).val()); }); $('#chkNoRelation').on('change', function() { var value = ""; if($(this).prop('checked')){ value = $(this).val(); } $('#__norelation').val(value); }) }) $(document).ready(function(){ var linkpage = <%=screen.hasLinkPage()%> ; if(linkpage === false){ $("button[id=option]").addClass("btn-disable disabled"); $("button[id=option]").attr("onclick",""); } }); </script> </body> </html>