<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*" %>
<%@page import="com.csc.library.utilities.*,com.csc.library.components.*,org.apache.commons.lang.StringUtils;"%>
<jsp:useBean id="PRU045" class="com.csc.library.system.Task" scope="page" />
<%

	response.setContentType("application/vnd.ms-excel; charset=UTF-8");
	response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");

	PRU045.setChannel(request,response);
	UIManager screen=(UIManager)PRU045.process("MultiEntry","PRU045");	
	MultiLine multi = screen.getMultiLine("MEMPL_TAXM");	
	screen.getTable("mempl_taxm").setKeyOff();
	multi.setLabelBox("check box");
	
	CheckNull chk= new CheckNull() ;
	
	String y = chk.chkNullString(request.getParameter("Yselect"),"2011");
	String mon = chk.chkNullString(request.getParameter("Mselect"));
	String empid = chk.chkNullString(request.getParameter("__employeeid"));
	String fixChild = "employeeid='" +empid+"' ";
	if(!mon.equals("")){
		fixChild += " and gendate like'"+y+"-"+mon+"%' ";	
	}else{
		fixChild += " and gendate like'"+y+"%' ";
	}
	//out.println(fixChild);
	screen.getTable("mempl_taxm").setFilter(fixChild);
	screen.getTable("mempl_taxm").setOrderBy("gendate,formula_type,formulaid");	
	screen.getRecord("memployee").refreshChild("mempl_taxm");
	multi.goFirst();
	String line;
	
%>

	<table border="0"  cellpadding="0" cellspacing="0"  width="100%" >
		<tr>
			<td align="center">รหัสสูตร</td>
			<td align="center">วันที่จ่ายเงิน</td>
			<td align="center">รายละเอียด</td>
			<td align="center">จำนวนเงิน</td>
			<td align="center">ภาษี</td>
			<td align="center">SOC</td>
			<td align="center">PVF</td>
		</tr>
    
					<%
					String formula_type;
					double sum=0,amounts;
					double sum_emp_soc=0;
					double sum_emp_pvf=0;
					double sum_cmp_soc=0;
					double sum_cmp_pvf=0;
					double sum_income=0;
					double sum_tot=0;
					double sum_tax=0;
					double netIncome=0;
					java.text.DecimalFormat df = new java.text.DecimalFormat("#,##0.00");
					for(int i=1;!multi.eof();multi.next(),i++)
					{ 
						multi.getTable().getCurrentRecordManager().referLangOn();
				%>
			<tr> 
				<td height="20" class="forborder2"><div align="left">&nbsp;<%=multi.getData("formulaid")%></div></td>
				<td class="forborder2" height="20" ><div align="center"><%=multi.getData("gendate")%></div></td>
				<td class="forborder2" height="20" ><div align="left">&nbsp;<%=multi.getData("mformula","tdesc")%></div></td>
				<td height="20" class="forborder2" >
					<div align="right">&nbsp;<%=(multi.getData("formula_type").equals("1")||multi.getData("formula_type").equals("D"))?"+":"-" %>&nbsp;<%=multi.getData("amount")%>&nbsp;&nbsp;&nbsp;</div>
				</td>
			    <td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("tax"), "3"))?"&#9679;":"" %></div></td>
			    <td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("calsoc"), "1"))?"&#9679;":"" %></div></td>
			    <td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("calpvf"), "1"))?"&#9679;":"" %></div></td>
			</tr>            
				<%
						amounts = multi.getTable().getCurrentRecordManager().getDouble("amount");
						formula_type = multi.getTable().getString("formula_type").trim();
						String tax= multi.getTable().getString("tax").trim();
						sum = sum+amounts;

						if ((formula_type.equalsIgnoreCase("1")||formula_type.equalsIgnoreCase("D")) && !tax.equalsIgnoreCase("0")) {			// รายได้ หรือ เงินชดเชย
							sum_income+=amounts;
							netIncome+=amounts;
						}else if (formula_type.equalsIgnoreCase("2") && !tax.equalsIgnoreCase("0")) {  // เงินหัก
							sum_income-=amounts;
							netIncome-=amounts;
						}else if (formula_type.equalsIgnoreCase("3")) {  // ภาษี
							sum_tax+=amounts;
							netIncome-=amounts;
						}else if (formula_type.equalsIgnoreCase("4")) {  // เงินสะสมพนักงาน
							sum_emp_pvf+=amounts;
							netIncome-=amounts;
						}else if (formula_type.equalsIgnoreCase("5")) {  // ประกันสังคมพนักงาน
							sum_emp_soc+=amounts;
							netIncome-=amounts;
						}else if (formula_type.equalsIgnoreCase("6")) {  // เงินสะสมบริษัท
							sum_cmp_pvf+=amounts;
						}else if (formula_type.equalsIgnoreCase("7")) {  // ประกันสังคมบริษัท
							sum_cmp_soc+=amounts;
						}else if (formula_type.equalsIgnoreCase("8")) {  // รายได้ภาษี 
							sum_income+=amounts;
							sum_tot+=amounts;
							netIncome+=amounts;
						}/*else if (formula_type==99) { // รายได้ภาษี

						}*/
						multi.getTable().getCurrentRecordManager().referLangOff();
					}
				%>
					  




 
	</table>