<!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">&nbsp;&nbsp;มกราคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[0][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[0][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[0][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[0])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;กุมภาพันธ์</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[1][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[1][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[1][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[1])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;มีนาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[2][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[2][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[2][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[2])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;เมษายน</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[3][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[3][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[3][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[3])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[3])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;พฤษภาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[4][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[4][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[4][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[4])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[4])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;มิถุนายน</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[5][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[5][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[5][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[5])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[5])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;กรกฎาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[6][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[6][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[6][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[6])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[6])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;สิงหาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[7][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[7][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[7][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[7])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[7])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;กันยายน</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[8][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[8][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[8][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[8])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[8])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;ตุลาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[9][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[9][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[9][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[9])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[9])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;พฤศจิกายน</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[10][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[10][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[10][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[10])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[10])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td width="25%"><div align="left">&nbsp;&nbsp;ธันวาคม</div></td>			
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[11][0])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[11][1])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm2.format(data1[11][2])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(average[11])%>&nbsp;&nbsp;</div></td>
				<td  width="15%"><div align="right"><%=dmfm1.format(percent[11])%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td class="row1" width="25%"><div align="left">&nbsp;&nbsp;รวม</div></td>			
				<td class="row1" width="15%"><div align="right"><%=dmfm2.format(sumOut)%>&nbsp;&nbsp;</div></td>
				<td class="row1" width="15%"><div align="right"><%=dmfm2.format(sumIn)%>&nbsp;&nbsp;</div></td>
			</tr>
			<tr> 
				<td class="row1" width="25%"><div align="left">&nbsp;&nbsp;Turn Over Rate</div></td>			
				<td class="row1" width="15%"><div align="right"><%=dmfm1.format(TurnOverRate)%>&nbsp;%&nbsp;&nbsp;</div></td>
			</tr>
         </table>
	  </td>
	 </tr>
</table>
</form>
</body>
</html>