<!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.utilities.*,com.csc.library.session.*,com.csc.library.components.*,com.csc.library.report.*"%>
<%@page import="java.util.*,java.text.DecimalFormat,java.math.BigDecimal,com.csc.library.database.DataSet"%>
<jsp:useBean id="PRU173" scope="page" class="com.csc.library.system.Task" />
<html ng-app="myHR">
<%
CheckNull chk = new CheckNull();
CscCalendar cs = new CscCalendar();
PRU173.setChannel(request ,response);
HelpEntry screen = (HelpEntry) PRU173.process("HelpEntry", "MEMPLOYEEHELP");
//initial value
String emp1 = chk.chkNullString(request.getParameter("__emp1"));
String emp2 = chk.chkNullString(request.getParameter("__emp2"));
String bu1 = chk.chkNullString(request.getParameter("__bu1"));
String bu2 = chk.chkNullString(request.getParameter("__bu2"));
String bu3 = chk.chkNullString(request.getParameter("__bu3"));
String bu4 = chk.chkNullString(request.getParameter("__bu4"));
String bu5 = chk.chkNullString(request.getParameter("__bu5"));
String salatype = chk.chkNullString(request.getParameter("__salatype"));
String saladesc = chk.chkNullString(request.getParameter("__saladesc"));
String col1 = chk.chkNullString(request.getParameter("__column1"));
String col2 = chk.chkNullString(request.getParameter("__column2"));
String col3 = chk.chkNullString(request.getParameter("__column3"));
String col4 = chk.chkNullString(request.getParameter("__column4"));
String col5 = chk.chkNullString(request.getParameter("__column5"));
String col6 = chk.chkNullString(request.getParameter("__column6"));
String col7 = chk.chkNullString(request.getParameter("__column7"));
String col8 = chk.chkNullString(request.getParameter("__column8"));
String language = screen.getUProfile().get("lang");
String getColumn = chk.chkNullString(request.getParameter("__getColumnID"),"");
String getColumnDesc = chk.chkNullString(request.getParameter("__getColumnDesc"),"");
String getFixcon = chk.chkNullString(request.getParameter("__fixCon"),"");
String getGroupby = chk.chkNullString(request.getParameter("__groupby"));
String cmd = request.getParameter("__cmd");
String goPage = chk.chkNullString(request.getParameter("__goPage"),"1");
goPage = goPage.replace("+","");
goPage = goPage.replace("-","");
String[] listColumn = {""};
String[] listColumnDesc = {""};
if(!getColumn.equals("")){
if(getColumn.indexOf(",")>-1){
listColumn = getColumn.split(",");
listColumnDesc = getColumnDesc.split(",");
}else if(!getColumn.equals("")){
listColumn[0] = getColumn;
listColumnDesc[0] = getColumnDesc;
}
}
screen.inq.setColumn("employeeid,emp_prefix,fname,efname,lname,elname,fullname,bu1,bu1name,bu2,bu2name,bu3,bu3name,bu4,bu4name,bu5,bu5name,branch,branchname");
if(getFixcon!=null && !getFixcon.equals("")){
screen.inq.setFilter(getFixcon+" and employeeid in (select employeeid from tpytran0)");
} else {
screen.inq.setFilter("employeeid in (select employeeid from tpytran0)");
}
if(getGroupby!=null && !getGroupby.equals("")){
screen.inq.setOrderBy(getGroupby);
}
int maxLine = 50;
int beginRow=((Integer.parseInt(goPage)-1)*maxLine)+1;
int endRow=(Integer.parseInt(goPage))*maxLine;
//screen.currentPage = goPage;
screen.setMaxLine(maxLine);
screen.inq.refresh();
screen.inq.setBetween(beginRow, endRow);
screen.inq.clearOldCondition();
screen.countRec(screen.inq);
screen.inq.setRefreshBeforeNext(true);
%>
<head>
<title>Current Payment Record</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>
<link href="../CSS/Bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<script src="../JS/SCREEN.js"></script>
<script src="../JS/angular-1.3.15/angular.js"></script>
<script type='text/JavaScript' SRC='../JS/ANGULAR/SCREEN_ANGULAR.js'></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script>getTitleName();</script>
<style>
td.result {
border: 1px solid black;
}
td.init{
height: 0px;
}
</style>
<script type="text/JavaScript">
var lang = getLang();
//-->
var sw = new swaplang2();
//------- Global value --------
var jsonArray = [];
function goHelp(helpName,inputName){
var helpReturn;
var fixcon;
if(inputName.indexOf("__column") > -1){ //ex__column1_desc
if(getLang() === 'tha'){
helpReturn = inputName+":formulaid,"+inputName+"_desc:tdesc"
}else{
helpReturn = inputName+":formulaid,"+inputName+"_desc:edesc"
}
var fixcon = "groupincid != '1' and upper(formulaid) not like '%25TAX%25' and upper(formulaid) not like '%25TOT%25' and formulaid in (select formulaid from tpytran1) and formulaid not in ('"+getColumn()+"')";
linkHelp_Return_CallFunction(helpName,helpReturn,"checkColumn",fixcon);
}else{
if(inputName.indexOf("__emp") > -1){
helpReturn = inputName+":employeeid"
}else if(inputName=="__bu1" ){
if(getLang() === 'tha'){
helpReturn="__bu1:bu1id,__bu1_desc:tdesc";
}else{
helpReturn="__bu1:bu1id,__bu1_desc:edesc";
}
}
else if(inputName=="__bu2" ){
if(getLang() === 'tha'){
helpReturn="__bu2:bu2id,__bu2_desc:tdesc";
}else{
helpReturn="__bu2:bu2id,__bu2_desc:edesc";
}
}
else if(inputName=="__bu3" ){
if(getLang() === 'tha'){
helpReturn="__bu3:bu3id,__bu3_desc:tdesc";
}else{
helpReturn="__bu3:bu3id,__bu3_desc:edesc";
}
}
else if(inputName=="__bu4" ){
if(getLang() === 'tha'){
helpReturn="__bu4:bu4id,__bu4_desc:tdesc";
}else{
helpReturn="__bu4:bu4id,__bu4_desc:edesc";
}
}
else if(inputName=="__bu5" ){
if(getLang() === 'tha'){
helpReturn="__bu5:bu5id,__bu5_desc:tdesc";
}else{
helpReturn="__bu5:bu5id,__bu5_desc:edesc";
}
}else if(inputName=="__salatype" ){
if(getLang() === 'tha'){
helpReturn="__salatype:codeid,__saladesc:tdesc";
}else{
helpReturn="__salatype:codeid,__saladesc:edesc";
}
}
linkHelp_Return(helpName,helpReturn);
}
}
function getColumn(){
with(document.cscform){
var myColumn = "";
var column1 = __column1.value;
var column2 = __column2.value;
var column3 = __column3.value;
var column4 = __column4.value;
var column5 = __column5.value;
var column6 = __column6.value;
var listColumn = [column1,column2,column3,column4,column5,column6];
for(var i = 0;i<listColumn.length;i++){
if(listColumn[i]!==""){
if(myColumn.length > 0){
myColumn += "','";
}
myColumn += listColumn[i];
}
}
console.log("myColumn ==> "+myColumn);
return myColumn;
}
}
function linkHelp_Return_CallFunction(help,input,newFunction,fixCon){
with( document.cscform ){
var filter = fixCon || __fixCon.value;
var param="BROWSE_TIMEHELP.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off&__langOn=off&__callFunction="+newFunction;
window.open(param,"Help","left=150,top=150,width=530,height=370,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
function checkColumn(){ //Function for check duplicate column
/*with(document.cscform){
var column1 = __column1.value;
var column2 = __column2.value;
var column3 = __column3.value;
var column4 = __column4.value;
var column5 = __column5.value;
var column6 = __column6.value;
var listColumn = [column1,column2,column3,column4,column5,column6];
var checkDuplicate = false;
var breakLoop = false;
for(var i = 0;i<listColumn.length;i++){
for(var j = 0;j<listColumn.length;j++){
if(i === j){
//Do Nothing because it is same value.
}else if(listColumn[i] === ""||listColumn[j] === ""){
}
else if(listColumn[i] === listColumn[j]){
checkDuplicate = true;
breakLoop = true;
}
if(checkDuplicate){
var pos = j;
if(lang === 'tha'){
alert("คอลัมน์ที่"+pos+" มีค่าที่ซ้ำกับคอลัมน์อื่นๆ");
}else{
alert("This Column"+pos+" is duplicate with other column.");
}
switch(pos){
case 1: __column1.value = "";
__column1_desc.value = "";
break;
case 2: __column2.value = "";
__column2_desc.value = "";
break;
case 3: __column3.value = "";
__column3_desc.value = "";
break;
case 4: __column4.value = "";
__column4_desc.value = "";
break;
case 5: __column5.value = "";
__column5_desc.value = "";
break;
case 6: __column6.value = "";
__column6_desc.value = "";
break;
}
break;
}
}
if(breakLoop){
break;
}
}
}*/
}
function GoSearch(){
with(document.cscform){
//Check column
/*if(__column1.value =="" && __column2.value =="" && __column3.value =="" && __column4.value =="" && __column5.value =="" && __column6.value =="" ){
if(getLang() === 'tha'){
alert("กรุณาเลือกคอลัมน์ก่อน");
}else{
alert("Please Choose Column First.");
}
}else{*/
var filterheal="";
filterheal=checkCondition2(filterheal,__emp1,__emp2,"employeeid")
filterheal=checkCondition(filterheal,__bu1,"bu1");
filterheal=checkCondition(filterheal,__bu2,"bu2");
filterheal=checkCondition(filterheal,__bu3,"bu3");
filterheal=checkCondition(filterheal,__bu4,"bu4");
filterheal=checkCondition(filterheal,__bu5,"bu5");
filterheal=checkCondition(filterheal,__salatype,"salatype");
__fixCon.value=filterheal;
console.log("filterheal => "+__fixCon.value);
//Get column to set value
var column1 = __column1.value;
var column2 = __column2.value;
var column3 = __column3.value;
var column4 = __column4.value;
var column5 = __column5.value;
var column6 = __column6.value;
var column1desc = __column1_desc.value;
var column2desc = __column2_desc.value;
var column3desc = __column3_desc.value;
var column4desc = __column4_desc.value;
var column5desc = __column5_desc.value;
var column6desc = __column6_desc.value;
var getColumn = "";
var getColumnDesc = "";
var listColumn = [column1,column2,column3,column4,column5,column6];
var listColumnDesc = [column1desc,column2desc,column3desc,column4desc,column5desc,column6desc];
for(var i = 0;i<listColumn.length;i++){
if(listColumn[i]!==""){
getColumn += listColumn[i]+",";
getColumnDesc += listColumnDesc[i]+",";
}
}
getColumn = getColumn.substring(0,getColumn.length-1);
console.log("getColumn => "+getColumn);
getColumnDesc = getColumnDesc.substring(0,getColumnDesc.length-1);
__getColumnID.value = getColumn;
__getColumnDesc.value = getColumnDesc;
search();
//}
}
}
function checkCondition(filcon,objname,targetname){
with(document.cscform){
if(objname.value.length>0){
filcon=checkFilter(filcon);
filcon+= targetname+"='"+objname.value+"'";
}
return filcon;
}
}
function checkCondition2(filcon,objname1,objname2,targetname){ // For EmployeeID (Between)
with(document.cscform){
var emp1 = objname1.value;
var emp2 = objname2.value;
if(emp1 === "" && emp2===""){
return filcon;
}else if(emp1 === ""){
emp1 = emp2;
}else if(emp2 === ""){
emp2 = emp1;
}
filcon = checkFilter(filcon);
filcon += targetname+" between '"+emp1+"' and '"+emp2+"'";
return filcon;
}
}
function checkFilter(fil){
if(fil.length>0)
fil+=" and ";
return fil;
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="cscform" method="post" action ="PRU173.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<input type="hidden" name="__cmd" value="<%=request.getParameter("__cmd")%>">
<input type="hidden" name="__screen" value="PRU173">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__calendar" value="">
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>">
<input type="hidden" name="__filterMemployee" value="companyid='<%=screen.getUProfile().get("companyid")%>'">
<input type="hidden" name="__referPage" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__fixCon" value="<%=getFixcon%>">
<input type="hidden" name="__getColumnDesc" value="<%=getColumnDesc%>">
<input type="hidden" name="__getColumnID" value="<%=getColumn%>">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__chkcolumn" value="">
<!----------END CSC INITIAL ZONE -------------------------->
<br>
<div align="center">
<table height="" align="center" cellpadding="0" cellspacing="0" border="1" class="largest">
<tr bgcolor="#3366CC">
<td height="20" class="header" colspan="4">PRU173, <%=language.equals("tha")?"ข้อมูลหลังการคำนวณเงินเดือนพนักงานทั้งหมด":"Current Payment Record"%> </td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td align="right"><strong><!-- <swaplang code='SW000350'></swaplang> --><script>sw.write('SW000350');</script> </strong></td>
<td colspan="3"><input type="text" name="__emp1" size="15" value="<%=emp1%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image2" border="0" align="absmiddle"></a> -
<input type="text" name="__emp2" size="15" value="<%=emp2%>">
<a href="javascript:goHelp('MEMPLOYEEHELP','__emp2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="Image3" border="0" align="absmiddle"></a></span> </td>
</tr>
<tr>
<td align="right"><%=screen.getLabel("bu1")%> </td>
<td colspan="3"><input type="text" name="__bu1" size="15" value="<%=bu1%>">
<a href="javascript:goHelp('MBU1HELP','__bu1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu1" border="0" align="absmiddle"></a>
<input name="__bu1_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__bu1_desc"))%>" size="35" readonly=""> </td>
</tr>
<tr>
<td align="right"><%=screen.getLabel("bu2")%> </td>
<td colspan="3"><input type="text" name="__bu2" size="15" value="<%=bu2%>">
<a href="javascript:goHelp('MBU2HELP','__bu2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu2" border="0" align="absmiddle"></a>
<input name="__bu2_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__bu2_desc"))%>" size="35" readonly=""> </td>
</tr>
<tr>
<td align="right"><%=screen.getLabel("bu3")%> </td>
<td colspan="3"><input type="text" name="__bu3" size="15" value="<%=bu3%>">
<a href="javascript:goHelp('MBU3HELP','__bu3')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu3" border="0" align="absmiddle"></a>
<input name="__bu3_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__bu3_desc"))%>" size="35" readonly=""> </td>
</tr>
<tr>
<td align="right"><%=screen.getLabel("bu4")%> </td>
<td colspan="3"><input type="text" name="__bu4" size="15" value="<%=bu4%>">
<a href="javascript:goHelp('MBU4HELP','__bu4')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu4" border="0" align="absmiddle"></a>
<input name="__bu4_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__bu4_desc"))%>" size="35" readonly=""> </td>
</tr>
<tr>
<td align="right"><%=screen.getLabel("bu5")%> </td>
<td colspan="3"><input type="text" name="__bu5" size="15" value="<%=bu5%>">
<a href="javascript:goHelp('MBU5HELP','__bu5')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgBu5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgBu5" border="0" align="absmiddle"></a>
<input name="__bu5_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__bu5_desc"))%>" size="35" readonly=""></td>
</tr>
<tr>
<td align="right"><!-- <swaplang code='SW000865'></swaplang> --><%=language.equals("tha")?"ประเภทการจ่ายเงิน":"Salary Type"%> </td>
<td colspan="3"><!-- Salary Type -->
<input type="Text" name="__salatype" size="5" maxlength="5" value="<%=salatype%>" onkeypress="chkSpecialStr(event);" onkeyup="sysIsEdit();" onblur="trimValue(this);" onfocus="this.select();" alt="Salary Type" onmousemver="toolTip('Salary Type')" onmouseout="toolTip()">
<a href="javascript:goHelp('MSALATYPE0HELP','__salatype');" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('__salatype_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="SEARCH" name="__salatype_image" border="0" align="absmiddle"></a>
<input type="Text" name="__saladesc" size="35" value="<%=saladesc%>" readonly>
</td>
</tr>
<tr>
<td><div align="right"><!-- <swaplang code='SW000004'></swaplang> --><script>sw.write('SW000004');</script> </div></td>
<td colspan="3">
<select name="__groupby" id="__groupby">
<option value="employeeid" <%=(getGroupby.equals("employeeid"))?"selected":""%>><%=language.equals("tha")?"รหัสพนักงาน":"Employee ID"%></option>
<option value="bu1" <%=(getGroupby.equals("bu1"))?"selected":""%>><%=language.equals("tha")?"หน่วยงานระดับที่ 1":"Business Unit 1"%></option>
<option value="bu2" <%=(getGroupby.equals("bu2"))?"selected":""%>><%=language.equals("tha")?"หน่วยงานระดับที่ 2":"Business Unit 2"%></option>
<option value="bu3" <%=(getGroupby.equals("bu3"))?"selected":""%>><%=language.equals("tha")?"หน่วยงานระดับที่ 3":"Business Unit 3"%></option>
<option value="bu4" <%=(getGroupby.equals("bu4"))?"selected":""%>><%=language.equals("tha")?"หน่วยงานระดับที่ 4":"Business Unit 4"%></option>
<option value="bu5" <%=(getGroupby.equals("bu5"))?"selected":""%>><%=language.equals("tha")?"หน่วยงานระดับที่ 5":"Business Unit 5"%></option>
<option value="salatype" <%=(getGroupby.equals("salatype"))?"selected":""%>><%=language.equals("tha")?"ประเภทการจ่ายเงิน":"Salary Type"%></option>
</select>
</td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td align="right" style="font-size:14px;"><b><%=language.equals("tha")?"แสดงคอลัมน์":"Show Column"%></b></td>
<td class="blankspace" colspan="3"></td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 1":"Column 1"%> </td>
<td><input type="text" name="__column1" size="15" value="<%=col1%>">
<a href="javascript:goHelp('MFORMULAHELP','__column1')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn1','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn1" border="0" align="absmiddle"></a>
<input name="__column1_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column1_desc"))%>" size="20" readonly="">
</td>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 4":"Column 4"%> </td>
<td><input type="text" name="__column4" size="15" value="<%=col4%>">
<a href="javascript:goHelp('MFORMULAHELP','__column4')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn4','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn4" border="0" align="absmiddle"></a>
<input name="__column4_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column4_desc"))%>" size="20" readonly="">
</td>
</tr>
<tr>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 2":"Column 2"%> </td>
<td><input type="text" name="__column2" size="15" value="<%=col2%>">
<a href="javascript:goHelp('MFORMULAHELP','__column2')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn2','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn2" border="0" align="absmiddle"></a>
<input name="__column2_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column2_desc"))%>" size="20" readonly="">
</td>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 5":"Column 5"%> </td>
<td><input type="text" name="__column5" size="15" value="<%=col5%>">
<a href="javascript:goHelp('MFORMULAHELP','__column5')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn5','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn5" border="0" align="absmiddle"></a>
<input name="__column5_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column5_desc"))%>" size="20" readonly="">
</td>
</tr>
<tr>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 3":"Column 3"%> </td>
<td><input type="text" name="__column3" size="15" value="<%=col3%>">
<a href="javascript:goHelp('MFORMULAHELP','__column3')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn3','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn3" border="0" align="absmiddle"></a>
<input name="__column3_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column3_desc"))%>" size="20" readonly="">
</td>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 6":"Column 6"%> </td>
<td><input type="text" name="__column6" size="15" value="<%=col6%>">
<a href="javascript:goHelp('MFORMULAHELP','__column6')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn6','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn6" border="0" align="absmiddle"></a>
<input name="__column6_desc" type="text" value="<%=chk.chkNullString(request.getParameter("__column6_desc"))%>" size="20" readonly="">
</td>
</tr>
<tr>
<td class="blankspace" colspan="4"></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 class="blankspace" colspan="4"></td>
</tr>
<!-- Create Table. -->
<%//if(cmd != null && cmd.equals("search")){%>
<tr>
<td colspan="2"><div>
<span swlang code="SW000927">Found Data</span> :: <%=screen.getRecCount()%></div></td>
<td colspan="2"><div align="right"><span swlang code="SW001120">Page</span> :: <%=screen.getPageTag()%> </div></td>
</tr>
<tr>
<td colspan="4">
<table border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808080" class="large">
<tr align="center">
<td class="result row3"><b><%=language.equals("tha")?"รหัสพนักงาน":"Employee ID"%></b></td>
<td class="result row3"><b><%=language.equals("tha")?"ชื่อ - นามสกุล":"Name - Surname"%></b></td>
<td class="result row3"><b><%=language.equals("tha")?"เงินเดือน":"Salary"%></b></td>
<%for(int i = 0;i<listColumnDesc.length;i++){ if(!listColumnDesc[i].equals("")){%> <td class="result row3"><b>[<%=i+1%>] <%=listColumnDesc[i]%></b></td> <%}}%>
<td class="result row3"><b><%=language.equals("tha")?"รวมเงินได้":"Total Income"%></b></td>
<td class="result row3"><b><%=language.equals("tha")?"รวมเงินหัก":"Total Deduct"%></b></td>
<td class="result row3"><b><%=language.equals("tha")?"รายได้สุทธิ":"Net Pay"%></b></td>
</tr>
<%!
private String getFormat(Double amount){
BigDecimal bctotal = new BigDecimal(amount);
DecimalFormat df = new DecimalFormat("###,##0.00");
return df.format(bctotal);
}
%>
<%//Create Data
/*DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");
inqEmp.setColumn("employeeid,emp_prefix,fname,efname,lname,elname,fullname,bu1,bu1name,bu2,bu2name,bu3,bu3name,bu4,bu4name,bu5,bu5name,branch,branchname");
if(getFixcon!=null||!getFixcon.equals("")){
inqEmp.setFilter(getFixcon+" and employeeid in (select employeeid from tpytran0)");
}
if(getFixcon!=null||!getFixcon.equals("")){
inqEmp.setOrderBy(getGroupby);
}
inqEmp.refresh();*/
String sql = "";
DataSet ds = null;
while(screen.nextRec()){
%>
<tr>
<td align="center" class="result" name="employeeid"> <a href="PRU029_NSTDA.jsp?empid=<%=screen.getString("employeeid")%>"><%=screen.getString("employeeid")%></a></td>
<td align="left" class="result" name="fullname"> <a href="PRU029_NSTDA.jsp?empid=<%=screen.getString("employeeid")%>"><%=screen.getString("fullname")%></a></td>
<%
Double salary = 0.0;
if(screen.getUProfile().getDbType().equalsIgnoreCase("PGSQL") || screen.getUProfile().getDbType().equalsIgnoreCase("ORACLE")){
sql = "select base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.groupincid = '1' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
} else {
sql = "select dbo.base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.groupincid = '1' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
}
ds = new DataSet(sql,screen.getUProfile().get("dbname"),"TPYTRAN1");
ds.initConnection(screen.getUProfile());
while(ds.next()){
salary += Double.valueOf(ds.getString("cur_amount"));
}
ds.closeConnection();
%>
<td align="right" class="result"><%=getFormat(salary)%> </td>
<%
for(int i = 0;i<listColumn.length;i++){
if(!listColumn[i].equals("")){
Double cur_amount=0.0;
DbInquiry inqAMT = new InitialInquiry(screen.getUProfile()).getDbInquiry("tpytran1");
inqAMT.setParam("__securityField","OFF");
inqAMT.setParam("rsc_skip","true");
inqAMT.setColumn("cur_amount");
inqAMT.setFilter("formulaid ='"+listColumn[i]+"' and employeeid ='"+screen.getString("employeeid")+"'");
inqAMT.refresh();
while(inqAMT.next()){
cur_amount += Double.valueOf(inqAMT.getString("cur_amount"));
}
String formula_amount = getFormat(cur_amount);
if(inqAMT.recCount() == 0){ formula_amount = "--"; }
%>
<td align="right" class="result"><%=formula_amount%> </td>
<%
}
}
%>
<%
Double total_income = 0.0;
if(screen.getUProfile().getDbType().equalsIgnoreCase("PGSQL") || screen.getUProfile().getDbType().equalsIgnoreCase("ORACLE")){
sql = "select base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.formula_type = '1' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
} else {
sql = "select dbo.base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.formula_type = '1' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
}
ds = new DataSet(sql,screen.getUProfile().get("dbname"),"TPYTRAN1");
ds.initConnection(screen.getUProfile());
while(ds.next()){
total_income += Double.valueOf(ds.getString("cur_amount"));
}
ds.closeConnection();
%>
<td align="right" class="result"><%=getFormat(total_income)%> </td>
<%
Double total_deduct = 0.0;
if(screen.getUProfile().getDbType().equalsIgnoreCase("PGSQL") || screen.getUProfile().getDbType().equalsIgnoreCase("ORACLE")){
sql = "select base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.formula_type = '2' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
} else {
sql = "select dbo.base64decoder(tpy.cur_amount) as cur_amount from tpytran1 as tpy INNER JOIN mformula as fml on tpy.formulaid = fml.formulaid and fml.formula_type = '2' "
+ "and upper(tpy.formulaid) not like '%TAX%' and upper(tpy.formulaid) not like '%TOT%' where tpy.employeeid = '"+screen.getString("employeeid")+"'";
}
ds = new DataSet(sql,screen.getUProfile().get("dbname"),"TPYTRAN1");
ds.initConnection(screen.getUProfile());
while(ds.next()){
total_deduct += Double.valueOf(ds.getString("cur_amount"));
}
ds.closeConnection();
%>
<td align="right" class="result"><%=getFormat(total_deduct)%> </td>
<%
Double netpay=0.0;
DbInquiry inqNETPAY = new InitialInquiry(screen.getUProfile()).getDbInquiry("tpytran0");
inqNETPAY.setParam("__securityField","OFF");
inqNETPAY.setParam("rsc_skip","true");
inqNETPAY.setColumn("netincome");
inqNETPAY.setFilter("employeeid ='"+screen.getString("employeeid")+"'");
inqNETPAY.refresh();
while(inqNETPAY.next()){
netpay += Double.valueOf(inqNETPAY.getString("netincome"));
}
%>
<td align="right" class="result"><%=getFormat(netpay)%> </td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<%//}%>
<tr>
<td colspan="4" class="blankspace"></td>
</tr>
</table>
</div>
</form>
</body>
</html>