<%@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" %> <% 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+"")); year = year-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 align='center'><tr><td></td></tr><td >ตำแหน่ง</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 colspan='3' rowspan='1'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td></tr>"); m_desc.append("<tr >"); m_desc.append("<td colspan='1' rowspan='1' align='center'>จำนวนพนักงาน</td>"); m_desc.append("<td colspan='1' rowspan='1' align='center'>เงินเดือนค่าจ้าง</td>"); m_desc.append("<td 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></td></tr><tr align='center'><td >เพศ</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 colspan='2' rowspan='1'>"+cs1.getThaiShortMonth()+"-"+cs1.getThaiYY()+"</td></tr>"); m_desc.append("<tr >"); m_desc.append("<td colspan='1' rowspan='1' align='center'>จำนวนพนักงาน</td>"); m_desc.append("<td 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 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 style='text-align:center;'>Grand Total</td></tr>"); sb_group.append( "<BR/>จำนวนพนักงานตามช่วงอายุ<table style=''><tr>"+ "<td rowspan='2' colspan='1' style='text-align:center;'>ช่วงอายุ(ปี)</td>"+ "<td 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 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 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 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"> <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css"> <link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script> <script type='text/javascript' src="../JS/bootstrap.js"></script> <script language='javascript' src='../JS/SCREEN.js'></script> <script language="javascript">setLang('<%=uprofile.get("lang")%>');</script> <script src="../JS/VIEWCALENDAR.js"></script> <script > function GoExport(){ window.location.href = "Payroll_Report_intelligence003_EXPORT.jsp?__year=<%=year%>"; } </script> <style> .report_detail{ /*text-align:center;*/ border: 1px solid white; } .report_header{ text-align:center; border: 1px solid white; /*min-width:50px;*/ } </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"> <table cellpadding="0" cellspacing="0" style='width:100%;'> <tr align='middle' > <td class='header'>รายงานจำนวนพนักงาน </td> </tr> <tr align='middle' > <td style='padding: 20px;'>ปี พ.ศ.<input name='__year' type='text' value='<%=year+543%>'></td> </tr> <tr> <td class="buttonline" colspan="7"><div align="center"> <button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="search();">SEARCH</button> <button type="button" class="btn btn-primary width100" swlang code="SW013178" onClick="GoExport();">EXPORT</button> </div> </td> </tr> </table> <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>