From 0ab9dfd8f122195e4e9f09bd50c59e0a47450bec Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期三, 19 三月 2025 15:50:03 +0800 Subject: [PATCH] fix: resolve merge conflicts in .gitignore --- ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java | 77 +++++++++----------------------------- 1 files changed, 19 insertions(+), 58 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java index fff605c..07154a0 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java @@ -1,37 +1,27 @@ package com.ruoyi.web.controller.api; -import cn.afterturn.easypoi.excel.ExcelExportUtil; -import cn.afterturn.easypoi.excel.entity.ExportParams; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.event.AnalysisEventListener; import com.ruoyi.common.basic.PageInfo; import com.ruoyi.common.core.domain.R; +import com.ruoyi.common.utils.StringUtils; import com.ruoyi.common.utils.WebUtils; -import com.ruoyi.system.export.ContractExport; import com.ruoyi.system.importExcel.TBankFlowImportExcel; import com.ruoyi.system.model.TBankFlow; import com.ruoyi.system.query.TBankFlowQuery; import com.ruoyi.system.service.TBankFlowService; import com.ruoyi.system.vo.TBankFlowStatisticsVo; import io.swagger.annotations.ApiOperation; -import org.apache.poi.ss.usermodel.Workbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; -import org.springframework.web.bind.annotation.PostMapping; -import org.springframework.web.bind.annotation.RequestBody; -import org.springframework.web.bind.annotation.RequestMapping; -import org.springframework.web.bind.annotation.RestController; -import org.springframework.web.context.request.RequestContextHolder; -import org.springframework.web.context.request.ServletRequestAttributes; +import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; -import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.InputStream; -import java.net.URLEncoder; import java.util.ArrayList; import java.util.List; import java.util.Vector; @@ -54,7 +44,7 @@ /** * 获取流水列表 */ - @PreAuthorize("@ss.hasPermi('system:bankFlow:list')") + @PreAuthorize("@ss.hasPermi('flow:bank:detail:list')") @ApiOperation(value = "获取银行流水列表") @PostMapping("/list") public R<PageInfo<TBankFlow>> list(@RequestBody TBankFlowQuery query) { @@ -92,7 +82,6 @@ list.clear(); } } - @Override public void doAfterAllAnalysed(AnalysisContext context) { int size = list.size(); @@ -102,59 +91,31 @@ } }).sheet().doRead(); // 导出导入结果 - // ServletRequestAttributes servletRequestAttributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes(); - // HttpServletResponse response = servletRequestAttributes.getResponse(); - // response.setContentType("application/vnd.ms-excel;charset=utf-8"); - // response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); - // if (failList.size()>0) { - // EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); - // } else { - // TBankFlowImportExcel result = new TBankFlowImportExcel(); - // result.setResult("全部成功"); - // failList.add(result); - // EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); - // } - - - if (failList.size()==0){ + HttpServletResponse response = WebUtils.response(); + response.setContentType("application/vnd.ms-excel;charset=UTF-8"); + response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); + response.setHeader("Pragma", "no-cache"); + if (failList.size() > 0) { + EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); + } else { TBankFlowImportExcel result = new TBankFlowImportExcel(); result.setResult("全部成功"); failList.add(result); + EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); } - Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), TBankFlowImportExcel.class, failList); - HttpServletResponse response = WebUtils.response(); - response.setContentType("application/vnd.ms-excel"); - response.setCharacterEncoding("utf-8"); - ServletOutputStream outputStream = null; - try { - String fileName = URLEncoder.encode("银行流水返回结果.xls", "utf-8"); - response.setHeader("Content-Disposition", "attachment;filename=" + fileName); - response.setContentType("application/vnd.ms-excel;charset=UTF-8"); - response.setHeader("Pragma", "no-cache"); - response.setHeader("Cache-Control", "no-cache"); - outputStream = response.getOutputStream(); - workbook.write(outputStream); - } catch (IOException e) { - e.printStackTrace(); - System.err.println("银行流水返回结果导出失败"); - } finally { - try { - outputStream.close(); - } catch (IOException e) { - e.printStackTrace(); - } - } - - - - - - } catch (Exception e) { e.printStackTrace(); System.err.println("银行流水返回结果导出失败"); } } + + @GetMapping("getByBankSerialNumber") + public R<List<TBankFlow>> searchByBankSerialNumber(@RequestParam String bankSerialNumber){ + List<TBankFlow> tBankFlows = flowService.searchByBankSerialNumber(bankSerialNumber); + return R.ok(tBankFlows); + } + + } -- Gitblit v1.7.1