<%@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.components.ListBox" %>
<%@page import="com.csc.library.entry.*,com.csc.library.database.*,com.csc.library.session.*,com.csc.library.report.ReportUDF" %>
<jsp:useBean id="PRU171" class="com.csc.library.system.Task" scope="page"/>
<%
CheckNull chk=new CheckNull();
PRU171.setChannel(request,response);
HelpEntry screen = (HelpEntry) PRU171.process("HelpEntry","MJVDATAHELP");
ReportUDF reportUDF = new ReportUDF();
String cmd = chk.chkNullString(request.getParameter("__cmd"));
String datafilter = chk.chkNullString(request.getParameter("__datafilter"));
String dataorder = chk.chkNullString(request.getParameter("__dataorder"),"jvid,acctcode asc");
String numpage = chk.chkNullString(request.getParameter("__goPage"),"1");
//out.println(cmd + numpage);
int maxLine = 50;
screen.setMaxLine(maxLine);
screen.inq.setFilter(datafilter);
screen.process();
screen.inq.setOrderBy(dataorder);
screen.inq.refresh();
%>
<html ng-app="myHR">
<head>
<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 type='text/javascript' src='../JS/ICONSMENU.js'></script>
<script type='text/javascript' src='/hr/dwr/interface/Deletejvsetup.js'></script>
<script type='text/javascript' src='/hr/dwr/engine.js'></script>
<script src="../JS/jquery-2.1.3.min.js" type="text/javascript"></script>
<script language='javascript'>setLang('<%=screen.getUProfile().get("lang")%>');</script>
<script language="javascript">getTitleName();</script>
<script language="javascript">
function goHelp(helpName,inputName){
var helpReturn;
if(inputName=="__fix_acctcode" ) {
helpReturn="__fix_acctcode:acctcode";
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__fix_acctname" ) {
helpReturn="__fix_acctname:acctname";
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__fix_mcostcode" ) {
helpReturn="__fix_mcostcode:maincostcentercode,__mmaincostcenter_edesc:edesc";
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__fix_costcode" ) {
helpReturn="__fix_costcode:costcenterid,__mcostcenter0_edesc:edesc";
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__fix_analcode" ) {
helpReturn="__fix_analcode:analcode";
linkHelp_Return(helpName,helpReturn);
} else if (inputName=="__fix_jvid" ) {
helpReturn="__fix_jvid:jvid";
linkHelp_Return(helpName,helpReturn);
}
}
function linkHelp_Return(help,input, fixCon){
with(document.cscform){
var filter = fixCon || __fixCon.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 searchdata(){
with(document.cscform){
__cmd.value = "searchdata";
setFilter();
setOrderBy();
submit();
}
}
function setFilter(){
with(document.cscform){
var filter = "";
if(__fix_jvid.value !== "") filter = chkLength(filter) + "jvid='"+__fix_jvid.value+"'";
if(__fix_acctcode.value !== "") filter = chkLength(filter) + "upper(acctcode) like upper('%"+__fix_acctcode.value+"%')";
if(__fix_acctname.value !== "") filter = chkLength(filter) + "upper(acctname) like upper('%"+__fix_acctname.value+"%')";
if(__fix_mcostcode.value !== "") filter = chkLength(filter) + "mcostcode='"+__fix_mcostcode.value+"'";
if(__fix_costcode.value !== "") filter = chkLength(filter) + "costcode='"+__fix_costcode.value+"'";
if(__fix_analcode.value !== "")
filter = chkLength(filter) + "( upper(anal_t0) like upper('%"+__fix_analcode.value+"%') or upper(anal_t1) like upper('%"+__fix_analcode.value+"%') or upper(anal_t2) like upper('%"+__fix_analcode.value+"%') or upper(anal_t3) like upper('%"+__fix_analcode.value+"%') or upper(anal_t4) like upper('%"+__fix_analcode.value+"%') or upper(anal_t5) like upper('%"+__fix_analcode.value+"%') or upper(anal_t6) like upper('%"+__fix_analcode.value+"%') or upper(anal_t7) like upper('%"+__fix_analcode.value+"%') or upper(anal_t8) like upper('%"+__fix_analcode.value+"%') or upper(anal_t9) like upper('%"+__fix_analcode.value+"%') )";
__datafilter.value = filter;
}
}
function setOrderBy(){
with(document.cscform){
var order = __fix_orderby.value;
if(order !== ""){
__dataorder.value = " "+order+" ASC";
}
}
}
function chkLength(str){
if(str !== ""){
str += " AND ";
}
return str;
}
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 deleteMulti(){
with(document.cscform){
bCon=confirm(MyCode[4]);
if (bCon===true){
var value = getCheckBox();
Deletejvsetup.multiKeyDelete("MJVDATA", "JVID,SQNUMBER", value, function(data){
alert("Delete Complete.");
searchdata();
});
}
}
}
function getCheckBox(){
var value = "";
$(".del_list").each(function(){
if($(this).prop("checked")){
value = chkText(value);
value += $(this).val();
}
});
return value;
}
function chkText(str){
if(str.length > 0){
str += ":";
}
return str;
}
</script>
</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="">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<script language="javascript">getInputFormatDate();</script>
<input type="hidden" name="__cmd" value=""/>
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>"/>
<input type="hidden" name="__screen" value="PRU171"/>
<input type="hidden" name="__childMulti" value="PRU171_DETAIL"/>
<input type="hidden" name="__childKey" value="__sqnumber"/>
<input type="hidden" name="__helpReturn" value=""/>
<input type="hidden" name="__help" value=""/>
<input type="hidden" name="__helpName" value=""/>
<input type="hidden" name="__pageCall" value=""/>
<input type="hidden" name="__referPage" value=""/>
<input type="hidden" name="__goPage" value=""/>
<input type="hidden" name="__datafilter" value="<%=datafilter%>"/>
<input type="hidden" name="__dataorder" value="<%=dataorder%>"/>
<input type="hidden" name="__companyid" value="<%=screen.getUProfile().get("companyid")%>"/>
<input type="hidden" name="__fixCon" value=""/>
<input type="hidden" name="__referPage" value=""/>
<input type="hidden" name="__user" value="<%=screen.getUProfile().getUserId()%>"/>
<div align="center">
<br/>
<table cellpadding="0" cellspacing="0" style="width:900px">
<tr >
<td class="header" colspan="2">PRU171, <span swlang code="SW012728">Payroll Journal Voucher Data</span><!-- <script language='javascript'>swapLang('Payroll Journal Voucher Data');</script> --> </td>
</tr>
<tr>
<td class="blankspace" colspan="2"></td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("JVID")%> :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_jvid" value="<%=chk.chkNullString(request.getParameter("__fix_jvid"))%>">
<a onmouseover="MM_swapImage('__fix_jvid_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVDATASETUPHELP','__fix_jvid');"><img name="__fix_jvid_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("ACCTCODE")%> :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_acctcode" value="<%=chk.chkNullString(request.getParameter("__fix_acctcode"))%>">
<a onmouseover="MM_swapImage('__fix_acctcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVDATA_DISTINCTACCTCODE','__fix_acctcode');"><img name="__fix_acctcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("ACCTNAME")%> :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_acctname" value="<%=chk.chkNullString(request.getParameter("__fix_acctname"))%>">
<a onmouseover="MM_swapImage('__fix_acctname_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVDATA_DISTINCTACCTNAME','__fix_acctname');"><img name="__fix_acctname_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("MCOSTCODE")%> :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_mcostcode" value="<%=chk.chkNullString(request.getParameter("__fix_mcostcode"))%>">
<a onmouseover="MM_swapImage('__fix_mcostcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MMAINCOSTCENTERHELP','__fix_mcostcode');"><img name="__fix_mcostcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
<input name="__mmaincostcenter_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mmaincostcenter_edesc"))%>" size="40">
</td>
</tr>
<tr>
<td class="columnlabel"><%=screen.getLabel("COSTCODE")%> :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_costcode" value="<%=chk.chkNullString(request.getParameter("__fix_costcode"))%>">
<a onmouseover="MM_swapImage('__fix_costcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MCOSTCENTER0HELP','__fix_costcode');"><img name="__fix_costcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
<input name="__mcostcenter0_edesc" type="text" readonly="true" value="<%=chk.chkNullString(request.getParameter("__mcostcenter0_edesc"))%>" size="40">
</td>
</tr>
<tr>
<td class="columnlabel">Analysis Code :: </td>
<td class="columnobject1">
<input type="text" size="15" name="__fix_analcode" value="<%=chk.chkNullString(request.getParameter("__fix_analcode"))%>">
<a onmouseover="MM_swapImage('__fix_analcode_image','','../IMAGES/BUTTON/SWAP/SEARCH_SWAP20.gif',1)" onmouseout="MM_swapImgRestore()" href="javascript:goHelp('MJVDATA_DISTINCTANALCODE','__fix_analcode');"><img name="__fix_analcode_image" width="20" height="20" align="absmiddle" alt="SEARCH" src="../IMAGES/BUTTON/MAIN/SEARCH20.gif" border="0"></a>
</td>
</tr>
<tr>
<td class="columnlabel"><span swlang code="SW000004">Order By</span> :: </td>
<td class="columnobject1">
<%
ListBox listboxOrderBy = new ListBox();
listboxOrderBy.setUProfile(screen.getUProfile());
listboxOrderBy.setName("fix_orderby"); //ชื่อ ListBox
listboxOrderBy.setValidCode("JVDATA_ORDERBY"); //tag Systemcode ที่เรียกใช้
listboxOrderBy.setBlank(true);
listboxOrderBy.setDisable("false");
listboxOrderBy.setChecked(chk.chkNullString(request.getParameter("__fix_orderby")));
out.println(listboxOrderBy.process());
%>
</td>
</tr>
<tr>
<td class="buttonline" colspan="7"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW013168" onClick="searchdata();">SEARCH</button>
</div>
</td>
</tr>
<tr>
<td class="blankspace" colspan="2"></td>
</tr>
<% if (!cmd.equalsIgnoreCase("") || !numpage.equalsIgnoreCase("1")){ %>
<tr>
<td><div> <script language="javascript">swapLang("Found Data");</script> :: <%=screen.getRecCount()%></div></td>
<td><div align="right"><span swlang code="SW001120">Page</span> :: <%=screen.getPageTag()%> </div></td>
</tr>
<tr>
<td colspan="2" align="center">
<div align="center">
<table cellpadding="0" cellspacing="0" style="width:900px">
<tr align="center" bgcolor="#CCCCCC">
<td class="row3"> <script language='javascript'>swapLang('Del');</script> </td>
<td class="row3"> <span swlang code="SW001393">No.</span><!-- <script language='javascript'>swapLang('No.');</script> --> </td>
<td class="row3"> <%=screen.getLabel("JVID")%> </td>
<td class="row3"> <%=screen.getLabel("ACCTCODE")%> </td>
<td class="row3"> <%=screen.getLabel("ACCTNAME")%> </td>
<td class="row3"> <script language='javascript'>swapLang('Code');</script> </td>
<td class="row3"> <script language='javascript'>swapLang('Analysis Code');</script> </td>
<td class="row3"> <script language='javascript'>swapLang('DR-Amount');</script> </td>
<td class="row3"> <script language='javascript'>swapLang('CR-Amount');</script> </td>
</tr>
<%
numpage = numpage.replace("+","");
numpage = numpage.replace("-","");
int i = (maxLine * Integer.parseInt(numpage)) - (maxLine - 1);
while (screen.nextRec()) {
if(screen.checkLinePage()){
%>
<tr>
<td align="center" class="forborder"><input type="checkbox" class="del_list" value="<%=screen.getDataLabel("JVID")%>,<%=screen.getDataLabel("SQNUMBER")%>"></td>
<td align="center" class="forborder"> <%=i%> </td>
<td align="left" class="forborder"> <%=screen.getDataLabel("JVID")%> </td>
<td align="left" class="forborder"> <%=screen.getDataLabel("ACCTCODE")%> </td>
<td align="left" class="forborder"> <%=screen.getDataLabel("ACCTNAME")%> </td>
<%
String maincode = screen.getDataLabel("MCOSTCODE");
String costcode = screen.getDataLabel("COSTCODE");
String code = "";
if(!costcode.equalsIgnoreCase("")){
DbInquiry inqcost = new InitialInquiry(screen.getUProfile()).getDbInquiry("MCOSTCENTER0");
inqcost.setColumn("MAINCOSTCENTERCODE");
inqcost.setFilter("COMPANYID = '"+screen.getUProfile().get("companyid")+"' AND COSTCENTERID ='"+costcode+"'");
inqcost.refresh();
inqcost.next();
code = inqcost.getString("MAINCOSTCENTERCODE") + "/" + costcode;
} else if(!maincode.equalsIgnoreCase("")){
code = maincode;
}
%>
<td align="center" class="forborder"> <%=code%> </td>
<%
String analtype = screen.getDataLabel("ANALTYPE");
String analcode = "";
String analysiscode = "";
for(int icode=0; icode <= 9; icode++){
String str = "anal_t" + String.valueOf(icode);
String analysis = screen.getDataLabel(str);
if(!analysis.equalsIgnoreCase("")){
if(!analcode.equalsIgnoreCase("")){
analcode += ",";
}
analcode += analysis;
}
}
if(!analtype.equalsIgnoreCase("NONE")){
analysiscode = analtype + "/" + analcode;
}
%>
<td align="left" class="forborder"> <%=analysiscode%> </td>
<td align="right" class="forborder"> <%if(screen.getDataLabel("ACCTTYPE").equals("0")){ out.println(screen.getDataLabel("AMOUNT")); }%> </td>
<td align="right" class="forborder"> <%if(screen.getDataLabel("ACCTTYPE").equals("1")){ out.println(screen.getDataLabel("AMOUNT")); }%> </td>
</tr>
<%
}
if(screen.outLinePage()){ break; }
i++;
}
%>
<tr>
<td class="buttonline" colspan="9"><div align="center">
<button type="button" class="btn btn-primary width100" swlang code="SW002185" onClick="checkAll();">SELECT ALL</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013164" onClick="decheckAll();">DESELECT ALL</button>
<button type="button" class="btn btn-primary width100" swlang code="SW013166" onClick="deleteMulti();">DELETE</button>
</div>
</td>
</tr>
<tr>
<td class="blankspace" colspan="9"></td>
</tr>
</table>
</div>
</td>
</tr>
<% } %>
<tr>
<td class="bottom" colspan="2"></td>
</tr>
</table>
</div>
<!----------BEGIN CSC ENDING ZONE ------------------------>
<!----------END CSC ENDING ZONE -------------------------->
</form>
</body>
</html>