<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%> <%@page import="com.csc.library.utilities.CscTime, com.csc.library.database.SystemCode, java.util.*,com.csc.library.report.*"%> <%@page import="com.csc.library.session.*"%> <jsp:useBean id="TAU1211" class="com.csc.library.system.Task" scope="page" /> <% TAU1211.setChannel(request, response); HelpEntry screen = (HelpEntry) TAU1211.process("HelpEntry", "TAU1211"); screen.setMaxLine(20); screen.process(); //out.print("select * from "+screen.inq.getTableName()+" where "+screen.inq.getFilter()); ThaiUtilities thai=new ThaiUtilities(); ReportUDF rt=new ReportUDF(); CheckNull chk = new CheckNull(); /* * Error_Type * ลืมรูดเข้า = FORGOT-IN ---> 0 * ลืมรูดออก = FORGOT-OUT ---> 1 * สาย = LATE ---> 2 * โอทีก่อนเวลา = OT-BEFORE ---> 3 * โอทีหลังเวลา = OT-AFTER ---> 4 * ออกก่อนเวลา = OUT-ABSENT ---> 5 * เข้าช้า = IN-ABSENT ---> 6 * //รูดเข้าหลายครั้ง = IN-MORE ---> 7 NOT USE * //รูดออกหลายครั้ง = OUT-MORE ---> 8 NOT USE * //ทำงานก่อนเวลางาน WK-BEFORE ---> 9 NOT USE * //ทำงานหลังเวลางาน WK-AFTER ---> 10 NOT USE * รูดบัตรในวันหยุดงาน WK-HOLIDAY ---> 11 * โอทีเกินก่อนเวลา OT-OVER-BEFORE ---> 12 * โอทีเกินหลังเวลา OT-OVER-AFTER ---> 13 * โอทีขาดก่อนเวลา OT-LESS-BEFORE ---> 14 * โอทีขาดหลังเวลา OT-LESS-AFTER ---> 15 */ TreeMap hmErrorType = new TreeMap(); String lang = screen.getUProfile().get("lang"); String[][] sysCode = SystemCode.getContent("ERROR_TYPE"); for(int i=0;i<sysCode.length;i++){ String key = sysCode[i][0]; if (Integer.parseInt(key)>=7 && Integer.parseInt(key)<=10) { continue; } if (Integer.parseInt(key)<10) { key = "warn0"+key; } else { key = "warn"+key; } String value = sysCode[i][1]; if (((String)screen.getUProfile().get("lang")).equalsIgnoreCase("tha")) { value = value.substring(value.indexOf(",") + 1); } else { value = value.substring(0, value.indexOf(",")); } hmErrorType.put(key, value); } DbInquiry dbssec = new InitialInquiry(screen.getUProfile()).getDbInquiry("ssecurity"); dbssec.setColumn("*"); dbssec.setFilter("employeeid = '"+screen.getUProfile().get("employeeid")+"' AND isviewall ='1'"); dbssec.refresh(); String filter = "1=1"; String reportfilter = "1=1"; if (dbssec.recCount()>0){ dbssec.next(); if (dbssec.getString("isemp_position").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("positionstatus"),"emp_position",dbssec.getString("positionlist")); reportfilter +=chkMySecurity(dbssec.getString("positionstatus"),"emp_position",dbssec.getString("positionlist")); } if (dbssec.getString("isemp_group").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("empgroupstatus"),"emp_group",dbssec.getString("empgrouplist")); reportfilter +=chkMySecurity(dbssec.getString("empgroupstatus"),"emp_group",dbssec.getString("empgrouplist")); } if (dbssec.getString("isbu1").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("bu1status"),"bu1",dbssec.getString("bu1list")); reportfilter +=chkMySecurity(dbssec.getString("bu1status"),"bu1",dbssec.getString("bu1list")); } if (dbssec.getString("isbu2").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("bu2status"),"bu2",dbssec.getString("bu2list")); reportfilter +=chkMySecurity(dbssec.getString("bu2status"),"bu2",dbssec.getString("bu2list")); } if (dbssec.getString("isbu3").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("bu3status"),"bu3",dbssec.getString("bu3list")); reportfilter +=chkMySecurity(dbssec.getString("bu3status"),"bu3",dbssec.getString("bu3list")); } if (dbssec.getString("isbu4").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("bu4status"),"bu4",dbssec.getString("bu4list")); reportfilter +=chkMySecurity(dbssec.getString("bu4status"),"bu4",dbssec.getString("bu4list")); } if (dbssec.getString("isjob").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("jobstatus"),"job",dbssec.getString("joblist")); reportfilter +=chkMySecurity(dbssec.getString("jobstatus"),"job",dbssec.getString("joblist")); } if (dbssec.getString("isbranch").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("branchstatus"),"branch",dbssec.getString("branchlist")); reportfilter +=chkMySecurity(dbssec.getString("branchstatus"),"branch",dbssec.getString("branchlist")); } if (dbssec.getString("issalatype").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("salatypestatus"),"salatype",dbssec.getString("salatypelist")); reportfilter +=chkMySecurity(dbssec.getString("salatypestatus"),"salatype",dbssec.getString("salatypelist")); } if (dbssec.getString("ispl").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("plstatus"),"pl",dbssec.getString("pllist")); reportfilter +=chkMySecurity(dbssec.getString("plstatus"),"pl",dbssec.getString("pllist")); } if (dbssec.getString("isworkarea").equalsIgnoreCase("1")){ filter +=chkMySecurity(dbssec.getString("workareastatus"),"workarea",dbssec.getString("workarealist")); reportfilter +=chkMySecurity(dbssec.getString("workareastatus"),"workarea",dbssec.getString("workarealist")); } } //out.print("filter :: "+filter); %> <html ng-app="myHR"> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script type='text/javascript' src='../JS/SCREEN.js'></script> <script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script> <script type='text/javascript' src='../JS/DATEINPUT.js'></script> <script type='text/javascript' src='../JS/VIEWCALENDAR.js'></script> <script src="../JS/angular-1.3.15/angular.js"></script> <script type='text/JavaScript' SRC='../JS/ANGULAR/SCREEN_ANGULAR.js'></script> <script language="javascript">getTitleName();</script> <STYLE type=text/css> FONT.holiday { FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif"; font-size: 12px; color: #FF00FF; } FONT.absent { FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif"; font-size: 12px; color: #FF0000; } </style> <script language="JavaScript" type="text/JavaScript"> function pageDesc(empid, dateid,seq){ with(document.cscform) { var d=chkDateTime1(dateid); var filterCon = "employeeid='"+empid+"' and (dateid='"+d+"') and sequence='"+seq+"'"; //alert(filterCon); window.open("TAU1212.jsp?__cmd="+ "&__fixCon="+filterCon, "ShowWarning","left=150,top=100,width=550,height=300,toolbar=no,status=yes,scrollbars=yes,resizable=yes" ); } } function linkHelp_Return(help,input,filter){ with(document.cscform){ var nInput = input; if(input.indexOf(":")>0){ nInput=input.substring(0,input.indexOf(":")); } obj = eval("document.cscform."+nInput); if(obj.value==""){ var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"; }else{ var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"+"&__valueSearch="+obj.value; } window.open(param,"Help","left=150,top=150,width=650,height=450,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } function chkDateTime1(valueSearch){ var tmpval=""; with(document.cscform){ var valueSearch1=valueSearch.split("-"); if(valueSearch1.length==3){ if(valueSearch1[1].length==1){ valueSearch1[1]="0"+valueSearch1[1]; } if(valueSearch1[0].length==1){ valueSearch1[0]="0"+valueSearch1[0]; } valueSearch1[2]=parseInt(valueSearch1[2]); return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0]; } } } function goHelp(helpName,inputName,filter){ var helpReturn; var fixcon; if(inputName.indexOf("__emp") > -1){ helpReturn = inputName+":employeeid" } fixcon=""; linkHelp_Return(helpName,helpReturn,fixcon); } function goHelpBu(helpName,inputName,filter){ var helpReturn; var fixcon; if(inputName=="__bu1"){ helpReturn = inputName+":bu1id,"+inputName+"_desc:edesc"; }else if(inputName=="__bu2"){ helpReturn = inputName+":bu2id,"+inputName+"_desc:edesc"; }else if(inputName=="__bu3"){ helpReturn = inputName+":bu3id,"+inputName+"_desc:edesc"; }else if(inputName=="__bu4"){ helpReturn = inputName+":bu4id,"+inputName+"_desc:edesc"; }else if(inputName=="__bu5"){ helpReturn = inputName+":bu5id,"+inputName+"_desc:edesc"; } fixcon=""; linkHelp_Return(helpName,helpReturn,fixcon); } function setSubmit(){ var altEmp="Please Insert Employee 1 Less Employee 2"; with(document.cscform){ if(__language.value=="tha") altEmp="กรุณากรอกข้อมูลพนักงาน 1 น้อยกว่าพนักงาน 2"; if(__emp1.value <= __emp2.value){ setFilter(); } else alert(MyCode[101]); } } function chkAll(){ with (document.cscform){ for (i=0;i<elements.length;i++){ if (elements[i].name.indexOf("error_") > -1){ if(errorall.checked){ //alert(i); elements[i].checked=true; }else{ elements[i].checked=false; } } } } } function setFilter(){ with(document.cscform){ __cmd.value="search"; var temp = __fixCon.value; var ssecurity=__filter.value; var sqlEmp="1=1 "; var sqlDate=""; var sqlBu1=""; var sqlBu2=""; var sqlBu3=""; var sqlBu4=""; var sqlBu5=""; var sqlResigdate = " dateid between (select startdate from memployee m where m.employeeid=ttime_current1.employeeid) and (select endworkdate from memployee m where m.employeeid=ttime_current1.employeeid)"; if (__emp1.value.length>0 && __emp2.value.length>0) sqlEmp = " (employeeid between '"+__emp1.value+"' and '"+__emp2.value+"') "; else if (__emp1.value.length>0 && __emp2.value.length==0) sqlEmp = " employeeid='"+__emp1.value+"' "; else if (__emp2.value.length>0 && __emp1.value.length==0) sqlEmp = " employeeid='"+__emp2.value+"' "; if (__date1.value.length>0 && __date2.value.length>0) sqlDate = " (dateid between '"+chkDateTime1(__date1.value)+"' and '"+chkDateTime1(__date2.value)+"') "; else if (__date1.value.length>0 && __date2.value.length==0) sqlDate = " dateid='"+chkDateTime1(__date1.value)+"' "; else if (__date2.value.length>0 && __date1.value.length==0) sqlDate = " dateid='"+chkDateTime1(__date2.value)+"' "; if (__bu1.value.length>0) sqlBu1 = " bu1='"+__bu1.value+"' "; else __bu1_desc.value=""; if (__bu2.value.length>0) sqlBu2 = " bu2='"+__bu2.value+"' "; else __bu2_desc.value=""; if (__bu3.value.length>0) sqlBu3 = " bu3='"+__bu3.value+"' "; else __bu3_desc.value=""; if (__bu4.value.length>0) sqlBu4 = " bu4='"+__bu4.value+"' "; else __bu4_desc.value=""; if (__bu5.value.length>0) sqlBu5 = " bu5='"+__bu5.value+"' "; else __bu5_desc.value=""; var setFixcon = new Array(ssecurity,sqlEmp,sqlDate,sqlBu1,sqlBu2,sqlBu3,sqlBu4,sqlBu5,sqlResigdate); __fixCon.value = ""; for(i=0; i<setFixcon.length; i++){ if(setFixcon[i] != ""){ __fixCon.value += setFixcon[i] + " and "; } } __fixCon.value = __fixCon.value.substring(0,__fixCon.value.length-5); var dbType = "oracal"; //รับค่าชนิดดาต้าเบส เนื่องจากใช้ SQL (ไม่เท่ากับ) ไม่เหมือนกัน //กรองข้อผิดพลาดที่ต้องการ var etype = ""; var err = ""; for (j=0; j<elements.length; j++){ if (elements[j].name.indexOf("error_") > -1){ if (elements[j].checked){ // alert(elements[j].value); if (etype != ""){ etype +=" or "; } if(dbType=='oracal'){ //if(elements[j].value == "warn16"){ // etype += " ( EVENTGRP = 'j') "; //}else{ if(elements[j].value=="warn00"){ etype += "("+elements[j].value+" !='' and warn01 ='') "; }else if(elements[j].value=="warn01"){ etype += "("+elements[j].value+" !='' and warn00 ='') "; }else if(elements[j].value=="warn16"){ etype += "(warn00 !='' and warn01 !='') "; }else if(elements[j].value=="absent"){ etype += "eventgrp = 'J' "; }else{ etype += elements[j].value+" !='' "; } //} }else{ if(elements[j].value=="absent"){ etype += "eventgrp = 'J' "; }else{ etype += elements[j].value+"<>''"; } } err += elements[j].value+","; } } } // alert(etype); if (!etype==""){ __error.value = err; __fixCon.value += " and ("+etype+")"; } else { if(__language.value=="tha") { alert("กรุณาเลือกเงื่อนไขข้อผิดพลาดที่ต้องการอย่างน้อย 1 ประเภท"); } else alert("Please select error type less 1 type"); return false; } submit(); } } function goExportExcel(){ with(document.cscform){ var param = "TAU1211_Exp.jsp?__Filter="+__fixCon.value; //alert(param); window.open(param); } } function setCheck(obj){ with(document.cscform){ if(obj.value!="warn16"){ if(obj.checked){ if(!(error_16.checked && (obj.value=="warn00" || obj.value=="warn01"))){ __showList.value += ","+obj.value; } }else{ if(!(error_16.checked && (obj.value=="warn00" || obj.value=="warn01"))){ __showList.value = __showList.value.replace(","+obj.value,""); } } // if(error_16.checked){} }else{ if(obj.checked){ //__showList.value += ","+obj.value; if(__showList.value.indexOf(",warn00")==-1){ __showList.value += ",warn00"; } if(__showList.value.indexOf(",warn01")==-1){ __showList.value += ",warn01"; } }else{ if(!error_00.checked){ __showList.value = __showList.value.replace(",warn00",""); } if(!error_01.checked){ __showList.value = __showList.value.replace(",warn01",""); } } } setShow(); } } function setShow(){ with(document.cscform){ var showList = __showList.value.split(","); for(var i=1 ; i<=5 ; i++){ eval("warn_col0"+i).value = "warn99"; if(showList[i]!="" && showList[i]!=undefined){ eval("warn_col0"+i).value = showList[i]; } } } } </script> </head> <body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SEARCH.gif')"> <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div> <script language="javascript">initToolTips();</script> <form name="cscform" method="post" action="TAU1211.jsp" ng-controller="Swaplang as sw"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="TAU1211"> <input type="hidden" name="__cmd" value="search"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__calendar"> <input type="hidden" name="__employeeid" value=""> <input type="hidden" name="__dateid" value=""> <input type="hidden" name="__time0id" 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="<%=request.getParameter("__helpReturn")%>"> <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"> <input type="hidden" name="__filter" value="<%=filter%>"> <input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__error" value="<%=request.getParameter("__error")%>"> <% String emp1="",emp2="",bu1="",bu2="",bu3="",bu4="",bu5="",date1="",date2="",bu1_desc="",bu2_desc="",bu3_desc="",bu4_desc="",bu5_desc=""; if (request.getParameter("__date1")!=null) date1=request.getParameter("__date1"); if (request.getParameter("__date2")!=null) date2=request.getParameter("__date2"); if (request.getParameter("__emp1")!=null) emp1=request.getParameter("__emp1"); if (request.getParameter("__emp2")!=null) emp2=request.getParameter("__emp2"); if (request.getParameter("__bu1")!=null) bu1=request.getParameter("__bu1"); if (request.getParameter("__bu2")!=null) bu2=request.getParameter("__bu2"); if (request.getParameter("__bu3")!=null) bu3=request.getParameter("__bu3"); if (request.getParameter("__bu4")!=null) bu4=request.getParameter("__bu4"); if (request.getParameter("__bu5")!=null) bu5=request.getParameter("__bu5"); if (request.getParameter("__bu1_desc")!=null) bu1_desc=request.getParameter("__bu1_desc"); if (request.getParameter("__bu2_desc")!=null) bu2_desc=request.getParameter("__bu2_desc"); if (request.getParameter("__bu3_desc")!=null) bu3_desc=request.getParameter("__bu3_desc"); if (request.getParameter("__bu4_desc")!=null) bu4_desc=request.getParameter("__bu4_desc"); if (request.getParameter("__bu5_desc")!=null) bu5_desc=request.getParameter("__bu5_desc"); String warn_c01="", warn_c02="", warn_c03="", warn_c04="", warn_c05=""; if (request.getParameter("warn_col01")!=null) warn_c01=request.getParameter("warn_col01"); if (request.getParameter("warn_col02")!=null) warn_c02=request.getParameter("warn_col02"); if (request.getParameter("warn_col03")!=null) warn_c03=request.getParameter("warn_col03"); if (request.getParameter("warn_col04")!=null) warn_c04=request.getParameter("warn_col04"); if (request.getParameter("warn_col05")!=null) warn_c05=request.getParameter("warn_col05"); HashMap hm = new HashMap(); String type = ""; String error = ""; if (request.getParameter("__error")==null) { // error = "warn00,warn01,warn02,warn05,warn11"; error = "warn00,warn01,warn02,warn05"; } else error = chk.chkNullString(request.getParameter("__error")); StringTokenizer str = new StringTokenizer(error,","); while (str.hasMoreTokens()) { type = str.nextToken(); hm.put(type,type); } %> <input type="hidden" size="100" name="__showList" value="<%=chk.chkNullString(request.getParameter("__showList"),","+error)%>"> <br> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="largest"> <tr bgcolor="#3366CC"> <td height="20" class="header" colspan="4">TAU1211, <script language="javascript">swapLang("WorkingTime Warning");</script> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td align="right"><strong><%=screen.getLabel("employeeid")%> </strong></td> <td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__emp1','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" border="0" align="absmiddle"></a> - <input type="text" name="__emp2" size="15" value="<%=emp2%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__emp2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image3" border="0" align="absmiddle"></a></span> </td> </tr> <tr> <td align="right"><%=screen.getLabel("memployee","bu1")%> </td> <td colspan="3"><input type="text" name="__bu1" size="15" value="<%=bu1%>"> <a href="javascript:goHelpBu('MBU1HELP','__bu1','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a> <input name="__bu1_desc" type="text" value="<%=thai.ASCII2Unicode(bu1_desc)%>" size="40" readonly=""> <script language="javascript">swapLang('Column');</script> 1 <select name="warn_col01"> <option value="warn99">ไม่แสดงข้อมูล</option> <% Iterator it = hmErrorType.keySet().iterator(); while (it.hasNext()) { String key = (String) it.next(); String value = (String) hmErrorType.get(key); if (warn_c01.equals("") && key.equals("warn00")) { %> <option value="<%=key%>" selected><%=value%></option> <% } else { %> <option value="<%=key%>" <% if (warn_c01.equals(key)) out.println("selected");%>><%=value%></option> <% } } //end while %> </select> </td> </tr> <tr> <td align="right"><%=screen.getLabel("memployee","bu2")%> </td> <td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>"> <a href="javascript:goHelpBu('MBU2HELP','__bu2','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu2" border="0" align="absmiddle"></a> <input name="__bu2_desc" type="text" id="__bu2_desc" value="<%=thai.ASCII2Unicode(bu2_desc)%>" size="40" readonly=""> <script language="javascript">swapLang('Column');</script> 2 <select name="warn_col02"> <option value="warn99" selected>ไม่แสดงข้อมูล</option> <% it = hmErrorType.keySet().iterator(); while (it.hasNext()) { String key = (String) it.next(); String value = (String) hmErrorType.get(key); if (warn_c02.equals("") && key.equals("warn01")) { %> <option value="<%=key%>"><%=value%></option> <% } else { %> <option value="<%=key%>" <% if (warn_c02.equals(key)) out.println("selected");%>><%=value%></option> <% } } //end while %> </select> </td> </tr> <tr> <td align="right"><%=screen.getLabel("memployee","bu3")%> </td> <td colspan="3"><input type="text" name="__bu3" size="15" value="<%=bu3%>"> <a href="javascript:goHelpBu('MBU3HELP','__bu3','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu3" border="0" align="absmiddle"></a> <input name="__bu3_desc" type="text" value="<%=thai.ASCII2Unicode(bu3_desc)%>" size="40" readonly=""> <script language="javascript">swapLang('Column');</script> 3 <select name="warn_col03"> <option value="warn99" selected>ไม่แสดงข้อมูล</option> <% it = hmErrorType.keySet().iterator(); while (it.hasNext()) { String key = (String) it.next(); String value = (String) hmErrorType.get(key); if (warn_c03.equals("") && key.equals("warn02")) { %> <option value="<%=key%>"><%=value%></option> <% } else { %> <option value="<%=key%>" <% if (warn_c03.equals(key)) out.println("selected");%>><%=value%></option> <% } } //end while %> </select> </td> </tr> <tr> <td align="right"><%=screen.getLabel("memployee","bu4")%> </td> <td colspan="3"><input type="text" name="__bu4" size="15" value="<%=bu4%>"> <a href="javascript:goHelpBu('MBU4HELP','__bu4','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu4" border="0" align="absmiddle"></a> <input name="__bu4_desc" type="text" value="<%=thai.ASCII2Unicode(bu4_desc)%>" size="40" readonly=""> <script language="javascript">swapLang('Column');</script> 4 <select name="warn_col04"> <option value="warn99" selected>ไม่แสดงข้อมูล</option> <% it = hmErrorType.keySet().iterator(); while (it.hasNext()) { String key = (String) it.next(); String value = (String) hmErrorType.get(key); if (warn_c04.equals("") && key.equals("warn05")) { %> <option value="<%=key%>"><%=value%></option> <% } else { %> <option value="<%=key%>" <% if (warn_c04.equals(key)) out.println("selected");%>><%=value%></option> <% } } //end while %> </select> </td> </tr> <tr> <td align="right"><%=screen.getLabel("memployee","bu5")%> </td> <td colspan="3"><input type="text" name="__bu5" size="15" value="<%=bu5%>"> <a href="javascript:goHelpBu('MBU5HELP','__bu5','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5" border="0" align="absmiddle"></a> <input name="__bu5_desc" type="text" value="<%=thai.ASCII2Unicode(bu5_desc)%>" size="40" readonly=""> <script language="javascript">swapLang('Column');</script> 5 <select name="warn_col05"> <option value="warn99" selected><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ไม่แสดงข้อมูล":"No Select Data"%></option> <% it = hmErrorType.keySet().iterator(); while (it.hasNext()) { String key = (String) it.next(); String value = (String) hmErrorType.get(key); if (warn_c05.equals("") && key.equals("warn11")) { %> <option value="<%=key%>"><%=value%></option> <% } else { %> <option value="<%=key%>" <% if (warn_c05.equals(key)) out.println("selected");%>><%=value%></option> <% } } //end while %> </select> </td> </tr> <tr> <td align="right"><script language="javascript">swapLang('Period Date');</script> </td> <td colspan="3"><span class="columnobject1"> <input type="text" name="__date1" size="10" maxlength="10" value="<%=date1%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,__date2)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar1" border="0" align="absmiddle" onClick="viewCal('__date1')" alt="Calendar"></a> - <input type="text" name="__date2" size="10" maxlength="10" value="<%=date2%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(__date1,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar2" border="0" align="absmiddle" onClick="viewCal('__date2')" alt="Calendar"></a></span> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td align="right"> </td> <td colspan="3"> <table border="0" cellspacing="0" cellpadding="0" class="maxsize"> <tr> <td><label> <input name="error_00" type="checkbox" value="warn00" <% if (hm.containsKey("warn00")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"0")%> </label></td> <td><label> <input name="error_01" type="checkbox" value="warn01" <% if (hm.containsKey("warn01")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"1")%> </label></td> <td><label> <input name="error_16" type="checkbox" value="warn16" <% if (hm.containsKey("warn16")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"16")%> </label></td> <td><label> <input name="error_02" type="checkbox" value="warn02" <% if (hm.containsKey("warn02")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"2")%> </label></td> <td><label> <input name="error_03" type="checkbox" value="warn03" <% if (hm.containsKey("warn03")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"3")%> </label></td> </tr> <tr> <td><label> <input name="error_04" type="checkbox" value="warn04" <% if (hm.containsKey("warn04")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"4")%> </label></td> <td><label> <input name="error_05" type="checkbox" value="warn05" <% if (hm.containsKey("warn05")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"5")%> </label></td> <td><label> <input name="error_06" type="checkbox" value="warn06" <% if (hm.containsKey("warn06")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"6")%> </label></td> <td><label> <input name="error_11" type="checkbox" value="warn11" <% if (hm.containsKey("warn11")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"11")%> </label></td> <td><label> <input name="error_12" type="checkbox" value="warn12" <% if (hm.containsKey("warn12")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"12")%> </label></td> </tr> <tr> <td><label> <input name="error_13" type="checkbox" value="warn13" <% if (hm.containsKey("warn13")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"13")%> </label></td> <td><label> <input name="error_14" type="checkbox" value="warn14" <% if (hm.containsKey("warn14")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"14")%> </label></td> <td><label> <input name="error_15" type="checkbox" value="warn15" <% if (hm.containsKey("warn15")) out.println("checked");%> onclick="setCheck(this);"> <%=rt.getSystemCode("ERROR_TYPE_FILTER",lang,"15")%> </label></td> <td> <label> <input type="checkbox" name="error_absent" value="absent" <%if (hm.containsKey("absent")) out.println("checked");%> onclick="setCheck(this);"> <%=screen.getUProfile().get("lang").equals("THA")?"ขาดงาน":"Absent"%> </label> </td> <td><label> <input type="checkbox" name="errorall" value="warn17" onClick="javascript:chkAll();"><script language="javascript">swapLang('Select All')</script> </label></td> </tr> </table> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW012098" onClick="setSubmit();">SUBMIT</button> <button type="button" class="btn btn-primary width100" swlang code="SW013178" onClick="goExportExcel();">EXPORT</button> </div> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> </table> <% String cmd = request.getParameter("__cmd"); String goPage = request.getParameter("__goPage"); if((cmd != null && cmd.equals("search")) || (goPage != null && !goPage.equals(""))){ %> <table height="" align="center" cellpadding="0" cellspacing="0" class="largest"> <tr> <td class="blankspace" colspan="9"><div align="right">< <%=screen.getPageTag()%> ></div></td> </tr> <tr> <td class="blankspace" colspan="9"></td> </tr> <% int i = 0; // out.print("fiter :: "+screen.inq.getFilter()); // out.print("fiter :: "+screen.inq.getTableName()); while(screen.nextRec()) { if (i==0) { %> <tr> <td width="25%" class="forborder"><div align="center"><strong><%=screen.getLabel("employeeid")%></strong></div></td> <td width="10%" class="forborder"><div align="center"><strong><%=screen.getLabel("dateid")%></strong></div></td> <td width="10%" class="forborder"><div align="center"><strong><%=screen.getLabel("time0id")%></strong></div></td> <td width="10%" class="forborder"> <div align="center"><strong><%=screen.getLabel("warn_col01")=="warn_col01"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col01")%></strong></div> </td> <td width="10%" class="forborder"> <div align="center"><strong><%=screen.getLabel("warn_col02")=="warn_col02"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col02")%></strong></div> </td> <td width="10%" class="forborder"> <div align="center"><strong><%=screen.getLabel("warn_col03")=="warn_col03"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col03")%></strong></div> </td> <td width="10%" class="forborder"> <div align="center"><strong><%=screen.getLabel("warn_col04")=="warn_col04"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col04")%></strong></div> </td> <td width="10%" class="forborder"> <div align="center"><strong> <%=screen.getLabel("warn_col05")=="warn_col05"?"ไม่แสดงข้อมูล":screen.getLabel("warn_col05") %></strong></div> </td> <td width="5%" class="forborder"><div align="center"><strong><%=screen.getLabel("warn_col06")%></strong></div></td> </tr> <% } i++; if( screen.checkLinePage() ) { %> <tr> <td class="forborder"><div align="center"><%=screen.getString("employeeid")%> <%=screen.getString("memployee","fullname")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getString("dateid")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getString("time0id")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getLabel("warn_col01").equals("warn_col01") || chkCond(screen.getLabel("warn_col01"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col01")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getLabel("warn_col02").equals("warn_col02") || chkCond(screen.getLabel("warn_col02"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col02")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getLabel("warn_col03").equals("warn_col03") || chkCond(screen.getLabel("warn_col03"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col03")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getLabel("warn_col04").equals("warn_col04") || chkCond(screen.getLabel("warn_col04"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col04")%></font></div></td> <td class="forborder"><div align="center"><%=screen.getLabel("warn_col05").equals("warn_col05") || chkCond(screen.getLabel("warn_col05"), screen.getString("eventgrp"), lang) ?"-":screen.getString("warn_col05")%></font></div></td> <td class="forborder"><div align="center"> <% //if (screen.getString("warn_col06").equals("YES") || screen.getString("warn_col06").equals("มี")) { %> <a href="javascript:pageDesc('<%=screen.getString("employeeid")%>','<%=screen.getString("dateid")%>','<%=screen.getString("sequence")%>')"><img src="../IMAGES/BUTTON/MAIN/EDIT20.gif" border="0"></a></div> </td> <% //} else { out.println("-"); } %> </tr> <% } if(screen.outLinePage()) { break; } } %> <tr> <td class="blankspace" colspan="9"></td> </tr> <tr> <td class="bottom" colspan="9"></td> </tr> </table> <% } %> <%! public boolean chkCond(String label, String eventgrp, String lang){ ReportUDF rt=new ReportUDF(); if(eventgrp.equalsIgnoreCase("H") && ( label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"0") ) || label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"1") ) || label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"2") ) || label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"5") ) || label.equalsIgnoreCase( rt.getSystemCode("ERROR_TYPE", lang,"6") ) ) ){ return true; }else{ return false; } } private String chkMySecurity(String p_status,String p_field,String p_data){ String mfilter = ""; if (p_status.equalsIgnoreCase("1")){ mfilter =" AND "+p_field+" NOT IN ("; }else if (p_status.equalsIgnoreCase("0")){ mfilter = " AND "+p_field+" IN ("; } String mdata[] = p_data.split(","); for (int i=0;i<mdata.length; i++){ mfilter += "'"+mdata[i]+"',"; } mfilter = mfilter.substring(0,mfilter.length()-1); mfilter += ")"; return mfilter; } %> <% if (request.getParameter("__error")==null) { %> <script language="javascript">setShow();</script> <% } %> <br> </form> </body> </html>