PrintController.java 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148
  1. package com.uas.report.controller;
  2. import java.io.IOException;
  3. import java.io.OutputStream;
  4. import java.util.Map;
  5. import javax.servlet.http.HttpServletResponse;
  6. import org.apache.commons.lang.ArrayUtils;
  7. import org.apache.log4j.Logger;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.stereotype.Controller;
  10. import org.springframework.util.StringUtils;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.ResponseBody;
  13. import com.uas.report.core.exception.SystemError;
  14. import com.uas.report.service.PrintService;
  15. /**
  16. * 报表打印
  17. *
  18. * @author sunyj
  19. * @since 2016年8月16日 下午3:49:02
  20. */
  21. @Controller
  22. @RequestMapping("/print")
  23. public class PrintController {
  24. private static Logger logger = Logger.getLogger(PrintController.class);
  25. @Autowired
  26. private PrintService printService;
  27. /**
  28. * 导出报表
  29. *
  30. * @param userName
  31. * 不为null;当前账套用户名
  32. * @param reportName
  33. * 不为null;需要导出的报表的名称,不带任何后缀(如导出采购单,即为"Purchase")
  34. * @param whereCondition
  35. * 可为null;where之后的条件(包括where)
  36. * @param otherParameters
  37. * 若模板已指定需要的参数,则不可为null;其他参数,区别于whereCondition,报表某些字段的值取决于这些参数;
  38. * JSON格式,数据为键值对
  39. * @param exportFileType
  40. * 报表导出的格式,默认为pdf
  41. * @param response
  42. * @return
  43. */
  44. @RequestMapping("/export")
  45. @ResponseBody
  46. public void export(String userName, String reportName, String whereCondition, String otherParameters,
  47. String exportFileType, HttpServletResponse response) {
  48. String message = "";
  49. if (StringUtils.isEmpty(userName)) {
  50. message = "未传入当前账套用户名!";
  51. logger.error(message);
  52. throw new SystemError(message);
  53. }
  54. if (StringUtils.isEmpty(reportName)) {
  55. message = "报表名称无效!";
  56. logger.error(message);
  57. throw new SystemError(message);
  58. }
  59. logger.info("开始导出报表:" + reportName);
  60. if (StringUtils.isEmpty(exportFileType)) {
  61. exportFileType = "pdf";
  62. }
  63. byte[] data = printService.export(userName, reportName, whereCondition, otherParameters, exportFileType);
  64. if (ArrayUtils.isEmpty(data)) {
  65. message = "报表导出失败:" + reportName;
  66. logger.error(message);
  67. throw new SystemError(message);
  68. }
  69. try {
  70. String exportFileName = reportName;
  71. if (exportFileType.equals("xls_with_only_data")) {
  72. exportFileName += ".xls";
  73. } else {
  74. exportFileName += "." + exportFileType;
  75. }
  76. response.setHeader("Content-Disposition", "attachment;filename=" + exportFileName);
  77. OutputStream outputStream = response.getOutputStream();
  78. outputStream.write(data);
  79. outputStream.flush();
  80. outputStream.close();
  81. } catch (IOException e) {
  82. logger.error("浏览器重复请求!");
  83. }
  84. logger.info("报表导出完成:" + reportName);
  85. }
  86. /**
  87. * 报表预览时获取pdf流
  88. *
  89. * @param userName
  90. * 不为null;当前账套用户名
  91. * @param reportName
  92. * 不为null;需要预览的报表的名称,不带任何后缀(如预览采购单,即为"Purchase")
  93. * @param whereCondition
  94. * 可为null;where之后的条件(包括where)
  95. * @param otherParameters
  96. * 若模板已指定需要的参数,则不可为null;其他参数,区别于whereCondition,报表某些字段的值取决于这些参数;
  97. * JSON格式,数据为键值对
  98. * @param pageIndex
  99. * 分页展示,当前页码,从0开始
  100. * @return
  101. */
  102. @RequestMapping(value = "/loadPdfData")
  103. @ResponseBody
  104. public Map<String, Object> loadPdfData(String userName, String reportName, String whereCondition,
  105. String otherParameters, Integer pageIndex, HttpServletResponse response) {
  106. String message = "";
  107. if (StringUtils.isEmpty(userName)) {
  108. message = "未传入当前账套用户名!";
  109. logger.error(message);
  110. throw new SystemError(message);
  111. }
  112. if (StringUtils.isEmpty(reportName)) {
  113. message = "报表名称无效!";
  114. logger.error(message);
  115. throw new SystemError(message);
  116. }
  117. logger.info("开始预览报表:" + reportName);
  118. Map<String, Object> result = printService.preview(userName, reportName, whereCondition, otherParameters,
  119. pageIndex);
  120. byte[] data = null;
  121. if (result != null && result.get("data") != null) {
  122. data = (byte[]) result.get("data");
  123. }
  124. if (data == null) {
  125. message = "获取预览数据失败";
  126. logger.error(message);
  127. throw new SystemError(message);
  128. }
  129. String pdfPath = printService.writePdfFile(reportName, data);
  130. result.put("pdfPath", pdfPath);
  131. logger.info("预览报表成功:" + reportName);
  132. return result;
  133. }
  134. }