<!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> - <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>