<!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="PRR322_DHASOPTION_MID_H" scope="page" class="com.csc.library.system.Task"/>
<%
PRR322_DHASOPTION_MID_H.setChannel(request,response);
ReportEntry screen=null;
screen=(ReportEntry)PRR322_DHASOPTION_MID_H.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 salatype_period = __salatype_period.value;
var mygendate = myGendate.value.split("#")[0];
var mysalatype = myGendate.value.split("#")[1];
var mypaydate = myGendate.value.split("#")[2];
}
with(window.opener.document.cscform){
__fixfiltermemployee.value = "employeeid in (select employeeid from tpy_his1 where 0=0 and gendate='"+mygendate+"')";
__prgroup.value = myprgroup;
__mygendate.value = mygendate;
__mysalatype_count.value = mysalatype;
__mypaydate.value = mypaydate;
}
window.close();
}
function SearchMonthPeriod(year){
with(document.cscform){
yyyy.value = year;
submit();
}
}
</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" >
<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"> PRR322_DHAS, <span swlang code="SW000128">Report Option</span> </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.setBlank(true);
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> </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 DISTINCT TOP(24) PAY_DATE FROM MEMPL_SLIP WHERE EMPLOYEEID='"+screen.getUProfile().get("employeeid")+"' ORDER BY PAY_DATE DESC";
String SQL = "select end_date,pay_date from tpy_his0 where gendate like '"+chk.chkNullString(request.getParameter("yyyy"), new CscCalendar().getEngYYYY())+"%' and salatype in ('M01','M02') group by end_date,pay_date order by end_date,pay_date";
DataSet ds = new DataSet(SQL,screen.getUProfile().get("dbname"),"Memployee");
ds.initConnection(screen.getUProfile());
while(ds.next()){
out.print("<option value='"+ds.getString("end_date")+"#1#"+ds.getString("pay_date")+"'>"+ds.getString("end_date")+"</option>");
}
ds.closeConnection();
%>
</select>
<%//out.print("SQL >>> "+SQL);%>
<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>
<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>