<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ page contentType="text/html; charset=UTF-8" language="java" pageEncoding="UTF-8" %> <%@ page import="com.csc.library.entry.EmvHelpEntry, com.csc.library.system.*, com.csc.library.utilities.CheckNull,com.csc.library.session.*,com.csc.library.database.FieldManager" %> <%@ page import="com.csc.library.report.ReportUDF, java.util.*"%> <% request.setCharacterEncoding("UTF-8"); %> <jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" /> <jsp:setProperty name="EMV" property="appname" value="WELFARE" /> <% EMV.setChannel( request, response ); EmvHelpEntry screen = (EmvHelpEntry)EMV.process("EmvHelpEntry", "WELEXP005"); if(screen==null){ return; } screen.setMaxLine(15); java.text.DecimalFormat df =new java.text.DecimalFormat("#,##0.00"); CheckNull chk = new CheckNull(); String bu1 = chk.chkNullString( request.getParameter("__bu1")); String bu2 = chk.chkNullString( request.getParameter("__bu2")); String bu3 = chk.chkNullString( request.getParameter("__bu3")); String bu4 = chk.chkNullString( request.getParameter("__bu4")); String bu5 = chk.chkNullString( request.getParameter("__bu5")); String costcenter = chk.chkNullString( request.getParameter("__costcenter")); String startdate = chk.chkNullString( request.getParameter("__startdate")); String enddate = chk.chkNullString( request.getParameter("__enddate")); if( !bu1.equals("") ){ screen.getInquiry().setFilter( "bu1", bu1, "", "=" ); } if( !bu2.equals("") ){ screen.getInquiry().setFilter( "bu2", bu2, "", "=" ); } if( !bu3.equals("") ){ screen.getInquiry().setFilter( "bu3", bu3, "", "=" ); } if( !bu4.equals("") ){ screen.getInquiry().setFilter( "bu4", bu4, "", "=" ); } if( !bu5.equals("") ){ screen.getInquiry().setFilter( "bu5", bu5, "", "=" ); } if( !costcenter.equals("") ){ screen.getInquiry().setFilter( "costcenter", costcenter, "", "=" ); } if( !startdate.equals("")||!enddate.equals("") ){ screen.getInquiry().setFilter( "startdate", startdate, enddate, "between" ); } int beginRow=((Integer.parseInt(screen.goPage)-1)*screen.maxLine)+1; int endRow=(Integer.parseInt(screen.goPage))*screen.maxLine; screen.getInquiry().setBetween(beginRow, endRow); screen.getInquiry().clearOldCondition(); screen.process(); %> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <!-- InstanceBeginEditable name="doctitle" --> <title>Employee View</title> <!-- InstanceEndEditable --> <meta http-equiv="Content-Type" content="text/html; charset=TIS620" /> <!-- InstanceBeginEditable name="head" --> <!-- Begin CSS Links --> <link rel="stylesheet" type="text/css" href="../CSS/EMV_DEFAULT.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_TWO.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" /> <link rel="stylesheet" type="text/css" href="../CSS/DDMENU.css" /> <!-- End CSS Links --> <!-- Begin Scripts --> <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> <!-- Begin script for Dropdown Menu --> <!-- DO NOT EDIT --> <script language="JavaScript" type="text/javascript" src="../JS/DDMENU.js"></script> <!--[if lt IE 7]><script language="JavaScript" type="text/javascript" src="../JS/IEHOVER-FIX.js"></script><![endif]--> <!-- DO NOT EDIT --> <!-- End script for Dropdown Menu --> <script language="JavaScript" type="text/javascript"src="../JS/SCREEN.js"></script> <script src="../JS/VIEWCALENDAR.js"></script> <script type="text/javascript"> <!-- setLang("<%=screen.getUProfile().get("lang")%>"); setPageTitle(swap2String("Employee Information")); function goHelp(helpName,inputName) { var helpReturn; var fixCon = ""; if(inputName=="__bu1" ) { helpReturn="__bu1:bu1id,MBU1@TDESC"; } else if(inputName=="__bu2" ) { helpReturn="__bu2:bu2id,MBU2@TDESC"; } else if(inputName=="__bu3" ) { helpReturn="__bu3:bu3id,MBU3@TDESC"; } else if(inputName=="__bu4" ) { helpReturn="__bu4:bu4id,MBU4@TDESC"; } else if(inputName=="__bu5" ) { helpReturn="__bu5:bu5id,MBU5@TDESC"; } else if(inputName=="__costcenter" ) { helpReturn="__costcenter:costcenterid,MCOSTCENTER0@TDESC"; } linkHelp_Return(helpName,helpReturn, fixCon); } function ShowDetail( pages, employeeid ){ var url = pages +".jsp?__employeeid=" +employeeid; PopupCenterTop( url, "popup", 700, 300); } function GoSearch(){ search(); } function toolTip(){ } function preview(pages){ with(document.cscform){ var url=pages+"?"; url+="__bu1="+__bu1.value; url+="&&__bu2="+__bu2.value; url+="&&__bu3="+__bu3.value; url+="&&__bu4="+__bu4.value; url+="&&__bu5="+__bu5.value; url+="&&__costcenter="+__costcenter.value; url+="&&__startdate="+__startdate.value; url+="&&__enddate="+__enddate.value; url+="&&__goPage="+listpage.options[listpage.selectedIndex].value; window.open(url,"Help","left=150,top=150,width=530,height=370,resizable=yes,scrollbars=yes,toolbar=no,status=yes"); } } //--> </script> </head> <body> <div id="wrapper"> <div id="header"> <!-- InstanceBeginEditable name="header" --> <jsp:include page="../EMPVIEW/EMV_HEADER.jsp" flush="true" /> <!-- InstanceEndEditable --> </div> <div id="topnav"><!-- InstanceBeginEditable name="top_navigation" --> <jsp:include page="../EMPVIEW/EMV_TOPMENU.jsp" flush="true" /> <!-- InstanceEndEditable --> </div> <div id="container"> <div id="sidebar"><!-- InstanceBeginEditable name="side_bar" --> <jsp:include page="../EMPVIEW/EMV_SIDEBAR.jsp" flush="true" /> <!-- InstanceEndEditable --> </div> <div id="content"><!-- InstanceBeginEditable name="main_content" --> <!-- Begin Main Content --> <jsp:include page="../EMPVIEW/EMV_HELPBAR.jsp" flush="true" /> <div id="content"> <form name="cscform" method="post" action="?"> <!-- BEGIN CSC INITIAL ZONE --> <%=screen.InitialVariable()%> <!-- END CSC INITIAL ZONE --> <input type="hidden" name="__screen" value="EMV008"> <input type="hidden" name="__cmd" value="" /> <input type="hidden" name="__help" value="" /> <input type="hidden" name="__goPage" value="" /> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>" /> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>" /> <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="__calendar"> <input type="hidden" name="__subordinateid" value="" /> <script language="javascript">getInputFormatDate();</script> <div class="box-search-condition"> <div class="content-title"> <script type="text/javascript" language="JavaScript">swapLang("Search Condition")</script> </div> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table-search-condition"> <tr> <td width="150" class="column-label"><img src="../IMAGES/SPACER.gif" width="100" height="1" /></td> <td class="column-label"> </td> <td class="column-label"> </td> <td class="column-label"> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("COSTCENTER")%></td> <td colspan="3" class="column-input"><%=screen.getInput("COSTCENTER")%> <input name="MCOSTCENTER0@TDESC" type="text" class="text" id="MCOSTCENTER0@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MCOSTCENTER0@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("bu1")%></td> <td colspan="3" class="column-input"><%=screen.getInput("bu1")%> <input name="MBU1@TDESC" type="text" class="text" id="MBU1@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU1@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("bu2")%></td> <td colspan="3" class="column-input"><%=screen.getInput("bu2")%> <input name="MBU2@TDESC" type="text" class="text" id="MBU2@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU2@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("bu3")%></td> <td colspan="3" class="column-input"><%=screen.getInput("bu3")%> <input name="MBU3@TDESC" type="text" class="text" id="MBU3@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU3@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("bu4")%></td> <td colspan="3" class="column-input"><%=screen.getInput("bu4")%> <input name="MBU4@TDESC" type="text" class="text" id="MBU4@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU4@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><%=screen.getLabel("bu5")%></td> <td colspan="3" class="column-input"><%=screen.getInput("bu5")%> <input name="MBU5@TDESC" type="text" class="text" id="MBU5@TDESC" size="40" readonly="readonly" value="<%=chk.chkNullString(request.getParameter("MBU5@TDESC")) %>" /> </td> </tr> <tr> <td class="column-label"><script language="JavaScript" type="text/javascript">swapLang('Date Between')</script></td> <td colspan="3" class="column-input"><span class="Text"> <input name="__startdate" type="text" size="10" maxlength="10" value="<%=chk.chkNullString(request.getParameter("__startdate"))%>" onfocus = "this.select()" onkeyup = "formatDate(this)" onkeypress = "chkInteger()" onblur="chkInputDate2(this,__enddate);"/> <a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onclick="viewCal('__startdate');"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image2" width="20" height="20" border="0" align="absmiddle" id="Image2" /></a> - <input name="__enddate" type="text" size="10" maxlength="10" value="<%=chk.chkNullString(request.getParameter("__enddate"))%>" onfocus = "this.select()" onkeyup = "formatDate(this)" onkeypress = "chkInteger()" onblur="chkInputDate2(__startdate,this);"/> <a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image11','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onclick="viewCal('__enddate');"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image11" width="20" height="20" border="0" align="absmiddle" id="Image11" /></a></span></td> </tr> <tr> <td class="column-label"><script language="javascript" type="text/javascript">swapLang("Order By");</script></td> <td colspan="3" class="column-input"><%=screen.getTagOrder()%> <a href="javascript:GoSearch();"><img src="../IMAGES/EMPVIEW/BUTTON/SEARCH.gif" alt="Search" width="60" height="23" border="0" align="top" /></a></td> </tr> <tr> <td colspan="4" class="column-label"> </td> </tr> </table> </div> <div id="searchinfo" > <span id="recordfound"><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> : <%=screen.getInquiry().recCount() %> <script language="JavaScript" type="text/javascript">swapLang("record(s)");</script></span> <span id="pagetag"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> : <%=screen.getPageTag()%></span> <div class="clearfloat"></div> </div> <div class="content-box"> <div class="content-header"> <h2> <script type="text/javascript" language="JavaScript">swapLang("Employee Information")</script> </h2> </div> <div style="overflow-x:scroll; width:728px;"> <table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list"> <tr> <td width="30" class="column-header"><%=screen.getLabel("employeeid")%></td> <td width="70" class="column-header" nowrap>ชื่อ-นามสกุล</td> <td width="170" class="column-header"><%=screen.getLabel("bu1")%></td> <td width="110"class="column-header">ผู้อนุมัติสูงสุด</td> <td width="110" class="column-header">สถานที่เดินทาง</td> <td width="110" class="column-header">วันที่เดินทาง</td> <td width="110" class="column-header">จำนวนเงิน (ขออนุมัติ)</td> <td width="110" class="column-header">จำนวนเงิน (ค่าใช้จ่าย)</td> <td width="110" class="column-header">เลขที่เอกสาร</td> </tr> <% if(screen.getInquiry().recCount()>0) { double totalcost=0; String approve_fullname=""; DbRecord db=new InitialRecord(screen.getUProfile()).getDbRecord("memployee"); db.setColumn("employeeid,companyid,fname,lname,efname,elname,emp_position"); while(screen.nextRec()){ screen.referLangOn(); totalcost=screen.getInquiry().getCurrentDbRecord().getDouble("totalcost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_oilcost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_travcost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_vehiclecost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_receptioncost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_trainingcost")+ screen.getInquiry().getCurrentDbRecord().getDouble("borrow_othercost"); db.set("employeeid",screen.getString("approve")); db.set("companyid",screen.getString("companyid")); if(db.search()==1){ approve_fullname=db.getString("fullname"); } %> <tr> <td class="column-text center" ><!--a href="javascript:ShowDetail('EMV024','<%//=screen.getString("employeeid")%>');" --><%=screen.getString("employeeid")%><!--/a--></td> <td class="column-text center" nowrap ><%=chk.chkNullString(screen.getString("memployee","fullname"), "-") %></td> <td class="column-text" nowrap ><%=chk.chkNullString(screen.getString("mbu1","tdesc"), "-") %></td> <td class="column-text" nowrap ><%=chk.chkNullString(approve_fullname, "-")%></td> <td class="column-text" nowrap ><%=chk.chkNullString(screen.getString("mprovince","long_tname"), screen.getString("mcountry","tdesc")) %></td> <td class="column-text" nowrap ><%=screen.getString("startdate")%>-<br><%=screen.getString("enddate")%></td> <td class="column-text" ><%=df.format(totalcost)%></td> <td class="column-text" ><%=screen.getString("expend_cost")%></td> <td class="column-text" ><%=screen.getString("expendid")%></td> </tr> <% screen.referLangOff(); } // while } else { %> <tr> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> <td class="column-text" > </td> </tr> <% } %> </table> </div> <div align="center"><a href="javascript:preview('WELEXP006.jsp')"><img src="../IMAGES/BUTTON/PRINTER/PRINTER3.jpg" width="44" height="44" border="0" /></a></div> <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div> </div> <!-- BEGIN CSC ENDING ZONE --> <%=screen.endJSP()%> <!-- END CSC ENDING ZONE --> </form> </div> <!-- End Main Content --> <!-- InstanceEndEditable --> </div> </div> <div id="footer"><!-- InstanceBeginEditable name="footer" --> <jsp:include page="../EMPVIEW/EMV_FOOTER.jsp" flush="true" /> <!-- InstanceEndEditable --> </div> </body> </html>