<!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.*,java.sql.*"%>
<%@ include file="../CHECKPROFILE.jsp" %>
<%
response.setHeader("Cache-Control","must-revalidate");
response.setContentType("application/vnd.ms-excel; UTF-8");
response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");
CheckNull chk = new CheckNull();
CscCalendar c = new CscCalendar();
UProfile up = null;
if (session !=null){
up = (UProfile)session.getAttribute("userprofile");
}
DecimalFormat dmfm1 = new DecimalFormat("#,##0.00");
String lang = up.get("lang");
String startdate = chk.chkNullString(request.getParameter("__startdate"), c.getDDMMYYYY());
String enddate = chk.chkNullString(request.getParameter("__enddate"), c.getDDMMYYYY());
String cmd = chk.chkNullString(request.getParameter("__cmd"));
String apsassessy =chk.chkNullString(request.getParameter("__employeeid"));
String isprocess =chk.chkNullString(request.getParameter("__isprocess"));
String filter = "startdate <= '"+new CscCalendar(enddate).getYYYYMMDD()+"' and resigndate >='"+new CscCalendar(startdate).getYYYYMMDD()+"' and emp_position not in('i050','i016')";
String filter_intern = "startdate <= '"+new CscCalendar(enddate).getYYYYMMDD()+"' and resigndate >='"+new CscCalendar(startdate).getYYYYMMDD()+"' and emp_position in('i050','i016') ";
String filter_newStaff = "startdate >= '"+new CscCalendar(startdate).getYYYYMMDD()+"' and startdate <='"+new CscCalendar(enddate).getYYYYMMDD()+"' and emp_position not in('i050','i016')";
String filter_promoteStaff = "employeeid in (select employeeid from HADJPOSITION where eff_date >='"+new CscCalendar(startdate).getYYYYMMDD()+"' and eff_date <='"+new CscCalendar(enddate).getYYYYMMDD()+"' and adj_type !='10') and emp_position not in('i050','i016')";
String filter_newIntern = "startdate >= '"+new CscCalendar(startdate).getYYYYMMDD()+"' and startdate <='"+new CscCalendar(enddate).getYYYYMMDD()+"' and emp_position in('i050','i016') ";
DbRecord dbrec = new InitialRecord(up).getDbRecord("memployee");
dbrec.setColumn("*");
%>
<html ng-app="myHR">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- <link href="../CSS/TISCO.css" rel="stylesheet" type="text/css"> -->
<script language="JavaScript" src="../JS/SCREEN.js"></script>
<SCRIPT TYPE='text/JavaScript' SRC='../JS/DATEINPUT.js'></SCRIPT>
<SCRIPT TYPE='text/JavaScript' SRC='../JS/VIEWCALENDAR.js'></SCRIPT>
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type="text/javascript" src="../JS/angular-1.3.15/angular.js"></script>
<script type="text/javascript" src="../JS/ANGULAR/SCREEN_ANGULAR.js"></script>
<script language="javascript">setLang('<%=up.get("lang")%>');</script>
<style>
.num {
mso-number-format:General;
}
.format_text{
mso-number-format:"\@";/*force text*/
}
</style>
</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="APSR010.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%//=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PRU1122">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__language" value="<%=up.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="">
<input type="hidden" name="__isprocess" value="0">
<input type="hidden" name="__filter" value="<%=filter%>">
<input type="hidden" name="__calendar" value="">
<script language="javascript">getInputFormatDate()</script>
<br>
<table class="maxsize" border="1" cellpadding="0" cellspacing="1" cols=21 >
<tr>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ลำดับที่":"seq"%></div></td>
<td class="row1"><div align="center"><%=dbrec.getField("bu1").getDescription()%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"กลุ่มพนักงาน":"Contract Type"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"คอสเซ็นเตอร์":"Cost Center"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"รหัสพนักงาน":"Employee ID"%></div></td>
<td class="row1"><div align="center"><%=dbrec.getField("bu2").getDescription()%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"สถานที่ทำงาน":"Workarea"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ชื่อพนักงาน":"Fullname"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ตำแหน่ง":"Position"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"เพศ":"Gender"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"วันเกิด":"Birthday"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"อายุ":"Age"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"เบอร์โทรศัพท์":"Tel No"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"อีเมล์":"E-Mail"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"สัญชาติ":"Nationality"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ระดับการศึกษา":"Degree"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ระดับพนักงาน":"Pl"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"วันที่เริ่มสัญญา":"Date Contract"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"วันที่สิ้นสุดสัญญา":"End Date Contract"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"ขยายสัญญาจ้าง":"Contract Extended"%></div></td>
<td class="row1"><div align="center"><%=lang.equalsIgnoreCase("tha")?"แก้ไขสัญญา":"Revised Contract"%></div></td>
</tr>
<%
int seq = 0;
DbInquiry inqemp = new InitialInquiry(up).getDbInquiry("memployee");
DbInquiry inqbu1 = new InitialInquiry(up).getDbInquiry("mbu1");
DbInquiry inqbu2 = new InitialInquiry(up).getDbInquiry("mbu2");
DbInquiry inqpos = new InitialInquiry(up).getDbInquiry("mposition");
DbInquiry inqeducate = new InitialInquiry(up).getDbInquiry("mempl_educate");
DbInquiry inqdegree = new InitialInquiry(up).getDbInquiry("mdegree");
DbInquiry inqsalatype = new InitialInquiry(up).getDbInquiry("msalatype0");
DbInquiry inqcontact = new InitialInquiry(up).getDbInquiry("mempl_promisework");
DbInquiry inqnation = new InitialInquiry(up).getDbInquiry("mnationality");
DbInquiry inqwork = new InitialInquiry(up).getDbInquiry("mworkarea");
DbInquiry inqgroup = new InitialInquiry(up).getDbInquiry("mgroup");
inqcontact.setColumn("*");
inqemp.setColumn("*");
inqemp.putChild(inqpos);
inqemp.putChild(inqeducate);
inqeducate.putChild(inqdegree);
inqemp.putChild(inqsalatype);
inqemp.putChild(inqcontact);
inqemp.putChild(inqnation);
inqemp.putChild(inqwork);
inqemp.putChild(inqgroup);
inqbu1.setColumn("*");
inqbu1.refresh();
while(inqbu1.next()){
%>
<tr>
<td colspan="21"><b><%=inqbu1.getString("edesc")%></b></td>
</tr>
<%
seq = 0;
inqemp.setFilter(filter+" and bu1 ='"+inqbu1.getString("bu1id")+"'");
inqemp.setOrderBy("bu2");
inqemp.refresh();
//out.print(inqemp.getFilter()+"</br>");
while(inqemp.next()){
seq++;
%>
<tr>
<td><center><%=seq%></center></td>
<td><center><%=inqemp.getString("bu1")%></center></td>
<td><center><%=inqemp.getString("mgroup","edesc")%></center></td>
<td><center><%=inqemp.getString("costcenter")%></center></td>
<td><center><%=inqemp.getString("employeeid")%></center></td>
<td><center><%=inqemp.getString("bu2")%></center></td>
<td><center><%=inqemp.getString("mworkarea","edesc")%></center></td>
<td><%=inqemp.getString("fullname_noprefix")%></td>
<td><%=inqemp.getString("mposition","edesc")%></td>
<td><center><%=inqemp.getString("sex").equals("1")?"M":inqemp.getString("sex").equals("2")?"F":""%></center></td>
<td><center><%=new CscCalendar(inqemp.getString("birthday")).getDDEngSortYY()%></center></td>
<td><center><%=inqemp.getString("empagesy")%></center></td>
<td><center><%=inqemp.getString("tel_no")%></center></td>
<td><%=inqemp.getString("email")%></td>
<td><%=inqemp.getString("mnationality","edesc")%></td>
<td><%=inqemp.getString("mdegree","edesc")%></td>
<td><center><%=inqemp.getString("pl")%></center></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='2'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("startdate")).getDDEngSortYY()%></td>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
String revise = "";
if(inqemp.getString("mempl_promisework","opencontract").equals("1")){
revise ="Open Contract";
}else{
if(inqemp.getString("mempl_promisework","promise_type").equals("4")){
revise = new CscCalendar(inqemp.getString("mempl_promisework","enddate")).getDDEngSortYY();
}
}
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=revise%></td>
</tr>
<%
} // end employee loop
DbInquiry inqgroup2 = new InitialInquiry(up).getDbInquiry("mgroup");
inqgroup2.setColumn("*");
inqgroup2.setFilter("groupid ='03'");
inqgroup2.refresh();
inqgroup2.next();
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and emp_group ='03'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup2.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup2.setColumn("*");
inqgroup2.setFilter("groupid ='04'");
inqgroup2.refresh();
inqgroup2.next();
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and emp_group ='04'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup2.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup2.setColumn("*");
inqgroup2.setFilter("groupid ='02'");
inqgroup2.refresh();
inqgroup2.next();
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and emp_group ='02'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup2.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002042">Female</td>
<%
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and sex ='2'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<%
inqgroup2.setColumn("*");
inqgroup2.setFilter("groupid ='01'");
inqgroup2.refresh();
inqgroup2.next();
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and emp_group ='01'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup2.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002044">Male</td>
<%
inqemp.setFilter(filter+"and bu1 ='"+inqbu1.getString("bu1id")+"' and sex ='1'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<tr>
<td class="td-right" swlang code="SW000024"><b>Total</b></td>
<td><center><b><%=seq%></b></center></td>
<td colspan='19'></td>
</tr>
<tr>
<td colspan='21'></td>
</tr>
<%
}
%>
<!-- newStaff Section Start Here -->
<tr>
<td colspan='21'><b>New Staff</b></td>
</tr>
<%
inqemp.setFilter(filter_newStaff);
inqemp.setOrderBy("bu2");
inqemp.refresh();
seq = 0;
while(inqemp.next()){
seq++;
%>
<tr>
<td><center><%=seq%></center></td>
<td><center><%=inqemp.getString("bu1")%></center></td>
<td><center><%=inqemp.getString("mgroup","edesc")%></center></td>
<td><center><%=inqemp.getString("costcenter")%></center></td>
<td><center><%=inqemp.getString("employeeid")%></center></td>
<td><center><%=inqemp.getString("bu2")%></center></td>
<td><center><%=inqemp.getString("mworkarea","edesc")%></center></td>
<td><%=inqemp.getString("fullname_noprefix")%></td>
<td><%=inqemp.getString("mposition","edesc")%></td>
<td><center><%=inqemp.getString("sex").equals("1")?"M":inqemp.getString("sex").equals("2")?"F":""%></center></td>
<td><center><%=new CscCalendar(inqemp.getString("birthday")).getDDEngSortYY()%></center></td>
<td><center><%=inqemp.getString("empagesy")%></center></td>
<td><center><%=inqemp.getString("tel_no")%></center></td>
<td><%=inqemp.getString("email")%></td>
<td><%=inqemp.getString("mnationality","edesc")%></td>
<td><%=inqemp.getString("mdegree","edesc")%></td>
<td><center><%=inqemp.getString("pl")%></center></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='2'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("startdate")).getDDEngSortYY()%></td>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
String revise = "";
if(inqemp.getString("mempl_promisework","opencontract").equals("1")){
revise ="Open Contract";
}else{
if(inqemp.getString("mempl_promisework","promise_type").equals("4")){
revise = new CscCalendar(inqemp.getString("mempl_promisework","enddate")).getDDEngSortYY();
}
}
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=revise%></td>
</tr>
<%
} // end employee loop newStaff
DbInquiry inqgroup3 = new InitialInquiry(up).getDbInquiry("mgroup");
inqgroup3.setColumn("*");
inqgroup3.setFilter("groupid ='03'");
inqgroup3.refresh();
inqgroup3.next();
inqemp.setFilter(filter_newStaff+" and emp_group ='03'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup3.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup3.setColumn("*");
inqgroup3.setFilter("groupid ='04'");
inqgroup3.refresh();
inqgroup3.next();
inqemp.setFilter(filter_newStaff+" and emp_group ='04'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup3.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup3.setColumn("*");
inqgroup3.setFilter("groupid ='02'");
inqgroup3.refresh();
inqgroup3.next();
inqemp.setFilter(filter_newStaff+" and emp_group ='02'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup3.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002042">Female</td>
<%
inqemp.setFilter(filter_newStaff+" and sex ='2'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<%
inqgroup3.setColumn("*");
inqgroup3.setFilter("groupid ='01'");
inqgroup3.refresh();
inqgroup3.next();
inqemp.setFilter(filter_newStaff+" and emp_group ='01'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup3.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002044">Male</td>
<%
inqemp.setFilter(filter_newStaff+" and sex ='1'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<tr>
<td class="td-right" swlang code="SW000024"><b>Total</b></td>
<td><center><b><%=seq%></b></center></td>
<td colspan='19'></td>
</tr>
<tr>
<td colspan='21'></td>
</tr>
<!-- promoteStaff Section Start Here -->
<tr>
<td colspan='21'><b>Promoted Staff</b></td>
</tr>
<%
inqemp.setFilter(filter_promoteStaff);
inqemp.setOrderBy("bu2");
inqemp.refresh();
seq = 0;
while(inqemp.next()){
seq++;
%>
<tr>
<td><center><%=seq%></center></td>
<td><center><%=inqemp.getString("bu1")%></center></td>
<td><center><%=inqemp.getString("mgroup","edesc")%></center></td>
<td><center><%=inqemp.getString("costcenter")%></center></td>
<td><center><%=inqemp.getString("employeeid")%></center></td>
<td><center><%=inqemp.getString("bu2")%></center></td>
<td><center><%=inqemp.getString("mworkarea","edesc")%></center></td>
<td><%=inqemp.getString("fullname_noprefix")%></td>
<td><%=inqemp.getString("mposition","edesc")%></td>
<td><center><%=inqemp.getString("sex").equals("1")?"M":inqemp.getString("sex").equals("2")?"F":""%></center></td>
<td><center><%=new CscCalendar(inqemp.getString("birthday")).getDDEngSortYY()%></center></td>
<td><center><%=inqemp.getString("empagesy")%></center></td>
<td><center><%=inqemp.getString("tel_no")%></center></td>
<td><%=inqemp.getString("email")%></td>
<td><%=inqemp.getString("mnationality","edesc")%></td>
<td><%=inqemp.getString("mdegree","edesc")%></td>
<td><center><%=inqemp.getString("pl")%></center></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='2'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("startdate")).getDDEngSortYY()%></td>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
String revise = "";
if(inqemp.getString("mempl_promisework","opencontract").equals("1")){
revise ="Open Contract";
}else{
if(inqemp.getString("mempl_promisework","promise_type").equals("4")){
revise = new CscCalendar(inqemp.getString("mempl_promisework","enddate")).getDDEngSortYY();
}
}
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=revise%></td>
</tr>
<%
} // end employee loop newStaff
DbInquiry inqgroup4 = new InitialInquiry(up).getDbInquiry("mgroup");
inqgroup4.setColumn("*");
inqgroup4.setFilter("groupid ='03'");
inqgroup4.refresh();
inqgroup4.next();
inqemp.setFilter(filter_promoteStaff+" and emp_group ='03'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup4.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup4.setColumn("*");
inqgroup4.setFilter("groupid ='04'");
inqgroup4.refresh();
inqgroup4.next();
inqemp.setFilter(filter_promoteStaff+" and emp_group ='04'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup4.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup4.setColumn("*");
inqgroup4.setFilter("groupid ='02'");
inqgroup4.refresh();
inqgroup4.next();
inqemp.setFilter(filter_promoteStaff+" and emp_group ='02'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup4.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002042">Female</td>
<%
inqemp.setFilter(filter_promoteStaff+" and sex ='2'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<%
inqgroup4.setColumn("*");
inqgroup4.setFilter("groupid ='01'");
inqgroup4.refresh();
inqgroup4.next();
inqemp.setFilter(filter_promoteStaff+" and emp_group ='01'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup4.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002044">Male</td>
<%
inqemp.setFilter(filter_promoteStaff+" and sex ='1'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<tr>
<td class="td-right" swlang code="SW000024"><b>Total</b></td>
<td><center><b><%=seq%></b></center></td>
<td colspan='19'></td>
</tr>
<tr>
<td colspan='21'></td>
</tr>
<!-- newIntern Section Start Here -->
<tr>
<td colspan='21'><b>New Intern</b></td>
</tr>
<%
inqemp.setFilter(filter_newIntern);
inqemp.setOrderBy("bu2");
inqemp.refresh();
seq = 0;
while(inqemp.next()){
seq++;
%>
<tr>
<td><center><%=seq%></center></td>
<td><center><%=inqemp.getString("bu1")%></center></td>
<td><center><%=inqemp.getString("mgroup","edesc")%></center></td>
<td><center><%=inqemp.getString("costcenter")%></center></td>
<td><center><%=inqemp.getString("employeeid")%></center></td>
<td><center><%=inqemp.getString("bu2")%></center></td>
<td><center><%=inqemp.getString("mworkarea","edesc")%></center></td>
<td><%=inqemp.getString("fullname_noprefix")%></td>
<td><%=inqemp.getString("mposition","edesc")%></td>
<td><center><%=inqemp.getString("sex").equals("1")?"M":inqemp.getString("sex").equals("2")?"F":""%></center></td>
<td><center><%=new CscCalendar(inqemp.getString("birthday")).getDDEngSortYY()%></center></td>
<td><center><%=inqemp.getString("empagesy")%></center></td>
<td><center><%=inqemp.getString("tel_no")%></center></td>
<td><%=inqemp.getString("email")%></td>
<td><%=inqemp.getString("mnationality","edesc")%></td>
<td><%=inqemp.getString("mdegree","edesc")%></td>
<td><center><%=inqemp.getString("pl")%></center></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='2'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("startdate")).getDDEngSortYY()%></td>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
String revise = "";
if(inqemp.getString("mempl_promisework","opencontract").equals("1")){
revise ="Open Contract";
}else{
if(inqemp.getString("mempl_promisework","promise_type").equals("4")){
revise = new CscCalendar(inqemp.getString("mempl_promisework","enddate")).getDDEngSortYY();
}
}
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=revise%></td>
</tr>
<%
} // end employee loop newStaff
DbInquiry inqgroup5 = new InitialInquiry(up).getDbInquiry("mgroup");
inqgroup5.setColumn("*");
inqgroup5.setFilter("groupid ='03'");
inqgroup5.refresh();
inqgroup5.next();
inqemp.setFilter(filter_newIntern+" and emp_group ='03'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup5.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup5.setColumn("*");
inqgroup5.setFilter("groupid ='04'");
inqgroup5.refresh();
inqgroup5.next();
inqemp.setFilter(filter_newIntern+" and emp_group ='04'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup5.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup5.setColumn("*");
inqgroup5.setFilter("groupid ='02'");
inqgroup5.refresh();
inqgroup5.next();
inqemp.setFilter(filter_newIntern+" and emp_group ='02'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup5.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002042">Female</td>
<%
inqemp.setFilter(filter_newIntern+" and sex ='2'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<%
inqgroup5.setColumn("*");
inqgroup5.setFilter("groupid ='01'");
inqgroup5.refresh();
inqgroup5.next();
inqemp.setFilter(filter_newIntern+" and emp_group ='01'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup5.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002044">Male</td>
<%
inqemp.setFilter(filter_newIntern+" and sex ='1'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<tr>
<td class="td-right" swlang code="SW000024"><b>Total</b></td>
<td><center><b><%=seq%></b></center></td>
<td colspan='19'></td>
</tr>
<tr>
<td colspan='21'></td>
</tr>
<!-- Intern Section Start Here -->
<tr>
<td colspan='21'><b>Intern</b></td>
</tr>
<%
inqemp.setFilter(filter_intern);
inqemp.setOrderBy("bu2");
inqemp.refresh();
seq = 0;
while(inqemp.next()){
seq++;
%>
<tr>
<td><center><%=seq%></center></td>
<td><center><%=inqemp.getString("bu1")%></center></td>
<td><center><%=inqemp.getString("mgroup","edesc")%></center></td>
<td><center><%=inqemp.getString("costcenter")%></center></td>
<td><center><%=inqemp.getString("employeeid")%></center></td>
<td><center><%=inqemp.getString("bu2")%></center></td>
<td><center><%=inqemp.getString("mworkarea","edesc")%></center></td>
<td><%=inqemp.getString("fullname_noprefix")%></td>
<td><%=inqemp.getString("mposition","edesc")%></td>
<td><center><%=inqemp.getString("sex").equals("1")?"M":inqemp.getString("sex").equals("2")?"F":""%></center></td>
<td><center><%=new CscCalendar(inqemp.getString("birthday")).getDDEngSortYY()%></center></td>
<td><center><%=inqemp.getString("empagesy")%></center></td>
<td><center><%=inqemp.getString("tel_no")%></center></td>
<td><%=inqemp.getString("email")%></td>
<td><%=inqemp.getString("mnationality","edesc")%></td>
<td><%=inqemp.getString("mdegree","edesc")%></td>
<td><center><%=inqemp.getString("pl")%></center></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='2'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("startdate")).getDDEngSortYY()%></td>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=new CscCalendar(inqcontact.getString("enddate")).getDDEngSortYY()%></td>
<%
String revise = "";
if(inqemp.getString("mempl_promisework","opencontract").equals("1")){
revise ="Open Contract";
}else{
if(inqemp.getString("mempl_promisework","promise_type").equals("4")){
revise = new CscCalendar(inqemp.getString("mempl_promisework","enddate")).getDDEngSortYY();
}
}
inqcontact.setFilter("employeeid = '"+inqemp.getString("employeeid")+"' and promise_type ='3'");
inqcontact.refresh();
inqcontact.next();
%>
<td><%=revise%></td>
</tr>
<%
} // end employee loop Intern
DbInquiry inqgroup6 = new InitialInquiry(up).getDbInquiry("mgroup");
inqgroup6.setColumn("*");
inqgroup6.setFilter("groupid ='03'");
inqgroup6.refresh();
inqgroup6.next();
inqemp.setFilter(filter_intern+" and emp_group ='03'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup6.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup6.setColumn("*");
inqgroup6.setFilter("groupid ='04'");
inqgroup6.refresh();
inqgroup6.next();
inqemp.setFilter(filter_intern+" and emp_group ='04'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup6.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="19"></td>
</tr>
<%
inqgroup6.setColumn("*");
inqgroup6.setFilter("groupid ='02'");
inqgroup6.refresh();
inqgroup6.next();
inqemp.setFilter(filter_intern+" and emp_group ='02'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup6.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002042">Female</td>
<%
inqemp.setFilter(filter_intern+" and sex ='2'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<%
inqgroup6.setColumn("*");
inqgroup6.setFilter("groupid ='01'");
inqgroup6.refresh();
inqgroup6.next();
inqemp.setFilter(filter_intern+" and emp_group ='01'");
inqemp.refresh();
%>
<tr>
<td class="td-right"><%=inqgroup6.getString("edesc")%></td>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="6"></td>
<td class="td-right" swlang code="SW002044">Male</td>
<%
inqemp.setFilter(filter_intern+" and sex ='1'");
inqemp.refresh();
%>
<td><center><%=inqemp.recCount()%></center></td>
<td colspan="11"></td>
</tr>
<tr>
<td class="td-right" swlang code="SW000024"><b>Total</b></td>
<td><center><b><%=seq%></b></center></td>
<td colspan='19'></td>
</tr>
<tr>
<td colspan='21'></td>
</tr>
</table>
</form>
</body>
</html>