<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.formula.*"%>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.timeattendance.*"%>
<%@page import="com.csc.library.timeattendance.GenShift,java.util.TreeMap,java.util.Iterator,java.util.HashMap"%>
<jsp:useBean id="SHOWLEAVE" class="com.csc.library.system.Task" scope="page" />
<%
		CheckNull chkNull=new CheckNull();
		SHOWLEAVE.setChannel(request ,response);
		HelpEntry screen = (HelpEntry) SHOWLEAVE.process("HelpEntry","SHOWLEAVEHELP");
		String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid"));
		screen.getInquiry().setFilter("employeeid = '"+empid+"'");
        screen.process();
		screen.nextRec();
//		out.println("employeeid -->> "+screen.getString("employeeid")+"<br>");
//		out.println("employeeid -->> "+request.getParameter("__employeeid"));

		CscCalendar cs = new CscCalendar();
		String sDate = "01-"+cs.getMM()+"-"+cs.getYear();
		String eDate = cs.getDDMMYYYY();
		try {
				sDate = StaticConfig.getConfigCompany(screen.getUProfile(), "ta1001");
				eDate = StaticConfig.getConfigCompany(screen.getUProfile(), "ta1002");
		} catch (Exception e) {}
		CscCalendar cssDate = new CscCalendar(sDate);
		CscCalendar cseDate = new CscCalendar(eDate);
		//out.println(cssDate.getDDMMYYYY()+"   "+cseDate.getDDMMYYYY()+"<br>");

		String openWith =chkNull.chkNullString(request.getParameter("openWith"),"");
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script  language="JavaScript" src="../JS/SCREEN.js"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
function back(unit){
	with(window.opener.document.cscform){
	        locateId.value =unit;
	}
	window.close();
}


function pageDesc2(c){	
		with(document.cscform){
//			var a=chkDateTime1(date_start.value);
//			var b=chkDateTime1(date_end.value); 
			var a = '<%=cssDate.getYYYYMMDD()%>';
			var b = '<%=cseDate.getYYYYMMDD()%>';
			//alert(a+"--"+b);
			__fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"'";
	    	window.open("TAU144.jsp?__cmd=&__gorec="+
		    "&__date_start="+a+	   
		    "&__date_end="+b+"&__fixCon="+__fixCon.value,
			 "Child","left=150,top=20,width=700,height=600,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
			//__childFilter.value="ttime_current1:m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'";
			//alert(__fixCon.value);
			submit();
			
		}
	}

function pageDesc(c){	
		/*with(document.cscform){
			var a = '<%//=cssDate.getYYYYMMDD()%>';
			var b = '<%//=cseDate.getYYYYMMDD()%>';
	    	action="SHOWNLEAVE_DETAIL.jsp?__cmd=&__gorec="+
		    "&__date_start="+a+	   
		    "&__date_end="+b;
			__fixCon.value=" employeeid='<%//=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"' ";
			if(c == 'OTL') __fixCon.value += " and is_otl='0'";

			window.open ("SHOWNLEAVE_DETAIL.jsp?__empID="+__empID.value+"&__empName="+__empName.value +"&__cmd=&__gorec="+
				"&__date_start="+a+"&__date_end="+b+"&__fixCon="+__fixCon.value
				,"mywindow","width=595,height=200,scrollbars=1"); 	
		}*/
		
		with(document.cscform){
			var a = '<%=cssDate.getYYYYMMDD()%>';
			var b = '<%=cseDate.getYYYYMMDD()%>';
	    	action="SHOWLEAVE_WF_DESC.jsp?__cmd=&__gorec="+
		    "&__date_start="+a+"&__date_end="+b;
			__fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and dateid between '"+a+"' and '"+b+"' and lv_type='"+c+"'";
			//alert(__fixCon.value);
			submit();			
		}
}
//-->
</script>
</head>

<body  leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="cscform" method="post" >


<!----------BEGIN CSC INITIAL ZONE ------------------------>

<%=screen.InitialVariable()%>

<!----------END CSC INITIAL ZONE -------------------------->

<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="SHOWLEAVE">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__language" value ="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="">
<input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>">
<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
<input type="hidden" name="__fixCon" value="employeeid='<%=empid%>'">  
<input type="hidden" name="__empID" value="<%=empid%>">
<input type="hidden" name="__empName" value="<%=screen.getDataLabel("fullname")%>">

<table cellpadding="0" cellspacing="0" class="inframe" >  
	 <tr >
      <td  colspan="2"> <div align="center">
          <table   class="maxsize" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666" >
           <tr>
			<td colspan="6"><div align="center"><script language="javascript">swapLang("Leave Statistic");</script>&nbsp;&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang("Start Date");</script>&nbsp;&nbsp; <%=cssDate.getDDMMYYYY()%>
			&nbsp;&nbsp;&nbsp;&nbsp;
			<script language="javascript">swapLang("End Date");</script>&nbsp;&nbsp; <%=cseDate.getDDMMYYYY()%>
			</div>
			</td>
			</tr>
            <tr >
                <td width="390" class="row3" rowspan="2"><div align="CENTER"><b><script language="javascript">swapLang("Leave Type");</script></b></div></td>
		    <td width="228" height="17" class="row3"><div align="CENTER"><b>
					<script language="javascript">swapLang("Limit Last Year");</script>
					<script language="javascript">swapLang("End");</script>
				<br><%=screen.inq.getString("lastleavedate")%></b></div></td>
			  <td width="204" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td>
              <td width="204" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td>
              <td width="207" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td>
            </tr>
              <tr>
                <td width="228" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
                <td width="204" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
                <td width="204" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
                <td width="207" height="10" class="row3"><div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
            </tr>
			   <%
				String vacation0_get = "00:00:00";
				String vacation0 = "00:00:00";
				String vacation1 = "00:00:00";
		  		FormulaString fs = new FormulaString();	

				DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");	
				inqEmp.setSchemaName(screen.getUProfile().getSchemaName());
				inqEmp.setFilter("employeeid='"+empid+"'");
					inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1, vacation0_get");
				inqEmp.refresh();
				if (inqEmp.next()){	
					vacation0 = inqEmp.getString("vacation0");
					vacation1 = inqEmp.getString("vacation1");
					vacation0_get = inqEmp.getString("vacation0_get");
				}
				%>
			   <% 			   
				String cFont = "";
				String v0_limit = "";
				String v1_limit = "";
				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 BRANCHID = (select BRANCH from MEMPLOYEE where EMPLOYEEID = '" +empid+ "')");
				//inq.setFilter("(daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') ");
				inq.setOrderBy("display_order");
				inq.setColumn("*");
				inq.refresh();
				while(inq.next()){
					String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid");

					String b= inq.getString("eventgrpid");
					String type = inq.getString("daytype");
					//boolean display = inq.getString("display_limit").equals("1");
					String event_desc = inq.getString("event_desc");
					if (screen.inq.getString(a+"_remain").indexOf('-')>-1) {
						cFont = "error";
					} else cFont = "";
				%>				
				<tr > 
                <td height="19" class="row-data"><div align="left">&nbsp;<a href="javascript:pageDesc('<%=b%>')"><%=screen.inq.getString(a+"_desc")%></a></div></td>
				<%
						String result = "";
						String c_limit = chkNull.chkNullString(screen.inq.getString(a+"_limit"),"00:00");
						String c_used = chkNull.chkNullString(screen.inq.getString(a+"_used"),"00:00");
						String c_remain = chkNull.chkNullString(screen.inq.getString(a+"_remain"),"00:00");
						String list[] = {vacation0,vacation1,c_used,c_remain};
						String list_value[] = {"","","",""};

						if (type.equals("7")) {
							if (vacation0.equals("")) {
								vacation0 = "00:00:00";
							/*} else {
								if (!vacation0.equals(vacation1)) {
									vacation0 = vacation0_get;
								}*/
							}

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

						for(int i = 0; i<list.length; i++){
							String splitTime[] = list[i].split(":");
							int day = chkNull.chkNullStringToInt(splitTime[0]);
							if(splitTime.length > 2){
								if (Float.parseFloat(splitTime[1]) == 0) {
									result = day + ".0";
								} else if (Float.parseFloat(splitTime[1]) <= 4.5) {
									result = day + ".5";	
								} else {
									result = day + ".0";
								}
								list_value[i] = result;
							}
						}

				%>
				<input type="hidden" name="<%="L"+b+"_USED"%>" value="<%=fs.DhmToM(screen.inq.getString(a+"_used"), 8)%>">
				<td height="19"><div align="center">
					<font class='<%=cFont%>'>
						<%
							//if(b.equals("A01") || openWith.equals("HR")){
								out.print(list[0]);
							//}else{
							//	out.println("");
							//}//end if 
						%>
					</font>&nbsp&nbsp&nbsp</div>
				</td>
				<td height="19"><div align="center">
					<font class='<%=cFont%>'>
						<%
							out.print(list[1]); 
						%>
						</font>&nbsp&nbsp&nbsp</div></td>
				<td height="19"><div align="center">
					<font class='<%=cFont%>'>
						<%=list[2]%>
					</font>&nbsp&nbsp&nbsp</div></td>
				<td height="19"><div align="center">
					<font class='<%=cFont%>'>
						<% 
								out.print(list[3]); 
						%>
						</font>&nbsp&nbsp&nbsp</div></td>
              </tr>   
			 <% }%>
			 </table>
        </div></td>
    </tr>           
	
	</td>
    </tr>
  </table>
  
</form>
</body>
</html>