| | |
|---|
| | | 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.importExcel.TBankFlowImportExcel; |
|---|
| | |
|---|
| | | /** |
|---|
| | | * 获取流水列表 |
|---|
| | | */ |
|---|
| | | @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)); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | }).sheet().doRead(); |
|---|
| | | // 导出导入结果 |
|---|
| | | HttpServletResponse response = WebUtils.response(); |
|---|
| | | response.setContentType("application/vnd.ms-excel;charset=utf-8"); |
|---|
| | | response.setContentType("application/vnd.ms-excel;charset=UTF-8"); |
|---|
| | | response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); |
|---|
| | | response.setHeader("Content-Length","1"); |
|---|
| | | response.setHeader("Pragma", "no-cache"); |
|---|
| | | if (failList.size() > 0) { |
|---|
| | | EasyExcel.write(response.getOutputStream(), TBankFlowImportExcel.class).sheet("Sheet1").doWrite(failList); |
|---|
