<%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.formula.*"%> <%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %> <%@page import="com.csc.library.timeattendance.MyBudgetYear" %> <%@page import="java.text.DecimalFormat,com.csc.library.utility.DHMConvert"%> <jsp:useBean id="TAU_ALLOWANCE" class="com.csc.library.system.Task" scope="page"/> <% try { ThaiUtilities thaicode = new ThaiUtilities(); DecimalFormat df = new DecimalFormat("#0.00"); CheckNull chk = new CheckNull(); FormulaString fs = new FormulaString(); DHMConvert dhm = new DHMConvert(); double dHourd = 8d; String empName = thaicode.ASCII2Unicode(chk.chkNullString(request.getParameter("__empName"))); String empID = thaicode.ASCII2Unicode(chk.chkNullString(request.getParameter("__empID"))); String yearid = chk.chkNullString(request.getParameter("__yearid"),"0"); String ldesc = thaicode.ASCII2Unicode(chk.chkNullString(request.getParameter("__ldesc"))); String fixcon = chk.chkNullString(request.getParameter("__fixCon"),"0"); TAU_ALLOWANCE.setChannel(request,response); HelpEntry screen = (HelpEntry) TAU_ALLOWANCE.process("HelpEntry","TAU_LVALLOWANCEHELP"); screen.referLangOff(); MyBudgetYear mby = new MyBudgetYear(screen.getUProfile()); CscCalendar cs[] = mby.getBudgetYearPeriod(Integer.parseInt(yearid)); if(!fixcon.equals("")){ screen.inq.setFilter(fixcon + " and dateid between '" + cs[0].getYYYYMMDD() + "' and '" + cs[1].getYYYYMMDD() + "'"); }else{ screen.inq.setFilter("employeeid = '"+ empID +"' and dateid between '" + cs[0].getYYYYMMDD() + "' and '" + cs[1].getYYYYMMDD() + "'"); } //out.print(fixcon + " and dateid between '" + cs[0].getYYYYMMDD() + "' and '" + cs[1].getYYYYMMDD() + "'"); screen.process(); DbRecord db = new InitialRecord(screen.getUProfile()).getDbRecord("Memployee"); db.setParam("rsc_skip", "true"); db.setColumn("employeeid,companyid,time0"); db.set("employeeid", empID); if(db.search()==1) { DbRecord dbMtime0 = new InitialRecord(screen.getUProfile()).getDbRecord("Mtime0"); dbMtime0.setColumn("time0,companyid,hour_d"); dbMtime0.set("time0id", db.getString("time0")); if(dbMtime0.search()==1){ System.out.print("Mtime0 found"); dHourd = dbMtime0.getDouble("hour_d"); }else{ System.out.print("!! Hourd not found " + empID); } }else{ System.out.print("!! Hourd not found " + empID); } %> <!DOCTYPE HTML> <html ng-app="myHR"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Employee View</title> <link rel="stylesheet" href="<%=request.getContextPath()%>/CSS/font-awesome.css"> <link rel="stylesheet" type="text/css" href="../CSS/Bootstrap/css/bootstrap.css" /> <link rel="stylesheet" type="text/css" href="../CSS/EMPVIEW_LAYOUT.min.css" /> <script type="text/javascript" src="../JS/SCREEN.js"></script> <script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script> <script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script> <script type="text/javascript" src="../JS/VIEWCALENDAR.js"></script> <script language="javascript"> <!-- setLang('<%=screen.getUProfile().get("lang")%>'); 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];} } //--> </script> </head> <body> <div class="bg-com"></div> <div class="container csc-content"> <form name="cscform" method="post" > <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden"name="__screen" value="TAU_ALLOWANCE"> <input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input name="__companyid" type="hidden" value='<%=screen.getUProfile().get("companyid")%>'> <input type="hidden" name="__employeeid" value="<%=empID%>"> <input type="hidden" name="__referPage" value=""> <input type="hidden" name="__childFilter"> <input type="hidden" name="__date_start" value="<%=cs[0].getYYYYMMDD()%>"> <input type="hidden" name="__date_end" value="<%=cs[1].getYYYYMMDD()%>"> <input type="hidden" name="date_start" value="<%=cs[0].getYYYYMMDD()%>"> <input type="hidden" name="date_end" value="<%=cs[0].getYYYYMMDD()%>"> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"> <input type="hidden" name="__gorec"> <div class="csc-block"> <div class="center"> <h3 class="csc-block-head">Leave allowance</h3> </div></br> <div class="row"> <div class="form-group"> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label label-right" swlang code='SW000274'>Employee ID</label> </div> <div class="col-md-2 col-sm-2 col-xs-2"> <label class="control-label"><%=empID%></label> </div> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label label-right" swlang code='SW000195'>Name</label> </div> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label"><%=empName%></label> </div> </div> </div> <div class="row"> <div class="form-group"> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label label-right" swlang code='SW005161'>Leave Description</label> </div> <div class="col-md-2 col-sm-2 col-xs-2"> <label class="control-label"><%=ldesc%></label> </div> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label label-right" swlang code='SW000702'>Date Between</label> </div> <div class="col-md-3 col-sm-3 col-xs-3"> <label class="control-label"><%=cs[0].getDDMMYYYY()%> - <%=cs[1].getDDMMYYYY()%></label> </div> </div> </div></br> </div> <table class="table table-head table-hover table-bordered table-title-left table-content-center"> <thead> <tr> <th swlang code='SW000193'>Seq</th> <th swlang code='SW001033'>Date</th> <th><label swlang code='SW000024'>Total</label> ( <label swlang code='SW011233'>HH MM</label> )</th> </tr> </thead> <tbody> <% screen.inq.first(); int i=0; while (screen.inq.next()) { i++; try { /* StringBuffer sb = new StringBuffer(); sb.append(new CscCalendar(screen.getString("start_date")).getDDMMYYYY()).append(" "); sb.append(df.format(Double.parseDouble(screen.getString("start_time")))); sb.append(" - "); sb.append(new CscCalendar(screen.getString("end_date")).getDDMMYYYY()).append(" "); sb.append(df.format(Double.parseDouble(screen.getString("end_time")))); */ %> <tr> <td><%=i%></td> <td><%=screen.getString("dateid")%></td> <td><%=dhm.MinToDHM(dhm.timeToMin(Double.parseDouble(screen.getString("hour"))), dHourd)%></td> </tr> <% }catch(Exception e){ e.printStackTrace(); } } %> </tbody> </table> <div class="center"> <a href="javascript:close();" class="btn btn-primary" swlang code='SW012104'>Close</a> </div> </form> </div> <% screen.referLangOff(); }catch(Exception e){ e.printStackTrace(); } %> </body> </html>