<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.HelpEntry,com.csc.library.system.*,com.csc.library.session.*,com.csc.library.utilities.*"%>
<%@page import="com.csc.library.databean.*"%>
<jsp:useBean id="AS000" class="com.csc.library.system.Task" scope="page" />
<%
AS000.setChannel(request, response);
HelpEntry screen = (HelpEntry) AS000.process("HelpEntry", request.getParameter("__helpName"));
CheckNull chk = new CheckNull();
String employeeid=chk.chkNullString(request.getParameter("__employeeid"));
screen.getInquiry().setFilter("employeeid='"+employeeid+"' and companyid='"+screen.getUProfile().get("companyid")+"'");
screen.process();
screen.nextRec();
// screen.process();
// screen.inq.next();
double minc=0,maxc=0,minm=0,maxm=0;
String[] workAge=screen.inq.getString("empworkages").split(" ");
// out.println("workage::"+screen.inq.getString("empworkages"));
String month = "";
if(workAge[2].length()>1){
month=workAge[2];
}else{
month="0"+workAge[2];
}
double age = Double.parseDouble(workAge[0]+"."+month);
double ratc=0.0,ratm=0.0;
String descM="",descC="";
String fundtablec= request.getParameter("__fundtablec");
String fundtablem= request.getParameter("__fundtablem");
//out.println(age+" fundtablec >>"+fundtablec+" fundtablem >> "+ fundtablem);
DbInquiry db = new InitialInquiry(screen.getUProfile()).getDbInquiry();
try {
db.initMyTable("mfundtable1","","");
db.setColumn("fundtableid,line_no,start_yos,end_yos,amount,unit");
db.setFilter("fundtableid='"+fundtablec+"' and start_yos<="+age+" and end_yos>="+age);
//out.println("filter :: "+db.getFilter());
db.refresh();
if(db.next()){
minc = Double.parseDouble(db.getString("start_yos"));
maxc = Double.parseDouble(db.getString("end_yos"));
ratc = Double.parseDouble(db.getString("amount"));
descC = db.getCurrentDbRecord().getSystemCode("unit");
}
db.setFilter("fundtableid='"+fundtablem+"' and start_yos<="+age+" and end_yos>="+age);
db.refresh();
if(db.next()){
minm = Double.parseDouble(db.getString("start_yos"));
maxm = Double.parseDouble(db.getString("end_yos"));
ratm = Double.parseDouble(db.getString("amount"));
descM = db.getCurrentDbRecord().getSystemCode("unit");
}
}
catch (Exception ex) {}
%>
<html ng-app="myHR">
<head>
<title><%=screen.getInquiry().getCurrentDbRecord().getDescription()%></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 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" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
function backPage_Return(valueList){
var tmp = new Array(50);
var tmp1 = new Array(50);
var inputName="";
var inputValue="";
with(window.opener.document.cscform){
tmp=valueList.split(",");
for (var i=0; i < tmp.length; i++) {
tmp1=tmp[i].split("#");
for (var j=0; j < tmp1.length; j++) {
inputName=tmp1[j++];
inputValue=tmp1[j];
for(var z=0;z<elements.length;z++){
if(elements[z].name == inputName){
elements[z].value=inputValue;
}
}
}
}
}
window.opener.GoSearch();
window.close();
}
function back(unit){
with(window.opener.document.cscform){
locateId.value =unit;
}
window.close();
}
//-->
</script>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" >
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
<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")%>">
<br>
<table height="" align="center" cellpadding="0" cellspacing="0" class="normal">
<tr bgcolor="#3366CC">
<td height="20" class="header"><%=screen.getInquiry().getCurrentDbRecord().getDescription()%> </td>
</tr>
<tr bgcolor="#3366CC">
<td><table class="maxsize" border="1" cellspacing="1" cellpadding="1">
<tr>
<td>
<table class="maxsize" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="3" class="blankspace" ></td>
</tr>
<tr>
<td colspan="3" class="row1" > <span swlang code="SW011859">อัตราเงินสำรองเลี้ยงชีพ</span></td>
</tr>
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
<tr>
<td width="10%">
<div align="right">
</div>
</td>
<td width="72%">ชื่อ
<%=screen.inq.getString("fullname")%> <span swlang code="SW000230">อายุงาน</span>
<%=screen.inq.getString("empworkages")%></td>
<td width="18%"> </td>
</tr>
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
<tr>
<td colspan="3" class="row1" ><span swlang code="SW011860">อายุกองทุน</span></td>
</tr>
<%
String result="",name="";
CountAge count = new CountAge(screen.getUProfile().get("lang"));
CscCalendar startDate = new CscCalendar();
CscCalendar endDate = new CscCalendar();
DbInquiry inqpvf = new InitialInquiry(screen.getUProfile()).getDbInquiry("MEMPL_PVF");
inqpvf.setColumn("employeeid,companyid,fundtableid,registerdate,expiredate");
DbInquiry inqfund = new InitialInquiry(screen.getUProfile()).getDbInquiry("MFUNDTABLE");
inqfund.setColumn("fundtableid,companyid,tdesc,edesc");
inqpvf.setFilter("employeeid='"+employeeid+"' and companyid='"+screen.getUProfile().get("companyid")+"'");
inqpvf.refresh();
if(inqpvf.next()){
startDate = new CscCalendar(inqpvf.getString("registerdate"));
result=count.getCountAges(startDate,endDate,true);
inqfund.setFilter("fundtableid='"+inqpvf.getString("fundtableid")+"' and companyid='"+screen.getUProfile().get("companyid")+"'");
inqfund.refresh();
if(inqfund.next()){
name = chk.chkNullString(inqfund.getString("tdesc"));
}
%>
<tr>
<td></td>
<td><%=name%> อายุกองทุน
<%=result%></td>
<td width="18%"> </td>
</tr>
<%
}
%>
<!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
<tr>
<td colspan="3" class="row1" ><span swlang code="SW011861">เงินสะสมพนักงาน</span></td>
</tr>
<tr>
<td>
</td>
<td>อายุงาน <%=minm%> ถึง <%=maxm%> คิดอัตรา <%=ratm%> <%=descM%></td>
<td> </td>
</tr>
<tr>
<td colspan="3" class="row1" ><span swlang code="SW011862">เงินสมทบ</span></td>
</tr>
<tr>
<td>
</td>
<td>อายุงาน <%=minc%> ถึง <%=maxc%> คิดอัตรา <%=ratc%> <%=descC%>
</td>
<td> </td>
</tr>
<tr>
<td colspan="3" class="blankspace" > </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<div align="center"></div>
</form>
</body>
</html>