<!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.session.*,com.csc.library.utilities.*,java.text.DecimalFormat,com.csc.library.database.*,com.csc.library.components.*"%>
<%@page import="java.util.*,java.io.*,java.math.BigDecimal"%>
<jsp:useBean id="PRRJVDATAEXCEL" class="com.csc.library.system.Task" scope="page" />
<%
response.setContentType("application/vnd.ms-excel; UTF-8");
response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");
PRRJVDATAEXCEL.setChannel(request, response);
HelpEntry screen = (HelpEntry) PRRJVDATAEXCEL.process("HelpEntry","MJVDATAHELP");
CheckNull chk = new CheckNull();
DecimalFormat df = new DecimalFormat("###,##0.00");
String cmd = chk.chkNullString(request.getParameter("__cmd"));
String jvid = chk.chkNullString(request.getParameter("__jvid"));
String groupby_code = chk.chkNullString(request.getParameter("__groupby_code"));
String filter = "";
String orderby = "CAST(SQNUMBER AS INTEGER) ASC";
if(groupby_code.equalsIgnoreCase("MCOSTCODE")){ filter = " AND MCOSTCODE != ''"; orderby = "MCOSTCODE ASC"; }
else if(groupby_code.equalsIgnoreCase("COSTCODE")){ filter = " AND COSTCODE != ''"; orderby = "COSTCODE ASC"; }
screen.getInquiry().setFilter("COMPANYID = '"+screen.getUProfile().get("companyid")+"' AND jvid ='"+jvid+"'"+filter);
screen.getInquiry().setOrderBy(orderby);
screen.getInquiry().refresh();
%>
<html ng-app="myHR">
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<script language="JavaScript" src="../JS/SCREEN.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" type="text/JavaScript">
function GoExport() {
with( document.cscform) {
__export.value = "1";
action = "PRRJVDATAEXCEL_EX.jsp";
submit();
}
}
function GoProcess(){
with(document.cscform){
__cmd.value = "search";
submit();
}
}
function goHelp(helpName,inputName){
with(document.cscform){
var helpReturn = "";
if (inputName==="__jvid") {
helpReturn="__jvid:jvid";
linkHelp_Return(helpName,helpReturn);
}
}
}
function linkHelp_Return(help,input){
with(document.cscform){
var param="PRU084.jsp?__helpName="+help+"&__helpReturn="+input+"&__pageCall="+__screen.value+"&__checkVerify=off";
window.open(param,"Help","left=150,top=150,width=1200,height=400,toolbar=no,status=yes,scrollbars=yes,resizable=yes");
}
}
</script>
<style>
.maintitle td { background-color: #a6a6a6; }
.subtitle td { background-color: #d9d9d9; }
.data td { color: black !important; padding: 0px 6px 0px 6px; }
.nopadding { padding: 0px !important; }
.boldtext { font-weight: bold; }
.tdhead td { font-weight: bold; text-align: center; }
.headsize { font-size: 150%; font-weight: bold; }
.blankspace {
height:10px;
border: none;
font-size: 1%;
}
</style>
</head>
<%
String helpReturn="";
if(request.getParameter("__helpReturn")!=null){
helpReturn=request.getParameter("__helpReturn");
}
String fieldSearch="";
if(request.getParameter("__fieldSearch")!=null){
fieldSearch=request.getParameter("__fieldSearch");
}
%>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" action="PRRJVDATAEXCEL.jsp">
<!----------BEGIN CSC INITIAL ZONE ------------------------>
<%=screen.InitialVariable()%>
<!----------END CSC INITIAL ZONE -------------------------->
<input type="hidden" name="__cmd" value="">
<input type="hidden" name="__help" value="">
<input type="hidden" name="__goPage" value="">
<input type="hidden" name="__language" value="<%=screen.getUProfile().get("lang")%>">
<input type="hidden" name="__helpReturn" value="<%=helpReturn%>">
<input type="hidden" name="__fieldSearch" value="<%=fieldSearch%>">
<input type="hidden" name="__helpName" value="<%=request.getParameter("__helpName")%>">
<input type="hidden" name="__pageCall" value="<%=request.getParameter("__screen")%>">
<input type="hidden" name="__fixCon" value="<%=request.getParameter("__fixCon")%>">
<input type="hidden" name="__orderBy" value="<%=request.getParameter("__orderBy")%>">
<input type="hidden" name="__export" value="">
<input type="hidden" name="__screen" value="PRRJVDATAEXCEL">
<input type="hidden" name="__getformula">
<br>
<div align="center">
<table class="maxsize" cellpadding="0" cellspacing="0">
<tr>
<td align="center">
<%
DbInquiry jvdatasetup = new InitialInquiry(screen.getUProfile()).getDbInquiry("MJVDATASETUP");
jvdatasetup.setColumn("*");
jvdatasetup.setFilter("COMPANYID = '"+screen.getUProfile().get("companyid")+"' AND JVID ='"+jvid+"'");
jvdatasetup.setOrderBy("JVID ASC");
jvdatasetup.refresh();
jvdatasetup.next();
%>
<table border="0" cellpadding="0" cellspacing="0" class="data" style="width:800px">
<tr>
<td colspan="4" class="headsize" align="left"><%=screen.getUProfile().get("companyname")%></td>
<td colspan="3" class="headsize" align="center">Payroll Journal Voucher</td>
</tr>
<tr>
<td align="left" colspan="4"><%=jvdatasetup.getString("MJVDATASETUP","COMPANY_ADDRESS")%></td>
<td align="left">JV SQ. No. : </td>
<td align="left" colspan="2">
<%
if(jvdatasetup.getString("MJVDATASETUP","SQCODE").equalsIgnoreCase("")){
out.println("All");
} else {
out.println(jvdatasetup.getString("MJVDATASETUP","SQCODE"));
}
%>
</td>
</tr>
<tr>
<td align="left" colspan="4">Telephone : <%=jvdatasetup.getString("MJVDATASETUP","COMPANY_TEL")%> Fax : <%=jvdatasetup.getString("MJVDATASETUP","COMPANY_FAX")%></td>
<td align="left">Period : </td>
<td align="left" colspan="2"><%=jvdatasetup.getString("MJVDATASETUP","PERIODDATE")%></td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td align="left">Print : </td>
<td align="left" colspan="6"><%=new CscCalendar().getDDMMYYYY()%></td>
</tr>
<tr>
<td align="left">Print By : </td>
<td align="left" colspan="6"><%=screen.getUProfile().get("actor") + " - " + screen.getUProfile().get("fullname")%></td>
</tr>
<tr>
<td class="blankspace"></td>
</tr>
<tr class="tdhead maintitle">
<td align="center" width="100">No.</td>
<td align="center" width="150">Acct Code</td>
<td align="center" width="350">Acct Name</td>
<td align="center" width="180">Code</td>
<td align="center" width="180">Analysis Code</td>
<td align="center" width="130">DR-Amount</td>
<td align="center" width="130">CR-Amount</td>
</tr>
<%
int subrec = 0;
int mainrec = 0;
Double subdramount = 0.00;
Double subcramount = 0.00;
Double maindramount = 0.00;
Double maincramount = 0.00;
String comegroup = "START";
String thisgroup = "";
int footercheck = 0;
while(screen.nextRec()){
if (!comegroup.equalsIgnoreCase("START")){
comegroup = screen.getString(groupby_code);
if(!groupby_code.equalsIgnoreCase("") && !comegroup.equalsIgnoreCase(thisgroup)){
%>
<tr>
<td colspan="7">Record(s) : <%=subrec%></td>
</tr>
<tr class="subtitle">
<td colspan="5" align="center" class="boldtext">Total</td>
<td align="right"><%=df.format(new BigDecimal(subdramount))%></td>
<td align="right"><%=df.format(new BigDecimal(subcramount))%></td>
</tr>
<%
thisgroup = comegroup;
footercheck = 0;
}
} else if (comegroup.equalsIgnoreCase("START")){
comegroup = "";
}
if(!groupby_code.equalsIgnoreCase("") && footercheck == 0){
String stringName = "";
String stringTable = "";
subrec = 0;
subdramount = 0.00;
subcramount = 0.00;
footercheck = 1;
if(groupby_code.equalsIgnoreCase("MCOSTCODE")){ stringName = "Main Cost Center"; stringTable = "MMAINCOSTCENTER"; }
else if(groupby_code.equalsIgnoreCase("COSTCODE")){ stringName = "Cost Center"; stringTable = "MCOSTCENTER0"; }
%>
<tr>
<td align="left" colspan="7"><%=stringName + " : " + screen.getString(groupby_code) + " - " + screen.getString(stringTable,"TDESC")%></td>
</tr>
<%
}
subrec++;
mainrec++;
Double amount = Double.valueOf(screen.getString("AMOUNT").replace(",",""));
if(screen.getString("ACCTTYPE").equalsIgnoreCase("0")){
subdramount += amount;
maindramount += amount;
} else {
subcramount += amount;
maincramount += amount;
}
%>
<tr>
<td align="center"><%=subrec%></td>
<td align="left"><%=screen.getString("ACCTCODE")%></td>
<td align="left"><%=screen.getString("ACCTNAME")%></td>
<%
String code = "";
if(!screen.getString("MCOSTCODE").equalsIgnoreCase("")){
code = screen.getString("MMAINCOSTCENTER","MAINCOSTCENTERCODE");
} else if(!screen.getString("COSTCODE").equalsIgnoreCase("")){
code = screen.getString("MCOSTCENTER0","MAINCOSTCENTERCODE") + " / " + screen.getString("MCOSTCENTER0","COSTCENTERID");
}
%>
<td align="center"><%=code%></td>
<%
String analcode = "";
if(!screen.getString("ANALTYPE").equalsIgnoreCase("NONE")){
analcode = screen.getString("ANALTYPE") + " / " + screen.getString("ANALYSIS_CODE");
}
%>
<td align="center"><%=analcode%></td>
<td align="right"><%=screen.getString("DR_AMOUNT")%></td>
<td align="right"><%=screen.getString("CR_AMOUNT")%></td>
</tr>
<%
}
if(!groupby_code.equalsIgnoreCase("")){
%>
<tr>
<td align="left" colspan="7">Record(s) : <%=subrec%></td>
</tr>
<tr class="subtitle">
<td colspan="5" align="center" class="boldtext">Total</td>
<td align="right"><%=df.format(new BigDecimal(subdramount))%></td>
<td align="right"><%=df.format(new BigDecimal(subcramount))%></td>
</tr>
<%
thisgroup = comegroup;
footercheck = 0;
}
%>
<tr>
<td class="blankspace"></td>
</tr>
<tr>
<td align="left" colspan="7">Record(s) : <%=mainrec%></td>
</tr>
<tr class="maintitle">
<td colspan="5" align="center" class="boldtext">Grand Total</td>
<td align="right"><%=df.format(new BigDecimal(maindramount))%></td>
<td align="right"><%=df.format(new BigDecimal(maincramount))%></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>