<%@page contentType="text/html; charset=UTF-8" language="java" %>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,java.util.*"%>
<%@page import="com.csc.library.utilities.CscCalendar,com.csc.library.entry.HelpEntry,com.csc.library.system.*"%>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.formula.FormulaString"  %>
<%@page import="com.csc.library.timeattendance.DayShift,com.csc.library.timeattendance.Shift,com.csc.library.timeattendance.WorkingShift"  %>
<%@page import="java.text.DecimalFormat"  %>
<% 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", "PI_LEAVEHELP"); 
	screen.inq.setFilter("employeeid = '"+EMV.getUProfile().getEmvEmpId()+"' ");

	screen.inq.refresh();	
	screen.nextRec();
	CscCalendar cs=new CscCalendar();
	FormulaString fs = new FormulaString();

	CheckNull chkNull=new CheckNull();
	String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid"));
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="../Templates/template-emv-main.dwt.jsp" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Employee View</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="head" -->
<!-- Begin CSS Links -->
<link rel="stylesheet" type="text/css" href="../CSS/DDMENU.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_DEFAULT.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_LAYOUT_TWO.css" />
<link rel="stylesheet" type="text/css" href="../CSS/EMV_TEXT.css" />
<style type=text/css>
<!--
font.error {
	color: #FF0000;
	}
-->
</style>
<!-- End CSS Links -->
<!-- Begin Scripts -->
<!-- Begin script for Dropdown Menu -->
<!-- DO NOT EDIT -->
<script language="JavaScript" type="text/javascript" src="../JS/EVENTS.js"></script>
<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/UTILITIES.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/ACTIVE_OBJECT.js"></script>
<script language="JavaScript" type="text/javascript" src="../JS/SCREEN.js"></script>
<script language="JavaScript">setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/javascript">
function pageDesc(lv, desc){	
	with(document.cscform){
		var emp=__empID.value;
		var a=chkDateTime1(date1.value);
		var b=chkDateTime1(date2.value);
		//alert(date1.value+"==="+date2.value);
		var lv_filter="lv_type='"+lv+"'";
		__fixCon.value=" employeeid='"+emp+"' and (dateid between '"+date1.value+"' and '"+date2.value+"') and "+lv_filter;
		
		//alert(__fixCon.value);
		window.open("PI_LEAVEDESC.jsp?__cmd="+
			"&__date1="+a+"&__date2="+b+
			"&__empID="+__empID.value+"&__empName="+__empName.value+
			"&__lv_desc="+desc+
			"&__fixCon="+__fixCon.value,
			"Tleave_summary","left=150,top=100,width=700,height=300,toolbar=no,status=yes,scrollbars=yes,resizable=yes"
		);
		//submit();			
	}
}
</script>
<style type="text/css">
#header {
 	background: #FFFFFF ;
}
</style>
<!-- End Scripts -->
<!-- Begin Head -->

<!-- End Head -->
<!-- InstanceEndEditable -->
</head>
<body>
<div id="wrapper">
  <div id="header"><!-- InstanceBeginEditable name="header" -->
    <jsp:include page="EMV_HEADER.jsp" flush="true" />
   <!-- InstanceEndEditable -->  </div>
  <div id="topnav"><!-- InstanceBeginEditable name="top_navigation" -->
  	<jsp:include page="EMV_TOPMENU.jsp" flush="true" />
    <!-- InstanceEndEditable -->  </div>
  <div id="container">
    <div id="sidebar"><!-- InstanceBeginEditable name="side_bar" -->
    <jsp:include page="EMV_SIDEBAR.jsp" flush="true" />
      <!-- InstanceEndEditable -->    </div>
    <div id="content"><!-- InstanceBeginEditable name="main_content" -->
    <jsp:include page="EMV_HELPBAR.jsp" flush="true" />
    <!-- Begin Main Content -->
      <div class="content">
      <form name="cscform" method="post" action="PI_LEAVE.jsp">
        <input type="hidden" name="__cmd" value="">
        <input type="hidden" name="__screen"  value="PI_LEAVE"> 
        <input type="hidden" name="__help" value="">
        <input type="hidden" name="__helpReturn" value="">
        <input type="hidden" name="__helpName" value="">
        <input type="hidden" name="__pageCall" >
        <input type="hidden" name="__referPage" value="">
        <input type="hidden" name="__calendar">
        <script language="javascript">getInputFormatDate();</script>
        <input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
        <input type="hidden" name="__fixCon"  > 
        <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
        <input type="hidden" name="__childFilter" >
        <input type="hidden" name="__empID" value="<%=screen.getString("employeeid")%>"> 
        <input type="hidden" name="__empName" value="<%=screen.getString("fullname")%>">   
        <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
		<script language="javascript">initToolTips();</script> 
      	<%
			String d1 = "";
			String d2 = "";
			CscCalendar c1 = null;
			CscCalendar c2 = null;
			try {
				d1 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1001");
				d2 = (String) StaticConfig.getConfigCompany(screen.getUProfile(), "ta1002");
				if (d1!=null && d2!=null && !d1.equals("") && !d2.equals("")) {
					c1 = new CscCalendar(d1);
					c2 = new CscCalendar(d2);
				} 
			} catch (Exception e) {}
		%>
          <div class="content-box2">
            <div class="content-header"><h2><script language="javascript">swapLang('Employee Privilege Leave')</script>
            &nbsp;
            <%
				//out.println(c1+" : "+c2);
				if (c1!=null && c2!=null && !c1.equals(c2)) {
					if (screen.getUProfile().get("lang").equalsIgnoreCase("tha")) {
						out.println("["+c1.getDDThaiYYYY()+" - "+c2.getDDThaiYYYY()+"]");
					} else {
						out.println("["+c1.getDDEngYYYY()+" - "+c2.getDDEngYYYY()+"]");
					}
				}
			%>
            </h2></div>
            
            <table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-content-list">
                <tr> 
				  <td width="44%" class="column-header" rowspan="2"><script language="javascript">swapLang('Leave Type')</script></td>
				  <td width="14%" class="column-header"><script language="javascript">swapLang('Limit Last Year')</script></td>
				  <td width="14%" class="column-header"><script language="javascript">swapLang('Limit')</script></td>
				  <td width="14%" class="column-header"><script language="javascript">swapLang('Used')</script></td>
				  <td width="14%" class="column-header"><script language="javascript">swapLang('Remain')</script></td>
				</tr>
                <tr> 
					<td class="column-header"><script language="javascript">swapLang('DD HH')</script></td>
					<td class="column-header"><script language="javascript">swapLang('DD HH')</script></td>
					<td class="column-header"><script language="javascript">swapLang('DD HH')</script></td>
					<td class="column-header"><script language="javascript">swapLang('DD HH')</script></td>
				</tr>
			   <%
				//String vacation0_get = "00:00:00";
				String vacation0 = "00:00:00";
				String vacation1 = "00:00:00";

				DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");	
				inqEmp.setSchemaName(screen.getUProfile().getSchemaName());
				inqEmp.setFilter("employeeid='"+EMV.getUProfile().getEmvEmpId()+"'");
				inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1");
				inqEmp.refresh();
				if (inqEmp.next()){	
					vacation0 = inqEmp.getString("vacation0");
					vacation1 = inqEmp.getString("vacation1");
					//vacation0_get = inqEmp.getString("vacation0_get");
				}
				%>

                <% 			   
					String cFont = "";
					String c_limit = "";
					String c_used = "";
					String c_remain = "";
					String fld = getMConfigValue(screen.getUProfile(), "TALVFD");

					DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp1");	
					inq.setSchemaName(screen.getUProfile().getSchemaName());
					inq.setFilter("(daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') and display=1 and branchid = (select " +fld+" from MEMPLOYEE where EMPLOYEEID = '" + empid + "')");
					inq.setColumn("*");
					inq.setOrderBy("display_order");
					inq.refresh();

					while(inq.next()){	
						String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid");
						String b= inq.getString("eventgrpid");
						String type = inq.getString("daytype");
						String dis_limit = inq.getString("display_limit");
						if (screen.inq.getString(a+"_remain").indexOf('-')>-1) {
							cFont = "error";
						} else cFont = "";

						c_limit = screen.inq.getString(a+"_limit");
						c_used = screen.inq.getString(a+"_used");
						c_remain = screen.inq.getString(a+"_remain");
						String leaveadvance = chkNull.chkNullString(screen.inq.getString(a+"_leaveadvance"));
						String list[] = {vacation0,vacation1,c_used,c_remain};

						if (type.equals("7")) {
							if (vacation0.equals("")) {
								vacation0 = "00:00:00";
							}

							if (vacation1.equals("")) {
								vacation1= "00:00:00";
							}
							list[0] = vacation0;
							list[1] = vacation1;
						} else {
							list[0] = "";
							list[1] = c_limit;
						}

				%>
				<tr> 
					<td class="column-text">&nbsp;
                    	<% if (screen.inq.getString(a+"_used").equals("") || screen.inq.getString(a+"_used").equals("00:00:00")) { %>
                    		<font class="<%=cFont%>"><%=screen.inq.getString(a+"_desc")%></font>
                        <% } else { %>
                        	<a href="javascript:pageDesc('<%=b%>','<%=screen.inq.getString(a+"_desc")%>')"><font class="<%=cFont%>"><%=screen.inq.getString(a+"_desc")%></font></a>
                        <% } %>
						<%if(type.equals("7") && leaveadvance.length() > 0){%>
							&nbsp;&nbsp;<font class='error'>(<script language="javascript">swapLang("Leave Advance");</script>&nbsp;&nbsp;<%=leaveadvance%>)</font>
						<%}%>
                    </td>
					<td class="column-text-right">
						<font class="<%=cFont%>"><%=getDDHH(list[0])%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;		
						</font>
					</td>
					<td nowrap="nowrap" class="column-text-right">
						<font class="<%=cFont%>"><%=(dis_limit.equals("1"))?getDDHH(list[1]):"00:00"%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						</font>
					</td>
					<td nowrap="nowrap" class="column-text-right">
						<font class="<%=cFont%>"><%=getDDHH(list[2])%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						</font>
					</td>
					<td nowrap="nowrap" class="column-text-right">
						<font class="<%=cFont%>"><%=(dis_limit.equals("1"))?getDDHH(list[3]):"00:00"%>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						</font>
					</td>
                </tr>
				<% } %>
           	</table>
            <input type="hidden" name="date1" value="<%=screen.inq.getString("$date_begin")%>">
			<input type="hidden" name="date2" value="<%=screen.inq.getString("$date_end")%>">
            <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>
          </div>   
         
      </div>
      <!-- End Main Content -->
      <!-- InstanceEndEditable -->    </div>
  </div>
  <div id="footer"><!-- InstanceBeginEditable name="footer" -->
  <jsp:include page="EMV_FOOTER.jsp" flush="true" />
  <!-- InstanceEndEditable -->  </div>
</div>
</body>
<!-- InstanceEnd --></html>
<%!
public String getDDHH(String fm){
	String tmp = "";
	try {
		String dat[] = fm.split(":");
		tmp =  dat[0] + ":" + dat[1] ;
	}catch(Exception e){
		e.printStackTrace();
	}
	return tmp ;
}

public String getMConfigValue(UProfile upf, String filed){
	String srt = "";
	try {
		srt = (String) StaticConfig.getConfigCompany(upf, filed) ;
	}catch(Exception e){
		e.printStackTrace();
	}
	return srt ;
}
%>