<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset=UTF-8"%>
<%@ page import="com.csc.library.entry.*,com.csc.library.system.*,com.csc.library.utilities.*,com.csc.library.session.*,com.csc.library.components.*,com.csc.library.report.*,java.util.*,java.text.DecimalFormat,java.math.BigDecimal;"%>
<jsp:useBean id="PRU169" scope="page" class="com.csc.library.system.Task" />
<html ng-app="myHR">
<%
CheckNull chk = new CheckNull();
CscCalendar cs = new CscCalendar();
PRU169.setChannel(request ,response);
HelpEntry screen = (HelpEntry) PRU169.process("HelpEntry", "PRU169HELP");
UIManager screenCon = (UIManager) PRU169.process("SingleEntry","MEMPL_AMTCONDITION");
String col1 = "",col2 = "",col3 = "",col4 = "",col5 = "",col6 = "",col7 = "",col8 = "";
HashMap myDesc = new HashMap();
DbInquiry inqAmTab = new InitialInquiry(screenCon.getUProfile()).getDbInquiry("mamounttab");
inqAmTab.setColumn("*");
inqAmTab.refresh();
if (inqAmTab.recCount()>0){
while (inqAmTab.next()){
myDesc.put(inqAmTab.getString("amounttabid"),inqAmTab.getString("edesc"));
}
}
DbInquiry inqCon = new InitialInquiry(screenCon.getUProfile()).getDbInquiry("mempl_amtcondition");
inqCon.setColumn("*");
inqCon.refresh();
if (inqCon.recCount()>0){
inqCon.next();
if (!chk.chkNullString(inqCon.getString("column1")).equals("")){
col1 = inqCon.getString("column1");
//listcol +=",'"+col1+"'";
}
if (!chk.chkNullString(inqCon.getString("column2")).equals("")){
col2 = inqCon.getString("column2");
//listcol +=",'"+col2+"'";
}
if (!chk.chkNullString(inqCon.getString("column3")).equals("")){
col3 = inqCon.getString("column3");
//listcol +=",'"+col3+"'";
}
if (!chk.chkNullString(inqCon.getString("column4")).equals("")){
col4 = inqCon.getString("column4");
//listcol +=",'"+col4+"'";
}
if (!chk.chkNullString(inqCon.getString("column5")).equals("")){
col5 = inqCon.getString("column5");
//listcol +=",'"+col5+"'";
}
if (!chk.chkNullString(inqCon.getString("column6")).equals("")){
col6 = inqCon.getString("column6");
//listcol +=",'"+col6+"'";
}
if (!chk.chkNullString(inqCon.getString("column7")).equals("")){
col7 = inqCon.getString("column7");
//listcol +=",'"+col7+"'";
}
if (!chk.chkNullString(inqCon.getString("column8")).equals("")){
col8 = inqCon.getString("column8");
//listcol +=",'"+col8+"'";
}
/*listcol = listcol.substring(1,listcol.length());
listcol = "("+listcol+")";*/
}
//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"));
if (!chk.chkNullString(request.getParameter("__column1")).equals("")){
col1 = chk.chkNullString(request.getParameter("__column1"));
}
if (!chk.chkNullString(request.getParameter("__column2")).equals("")){
col2 = chk.chkNullString(request.getParameter("__column2"));
}
if (!chk.chkNullString(request.getParameter("__column3")).equals("")){
col3 = chk.chkNullString(request.getParameter("__column3"));
}
if (!chk.chkNullString(request.getParameter("__column4")).equals("")){
col4 = chk.chkNullString(request.getParameter("__column4"));
}
if (!chk.chkNullString(request.getParameter("__column5")).equals("")){
col5 = chk.chkNullString(request.getParameter("__column5"));
}
if (!chk.chkNullString(request.getParameter("__column6")).equals("")){
col6 = chk.chkNullString(request.getParameter("__column6"));
}
if (!chk.chkNullString(request.getParameter("__column7")).equals("")){
col7 = chk.chkNullString(request.getParameter("__column7"));
}
if (!chk.chkNullString(request.getParameter("__column8")).equals("")){
col8 = chk.chkNullString(request.getParameter("__column8"));
}
chk.chkNullString(request.getParameter("__column1_desc"));
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[] listColumn = {""};
String[] listColumnDesc = {""};
if(!getColumn.equals("")){
if(getColumn.indexOf(",")>-1){
listColumn = getColumn.split(",");
listColumnDesc = getColumnDesc.split(",");
}else{
listColumn[0] = getColumn;
listColumnDesc[0] = getColumnDesc;
}
}
screenCon.referLangOn();
%>
<head>
<title>ReportOption</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 type='text/javascript' src='../JS/jquery-1.11.1.min.js'></script>
<script src="../JS/jquery-1.11.2.js" type="text/javascript"></script>
<script src="../JS/jquery-ui-1.11.4.js" type="text/javascript"></script>
<script type='text/javascript' src='../JS/bootstrap.js'></script>
<SCRIPT TYPE='text/JavaScript' SRC='../TA/JS/TA_SCREEN.js'></SCRIPT>
<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 type='text/JavaScript' SRC='../JS/ANGULAR/SWAPLANG.js'></script> -->
<script type="text/javascript" src="/hr/dwr/interface/CscCalendar.js"></script>
<script type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script src="../JS/VIEWCALENDAR.js"></script>
<script src='../JS/ICONSMENU.js'></script>
<script src='../JS/HOTKEY.js'></script>
<script src="../JS/DATEINPUT.js"></script>
<script src="../JS/CscBase.js"></script>
<script src="../JS/CscCalendar.js"></script>
<!-- Call DWR -->
<script type='text/javascript' src='/hr/dwr/interface/SaveIrregular.js'></script>
<script type='text/javascript' src='/hr/dwr/engine.js'></script>
<script type='text/javascript' src='/hr/dwr/util.js'></script>
<script>getTitleName();</script>
<script TYPE='text/JavaScript' SRC='../JS/CscCalendarV3.js'></script>
<style>
td.result {
border: 1px solid black;
}
td.init{
height: 0px;
}
</style>
<script type="text/JavaScript">
setLang('<%=screen.getUProfile().get("lang")%>');
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+":Amounttabid,"+inputName+"_desc:tdesc"
}else{
helpReturn = inputName+":Amounttabid,"+inputName+"_desc:edesc"
}
linkHelp_Return_CallFunction(helpName,helpReturn,"checkColumn");
}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 linkHelp_Return(help,input, fixCon){
with(document.cscform){
var nInput = input;
var language = getLang();
var filter = fixCon || __fixCon.value;
if(input.indexOf(":")>0){
nInput=input.substring(0,input.indexOf(":"));
}
obj = eval("document.cscform."+nInput);
if((obj=="")||(obj.value=="")){
if(language != "eng" ){
var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
}else{
var param="PRU084_REFERLANG.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
}
}else{
if(language != "eng" ){
var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"+"&__valueSearch="+obj.value;
}else{
var param="PRU084_REFERLANG.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off"+"&__valueSearch="+obj.value;
}
}
//var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__fixCon="+filter+"&__checkVerify=off";
win = window.open(param,"Help","left=150,top=150,width=600,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
if(window.focus){win.focus();}
}
}
*/
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 column7 = __column7.value;
var column8 = __column8.value;
var listColumn = [column1,column2,column3,column4,column5,column6,column7,column8];
var checkDuplicate = false;
var breakLoop = false;
for(var i = 1;i<=listColumn.length;i++){
for(var j = 1;j<=listColumn.length;j++){
if(i === j){
//Do Nothing because it is same value.
}else if(listColumn[i-1] === ""||listColumn[j-1] === ""){
}
else if(listColumn[i-1] === listColumn[j-1]){
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;
case 7: __column7.value = "";
__column7_desc.value = "";
break;
case 8: __column8.value = "";
__column8_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 =="" && __column7.value =="" && __column8.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(__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 column7 = __column7.value;
var column8 = __column8.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 column7desc = __column7_desc.value;
var column8desc = __column8_desc.value;
var getColumn = "";
var getColumnDesc = "";
var listColumn = [column1,column2,column3,column4,column5,column6,column7,column8];
var listColumnDesc = [column1desc,column2desc,column3desc,column4desc,column5desc,column6desc,column7desc,column8desc];
for(var i = 0;i<listColumn.length;i++){
if(listColumn[i]===""){
//Do Nothing
}else{
getColumn += listColumn[i]+",";
getColumnDesc += listColumnDesc[i]+","
}
}
getColumn = getColumn.substring(0,getColumn.length-1);
getColumnDesc = getColumnDesc.substring(0,getColumnDesc.length-1);
__getColumnID.value = getColumn;
__getColumnDesc.value = getColumnDesc;
console.log(__getColumnID.value);
console.log(__getColumnDesc.value);
search();
}
}
}
function GoSave(){
with(document.cscform){
var getColumn = __getColumnID.value;
//Sent to DWR to Save
waitingDialog.show('Processing');
SaveIrregular.saveRecord(getColumn,JSON.stringify(jsonArray),AfterSaveIrregular);
}
}
function GoSaveCondition(){
var checkMyData = <%=inqCon.recCount()%>;
with(document.cscform){
if (checkMyData>0){
__conid.value = "1";
update();
}else{
__conid.value = "0";
console.log(__conid.value);
confirmSave();
}
}
}
function checkNumFloat(obj,min,max){
if (obj.value != "") {
var thisvalue = obj.value;
if(thisvalue.indexOf(",")>-1){
thisvalue = thisvalue.replace(",","");
}
obj.value = parseFloat(thisvalue)+""; // แปลงจาก 01234.xx เป็น 1234.xx
checkInputComma(obj); // ถ้าพิม xxx ก็ให้เป็น xxx.00
if (min >= 0 && max > 0) {
callMaxMin(obj,min,max); // ตรวจดูว่าค่าที่กรอกเกินค่าสูงสุด หรือต่ำกว่าค่าต่ำสุดหรือไม่
}
insertComma(obj); //123456 ==> 123,456
}
}
function checkInputComma(obj) {
var temp = obj.value.split(".");
if (temp.length == 2) {
if (temp[1].length == 0) {
obj.value = obj.value + "00";
}
else if (temp[1].length == 1) {
obj.value = obj.value + "0";
}
}
else {
obj.value = obj.value + ".00";
}
}
$(document).ready(function(){
/*
$(".chkinput" ).on("focus",function() {
inputvalue = $(this).val();
chkInteger(inputvalue);
});
*/
$(".chkinput" ).blur(function(){
var thisfieldname = $(this).attr('id');
var getpos = thisfieldname.split("$");
var posCol = getpos[1];
var posRow = getpos[0].substring(5,getpos[0].length);
var backfielddata = "#backup"+posRow+"_"+posCol;
//check save emp
var fullempdata = $("[name=emp"+posRow+"]").text();
var splitEmpID = fullempdata.split(" ");
var empid = splitEmpID[0];
var input= $(this).val();
var chk = false;
for (var i=0; i<jsonArray.length; i++){
if (jsonArray[i]["empid"] === empid){
var valuesOfThisEmployee = jsonArray[i]["value"];
var thisfield = "val$"+posCol;
for(var j = 0;j<valuesOfThisEmployee.length;j++){
if(valuesOfThisEmployee[j][thisfield]){
if(input == null ||input ==""){
valuesOfThisEmployee.splice(j, 1);
chk = true;
}
}
}
}
}
if(chk){
//Do nothing (done in loop)
console.log("jsonArray ==> "+JSON.stringify( jsonArray ));
}else{
var test = input.match("^[0-9]+(\.[0-9]{1,2})*$");
if (test==null)
{
var backdata = $(backfielddata).val();
if (backdata!=""){
$(this).val(backdata);
}else{
$(this).val("");
}
console.log("jsonArray ==> "+JSON.stringify( jsonArray ));
}else{
setObjValue($(this).attr('id'),$(this).val());
}
}
});
function setObjValue(dataname,value){ //Ex field1$1
//var thisvalue = $(".input[name="+dataname+"]").val();
dataname = dataname.substring(5,dataname.length);
var inputname = dataname.split("$");
var row = inputname[0];
var column = inputname[1];
inputname = "emp"+row;
var empid = $("[name="+inputname+"]").text();
setObjArray(empid,value,row,column);
console.log("jsonArray ==> "+JSON.stringify( jsonArray ));
}
function setObjArray(empid,value,row,column){
var chk = true;
var chk2 = true;
var splitEmpID = empid.split(" ");
for (var i=0; i<jsonArray.length; i++){
if (jsonArray[i]["empid"] === splitEmpID[0]) {
var ThisEmployee = jsonArray[i]["empid"];
var valuesOfThisEmployee = jsonArray[i]["value"];
if(ThisEmployee === splitEmpID[0]){
var thisfield = "val$"+column;
for(var j = 0;j<valuesOfThisEmployee.length;j++){
if(valuesOfThisEmployee[j][thisfield]){
if(value == null ||value ==""){
valuesOfThisEmployee[j][thisfield] = " ";
chk2 = false;
}else{
valuesOfThisEmployee[j][thisfield] = value;
chk2 = false;
}
break;
}
}
if(chk2){
var obj = {};
obj[thisfield] = value;
valuesOfThisEmployee.push(obj);
}
chk = false;
}
}
}
if(chk){
var values = [];
var thisfield = "val$"+column;
var obj = {};
obj[thisfield] = value;
values.push(obj);
jsonArray.push({"empid":splitEmpID[0], "value":values});
}
}
});
function AfterSaveIrregular(data){
waitingDialog.hide();
alert(data);
}
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 ="PRU169.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<input type="hidden" name="__cmd" value="<%=request.getParameter("__cmd")%>">
<input type="hidden" name="__screen" value="PRU169">
<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="__fixCon" value="">
<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="__notNull" value="<%=screenCon.getRequire()%>">
<input type="hidden" name="__conid" value="">
<br/>
<!----------END CSC INITIAL ZONE -------------------------->
<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">PRU169,<span swlang code="SW012695">Irregular Income and Deduction for Employee</span> </td>
</tr>
<tr>
<td class="blankspace" colspan="4"></td>
</tr>
<tr>
<td align="right"><strong><!-- <swaplang code='SW000350'></swaplang> --><!-- <script>sw.write('SW000350');</script> --><span swlang code="SW000274">Employee ID</span> </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>
<%
DbInquiry memployee = new InitialInquiry(screen.getUProfile()).getDbInquiry("memployee");
memployee.setColumn("employeeid,companyid,bu1,bu2,bu3,bu4,bu5");
memployee.refresh();
DbRecord mbu = memployee.getCurrentDbRecord();
%>
<tr>
<td align="right"><%=mbu.getField("bu1").getDescription()%> </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"><%=mbu.getField("bu2").getDescription()%> </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"><%=mbu.getField("bu3").getDescription()%> </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"><%=mbu.getField("bu4").getDescription()%> </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"><%=mbu.getField("bu5").getDescription()%> </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> --><span swlang code="SW000004">Order By</span> </div></td>
<td colspan="3">
<select name="__groupby" id="__groupby"">
<option value=""></option>
<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('MAMOUNTTABHELP','__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="<%=(!col1.equals(""))?(String)myDesc.get(col1):""%>" 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('MAMOUNTTABHELP','__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="<%=(!col5.equals(""))?(String)myDesc.get(col5):""%>" 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('MAMOUNTTABHELP','__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="<%=(!col2.equals(""))?(String)myDesc.get(col2):""%>" 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('MAMOUNTTABHELP','__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="<%=(!col6.equals(""))?(String)myDesc.get(col6):""%>" 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('MAMOUNTTABHELP','__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="<%=(!col3.equals(""))?(String)myDesc.get(col3):""%>" size="20" readonly="">
</td>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 7":"Column 7"%> </td>
<td><input type="text" name="__column7" size="15" value="<%=col7%>">
<a href="javascript:goHelp('MAMOUNTTABHELP','__column7')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn7','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn7" border="0" align="absmiddle"></a>
<input name="__column7_desc" type="text" value="<%=(!col7.equals(""))?(String)myDesc.get(col7):""%>" size="20" readonly="">
</td>
</tr>
<tr>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 4":"Column 4"%> </td>
<td><input type="text" name="__column4" size="15" value="<%=col4%>">
<a href="javascript:goHelp('MAMOUNTTABHELP','__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="<%=(!col4.equals(""))?(String)myDesc.get(col4):""%>" size="20" readonly="">
</td>
<td align="right"><%=language.equals("tha")?"คอลัมน์ 8":"Column 8"%> </td>
<td><input type="text" name="__column8" size="15" value="<%=col8%>">
<a href="javascript:goHelp('MAMOUNTTABHELP','__column8')" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('imgColumn8','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)"><img src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" alt="Help" name="imgColumn8" border="0" align="absmiddle"></a>
<input name="__column8_desc" type="text" value="<%=(!col8.equals(""))?(String)myDesc.get(col8):""%>" 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="SW013175" onClick="GoSaveCondition();">SAVE</button>
<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="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"%></b></td>
<td class="result row3"><b><%=language.equals("tha")?"ประเภทการจ่ายเงิน":"Salary Type"%></b></td>
<%for(int i = 0;i<listColumnDesc.length;i++){%>
<td class="result row3"><b><%=listColumnDesc[i]%></b></td>
<%}%>
</tr>
<%//Create Data
DbInquiry inqEmp = new InitialInquiry(screen.getUProfile()).getDbInquiry("Memployee");
inqEmp.setColumn("employeeid,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);
}
if(getFixcon!=null||!getFixcon.equals("")){
inqEmp.setOrderBy(getGroupby);
}
inqEmp.refresh();
int countemp = 0;
while(inqEmp.next()){
countemp++;
%>
<tr>
<td align="left" class="result" name="emp<%=countemp%>"><%=inqEmp.getString("employeeid")+" "+inqEmp.getString("fullname")%></td>
<td align="center" class="result">
<% DbInquiry inqSalatype = new InitialInquiry(screen.getUProfile()).getDbInquiry("Msalatype0");
inqSalatype.setColumn("tdesc,edesc");
inqSalatype.setFilter("codeid in (select salatype from memployee where employeeid ='"+inqEmp.getString("employeeid")+"')");
inqSalatype.refresh();
while(inqSalatype.next()){
if(language.equals("tha")){
%><%=inqSalatype.getString("tdesc")%><%
}else{
%><%=inqSalatype.getString("edesc")%><%
}
}%>
</td>
<%
for(int i = 0;i<listColumn.length;i++){
Double total=0.0;
DbInquiry inqAMT = new InitialInquiry(screen.getUProfile()).getDbInquiry("Mempl_amt");
inqAMT.setColumn("emp_data");
inqAMT.setFilter("amounttabid ='"+listColumn[i]+"' and employeeid ='"+inqEmp.getString("employeeid")+"'");
inqAMT.refresh();
while(inqAMT.next()){
if(inqAMT.getString("emp_data")==null||inqAMT.getString("emp_data").equals("")){
//Do Nothing(cannot summary)
}else{
String getEmpData = inqAMT.getString("emp_data");
getEmpData = getEmpData.replace(",","");
total = total + Double.valueOf(getEmpData);
}
}
String truetotal="0.0";
BigDecimal bctotal = new BigDecimal(total);
DecimalFormat df = new DecimalFormat("###,###,###,###.00");
truetotal = df.format(bctotal);
System.out.println("truetotal= "+truetotal);
if(inqAMT.recCount()!=0){
if(truetotal.equals(".00")){
truetotal = "0.00";
}
}
%>
<input type="hidden" id="backup<%=countemp+"_"+(i+1)%>" value="<%=(inqAMT.recCount()==0)?"":truetotal%>"></input>
<td align="center" class="result"><input type="text" class="chkinput" id="field<%=countemp+"$"+(i+1)%>" value="<%=(inqAMT.recCount()==0)?"":truetotal%>" size="10" align="right" onkeypress="checkWordNumber(this.value,event);" onkeyup="sysIsEdit();checkComma(this,2);" onblur="checkNumFloat(this,0,10000000)"></td>
<%}
%>
</tr>
<%}%>
</table>
</td>
</tr>
<tr>
<td colspan="4" class="blankspace"></td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW000117" onClick="GoSave();">SAVE</button>
</div>
</td>
</tr>
<%}%>
<tr>
<td colspan="4" class="blankspace"></td>
</tr>
</table>
</div>
<%=screenCon.endJSP()%>
</form>
</body>
<script>
//Credit by Nheung(Chamnan)
var waitingDialog = waitingDialog || (function ($) {
'use strict';
// Creating modal dialog's DOM
var $dialog = $(
'<div class="modal fade" data-backdrop="static" data-keyboard="false" tabindex="-1" role="dialog" aria-hidden="true" style="padding-top:15%; overflow-y:visible;">' +
'<div class="modal-dialog modal-m">' +
'<div class="modal-content">' +
'<div class="modal-header"><h3 style="margin:0;"></h3></div>' +
'<div class="modal-body">' +
'<div class="progress progress-striped active" style="margin-bottom:0;"><div class="progress-bar" style="width: 100%"></div></div>' +
'</div>' +
'</div></div></div>');
return {
show: function (message, options) {
// Assigning defaults
if (typeof options === 'undefined') {
options = {};
}
if (typeof message === 'undefined') {
message = 'Loading';
}
var settings = $.extend({
dialogSize: 'm',
progressType: '',
onHide: null // This callback runs after the dialog was hidden
}, options);
// Configuring dialog
$dialog.find('.modal-dialog').attr('class', 'modal-dialog').addClass('modal-' + settings.dialogSize);
$dialog.find('.progress-bar').attr('class', 'progress-bar');
if (settings.progressType) {
$dialog.find('.progress-bar').addClass('progress-bar-' + settings.progressType);
}
$dialog.find('h3').text(message);
// Adding callbacks
if (typeof settings.onHide === 'function') {
$dialog.off('hidden.bs.modal').on('hidden.bs.modal', function (e) {
settings.onHide.call($dialog);
});
}
$dialog.modal();
},
hide: function () {
$dialog.modal('hide');
}
};
})(jQuery);
</script>
</html>