<%@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"%> <%@page import="com.csc.library.database.DataSet,java.util.HashMap"%> <jsp:useBean id="TABSENT_ERR" class="com.csc.library.system.Task" scope="page" /> <% TABSENT_ERR.setChannel(request, response); HelpEntry screen = (HelpEntry) TABSENT_ERR.process("HelpEntry", "TABSENT_ERROR"); screen.setMaxLine(100); screen.inq.setRequireFoundTable("MEMPLOYEE"); screen.process(); ThaiUtilities thai = new ThaiUtilities(); %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <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 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; } TD.tdholiday{ FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif"; background-color: FF9999; font-size: 12px; color: #3366CC; height: 14px; border: 1px solid #CCCCCC; } TABLE.rockSizeTable{ width: 1100px; cell-spacing:0; } A { text-decoration: underline; } .absent A.absent { color: #FF0000; text-decoration: underline; } td.colorRow0{ background-color:#FFFFFF; border:1px solid #CCCCCC; color:#3366CC; font-size:12px; height:14px; } td.colorRow1{ background-color:#EFEFEF; border:1px solid #CCCCCC; color:#3366CC; font-size:12px; height:14px; } td.header_aga{ -moz-background-clip:border; -moz-background-inline-policy:continuous; -moz-background-origin:padding; background:#BBBBBB none repeat scroll 0 0; border:1px solid #BBBBBB; font-size:12px; font-weight:bold; } </style> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a && i<a.length && (x=a[i]) && x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0 && parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) && d.all) x=d.all[n]; for (i=0;!x && i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x && d.layers && i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } //--> function linkDetail(empid, dateid, time0id){ with (document.cscform){ location = "TAU165.jsp?__employeeid="+empid+"&__dateid="+dateid+"&__time0id="+time0id+"&__search=true"+getAllCondition()+"&__whereCuz="+__fixCon.value; } } function getAllCondition(){ var strReturn=""; with (document.cscform){ strReturn="&__emp1="+__emp1.value; strReturn+="&__emp2="+__emp2.value; strReturn+="&__bbu1="+__bu1.value; strReturn+="&__bbu2="+__bu2.value; strReturn+="&__bbu3="+__bu3.value; strReturn+="&__bbu4="+__bu4.value; strReturn+="&__bbu5="+__bu5.value; strReturn+="&__date1="+__date1.value; strReturn+="&__date2="+__date2.value; } return strReturn; } function linkHelp_Return(help,input,filter){ with(document.cscform){ if (__fixCon.value!="") { __fixCon.value=__fixCon.value } 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="Employee 1 ID must be less than Employee 2 ID"; with(document.cscform){ if(__language.value=="tha") altEmp="กรุณากรอกรหัสพนักงาน ช่องที่ 1 น้อยกว่ารหัสพนักงาน ช่องที่ 2"; if(__emp1.value <= __emp2.value){ setFilter(); }else alert(MyCode[101]); } } function initSubmit(){ setSubmit(); } function setFilter(){ with(document.cscform){ __cmd.value="search"; var temp = __fixCon.value; var sqlEmp=""; var sqlDate=""; var sqlBu1=""; var sqlBu2=""; var sqlBu3=""; var sqlBu4=""; var sqlBu5=""; 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 = " (start_date between '"+chkDateTime1(__date1.value)+"' and '"+chkDateTime1(__date2.value)+"') "; else if (__date1.value.length>0 && __date2.value.length==0) sqlDate = " start_date='"+chkDateTime1(__date1.value)+"' "; else if (__date2.value.length>0 && __date1.value.length==0) sqlDate = " start_date='"+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(sqlEmp,sqlDate); __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); __childFilter.value = sqlBu1 + sqlBu2 + sqlBu3 + sqlBu4 + sqlBu5; alert(__fixCon.value); alert(__childFilter.value); submit(); } } function openPopup(docid){ with(document.cscform){ tempAction = action; tempTarget = target; action="TAU120_NSTDA.jsp"; __help.value="__absentid#"+docid+";"; window.open("","Static","width=780px,height=500px,scrollbars=yes"); target="Static"; submit(); action = tempAction; target = tempTarget; } } </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="TABSENT_ERROR.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__screen" value="TABSENT_ERR"> <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="__fixCon" value="<%=request.getParameter("__fixCon")%>"> <input type="hidden" name="__childFilter" value="<%=request.getParameter("__childFilter")%>"> <script language="javascript">getInputFormatDate();</script> <% 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"); %> <br> <table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="largest"> <tr bgcolor="#3366CC"> <td height="20" class="header" colspan="4">TABSENT_ERR, <script language="javascript">swapLang("Absent Error");</script> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <td align="right"><strong> <script language="javascript">swapLang("Employee Code");</script> </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"><script language="javascript">swapLang('Business Unit 1');</script> </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="50" readonly=""> </td> </tr> <tr> <td align="right"><script language="javascript">swapLang('Business Unit 2');</script> </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="50" readonly=""> </td> </tr> <tr> <td align="right"><script language="javascript">swapLang('Business Unit 3');</script> </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="50" readonly=""> </td> </tr> <tr> <td align="right"><script language="javascript">swapLang('Business Unit 4');</script> </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="50" readonly=""> </td> </tr> <tr> <td align="right"><script language="javascript">swapLang('Business Unit 5');</script> </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="50" readonly=""> </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="8" value="<%=date1%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,__date2)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <a href="#" 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="8" value="<%=date2%>" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(__date1,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()"> <a href="#" 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><div align="right"><script language="javascript">swapLang('Order By');</script> </div></td> <td><%=screen.getTagOrder()%></td> <td><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 class="medium"> <td colspan="4"><div align="center"><a href="javascript:setSubmit();"><img src="../IMAGES/BUTTON/SUBMIT.gif" alt="Submit" border="0" align="absmiddle"></a></div></td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <% String cmd = request.getParameter("__cmd"); String goPage = request.getParameter("__goPage"); if((cmd != null && cmd.equals("search")) || (goPage != null && !goPage.equals(""))){ %> <tr> <td class="blankspace" colspan="4"><div align="right" ><font size="2">< <%=screen.getPageTag()%> ></font></div></td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td colspan="4"> <table height="" align="center" cellpadding="0" cellspacing="1" class="largest"> <tr > <td rowspan="2" class="header_aga"><div align="center"><strong><%=screen.getLabel("employeeid")%></strong></div></td> <td width="" rowspan="2" class="header_aga"><div align="center"><%=screen.getLabel("absentid")%></div></td> <td width="" rowspan="2" class="header_aga"><div align="center"><%=screen.getLabel("absentid_err")%></div></td> <td colspan="4" align="center" class="header_aga">ใบลาที่ลงไว้แล้ว</td> <td colspan="4" align="center" class="header_aga">ใบลาที่เวลาซ้ำกัน</td> </tr> <tr > <td width="" class="header_aga"><div align="center"><%=screen.getLabel("start_date")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("end_date")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("start_time")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("end_time")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("start_date_err")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("end_date_err")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("start_time_err")%></div></td> <td class="header_aga"><div align="center"><%=screen.getLabel("end_time_err")%></div></td> </tr> <% int rowColor = 0; while(screen.nextRec()) { if(screen.checkLinePage()) { %> <tr > <td align="left" class=""> <%=screen.getString("employeeid")%> <%=screen.getString("Memployee","fullname")%></td> <td class=""><div align="center"><font class=""> <a href="javascript:openPopup('<%=screen.getString("absentid")%>');"><%=screen.getString("absentid")%></a></font></div></td> <td class=""><div align="center"><font class=""><a class="" href="javascript:openPopup('<%=screen.getString("absentid_err")%>');"><%=screen.getString("absentid_err")%></a></font></div></td> <td class=""><div align="center"><%=screen.getString("start_date")%></div></td> <td class=""><div align="center"><%=screen.getString("end_date")%></div></td> <td class=""><div align="center"><%=screen.getString("start_time")%></div></td> <td class=""><div align="center"><%=screen.getString("end_time")%></div></td> <td class=""><div align="center"><font class="absent"><%=screen.getString("start_date_err")%></font></div></td> <td class=""><div align="center"><font class="absent"><%=screen.getString("end_date_err")%></font></div></td> <td class=""><div align="center"><font class="absent"><%=screen.getString("start_time_err")%></font></div></td> <td class=""><div align="center"><font class="absent"><%=screen.getString("end_time_err")%></font></div></td> </tr> <% } if(screen.outLinePage()) { break; } } %> </table> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <tr> <td class="blankspace" colspan="4"> </td> </tr> <tr> <td class="blankspace" colspan="4"></td> </tr> <%}%> <tr> <td class="blankspace" colspan="4"></td> </tr> </table> </form> <br> </body> </html>