<!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>&nbsp;</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 &nbsp;</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 &nbsp;</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>&nbsp;
          <button type="button" class="btn btn-primary width100" swlang code="SW006927" onClick="window.close()">CANCEL</button>&nbsp;
      </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>