<!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.system.*,com.csc.library.utilities.*"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*" %>
<%@ page import="org.apache.commons.lang.StringUtils" %>
<jsp:useBean id="PSU141" class="com.csc.library.system.Task" scope="page"/>
<%
PSU141.setChannel(request,response);
HelpEntry screen = (HelpEntry) PSU141.process("HelpEntry","PSU141HELP");
String age = request.getParameter("__age");
String empType = request.getParameter("__emp_type");
String ageFilter;
if("2".equalsIgnoreCase(age)) {
// อีก 30 วันครบ 4 ปี และเป็นสมาชิก pvf
ageFilter = "(startdate <= '" +new CscCalendar().incDate(30).decYear(4).getYYYYMMDD()
+"' and startdate >='" +new CscCalendar().decYear(4).getYYYYMMDD()
+"' and employeeid not in(select distinct employeeid from mempl_pvf) )";
} else {
age = "1";
// อีก 30 วันครบ 5เดือน และไม่เป็นสมาชิก pvf
ageFilter = "( startdate <= '" +new CscCalendar().incDate(30).decMonth(5).getYYYYMMDD()
+"' and startdate >='" +new CscCalendar().decMonth(5).getYYYYMMDD()
+"' and employeeid not in(select distinct employeeid from mempl_pvf) )";
}
String empTypeFilter = "";
if("1".equalsIgnoreCase(empType)) {
// age = 5 month
empTypeFilter = " and emp_type ='1' ";
} else if("2".equalsIgnoreCase(empType)) {
//age = 4 year
empTypeFilter = " and emp_type ='2' ";
} else {
empType = "3";
empTypeFilter = " and emp_type in ( '1','2' ) ";
}
screen.getInquiry().setFilter( ageFilter +empTypeFilter );
screen.setMaxLine(-1);
screen.process();
%>
<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('<%=screen.getUProfile().get("lang")%>');</script>
<script language="JavaScript" >
function GoSave(){confirmSave();}
function GoUpdate(){update();}
function GoDelete(){edelete();}
function GoSearch(){
with( document.cscform) {
if(getSelectedRadio(__age) == -1 ) {
alert();
} else if(getSelectedRadio(__emp_type) == -1 ) {
alert();
}
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="PSU141">
<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="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<br>
<div align="center">
<table cellpadding="0" cellspacing="0" class="large">
<tr>
<td class="header">PSU141,
<!-- <script language="javascript">swapLang('รายชื่อเจ้าหน้าที่/ลูกจ้างประจำอายุงานครบ 5 เดือนหรือ 4 ปี');</script> -->
<span swlang code="SW011940">ลูกจ้างประจำอายุงานครบ 5 เดือนหรือ 4 ปี</span> </td>
</tr>
<tr>
<td class="blankspace"> </td>
</tr>
<tr>
<td>
<div><!-- <script language="javascript">swapLang('Work Age');</script> --><span swlang code="SW000230">Year of Service</span>
<label><input type="radio" name="__age" value="1" id="__age_1" <%=("1".equalsIgnoreCase(age))?" checked=\"checked\"":""%> />5 <span swlang code="SW000800">Month</span><!-- เดือน --></label>
<label><input type="radio" name="__age" value="2" id="__age_2" <%=("2".equalsIgnoreCase(age))?" checked=\"checked\"":""%> />4 <span swlang code="SW000717">Year</span><!-- ปี --></label>
</div>
</td>
<tr>
<td>
<div>
<label><input type="radio" name="__emp_type" value="1" id="__emp_type_1" <%=("1".equalsIgnoreCase(empType))?" checked=\"checked\"":""%> /><%=com.csc.library.database.SystemCode.getValue("EMPTYPE", "1", screen.getUProfile().get("lang"))%></label>
<label><input type="radio" name="__emp_type" value="2" id="__emp_type_2" <%=("2".equalsIgnoreCase(empType))?" checked=\"checked\"":""%> /><%=com.csc.library.database.SystemCode.getValue("EMPTYPE", "2", screen.getUProfile().get("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>
<table border="0" cellpadding="0" cellspacing="1"class="inframe" align="center">
<!--tr>
<td width="50%"><div><script language="javascript">swapLang('Found Data');</script> <%//=screen.getRecCount()%></div></td>
<td width="50%"><div align="right"><%//=screen.getPageTag()%></div></td>
</tr-->
<tr>
<td colspan="2">
<table border="0" cellpadding="0" cellspacing="1" bgcolor="#333333" class="inframe" width="100%" id="myTable">
<tr>
<td class="colunm_header"><%=screen.getLabel("employeeid")%></td>
<td class="colunm_header"><%=screen.getLabel("fullname")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","bu1")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","bu2")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","bu3")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","emp_position")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","emp_type")%></td>
<td class="colunm_header"><%=screen.getLabel("memployee","startdate")%></td>
<td class="colunm_header"><!-- <script language="javascript">swapLang('Work ages');</script> --><span swlang code="SW000739">Work Age</span></td>
<td class="colunm_header"><%=screen.getLabel("mempl_pvf","amount")%></td>
</tr>
<%
while(screen.nextRec()){
%>
<tr>
<td ><div class="colunm_data nowrap"><%=StringUtils.defaultIfEmpty(screen.getString("employeeid"),"-") %></div></td>
<td><div class="colunm_data nowrap" ><%=StringUtils.defaultIfEmpty(screen.getString("memployee","fullname"),"-") %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty(screen.getString("mbu1","tdesc"),"-") %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty(screen.getString("mbu2","tdesc"),"-") %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty(screen.getString("mbu3","tdesc"),"-") %></div></td>
<td><div class="colunm_data" ><%=StringUtils.defaultIfEmpty(screen.getString("mposition","tdesc"),"-") %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty(screen.getInquiry().getCurrentDbRecord().getSystemCode("emp_type"),"-") %></div></td>
<td><div class="colunm_data_center nowrap" ><%=StringUtils.defaultIfEmpty(screen.getString("memployee","startdate"),"-") %></div></td>
<td><div class="colunm_data_center" ><%=StringUtils.defaultIfEmpty(screen.getString("memployee","empworkages"),"-") %></div></td>
<td><div class="colunm_data_right nowrap" ><%=StringUtils.defaultIfEmpty(screen.getString("mempl_pvf","amount"),"-") %></div></td>
</tr>
<%
}
%>
</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>