手动生成报表

zhaixin · 发表于 2013-3-22 15:45:21

目的：平台中的报表是每次显示的时候生成的，如果希望生成报表和显示报表分开，可以这样实现：生成报表时，一次性将报表对应的html、doc、xls、pdf等4个文件生成并保存到服务器的某个目录中；显示报表、导出报表时直接下载这4个文件的其中一个到本地即可。平台使用了生成一个临时文件，并下载到本地的做法，我们可以效仿这个做法。

平台报表组件在显示报表、打印报表、导出报表时使用了下面两个java文件
/UI/system/service/report/dsrc/ReportBrowse.java
/UI/system/service/report/dsrc/PrintGetFile.java
主要修改ReportBrowse.java 文件的doPost方法

zhaixin · 发表于 2013-3-22 15:47:10

生成4个报表对应的文件，代码如下

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
……
createReportFile(reportJSONHelper, "xhtml", fileDir + "/" + reportName + ".xhtml");
createReportFile(reportJSONHelper, "doc", fileDir + "/" + reportName + ".doc");
createReportFile(reportJSONHelper, "xls", fileDir + "/" + reportName + ".xls");
createReportFile(reportJSONHelper, "pdf", fileDir + "/" + reportName + ".pdf");
……
}
private void createReportFile(ReportJSONHelper reportJSONHelper, String outputType, String fullfilename) throws ServletException, IOException {
try {
String url = createReportURL(REPORT_SERVER, businessCookie);
Element requestE = reportJSONHelper.execute(outputType);
//请求报表服务器，生成报表
byte[] cacheByte = call(url, requestE.asXML());
//存为文件
File reportFile = new File(fullfilename);
FileOutputStream fileOutputStream = new FileOutputStream(reportFile, false);
if ("xhtml".equals(outputType)) {
cacheByte = new String(cacheByte).replace("xhtml:", "").getBytes();
}
ByteArrayInputStream in = new ByteArrayInputStream(cacheByte);
byte[] bs = new byte[1024];
int i = -1;
while ((i = in.read(bs)) != -1) {
fileOutputStream.write(bs, 0, i);
}
fileOutputStream.flush();
fileOutputStream.close();
} catch (Exception e) {
throw new ServletException("报表服务请求失败", e);
}
}

复制代码

这里有个中文文件名的问题，如果使用中文文件名，需要进行一次utf-8编码

filenameEncode = java.net.URLEncoder.encode(reportName, "utf-8") + "." + outputType;

复制代码

zhaixin · 发表于 2013-3-22 15:48:55

下载报表文件，其中打印报表是比较特殊的

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
……
String uiServerURL = tempUrl.substring(0, tempUrl.indexOf("/UI/"));
ReportJSONHelper reportJSONHelper = new ReportJSONHelper(jsonString, (String) businessCookie, uiServerURL, REPORT_SERVER);
String outputType = reportJSONHelper.getOutputType(); ……
//将报表文件传回界面
if ("print".equals(outputType)) {
PrintWriter pw = response.getWriter();
pw.print("<object id='pdf' type='application/pdf' width='100' height='100'>" +
"<param name='src' fmt:url-type='action' value='"+uiServerURL+"/UI/system/service/report/printGetFile.j?filename="
+ fileDir + "/" + filenameEncode+"' />" +
"</object>" +
"<script type='text/javascript'>" +
"document.pdf.printWithDialog();" +
"document.pdf.focus();" +
"</script>" +
"");
pw.flush();
pw.close();
} else {
FileInputStream inputStream = new FileInputStream(reportFile);
response.setCharacterEncoding("UTF-8");
if ("xhtml".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "text/html");
} else if ("doc".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/ms-word");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
} else if ("xls".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/ms-excel");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
} else if ("preview".equals(outputType)) {
response.setHeader("Content-Type", "application/pdf");
response.addHeader("Content-disposition", "inline;filename="" + filenamedownload + """);
} else {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/pdf");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
}
OutputStream out = response.getOutputStream();
byte[] bt = new byte[1024];
int i = -1;
while ((i = inputStream.read(bt)) != -1) {
out.write(bt, 0, i);
}
out.flush();
out.close();
}
……
}

复制代码

zhaixin · 发表于 2013-3-22 15:51:08

说明：

1、案例实现了一种简单的方式，即当没有生成过报表时，则生成报表，否则显示报表。这样的改动最小。

2、如果希望生成报表和显示报表完全分开，需要给report组件增加一个方法，可以仿照refresh方法写，再仿照ReportBrowse.j写一个.j文件来实现，

3、案例中对report组件id等于grid的报表进行了单独处理，会将报表相关的4个文件一次生成，以后则会直接显示。关于生成的这4个文件的文件名取自报表组件中的reportName属性，这4个文件存放的目录暂时是tomcat的temp目录，这个目录应该修改为一个合适的目录。

ReportBrowse.java代码如下

public class ReportBrowse extends JProcessorImpl {
……
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
try {
//初始化报表服务器地址(UIServer/justep.xml)
init(request);
businessCookie = getBusinessSessionID(request).toString();
String tempUrl = request.getRequestURL().toString();
String uiServerURL = tempUrl.substring(0, tempUrl.indexOf("/UI/"));
String jsonString = getRequestJSONString(request);
// rdl和json的数据整合,(sql与页面设置)
ReportJSONHelper reportJSONHelper = new ReportJSONHelper(jsonString, (String) businessCookie, uiServerURL, REPORT_SERVER);
Element requestE = reportJSONHelper.execute(null);
String outputType = reportJSONHelper.getOutputType();
String reportName = reportJSONHelper.getReportName();
String reportID = reportJSONHelper.getReportID();
String fileDir;
String filename;
String filenameEncode;
String filenamedownload;
if ("grid".equals(reportID)) {//只有报表组件的ID是grid的报表生成指定名称的报表文件
fileDir = System.getProperty("java.io.tmpdir");//需要保存的报表文件，应该放到其它目录中
//用reportName生成文件名
filename = reportName + "." + outputType;
filenameEncode = java.net.URLEncoder.encode(reportName, "utf-8") + "." + outputType;
if ("preview".equals(outputType) || "print".equals(outputType)) {
filename = reportName + ".pdf";
filenameEncode = java.net.URLEncoder.encode(reportName, "utf-8") + ".pdf";
}
filenamedownload = filename;
}
else{//其它报表用GUID作为文件名
fileDir = System.getProperty("java.io.tmpdir");
filename = java.util.UUID.randomUUID().toString();
if ("preview".equals(outputType) || "print".equals(outputType)) {
filename = filename + ".pdf";
filenamedownload = reportName + ".pdf";
}else{
filename = filename + "." + outputType;
filenamedownload = reportName + "." + outputType;;
}
filenameEncode = filename;
}
String fullFileName = fileDir + "/" + filename;
File reportFile = new File(fullFileName);
if ("grid".equals(reportID)) {//只有报表组件的ID是grid的报表才一次生成4个文件
if (!reportFile.exists()) {//如果文件不存在则生成4个报表文件
createReportFile(reportJSONHelper, "xhtml", fileDir + "/" + reportName + ".xhtml");
createReportFile(reportJSONHelper, "doc", fileDir + "/" + reportName + ".doc");
createReportFile(reportJSONHelper, "xls", fileDir + "/" + reportName + ".xls");
createReportFile(reportJSONHelper, "pdf", fileDir + "/" + reportName + ".pdf");
}
}else{
if ("preview".equals(outputType) || "print".equals(outputType)) {
createReportFile(reportJSONHelper, "pdf", fullFileName);
}else{
createReportFile(reportJSONHelper, outputType, fullFileName);
}
}
//将报表文件传回界面
if ("print".equals(outputType)) {
PrintWriter pw = response.getWriter();
pw.print("<object id='pdf' type='application/pdf' width='100' height='100'>" +
"<param name='src' fmt:url-type='action' value='"+uiServerURL+"/UI/system/service/report/printGetFile.j?filename="
+ fileDir + "/" + filenameEncode+"' />" +
"</object>" +
"<script type='text/javascript'>" +
"document.pdf.printWithDialog();" +
"document.pdf.focus();" +
"</script>" +
"");
pw.flush();
pw.close();
} else {
FileInputStream inputStream = new FileInputStream(reportFile);
response.setCharacterEncoding("UTF-8");
if ("xhtml".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "text/html");
} else if ("doc".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/ms-word");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
} else if ("xls".equals(outputType)) {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/ms-excel");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
} else if ("preview".equals(outputType)) {
response.setHeader("Content-Type", "application/pdf");
response.addHeader("Content-disposition", "inline;filename="" + filenamedownload + """);
} else {
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Content-Type", "application/pdf");
response.addHeader("Content-disposition", "attachment;filename="" + filenamedownload + """);
}
OutputStream out = response.getOutputStream();
byte[] bt = new byte[1024];
int i = -1;
while ((i = inputStream.read(bt)) != -1) {
out.write(bt, 0, i);
}
out.flush();
out.close();
}
} catch (Exception e) {
throw new ServletException("报表服务请求失败", e);
}
}
……
}

复制代码

PrintGetFile.java代码如下

public class PrintGetFile extends JProcessor {
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String filename = request.getParameter("filename");
if(filename.indexOf("/") == -1)
filename = System.getProperty("java.io.tmpdir") + "/" + filename;
OutputStream out = null;
try{
File reportFile = new File(filename);
FileInputStream inputStream = new FileInputStream(reportFile);
out = response.getOutputStream();
byte[] bt = new byte[1024];
int i = -1;
while((i = inputStream.read(bt)) != -1){
out.write(bt, 0, i);
}
out.flush();
}finally{
out.close();
}
}
}

复制代码

relinson · 发表于 2013-3-24 14:47:29

谢谢管理员

relinson · 发表于 2013-3-25 10:23:25

这种方式是以报表名称为标识,如果多个用户请求相同报表,是否会后请求的会覆盖先请求的报表

腹部流出的肉 · 发表于 2015-10-23 16:30:25

本帖最后由腹部流出的肉于 2015-10-23 16:32 编辑

zhaixin 发表于 2013-3-22 15:47
生成4个报表对应的文件，代码如下

这里有个中文文件名的问题，如果使用中文文件名，需要进行一次utf-8编码 ...

BeX5.3.1中创建文件也是这样的吗我试了好多次都不行

在线等
在线等
在线等

allpower · 发表于 2020-2-26 14:16:35

好牛的帖子！

		自动登录	找回密码
密码			注册

手动生成报表

一个简单的案例