<%@ 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>&nbsp; </td>
      </tr>
      <tr >
        <td >
		<br>	  
      <table  border="0" cellpadding="0" cellspacing="0" class="inframe">
        <tr>
          <td colspan="2" class="column-label">&nbsp;</td>
        </tr>
        <tr>
          <td width="150" class="column-label"><%=screen.getLabel("costtype")%>&nbsp;</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")%>&nbsp;</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")%>&nbsp;</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>&nbsp;&nbsp;<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">&nbsp;</td>
          <td class="column-input"><%=screen.getTagOrder()%></td>
        </tr>
        <tr>
          <td class="column-label">&nbsp;</td>
          <td class="column-input">&nbsp;</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")%>&nbsp;<%=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>