<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@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.session.*,com.csc.library.components.*,com.csc.library.report.*,java.util.*,java.text.DecimalFormat,com.csc.library.database.DataSet;"%>
<jsp:useBean id="VACACCRUE001" scope="page" class="com.csc.library.system.Task" />
<jsp:useBean id="SAVEDATA" class="com.csc.library.databean.Vacaccrue_save" scope="page" />
<html ng-app="myHR">
<% 
	CheckNull chk = new CheckNull();
	CscCalendar cs = new CscCalendar();
	
    VACACCRUE001.setChannel(request ,response);
    HelpEntry screen = (HelpEntry) VACACCRUE001.process("HelpEntry", "VACACCRUE001");   
	SAVEDATA.setUProfile(screen.getUProfile());
	
		// --------------- SetData ---------------- //
    int year = cs.getYear();
	String calYos = cs.getYYYYMMDD();
	String getLeaveType = chk.chkNullString(request.getParameter("__getLeavetype"),"");
	String leavetype = chk.chkNullString(request.getParameter("__leavetype"),"");
	String cmd = chk.chkNullString(VACACCRUE001.getParameter("__cmd"),"");
	String bu1 = chk.chkNullString(VACACCRUE001.getParameter("__bu1"));
	String bu2 = chk.chkNullString(VACACCRUE001.getParameter("__bu2"));
	String bu3 = chk.chkNullString(VACACCRUE001.getParameter("__bu3"));
	String bu4 = chk.chkNullString(VACACCRUE001.getParameter("__bu4"));
	String bu5 = chk.chkNullString(VACACCRUE001.getParameter("__bu5"));
    String emp1 = chk.chkNullString(VACACCRUE001.getParameter("__emp1"));
	String emp2 = chk.chkNullString(VACACCRUE001.getParameter("__emp2"));
	String period1 = chk.chkNullString(VACACCRUE001.getParameter("__period1"));
	String period2 = chk.chkNullString(VACACCRUE001.getParameter("__period2"));
	String periodgrp = chk.chkNullString(VACACCRUE001.getParameter("__period_group"));
	String years = chk.chkNullString(VACACCRUE001.getParameter("__year"));
	String getFixcon = chk.chkNullString(VACACCRUE001.getParameter("__fixCon"),"");
	String orderBy = chk.chkNullString(VACACCRUE001.getParameter("__OrderBy_option"));
	String language = screen.getUProfile().get("lang");

	DbInquiry inqVac = new InitialInquiry(screen.getUProfile()).getDbInquiry("TVACATION_ACCRUAL");
	
	int i =0;
	int setRow =30;
	int receivePage = chk.chkNullStringToInt(VACACCRUE001.getParameter("__page"));
	if(receivePage == 0){
		receivePage = 1;
		}
	int StartRec = (setRow * receivePage) - (setRow);
	int endRec = 1;
	int row_total =0;
	//screen.process();
		// --------------- BEAN ---------------- //

	if (cmd.equalsIgnoreCase("save")) {
            System.out.println("*********************** save condition ***********************");
				
				cmd = "savecomplete";
    }

	if(cmd.equalsIgnoreCase("search")) {
		DbInquiry inqMemployee = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
	    inqMemployee.setColumn("employeeid,emp_prefix,fname,lname,efname,elname");
		inqVac.setColumn("employeeid,yos,last_year,this_year,as_of_period,this_period,total,taken,balance,planning,available,as_at_date,year");

		inqVac.setFilter(getFixcon);
		inqVac.putChild(inqMemployee);
		i = StartRec;
	}


    ListBox listSearchBy = new ListBox();
	listSearchBy.setUProfile(screen.getUProfile()); 
	listSearchBy.setName("SearchBy_option");
	listSearchBy.setValidCode("SEARCH_BY");
	listSearchBy.setDisable("false");
	listSearchBy.setChecked(chk.chkNullString(VACACCRUE001.getParameter("__SearchBy_option"),"EMPLOYEEID"));

	ListBox listOrderBy = new ListBox();
	listOrderBy.setUProfile(screen.getUProfile()); 
	listOrderBy.setName("OrderBy_option");
	listOrderBy.setValidCode("ORDER_BY_VAC");
	listOrderBy.setDisable("false");
	listOrderBy.setChecked(chk.chkNullString(VACACCRUE001.getParameter("__OrderBy_option"),"EMPLOYEEID"));

	ListBox listCondition = new ListBox();
	listCondition.setUProfile(screen.getUProfile()); 
	listCondition.setName("Condition_option");
	listCondition.setValidCode("ARITHMETICSEARCH");
	listCondition.setDisable("false");
	listCondition.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Condition_option"),"Less"));

	ListBox listLeaveType = new ListBox();
	listLeaveType.setUProfile(screen.getUProfile()); 
	listLeaveType.setName("Leave_option");
	listLeaveType.setValidCode("LEAVE_TYPE");
	listLeaveType.setDisable("false");
	listLeaveType.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Leave_option"),"Working day"));

	ListBox listPeriodType = new ListBox();
	listPeriodType.setUProfile(screen.getUProfile()); 
	listPeriodType.setName("Period_option");
	listPeriodType.setValidCode("PERIOD_TYPE");
	listPeriodType.setDisable("false");
	listPeriodType.setChecked(chk.chkNullString(VACACCRUE001.getParameter("Period_option"),"January"));
	
	DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("VACATION_PROFILE");
	inq.setColumn("VAC_CODE,VACID,TDESC,EDESC");
	inq.refresh();	

	row_total = inqVac.recCount();
	//screen.process();
%>
<head>
<title>ReportOption</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">
<script src="../JS/jquery-1.7.2.js"></script>
<script src="../JS/SCREEN.js"></script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<script type='text/JavaScript' SRC='../JS/ANGULAR/SWAPLANG.js'></script>
<script type="text/javascript" src="/hr/dwr/interface/CscCalendar.js"></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script src='../JS/ICONSMENU.js'></script>
<script src='../JS/HOTKEY.js'></script>
<script src="../JS/DATEINPUT.js"></script>
<script src="../JS/CscBase.js"></script>
<script src="../JS/CscCalendar.js"></script>
<script>getTitleName();</script>
<script TYPE='text/JavaScript' SRC='../JS/CscCalendarV3.js'></script>
<script type="text/JavaScript">

//-->
//var sw = new swaplang2();

function goHelp(helpName,inputName){
	with(document.cscform){	
	var helpReturn;
	var fixcon;
	var lang = '<%=screen.getUProfile().get("lang")%>';
	if(inputName.indexOf("__emp") > -1){
		helpReturn = inputName+":employeeid"
		fixcon = "employeeid in(select employeeid from tvacation_accrual)";
		linkHelp_Return(helpName,helpReturn,fixcon);
	}else if(inputName=="__period_group"){
		helpReturn = inputName+":groupid"
		linkHelp_Return(helpName,helpReturn,fixcon);
	}else if(inputName=="__period1"){
		helpReturn = inputName+":period"
		var getPeriodGroup = __period_group.value;
		if(getPeriodGroup != ""){
			fixcon = "groupid ='"+getPeriodGroup+"'";
			linkHelp_Return(helpName,helpReturn,fixcon);
		}else{
			if(lang == 'eng'){
				alert("Please Choose Period Group First.");
			}else{
				alert("กรุณาเลือกกลุ่มช่วงเวลาก่อน");
			}
		}
	}else if(inputName=="__period2"){
		helpReturn = inputName+":period"
		var getPeriodGroup = __period_group.value;
		if(getPeriodGroup != ""){
			fixcon = "groupid ='"+getPeriodGroup+"'";
			linkHelp_Return(helpName,helpReturn,fixcon);
		}else{
			if(lang == 'eng'){
				alert("Please Choose Period Group First.");
			}else{
				alert("กรุณาเลือกกลุ่มช่วงเวลาก่อน");
			}
		}
	}
	}
}


function goHelpBu(helpName,inputName){
	var helpReturn;
	var fixcon;
	 if(inputName=="__job" )
		helpReturn="__bu1:bu1,__bu2:bu2,__bu3:bu3,__bu4:bu4,__bu5:bu5,__bu1_desc,__bu2_desc,__bu3_desc,__bu4_desc,__bu5_desc";
	else if(inputName=="__bu1" )
		helpReturn="__bu1:bu1id,__bu1_desc:tdesc";
		//fixcon = "bu1 in(select bu1 from vacaccrue)";
	 else if(inputName=="__bu2" )
		helpReturn="__bu2:bu2id,__bu2_desc:tdesc";
		// fixcon = "bu2 in(select bu2 from vacaccrue)";
	else if(inputName=="__bu3" )
		helpReturn="__bu3:bu3id,__bu3_desc:tdesc";
		//fixcon = "bu3 in(select bu3 from vacaccrue)";
	else if(inputName=="__bu4" )
		helpReturn="__bu4:bu4id,__bu4_desc:tdesc";
		//fixcon = "bu4 in(select bu4 from vacaccrue)";
	else if(inputName=="__bu5" )
		helpReturn="__bu5:bu5id,__bu5_desc:tdesc";
		//fixcon = "bu5 in(select bu5 from vacaccrue)";
	linkHelp_Return(helpName,helpReturn);
	
}



function GoSearch(){
	with(document.cscform){	
		var filterheal="";
		//var month = __Period_option.value;
        filterheal=checkCondition2(filterheal,__emp1,__emp2,"employeeid");
        filterheal=checkCondition(filterheal,__bu1,"bu1");
        filterheal=checkCondition(filterheal,__bu2,"bu2");
        filterheal=checkCondition(filterheal,__bu3,"bu3");
        filterheal=checkCondition(filterheal,__bu4,"bu4");
        filterheal=checkCondition(filterheal,__bu5,"bu5");
		filterheal=checkCondition(filterheal,__period_group,"periodgroup");
		filterheal=checkCondition(filterheal,__leavetype,"EVENTGRP");
		filterheal=checkCondition(filterheal,__year,"year");
		var start_period = __period1.value;
		var end_period = __period2.value;
		if(start_period == "" && end_period == ""){
			//Do nothing
		}else if (start_period == "" && end_period != ""){
			 __period1.value = end_period;
			 filterheal=checkCondition(filterheal,__period1,"start_period");
			 filterheal=checkCondition(filterheal,__period2,"end_period");
		}else if (start_period != "" && end_period == ""){
			 __period2.value = start_period;
			 filterheal=checkCondition(filterheal,__period1,"start_period");
			 filterheal=checkCondition(filterheal,__period2,"end_period");
		}else{
			 filterheal=checkCondition(filterheal,__period1,"start_period");
			 filterheal=checkCondition(filterheal,__period2,"end_period");
		}
		

		__fixCon.value=filterheal;
		console.log(" filterheal >>>>>>>>"+filterheal);
		//__getLeavetype.value = $('select[name=__leavetype]').find(":selected").text();
		search();
    }
}

function checkCondition(filcon,objname,targetname){
    with(document.cscform){
        if(objname.value.length>0){
            filcon=checkFilter(filcon);
            filcon += targetname+"='"+objname.value+"'";
        }else{
			return filcon;
		} 
        return filcon;
    }
}

function checkConditionNull(filcon,targetname){
    with(document.cscform){
        filcon=checkFilter(filcon);
        filcon += targetname+"!=''";
        return filcon;
    }
}

function checkCondition2(filcon,objname1,objname2,targetname){
    with(document.cscform){
        if(objname1.value.length>0 && targetname === "employeeid"){
			if(objname2.value.length>0){
				filcon=checkFilter(filcon);
				filcon+= targetname+" between '"+objname1.value+"' and '"+objname2.value+"'";
			}else{
				filcon=checkFilter(filcon);
				filcon+= targetname+" between '"+objname1.value+"' and '"+objname1.value+"'";
			}
        }else if(objname2.value.length>0 && targetname === "employeeid"){
			filcon=checkFilter(filcon);
				filcon+= targetname+" between '"+objname2.value+"' and '"+objname2.value+"'";
		}else{
			return filcon;
		} 
        return filcon;
    }
}

function checkFilter(fil){
    if(fil.length>0)
        fil+=" and ";
    return fil;
}
function chkval(data){
	with(document.cscform){
		GoSearch();
	}
}

$(document).ready(function(){

});

</script>

</head>
<!-- <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onload="setdefaultDate();"> -->
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="cscform" method="post" action ="VACACCRUE001.jsp" ng-controller="Swaplang as sw" >
 

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

<%=screen.InitialVariable()%>

<input type="hidden" name="__cmd" value="<%=VACACCRUE001.getParameter("__cmd")%>"> 
<input type="hidden" name="__screen" value="VACACCRUE001"> 
<input type="hidden" name="__help" value=""> 
<input type="hidden" name="__calendar" value="">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"> 
<input type="hidden" name="__filterMemployee" value="companyid='<%=screen.getUProfile().get("companyid")%>'">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__temp" value="">
<input type="hidden" name="__curDate" value="<%=new CscCalendar().getDate()%>">
<input type="hidden" name="__confirm" value="s">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__employeeid" value="<%=screen.getUProfile().get("employeeid")%>">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<!-- <input type="hidden" name="__getLeavetype" value="<%=getLeaveType%>"> -->
<input type="hidden" name="__monthforseach" value="">


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

<div align="center">

    <table height="" align="center" cellpadding="0" cellspacing="0"  border="1" class="largest">
    <tr bgcolor="#3366CC">
      <td  height="20" class="header" colspan="4">Vacation Accrual,<swaplang code='SW011656'></swaplang>&nbsp;</td>
  	</tr>
	<tr>
      <td class="blankspace" colspan="4"></td>
    </tr>
      <td align="right"><strong><swaplang code='SW000350'></swaplang>&nbsp;</strong></td>
	  <td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>">
          <a href="javascript:goHelp('MEMPLOYEEHELP','__emp1')" 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"  border="0" align="absmiddle"></a> &nbsp;&nbsp;-&nbsp;&nbsp;
          <input type="text" name="__emp2" size="15" value="<%=emp2%>">
          <a href="javascript:goHelp('MEMPLOYEEHELP','__emp2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image3"  border="0" align="absmiddle"></a></span> </td>
	  </tr>
	<tr>
	  <td align="right"><swaplang code='SW000309'></swaplang>&nbsp;</td>
	  <td colspan="3"><input type="text" name="__bu1" size="15" value="<%=bu1%>">
        <a href="javascript:goHelpBu('MBU1HELP','__bu1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1"  border="0" align="absmiddle"></a>
        <input name="__bu1_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu1_desc"))%>" size="50" readonly="">        </td>
	  </tr>
	<tr>
	  <td align="right"><swaplang code='SW000310'></swaplang>&nbsp; </td>
	  <td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>">
        <a href="javascript:goHelpBu('MBU2HELP','__bu2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu2"  border="0" align="absmiddle"></a> 
        <input name="__bu2_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu2_desc"))%>" size="50" readonly="">      </td>
	  </tr>
	<tr>
	  <td align="right"><swaplang code='SW000311'></swaplang>&nbsp;</td>
	  <td colspan="3"><input type="text" name="__bu3" size="15" value="<%=bu3%>">
        <a href="javascript:goHelpBu('MBU3HELP','__bu3')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu3"  border="0" align="absmiddle"></a>
        <input name="__bu3_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu3_desc"))%>" size="50" readonly="">        </td>
	  </tr>
	<tr>
	  <td align="right"><swaplang code='SW000312'></swaplang>&nbsp;</td>
	  <td colspan="3"><input type="text" name="__bu4" size="15" value="<%=bu4%>">
        <a href="javascript:goHelpBu('MBU4HELP','__bu4')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu4"  border="0" align="absmiddle"></a>
        <input name="__bu4_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu4_desc"))%>" size="50" readonly="">        </td>
	  </tr>
	<tr>
	  <td align="right"><swaplang code='SW000313'></swaplang>&nbsp;</td>
	  <td colspan="3"><input type="text" name="__bu5" size="15" value="<%=bu5%>">
        <a href="javascript:goHelpBu('MBU5HELP','__bu5')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5"  border="0" align="absmiddle"></a>
        <input name="__bu5_desc" type="text" value="<%=chk.chkNullString(VACACCRUE001.getParameter("__bu5_desc"))%>" size="50" readonly=""> </td>
	  </tr>
	  <tr>
			<td align="right"><swaplang code='SW011708'></swaplang>&nbsp;</td><!-- SW011708 - กลุ่มระยะเวลา (Period Group)-->
			<td align="left"><span class="columnobject1">
			<input type="text" name="__period_group" size="5" value="<%=periodgrp%>">
			<a href="javascript:goHelp('MVACATION_PERIOD_GROUPHELP','__period_group')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgPeriodGroup','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgPeriodGroup"  border="0" align="absmiddle"></a>
			</span>&nbsp;&nbsp;&nbsp;&nbsp;<swaplang code='SW011709'></swaplang>&nbsp;
			<input type="text" name="__period1" size="2" value="<%=period1%>">
					<a href="javascript:goHelp('MVACATION_PERIODHELP','__period1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5"  border="0" align="absmiddle"></a>
					&nbsp;&nbsp;&nbsp;&nbsp;<swaplang code='SW011710'></swaplang>
				<input type="text" name="__period2" size="2" value="<%=period2%>">
					<a href="javascript:goHelp('MVACATION_PERIODHELP','__period2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5"  border="0" align="absmiddle"></a>
					&nbsp;&nbsp;&nbsp;&nbsp;Year
					<select name="__year">
						 <option value=""></option>
					<%
						String sql1 = "select distinct(year) from tvacation_accrual order by year;"; 
						DataSet ds1 = new DataSet(sql1, screen.getUProfile().get("dbname"), "tvacation_accrual");
						ds1.initConnection(screen.getUProfile());
						while (ds1.next()) {
							%><option value="<%=ds1.getString("year")%>" <%=(years.equals(ds1.getString("year")))?"selected":""%>><%=ds1.getString("year")%></option>
						<%}
						ds1.closeConnection();
					%>
					<!-- <input type="text" name="__year" size="5" value="<%=years%>"> -->
					</select>
					</span>
			</td>
	</tr>
	<tr>
    	<td><div align="right"><swaplang code='SW000004'></swaplang>&nbsp;</div></td>
		<td><%=listOrderBy.process()%></td>
		<td><!--div align="right"><script language="javascript">swapLang('Search By');</script>&nbsp;</div--></td>
		<td><%//=listSearchBy.process()%></td>
  	</tr>
	<tr>
    	<td><div align="right"><swaplang code='SW000300'></swaplang>&nbsp;</div></td>
		<!--td><%=listCondition.process()%></td-->

		<td><select name="__leavetype"> 
			 <option value=""></option>
				<%
				while(inq.next())
				{%>		
					  <option value="<%=inq.getString("VACID")%>"
					  <% if(leavetype.equals(inq.getString("VACID"))){%>selected<%}%>>
					  <%=(language.equals("eng"))?inq.getString("EDESC"):inq.getString("TDESC")%></option>
				<%}%>
		</select></td>
		<td>
		
		<td></td>
   	</tr>
	
	<tr class="medium">
      <td colspan="4"><div align="center"><a href="javascript:GoSearch();"><img src="../IMAGES/BUTTON/SEARCH.gif" alt="Submit" border="0" align="absmiddle"></a></div></td>
	  </tr>
	<tr>
      <td class="blankspace" colspan="4"></td>
    </tr>  		
	<tr>
		<%if(cmd.equalsIgnoreCase("search")){%>
		<td colspan="4" align="left">&nbsp;&nbsp;
			
			<select style="float:right;" id="__page" name='__page' onChange="chkval(this)">
			<%
					int pagecount=row_total/setRow;
					int pagemod=row_total%setRow;
					int __start = 0;
					int __end = 0;
					
					if(pagemod>0){
						pagecount++;
					}
					if(pagecount>0){
						for(int j=1;j<=pagecount;j++){
							__end =  j*setRow;
							__start =__end-setRow+1;
							if(receivePage == j){
							out.print("<option name="+j+" value="+j+" start="+__start+" end="+__end+" selected>"+j+" </option>");
							}
							else
							{
							out.print("<option name="+j+" value="+j+" start="+__start+" end="+__end+">"+j+"</option>");
							}
						}
					}else{
						out.print("<option name='1' value='1' start='1' end="+setRow+">1</option>");
					}
			%>
			</select>
		</td>

	</tr>
	<tr>
		<td colspan="4">
		<table class="largest"  border="1" align="center" cellpadding="1" cellspacing="1" bgcolor="#666666">
	     <tr>
			<td align="center" width="2%" class="title1"><swaplang code='SW001393'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW000602'></swaplang></td>
			<td align="center" width="5%" class="title1"><swaplang code='SW006940'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW011643'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW011644'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW011645'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW011711'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW011712'></swaplang></td>
			<td align="center" width="3%" class="title1"><swaplang code='SW009694'></swaplang></td>
			<td align="center" width="4%" class="title1"><swaplang code='SW011649'></swaplang></td>
			<td align="center" width="4%" class="title1"><swaplang code='SW011651'></swaplang></td>
			<td align="center" width="4%" class="title1"><swaplang code='SW011653'></swaplang></td>
			<td align="center" width="4%" class="title1"><swaplang code='SW011654'></swaplang></td>
			<td align="center" width="4%" class="title1"><swaplang code='SW011655'></swaplang></td>
	  </tr> <!-- >ปิด หัวตารางๆ <!-->
			<%
					int page_total_row = 0;
					inqVac.setOrderBy(orderBy);
					inqVac.refresh();
					inqVac.go(StartRec);
					while(inqVac.next()){
						i++;
						if(i<=setRow + StartRec){
						page_total_row++;
					
				// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> SET DATA INQ <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< //

			
				//String month_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),thisMonth);
				//String taken_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),taken);
				//String balance_amounth = SAVEDATA.Calsalary(inqVac.getString("employeeid"),balance);*/
			%>
			
			<tr>
				<%
					CscCalendar c = new CscCalendar(inqVac.getString("AS_AT_DATE"));
					String as_at_date = c.getDDMMYYYY();
				%>
				<td align="center" width="2%" ><%=i%></td>
				<td align="center" width="3%" >&nbsp;<%=inqVac.getString("employeeid")%>&nbsp;
				</td>
				<td align="left" width="5%">&nbsp;<%=inqVac.getString("memployee","fullname")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("YOS")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("LAST_YEAR")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("THIS_YEAR")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("AS_OF_PERIOD")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("THIS_PERIOD")%>&nbsp;</td>
				<td align="center" width="3%">&nbsp;<%=inqVac.getString("total")%>&nbsp;</td>
				<td align="center" width="4%">&nbsp;<%=inqVac.getString("TAKEN")%>&nbsp;</td>
				<td align="center" width="4%">&nbsp;<%=inqVac.getString("BALANCE")%>&nbsp;</div></td>
				<td align="center" width="4%">&nbsp;<%=inqVac.getString("PLANNING")%>&nbsp;</td>
				<td align="center" width="4%">&nbsp;<%=inqVac.getString("AVAILABLE")%>&nbsp;</td>
				<td align="center" width="4%">&nbsp;<%=as_at_date%>&nbsp;</td>
			</tr>
			<%
				}//End  if(i<=setRow + StartRec)
				else{
					break;
				}
				}//End	inqVac.next()	 		
			}//End if(cmd = search)%>
		</table>
		</td>
	</tr>
	<tr>
      <td class="blankspace" colspan="4"></td>
    </tr>
	<tr>
      <td class="blankspace" colspan="4"></td>
    </tr>
  </table>
  </div>
</form>
</body>
</html>