<%@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.*,com.csc.library.formula.FormulaString"  %>

<jsp:useBean id="TAU143" class="com.csc.library.system.Task" scope="page"/>
<%
	TAU143.setChannel(request,response);
	HelpEntry screen = (HelpEntry) TAU143.process("HelpEntry","TAU143HELP");
	screen.process();
	screen.nextRec();
	screen.referLangOff();
	//out.println(request.getParameter("__date_start"));
    //out.println(request.getParameter("__date_end"));

	CheckNull chkNull=new CheckNull();
	String empid =chkNull.chkNullString(request.getParameter("__employeeid"),screen.getString("employeeid"));
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type=text/css>
FONT.error {
	FONT-FAMILY: "MS Sans Serif", sans-serif, "Microsoft Sans Serif";
	font-size: 14px;
	color: #FF0000;
	}
</style>
<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){ // 23/03/2004
	var tmpval="";
	with(document.cscform){
//				tmpval=valueSearch.substring(2,3);

				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){		
			//alert("date_start.value -> "+valueSearch);
				var valueSearch1=valueSearch.split("-");
				//alert("0 - >"+valueSearch1[0]+" #1 - >"+valueSearch1[1]+" #2 - >"+valueSearch1[2]);
					if(valueSearch1.length==3){	
						if(valueSearch1[0].length==4){
							//alert("length -> "+valueSearch1[0].length);
							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);
			//alert(a+"--"+b);
			__date_start.value=a;
			__date_end.value=b;
			__fixCon.value="employeeid= '"+__employeeid.value+"'";
			//__childFilter.value="tadjtime0:dt_bg between '"+a+"' and '"+b+"'";
			submit();

		document.cscform.submit();
		}
}

function pageDesc(c){	
		with(document.cscform){
			var a=chkDateTime1(date_start.value);
			var b=chkDateTime1(date_end.value);
			//alert(a+"--"+b);
	    	action="TAU144.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+"'";
			//__childFilter.value="ttime_current1:m_dt_bg between '"+a+"' and '"+b+"' and eventgrp='"+c+"'";
			//alert(__fixCon.value);
			submit();
			
		}
	}


function gotoDetail(page){
	with(document.cscform){
			var a=chkDateTime1(date_start.value);
			var b=chkDateTime1(date_end.value);
			__cmd.value = "";
			__date_start.value = a;
			__date_end.value = b;
			__fixCon.value = " employeeid='<%=request.getParameter("__employeeid")%>' and lv_type = 'LT' and dateid >= '"+a+"' and dateid <= '"+b+"'";
			action = "TARS001.jsp";
			submit();
	}
}

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

function checkCF() {checkConfirm();}

function goHelp(helpName,inputName){
	with(document.cscform){
		var helpReturn="";
		var fcon=__fixCon.value;
		if(inputName=="__employeeid" ){
			helpReturn="__employeeid:employeeid,MEMPLOYEE@FULLNAME";
			//fcon="employeeid in ("+__subordinate.value+")";		
		}
		
		if(fcon=="")
	     	linkHelp_Return(helpName,helpReturn);
	    else
	    	helpPageCon(helpName,helpReturn,fcon);
	}
}
	
function linkHelp(help,input){
	var fixcon="";
	with(document.cscform){
		fixcon=" ((employeeid in ("+__emp1.value+") ) or  (employee in ("+__emp2.value+"))) " 
		var param="PRU084.jsp?__helpName="+help+"&__fieldSearch="+input+"&__pageCall="+__screen.value+"&__fixCon="+fixcon;
		window.open(param,"Help","left=150,top=150,width=600,height=400,resizable=yes,scrollbars=yes,toolbar=no,status=yes");
	}
}
</script>
<!--meta http-equiv="refresh" content="1" url=PRU002.html-->
<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" ></br>
 <% CscCalendar cs=new CscCalendar();	%>
  <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
  <form name="cscform" method="post" >
  

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

<%=screen.InitialVariable()%>

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

<script language="javascript">//chkEmpid();</script>
  <input type="hidden" name="__cmd" value="">
  <input type="hidden" name="__screen"  value="TAU143"> 
  <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="__subordinate" value="<%//=screen.getUProfile().get("subordinateid")%>" -->
  <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" >

  <%
		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) {}
		//out.println(sDate+"   "+eDate+"<br>");
  %>
  <!--input type="hidden" name="__date_start" value="<%="01-"+cs.getMM()+"-"+cs.getYear()%>">
  <input type="hidden" name="__date_end" value="<%=cs.getDDMMYYYY()%>"-->
  <input type="hidden" name="__date_start" value="<%=sDate%>">
  <input type="hidden" name="__date_end" value="<%=eDate%>">
  <input type="hidden" name="__dateFilter" value=""> 
  <input type="hidden" name="__empID" value="<%=screen.getString("employeeid")%>"> 
  <input type="hidden" name="__empName" value="<%=screen.getString("fullname")%>">   
  <div align="center">
    <table class="medium">
      <tr> 
        <td class="header" colspan="2" >TAU143,&nbsp;<script language="javascript">swapLang('History of Leave for Employee');</script>&nbsp;</td>
      </tr>
      <tr> 
        <td colspan="2"> 
          <div align="center"> 
            <center>
              <table cellspacing="0" cellpadding="0" style="width:90%">
                <tr> 
                  <td colspan="2" class="blankspace"></td>
                </tr>
				<tr>
					<td class="columnlabel"><script language="javascript">swapLang("Employee Code");</script>&nbsp;</td>
					<td>
						<input type="text" name="__employeeid" size="15" value="<%=screen.getString("employeeid")%>">&nbsp;
						<a href="javascript:goHelp('MEMPLOYEEHELP','__employeeid','')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" width="20" height="20" border="0" align="absmiddle"></a>
					</td>
				</tr>
				<tr>
					<td class="columnlabel"><script language="javascript">swapLang('Name Surname');</script>&nbsp;</td>
					<td><input type="text" name="MEMPLOYEE@FULLNAME" value="<%=screen.getString("FULLNAME")%>" disabled size="34"></td>																
				</tr>
                <tr> 
					<td class="columnlabel"><script language="javascript">swapLang('Date Period');</script>&nbsp;</td>
					<td class="columnobject1"> 
						<input name="date_start" type="text" value="<%=request.getParameter("__date_start")%>" size="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(this,date_end)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()">&nbsp;
						<script language="javascript">chkDateStart(document.cscform.date_start.value,"date_start");</script>
						<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;
						<input name="date_end" type="text" value="<%=request.getParameter("__date_end")%>" size="10" onKeyup = "formatDate(this)" onBlur = "chkInputDate2(date_start,this)" onKeypress = "chkIntegerOfDate(this.value)" onMouseOver="toolTip('DDMMYYYY')" onMouseOut="toolTip()">&nbsp;
						<script language="javascript">chkDateStart(document.cscform.date_end.value,"date_end");</script>
						<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 class="blankspace" colspan="2"></td>
				</tr>
				<tr > 
					<td colspan="2">
						<table style="width:100%">
						<tr>
							<td rowspan="2" height="35" width="300" class="row3"> <div align="CENTER"><b><script language="javascript">swapLang('Leave Type');</script></b></div></td>
							<td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Limit_Last_Year");</script></b></div></td>
							<td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Limit");</script></b></div></td>
							<td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Used");</script></b></div></td>
							<td width="100" height="17" class="row3"><div align="CENTER"><b><script language="javascript">swapLang("Remain");</script></b></div></td>
						</tr>
						<tr bordercolor="#3399FF"> 
							<td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td>
							<td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td>
							<td width="100" height="10"  class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--script language="javascript">swapLang("DD HH SS");</script--></div></td>
							<td width="100" height="10" class="row3"><div align="CENTER">[<script language="javascript">swapLang("DD HH SS");</script>]<!--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";

				DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");	
				inqEmp.setSchemaName(screen.getUProfile().getSchemaName());
				inqEmp.setFilter("employeeid='"+screen.getString("employeeid")+"'");
				//inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1, vacation0_get");
				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="";
				FormulaString fs = new FormulaString();
			   	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 BRANCH from MEMPLOYEE where EMPLOYEEID = '" + empid + "')");
				//inq.setFilter("daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9' and eventgrpid !='LT'");
				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");
					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 height="19">
									<div align="left">&nbsp;
										<a href="javascript:pageDesc('<%=b%>')"><%=screen.inq.getString(a+"_desc")%></a>
										<%if(leaveadvance.length() > 0){%>
											&nbsp;&nbsp;<font style="color: #FF0000;font-size=12px;">(<script language="javascript">swapLang("Leave Advance");</script>&nbsp;&nbsp;<%=leaveadvance%>)</font>
										<%}%>
									</div>
								</td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=list[0]%></font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=list[1]%></font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=list[2]%></font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=list[3]%></font></div></td>
							</tr>   
							<% 
								}
								if ( screen.inq.getString("simmemployee_tadjtime0$lt_times").equals("0") ) {
									cFont = "";
								}else{
									cFont = "error";	
								}
							%>
							<tr > 
								<td height="19">
									<div align="left">&nbsp;
										<a href="javascript:gotoDetail('late');"><script language="javascript">swapLang("late");</script></a>
									</div>
								</td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'>รวม  <%=(screen.inq.getString("simmemployee_tadjtime0$lt_times")).length()>0?screen.inq.getString("simmemployee_tadjtime0$lt_times"):"0"%> ครั้ง</font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'>00:00:00</font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=screen.inq.getString("simmemployee_tadjtime0$lt_hour_fs")%></font></div></td>
								<td height="19"> <div align="center"><font class='<%=cFont%>'><%=screen.inq.getString("simmemployee_tadjtime0$lt_times").equals("0")?"":"-"%><%=screen.inq.getString("simmemployee_tadjtime0$lt_hour_fs")%></font></div></td>
							</tr>   
						</table>
					</td>
				</tr>
			</table>
           </center>
			</div>
		</td>
      </tr>
      <tr> 
        <td class="bottom" > </td>
      </tr>
	</table>
</div>
</form>
</body>
</html>