<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.utilities.*,com.csc.library.database.*"%>
<%@page import="org.apache.commons.lang.StringUtils" %>
<jsp:useBean id="PSU142" class="com.csc.library.system.Task" scope="page"/>
<%
PSU142.setChannel(request, response);
PSU142.checkProfile();
final UProfile uprofile = PSU142.getUProfile();
if( uprofile == null ) {
return;
}
final String lang = (String)uprofile.get("lang");
final String langPrefix = "ENG".equalsIgnoreCase(lang)?"e":"t";
final StringBuilder sql = new StringBuilder();
sql.append("SELECT m.employeeid,m.status,m.emp_type,m.startdate AS startdate "); /* memployee */
sql.append(",p.startdate as promise_start,p.enddate as promise_end "); /* mempl_promisework */
sql.append(",f.tdesc+m.fname +' ' +m.lname AS tfullname ");
sql.append(",f.edesc+m.efname +' ' +m.elname AS efullname ");
sql.append(",b1.tdesc AS tbu1,b1.edesc AS ebu1 "); /* bu1 */
sql.append(",b2.tdesc AS tbu2,b2.edesc AS ebu2 "); /* bu2 */
sql.append(",b3.tdesc AS tbu3,b3.edesc AS ebu3 "); /* bu3 */
sql.append(",s.tdesc AS tposition,s.edesc AS eposition "); /* position */
sql.append("FROM memployee m ");
sql.append("INNER JOIN ( ");
sql.append("SELECT p$1.* ");
sql.append("FROM mempl_promisework p$1 ");
sql.append("WHERE p$1.line_no=( ");
sql.append("SELECT TOP 1 line_no ");
sql.append("FROM mempl_promisework p$2 ");
sql.append("WHERE p$2.employeeid=p$1.employeeid AND p$2.companyid=p$1.companyid ");
sql.append("ORDER BY employeeid,enddate DESC) ");
sql.append(") p ON (p.employeeid=m.employeeid AND p.companyid=m.companyid) ");
sql.append("LEFT OUTER JOIN mprefix f ON(f.prefixid=m.emp_prefix) ");
sql.append("LEFT OUTER JOIN mbu1 b1 ON(b1.bu1id=m.bu1) ");
sql.append("LEFT OUTER JOIN mbu2 b2 ON(b2.bu2id=m.bu2) ");
sql.append("LEFT OUTER JOIN mbu3 b3 ON(b3.bu3id=m.bu3) ");
sql.append("LEFT OUTER JOIN mposition s ON(s.positionid=m.emp_position) ");
String empTypeFilter = "";
String empType = request.getParameter("__emp_type");
if("1".equalsIgnoreCase(empType)) {
// age = 5 month
empTypeFilter = " m.emp_type = '1' ";
} else if("2".equalsIgnoreCase(empType)) {
//age = 4 year
empTypeFilter = " m.emp_type = '2' ";
} else {
empType = "3";
empTypeFilter = " m.emp_type in ( '1','2' ) ";
}
sql.append("WHERE ").append( empTypeFilter );
sql.append(" and ( p.enddate <= '" ).append(new CscCalendar().incDate(90).getYYYYMMDD()).append("' ");
sql.append(" and p.enddate >= '" ).append(new CscCalendar().getYYYYMMDD()).append("' )");
//out.print(sql);
%>
<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">
<link href="../CSS/bootstrap.css" rel="stylesheet" type="text/css">
<link href="../CSS/bootstrap_csc_backend.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script type='text/javascript' src='../JS/SCREEN.js'></script>
<script src="../JS/angular-1.3.15/angular.js" type="text/javascript"></script>
<script src="../JS/ANGULAR/SCREEN_ANGULAR.js" type="text/javascript"></script>
<script language='javascript'>setLang('<%=uprofile.get("lang")%>');</script>
<script language="JavaScript" >
function GoSave(){confirmSave();}
function GoUpdate(){update();}
function GoDelete(){edelete();}
function GoSearch(){
with( document.cscform) {
submit();
}
}
</script>
<style type="text/css" media="all">
.button { margin: 20px auto; text-align:center; }
.colunm_data { padding: 0 3px;}
.colunm_data_center { padding: 0 3px; text-align:center; }
.colunm_data_right { padding-right: 10px; text-align:right;}
.nowrap { white-space: nowrap; white-space: -webkit-nowrap; }
.colunm_header { background: #cccccc; line-height: 150%; text-align: center; font-weight: bold; font-size: 12px; }
#myTable { border: 1px solid #000; border-collapse: collapse; }
#myTable td { border: 1px solid #000; border-collapse: collapse; }
</style>
<style type="text/css" media="print">
.button { display: none; margin: 0; }
</style>
</head>
<body leftmargin="0" topmargin="0" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" action="?">
<input type="hidden" name="__screen" value="PSU142">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__calendar">
<input type="hidden" name="__language" value="<%=uprofile.get("lang")%>">
<input type="hidden" name="__companyid" value="<%=uprofile.get("companyid")%>">
<br>
<div align="center">
<table cellpadding="0" cellspacing="0" class="large">
<tr>
<td class="header">PSU142,
<!-- <script language="javascript">swapLang('รายชื่อเจ้าหน้าที่/ลูกจ้างประจำหมดอายุสัญญา');</script> -->
<span swlang code="SW011941">รายชื่อเจ้าหน้าที่/ลูกจ้างประจำหมดอายุสัญญา</span> </td>
</tr>
<tr>
<td class="blankspace"> </td>
</tr>
<td>
<div>
<label><input type="radio" name="__emp_type" value="1" id="__emp_type_1" <%=("1".equalsIgnoreCase(empType))?" checked=\"checked\"":""%> /><%=SystemCode.getValue("EMPTYPE", "1", lang)%></label>
<label><input type="radio" name="__emp_type" value="2" id="__emp_type_2" <%=("2".equalsIgnoreCase(empType))?" checked=\"checked\"":""%> /><%=SystemCode.getValue("EMPTYPE", "2", lang)%></label>
<label><input type="radio" name="__emp_type" value="3" id="__emp_type_3" <%=("3".equalsIgnoreCase(empType))?" checked=\"checked\"":""%> />
<!-- <script language="javascript">swapLang('All');</script> --><span swlang code="SW008544">All</span></label>
</div>
</td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW003537" onClick="GoSearch();">Search</button>
</div>
</td>
</tr>
<tr>
<td><%//=sql.toString()%>
<table border="0" cellpadding="0" cellspacing="1"class="inframe" align="center">
<tr>
<td colspan="2">
<table border="0" cellpadding="0" cellspacing="1" bgcolor="#333333" class="inframe" width="100%" id="myTable">
<tr>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel( "memployee", "employeeid", lang) %></td>
<td class="colunm_header"><!-- <script language="javascript">swapLang('Name-Surname');</script> -->
<span swlang code="SW010885">Name-Surname</span></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel( "memployee", "bu1", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel( "memployee", "bu2", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel( "memployee", "bu3", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel("memployee","emp_position", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel("memployee","emp_type", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel("memployee","startdate", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel("mempl_promisework","startdate", lang) %></td>
<td class="colunm_header"><%=ScreenHelper.getFieldLabel("mempl_promisework","enddate", lang) %></td>
<td class="colunm_header"><!-- <script language="javascript">swapLang('Work ages');</script> -->
<span swlang code="SW000739">Work Age</span></td>
</tr>
<%
DataSet ds = null;
try {
ds = new DataSet(sql.toString(), uprofile.getDbName(), "");
ds.setFetchAll(false);
ds.initConnection(uprofile);
final CountAge count = new CountAge(lang);
while (ds.next()) {
%>
<tr>
<td ><div class="colunm_data nowrap"><%=StringUtils.defaultIfEmpty( ds.getString("employeeid"),"-" ) %></div></td>
<td><div class="colunm_data " ><%=StringUtils.defaultIfEmpty( ds.getString( langPrefix +"fullname" ),"-") %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty( ds.getString( langPrefix +"bu1"),"-" ) %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty( ds.getString( langPrefix +"bu2"),"-" ) %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty( ds.getString( langPrefix +"bu3"),"-" ) %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty( ds.getString( langPrefix +"position"),"-" ) %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty( SystemCode.getValue("EMPTYPE", ds.getString("emp_type"), lang),"-" ) %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty( ds.getString("startdate" ),"-" ) %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty( ds.getString("promise_start"),"-" ) %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty( ds.getString("promise_end"),"-" ) %></div></td>
<td><div class="colunm_data_center" ><%=count.getCountAges(ds.getString("promise_start"),ds.getString("promise_end"),true) %></div></td>
</tr>
<%
}
} finally {
if(ds != null) {
try {
ds.closeConnection();
} catch (Exception e) { /* Ignore Error*/ }
}
}
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW005455" onClick="print();">print</button>
</div>
</td>
</tr>
<tr>
<td class="bottom"> </td>
</tr>
</table>
</div>
</form>
</body>
</html>