西藏国投
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zhangmei
2025-03-27 1fad0578c97abbb7fc30f59eb1de0f23f08ddde1 
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBankFlowController.java


@@ -1,37 +1,28 @@


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.SecurityUtils;


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,10 +45,11 @@


    /**


     * 获取流水列表


     */


    @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) {


        query.setBusinessDeptId(SecurityUtils.getBusinessDeptId());


        return R.ok(flowService.pageList(query));


    }




@@ -92,7 +84,6 @@


                        list.clear();


                    }


                }




                @Override


                public void doAfterAllAnalysed(AnalysisContext context) {


                    int size = list.size();


@@ -102,59 +93,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);


    }






}