<!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">&nbsp;</td>
                <td class="column-label">&nbsp;</td>
                <td class="column-label">&nbsp;</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);"/>
                  &nbsp;<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>&nbsp;-&nbsp;
                  <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);"/>
                  &nbsp;<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">&nbsp;</td>
              </tr>
            </table>
          </div>
          
            <div id="searchinfo" >
              <span id="recordfound"><script language="JavaScript" type="text/javascript">swapLang("Found Data");</script> :&nbsp;&nbsp;<%=screen.getInquiry().recCount() %>&nbsp;<script language="JavaScript" type="text/javascript">swapLang("record(s)");</script></span>
              <span id="pagetag"><script language="JavaScript" type="text/javascript">swapLang("Page");</script> :&nbsp;&nbsp;<%=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" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</td>
                 <td class="column-text" >&nbsp;</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>