package com.ruoyi.cwgl.controller; import java.util.List; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.ruoyi.common.utils.file.DownloadExportUtil; import com.ruoyi.common.annotation.Log; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.cwgl.domain.FundFlow; import com.ruoyi.cwgl.service.IFundFlowService; import com.ruoyi.cwgl.service.ICmbsBankSyncService; import com.ruoyi.common.utils.poi.ExcelUtil; import org.springframework.web.multipart.MultipartFile; import com.ruoyi.common.core.page.TableDataInfo; /** * 资金流水Controller * * @author ruoyi * @date 2026-01-12 */ @RestController @RequestMapping("/cwgl/fundFlow") public class FundFlowController extends BaseController { @Autowired private IFundFlowService fundFlowService; @Autowired private ICmbsBankSyncService cmbsBankSyncService; /** * 从CMBS同步银行流水到资金流水表 * * @param acctNum 账号 * @param startDate 开始日期 yyyy-MM-dd * @param endDate 结束日期 yyyy-MM-dd */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:sync')") @Log(title = "CMBS银行流水同步", businessType = BusinessType.OTHER) @PostMapping("/syncFromCmbs") public AjaxResult syncFromCmbs(String acctNum, String startDate, String endDate) { try { String result = cmbsBankSyncService.syncFromCmbs(acctNum, startDate, endDate); return AjaxResult.success(result); } catch (Exception e) { return AjaxResult.error("同步失败: " + e.getMessage()); } } /** * 查询资金流水列表 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:list')") @GetMapping("/list") public TableDataInfo list(FundFlow fundFlow) { startPage(); List list = fundFlowService.selectFundFlowList(fundFlow); return getDataTable(list); } /** * 导出资金流水列表 * @param fundFlow 查询条件对象 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:export')") @Log(title = "资金流水", businessType = BusinessType.EXPORT) @GetMapping("/export") public AjaxResult export(FundFlow fundFlow,String exportKey) { fundFlowService.export(fundFlow,exportKey); return AjaxResult.success("导出请求成功,请稍后点击下载...!"); } /** * 获取资金流水详细信息 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:query')") @GetMapping(value = "/{id}") public AjaxResult getInfo(@PathVariable("id") Integer id) { return AjaxResult.success(fundFlowService.selectFundFlowById(id)); } /** * 新增资金流水 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:add')") @Log(title = "资金流水", businessType = BusinessType.INSERT) @PostMapping public AjaxResult add(@RequestBody FundFlow fundFlow) { return toAjax(fundFlowService.insertFundFlow(fundFlow)); } /** * 修改资金流水 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:edit')") @Log(title = "资金流水", businessType = BusinessType.UPDATE) @PutMapping public AjaxResult edit(@RequestBody FundFlow fundFlow) { return toAjax(fundFlowService.updateFundFlow(fundFlow)); } /** * 删除资金流水 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:remove')") @Log(title = "资金流水", businessType = BusinessType.DELETE) @DeleteMapping("/{ids}") public AjaxResult remove(@PathVariable Integer[] ids) { return toAjax(fundFlowService.deleteFundFlowByIds(ids)); } /** * 确认资金流水(将状态改为待认领) */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:edit')") @Log(title = "资金流水", businessType = BusinessType.UPDATE) @PutMapping("/confirm/{id}") public AjaxResult confirm(@PathVariable("id") Integer id) { return toAjax(fundFlowService.confirmFundFlow(id)); } /** * 导入资金流水Excel */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:import')") @Log(title = "资金流水", businessType = BusinessType.IMPORT) @PostMapping("/importData") public AjaxResult importData(MultipartFile file ) throws Exception { ExcelUtil util = new ExcelUtil(FundFlow.class); List fundFlowList = util.importExcel(file.getInputStream()); String message = fundFlowService.importFundFlow(fundFlowList); return AjaxResult.success(message); } /** * 下载导入资金流水模板 */ @PreAuthorize("@ss.hasPermi('cwgl:fundFlow:import')") @GetMapping("/importTemplate") public AjaxResult importTemplate(String exportKey) { fundFlowService.importTemplate(exportKey); return AjaxResult.success("导出请求成功,请稍后点击下载...!"); } }