<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>

<jsp:useBean id="TAU308" class="com.csc.library.system.Task" scope="page"/>
<%
	TAU308.setChannel(request,response);
	HelpEntry screen = (HelpEntry) TAU308.process("HelpEntry","TAU308HELP");
	screen.process();
	screen.nextRec();
	screen.referLangOff();	
	
	String DateS="";
	String DateE="";
	try {
	CscCalendar csBudget = new CscCalendar();
    int yearStart = csBudget.getYear();
    csBudget.incYear(1);
    int yearEnd = csBudget.getYear();	
	DbInquiry inqM = new InitialInquiry(screen.getUProfile()).getDbInquiry();
	inqM.initMyTable("Mbudget", "", "");                    
    inqM.setColumn("budid,companyid,years,startdate,enddate");
    inqM.setFilter("startdate<='"+yearStart+"-10-01' and enddate >='"+yearEnd+"-09-30' and companyid='"+screen.getUProfile().get("companyid")+"'");                    
    inqM.refresh();      
	if (inqM.next()) {
		CscCalendar cs1 = new CscCalendar(inqM.getString("startdate"));
		CscCalendar cs2 = new CscCalendar(inqM.getString("enddate"));
		DateS = cs1.getDDMMYYYY();
		DateE = cs2.getDDMMYYYY();
	}
	}catch (Exception e) {}	
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="javascript">

function chkDateTime1(valueSearch){ 
	var tmpval="";
	with(document.cscform){
		var valueSearch1=valueSearch.split("-");
		if(valueSearch1.length==3){
			if(valueSearch1[1].length==1){
				valueSearch1[1]="0"+valueSearch1[1];
			}
			if(valueSearch1[0].length==1){
				valueSearch1[0]="0"+valueSearch1[0];
			}
			valueSearch1[2]=parseInt(valueSearch1[2]);
        	return valueSearch=valueSearch1[2]+"-"+valueSearch1[1]+"-"+valueSearch1[0];
		 }
	}
}

function chkDateStart(valueSearch,date){ 
	var tmpval="";
	var data1="";
	with(document.cscform){					
				var valueSearch1=valueSearch.split("-");
					if(valueSearch1.length==3){	
						if(valueSearch1[0].length==4){
							data1=valueSearch1[0];
							valueSearch1[0]=valueSearch1[2];
							valueSearch1[2]=data1;							
						}
						if(valueSearch1[1].length==1){
							valueSearch1[1]="0"+valueSearch1[1];
						}
						if(valueSearch1[0].length==1){
							valueSearch1[0]="0"+valueSearch1[0];
						}
						valueSearch1[2]=parseInt(valueSearch1[2]);
						if(date=="date_start"){
			        	date_start.value=valueSearch1[0]+"-"+valueSearch1[1]+"-"+valueSearch1[2];				
						}else{
						date_end.value=valueSearch1[0]+"-"+valueSearch1[1]+"-"+valueSearch1[2];
						}
					 }
					//alert("par.value -> "+date_start.value);
	}
}

function bdOnload() {
	with(document.cscform){			 			
		var a=chkDateTime1(date_start.value);
		var b=chkDateTime1(date_end.value);
		__date_start.value=a;
		__date_end.value=b;			
		submit();
		document.cscform.submit();
	}
}

function pageDesc(c){	
	with(document.cscform){
		var a=chkDateTime1(date_start.value);
		var b=chkDateTime1(date_end.value);
	    action="TAU309.jsp?__cmd=&__gorec="
		+"&__date_start="+a+"&__date_end="+b;
		__fixCon.value=" employeeid='<%=request.getParameter("__employeeid")%>' and m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'";		
		submit();			
	}
}

function chkEmpid(){
	window.document.forms[0].__employeeid.value=window.parent.document.forms[0].__employeeid.value;
}	

function checkCF() {checkConfirm();}
</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];}
}
//-->
</script>

</head>
<body leftmargin="0" topmargin="0" >
<% CscCalendar cs=new CscCalendar();	%>  
<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="TAU308"> 
  	<input type="hidden" name="__help" 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="__calendar">
  	<script language="javascript">getInputFormatDate();</script>
  	<input type="hidden" name="__companyid"  value="<%=screen.getUProfile().get("companyid")%>">
  	<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
  	<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
  	<input type="hidden" name="__childFilter" >	
  	<input type="hidden" name="__employeeid" value="<%=screen.getUProfile().get("actor")%>">
    <% if (request.getParameter("__date_start")==null) { %>
  	<% if (!DateS.equals("")&&!DateE.equals("")) {%>	 
	<input type="hidden" name="__date_start" value="<%=DateS%>">
	<%} else {%>
	<input type="hidden" name="__date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>">
	<% } %>
  	<% } else {%>
  	<input type="hidden" name="__date_start" value="<%=request.getParameter("__date_start")%>">
  	<%}%>  

  	<% if (request.getParameter("__date_end")==null) { %>
	<% if (!DateS.equals("")&&!DateE.equals("")) {%>	 
	<input type="hidden" name="__date_end" value="<%=DateE%>">
	<%} else {%>
  	<input type="hidden" name="__date_end" value="<%=cs.getDDMMYYYY()%>">
	<% } %>
  	<% } else {%>
  	<input type="hidden" name="__date_end" value="<%=request.getParameter("__date_end")%>">
  	<%}%>
   	<input type="hidden" name="__dateFilter" value="">
  
  <div align="center">
    <table>
      <tr> 
        <td class="header" colspan="2" >TAU308,&nbsp;<script language="javascript">swapLang('Leave Statistic');</script>&nbsp;</td>
      </tr>
      <tr> 
        <td colspan="2"> 
          <div align="center"> 
            <center>
              <table cellspacing="0" cellpadding="0">
                <tr> 
                  <td colspan="4"  class="blankspace"></td>
                </tr>
				<tr>
				<td class="columnlabel"><%=screen.getLabel("employeeid")%>&nbsp;</td>
				<td><%=screen.getUProfile().get("actor")%></td>
				</tr>
				<tr>
					<td class="columnlabel"><script language="javascript">swapLang('Name Surname');</script>&nbsp;</td>
					<td><%=screen.getUProfile().get("fullname")%></td>
				</tr>
                <tr> 
                  <td  class="columnlabel"><script language="javascript">swapLang('Time Period');</script>&nbsp;</td>
                  <td colspan="3"   class="columnobject1"> 
					<% if (request.getParameter("date_start")==null) { %>
  					<% if (!DateS.equals("")&&!DateE.equals("")) {%>	 
						<input type="text" name="date_start" value="<%=DateS%>" size="11">
					<%} else {%>
						<input type="text" name="date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>" size="11">
					<% } %>
  					<% } else {%>
  					<input type="text" name="date_start" value="<%=request.getParameter("date_start")%>" size="11">
  					<%}%>  
				  <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar1','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)">
				  <img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar1" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('date_start')" alt="Calendar"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 				  
					<% if (request.getParameter("date_end")==null) { %>
  					<% if (!DateS.equals("")&&!DateE.equals("")) {%>	 
						<input type="text" name="date_end" value="<%=DateE%>" size="11">
					<%} else {%>
						<input type="text" name="date_end" value="<%=cs.getDDMMYYYY()%>" size="11">
					<% } %>
  					<% } else {%>
  					<input type="text" name="date_end" value="<%=request.getParameter("date_end")%>" size="11">
  					<%}%>  
				  <a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('calendar2','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)">
				  <img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" name="calendar2" width="20" height="20" border="0" align="absmiddle" onClick="viewCal('date_end')" alt="Calendar"></a>
				<a href="javascript:bdOnload();"><img src="../IMAGES/BUTTON/SUBMIT.gif" alt="Submit"  border="0" align="absmiddle"></a> </td>
                </tr>
				<tr>
					<td colspan="5" class="blankspace">
				</tr>			
              <tr >
                <td rowspan="2" height="35" width="186" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Leave Type");</script></b></div></td>
                <td width="166" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td>
                <td width="134" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td>
                <td width="120" height="17" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td>
              </tr>
              <tr> 
                <td width="166" height="10" class="row3"> 
                  <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
                <td width="134" height="10"  class="row3"> 
                  <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
                <td width="120" height="10" class="row3"> 
                  <div align="CENTER"><script language="javascript">swapLang("DD HH SS");</script></div></td>
              </tr>
			   <% 
			   	DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp");	
				inq.setSchemaName(screen.getUProfile().getSchemaName());
				inq.setFilter("daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9' ");
				inq.setColumn("*");
				inq.refresh();
				while(inq.next()){	
				String a="simmemployee_tadjtime0$"+ inq.getString("eventgrpid");
				String b= inq.getString("eventgrpid");
				%>
              <% if (b.equals("04") || b.equals("13")) { %> 
				  <tr > 
                <td width="186" height="19"><div align="CENTER"><a href="javascript:pageDesc('<%=b%>')"><%=screen.getString("memployee",a+"4")%></a></div></td>
                <td width="166" height="19"> <div align="CENTER">--:--:--</div></td>
                <td width="134" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"2")%></div></td>
                <td width="120" height="19"> <div align="CENTER">--:--:--</div></td>
              </tr>       
				 <% } else { %>
              <tr > 
                <td width="186" height="19"><div align="CENTER"><a href="javascript:pageDesc('<%=b%>')"><%=screen.getString("memployee",a+"4")%></a></div></td>
                <td width="166" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"1")%></div></td>
                <td width="134" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"2")%></div></td>
                <td width="120" height="19"> <div align="CENTER"><%=screen.getString("memployee",a+"3")%></div></td>
              </tr>                
			 <% }%>
			 <% }%>
              <tr>
                <td class="blankspace" colspan="4"></td>
              </tr>			   
              </table>
            </center>
          </div></td>
      </tr>
      <tr> 
        <td class="bottom" > </td>
      </tr>
    </table>
    
</div>
</form>
</body>
</html>