<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page import="com.csc.library.entry.*,com.csc.library.utilities.*,com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<%@ page import="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();
CheckNull chk=new CheckNull();
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();
DbInquiry cf_pos = new InitialInquiry(screen.getUProfile()).getDbInquiry("config_gohelp");
cf_pos.setColumn("*");
cf_pos.setFilter("config_id = '1'");
cf_pos.refresh();
cf_pos.next();
String cf_branch = cf_pos.getString("branch");
String cf_last_bu = cf_pos.getString("last_bu");
cf_pos.closeConnection();
%>
<html ng-app="myHR">
<head>
<title>ReportOption PRR183</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 src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script type="text/javascript" src="../JS/jquery-1.11.1.min.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(){
setData();
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);
}
}
}
}
window.close();
}
function setData(){
var mymonth1=month1.value;
var myyear1=year1.value;
var mymonth2=month2.value;
var myyear2=year2.value;
var date = new Date();
var firstDay = formatDate(new Date(myyear1, mymonth1-1, 1));
var lastDay = formatDate(new Date(myyear2, mymonth2, 0));
with(document.cscform){
//var branchsum = "";
var cf_branch = '<%=cf_branch%>';
var groupbu = __groupbu.value;
var orderby = "";
var receive = __receive.value;
if (cf_branch === "1") {
orderby = "branch";
}
/*if(__chkbranch.checked){
branchsum = "Tpy_his0.branch ";
}*/
if (groupbu !== "Tpy_his0.branch") {
var lastbu = groupbu.replace("Tpy_his0.bu", "");
for (var i = 1; i <= parseInt(lastbu); i++) {
orderby = chkOrderby(orderby) + "bu" + i;
}
}
orderby = chkOrderby(orderby) + "employeeid";
//__orderby.value = orderby;
__GROUPRELATION.value = cf_branch;
//__groupby.value = branchsum + groupbu;
__groupby.value = groupbu;
__groupbystd.value = groupbu;
__RECEIVE_TYPE.value = __receive.value;
__ST_DATE.value= firstDay;
__EN_DATE.value= lastDay;
__PERIOD_ST_DATE.value= firstDay;
__PERIOD_EN_DATE.value= lastDay;
__FILTERDATE.value= " gendate between '"+firstDay+"' and '"+lastDay+"'";
console.log(" gendate between '"+firstDay+"' and '"+lastDay+"'")
}
with(window.opener.document.cscform) {
var alienCondition = (document.cscform.__alien.value == -1) ? "'1','0'" : "'"+ document.cscform.__alien.value +"'";
__extraorderby.value = orderby;
__fixfiltermemployee.value=" employeeid in(select employeeid from memployee where receive = '" + receive + "' and alien in ("+ alienCondition + ")) and gendate between '"+firstDay+"' and '"+lastDay+"'";
//window.opener.document.cscform.__fixfiltertpy_his0.value="gendate between '"+firstDay+"' and '"+lastDay+"' ";
/*var filter_emp = "employeeid in(select employeeid from tpytran0) and receive = '" + receive + "' ";
__fixfiltermemployee.value = filter_emp;*/
}
window.close();
}
function formatDate(date) {
var d = new Date(date),
month = '' + (d.getMonth() + 1),
day = '' + d.getDate(),
year = d.getFullYear();
if (month.length < 2) month = '0' + month;
if (day.length < 2) day = '0' + day;
return [year, month, day].join('-');
}
function chkOrderby(orderby){
if(orderby !== ""){
orderby += ",";
}
return orderby;
}
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;
}
$(document).ready(function(){
with(document.cscform) {
document.getElementById("groupby_select").selectedIndex = "1";
}
});
//-->
</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">
<input type="hidden" name="__groupby">
<input type="hidden" name="__groupbystd">
<input type="hidden" name="__branchsum">
<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>
<%=screen.getTagComponent("columnlabel") %>
<tr>
<td class="columnlabel">Group By </td>
<td>
<select name="__groupbu" id="groupby_select">
<%
DbRecord recemp = new InitialRecord(screen.getUProfile()).getDbRecord("memployee");
if(cf_branch.equals("1")){
out.println("<option value='tpy_his0.branch'>"+recemp.getField("branch").getDescription()+"</option>");
}
int lastbu = chk.chkNullStringToInt(cf_last_bu.replaceAll("BU",""));
for(int i=1; i<=lastbu; i++){
out.println("<option value='tpy_his0.bu"+i+"'>"+recemp.getField("bu"+i).getDescription()+"</option>");
}
%>
</select>
</td>
</tr>
<tr>
<td class="columnlabel"><span swlang code="SW011788">Paid By</span> </td>
<td>
<select name="__receive">
<option value="B" swlang code="SW012801">Bank</option>
<option value="C" swlang code="SW012802">Cash</option>
</select>
</td>
</tr>
<tr>
<td class="columnlabel"><span swlang code="SW005097">สัญชาติ</span> </td>
<td>
<input type="radio" name="__alien" value="-1" checked="checked"> <span swlang code="SW002000">All</span>
<input type="radio" name="__alien" value="0"> <span swlang code="SW000840">Thai</span>
<input type="radio" name="__alien" value="1"> <span swlang code="SW012935">Alien</span>
</td>
</tr>
<!--<tr>
<td class="columnlabel"><span swlang code="SW012872">Branch Header</span> </td>
<td><input type="checkbox" name="__chkbranch" id="chkbranch"></td>
</tr>-->
<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="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>