<!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> </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"> </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> <div id="export" class="btn btn-primary btn-sm" style="padding-top: 2px;"> <span class="glyphicon glyphicon-export"></span> Export </div> --> <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"> </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;"> </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>