当前位置：首页 > news >正文

更新积木报表2.0.0注意事项

news 2025/6/9 8:57:25

一、导出接口变更

导出接口由原来的/jmreport/exportPdfStream更新为/jmreport/exportReport。具体见官方文档；

1、旧接口springboot实现报表生成并存储pdf文件

public String exportPdf(@RequestParam(name = "id", required = true) String id, @RequestParam(name = "excelConfigId", required = true)String excelConfigId, @RequestParam(name = "rootPath", required = true)String rootPath,@RequestParam(name = "url") String url) {// 1、创建url路径 RestUtil.getBaseUrl()：你的地址String url = RestUtil.getBaseUrl() + "/jmreport/exportPdfStream";Map<String, Object> map = new HashMap<>();JSONObject object = new JSONObject();// 2、此处为示例，需要传递api和sql的正确参数值object.put("id", id); //积木报表中sql的传参map.put("excelConfigId", excelConfigId); //积木报表idmap.put("queryParam", object);HTTPHeaders headers = new HttpHeaders);headers.add("Content-Type", "application/JSON;charset=UTF-8");HttpEntity<Map<String, Object>> httpEntity = new HttpEntity<>(map, headers);String filePath = "";try {// 3、调用积木报表接口Resource apiResult = restTemplateConfig.restTemplateHttps().postForObject(url, httpEntity, Resource.class);// 4、拿到流InputStream inputStream = apiResult.getInputStream();byte[] bytes = IOUtils.toByteArray(inputStream);String s = "data:application/pdf;base64," + Base64.getEncoder().encodeToString(bytes);ByteArrayInputStream stream = null;BASE64Decoder decoder = new BASE64Decoder();byte[] bt = decoder.decodeBuffer(s);stream = new ByteArrayInputStream(bt);// 5、存储到minio中filePath = MinioUtil.upload(stream,rootPath+"/"+id+".pdf");// 6、关闭流inputStream.close();} catch (RestClientException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();} catch (Exception e) {e.printStackTrace();}return filePath;

2、新接口实现

public String exportYbSbPdf(@RequestParam(name = "batchId", required = true) String batchId, @RequestParam(name = "communityId", required = true) String communityId, @RequestParam(name = "excelConfigId", required = true)String excelConfigId, @RequestParam(name = "rootPath", required = true)String rootPath,@RequestParam(name = "url", required = true)String url) {String filePath = "";try {// 查询参数JSONObject queryParam = new JSONObject();queryParam.put("batchId", batchId);queryParam.put("communityId", communityId);// 请求参数Map<String, Object> exportParams = new HashMap<>();exportParams.put("reportId", excelConfigId);exportParams.put("exportType", "pdf");exportParams.put("queryParam", queryParam);Map<String,Object> map = new HashMap<>();List<Map<String, Object>> list = new ArrayList<>();list.add(exportParams);map.put("exportParams", JSONObject.toJSONString(list));// 请求头HTTPHeaders headers = new HttpHeaders);headers.add("Content-Type", "application/JSON;charset=UTF-8");HttpEntity<Map<String, Object>> httpEntity = new HttpEntity<>(map, headers);url = "你的地址/jmreport/exportReport" + "?token="+((ServletRequestAttributes)RequestContextHolder.getRequestAttributes()).getRequest().getHeader("X-Access-Token")+"&exportParams=" + UriEncoder.encode(JSONObject.toJSONString(list));ResponseEntity<byte[]> responseEntity = restTemplateConfig.restTemplateHttps().getForEntity(url, byte[].class, httpEntity);if (responseEntity.getStatusCode().is2xxSuccessful()) {byte[] body = responseEntity.getBody();if (body == null || body.length == 0) {throw new RuntimeException("导出内容为空");}ByteArrayInputStream inputStream = new ByteArrayInputStream(body);byte[] bytes = IOUtils.toByteArray(inputStream);String s = "data:application/pdf;base64," + Base64.getEncoder().encodeToString(bytes);ByteArrayInputStream stream = null;BASE64Decoder decoder = new BASE64Decoder();byte[] bt = decoder.decodeBuffer(s);stream = new ByteArrayInputStream(bt);filePath = MinioUtil.upload(stream,rootPath+"/"+batchId+"_"+communityId+".pdf");inputStream.close();} else {throw new RuntimeException("导出失败，HTTP状态码：" + responseEntity.getStatusCode());}} catch (RestClientException | IOException e) {e.printStackTrace();throw new RuntimeException("调用报表导出接口失败：" + e.getMessage());} catch (Exception e) {throw new RuntimeException(e);}return filePath;}