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

UProfile mypro = null;

if (session !=null){
	mypro = (UProfile)session.getAttribute("userprofile");
}
CscCalendar cs = new CscCalendar();

DbInquiry salatype = new InitialInquiry(screen.getUProfile()).getDbInquiry("msalatype1");
salatype.setColumn("*");
salatype.setFilter("codeid = 'M01' and end_date in (select gendate from tpytran0)");
salatype.refresh();
salatype.referLangOff();
salatype.next();
%>
<html ng-app="myHR">
	<head>
		<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 language='javascript' src='../JS/SCREEN.js'></script>
		<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
		<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
		<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
		<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
		<script type="text/javascript" src="../JS/EMPVIEW_FUNC.js"></script>
		<script src="../JS/VIEWCALENDAR.js"></script>
		<script type="text/javascript">
		function back(){
			with(document.cscform){
				var myprgroup = __prgroup.value;
				var myperiod = myGendate.value.split("#")[0];
				var mygendate = myGendate.value.split("#")[1];
				var mypaydate = myGendate.value.split("#")[2];
				var myperiodseq = myGendate.value.split("#")[3];
				var myyears = mygendate.split("-")[0];
				var mymonths = mygendate.split("-")[1];

				var tabledata = "tpytran0";
				if(myperiod === "HISTORY") {
					tabledata = "tpy_his0";
				}
			}
			with(window.opener.document.cscform){
				__fixfiltermemployee.value = "employeeid in (select employeeid from "+tabledata+" where gendate='"+mygendate+"') and salatype in ('M01','M02')";
				__PRGCODE.value = myprgroup;
				__PERIOD.value = myperiod;
				__GENDATE.value = mygendate;
				__ROUND.value = mypaydate;
				__PERIODSEQ.value = myperiodseq;
				__YEARS.value = myyears;
				__MONTHS.value = mymonths;
			}
			window.close();
		}

		function SearchMonthPeriod(year){
			with(document.cscform){
				yyyy.value = year;
				submit();
			}
		}
		</script>
	</head>
	<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
		<form name="cscform" method="post">
			<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"/>
			<input type="hidden" name="yyyy" value="<%=chk.chkNullString(request.getParameter("yyyy"),	new CscCalendar().getEngYYYY())%>"/>
			<input type="hidden" name="__salatype_period" value="<%=salatype.getString("period_seq")%>"/>
			<center>
				<table cellpadding="0"  cellspacing="0">
					<tr>
						<td class="header"> EPAYSLIP_DHAS, <span swlang code="SW000128">Report Option</span>&nbsp;</td>
					</tr>
					<tr>
						<td colspan="2" align="center">
							<table cellpadding="0" cellspacing="0" >
								<tr>
									<td height="12" colspan="2" class="blankspace"></td>
								</tr>
								<tr>
									<%
									ListBox listbox1 = new ListBox();
									listbox1.setUProfile(screen.getUProfile());
									listbox1.setName("prgroup"); //ชื่อ ListBox
									listbox1.setTable("PAYROLL_GROUPHELP", "CODEID", "PAYROLL_DESC", "", "CODEID",screen.getUProfile().get("lang"));
									listbox1.setChecked(chk.chkNullString(request.getParameter("__prgroup")));
									%>
									<td align="right" style="width:200px"><span>Payroll Group</span>&nbsp;</td>
									<td ><%=listbox1.process()%></td>
								</tr>
								<tr>
									<td><div align="right"><script language="javascript">swapLang("Pay Slip ประจำเดือน : ");</script></div></td>
									<td>
										<select name="myGendate" id="myGendate">
											<%
											int yy=	new CscCalendar().getYear();
											String SQL = "select gendate, paydate, period, PERIOD_SEQ from MEPAYSLIP_CONFIG where gendate like '"+chk.chkNullString(request.getParameter("yyyy"), new CscCalendar().getEngYYYY())+"%' and salatype in ('M01','M02') and showslip = '1' GROUP BY gendate, paydate, period, PERIOD_SEQ ORDER BY gendate, paydate";

											DataSet ds = new DataSet(SQL,screen.getUProfile().get("dbname"),"Memployee");
											ds.initConnection(screen.getUProfile());
											while(ds.next()){
												out.print("<option value='"+ds.getString("period")+"#"+ds.getString("gendate")+"#"+ds.getString("paydate")+"#"+ds.getString("period_seq")+"'>"+ds.getString("gendate")+"</option>");
											}
											ds.closeConnection();
											%>
										</select>&nbsp;&nbsp;&nbsp;&nbsp;
										<script language="javascript">swapLang("ปี : ");</script>
										<select name="years" onchange="SearchMonthPeriod(this.value);">
										<%
										CscCalendar csm = new CscCalendar();
										csm.decYear(5);
										for(int i=csm.getYear();i<=new CscCalendar().getYear();i++){
											%>
											<option value="<%=i%>" <%if(i==Integer.parseInt(chk.chkNullString(request.getParameter("years"),String.valueOf(yy)))) {%>SELECTED<%}%>>
												<%=(screen.getUProfile().get("lang").equalsIgnoreCase("tha")?csm.getThaiYYYY():String.valueOf(csm.getYear()))%>
											</option>
											<%
											csm.incYear(1);
										}
										%>
										</select>
									</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>
						</table>
					</td>
				</tr>
				<tr>
					<td colspan="2" class="blankspace"></td>
				</tr>
				<tr bordercolor="0069B3">
					<td  class="bottom"></td>
				</tr>
			</table>
		</center>
		</form>
	</body>
</html>