<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <%@page contentType="text/html; charset=UTF-8"%> <%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*,java.text.DecimalFormat,com.csc.library.database.*"%> <%@page import="java.util.*,java.io.*"%> <jsp:useBean id="PRU195" class="com.csc.library.system.Task" scope="page" /> <% response.setContentType("application/vnd.ms-excel; UTF-8"); response.setHeader("Content-Disposition", "inline; filename=" + "export.xls"); PRU195.setChannel(request, response); HelpEntry screen = (HelpEntry) PRU195.process("HelpEntry","PRU195HELP"); CheckNull chk = new CheckNull(); CscCalendar c = new CscCalendar(); String thisYearSTR = String.valueOf(c.getYear()); String thisYearSTR1 = String.valueOf(c.getYear()+1); String lastYearSTR = String.valueOf(c.getYear()-1); int thisYear = c.getYear()+543; int lastYear = c.getYear()+542; String year = chk.chkNullString(request.getParameter("__year")); if(!year.equals("")){ thisYearSTR = year; thisYearSTR1 = String.valueOf(Double.parseDouble(year)+1); } DecimalFormat dmfm1 = new DecimalFormat("#,##0.00"); DecimalFormat dmfm2 = new DecimalFormat("#,###"); String sql_count = "select count(*) as count from mposition"; String sql = "SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-01-01' AND EFF_DATE < '"+thisYearSTR+"-02-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-01-01' AND EFF_DATE < '"+thisYearSTR+"-02-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-02-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-01-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-02-01' AND EFF_DATE < '"+thisYearSTR+"-03-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-02-01' AND EFF_DATE < '"+thisYearSTR+"-03-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-03-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-02-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-03-01' AND EFF_DATE < '"+thisYearSTR+"-04-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-03-01' AND EFF_DATE < '"+thisYearSTR+"-04-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-04-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-03-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-04-01' AND EFF_DATE < '"+thisYearSTR+"-05-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-04-01' AND EFF_DATE < '"+thisYearSTR+"-05-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-05-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-04-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-05-01' AND EFF_DATE < '"+thisYearSTR+"-06-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-05-01' AND EFF_DATE < '"+thisYearSTR+"-06-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-06-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-05-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-06-01' AND EFF_DATE < '"+thisYearSTR+"-07-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-06-01' AND EFF_DATE < '"+thisYearSTR+"-07-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-07-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-06-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-07-01' AND EFF_DATE < '"+thisYearSTR+"-08-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-07-01' AND EFF_DATE < '"+thisYearSTR+"-08-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-08-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-07-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-08-01' AND EFF_DATE < '"+thisYearSTR+"-09-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-08-01' AND EFF_DATE < '"+thisYearSTR+"-09-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-09-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-08-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-09-01' AND EFF_DATE < '"+thisYearSTR+"-10-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-09-01' AND EFF_DATE < '"+thisYearSTR+"-10-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-10-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-09-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-10-01' AND EFF_DATE < '"+thisYearSTR+"-11-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-10-01' AND EFF_DATE < '"+thisYearSTR+"-11-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-11-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-10-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-11-01' AND EFF_DATE < '"+thisYearSTR+"-12-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-11-01' AND EFF_DATE < '"+thisYearSTR+"-12-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-12-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-11-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT UNION ALL SELECT SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-12-01' AND EFF_DATE < '"+thisYearSTR1+"-01-01' AND EVENT ='-1' THEN 1 ELSE 0 END) AS \"OUT\", SUM(CASE WHEN EFF_DATE >='"+thisYearSTR+"-12-01' AND EFF_DATE < '"+thisYearSTR1+"-01-01' AND EVENT ='1' THEN 1 ELSE 0 END) AS \"IN\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR1+"-01-01' THEN EVENT ELSE 0 END) AS \"TOTAL\", SUM(CASE WHEN EFF_DATE < '"+thisYearSTR+"-12-01' THEN EVENT ELSE 0 END) AS \"AVR\" FROM MEMPL_MOVEMENT"; String dbName = screen.getUProfile().getDbName(); String tableName = "mempl_movement"; DataSet dataset1 = new DataSet(sql_count, dbName, tableName ); //หาจำนวนบรรทัด dataset1.initConnection(screen.getUProfile()); dataset1.next(); int index1 = chk.chkNullStringToInt(dataset1.getString("count")); dataset1.closeConnection(); dataset1.setSql(sql); // หา Record dataset1.initConnection(screen.getUProfile()); int row = 0; Double[][] data1 = new Double[index1][4]; Double[] lastYearAVR = new Double[index1]; Double[] thisYearAVR = new Double[index1]; int[] total = new int[25]; int notSum = 0; int month = c.getMonth(); Double[] average = new Double[index1] ; Double[] percent = new Double[index1] ; Double sumIn = 0.0; Double sumOut = 0.0; Double sumAVR = 0.0; Double TurnOverRate = 0.0; while(dataset1.next()){ data1[row][0] = Double.parseDouble(chk.chkNullString(dataset1.getString("out"),"0")); data1[row][1] = Double.parseDouble(chk.chkNullString(dataset1.getString("in"),"0")); data1[row][2] = Double.parseDouble(chk.chkNullString(dataset1.getString("total"),"0")); data1[row][3] = Double.parseDouble(chk.chkNullString(dataset1.getString("avr"),"0")); average[row] = (data1[row][2]+data1[row][3])/2 ; percent[row] = (data1[row][0]/average[row])*100; sumOut += data1[row][0]; sumIn += data1[row][1]; sumAVR += average[row]; row++; } sumAVR = sumAVR/12; TurnOverRate = (sumOut/sumAVR)*100; dataset1.closeConnection(); %> <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <style type="text/css"> body, td, th { font-size: 12px; font-family: Tahoma, "MS Sans Serif";} a { font-size: 12px; color: #3366CC; } a:link { text-decoration: underline; } a:active { color: #3366CC; } a:visited { color: #3366CC; text-decoration: underline; } a:hover { color: #3366cc; text-decoration: underline; } a img { border: 0 none; } a img#employeePic, a img.borderthin { border: 1px solid #000000; } img[height="20"] { padding: 2px; border: 0 none; } h1 { color: #000; font-size: 12px; font-weight: bold; } h2 { color: #000000; font-size: 12px; font-weight: bold; } h3 { color: #000000; font-size: 12px; font-weight: bold; } h4 { color: #ffffff; font-size: 12px; font-weight: bold; } input { margin: 0; padding: 0 2px; } select { margin: 0; padding: 0 0 0 2px; } textarea { margin: 0 0 2px 0; padding: 0 2px; } input:not([type]), input[type="color"], input[type="date"], input[type="datetime"], input[type="datetime-local"], input[type="email"], input[type="month"], input[type="number"], input[type="password"], input[type="tel"], input[type="text"], input[type="time"], input[type="url"], input[type="week"], textarea, select { border: 1px solid #ababab; color: #000000; } input:not([type]), input[type="color"], input[type="date"], input[type="datetime"], input[type="datetime-local"], input[type="email"], input[type="month"], input[type="number"], input[type="password"], input[type="tel"], input[type="text"], input[type="time"], input[type="url"], input[type="week"], select { height: 20px; } input:not([type]):disabled, input[type="color"]:disabled, input[type="date"]:disabled, input[type="datetime"]:disabled, input[type="datetime-local"]:disabled, input[type="email"]:disabled, input[type="month"]:disabled, input[type="password"]:disabled, input[type="number"]:disabled, input[type="search"]:disabled, input[type="tel"]:disabled, input[type="text"]:disabled, input[type="time"]:disabled, input[type="url"]:disabled, input[type="week"]:disabled, textarea:disabled, select:disabled { background-color: #ebebe4; } input[readonly], textarea[readonly], select[readonly] { background-color: #ebebe4; } input.numeric { text-align: right; } label.key { font-weight: bold; } div.centered { text-align: center; margin-left: auto; margin-right: auto; } div.centered table { margin: 0 auto; text-align: left; } table { width: 640px; } table.header { color: #ffffff; margin: 0; padding: 0; border: 0 none; } table.inner { color: #3366CC; margin: 0; padding: 0px; border: 0 none; } table.inner2 { color: #3366CC; margin: 0; padding: 0; border: 0px none; width:auto; } table.toolTip { border: 0 none; width: auto; background: #6699ff; } table.inframe { width: 100%; } table.maxsize { width: 100%; } table.largest1 { width: 99%; } table.large { width: 98%; } table.largest { width: 98%; } table.medium2 { width: 90%; } table.medium1 { width: 85%; } table.medium { width: 80%; } table.normal { width: 70%; } table.mini { width: 30%; } table.width500 { width: 500px; } table.withoutborder { border: 0px; } tr { margin: 0; padding: 0; color: #3366cc; border: 0; } tr.inframe { margin: 0; padding: 0; border: 0; height: 25px; color: #3366CC; vertical-align: baseline; } th { background-color: #006699; color: #3366CC; font-size: 12px; font-weight: bold; height: 22px } td { height: 22px; background-color: #efefef; border: 1px none #cccccc; color: #3366CC; } td.noborder { background: #efefef; font: normal 12px; color: #3366CC; border: none #efefef; margin: 0px; padding: 0px; } td.normal { background-color: #ffffff; font-size: 12px; color: #3366CC; height: 20px; border: 1px none #cccccc; vertical-align: baseline; } td.title1 { background: #cccccc; font-size: 12px; border: #cccccc; color: #000000; font-weight: normal; } td.header { color: #ffffff; font-weight: bold; background-color: #336699; text-align: right; height: 22px; border: none; } td.row1 { background: #3399cc; border: #cccccc; color: #000000; font-weight: bold; } td.row2 { background: #efefef; } td.row3 { background: #cccccc; font-weight: bold; } td.row4 { background: #efefef; color: #3366cc; } td.bottom { font-size: 12px; color: #ffffff; background-color: #336699; border: none; height: 10px; } td.blankspace { height: 10px; border: none; font-size: 1%; } td.blankspacenocolor { background-color: #ffffff; height:10px; border: none; } td.buttonline { margin: 0 auto; padding: 5px 0; background-color: #efefef; text-align: center; white-space: nowrap; } td.columnlabel { width: 150px; text-align: right; vertical-align: text-top; } td.columnlabel_baseline { width: 150px; text-align: right; vertical-align: baseline; } td.columnlabel_baseline_left { width: 150px; text-align: left; vertical-align: baseline; } td.columnlabelwidth { width: 200px; text-align: right; vertical-align: text-top; } td.columnlabel, td.columnlabel_baseline, td.columnlabel_baseline_left, td.columnlabelwidth { padding: 0 2px inherit 5px; background-color: #efefef; line-height: 22px; color: #3366CC; white-space: -webkit-nowrap; white-space: nowrap; } td.columnlabel label, td.columnlabel_baseline_left label, td.columnlabel_baseline label, td.columnlabelwidth label { white-space: nowrap; } /*html>body .columnlabel { width: auto; min-width: 150px; }*/ td.columnobject1 { color: #3366cc; background-color: #efefef; text-align: left; /*width: 488px;*/ width: auto; border: #cccccc; vertical-align: top; } td.columndata { color: #000000; } td.forborder { background-color: #efefef; font-size: 12px; color: #3366CC; height: 14px; border: 1px solid #cccccc; } td.forborder2 { background-color: #efefef; font-size: 12px; color: #3366cc; height: 14px; padding-left: 2px; padding-right: 2px; } td.error { font-size: 12px; color:#ff0000; font-weight: bold; text-align: left; height: 10px; width: 320px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; } td.warning { font-size: 12px; color:#0066cc; font-weight: bold; text-align: left; height: 10px; width: 320px; border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; } TABLE.maxsize1 { width: 700; cell-spacing:0; } .roverbutton { background-color: #efefef; height: 24px; vertical-align: top; } .error { color: #FF0000; } .dont { font-size: 12px; color: #ff0000; } .over { font-size: 12px; color: #00ff00; } .normal { font-size: 12px; color: #000000; } .warnning { font-size: 12px; color: #ff0000; } .errors {border:1px dotted #d21033; background:#fed url(../IMAGES/MSGERROR.gif) no-repeat 20px 18px; color:#d21033; padding-bottom: 40px;} .forgetpwd {border:1px dotted #0080C0; background:#efefef url(../IMAGES/MSGWARNING.gif) no-repeat 20px 18px; color:#000000; padding-bottom: 40px;} .msg_err {color: #FF0000;} .complete {border:1px dotted #00FF40; background:#EEFFDD url(../IMAGES/MSGCOMPLETE.gif) no-repeat 20px 18px; color:#0080C0; padding-bottom: 40px;} </style> <script language="JavaScript" src="../JS/SCREEN.js"></script> <script language="javascript">setLang('<%=screen.getUProfile().get("lang")%>');</script> <script language="JavaScript" type="text/JavaScript"> <!-- //--> function back(unit){ with(window.opener.document.cscform){ locateId.value =unit; } window.close(); } //--> function GoExport() { with( document.cscform) { //alert("Export"); __export.value = "1"; //target="_blank" action = "PRU195_EXP.jsp"; submit(); action = "PRU195.jsp"; } } function GoProcess(){ with( document.cscform){ submit(); } } </script> </head> <% String helpReturn=""; if(request.getParameter("__helpReturn")!=null){ helpReturn=request.getParameter("__helpReturn"); } String fieldSearch=""; if(request.getParameter("__fieldSearch")!=null){ fieldSearch=request.getParameter("__fieldSearch"); } %> <body leftmargin="0" topmargin="0"> <form name="cscform" method="post" action="PRU195.jsp"> <!----------BEGIN CSC INITIAL ZONE ------------------------> <%=screen.InitialVariable()%> <!----------END CSC INITIAL ZONE --------------------------> <input type="hidden" name="__cmd" value=""> <input type="hidden" name="__help" value=""> <input type="hidden" name="__goPage" value=""> <input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"> <input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>"> <input type="hidden" name="__helpReturn" value="<%=helpReturn%>"> <input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>"> <input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>"> <input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>"> <input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>"> <input type="hidden" name="__export" value=""> <div align="center"> <table height="" align="center" cellpadding="0" cellspacing="0" class="maxsize" border="1" width="100%"> <tr> <td> <table class="maxsize" border="0" cellpadding="0" cellspacing="1" cols=11 bgcolor="#CCCCCC"> <tr> <td class="row1" width="10%"><div align="center">เดือน</div></td> <td class="row1" width="10%"><div align="center">จำนวนพนักงานลาออก(คน)</script></div></td> <td class="row1" width="10%"><div align="center">พนักงานใหม่(คน)</div></td> <td class="row1" width="10%"><div align="center">อัตรากำลัง ณ สิ้นเดือน(คน)</div></td> <td class="row1" width="10%"><div align="center">อัตรากำลังคนเฉลี่ย ณ สิ้นเดือน(คน)</div></td> <td class="row1" width="10%"><div align="center">Turn Over Rate(%)</div></td> </tr> <tr> <td width="25%"><div align="left"> มกราคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[0][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[0][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[0][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[0])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[0])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> กุมภาพันธ์</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[1][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[1][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[1][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[1])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[1])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> มีนาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[2][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[2][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[2][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[2])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> เมษายน</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[3][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[3][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[3][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[3])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[3])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> พฤษภาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[4][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[4][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[4][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[4])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[4])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> มิถุนายน</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[5][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[5][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[5][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[5])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[5])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> กรกฎาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[6][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[6][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[6][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[6])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[6])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> สิงหาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[7][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[7][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[7][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[7])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[7])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> กันยายน</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[8][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[8][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[8][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[8])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[8])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> ตุลาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[9][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[9][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[9][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[9])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[9])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> พฤศจิกายน</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[10][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[10][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[10][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[10])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[10])%> % </div></td> </tr> <tr> <td width="25%"><div align="left"> ธันวาคม</div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[11][0])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[11][1])%> </div></td> <td width="15%"><div align="right"><%=dmfm2.format(data1[11][2])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(average[11])%> </div></td> <td width="15%"><div align="right"><%=dmfm1.format(percent[11])%> % </div></td> </tr> <tr> <td class="row1" width="25%"><div align="left"> รวม</div></td> <td class="row1" width="15%"><div align="right"><%=dmfm2.format(sumOut)%> </div></td> <td class="row1" width="15%"><div align="right"><%=dmfm2.format(sumIn)%> </div></td> </tr> <tr> <td class="row1" width="25%"><div align="left"> Turn Over Rate</div></td> <td class="row1" width="15%"><div align="right"><%=dmfm1.format(TurnOverRate)%> % </div></td> </tr> </table> </td> </tr> </table> </form> </body> </html>