<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*" %>
<%@ page import="com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.components.*" %>
<jsp:useBean id="ASR002" scope="page" class="com.csc.library.system.Task"/>
<% 
   ASR002.setChannel(request ,response);
   ReportEntry screen=null;
   screen=(ReportEntry)ASR002.process("ReportEntry",request.getParameter("__screen"));
   UProfile uf=screen.getUProfile();
   com.csc.library.report.ReportUDF systemCode = new com.csc.library.report.ReportUDF();

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

	DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("VACATION_PROFILE");
	inq.setColumn("VAC_CODE,VACID,TDESC,EDESC");
	inq.refresh();	
%>
<html ng-app="myHR">
<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">
	<link href="../CSS/bootstrap.css" rel="stylesheet"  type="text/css">
	<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet"  type="text/css">
	<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
	<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script src="../JS/SCREEN.js"></script>
<script src="../JS/jquery-1.7.2.js"></script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<script type='text/JavaScript' SRC='../JS/ANGULAR/SCREEN_ANGULAR.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></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 back(){ 
	var filter = "1=1 ";
	with(document.cscform){ 
		if(__condition$emp1.value!=""&&__condition$emp2.value!=""){
			filter += " and employeeid between '"+__condition$emp1.value+"' and '"+__condition$emp2.value+"' ";
		}else if(__condition$emp1.value!=""&&__condition$emp2.value==""){
			filter += " and employeeid = '"+__condition$emp1.value+"' ";
		}else if(__condition$emp1.value==""&&__condition$emp2.value!=""){
			filter += " and employeeid = '"+__condition$emp2.value+"' ";
		}

		if(__condition$periodgroup.value!=""){
			filter += " and periodgroup = '"+__condition$periodgroup.value+"' ";
		}

		if(__condition$start_period.value!=""&&__condition$end_period.value!=""){
			filter += " and start_period = '"+__condition$start_period.value+"' and end_period = '"+__condition$end_period.value+"' ";
		}else if(__condition$start_period.value!=""&&__condition$end_period.value==""){
			filter += " and start_period = '"+__condition$start_period.value+"' and end_period = '"+__condition$start_period.value+"' ";
		}else if(__condition$start_period.value==""&&__condition$end_period.value!=""){
			filter += " and start_period = '"+__condition$end_period.value+"' and end_period = '"+__condition$end_period.value+"' ";
		}

		if(__condition$year_process.value!=""){
			filter += " and year = '"+__condition$year_process.value+"' ";
		}

		if(__condition$eventgrp.value!=""){
			filter += " and eventgrp = '"+__condition$eventgrp.value+"' ";
		}
		
		if(__condition$year_process.value!=""&&__condition$start_period.value!=""&&__condition$end_period.value!=""){
			filter += setFilterEmp();
		}else if(__condition$year_process.value!=""&&__condition$start_period.value!=""&&__condition$end_period.value==""){
			filter += setFilterEmp_start();
		}else if(__condition$year_process.value!=""&&__condition$start_period.value==""&&__condition$end_period.value!=""){
			filter += setFilterEmp_end();
		}
		
		var group_by = __groupby_vac.value;
	}
	with(window.opener.document.cscform){ 
		//alert(filter);
		__fixfilterTvacation_accrual.value = filter;
		__GROUPBY_VAC.value = group_by;
	}
	window.close();
}

function setFilterEmp(){
	with(document.cscform){
		var filter ="";
		var yyyy = __condition$year_process.value;

			var start_mm = __condition$start_period_month.value;
			var start_dd = __condition$start_period_date.value;
			if(start_dd.length==1){
				start_dd = "0"+start_dd;
			}
			var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd;

			var end_mm = __condition$end_period_month.value;
			var end_dd = "";
			if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){
				end_dd = "31";
			}else if(end_mm=="02"){
				if(yyyy%4==0){
					end_dd = "29";
				}else{
					end_dd = "28";
				}	
			}else{
				end_dd = "30";
			}
			var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd;
			filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) ";
	}
	return filter;
}

function setFilterEmp_start(){
	with(document.cscform){
		var filter ="";
		var yyyy = __condition$year_process.value;

			var start_mm = __condition$start_period_month.value;
			var start_dd = __condition$start_period_date.value;
			if(start_dd.length==1){
				start_dd = "0"+start_dd;
			}
			var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd;

			var end_mm = __condition$start_period_month.value;
			var end_dd = "";
			if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){
				end_dd = "31";
			}else if(end_mm=="02"){
				if(yyyy%4==0){
					end_dd = "29";
				}else{
					end_dd = "28";
				}	
			}else{
				end_dd = "30";
			}
			var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd;
			filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) ";
	}
	return filter;
}

function setFilterEmp_end(){
	with(document.cscform){
		var filter ="";
		var yyyy = __condition$year_process.value;

			var start_mm = __condition$end_period_month.value;
			var start_dd = __condition$end_period_date.value;
			if(start_dd.length==1){
				start_dd = "0"+start_dd;
			}
			var start_yyyymmdd = yyyy+"-"+start_mm+"-"+start_dd;

			var end_mm = __condition$end_period_month.value;
			var end_dd = "";
			if(end_mm=="01"||end_mm=="03"||end_mm=="05"||end_mm=="07"||end_mm=="08"||end_mm=="10"||end_mm=="12"){
				end_dd = "31";
			}else if(end_mm=="02"){
				if(yyyy%4==0){
					end_dd = "29";
				}else{
					end_dd = "28";
				}	
			}else{
				end_dd = "30";
			}
			var end_yyyymmdd = yyyy+"-"+end_mm+"-"+end_dd;
			filter += " and employeeid in (select employeeid from memployee where status in ('A','V','Y') and startdate <='"+start_yyyymmdd+"' and resigndate >'"+end_yyyymmdd+"' ) ";
	}
	return filter;
}

function goHelp(helpName,inputName){
	with(document.cscform){
		var helpReturn;
		var fixcon = '';
		if(inputName.indexOf("__condition$emp") > -1){
			helpReturn = inputName+":employeeid"
			linkHelp_Return(helpName,helpReturn,fixcon);
		}else if(inputName=="__condition$periodgroup"){
			helpReturn = inputName+":groupid"
			linkHelp_Return(helpName,helpReturn,fixcon);
		}else if(inputName=="__condition$start_period" || inputName=="__condition$end_period"){
			if(__condition$periodgroup.value==''){
				alert(MyCode[219]);
			}else{
				fixcon = "groupid='"+__condition$periodgroup.value+"'";
				helpReturn = inputName+":period,"+inputName+"_date:period_date,"+inputName+"_month:period_month";
				linkHelp_Return(helpName,helpReturn,fixcon);
			}
		}
	}
}

function linkHelp_Return(help,input){
	with(document.cscform){
		var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__checkVerify=off";
		window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
	}
}

//-->
</script>

</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')">
<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="__language" value ="<%=screen.getUProfile().get("lang")%>">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__calendar">
  <div align="center">
  <br>
    <table  cellpadding="0"  cellspacing="0">
      <tr > 
        <td  class="header"> 
		<script language="javascript">swapLang('Report Option');</script>&nbsp;</td>
      </tr>
      <tr > 
        <td  colspan="2"> 
          <div align="center"> 
            <table  cellpadding="0" cellspacing="0" >
              <tr> 
                <td colspan="2"  class="blankspace"></td>
              </tr>
              
				<tr>
					<td align="right" swlang code='SW000350'>Employee ID</td>
					<td>
						<input type="text" name="__condition$emp1" size="15" value="<%//=emp1%>">
							<a href="javascript:goHelp('MEMPLOYEEHELP','__condition$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="__condition$emp2" size="15" value="<%//=emp2%>">
							<a href="javascript:goHelp('MEMPLOYEEHELP','__condition$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>
					</td>
				</tr>
				<tr>
					<td align="right" swlang code='SW011708'>Period Group</td>
					<td>
						<input type="text" name="__condition$periodgroup" size="10" value="<%//=periodgroup%>">
						<a href="javascript:goHelp('MVACATION_PERIOD_GROUPHELP','__condition$periodgroup','')" 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>
					</td>
				</tr>
				<tr>
					<td align="right" swlang code='SW001331'>From</td>
					<td align="left" >
						<input type="text" name="__condition$start_period" size="2" value="<%//=start_period%>">
						<a href="javascript:goHelp('MVACATION_PERIODHELP','__condition$start_period','')" 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>
						<span swlang code="SW000002">Date</span><input type="text" name="__condition$start_period_date" size="1" value="<%//=start_period%>" readonly>
						<span swlang code="SW000800">Month</span><input type="text" name="__condition$start_period_month" size="1" value="<%//=start_period%>" readonly>
					</td>
				</tr>
				<tr>
					<td align="right" swlang code='SW005755'>To</td>
					<td align="left" >
						<input type="text" name="__condition$end_period" size="2" value="<%//=end_period%>">
						<a href="javascript:goHelp('MVACATION_PERIODHELP','__condition$end_period','')" 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>
						<span swlang code="SW000002">Date</span><input type="text" name="__condition$end_period_date" size="1" value="<%//=start_period%>" readonly>
						<span swlang code="SW000800">Month</span><input type="text" name="__condition$end_period_month" size="1" value="<%//=start_period%>" readonly>
					</td>
				</tr>
				<tr>
					<td align="right" swlang code='SW000717'>Year</td>
					<td align="left" >
						<input type="text" name="__condition$year_process" size="5" value="<%//=year_process%>">
					</td>
				</tr>
				<tr>
					<td><div align="right" swlang code='SW000300'>Leave Type</div></td>
					<td>
						<select name="__condition$eventgrp"> 
							<%
							while(inq.next()){
							%>		
								  <option value="<%=inq.getString("VAC_CODE")%>"
								  <%//=(eventgrp.equals(inq.getString("VAC_CODE")))?"selected":""%>>
								  <%=(screen.getUProfile().get("lang").equalsIgnoreCase("THA"))?inq.getString("TDESC"):inq.getString("EDESC")%></option>
							<%
								}
							%>
						</select>
					</td>
				</tr>
				<tr> 
					<%
						ListBox listbox1 = new ListBox();
						listbox1.setUProfile(screen.getUProfile());	
						listbox1.setName("groupby_vac"); //ชื่อ ListBox
						listbox1.setValidCode("GROUP_BY_VAC");	//tag Systemcode ที่เรียกใช้
					%>
					<td><div align="right" swlang code='SW000122'>Group By</div></td>
					<td ><%=listbox1.process()%></td>
				</tr>
			  
              <tr> 
                <td colspan="2" class="blankspace"></td>
              </tr>

							<tr>
								<td  class="buttonline" colspan="7"><div align="center">
									<button type="button" class="btn btn-primary width100" swlang code="SW013169" onClick="back();">OK</button>&nbsp;
									<button type="button" class="btn btn-primary width100" swlang code="SW006927" onClick="window.close();">CANCEL</button>
								</div>
								</td>
							</tr>
              <tr > 
                <td colspan="2" class="blankspace"></td>
              </tr>
            </table>
          </div></td>
      </tr>
      <tr bordercolor="0069B3"> 
        <td  class="bottom"></td>
      </tr>
    </table>
  </div>
<INPUT TYPE="hidden" NAME="__screen" VALUE="<%=request.getParameter("__screen")%>">
</form>
</body>
</html>