HgxfxSchedule.java 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492
  1. package com.onemap.analyse.task;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.onemap.analyse.domain.*;
  4. import com.onemap.analyse.mapper.*;
  5. import com.onemap.analyse.utils.NpoiHelper;
  6. import com.onemap.common.core.utils.StringUtils;
  7. import org.apache.commons.io.FileUtils;
  8. import org.apache.poi.xwpf.usermodel.*;
  9. import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTTblWidth;
  10. import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTTcPr;
  11. import org.openxmlformats.schemas.wordprocessingml.x2006.main.STTblWidth;
  12. import org.slf4j.Logger;
  13. import org.slf4j.LoggerFactory;
  14. import org.springframework.beans.factory.annotation.Value;
  15. import org.springframework.scheduling.annotation.Async;
  16. import org.springframework.scheduling.annotation.Scheduled;
  17. import org.springframework.stereotype.Component;
  18. import javax.annotation.Resource;
  19. import java.io.File;
  20. import java.io.FileOutputStream;
  21. import java.io.OutputStream;
  22. import java.math.BigInteger;
  23. import java.text.SimpleDateFormat;
  24. import java.util.*;
  25. /**
  26. * 合规性分析模块定时刷新任务
  27. */
  28. @Component
  29. public class HgxfxSchedule {
  30. //间隔时间 单位ms
  31. public static final long TIME_INTERVAL = 1 * 15000;
  32. //任务状态标识码
  33. private RwztDTO Rwzt = new RwztDTO();
  34. @Resource
  35. private HgxfxMapper hgxfxMapper;
  36. @Resource
  37. HgxfxHgscxMapper hgxfxHgscxMapper;
  38. @Resource
  39. HgxfxScxMapper hgxfxScxMapper;
  40. @Resource
  41. private FxrwrzMapper fxrwrzMapper;
  42. @Resource
  43. private FzssChscMapper fzssChscMapper;
  44. //合规性分析python方法名标识
  45. @Value("${Hgxfx.functionId}")
  46. private String functionId;
  47. @Value("${Hgxfx.temp}")
  48. private String temp;
  49. @Value("${Hgxfx.ftpOut}")
  50. private String ftpOut;
  51. private static final Logger log = LoggerFactory.getLogger(HgxfxSchedule.class);
  52. /**
  53. * Scheduled 定时器参数
  54. * cron表达式:指定任务在特定时间执行
  55. * fixedDelay:表示上一次任务执行完成后多久再执行,参数类型long,单位:ms
  56. * fixedDelayString:与fixedDelay一样,只是参数类型是String
  57. * fixedRate:表示按一定的频率执行任务,参数类型long,单位:ms 如: fixedRate(5000),表示这个定时器任务每5秒执行一次
  58. * fixedRateString:与fixedRate一样,只是参数类型变为String
  59. * initialDelay:表示延迟多久再第一次执行任务,参数类型为long ,单位:ms
  60. * initialDelayString:与initialDelay一样,只是参数类型String
  61. */
  62. /**
  63. * @Async("name") 开启多线程
  64. */
  65. /**
  66. * 合规性分析执行入口
  67. */
  68. @Async("taskExecutor")
  69. @Scheduled(fixedDelay = TIME_INTERVAL)
  70. public void HgxfxStatus() {
  71. try {
  72. QueryWrapper<HgxfxDTO> wrapper = new QueryWrapper<HgxfxDTO>();
  73. wrapper.eq("rwzt", Rwzt.getCreate());
  74. //以创建时间正序排列
  75. wrapper.orderByAsc("cjsj");
  76. //每次只操作一条记录
  77. List<HgxfxDTO> ress = hgxfxMapper.selectList(wrapper);
  78. if (ress.size() > 0) {
  79. HgxfxDTO res = ress.get(0);
  80. //插入执行状态
  81. res.setRwzt(Rwzt.getRun());
  82. res.setRwkssj(new Date());
  83. QueryWrapper<HgxfxDTO> query = new QueryWrapper<HgxfxDTO>();
  84. query.eq("bsm", res.getBsm());
  85. hgxfxMapper.update(res, query);
  86. //插入任务日志
  87. FxrwrzDTO rzDto = new FxrwrzDTO();
  88. rzDto.setRwbsm(res.getBsm());
  89. rzDto.setRwlx("合规性检查");
  90. rzDto.setRzlr("开始分析");
  91. rzDto.setRzlx("info");
  92. rzDto.setRzsj(new Date());
  93. fxrwrzMapper.insert(rzDto);
  94. //执行python
  95. Map<String, String> params = new HashMap<>();
  96. params.put("bsm", res.getBsm());
  97. String result = PythonExecute.Run(functionId, params);
  98. if (!StringUtils.isEmpty(result) && result.contains("OK")) {//成功
  99. res.setRwjssj(new Date());
  100. res.setRwzt(Rwzt.getComplete());
  101. //捕获报告生成异常
  102. try {
  103. //TODO 生成合规性分析结果报告 返回 FxReport实体
  104. FxReport report = createReport(res.getBsm());
  105. res.setFxbg(report.getReportfile());
  106. hgxfxMapper.update(res, query);
  107. //TODO 策划生成 项目
  108. if ("OpenAPI".equals(res.getRwly())) {
  109. QueryWrapper<FzxzChscDTO> chscwrapper = new QueryWrapper<FzxzChscDTO>();
  110. chscwrapper.eq("bsm", res.getBsm());
  111. FzxzChscDTO chscDto = fzssChscMapper.selectOne(chscwrapper);
  112. chscDto.setRwzt(Rwzt.getComplete());
  113. chscDto.setRwjg("分析完成");
  114. chscDto.setRwjd(100);
  115. fzssChscMapper.update(chscDto, chscwrapper);
  116. //拷贝合规性分析报告
  117. com.onemap.common.core.utils.file.FileUtils.copyNewFileAndRename(ftpOut, report.getPdffile(), chscDto.getXmmc() + ".pdf");
  118. }
  119. //插入任务日志
  120. FxrwrzDTO rzDto2 = new FxrwrzDTO();
  121. rzDto2.setRwbsm(res.getBsm());
  122. rzDto2.setRwlx("合规性检查");
  123. rzDto2.setRzlr("生成分析报告完成");
  124. rzDto2.setRzlx("info");
  125. rzDto2.setRzsj(new Date());
  126. fxrwrzMapper.insert(rzDto2);
  127. //休眠1S,避免日志插入时间相同
  128. Thread.sleep(1000 * 1);
  129. //插入成功日志
  130. FxrwrzDTO successDto = new FxrwrzDTO();
  131. successDto.setRwbsm(res.getBsm());
  132. successDto.setRwlx("合规性检查");
  133. successDto.setRzlr("分析完成");
  134. successDto.setRzlx("info");
  135. successDto.setRzsj(new Date());
  136. fxrwrzMapper.insert(successDto);
  137. } catch (Exception e) {
  138. e.printStackTrace();
  139. res.setRwzt(Rwzt.getError());
  140. hgxfxMapper.update(res, query);
  141. if ("OpenAPI".equals(res.getRwly())) {
  142. QueryWrapper<FzxzChscDTO> chscwrapper = new QueryWrapper<FzxzChscDTO>();
  143. chscwrapper.eq("bsm", res.getBsm());
  144. FzxzChscDTO chscDto = fzssChscMapper.selectOne(chscwrapper);
  145. chscDto.setRwzt(Rwzt.getError());
  146. chscDto.setRwjg("报告生成异常");
  147. fzssChscMapper.update(chscDto, chscwrapper);
  148. }
  149. //插入任务日志
  150. FxrwrzDTO errorDto = new FxrwrzDTO();
  151. errorDto.setRwbsm(res.getBsm());
  152. errorDto.setRwlx("合规性检查");
  153. errorDto.setRzlr("报告生成异常");
  154. errorDto.setRzlx("error");
  155. errorDto.setRzsj(new Date());
  156. fxrwrzMapper.insert(errorDto);
  157. }
  158. } else {//失败
  159. res.setRwjssj(new Date());
  160. res.setRwzt(Rwzt.getError());
  161. hgxfxMapper.update(res, query);
  162. if ("OpenAPI".equals(res.getRwly())) {
  163. QueryWrapper<FzxzChscDTO> chscwrapper = new QueryWrapper<FzxzChscDTO>();
  164. chscwrapper.eq("bsm", res.getBsm());
  165. FzxzChscDTO chscDto = fzssChscMapper.selectOne(chscwrapper);
  166. chscDto.setRwzt(Rwzt.getError());
  167. chscDto.setRwjg("分析错误");
  168. fzssChscMapper.update(chscDto, chscwrapper);
  169. }
  170. //插入任务日志
  171. FxrwrzDTO errorDto = new FxrwrzDTO();
  172. errorDto.setRwbsm(res.getBsm());
  173. errorDto.setRwlx("合规性检查");
  174. errorDto.setRzlr("分析范围内无基础数据");
  175. errorDto.setRzlx("error");
  176. errorDto.setFxjg(result);
  177. errorDto.setRzsj(new Date());
  178. fxrwrzMapper.insert(errorDto);
  179. }
  180. System.out.println("合规性分析模块:" + res.getBsm() + "完成!!!!!!!! " + new Date().toString());
  181. }
  182. } catch (Exception e) {
  183. e.printStackTrace();
  184. }
  185. }
  186. /**
  187. * 根据任务标识码生成报告
  188. *
  189. * @return
  190. */
  191. public FxReport createReport(String bsm) {
  192. //插入任务日志
  193. // FxrwrzDTO rzDto = new FxrwrzDTO();
  194. // rzDto.setRwbsm(bsm);
  195. // rzDto.setRwlx("合规性检查");
  196. // rzDto.setRzlr("开始生成分析报告");
  197. // rzDto.setRzlx("info");
  198. // rzDto.setRzsj(new Date());
  199. // fxrwrzMapper.insert(rzDto);
  200. FxReport fxReport = new FxReport();
  201. QueryWrapper<HgxfxDTO> wrapper = new QueryWrapper<HgxfxDTO>();
  202. wrapper.eq("bsm", bsm);
  203. HgxfxDTO res = hgxfxMapper.selectOne(wrapper);
  204. //文件硬盘真实路径
  205. String timeStamp = new Date().getTime() + "";
  206. String rootPath = temp + File.separator + "合规性检查报告"
  207. + File.separator + res.getBsm();
  208. File rootFile = new File(rootPath);
  209. if (!rootFile.exists()) {
  210. rootFile.mkdirs();
  211. }
  212. String reportPath = rootPath
  213. + File.separator + res.getXmmc() + "(合规性检查报告)_" + timeStamp + ".docx";
  214. //解析文件路径为web路径
  215. String webFilePath = StringUtils.getFileStaticPath(reportPath, temp);
  216. double mj = 0;
  217. if (res != null) {
  218. XWPFDocument document = null;
  219. OutputStream outputStream = null;//把doc输出到输出流
  220. try {
  221. //前端映射路径
  222. System.out.println(reportPath);
  223. //创建poi XWPFDocument doc文件
  224. document = new XWPFDocument();
  225. int pos = 0;
  226. //文本标题
  227. String title = res.getXmmc() + "合规性检查报告";
  228. NpoiHelper.title(document, title, pos++);
  229. NpoiHelper.Option option = new NpoiHelper.Option();
  230. option.setFontSize(19);
  231. option.setAlign(ParagraphAlignment.CENTER);
  232. option.setBold(true);
  233. List<String> list = new ArrayList<>();
  234. list.add("");
  235. document.setParagraph(NpoiHelper.newParagraph(document, list, option), pos++);
  236. SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
  237. option = new NpoiHelper.Option();
  238. option.setAlign(ParagraphAlignment.CENTER);
  239. document.setParagraph(NpoiHelper.newParagraph(document, sdf.format(new Date())
  240. , option), pos++);
  241. NpoiHelper.catalog(document, "一、项目合规性审查", pos++);
  242. XWPFTable table = document.createTable(1, 4);
  243. int tableIndex = 0;
  244. table.setWidth(9000);//总宽度
  245. table.setCellMargins(100, 0, 200, 0);
  246. for (int i = 0; i < 4; i++) {
  247. XWPFTableCell cell = table.getRow(0).getCell(i);
  248. CTTcPr ctTcPr = cell.getCTTc().isSetTcPr() ? cell.getCTTc().getTcPr() : cell.getCTTc().addNewTcPr();
  249. CTTblWidth ctTblWidth = ctTcPr.addNewTcW();
  250. ctTblWidth.setW(BigInteger.valueOf(2250));
  251. ctTblWidth.setType(STTblWidth.DXA);
  252. }
  253. //Table 表格第1行
  254. NpoiHelper.Option optionCenterAndBold = new NpoiHelper.Option();
  255. optionCenterAndBold.setBold(true);
  256. optionCenterAndBold.setAlign(ParagraphAlignment.CENTER);
  257. NpoiHelper.Option optionCenter = new NpoiHelper.Option();
  258. optionCenter.setAlign(ParagraphAlignment.CENTER);
  259. table.getRow(0).getCell(0).setParagraph(NpoiHelper.setCellText(table, "项目名称", optionCenterAndBold));
  260. table.getRow(0).getCell(1).setParagraph(NpoiHelper.setCellText(table, res.getXmmc(), null));
  261. table.getRow(0).getCell(2).setParagraph(NpoiHelper.setCellText(table, "项目类型", optionCenterAndBold));
  262. table.getRow(0).getCell(3).setParagraph(NpoiHelper.setCellText(table, res.getXmlx(), null));
  263. XWPFTableRow row = table.createRow();
  264. tableIndex++;
  265. row.getCell(0).setParagraph(NpoiHelper.setCellText(table, "用地面积", optionCenterAndBold));
  266. row.getCell(1).setParagraph(NpoiHelper.setCellText(table, res.getFxmj() + "㎡", null));
  267. row.getCell(2).setParagraph(NpoiHelper.setCellText(table, "建设单位", optionCenterAndBold));
  268. row.getCell(3).setParagraph(NpoiHelper.setCellText(table, res.getJsdw(), null));
  269. row = table.createRow();
  270. tableIndex++;
  271. row.getCell(0).setParagraph(NpoiHelper.setCellText(table, "管控要素分类", optionCenterAndBold));
  272. row.getCell(1).setParagraph(NpoiHelper.setCellText(table, "检查要素", optionCenterAndBold));
  273. row.getCell(2).setParagraph(NpoiHelper.setCellText(table, "涉及面积", optionCenterAndBold));
  274. row.getCell(3).setParagraph(NpoiHelper.setCellText(table, "结论", optionCenterAndBold));
  275. //先查询FzssHgxfxHgscx,再查询FzssHgxfxScx
  276. QueryWrapper<HgxfxHgscxDTO> wrapperHgxfxHgscxDTO = new QueryWrapper<HgxfxHgscxDTO>();
  277. wrapperHgxfxHgscxDTO.eq("rwbsm", res.getBsm());
  278. List<HgxfxHgscxExportDTO> hgxfxHgscxDTOList = hgxfxHgscxMapper.queryScxList(res.getBsm());
  279. //一级控制线
  280. Map[] mapArray = new Map[hgxfxHgscxDTOList.size()];
  281. //审查项数组排序序号
  282. int index = 0;
  283. for (int i = 0; i < hgxfxHgscxDTOList.size(); i++) {
  284. HgxfxHgscxExportDTO hgxfxHgscxDTO = hgxfxHgscxDTOList.get(i);
  285. if (hgxfxHgscxDTO.getKzxjb() == 1) {
  286. Map<String, Object> map = new HashMap<>();
  287. map.put("scx", hgxfxHgscxDTO);
  288. map.put("hgscx", hgxfxHgscxDTO);
  289. mapArray[index] = map;
  290. index++;
  291. }
  292. }
  293. int startRowIndex = tableIndex;
  294. for (int i = 0; i < mapArray.length; i++) {
  295. if (mapArray[i] != null) {
  296. HgxfxHgscxExportDTO hgxfxHgscxDTO = (HgxfxHgscxExportDTO) mapArray[i].get("hgscx");
  297. if (hgxfxHgscxDTO != null) {
  298. hgxfxHgscxDTO.setZdmj(hgxfxHgscxDTO.getZdmj() == null ? 0 : hgxfxHgscxDTO.getZdmj());
  299. row = table.createRow();
  300. tableIndex++;
  301. row.getCell(0).setParagraph(NpoiHelper.setCellText(table, "一级控制线", optionCenterAndBold));
  302. row.getCell(1).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getYsmc(), null));
  303. row.getCell(2).setParagraph(NpoiHelper.setCellText(table, Math.round(hgxfxHgscxDTO.getZdmj()) + "m²", optionCenter));
  304. row.getCell(3).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getJcjg(), null));
  305. mj = mj + hgxfxHgscxDTO.getZdmj();
  306. }
  307. }
  308. }
  309. //合并列
  310. NpoiHelper.mergeCellsVertically(table, 0, startRowIndex + 1, tableIndex);
  311. //二级控制线
  312. mapArray = new Map[hgxfxHgscxDTOList.size()];
  313. //审查项数组排序序号
  314. index = 0;
  315. for (int i = 0; i < hgxfxHgscxDTOList.size(); i++) {
  316. //二级控制线
  317. HgxfxHgscxExportDTO hgxfxHgscxDTO = hgxfxHgscxDTOList.get(i);
  318. if (hgxfxHgscxDTO != null) {
  319. if (hgxfxHgscxDTO.getKzxjb() == 2) {
  320. Map<String, Object> map = new HashMap<>();
  321. map.put("scx", hgxfxHgscxDTO);
  322. map.put("hgscx", hgxfxHgscxDTO);
  323. mapArray[index] = map;
  324. index++;
  325. }
  326. }
  327. }
  328. startRowIndex = tableIndex;
  329. for (int i = 0; i < mapArray.length; i++) {
  330. if (mapArray[i] != null) {
  331. HgxfxHgscxExportDTO hgxfxHgscxDTO = (HgxfxHgscxExportDTO) mapArray[i].get("hgscx");
  332. if (hgxfxHgscxDTO != null) {
  333. row = table.createRow();
  334. tableIndex++;
  335. row.getCell(0).setParagraph(NpoiHelper.setCellText(table, "二级控制线", optionCenterAndBold));
  336. row.getCell(1).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getYsmc(), null));
  337. row.getCell(2).setParagraph(NpoiHelper.setCellText(table, Math.round(hgxfxHgscxDTO.getZdmj()) + "m²", optionCenter));
  338. row.getCell(3).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getJcjg(), null));
  339. mj = mj + hgxfxHgscxDTO.getZdmj();
  340. }
  341. }
  342. }
  343. //设置用地面积
  344. table.getRow(1).getCell(1).setParagraph(NpoiHelper.setCellText(table, res.getFxmj() + "㎡", null));
  345. NpoiHelper.mergeCellsVertically(table, 0, startRowIndex + 1, tableIndex);
  346. //TODO wanger 将其他审查项插入到表
  347. Map<String, List<HgxfxHgscxExportDTO>> scxMap = new HashMap<>();
  348. //组织数据
  349. for (int i = 0; i < hgxfxHgscxDTOList.size(); i++) {
  350. HgxfxHgscxExportDTO hgxfxHgscxDTO = hgxfxHgscxDTOList.get(i);
  351. if (hgxfxHgscxDTO.getKzxjb() > 2) {
  352. String classify = hgxfxHgscxDTO.getTjzd();
  353. if (scxMap.get(classify) == null) {
  354. scxMap.put(classify, new ArrayList<>());
  355. }
  356. scxMap.get(classify).add(hgxfxHgscxDTO);
  357. }
  358. }
  359. //循环添加
  360. Iterator<Map.Entry<String, List<HgxfxHgscxExportDTO>>> iterator = scxMap.entrySet().iterator();
  361. while (iterator.hasNext()) {
  362. Map.Entry<String, List<HgxfxHgscxExportDTO>> entry = iterator.next();
  363. String key = entry.getKey();
  364. List<HgxfxHgscxExportDTO> value = entry.getValue();
  365. mapArray = new Map[value.size()];
  366. //审查项数组排序序号
  367. index = 0;
  368. for (int i = 0; i < value.size(); i++) {
  369. //二级控制线
  370. HgxfxHgscxExportDTO hgxfxHgscxDTO = value.get(i);
  371. Map<String, HgxfxHgscxExportDTO> map = new HashMap<>();
  372. map.put("scx", hgxfxHgscxDTO);
  373. map.put("hgscx", hgxfxHgscxDTO);
  374. mapArray[index] = map;
  375. index++;
  376. }
  377. startRowIndex = tableIndex;
  378. for (int i = 0; i < mapArray.length; i++) {
  379. if (mapArray[i] != null) {
  380. HgxfxHgscxExportDTO hgxfxHgscxDTO = (HgxfxHgscxExportDTO) mapArray[i].get("hgscx");
  381. if (hgxfxHgscxDTO != null) {
  382. row = table.createRow();
  383. tableIndex++;
  384. row.getCell(0).setParagraph(NpoiHelper.setCellText(table, key, optionCenterAndBold));
  385. row.getCell(1).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getYsmc(), null));
  386. row.getCell(2).setParagraph(NpoiHelper.setCellText(table, Math.round(hgxfxHgscxDTO.getZdmj()) + "m²", optionCenter));
  387. row.getCell(3).setParagraph(NpoiHelper.setCellText(table, hgxfxHgscxDTO.getJcjg(), null));
  388. mj = mj + hgxfxHgscxDTO.getZdmj();
  389. }
  390. }
  391. }
  392. //设置用地面积
  393. table.getRow(1).getCell(1).setParagraph(NpoiHelper.setCellText(table, res.getFxmj() + "㎡", null));
  394. NpoiHelper.mergeCellsVertically(table, 0, startRowIndex + 1, tableIndex);
  395. }
  396. //第二章节
  397. NpoiHelper.catalog(document, "二、项目用地明细", pos++);
  398. XWPFTable tableSecond = document.createTable(1, 5);
  399. tableSecond.setCellMargins(100, 0, 200, 0);
  400. tableSecond.setWidth(9000);//总宽度
  401. //Table 表格第0行
  402. tableSecond.getRow(0).getCell(0).setParagraph(NpoiHelper.setCellText(tableSecond, "一级地类", optionCenterAndBold));
  403. tableSecond.getRow(0).getCell(2).setParagraph(NpoiHelper.setCellText(tableSecond, "二级地类", optionCenterAndBold));
  404. tableSecond.getRow(0).getCell(4).setParagraph(NpoiHelper.setCellText(tableSecond, "占地面积", optionCenterAndBold));
  405. //合并列
  406. NpoiHelper.mergeHorizontal(tableSecond, 0, 0, 1);
  407. NpoiHelper.mergeHorizontal(tableSecond, 0, 2, 3);
  408. //查询HgxfxFxtbDTO
  409. List<HgxfxFxtbDTO> hgxfxFxtbDTOList = hgxfxMapper.getFxtb(res.getBsm());
  410. NpoiHelper.Option optionFontSizeAlign = new NpoiHelper.Option();
  411. optionFontSizeAlign.setAlign(ParagraphAlignment.CENTER);
  412. optionFontSizeAlign.setFontSize(10);
  413. NpoiHelper.Option optionFontSize = new NpoiHelper.Option();
  414. optionFontSize.setFontSize(10);
  415. for (int i = 0; i < hgxfxFxtbDTOList.size(); i++) {
  416. HgxfxFxtbDTO hgxfxFxtbDTO = hgxfxFxtbDTOList.get(i);
  417. XWPFTableRow row1 = tableSecond.createRow();
  418. tableIndex++;
  419. row1.getCell(0).setParagraph(NpoiHelper.setCellText(tableSecond, hgxfxFxtbDTO.getDldm1(), optionFontSizeAlign));
  420. row1.getCell(1).setParagraph(NpoiHelper.setCellText(tableSecond, hgxfxFxtbDTO.getDlmc1(), optionFontSize));
  421. row1.getCell(2).setParagraph(NpoiHelper.setCellText(tableSecond, hgxfxFxtbDTO.getDldm2(), optionFontSizeAlign));
  422. row1.getCell(3).setParagraph(NpoiHelper.setCellText(tableSecond, hgxfxFxtbDTO.getDlmc2(), optionFontSize));
  423. if (hgxfxFxtbDTO.getMj() == null) {
  424. hgxfxFxtbDTO.setMj(0.0);
  425. }
  426. row1.getCell(4).setParagraph(NpoiHelper.setCellText(tableSecond, Math.round(hgxfxFxtbDTO.getMj()) + "㎡", optionFontSizeAlign));
  427. }
  428. if (tableSecond.getRow(1) != null) {
  429. for (int i = 0; i < 5; i++) {
  430. XWPFTableCell cell = tableSecond.getRow(1).getCell(i);
  431. CTTcPr ctTcPr = cell.getCTTc().isSetTcPr() ? cell.getCTTc().getTcPr() : cell.getCTTc().addNewTcPr();
  432. CTTblWidth ctTblWidth = ctTcPr.addNewTcW();
  433. ctTblWidth.setW(BigInteger.valueOf(1800));
  434. ctTblWidth.setType(STTblWidth.DXA);
  435. }
  436. }
  437. File fileDoc = new File(reportPath);
  438. if (fileDoc.exists()) {
  439. FileUtils.delete(fileDoc);
  440. }
  441. //word文件输出流
  442. outputStream = new FileOutputStream(reportPath);
  443. document.write(outputStream);
  444. } catch (Exception e) {
  445. log.error(e.toString());
  446. //插入任务日志
  447. FxrwrzDTO errorDto = new FxrwrzDTO();
  448. errorDto.setRwbsm(res.getBsm());
  449. errorDto.setRwlx("合规性检查");
  450. errorDto.setRzlr("报告生成异常:" + e.getMessage());
  451. errorDto.setRzlx("error");
  452. errorDto.setRzsj(new Date());
  453. fxrwrzMapper.insert(errorDto);
  454. // e.printStackTrace();
  455. } finally {
  456. if (outputStream != null) {
  457. try {
  458. outputStream.close();
  459. } catch (Exception ex) {
  460. log.error(ex.toString());
  461. }
  462. }
  463. if (document != null) {
  464. try {
  465. document.close();
  466. } catch (Exception ex) {
  467. log.error(ex.toString());
  468. }
  469. }
  470. }
  471. //转PDF
  472. String outfilepath = reportPath.replace(".docx", ".pdf");
  473. if (new File(reportPath).exists()) {
  474. NpoiHelper.doc2pdf(reportPath, outfilepath);
  475. //更新报告对象
  476. fxReport.setReportfile(webFilePath);
  477. fxReport.setMj(mj);
  478. fxReport.setPdffile(outfilepath);
  479. }
  480. }
  481. return fxReport;
  482. }
  483. }