<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.database.*"%> <%@page import="com.csc.library.session.*"%> <%@page import="com.csc.library.components.*"%> <jsp:useBean id="WEL243" class="com.csc.library.system.Task" scope="page" /> <% WEL243.setChannel(request, response); HelpEntry screen = (HelpEntry) WEL243.process("HelpEntry","WEL238C"); screen.setMaxLine(15); CheckNull chk = new CheckNull(); CscCalendar csc = new CscCalendar(); String[][] addstatus = SystemCode.getContent("ADVANCE_STATUS"); String adno1 = chk.chkNullString(request.getParameter("__adno1")); String adno2 = chk.chkNullString(request.getParameter("__adno2")); String cleardate1 = chk.chkNullString(request.getParameter("__cleardate1")); String cleardate2 = chk.chkNullString(request.getParameter("__cleardate2")); String adstatus = chk.chkNullString(request.getParameter("__adstatus")); String empid1 = chk.chkNullString(request.getParameter("__empid1")); String empid2 = chk.chkNullString(request.getParameter("__empid2")); String filter = "(1=1) and (advance_type='3' and clearance_no is not null and clearance_no != '')"; // if( !tano1.equals("")&& !tano2.equals("") ){ if( !chk.chkNullString(request.getParameter("con_adno")).equals("")){ filter +=" and (clearance_no between '"+adno1+"' and '"+adno2+"')"; } if( !chk.chkNullString(request.getParameter("con_employeeid")).equals("")){ filter +=" and (employeeid between '"+empid1+"' and '"+empid2+"')"; } // if( !empid1.equals("")&& !empid2.equals("") ){ //if( !chk.chkNullString(request.getParameter("con_employeeid")).equals("")){ //filter +=" and (taid in (select taid from ttravel_aut where employeeid between '"+empid1+"' and '"+empid2+"'))" ; //} // if( !specialreq1.equals("")&& !specialreq2.equals("") ){ if( !chk.chkNullString(request.getParameter("con_cleardate")).equals("")){ CscCalendar reqdate1 = new CscCalendar(cleardate1); CscCalendar reqdate2 = new CscCalendar(cleardate2); //((DbInquiry)screen.getInquiry()).setFilter( "specialreq_ta", reqdate1.getYYYYMMDD(),reqdate2.getYYYYMMDD(), "between" ); filter +=" and (clearing_date between '"+reqdate1.getYYYYMMDD()+"' and '"+reqdate2.getYYYYMMDD()+"')"; } if( !chk.chkNullString(request.getParameter("con_status")).equals("")){ //((DbInquiry)screen.getInquiry()).setFilter( "car_status", doc_status, "", "=" ); filter +=" and (advance_status ='"+adstatus+"')"; } ((DbInquiry)screen.getInquiry()).setFilter(filter); //out.print(filter); screen.process(); %> <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 language="JavaScript" src="../JS/SCREEN.js"></script> <SCRIPT TYPE='text/JavaScript' SRC='../JS/MYNOTE_SCREEN.js'></SCRIPT> <script src="../JS/VIEWCALENDAR.js"></script> <script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language='javascript' src='./JS/SWAPLANG.js'></script> <script language="JavaScript" type="text/JavaScript"> function GoSearch(){ with(document.cscform){ var tmp="", myText=""; var conName=Array ("__adno1#__adno2","__empid1#__empid2","__cleardate1#__cleardate2","__adstatus"); conList.value=""; for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox" && elements[i].id=="condition"){ if(elements[i].checked){ conList.value+=elements[i].value+"#"; //if(elements[i].value!="8" && elements[i].value!="9"){//ไม่เช็คค่าฟิลด์ condition ที่เป็น select และ radio เพราะี default ค่าไว้แล้ว //tmp+=conName[(elements[i].value)-1]+"#"; //} } } } //alert(tmp); if(!chkConditionValue(tmp)){ if(getLang()=="tha"){ myText = "ระบุเงื่อนไขการค้นหา"; }else{ myText = "Please insert condition value."; } alert(myText); }else{ search(); } } } //ตรวจสอบว่ามีการกรอกค่าในฟิลด์หรือไม่? function chkConditionValue(obj){ with(document.cscform){ var check=true; var tmp=obj.split("#"); for(i=0;i<tmp.length-1;i++){ if(eval(tmp[i]).value==""){ check=false; } } return check; } } function goHelp(helpName,inputName) { var helpReturn; var fixCon = ""; if(inputName=="__empid1" ) { helpReturn="__empid1:employeeid"; }else if(inputName=="__empid2" ) { helpReturn="__empid2:employeeid"; }else if(inputName=="__adno1" ) { helpReturn="__adno1:clearance_no"; }else if(inputName=="__adno2" ) { helpReturn="__adno2:clearance_no"; }else if(inputName=="__agency" ) { fixCon="sitewelgid='AG001'"; helpReturn="__agency:SITEWELID"; } linkHelp_Return(helpName,helpReturn,fixCon); } function GoSave(){ alert(MyCode[150]); } function GoDelete(){ alert(MyCode[150]); } function checkAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox" && elements[i].name=="talist") elements[i].checked=true; }//end for }//end with }//end function function decheckAll(){ with(document.cscform){ for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox" && elements[i].name=="talist") elements[i].checked=false; }//end for }//end with }//end function function goPage(page){ with(document.cscform){ __goPage.value=page; submit(); } } function mailToEmployee(){ with(document.cscform){ alert("mail to employee"); } } function mailToAgency(){ with(document.cscform){ alert("mail to agency"); } } function reserveDetail(ta_no,employeeid,line_no,gorac){ with(document.cscform){ window.open("WEL243_1.jsp?__ack=edit&__cmd=search&__CLEARANCE_NO="+ta_no+"&__line_no="+line_no+"&__gorec="+gorac+ "&__employeeid="+employeeid+"&__companyid="+__companyid.value,"","left=150,top=150,width=800,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } } /*function reserveDetail2(ta_no,employeeid,line_no,gorac){ with(document.cscform){ window.open("WEL243_2.jsp?__ack=edit&__cmd=search&__CLEARANCE_NO="+ta_no+"&__line_no="+line_no+"&__gorec="+gorac+ "&__employeeid="+employeeid+"&__companyid="+__companyid.value,"","left=150,top=150,width=800,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes"); } }*/ //set ค่า checkbox เมื่อมีการ refresh หน้าจอ function setChkbox(){ with(document.cscform){ var val=conList.value.split("#"); for(i=0;i<elements.length;i++){ if(elements[i].type=="checkbox" && elements[i].id=="condition"){ for(j=0;j<val.length;j++){ if(elements[i].value==val[j]){ elements[i].checked=true; } } } } } } </script> </head> <% String helpReturn=""; if(request.getParameter("__helpReturn")!=null){ helpReturn=request.getParameter("__helpReturn"); } %> <body leftmargin="0" topmargin="0"> <p> </p> <form name="cscform" method="post" action="WEL243.jsp" > <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value="<%//=chk.chkNullString(request.getParameter("__cmd"))%>"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__notNull" value=""> <input type="hidden" name="__pageCall" value=""> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__lockPage" value=""> <input type="hidden" name="__calendar"> <input name="__employeeid" type="hidden" value="0"> <input name="__docno" type="hidden" value="0"> <input type="hidden" name="__screen" value="WEL243"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__fixCon" value=""> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="conList" value="<%=chk.chkNullString(request.getParameter("conList"))%>"> <div align="center"> <table height="" align="center" cellpadding="0" cellspacing="0" border="0" class="large"> <tr bgcolor="#3366CC"> <td height="20" class="header">WEL243, <script language="JavaScript">swapLang('Clear Abroad Trip');</script> </td> </tr> <tr> <td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="maxsize"> <tr> <td class="blankspace"> </td> </tr> <tr> <td width="150" align="center"><b><script language="JavaScript">swapLang('Condition');</script></b> </td> <td class="columnlabel"><script language="JavaScript">swapLang('Order By');</script> </td> <td><%=screen.getTagOrder()%></td> </tr> <tr> <td align="center"><input type="checkbox" id="condition" name="con_adno" value="1"> </td> <td class="columnlabel"><%=screen.getLabel("CLEARANCE_NO")%> </td> <td> <input name="__adno1" type="text" size="15" value="<%=adno1%>"> <a href="javascript:goHelp('CLEARANCE0HELP','__adno1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image3" width="20" border="0" align="absmiddle"></a> - <input name="__adno2" type="text" size="15" value="<%=adno2%>"> <a href="javascript:goHelp('CLEARANCE0HELP','__adno2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image31','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20" border="0" align="absmiddle" id="Image31"></a></td> </tr> <tr> <td align="center"><input type="checkbox" id="condition" name="con_employeeid" value="2"> </td> <td class="columnlabel"><%=screen.getLabel("EMPLOYEEID")%> </td> <td> <input name="__empid1" type="text" size="15" value="<%=empid1%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__empid1');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image3" width="20" border="0" align="absmiddle"></a> - <input name="__empid2" type="text" size="15" value="<%=empid2%>"> <a href="javascript:goHelp('MEMPLOYEEHELP','__empid2');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image61','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image31" width="20" border="0" align="absmiddle" id="Image31"></a></td> </tr> <tr> <td align="center"><input type="checkbox" id="condition" name="con_cleardate" value="3"> </td> <td class="columnlabel"><%=screen.getLabel("CLEARING_DATE")%> </td> <td> <input name="__cleardate1" type="text" size="15" maxlength="10" value="<%=cleardate1%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)" onBlur="chkInputDate2(this,__cleardate2)" /> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image12" width="20" border="0" align="absmiddle" id="Image12" onClick="viewCal('__cleardate1')" /></a> - <input name="__cleardate2" type="text" size="15" maxlength="10" value="<%=cleardate2%>" onKeyPress="chkInteger()" onKeyUp="formatDate(this)" onBlur="chkInputDate2(__cleardate1,this)" /> <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image121','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image121" width="20" border="0" align="absmiddle" id="Image12" onClick="viewCal('__cleardate2')" /></a> </td> </tr> <tr> <td align="center"><input type="checkbox" id="condition" name="con_status" value="4"> </td> <td class="columnlabel"><%=screen.getLabel("ADVANCE_STATUS")%> </td> <td> <select name="__adstatus" onChange="setFilter()"> <% for(int i=0;i<addstatus.length;i++){ %> <option value="<%=addstatus[i][0]%>"><%=addstatus[i][1].substring(addstatus[i][1].indexOf(",") + 1)%></option> <% } %> </select></td> </tr> <tr> <td class="blankspace" ></td> </tr> <tr> <td colspan="3" align="center"> <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" border="0"></a></td> </tr> <tr> <td class="blankspace" ></td> </tr> <tr> <td colspan="3"><div align="right"><%=screen.getPageTag()%></div></td> </tr> </table> </td> </tr> <tr> <td colspan="3"> <table height="" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000" class="inframe" > <tr bgcolor="#3366CC"> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Order by');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Clearance');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Employee ID');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Name');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Approve Date');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Destination');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Amount');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Status');</script></div></td> <td class="title1"><div align="center"><script language="JavaScript">swapLang('Tranfer Date');</script></div></td> </tr> <% int i = 1; Double sumLenge=0.00; String lenge=""; while(screen.nextRec()){ if(screen.checkLinePage()){ screen.referLangOn(); lenge = chk.chkNullString(screen.getString("car_length"),"0.00"); while(lenge.indexOf(",")>0){ lenge = lenge.replace(",",""); } sumLenge=sumLenge+(Double.parseDouble(lenge)); %> <tr> <td nowrap class="forborder2"><div align="center"><input type="checkbox" name="talist" value=""></div></td> <td nowrap class="forborder2"> <div align="center"><a href="javaScript:reserveDetail('<%=screen.getString("CLEARANCE_NO")%>', '<%=screen.getString("EMPLOYEEID")%>','<%=i%>','<%=screen.getString("LINE_NO")%>')"> <%=screen.getString("CLEARANCE_NO")%></a></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("EMPLOYEEID"),"-")%></div></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getDataLabel("MEMPLOYEE","FULLNAME"),"-")%></div></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("APPROVE_DATE"),"-")%></div></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("CLEARANCE1","DESTINATION"),"-")%></div></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("ALL_AMOUNT"),"0.00")%></div></td> <td nowrap class="forborder2"><div align="center"><%=screen.getInquiry().getCurrentDbRecord().getSystemCode("ADVANCE_STATUS")%></div></td> <td nowrap class="forborder2"><div align="center"><%=chk.chkNullString(screen.getString("TRANFER_DATE"),"-")%></div></td> </tr> <% i++; screen.referLangOff(); } //if(screen.outLinePage()){ break; } }%> <!--tr> <% String sTotal="",temp1="",temp2="",aString=""; int comma=0; aString = sumLenge.toString(); temp1 = aString.substring(0,(aString.indexOf("."))); temp2 = aString.substring((aString.indexOf("."))+1,(aString.length())); if(temp2.length()<2){ temp2 += "0"; } for(int j=temp1.length();j>0;j--){ if(comma==3){ sTotal = temp1.substring(j-1,j)+ "," + sTotal; comma=1; }else{ sTotal = temp1.substring(j-1,j) + sTotal; comma++; } } sTotal += "."+temp2; %> <td nowrap class="forborder2" colspan="12"><div align="right"><b><script language="JavaScript">swapLang('Total');</script></b> </div></td> <td nowrap class="forborder2"><div align="center"><b><%=sTotal%></b></div></td> <td nowrap class="forborder2" colspan="2"> </td> </tr--> </table> </td> </tr> <tr><td > <table class="maxsize"> <tr> <td colspan="8" class="blankspace"></td> </tr> <tr> <td colspan="8" class="noborder"><div align="center" > <a href="#" onClick="checkAll()"><img src="../IMAGES/BUTTON/TRANSFER.gif" border="0"></a></div> </td> </tr> <tr> <td colspan="8" class="blankspace"></td> </tr> </table> </td></tr> <tr><td class="bottom"> </td></tr> </table> <script language="javascript"> setValue('__adstatus','<%=chk.chkNullString(request.getParameter("__adstatus"))%>'); setChkbox(); </script> </div> <!----------BEGIN CSC ENDING ZONE ------------------------> <%=screen.endJSP()%> <!----------END CSC ENDING ZONE --------------------------> </form> </body> </html>