<!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"%>
<%@ page import="java.util.*,java.io.*,java.sql.*"%>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Locale" %>
<%@ page import="java.util.Date" %>
<%
	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>
		<script language="JavaScript" type="text/JavaScript">

			function GoExport(){
				with(document.cscform){
					// alert(__filter.value);
					var param = "PRU1122_EXP.jsp?__startdate="+__startdate.value+"&__enddate="+__enddate.value;
					window.open(param);
				}
			}

			function GoProcess(){
				with( document.cscform){
          __cmd.value = "search"
          __isprocess.value = "1"
          submit();
				}
			}

		</script>
		<style>
			.td-right{
				text-align: right;
			}
		</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="PRU1122.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="__startdate" value="<%=startdate%>">
			<input type="hidden" name="__enddate" value="<%=enddate%>">

			<input type="hidden" name="__calendar" value="">
			<script language="javascript">getInputFormatDate()</script>

			<br>
			<div align="center">
				<table class="large" cellpadding="0"  cellspacing="1"  >
					<tr>
						<td  colspan=2 class="header">PRU1122,NTPC Staff Name List</td>
					</tr>
					<tr>
						<td colspan=2>
							<table border="0" cellpadding="0" cellspacing="1"   align="center" class="largest">
								<tr>
									<td colspan=2 class="blankspace"></td>
								</tr>
								<tr>
									<td width="40%" style="text-align: right;"><span swlang code="SW000277">Period Date</span></td>
									<td style="text-align: left;">
										<input type="text" id="startdate" name="startdate" value="<%=startdate %>" size="10" maxlength="10" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate(this);" onfocus="this.select();">
										<a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image19','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('startdate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image19" width="20" height="20" border="0" style="vertical-align: middle"></a>&nbsp;&nbsp;-&nbsp;&nbsp;
										<input type="text" id="enddate" name="enddate" value="<%=enddate %>" size="10" maxlength="10" onkeypress="chkIntegerOfDate(this.value,event);" onkeyup="sysIsEdit();formatDate(this);" onblur="chkInputDate(this);" onfocus="this.select();">
										<a href="javascript:;" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image19','','../IMAGES/BUTTON/SWAP/CALENDAR_SWAP20.gif',1)" onClick="viewCal('enddate')"><img src="../IMAGES/BUTTON/MAIN/CALENDAR20.gif" alt="Calendar" name="Image19" width="20" height="20" border="0" style="vertical-align: middle"></a>
									</td>
								</tr>
								<tr>
									<td colspan=2 class="blankspace"></td>
								</tr>
								<tr>
									<td colspan="2" align="center">
										<a href="javascript:GoProcess();"><img src="../IMAGES/BUTTON/SEARCH.gif"border=0/></a>
									</td>
								</tr>
								<%
									if(isprocess.equals("1")){
								%>
								<td colspan="2" align="center">
									<a href="javascript:GoExport();"><img src="../IMAGES/BUTTON/EXPORT.gif" border=0 /></a>
								</td>
								<%
									}
								%>
							</table>

							<%
								if(isprocess.equals("1")){
							%>
							<table class="maxsize" border="1" cellpadding="0" cellspacing="1" cols=11 bgcolor="#CCCCCC">
								<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>
						<%
							}
						%>
					</td>
				</tr>
				<tr>
					<td colspan=2 class="blankspace"></td>
				</tr>
				<tr>
					<td colspan=2 class="blankspace"></td>
				</tr>
				<tr bordercolor="0069B3">
					<td colspan=2 class="bottom"></td>
				</tr>
			</table>
		</form>
	</body>
</html>