<!DOCTYPE html>
<%@page import="com.csc.library.utility.DHMConvert"%>
<%@page import="com.csc.library.session.InitialInquiry"%>
<%@page import="com.csc.library.session.DbInquiry"%>
<%@page import="com.csc.library.database.StaticProperties"%>
<%@page import="com.csc.library.utilities.CscCalendar"%>
<%@page import="com.csc.library.utilities.CheckNull"%>
<%@page import="com.csc.library.entry.HelpEntry"%>
<%@page contentType="text/html; charset=UTF-8"%>
<jsp:useBean id="RCR019_PDF" class="com.csc.library.system.Task" scope="page"/>
<%
  RCR019_PDF.setChannel(request,response);
  RCR019_PDF.checkProfile();
  HelpEntry screen = (HelpEntry) RCR019_PDF.process("HelpEntry","MEMPLOYEEHELP");
  screen.referLangOff();
  String lang = screen.getUProfile().get("lang");
  CheckNull chk = new CheckNull();
  CscCalendar cc = new CscCalendar();
  screen.setMaxLine(-1);
  
  String bu = chk.chkNullString(request.getParameter("bu"));
  String statusFirst = chk.chkNullString(request.getParameter("statusFirst"), "false");
  String search = chk.chkNullString(request.getParameter("search"), "MBU1");
  String empid = chk.chkNullString(request.getParameter("empid"));
  String fullname = chk.chkNullString(request.getParameter("fullname"));
  
  String filter = "status = 'A'";
  
  if (!bu.equals("")) {
  	String mbu = search.substring(1, search.length());
  	filter += " and " + mbu + " = '" + bu + "'";
  }
  if (!empid.equals("")) {
    filter += " and employeeid = '" + empid + "'";
  }
  
  screen.getInquiry().setFilter(filter);
  if (statusFirst.equals("true")) {
    screen.process();
  }

%>
<%!
  private String chkBlank(String val) {
	  return val.equals("")?"0:00:00":val;
  }

%>

<html lang="en">
  <head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <title></title>
    
    <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css">

    <!-- Bootstrap -->
    <link href="../CSS/bootstrap.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="js/html5shiv.min.js"></script>
      <script src="js/respond.min.js"></script>
    <![endif]-->
	  <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="../JS/jquery-1.11.3.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="../JS/bootstrap.min.js"></script>
    <script src='../JS/SCREEN.js'></script>
    <script src="../JS/VIEWCALENDAR.js"></script>
    <script>setLang('<%=lang%>');</script>
    <script src="../JS/SWAPLANG_FREEDOM.js"></script>
    <script>setLangSwapLang('<%=lang%>');</script>
    
    <style>
      .table-condensed > tbody > tr > td {
        padding: 4px;
        border: 0px solid #ddd;
      }
      
      img[height="20"] {
        padding: 0px;
      }
      
      .table-bordered th {
      	color: #ffffff;
      	text-align: center;
      	vertical-align: middle;
      	background-color: #336699;
      }
    </style>
	 
  </head>
  <body>
      <div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
      <script>initToolTips();</script>
      <form role="form" class="form-horizontal" id="cscform" name="cscform" method="post" action="RCR019_PDF.jsp">
        <!----------BEGIN CSC INITIAL ZONE ------------------------>
        <%=screen.InitialVariable()%>
        <!----------END CSC INITIAL ZONE -------------------------->
        <input type="hidden"name="__screen"  value="RCR019_PDF">
        <input type="hidden" name="__help" value="">
        <input type="hidden" name="__fixCon" value="">
        <input type="hidden" name="__cmd"  value="">
        <input type="hidden" name="__calendar"  value="">
        <input type="hidden" name="__language" value='<%=screen.getUProfile().get("lang")%>'>
        <input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
        <input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>">
        <input type="hidden" name="__referPage" value="">
        <input type="hidden" name="__goPage" value="">
        <input type="hidden" id="statusFirst" name="statusFirst" value="<%=statusFirst%>">
        <script>getInputFormatDate();</script>
        
        <div class="container">
	         <div class="col-sm-12">
	          <table class="table table-condensed">
	            <tbody>
	              <tr>
	                <td colspan="2" class="header"><script>swLang('PDF_EX002');</script>&nbsp;&nbsp;</td>
	              </tr>
	              <tr>
                  <td class="columnlabel"><script>swLang('SEARCH');</script></td>
                  <td>
                    <select id="search" name="search"></select>
                  </td>
                </tr>
	              <tr>
	                <td class="columnlabel"><script>swLang('SEARCH_BU');</script></td>
	                <td>
	                  <input type="text" id="bu" name="bu" value="<%=bu %>" size="10">
	                  <a href ="javascript:goHelp('MBU1HELP','bu');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
	                  <input type="text" id="buDesc" name="buDesc" value="<%=chk.chkNullString(request.getParameter("buDesc")) %>" size="35">
	                </td>
	              </tr>
	              <tr>
                  <td class="columnlabel">ค้นหาตามรหัสพนักงาน</td>
                  <td>
                    <input type="text" id="empid" name="empid" value="<%=empid %>" size="10">
                    <a href ="javascript:goHelp('MEMPLOYEEHELP','empid');" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emp_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" ALT="SEARCH" name="emp_image" width="20" height="20" border="0" style="vertical-align: middle"></a>
                    <input type="text" id="fullname" name="fullname" value="<%=chk.chkNullString(request.getParameter("fullname")) %>" size="35">
                  </td>
                </tr>
	              <tr><td colspan="2">&nbsp;</td></tr>
	              <tr>
	                <td colspan="2" style="text-align: center;">
	                  <!-- <div id="print" class="btn btn-primary btn-sm" style="padding-top: 2px;">
					            <span class="glyphicon glyphicon-print"></span> Print  
					          </div>&nbsp;&nbsp;
					          <div id="export" class="btn btn-primary btn-sm" style="padding-top: 2px;">
                      <span class="glyphicon glyphicon-export"></span> Export  
                    </div>&nbsp;&nbsp; -->
                    <div id="preview" class="btn btn-primary btn-sm" style="padding-top: 2px;">
                      <span class="glyphicon glyphicon-triangle-right"></span> Preview  
                    </div>
	                </td>
	              </tr>
	              <tr><td colspan="2">&nbsp;</td></tr>
	              <!-- <tr><td colspan="2" align="right"><%//=screen.getPageTag() %></td></tr>  -->
	              <tr><td colspan="2" class="bottom" style="padding-top: 0px; padding-bottom: 0px;">&nbsp;</td></tr>  
	            </tbody>
	          </table>
	          
          </div>
          <div class="clearfix"></div>
          <div class="col-sm-12">
          
          <img src="../IMAGES/loading2.gif" id="loading" style="margin-left: 40%">
          <%
          boolean firstRow = true;
          while (screen.nextRec() && statusFirst.equals("true")) {
          	
          	if (firstRow) {
              firstRow = false;
              %>
                <table class="table table-bordered">
                  <thead>
                    <tr>
                      <th rowspan="2" width="87px" style="vertical-align: middle;"><script>swLang("EMPLOYEEID");</script></th>
                      <th rowspan="2" width="200px" style="vertical-align: middle;"><script>swLang("NAME_SURNAME");</script></th>
                      <th rowspan="2" width="70px" style="vertical-align: middle;">ประเภทการลา</th>
                      <th rowspan="2" width="120px" style="vertical-align: middle;">รายละเอียด</th>
                      <th colspan="3" style="vertical-align: middle;">จำนวนวันที่ลามีสิทธิ</th>
                      <th colspan="2" style="vertical-align: middle;">วันที่ลาสะสมใช้ไป</th>
                    </tr>
                    <tr>
                      <th width="75px" style="vertical-align: middle;">ยอดยกมา</th>
                      <th width="70px" style="vertical-align: middle;">ปีปัจจุบัน</th>
                      <th width="70px" style="vertical-align: middle;">รวม</th>
                      <th width="70px" style="vertical-align: middle;">ที่ใช้ไป</th>
                      <th width="70px" style="vertical-align: middle;">คงเหลือ</th>
                    </tr>
                  </thead>
              <%
            }
            String vacation0 = "0:00:00";
            String vacation1 = "0:00:00";
            String hour_d = "0";

            DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");  
            inqEmp.setSchemaName(screen.getUProfile().getSchemaName());
            inqEmp.setColumn("employeeid, companyid, emp_level, vacation0, vacation1, time0");
            inqEmp.setFilter("employeeid='" + screen.getString("employeeid") + "'");
		//	out.print("<br>inqEmp :: "+inqEmp.getFilter());
            DbInquiry mp = new InitialInquiry(screen.getUProfile()).getDbInquiry("mtime0");
            mp.setColumn("hour_d");
            inqEmp.putChild(mp);
            inqEmp.refresh();
            if (inqEmp.next()){ 
              vacation0 = inqEmp.getString("vacation0");
              vacation1 = inqEmp.getString("vacation1");
              hour_d = inqEmp.getChild("mtime0").getString("hour_d");
            }
            
            String tmpVacation0 = vacation0;
            String tmpVacation1 = vacation1;
            
            String cFont = "";
            String c_limit = "";
            String c_used = "";
            String c_remain = "";
            String vacation1tmp = "";
            
            DbInquiry inq = new InitialInquiry(screen.getUProfile()).getDbInquiry("Meventgrp1");  
            inq.setSchemaName(screen.getUProfile().getSchemaName());
       //	inq.setFilter("display = '1' and (daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9') and eventgrpid in ('P0','S0','A0')");
            inq.setFilter("display = '1' and (daytype!='1' and daytype !='5' and daytype !='6' and daytype !='9')");
		//	out.print("<br>inq :: "+inq.getFilter());
            inq.setColumn("*");
            inq.setOrderBy("display_order");
            inq.refresh();
            
            String tmpEmp = "";
            while(inq.next()) {  
              
            	String a = "simmemployee_tadjtime0$"+ inq.getString("eventgrpid");
              String eventgrp = inq.getString("eventgrpid");
              String type = inq.getString("daytype");
              if (screen.inq.getString(a+"_remain").indexOf('-')>-1) {
                cFont = "error";
              } else cFont = "";

              c_limit = screen.inq.getString(a+"_limit");
              c_used = screen.inq.getString(a+"_used");
              c_remain = screen.inq.getString(a+"_remain");

              String list[] = {vacation0,vacation1,c_used,c_remain,vacation1tmp};

              if (type.equals("7")) {
                if (vacation0.equals("")) {
                  vacation0 = "00:00:00";
                }

                if (vacation1.equals("")) {
                  vacation1= "00:00:00";
                }
                list[0] = vacation0;
                list[1] = screen.inq.getString(a+"_used2");
              } else {
                list[0] = "";
                list[1] = c_limit;
              }
              
              DHMConvert dhm = new DHMConvert();
              int vaca0 = dhm.DHMToMin(vacation0, hour_d);
              int vaca1 = dhm.DHMToMin(vacation1, hour_d);
              String hourD = dhm.MinToDHM(vaca0 + vaca1, Double.parseDouble(hour_d));
              
              if (!eventgrp.equals("A0")) {
                list[0] = "0:00:00";
                list[4] = list[1];
              } else {
                list[4] = hourD;
              	list[1] = tmpVacation1;
              }
              
              %>
              <tbody>
                <tr>
                <%
                  if (!tmpEmp.equals(screen.getString("employeeid"))) { tmpEmp = screen.getString("employeeid");
                  %>
                    <td align="center"><%=screen.getString("employeeid") %></td>
                    <td align="center"><%=screen.getString("fullname") %></td>
                  <%
                  } else {
                  %>
                    <td></td>
                    <td></td>
                  <%
                  }
                %>

                  <td align="center"><%=eventgrp %></td>
                  <td align="center"><%=inq.getString("tdesc") %></td>
                  <td align="center"><%=list[0] %></td>
                  <td align="center"><%=chkBlank(list[1]) %></td>
                  <td align="center"><%=list[4] %></td>
                  <td align="center"><%=list[2] %></td>
                  <td align="center"><%=list[3] %></td>
                </tr>
              </tbody>
            
            <%}
            
            }%>
            </table>
            <script>$('#loading').hide();</script>
          </div>
         <!----------BEGIN CSC ENDING ZONE ------------------------>
         <%=screen.endJSP()%>
         <!----------END CSC ENDING ZONE -------------------------->
		    </div>
      </form>
    <script>
      function goHelp(helpName,inputName) {
        var helpReturn = "";
        if (inputName == 'bu') {
	        var $bu = $('#search').val();
	        var $num = $bu.slice(3);
	        helpReturn = inputName+":bu" + $num + "id,buDesc:tdesc";
	        helpName = $bu + "HELP";
        } else {
          helpReturn = inputName+":employeeid,fullname:fullname";
        }
        linkHelp_Return(helpName,helpReturn);
      }
      
      function getCondition() {
    	  var con = '';
    	  var $bu = $('#bu').val();
    	  if ($bu !== '') {
    		  var $buname = $('#search').val().substring(1, $('#search').val().length);
    		  con += "?bu=" + $bu + "&buname=" + $buname;
    	  }
    	  var $empid = $('#empid').val();
        if ($empid !== '') {
        	if ($bu === '') {
        		con += "?empid=" + $empid;
        	} else {
            con += "&empid=" + $empid;
        	}
        }
    	  return con;
      }
      
      $(function() {
    	  $('#search').append("<option value=MBU1>"+getSwapLang('BU1')+"</option><option value=MBU2>"+getSwapLang('BU2')+"</option><option value=MBU3>"+getSwapLang('BU3')+"</option><option value=MBU4>"+getSwapLang('BU4')+"</option><option value=MBU5>"+getSwapLang('BU5')+"</option>");
    	  $('#search').val('<%=search%>');
    	  
    	  $('#export').click(function() {
    		  window.open('EXCEL002.jsp' + getCondition());
    	  });
    	  
    	  $('#preview').click(function() {
    		  $('#statusFirst').val("true");
    		  $('#loading').show();
    		  $('#cscform').submit();
    	  });
    	  
    	  $('#print').click(function() {
    		  window.open('PDF002.jsp' + getCondition());
    	  });
      });
    </script>
  </body>
</html>