<!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="PRRJVDATAEXCELSAP" class="com.csc.library.system.Task" scope="page" />
<%
response.setContentType("application/vnd.ms-excel; UTF-8");
response.setHeader("Content-Disposition", "inline; filename=" + "export.xls");
PRRJVDATAEXCELSAP.setChannel(request, response);
HelpEntry screen = (HelpEntry) PRRJVDATAEXCELSAP.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 filter = "";
String orderby = "CAST(SQNUMBER AS INTEGER) 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 type="text/javascript" src="../JS/jquery-2.1.3.min.js"></script>
<script type='text/javascript' src="../JS/bootstrap.js"></script>
<script language="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 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 = "PRRJVDATAEXCELSAP_EX.jsp";
submit();
}
}
function GoProcess(){
with(document.cscform){
__cmd.value = "search";
action = "PRRJVDATAEXCELSAP.jsp";
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; }
.mainsubtitle td { background-color: #cccccc; }
.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: left; }
.headsize { font-size: 150%; font-weight: bold; }
.blankspace {
height:10px;
border: none;
font-size: 1%;
}
</style>
</head>
<body leftmargin="0" topmargin="0">
<form name="cscform" method="post" action="PRRJVDATAEXCELSAP.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="__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="PRRJVDATAEXCELSAP"/>
<input type="hidden" name="__getformula"/>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" class="data" style="width:1400px">
<tr class="tdhead maintitle">
<td width="130">ParentKey</td>
<td width="130">LineNum</td>
<td width="130">Line_ID</td>
<td width="180">AccountCode</td>
<td width="130">Debit</td>
<td width="130">Credit</td>
<td width="230">LineMemo</td>
<td width="130">ProjectCode</td>
<td width="130">CostingCode</td>
<td width="130">CostingCode2</td>
<td width="130">CostingCode3</td>
<td width="130">CostingCode4</td>
</tr>
<tr class="tdhead mainsubtitle">
<td>JdtNum</td>
<td>LineNum</td>
<td>Line_ID</td>
<td>Account</td>
<td>Debit</td>
<td>Credit</td>
<td>LineMemo</td>
<td>Project</td>
<td>ProfitCode</td>
<td>OcrCode2</td>
<td>OcrCode3</td>
<td>OcrCode4</td>
</tr>
<%
while(screen.nextRec()){
String LineID = "";
String code = "";
String analcode = "";
Double amount = Double.valueOf(screen.getString("AMOUNT").replace(",",""));
if(screen.getString("ACCTTYPE").equalsIgnoreCase("0")){
LineID = "0";
} else {
LineID = "1";
}
%>
<tr>
<td align="right"></td>
<td align="right"></td>
<td align="right"><%=getLimitString(LineID, 11)%></td>
<td align="right"><%=getLimitString(screen.getString("ACCTCODE"), 15)%></td>
<td align="right"><%=screen.getString("ACCTTYPE").equalsIgnoreCase("0")?getLimitString(screen.getString("DR_AMOUNT"), 15):""%></td>
<td align="right"><%=screen.getString("ACCTTYPE").equalsIgnoreCase("1")?getLimitString(screen.getString("CR_AMOUNT"), 15):""%></td>
<td align="left"><%=getLimitString(screen.getString("ACCTNAME"), 50)%></td>
<td align="right"></td>
<td align="right"></td>
<td align="right"></td>
<td align="right"></td>
<td align="right"></td>
</tr>
<%
}
%>
</table>
</form>
</body>
</html>
<%!
private String getLimitString(String str, int limit) {
if(str.length() > limit) {
str = str.substring(0,limit);
}
return str;
}
%>