<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*"  %>
<%@ page import="java.util.*"  %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="EMV" class="com.csc.library.system.Task" scope="page" />
<jsp:setProperty name="EMV" property="appname" value="empview" />
<%
	EMV.setChannel(request, response);	
	HelpEntry screen = (HelpEntry)EMV.process("HelpEntry", "PRU170"); 
	if(screen==null){
		return;
	}
	CscCalendar cscdate = new CscCalendar();
	//cscdate.decMonth(1);
	String filter = " employeeid IN (SELECT TOP 20 employeeid FROM hadjposition WHERE adj_date like '"+cscdate.getYear()+"-"+cscdate.getMM()+"%' ORDER BY adj_date DESC) AND status = 'A' AND adj_date like '"+cscdate.getYear()+"-"+cscdate.getMM()+"%'";
	//out.print(filter);
	//out.print(cscdate.getYear()+"-"+cscdate.getMM());
	screen.getInquiry().setOrderBy("employeeid");
	screen.setMaxLine(5);
	screen.getInquiry().setBetween(0, 5);
	screen.getInquiry().setFilter(filter);
	screen.getInquiry().refresh();	
	CheckNull chk = new CheckNull();
	
%>
<% 
	if(screen.getInquiry().recCount()>0) {

%>  
<script type="text/javascript">
	function ShowDetail( pages, reqid ){
		var url = pages +".jsp?__requestid=" +reqid;
		PopupCenterTop( url, "popup", 700, 300);
	}
</script>

<div class="content-box2">
  <div class="content-header">
    <h2><script type="text/javascript">swapLang("Had Job Position");</script></h2>
  </div>
  
    <table width="100%" border="0" cellpadding="3" cellspacing="3">
      <tr>
        <td width="110" valign="top"><div align="center"><img src="../IMAGES/EMPVIEW/FREEJOB.jpg" alt="" width="100" height="100" align="middle"  /></div></td>
        <td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" class="table-list">
          <tr>
            <td nowrap class="column-header"><%=screen.getLabel("employeeid") %></td>
            <td nowrap class="column-header left"><%=screen.getLabel("fullname") %></td>
            <td nowrap class="column-header left"><%=screen.getLabel("mposition","tdesc") %></td>
            <td nowrap class="column-header"><%=screen.getLabel("hadjposition","old_job") %></td>
			<td nowrap class="column-header"><%=screen.getLabel("MBU1","tdesc") %></td>
			<td nowrap class="column-header"><%=screen.getLabel("MBU2","tdesc") %></td>
			<td nowrap class="column-header"><%=screen.getLabel("MBU3","tdesc") %></td>
			<td nowrap class="column-header"><%=screen.getLabel("hadjposition","adj_date") %></td>
			<td nowrap class="column-header"><%=screen.getLabel("hadjposition","eff_date") %></td>
          </tr>
         <% 
				while(screen.nextRec()){
					screen.referLangOn();
		%>          
          <tr>
            <td class="column-text center"><%=screen.getString("employeeid") %></td>
            <td class="column-text"><%=screen.getString("fullname") %></td>
            <td class="column-text"><%=screen.getString("mposition","tdesc") %></td>
            <td class="column-text center"><%=screen.getString("hadjposition","old_job") %></td>
			<td class="column-text center"><%=screen.getString("MBU1","tdesc") %></td>
			<td class="column-text center"><%=screen.getString("MBU2","tdesc") %></td>
			<td class="column-text center"><%=screen.getString("MBU3","tdesc") %></td>
			<td class="column-text center"><%=screen.getString("hadjposition","adj_date") %></td>
			<td class="column-text center"><%=screen.getString("hadjposition","eff_date") %></td>
          </tr>

         <%	
				 	screen.referLangOff();
	
				 }
		%>                          
        </table></td>
      </tr>
  </table>
 	<div class="show-all"><a href="REV014.jsp"><script type="text/javascript">swapLang("Show_all");</script></a>&nbsp;&raquo;</div>
  <div class="content-footer"><img src="../IMAGES/SPACER.gif" width="3" height="3" /></div>
</div>
<% 
    }
%>