<%@ page contentType="text/html; charset=UTF-8" language="java" %> <%@page import="com.csc.library.entry.EmvHelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%> <%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <% request.setCharacterEncoding("UTF-8"); %> <jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page"/> <jsp:setProperty name="EMV" property="appname" value="empview" /> <% EMV.setChannel(request, response); HelpEntry screen = (HelpEntry) EMV.process("HelpEntry","WELEXPM006_CPN"); String lang = screen.getUProfile().get("lang"); screen.getInquiry().clearSubFilter(); //screen.getInquiry().setFilter("employeeid='"+screen.getUProfile().get("employeeid")+"'"); CheckNull chk=new CheckNull(); ThaiUtilities thail = new ThaiUtilities(); java.text.DecimalFormat df=new java.text.DecimalFormat("#,###,##0.00"); String condition=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__fixCon"))); String gl=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__gl"))); String account=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__account"))); String stdate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate"))); String endate=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate"))); String stdate1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__startdate"))); String endate1=thail.ASCII2Unicode(chk.chkNullString(request.getParameter("__enddate"))); if(gl.length()>0){ screen.getInquiry().setFilter("costtype",gl,"","="); } if(account.length()>0){ screen.getInquiry().setFilter("costcenter",account,"","="); } if(stdate.length()>0){ String [] std=stdate.split("-"); String [] end=endate.split("-"); if(std[2].length()==4){ stdate=std[2]+"-"+std[1]+"-"+std[0]; endate=end[2]+"-"+end[1]+"-"+end[0]; }else{ stdate=std[0]+"-"+std[1]+"-"+std[2]; endate=end[0]+"-"+end[1]+"-"+end[2]; } screen.getInquiry().setFilter("billdate",stdate,endate,"between"); } screen.process(); %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Employee View</title> <meta http-equiv="Content-Type" content="text/html; charset=TIS620" /> <link rel="stylesheet" type="text/css" href="../CSS/TISCO.css" /> <script language="JavaScript" type="text/javascript"src="../JS/EVENTS.js"></script> <script language="JavaScript" type="text/javascript" src="../JS/UTILITIES.js"></script> <script language="JavaScript" type="text/javascript"src="../JS/ACTIVE_OBJECT.js"></script> <script language="JavaScript" type="text/javascript" src="../JS/DDMENU.js"></script> <script language="JavaScript" type="text/javascript"src="../JS/SCREEN.js"></script> <script src="../JS/VIEWCALENDAR.js"></script> <script language="javascript"> setLang('<%=lang%>'); function goHelp(helpName,inputName){ var helpReturn; var fcon=""; if(inputName=="__gl" ){ helpReturn="__gl:PAYMENT_CODE"; }else if(inputName=="__welid2" ){ helpReturn="__welid2:WELID,MWELFARE@WELID"; }else if(inputName=="__year" ){ helpReturn="__year:years"; } helpPageCon(helpName,helpReturn,fcon); } function GoSearch(){ search(); } function goPages(page,complainid,caseid){ with(document.cscform){ action=page; method="post"; __complainid.value=complainid; __caseid.value=caseid; __cmd.value="search"; submit(); } } function addNewRows(){ with(document.cscform){ action="WELEXPM007_CPN.jsp"; method="post"; submit(); } } function editNewRows(expendid,employeeid,companyid,billdate,billno){ with(document.cscform){ __help.value="__expendid$"+expendid+";__employeeid$"+employeeid+";__companyid$"+companyid+"__billdate$"+billdate+";__billno$"+billno; action="WELEXPM007_CPN.jsp"; method="post"; submit(); } } </script> <style type="text/css"> #header { background: #FFFFFF ; } </style> </head> <body onload="MM_preloadImages('../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')"> <form name="cscform" action="WELEXPM006_CPN.jsp"> <input name="__cmd" type="hidden" value=""> <input type="hidden" name="__calendar"> <script language="javascript">getInputFormatDate();</script> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__orderBy" value=""> <input type="hidden" name="__helpReturn" value=""> <input type="hidden" name="__helpName" value=""> <input type="hidden" name="__pageCall" value=""> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__lockPage" value=""> <input type="hidden" name="__complainid" value=""> <input type="hidden" name="__caseid" value=""> <input type="hidden" name="__calendar" value=""> <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> <input type="hidden" name="__fixCon" value=""> <input name="__screen" type="hidden" value="WELEXPM006_CPN"> <div class="content-title"></div> <table class="largest" ellpadding="0" cellspacing="0"> <tr > <td class="header" >WELEXPM006_CPN, <script language="javascript">swapLang('History of vehicle expenses');</script> </td> </tr> <tr > <td > <br> <table border="0" cellpadding="0" cellspacing="0" class="inframe"> <tr> <td colspan="2" class="column-label"> </td> </tr> <tr> <td width="150" class="column-label"><%=screen.getLabel("costtype")%> </td> <td class="column-input"><input name="__gl" type="text" size="15" value="<%=gl%>" /> <a href="javascript: goHelp('MGLHELP','__gl');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image322','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image322" width="20" border="0" align="absmiddle" id="Image32" /></a></td> </tr> <tr> <td class="column-label"><%=screen.getLabel("costcenter")%> </td> <td class="column-input"><input name="__account" type="text" size="15" value="<%=account%>" /> <a href="javascript:goHelp('MACCOUNT_EXPHELP','__account');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image32','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Search" name="Image32" width="20" border="0" align="absmiddle" id="Image32" /></a></td> </tr> <tr> <td class="column-label"><%=screen.getLabel("billdate")%> </td> <td nowrap="nowrap" class="column-input"><input name="__startdate" type="text" size="10" maxlength="8" value="<%=stdate1%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(this,__enddate)" /> <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('__startdate')" /></a> - <input name="__enddate" type="text" size="10" maxlength="8" value="<%=endate1%>" onkeypress="chkInteger()" onkeyup="formatDate(this)" onblur="chkInputDate2(__startdate,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('__enddate')" /></a> <a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="Search" width="73" height="23" border="0" align="absmiddle" /></a></td> </tr> <tr> <td class="column-label"> </td> <td class="column-input"><%=screen.getTagOrder()%></td> </tr> <tr> <td class="column-label"> </td> <td class="column-input"> </td> </tr> </table> <br> <table width="100%" border="0" cellpadding="0" cellspacing="1" class="inframe"> <tr> <td width="114" nowrap class="title1"><%=screen.getLabel("expendid")%></td> <td width="103" class="title1" nowrap><%=screen.getLabel("employeeid")%></td> <td width="103" class="title1" nowrap><%=screen.getLabel("billdate")%></td> <td width="158" nowrap class="title1"><%=screen.getLabel("costtype")%></td> <td width="99" nowrap class="title1"><%=screen.getLabel("costcenter")%></td> <td width="89" nowrap class="title1"><%=screen.getLabel("workarea")%></td> <td width="106" nowrap class="title1"><%=screen.getLabel("km")%></td> <td width="121" nowrap class="title1"><%=screen.getLabel("nets")%></td> </tr> <% while (screen.nextRec()) { %> <tr> <td nowrap class="column-text"><a href="javascript:editNewRows('<%=screen.getString("expendid")%>','<%=screen.getString("employeeid")%>','<%=screen.getString("companyid")%>','<%=screen.getString("billdate")%>','<%=screen.getString("billno")%>');"><%=screen.getString("expendid")%></a></td> <td nowrap class="column-text"><%=screen.getString("employeeid")%> <%=screen.getString("memployee","fullname")%></td> <td nowrap class="column-text"><%=screen.getString("billdate")%></td> <td nowrap class="column-text"><%=screen.getString("costtype")%></td> <td nowrap class="column-text"><%=screen.getString("costcenter")%></td> <td nowrap class="column-text"><%=screen.getString("workarea")%></td> <td nowrap class="column-text"><%=screen.getString("km")%></td> <td nowrap class="column-text"><%=screen.getString("nets")%></td> </tr> <% } %> </table> <p align="center"><a href="javascript:addNewRows()"><img src="../IMAGES/BUTTON/ADD.gif" width="73" height="23" border="0" /></a></p></td> </tr> <tr> <td class="bottom" > </td> </tr> </table> </form> </body> </html>