Payroll_Report_intelligence003_EXPORT.jsp

<%@page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*" %>
<%@ page import="java.text.*" %>
<%@ page import="com.csc.library.utilities.*, java.util.*" %>
<%@page import="com.csc.library.database.*"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<%
	response.setContentType("application/vnd.ms-excel; UTF-8");
	response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");
	DecimalFormat df = new DecimalFormat("####.00");
	CheckNull chk = new CheckNull();
	CscCalendar cs = new CscCalendar();
	int year = Integer.parseInt(chk.chkNullString(request.getParameter("__year"),cs.getYear()+543+""));
	int last_year = year-1;
	int loop_month = 12;
	if(year==cs.getYear()){
		loop_month = cs.getCurrentMonth();
	}
%>
<%!
public String genEmpSalary(UProfile uprofile,int year){
		DecimalFormat df = new DecimalFormat("####.00");
		CheckNull chk = new CheckNull();
		CscCalendar cs = new CscCalendar();
		int loop_month = 12;
		if(year==cs.getYear()){
			loop_month = cs.getCurrentMonth();
		}

		/***************			Append SQL & Header		*****************/
		StringBuffer sb_group = new StringBuffer().append("ค่าเฉลี่ยเงินเดือน<table  cellpadding='0'  cellspacing='0' style='width:100%;'><tr>");
		StringBuffer sql = new StringBuffer();
		Map<Integer, StringBuffer> map = new HashMap<Integer, StringBuffer>();
		Map<Integer, Integer> map_sum1 = new HashMap<Integer, Integer>();
		Map<Integer, Double> map_sum2 = new HashMap<Integer, Double>();
		Map<Integer, Double> map_sum3 = new HashMap<Integer, Double>();
		map.put(0,new StringBuffer().append("<td><table style='width:100%;height:100%;min-width:150px;'><tr ><td style='border-top:1px solid black;'></td></tr><tr align='center'><td style='border-right:1px solid black;border-left:1px solid black;border-bottom:1px solid black;'>ตำแหน่ง</td></tr>"));
		sql.append("select positionid,");
		for(int i=1;i<=loop_month;i++){
			String month = i+"";
			if(i<10){
				month = "0"+i;
			}
			CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
			StringBuffer m_desc = new StringBuffer();
			m_desc.append("<td><table style='width:100%;height:100%;min-width:300px;'><tr align='center'><td class='report_header' colspan='3' rowspan='1'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td></tr>");
			m_desc.append("<tr >");
			m_desc.append("<td class='report_header' colspan='1' rowspan='1' align='center'>จำนวนพนักงาน</td>");
			m_desc.append("<td class='report_header' colspan='1' rowspan='1' align='center'>เงินเดือนค่าจ้าง</td>");
			m_desc.append("<td class='report_header' colspan='1' rowspan='1' align='center'>ค่าเฉลี่ยเงินเดือน</td>");
			m_desc.append("</tr>");
			map.put(i,m_desc);
			map_sum1.put(i,0);
			map_sum2.put(i,0.00);
			map_sum3.put(i,0.00);

			sql.append("dbo.pr003_getNumEmp('"+year+"-"+month+"-31',positionid) as 'numEmp"+month+"',");
			sql.append("dbo.pr003_getSalary('"+year+"-"+month+"-31',positionid) as 'salary"+month+"',");
		}
		sql.append("tdesc ");
		sql.append("from mposition ");
		sql.append("where positionid in (select emp_position from mempl_movement where event=1 and eff_date <='"+year+"-12-31' group by emp_position)");
		/***************			Append SQL & Header		*****************/


		/***************				Append Detail				*****************/
		DataSet ds = new DataSet(sql.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{
			ds.initConnection(uprofile);
		}catch(Exception e){}
		int run_num = 0;
		while(ds.next()){
			StringBuffer sb_head = map.get(0);
			sb_head.append("<tr ><td colspan='1' rowspan='1' class='report_detail'>"+ds.getString("tdesc")+"</td></tr>");
			map.put(0,sb_head);
			for(int i=1;i<=loop_month;i++){
				String month = i+"";
				double AVG_Salary =0.00;
				String print_AVG_Salary ="";
				if(i<10){
					month = "0"+i;
				}
				if(Integer.parseInt(chk.chkNullString(ds.getString("numemp"+month),"0"))>0){
					AVG_Salary = Double.parseDouble(ds.getString("salary"+month))/Integer.parseInt(ds.getString("numemp"+month));
				}
				if(AVG_Salary==0.00){
					print_AVG_Salary = "0.00";
				}else{
					print_AVG_Salary = df.format(AVG_Salary);
				}
				StringBuffer sb_detail = map.get(i);
				int Summary1 = map_sum1.get(i);
				double Summary2 = map_sum2.get(i);
				double Summary3 = map_sum3.get(i);
				sb_detail.append("<tr >");
				sb_detail.append("<td colspan='1' rowspan='1' class='report_detail' align='center'>"+chk.chkNullString(ds.getString("numemp"+month),"0")+"</td>");
				sb_detail.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+chk.chkNullString(ds.getString("salary"+month),"0.00")+"</td>");
				sb_detail.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+print_AVG_Salary+"</td>");
				sb_detail.append("</tr >");

				Summary1+= chk.chkNullStringToInt(ds.getString("numemp"+month));
				Summary2+= chk.chkNullStringToDouble(ds.getString("salary"+month));
				Summary3+= chk.chkNullStringToDouble(df.format(AVG_Salary));

				map.put(i,sb_detail);
				map_sum1.put(i,Summary1);
				map_sum2.put(i,Summary2);
				map_sum3.put(i,Summary3);
			}
		}
		ds.closeConnection();
		/***************				Append Detail				*****************/

		/***************				Append Summary & Footer			*****************/
		StringBuffer sb_head_end = map.get(0);
		sb_head_end.append("<tr><td colspan='1' rowspan='1' class='report_detail'>Grand Total</td></tr>");
		sb_head_end.append("</table></td>");
		map.put(0,sb_head_end);
		sb_group.append(map.get(0));
		for(int i=1;i<=loop_month;i++){
			StringBuffer sb_detail_end = map.get(i);
			sb_detail_end.append("<tr >");
			sb_detail_end.append("<td colspan='1' rowspan='1' class='report_detail' align='center'>"+map_sum1.get(i)+"</td>");
			sb_detail_end.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+df.format(map_sum2.get(i))+"</td>");
			sb_detail_end.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+df.format(map_sum3.get(i))+"</td>");
			sb_detail_end.append("</tr >");
			sb_detail_end.append("</table></td>");
			map.put(i,sb_detail_end);
			sb_group.append(map.get(i));
		}
		sb_group.append("</td></tr></table>");
		/***************				Append Summary & Footer			*****************/

	return sb_group.toString();
}

public String genEmpAge(UProfile uprofile,int year){
		DecimalFormat df = new DecimalFormat("####.00");
		CheckNull chk = new CheckNull();
		CscCalendar cs = new CscCalendar();
		int loop_month = 12;
		if(year==cs.getYear()){
			loop_month = cs.getCurrentMonth();
		}

		/***************			Append SQL & Header		*****************/
		StringBuffer sb_group = new StringBuffer().append("อายุเฉลี่ยพนักงาน<table  cellpadding='0'  cellspacing='0' style='width:100%;'><tr>");
		StringBuffer sql = new StringBuffer();
		Map<Integer, StringBuffer> map = new HashMap<Integer, StringBuffer>();
		Map<Integer, Integer> map_sum1 = new HashMap<Integer, Integer>();
		Map<Integer, Double> map_sum2 = new HashMap<Integer, Double>();
		map.put(0,new StringBuffer().append("<td><table style='width:100%;height:100%;min-width:150px;'><tr ><td style='border-top:1px solid black;'></td></tr><tr align='center'><td style='border-right:1px solid black;border-left:1px solid black;border-bottom:1px solid black;'>เพศ</td></tr>"));
		sql.append("select ");
		for(int i=1;i<=loop_month;i++){
			String month = i+"";
			if(i<10){
				month = "0"+i;
			}
			CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
			StringBuffer m_desc = new StringBuffer();
			m_desc.append("<td><table style='width:100%;height:100%;min-width:300px;'><tr align='center'><td class='report_header' colspan='2' rowspan='1'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td></tr>");
			m_desc.append("<tr >");
			m_desc.append("<td class='report_header' colspan='1' rowspan='1' align='center'>จำนวนพนักงาน</td>");
			m_desc.append("<td class='report_header' colspan='1' rowspan='1' align='center'>อายุเฉลี่ย</td>");
			m_desc.append("</tr>");
			map.put(i,m_desc);
			map_sum1.put(i,0);
			map_sum2.put(i,0.00);
			
			String eom = year+"-"+month+"-"+cs1.getEndDateOfMonth(); //End date of month YYYY-MM-DD
			sql.append("dbo.pr003_getNumEmp_Sex('"+eom+"',sex) as 'numEmp"+month+"',");
			sql.append("dbo.pr003_getAvg_Age('"+eom+"',sex) as 'AVG_AGE"+month+"',");
		}
		sql.append("sex ");
		sql.append("from memployee ");
		sql.append("group by sex");
		/***************			Append SQL & Header		*****************/


		/***************				Append Detail				*****************/
		DataSet ds = new DataSet(sql.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{
			ds.initConnection(uprofile);
		}catch(Exception e){}
		int run_num = 0;
		while(ds.next()){
			StringBuffer sb_head = map.get(0);
			String sex ="";
			if(ds.getString("sex").equals("1")){
				sex = "ชาย";
			}else if(ds.getString("sex").equals("2")){
				sex = "หญิง";
			}
			sb_head.append("<tr ><td colspan='1' rowspan='1' class='report_detail'>"+sex+"</td></tr>");
			map.put(0,sb_head);
			for(int i=1;i<=loop_month;i++){
				String month = i+"";
				if(i<10){
					month = "0"+i;
				}

				StringBuffer sb_detail = map.get(i);
				int Summary1 = map_sum1.get(i);
				double Summary2 = map_sum2.get(i);
				sb_detail.append("<tr >");
				sb_detail.append("<td colspan='1' rowspan='1' class='report_detail' align='center'>"+chk.chkNullString(ds.getString("numemp"+month),"0")+"</td>");
				sb_detail.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+df.format(chk.chkNullStringToDouble(ds.getString("avg_age"+month)))+"</td>");
				sb_detail.append("</tr >");

				Summary1+= chk.chkNullStringToInt(ds.getString("numemp"+month));
				Summary2+= chk.chkNullStringToDouble(ds.getString("avg_age"+month));

				map.put(i,sb_detail);
				map_sum1.put(i,Summary1);
				map_sum2.put(i,Summary2);
			}
		}
		ds.closeConnection();
		/***************				Append Detail				*****************/

		/***************				Append Summary & Footer			*****************/
		StringBuffer sb_head_end = map.get(0);
		sb_head_end.append("<tr><td colspan='1' rowspan='1' class='report_detail'>Grand Total</td></tr>");
		sb_head_end.append("</table></td>");
		map.put(0,sb_head_end);
		sb_group.append(map.get(0));
		for(int i=1;i<=loop_month;i++){
			StringBuffer sb_detail_end = map.get(i);
			sb_detail_end.append("<tr >");
			sb_detail_end.append("<td colspan='1' rowspan='1' class='report_detail' align='center'>"+map_sum1.get(i)+"</td>");
			sb_detail_end.append("<td colspan='1' rowspan='1' class='report_detail' align='right'>"+df.format(map_sum2.get(i))+"</td>");
			sb_detail_end.append("</tr >");
			sb_detail_end.append("</table></td>");
			map.put(i,sb_detail_end);
			sb_group.append(map.get(i));
		}
		sb_group.append("</td></tr></table>");
		/***************				Append Summary & Footer			*****************/

	return sb_group.toString();
}

public String genEmpAge_List(UProfile uprofile,int year){
	DecimalFormat df = new DecimalFormat("####.00");
	CheckNull chk = new CheckNull();
	CscCalendar cs = new CscCalendar();
	int loop_month = 12;
	if(year==cs.getYear()){
		loop_month = cs.getCurrentMonth();
	}
	StringBuffer sb_group = new StringBuffer();
	StringBuffer sb_detail1 = new StringBuffer();
	String[] Age_list = {"20-30","31-40","41-50","51-60","20-60"};
	Map<Integer,String> map = new HashMap<Integer,String>();
	String sql ="select mov.emp_position,po.tdesc from mempl_movement mov left join mposition po on po.positionid=mov.emp_position where event=1 and eff_date <='"+year+"-12-31' group by emp_position,tdesc";
	for(int i=1;i<=loop_month;i++){
		String sql_inner = "select ";
		String month = i+"";
		if(i<10){
			month = "0"+i;
		}
		CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
		String eom = year+"-"+month+"-"+cs1.getEndDateOfMonth(); //End date of month YYYY-MM-DD
		int run_num = 1;
		DataSet ds = new DataSet(sql.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds.initConnection(uprofile);}catch(Exception e){}
		sb_detail1 =new StringBuffer();
		sb_detail1.append("<tr>");
		while(ds.next()){
			sb_detail1.append("<td class='report_detail' style='text-align:center;'>"+ds.getString("tdesc")+"</td>");
			map.put(run_num,ds.getString("emp_position"));
			sql_inner +="dbo.pr003_getAge_By_Part('"+eom+"','"+ds.getString("emp_position")+"',$datepart0$,$datepart1$) as 'age"+run_num+"',";
			run_num++;
		}
		ds.closeConnection();
		sb_detail1.append("<td class='report_detail' style='text-align:center;'>Grand Total</td></tr>");
		sb_group.append(	"<BR/>จำนวนพนักงานตามช่วงอายุ<table style=''><tr>"+
									"<td class='report_detail' rowspan='2' colspan='1' style='text-align:center;'>ช่วงอายุ(ปี)</td>"+
									"<td class='report_detail' align='center' rowspan='1' colspan='"+run_num+"'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td></tr>");
		sb_group.append(sb_detail1);

		for(int j=0;j<Age_list.length;j++){
			String sql_inner_temp = sql_inner;
			String datepart[] = Age_list[j].toString().split("-");
			String desc ="";
			int temp = 0;
			if(j==Age_list.length-1){
				desc ="รวม";
			}else{
				desc = Age_list[j];
			}
			sb_detail1 =new StringBuffer().append("<tr>");
			sb_detail1.append("<td class='report_detail' style='text-align:center;'>"+desc+"</td>");
			sql_inner_temp = sql_inner_temp.replaceAll("\\$datepart0\\$",datepart[0]);
			sql_inner_temp = sql_inner_temp.replaceAll("\\$datepart1\\$",datepart[1]);
			sql_inner_temp = sql_inner_temp.substring(0,sql_inner_temp.length()-1);
			DataSet ds_inner = new DataSet(sql_inner_temp,uprofile.get("dbname"),"MEMPLOYEE");
			try{ds_inner.initConnection(uprofile);}catch(Exception e){}
			if(ds_inner.next()){
				for(int v=0;v<ds_inner.getFieldList().size();v++){
					sb_detail1.append("<td class='report_detail' style='text-align:center;'>"+ds_inner.getString(ds_inner.getFieldList().get(v).toString())+"</td>");
					temp += chk.chkNullStringToInt(ds_inner.getString(ds_inner.getFieldList().get(v).toString()));
				}
			}
			ds_inner.closeConnection();
			sb_detail1.append("<td class='report_detail' style='text-align:center;'>"+temp+"</td>");
			sb_detail1.append("</tr>");
			sb_group.append(sb_detail1);
		}
		sb_group.append("</table>");
	}
	return sb_group.toString();
}

public String genEmpEdu(UProfile uprofile,int year){
		DecimalFormat df = new DecimalFormat("####.00");
		CheckNull chk = new CheckNull();
		CscCalendar cs = new CscCalendar();
		String[] Degree_Level = {"8$ปริญญาโท","7$ปริญญาตรี","6$ป.ว.ส.","4$ป.ว.ช./ม.6","<=4$ต่ำกว่า ป.ว.ช.","<=8$รวม"};
		int loop_month = 12;
		if(year==cs.getYear()){
			loop_month = cs.getCurrentMonth();
		}
		/***************			Append SQL & Header		*****************/
		StringBuffer sb_group = new StringBuffer().append("โครงสร้างกำลังคนจำแนกตามระดับการศึกษา<table  cellpadding='0'  cellspacing='0' style='width:100%;'>");
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' rowspan='2' colspan='1'>วุฒิการศึกษา</td>");
		for(int a=1;a<=loop_month;a++){
			String month = a+"";
			if(a<10){month="0"+a;}
			CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
			sb_group.append("<td class='report_detail' rowspan='1' colspan='2' style='text-align:center;'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td>");
		}
		sb_group.append("</tr>");
		sb_group.append("<tr>");
		for(int b=1;b<=loop_month;b++){
			sb_group.append("<td class='report_detail' style='text-align:center;'>จำนวนพนักงาน</td>");
			sb_group.append("<td class='report_detail' style='text-align:center;'>%</td>");
		}
		sb_group.append("</tr>");
		/***************			Append SQL & Header		*****************/
		
		for(int i=1;i<Degree_Level.length;i++){
			StringBuffer sql = new StringBuffer().append("select ");
			for(int a=1;a<=loop_month;a++){
				String[] temp =Degree_Level[i].split("\\$");
				String level = temp[0];
				String desc = temp[1];
				String operator ="";
				if(level.length()>1){
					operator=level.substring(0,2);
					level = level.substring(2,3);
				}
				String month = a+"";
				if(a<10){month="0"+a;}
				CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
				String eom = year+"-"+month+"-"+cs1.getEndDateOfMonth(); //End date of month YYYY-MM-DD
				if(a==1){
					sql.append("'"+desc+"' as desc1,");
				}
				sql.append("dbo.pr003_getNumEmp_Degree('"+eom+"','"+level+"','"+operator+"') as 'num"+a+"',dbo.pr003_getNumEmp_Degree_Percent('"+eom+"','"+level+"','"+operator+"') as 'per"+a+"',");
			}
			sql.setLength(sql.length() - 1);
			DataSet ds = new DataSet(sql.toString(),uprofile.get("dbname"),"MEMPLOYEE");
			try{ds.initConnection(uprofile);}catch(Exception e){}
			sb_group.append("<tr>");
			if(ds.next()){
				for(int v=0;v<ds.getFieldList().size();v++){
					if(v==0){
						sb_group.append("<td class='report_detail' style='text-align:left;'>"+ds.getString(ds.getFieldList().get(v).toString())+"</td>");
					}else{
						sb_group.append("<td class='report_detail' style='text-align:center;'>"+ds.getString(ds.getFieldList().get(v).toString())+"</td>");
					}
				}
			}
			sb_group.append("</tr>");
			ds.closeConnection();
		}
		sb_group.append("</table>");

	return sb_group.toString();
}

public String genEmpCommand(UProfile uprofile,int year){
		StringBuffer sql1 = new StringBuffer().append("select ");
		StringBuffer sql2 = new StringBuffer().append("select ");
		StringBuffer sql3 = new StringBuffer().append("select ");
		StringBuffer sql4 = new StringBuffer().append("select ");
		StringBuffer sql5 = new StringBuffer().append("select ");
		DecimalFormat df = new DecimalFormat("####.00");
		CheckNull chk = new CheckNull();
		CscCalendar cs = new CscCalendar();
		int loop_month = 12;
		if(year==cs.getYear()){
			loop_month = cs.getCurrentMonth();
		}
		/***************			Append Header		*****************/
		StringBuffer sb_group = new StringBuffer().append("อัตราผู้บังคับบัญชา:พนักงาน<table  cellpadding='0'  cellspacing='0' style='width:100%;'>");
		sb_group.append("<td class='report_detail' rowspan='1' colspan='1' style='text-align:center;'>จำนวนพนักงาน</td>");
		for(int a=1;a<=loop_month;a++){
			String month = a+"";
			if(a<10){month="0"+a;}
			CscCalendar cs1 = new CscCalendar(year+"-"+month+"-01");
			String eom = year+"-"+month+"-"+cs1.getEndDateOfMonth(); //End date of month YYYY-MM-DD
			sb_group.append("<td class='report_detail' rowspan='1' colspan='1' style='text-align:center;'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td>");

			sql1.append("dbo.pr003_getNumEmp_Command('"+eom+"','ผู้บังคับบัญชา') as num"+a+",");
			sql2.append("dbo.pr003_getNumEmp_Command('"+eom+"','พนักงาน') as num"+a+",");
			sql3.append("dbo.pr003_getNumEmp_Command('"+eom+"','') as num"+a+",");
			sql4.append("CAST(dbo.pr003_getNumEmp_Command('"+eom+"','พนักงาน')as integer)/CAST(dbo.pr003_getNumEmp_Command('"+eom+"','ผู้บังคับบัญชา')as integer) as num"+a+",");
			sql5.append("CAST(CAST(dbo.pr003_getNumEmp_Command('"+eom+"','ผู้บังคับบัญชา')as decimal(15,2))/CAST(dbo.pr003_getNumEmp_Command('"+eom+"','พนักงาน')as decimal(15,2)) as decimal(15,2)) as num"+a+",");
		}
		sb_group.append("</tr>");
		sql1.setLength(sql1.length() - 1);
		sql2.setLength(sql2.length() - 1);
		sql3.setLength(sql3.length() - 1);
		sql4.setLength(sql4.length() - 1);
		sql5.setLength(sql5.length() - 1);
		/***************			Append Header		*****************/
		
		DataSet ds1 = new DataSet(sql1.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds1.initConnection(uprofile);}catch(Exception e){}
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' style='text-align:left;'>จำนวนผู้บังคับบัญชา</td>");
		if(ds1.next()){
			for(int v=0;v<ds1.getFieldList().size();v++){
				sb_group.append("<td class='report_detail' style='text-align:center;'>"+chk.chkNullString(ds1.getString(ds1.getFieldList().get(v).toString()),"")+"</td>");
			}
		}
		sb_group.append("</tr>");

		DataSet ds2 = new DataSet(sql2.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds2.initConnection(uprofile);}catch(Exception e){}
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' style='text-align:left;'>จำนวนพนักงาน</td>");
		if(ds2.next()){
			for(int v=0;v<ds2.getFieldList().size();v++){
				sb_group.append("<td class='report_detail' style='text-align:center;'>"+chk.chkNullString(ds2.getString(ds2.getFieldList().get(v).toString()),"")+"</td>");
			}
		}
		sb_group.append("</tr>");

		DataSet ds3 = new DataSet(sql3.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds3.initConnection(uprofile);}catch(Exception e){}
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' style='text-align:left;'>รวมผู้บังคับบัญชาและพนักงาน</td>");
		if(ds3.next()){
			for(int v=0;v<ds3.getFieldList().size();v++){
				sb_group.append("<td class='report_detail' style='text-align:center;'>"+chk.chkNullString(ds3.getString(ds3.getFieldList().get(v).toString()),"")+"</td>");
			}
		}
		sb_group.append("</tr>");

		DataSet ds4 = new DataSet(sql4.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds4.initConnection(uprofile);}catch(Exception e){}
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' style='text-align:left;'>อัตราผู้บังคับบัญชาพนักงาน</td>");
		if(ds4.next()){
			for(int v=0;v<ds4.getFieldList().size();v++){
				sb_group.append("<td class='report_detail' style='text-align:center;'>1:"+chk.chkNullString(ds4.getString(ds4.getFieldList().get(v).toString()),"")+"</td>");
			}
		}
		sb_group.append("</tr>");

		DataSet ds5 = new DataSet(sql5.toString(),uprofile.get("dbname"),"MEMPLOYEE");
		try{ds5.initConnection(uprofile);}catch(Exception e){}
		sb_group.append("<tr>");
		sb_group.append("<td class='report_detail' style='text-align:left;'></td>");
		if(ds5.next()){
			for(int v=0;v<ds5.getFieldList().size();v++){
				sb_group.append("<td class='report_detail' style='text-align:right;'>"+chk.chkNullString(ds5.getString(ds5.getFieldList().get(v).toString()),"")+"</td>");
			}
		}
		sb_group.append("</tr>");

	return sb_group.toString();
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script language="javascript">setLang('<%=uprofile.get("lang")%>');</script>
<script >
	function GoExport(){
		window.location.href = "Payroll_Report_intelligence003_EXPORT.jsp?__year=<%=year%>";
	}
</script>
<style>
	.report_detail{
		/*text-align:center;*/
		border: 1px solid black;
	}
	.report_header{
		text-align:center;
		border: 1px solid black;
		/*min-width:50px;*/
	}
	td{
		mso-number-format:\@;
	}
</style>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="cscform" method="post" action='?'>
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__language" value ="<%=uprofile.get("lang")%>">
<input type="hidden" name="__calendar">
	<div align="left">
	<BR/>
	<BR/>
    <%=genEmpSalary(uprofile,year)%>
	<BR/>
    <%=genEmpAge(uprofile,year)%>
	<BR/>
	<%=genEmpAge_List(uprofile,year)%>
	<BR/>
	<%=genEmpEdu(uprofile,year)%>
	<BR/>
	<%=genEmpCommand(uprofile,year)%>
  </div>
</form>
</body>
</html>