<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,java.text.DecimalFormat" %>
<%@page contentType="text/html; charset=UTF-8"%>
<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();
CscCalendar cs=new CscCalendar();
CscCalendar cDate = new CscCalendar();
String monthtxt="";
String cdate ="";
String month="";
String year ="";
// int dayS=1,dayE=1;
cdate=(cDate.getEngYYYY())+"-"+(Integer.parseInt(cDate.getMM())+1)+"-"+"01";
month = (Integer.parseInt(cDate.getMM())+1 )+"";
year = cDate.getEngYYYY()+"";
//cDate.incMonth(1);
monthtxt = cDate.getEngLongMonth().toUpperCase();
%>
<html>
<head>
<title>ReportOption PRR171</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 language='javascript' src='../JS/SCREEN.js'></script>
<script type='text/javascript' src='../JS/jquery-1.11.1.min.js'></script>
<script type='text/javascript' src='../JS/CscBase.js'></script>
<script language='javascript' src='../JS/CscCalendarV3.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript" type="text/JavaScript">
function back(){
var z=0;
with(document.cscform){
for(z=0;z<elements.length;z++){
if(elements[z].type.indexOf("select")>-1){
setParent(elements[z].name,elements[z].options[elements[z].selectedIndex].value);
}else {
if(elements[z].type.indexOf("radio")>-1){
if (elements[z].checked) {
setParent(elements[z].name, elements[z].value);
}
}else {
setParent(elements[z].name,elements[z].value);
}
}
}
var mymonth1=month1.value;
var myyear1=year1.value;
var mymonth2=month2.value;
var myyear2=year2.value;
var paymentdate = new CscCalendar().getDayOfMonth(mymonth2,myyear2);
var operatorselect = $('#operatorSelect').val();
var netincome = $('input[name=inputnetincome]').val();
netincome = parseFloat(netincome).toString();
var filternetincome = "";
if (netincome !== "") {
var dbo = '<%=screen.getUProfile().getDbType()%>' === "PGSQL" ? "" : "dbo.";
var fieldnetincome = dbo + "base64decoder(netincome)";
filternetincome = " and cast(case when " + fieldnetincome + " = '' then '0' else isnull(replace(" + fieldnetincome + ",',',''),'0') end as float) " + operatorselect + " " + netincome;
}
window.opener.document.cscform.__fixfiltermemployee.value=" employeeid in(select employeeid from tpy_his0 where gendate between '"+myyear1+"-"+mymonth1+"-01' and '"+myyear2+"-"+mymonth2+"-31'"+filternetincome+")";
//window.opener.document.cscform.__fixfiltertpy_his0.value="gendate between '"+myyear1+"-"+mymonth1+"-01' and '"+myyear2+"-"+mymonth2+"-31' ";
window.opener.document.cscform.__ST_DATE.value= myyear1+"-"+mymonth1+"-01";
window.opener.document.cscform.__EN_DATE.value= myyear2+"-"+mymonth2+"-01";
window.opener.document.cscform.__PERIOD_ST_DATE.value= myyear1+"-"+mymonth1+"-01";
window.opener.document.cscform.__PERIOD_EN_DATE.value= myyear2+"-"+mymonth2+"-"+paymentdate;
window.opener.document.cscform.__FILTERDATE.value= " gendate between '"+myyear1+"-"+mymonth1+"-01' and '"+myyear2+"-"+mymonth2+"-31' ";
}
window.close();
}
function setParent(inputName,inputValue){
with(window.opener.document.cscform){
for(var z=0;z<elements.length;z++){
if(elements[z].name==inputName){
if(elements[z].name=="__language"){
for(var k=0;k<__language.length;k++){
if(__language.options[k].value==inputValue){
__language.options[k].selected=true;
}
}
}else{
elements[z].value=inputValue;
}
}
}
}
}
function goHelp(helpName,inputName) {
var helpReturn;
if (inputName=="__codeid" ) {
helpReturn="__codeid:codeid,MLEAVE_REPORT@EDESC";
}
linkHelp_Return(helpName,helpReturn);
}
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");
}
}
function getYYYYMMDD(dd, dDate){
var splitdate = dd.split("-");
var size = splitdate.length;
var result = dd;
var msg = "Date is not in a valid format.";
//if(document.cscform.__language.value == "tha") msg = "รูปแบบวันที่ไม่ถูกต้อง";
if(size == 3){
result = "";
if(splitdate[0].length == 4 && splitdate[1].length == 2 && splitdate[2].length == 2){
return splitdate[0]+"-"+splitdate[1]+"-"+dDate;
}else{
return splitdate[2]+"-"+splitdate[1]+"-"+dDate;
}
result = result.substring(1,result.length);
}else{
alert(msg);
}
alert(result);
return result;
}
</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")%>">
<input type="hidden" name="__dateformat" value ="DD-MM-YYYY">
<input type="hidden" name="__calendar">
<div align="center">
<table cellpadding="0" cellspacing="0">
<tr >
<td class="header"> PRR171,
<script language="javascript">swapLang('Report Option');</script> </td>
</tr>
<tr >
<td colspan="2">
<div align="center">
<table cellpadding="0" cellspacing="0" >
<tr>
<td><div align="right"><script language="javascript">swapLang('เริ่มต้น :');</script> </div>
</td>
<td>
<script language="javascript">swapLang('Month');</script>
<select id="month1" name="month1">
<%
for(int i=0;i<12;i++){
%>
<option value="<%=new DecimalFormat("00").format(i+1).toString()%>" <%if(new CscCalendar().getMonth()==i){out.print("selected");}%> ><%=new DecimalFormat("00").format(i+1).toString()%></option>
<%
}
%>
</select> <script language="javascript">swapLang('Year');</script>
<input type="text" id="year1" name="year1" size="4" value="<%=new CscCalendar().getEngYYYY()%>">
</td>
</tr>
<tr>
<td><div align="right"><script language="javascript">swapLang('สิ้นสุด :');</script> </div>
</td>
<td>
<script language="javascript">swapLang('Month');</script>
<select id="month2" name="month2">
<%
for(int i=0;i<12;i++){
%>
<option value="<%=new DecimalFormat("00").format(i+1).toString()%>" <%if(new CscCalendar().getMonth()==i){out.print("selected");}%> ><%=new DecimalFormat("00").format(i+1).toString()%></option>
<%
}
%>
</select> <script language="javascript">swapLang('Year');</script>
<input type="text" id="year2" name="year2" size="4" value="<%=new CscCalendar().getEngYYYY()%>">
</td>
</tr>
<tr>
<td><div align="right">Netincome </div></td>
<td>
<select id="operatorSelect">
<option value="="><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"เท่ากับ":"Equal"%></option>
<option value="<>"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"ไม่เท่ากับ":"Not Equal"%></option>
<option value="<"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"น้อยกว่า":"Less"%></option>
<option value="<="><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"น้อยกว่าหรือเท่ากับ":"Less or Equal"%></option>
<option value=">"><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"มากกว่า":"Greater"%></option>
<option value=">="><%=screen.getUProfile().get("lang").equalsIgnoreCase("THA")?"มากกว่าหรือเท่ากับ":"Greater or Equal"%></option>
</select>
<input id="inputnetincome" name="inputnetincome" type="text" size="10" onkeypress="chkIntAndComma(event);">
</td>
</tr>
<%=screen.getTagComponent("columnlabel") %>
<tr >
<td height="13" 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="javascript:back()">OK</button>
<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>