<!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 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();
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>
<head>
<title>ReportOption EXPORTBANKKBK</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 language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript" type="text/JavaScript">
function back(){
with(document.cscform){
var sql ="";
sql = "employeeid in(select employeeid from tbank_tran0 where bankid !='CAH') and employeeid in(select employeeid from memployee where emp_type ='"+ __EMP_TYPE.value+"')" ;
console.log(sql);
}
window.opener.document.cscform.__fixfiltertbank_tran0.value = sql;
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;
}
}
}
}
}
// here
function setData(){
with(document.cscform){
var cf_branch = '<%=cf_branch%>';
var groupbu = __groupbu.value;
var orderby = "";
if(cf_branch === "1"){
orderby = "branch";
}
if(groupbu !== "memployee.branch"){
var lastbu = groupbu.replace("memployee.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 = groupbu;
}
}
function chkOrderby(orderby){
if(orderby !== ""){
orderby += ",";
}
return orderby;
}
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"/>
<input type="hidden" name="__groupby"/>
<input type="hidden" name="__orderby"/>
<div align="center">
<table cellpadding="0" cellspacing="0">
<tr>
<td class="header"> EXPORTBANKKBK, <script language="javascript">swapLang('Report Option');</script> </td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<table cellpadding="0" cellspacing="0">
<tr>
<td height="13" colspan="2" class="blankspace"></td>
</tr>
<%=screen.getTagComponent("columnlabel") %>
<tr>
<td class="columnlabel" swlang code='SW002408'>Employment Type </td>
<td>
<select name="__EMP_TYPE">
<%
DbInquiry de = new InitialInquiry(screen.getUProfile()).getDbInquiry("MEMPLOYMENT_TYPE");
de.setColumn("*");
de.refresh();
de.referLangOn();
while(de.next()){
%>
<option value="<%=de.getString("codeid")%>"><%=de.getString("tdesc")%></option>
<%
}
%>
</select>
</td>
</tr>
<!--
<tr>
<td class="columnlabel" swlang code='SW000865'>Salary Type </td>
<td>
<select name="emp_type">
<%
/*
DbInquiry ms = new InitialInquiry(screen.getUProfile()).getDbInquiry("MSALATYPE0");
ms.setColumn("*");
ms.refresh();
ms.referLangOn();
while(ms.next()){
*/
%>
<option value="<%//=ms.getString("codeid")%>"><%//=ms.getString("tdesc")%></option>
<%
//}
%>
</select>
</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>