<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.session.*" %>
<%@page import="com.csc.library.utilities.*,com.csc.library.components.*,org.apache.commons.lang.StringUtils;"%>
<jsp:useBean id="PRU043" class="com.csc.library.system.Task" scope="page" />
<%
PRU043.setChannel(request,response);
//PRU043.checkProfile();
UIManager screen=(UIManager)PRU043.process("MultiEntry","PRU043");
MultiLine multi = screen.getMultiLine("mempl_taxy");
screen.getTable("mempl_taxy").setKeyOff();
CscCalendar cdate = new CscCalendar();
if((request.getParameter("Yselect")!=null )&&(!request.getParameter("Yselect").equals(""))){
screen.getTable("mempl_taxy").setFilter("EMPLOYEEID='"+screen.getRecord().getString("employeeid")+"' AND TAXY_YEAR="+request.getParameter("Yselect") );
screen.getRecord().refreshChild("mempl_taxy");
}else{
if((request.getParameter("__cmd")!=null )&&(request.getParameter("__cmd").equals("search")) ){
screen.getTable("mempl_taxy").setFilter("EMPLOYEEID='"+screen.getRecord().getString("employeeid")+"' AND TAXY_YEAR="+cdate.getEngYYYY());
screen.getRecord().refreshChild("mempl_taxy");
}
}
multi.setLabelBox("check box");
multi.goFirst();
String empid="";
if((request.getParameter("__employeeid")!=null )&&(!request.getParameter("__employeeid").equals(""))){
empid=request.getParameter("__employeeid");
}
%>
<html ng-app="myHR">
<head>
<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>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<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">getTitleName();</script>
<script language='javascript' src='../JS/EMPLOYEE.js'></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script language="JavaScript" src='../JS/ICONSMENU.js'></script>
<script language='javascript' src='../JS/HOTKEY.js'></script>
<script language="JavaScript" type="text/JavaScript">
function GoSave(){
setAfterUpdate();
confirmSave();
}
function GoUpdate(){
setAfterUpdate();
update();
}
function GoDelete(){
alert(MyCode[150]);
//edelete();
}
function GoSearch(){
with(document.cscform){
__help.value="__employeeid#"+__employeeid.value;
}
search();
}
//function checkCF() {checkConfirm();}
<!--
//-->
function checkAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox")
elements[i].checked=true;
}//end for
}//end with
}//end function
function decheckAll(){
with(document.cscform){
for(i=0;i<elements.length;i++){
if(elements[i].type=="checkbox")
elements[i].checked=false;
}//end for
}//end with
}//end function
function childMulti(record){
with(document.cscform){
window.open(__childMulti.value+".jsp?__cmd=&__gorec="+record+
"&__ack=edit&__employeeid="+__employeeid.value+
"&__headMulti=PRU043"+
"&__companyid="+__companyid.value);
//submit();
}
}
function linkChildPru(page){
with(document.cscform){
if(__employeeid.value!=""){
window.open(page+".jsp?__gorec="+__gorec.value+"&__ack=add&__headMulti="+__headMulti.value+"&__RecNo="+__maxrec.value+"&__employeeid="+__employeeid.value);
}else{
alert(MyCode[0]);
__employeeid.focus();
__employeeid.select();
}
}
}
function addMulti(){
with(document.cscform){
if(__employeeid.value!=""){
window.open(__childMulti.value+".jsp?__cmd=&__gorec=&__ack=add"+
"&__employeeid="+__employeeid.value+
"&__headMulti=PRU043"+
"&__companyid="+__companyid.value);
}else{
alert(MyCode[0]);
__employeeid.focus();
__employeeid.select();
}
}
}
function deleteMulti(){
with(document.cscform){
bCon=confirm(MyCode[4]);
if (bCon==true) {
__cmd.value="DelChild";
submit();
}
}
}
function searchYear(){
with(document.cscform){
//GoSearch();
__cmd.value="ack";
submit();
}
}
function showList(){
with(document.cscform){
showlist.value="1";
__cmd.value="ack";
submit();
// GoSearch();
}
}
</script>
<STYLE TYPE="text/css">
<!--
#parent1Div {position:absolute;}
-->
</STYLE>
</head>
<body leftmargin="0" topmargin="0" onLoad="MM_preloadImages('../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif')" >
<div id="toolTipLayer" style="position:absolute; visibility: hidden"></div>
<script language="javascript">initToolTips();</script>
<form name="cscform" method="post" acttion="?">
<%=screen.getTagConfirm()%>
<input type="hidden" name="__calendar">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__screen" value="PRU043">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__multiTable" value="mempl_taxy">
<input type="hidden" name="__helpReturn" value="">
<input type="hidden" name="__headMulti" value="PRU043">
<input type="hidden" name="__gorec" value="">
<input type="hidden" name="__ack" value="">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__maxrec" value="<%=screen.getTable("mempl_taxy").recCount()%>">
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__notNull" value="">
<input type="hidden" name="__fixCon" value="">
<input type="hidden" name="__afterUpdate" value="">
<input type="hidden" name="__emp_level" value="<%=screen.getDataLabel("emp_level")%>">
<input type="hidden" name="showlist" value="">
<!--script language="javascript">
var titlename=swap2String('Yearly Income');
document.write(Icons("PRU043,"+titlename));
</script-->
<br>
<div align="center">
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 1 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<table cellpadding="0" cellspacing="0" >
<tr>
<td class="header">PRU043, <!-- <script language="javascript">swapLang('Yearly Income');</script> -->
<span swlang code="SW006298">Yearly Income</span>
</td>
</tr>
<tr>
<td> <!-- +++++++++++++++++++++++++++++++++++++++++ Table 2 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<br>
<table border="1" cellpadding="0" cellspacing="0" class="largest" align="center">
<tr>
<td>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 3 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<table cellspacing="0" cellpadding="0" class="inframe">
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("employeeid")%> </td>
<td ><%=screen.getInput("employeeid")%>
<%
if((request.getParameter("__afterUpdate")!=null)&&(request.getParameter("__afterUpdate").equals("search")))
{
%>
<script language="javascript">GoSearch();</script>
<%
}
%>
<%=screen.getLabel("status")%> <%=screen.getInput("status")%><%//=lisbx.getInput()%></td>
</tr>
<tr>
<td class="columnlabel" ><%=screen.getLabel("fname")%> </td>
<td><input type="hidden" name="__emp_prefix" value="<%=screen.getDataLabel("MPREFIX","PREFIXID")%>">
<input name="MPREFIX@TDESC" type="text" readonly size="10" value="<%=screen.getDataLabel("mprefix","tdesc")%>">
<input name="__fname" type="text" readonly size="20" value="<%=screen.getDataLabel("fname")%>">
<input name="__lname" type="text" readonly size="20" value="<%=screen.getDataLabel("lname")%>"></td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("efname")%> </td>
<td><input name="MPREFIX@EDESC" type="text" readonly size="10" value="<%=screen.getDataLabel("mprefix","edesc")%>">
<input name="MEMPLOYEE@EFNAME" type="text" readonly size="20" value="<%=screen.getDataLabel("efname")%>">
<input name="MEMPLOYEE@ELNAME" type="text" readonly size="20" value="<%=screen.getDataLabel("elname")%> "></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 3 CL +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
</td>
</tr>
</table>
<br>
<table width="640" border="0" align="center" cellpadding="5" cellspacing="0" class="largest">
<tr>
<td align="center">
<%
String select=cdate.getEngYYYY();
if((request.getParameter("Yselect")!=null)&&(!request.getParameter("Yselect").equals(""))){
select = request.getParameter("Yselect");
}
%>
<select name="Yselect">
<option value="1900"><!-- <script language="javascript">swapLang("SELECT YEAR");</script> -->
<span swlang code="SW011875">SELECT YEAR</span></option>
<%
for( int index=cdate.getYear(); index>1980; index--) {
%>
<option value="<%=index %>" <% if(select.equals("" +index ))out.print(" selected");%>><%=index %></option>
<%
}
%>
</select>
<button type="button" class="btn btn-primary width100" swlang code="SW013171" onClick="searchYear();">BACK</button>
</td>
</tr>
</table>
<br>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 4 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<table border="1" cellpadding="0" cellspacing="0" class="larget" align="center">
<tr>
<td>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 5 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<table cellpadding="0" cellspacing="0" class="inframe ">
<tr>
<td>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 6 OP +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
<table border="0" cellpadding="0" cellspacing="1" bordercolor="#3366CC" bgcolor="#666666" class="inframe tablewithborder" id="rsTable ">
<tr>
<td width="66" class="row3"><div align="center"><%=multi.getLabel("taxy_year")%></div></td>
<td width="93" class="row3"><div align="center"><%=multi.getLabel("formulaid")%></div></td>
<td width="35" class="row3"><div align="center"><!-- <script language="javascript">swapLang('Period');</script> -->
<span swlang code="SW000907">Period</span></div></td>
<td class="row3"><div align="center"><!-- <script language="javascript">swapLang('Description');</script> -->
<span swlang code="SW000012">Description</span></div></td>
<td width="85" class="row3"><div align="center"><%=multi.getLabel("amount")%></div></td>
<td width="35" class="row3"><div align="center"> <!-- <script language="javascript">swapLang('Tax');</script> -->
<span swlang code="SW003582">Tax</span></div></td>
<td width="35" class="row3"><div align="center"> <!-- <script language="javascript">swapLang('SOC');</script> -->
<span swlang code="SW011879">SOC</span></div></td>
<td width="35" class="row3"><div align="center"> <!-- <script language="javascript">swapLang('PVF');</script> -->
<span swlang code="SW011880">PVF</span></div></td>
</tr>
<%
String formula_type;
double sum=0,amounts;
double sum_emp_soc=0;
double sum_emp_pvf=0;
double sum_cmp_soc=0;
double sum_cmp_pvf=0;
double sum_income=0;
double sum_tot=0;
double sum_tax=0;
double netIncome=0;
java.text.DecimalFormat df = new java.text.DecimalFormat("#,##0.00");
for(int i=1;!multi.eof();multi.next(),i++)
{
multi.getTable().getCurrentRecordManager().referLangOn();
%>
<tr>
<td class="forborder2"><div align="center"><%=multi.getData("taxy_year")%></div></td>
<td height="20" class="forborder2"><div align="center"><%=multi.getData("formulaid")%></div></td>
<td class="forborder2" height="20" ><div align="center"><%=multi.getData("period")%></div></td>
<td height="20" class="forborder2"><div align="center"><%=multi.getData("mformula","tdesc")%></div></td>
<td height="20" class="forborder2"><!-- <div align="right"><%=multi.getData("amount")%> </div> -->
<div id="parent1Div"> <%=(multi.getData("formula_type").equals("1")||multi.getData("formula_type").equals("D"))?"+":"-" %> </div>
<div align="right"><%=multi.getData("amount")%> </div>
</td>
<td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("tax"), "3"))?"●":"" %></div></td>
<td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("calsoc"), "1"))?"●":"" %></div></td>
<td height="20" class="forborder2" ><div align="center"><%=(StringUtils.equals(multi.getData("calpvf"), "1"))?"●":"" %></div></td>
</tr>
<%
amounts = multi.getTable().getCurrentRecordManager().getDouble("amount");
formula_type = multi.getTable().getString("formula_type").trim();
String tax= multi.getTable().getString("tax").trim();
sum = sum+amounts;
if ((formula_type.equalsIgnoreCase("1")||formula_type.equalsIgnoreCase("D")) && !tax.equalsIgnoreCase("0")) { // รายได้ หรือ เงินชดเชย
sum_income+=amounts;
netIncome+=amounts;
}else if (formula_type.equalsIgnoreCase("2") && !tax.equalsIgnoreCase("0")) { // เงินหัก
sum_income-=amounts;
netIncome-=amounts;
}else if (formula_type.equalsIgnoreCase("3")) { // ภาษี
sum_tax+=amounts;
netIncome-=amounts;
}else if (formula_type.equalsIgnoreCase("4")) { // เงินสะสมพนักงาน
sum_emp_pvf+=amounts;
netIncome-=amounts;
}else if (formula_type.equalsIgnoreCase("5")) { // ประกันสังคมพนักงาน
sum_emp_soc+=amounts;
netIncome-=amounts;
}else if (formula_type.equalsIgnoreCase("6")) { // เงินสะสมบริษัท
sum_cmp_pvf+=amounts;
}else if (formula_type.equalsIgnoreCase("7")) { // ประกันสังคมบริษัท
sum_cmp_soc+=amounts;
}else if (formula_type.equalsIgnoreCase("8")) { // รายได้ภาษี
sum_income+=amounts;
sum_tot+=amounts;
netIncome+=amounts;
}/*else if (formula_type==99) { // รายได้ภาษี
}*/
multi.getTable().getCurrentRecordManager().referLangOff();
}
%>
</table>
<br>
<table border="0" cellpadding="0" cellspacing="0" class="inframe">
<tr>
<td align="center" class="blankspace" colspan="2"> </td>
</tr>
<tr>
<td align="right"><!-- <script language="javascript">swapLang("Total Income");</script> -->
<strong swlang code="SW003580">Total Income</strong> </td>
<td width="140" align="right" bordercolor="#3366CC" bgcolor="#666666"><div align="right"><%=df.format(sum_income) %> </div></td>
</tr>
<tr>
<td align="right"><!-- <script language="javascript">swapLang("Total Tax");</script> -->
<strong swlang code="SW003549">Total TAX</strong> </td>
<td width="140" align="right" bordercolor="#3366CC" bgcolor="#666666"><div align="right"><%=df.format(sum_tax) %> </div></td>
</tr>
<tr>
<td align="right"><!-- <script language="javascript">swapLang("Net Salary");</script> -->
<strong swlang code="SW011881">เงินสะสมกองทุนฯ</strong> </td>
<td width="140" align="right" bordercolor="#3366CC" bgcolor="#666666"><div align="right"><%=df.format(sum_emp_pvf) %> </div></td>
</tr>
<tr>
<td align="right"><!-- <script language="javascript">swapLang("Net Salary");</script> -->
<strong swlang code="SW011882">Social Security</strong> </td>
<td width="140" align="right" bordercolor="#3366CC" bgcolor="#666666"><div align="right"><%=df.format(sum_emp_soc) %> </div></td>
</tr>
<tr>
<td align="right"><!-- <strong><script language="javascript">swapLang("Net Salary");</script> -->
<strong swlang code="SW005055">Net Salary</strong> </td>
<td width="140" align="right" bordercolor="#3366CC" bgcolor="#666666"><div align="right"><%=df.format(netIncome) %> </div></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 6 CL +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
</td>
</tr>
</table>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 5 CL +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
</td>
</tr>
</table>
<br>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 4CL +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
</td>
</tr>
<tr>
<td class="bottom"></td>
</tr>
</table>
<!-- +++++++++++++++++++++++++++++++++++++++++ Table 1 CL +++++++++++++++++++++++++++++++++++++++++++++++++++++-->
</div>
<script language="javascript">setEmpIdformenu(document.cscform.__employeeid.value);</script>
<script language="JavaScript">checkConfirm();</script></form>
</body>
</html>