| | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.by4cloud.platformx.business.dto.BankStatementQueryDTO; |
| | | import com.by4cloud.platformx.business.dto.BankStatementUpdateDTO; |
| | | import com.by4cloud.platformx.business.dto.BipQueryDTO; |
| | | import com.by4cloud.platformx.business.dto.SyncPaymentRecepitDTO; |
| | | import com.by4cloud.platformx.business.entity.BankStatement; |
| | | import com.by4cloud.platformx.business.entity.BusinessCustomer; |
| | | import com.by4cloud.platformx.common.core.util.R; |
| | |
| | | /** |
| | | * 分页查询 |
| | | * @param page 分页对象 |
| | | * @param bankStatement 银行流水 |
| | | * @param queryDTO 银行流水 |
| | | * @return |
| | | */ |
| | | @Operation(summary = "分页查询" , description = "分页查询" ) |
| | | @GetMapping("/page" ) |
| | | @PreAuthorize("@pms.hasPermission('business_bankStatement_view')" ) |
| | | public R getBankStatementPage(@ParameterObject Page page, @ParameterObject BankStatement bankStatement) { |
| | | public R getBankStatementPage(@ParameterObject Page page, @ParameterObject BankStatementQueryDTO queryDTO) { |
| | | if (StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smj) || StrUtil.equals(SecurityUtils.getUser().getCompId() + "", smjhw)) { |
| | | LambdaQueryWrapper<BankStatement> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.like(StrUtil.isNotBlank(bankStatement.getPayBankAccName()),BankStatement::getPayBankAccName,bankStatement.getPayBankAccName()); |
| | | wrapper.like(StrUtil.isNotBlank(bankStatement.getReceiveBankAccName()),BankStatement::getReceiveBankAccName,bankStatement.getReceiveBankAccName()); |
| | | wrapper.orderByDesc(BankStatement::getCreateTime); |
| | | wrapper.like(StrUtil.isNotBlank(queryDTO.getPayBankAccName()),BankStatement::getPayBankAccName,queryDTO.getPayBankAccName()); |
| | | wrapper.like(StrUtil.isNotBlank(queryDTO.getReceiveBankAccName()),BankStatement::getReceiveBankAccName,queryDTO.getReceiveBankAccName()); |
| | | wrapper.ge(StrUtil.isNotBlank(queryDTO.getStartDate()),BankStatement::getTranDate,queryDTO.getStartDate()+" 00:00:00"); |
| | | wrapper.le(StrUtil.isNotBlank(queryDTO.getEndDate()),BankStatement::getTranDate,queryDTO.getEndDate()+" 23:59:59"); |
| | | wrapper.orderByDesc(BankStatement::getTranDate); |
| | | List<String> smjList = new ArrayList<>(); |
| | | smjList.add(smj); |
| | | smjList.add(smjhw); |
| | |
| | | return R.ok(bankStatementService.page(page, wrapper)); |
| | | } |
| | | LambdaQueryWrapper<BankStatement> wrapper = Wrappers.lambdaQuery(); |
| | | wrapper.like(StrUtil.isNotBlank(bankStatement.getPayBankAccName()),BankStatement::getPayBankAccName,bankStatement.getPayBankAccName()); |
| | | wrapper.like(StrUtil.isNotBlank(bankStatement.getReceiveBankAccName()),BankStatement::getReceiveBankAccName,bankStatement.getReceiveBankAccName()); |
| | | wrapper.orderByDesc(BankStatement::getCreateTime); |
| | | wrapper.like(StrUtil.isNotBlank(queryDTO.getPayBankAccName()),BankStatement::getPayBankAccName,queryDTO.getPayBankAccName()); |
| | | wrapper.like(StrUtil.isNotBlank(queryDTO.getReceiveBankAccName()),BankStatement::getReceiveBankAccName,queryDTO.getReceiveBankAccName()); |
| | | wrapper.ge(StrUtil.isNotBlank(queryDTO.getStartDate()),BankStatement::getTranDate,queryDTO.getStartDate()+" 00:00:00"); |
| | | wrapper.le(StrUtil.isNotBlank(queryDTO.getEndDate()),BankStatement::getTranDate,queryDTO.getEndDate()+" 23:59:59"); |
| | | wrapper.orderByDesc(BankStatement::getTranDate); |
| | | return R.ok(bankStatementService.pageByScope(page, wrapper)); |
| | | } |
| | | |
| | |
| | | public R pageBip(@ParameterObject Page page, @ParameterObject BipQueryDTO queryDTO) { |
| | | return R.ok(bankStatementService.pageBip(page, queryDTO)); |
| | | } |
| | | |
| | | @GetMapping("/pullBankData" ) |
| | | public R pullBankData(@ParameterObject SyncPaymentRecepitDTO queryDTO) { |
| | | return bankStatementService.pullBankData(queryDTO); |
| | | } |
| | | |
| | | } |