| | |
| | | |
| | | } |
| | | |
| | | @Autowired |
| | | private ReceiptPaymentServiceImpl receiptPaymentService; |
| | | |
| | | @Override |
| | | public Long overdueReceivable() { |
| | | // 通过开票日期超过15天的未回款提示 |
| | | ReceiptPaymentDto receiptPaymentDto = new ReceiptPaymentDto(); |
| | | receiptPaymentDto.setTimeOut(true); |
| | | receiptPaymentDto.setStatus(false); |
| | | IPage<ReceiptPaymentDto> receiptPaymentDtoIPage = receiptPaymentService.bindInvoiceNoRegPage(new Page<>(-1, -1), receiptPaymentDto); |
| | | return receiptPaymentDtoIPage.getTotal(); |
| | | // 通过登记日期超过15天的未回款提示 |
| | | LambdaQueryWrapper<SalesLedgerProduct> lambdaWrapper = new LambdaQueryWrapper<>(); |
| | | // 时间条件:registerDate < 当前时间 - 15天 |
| | | lambdaWrapper.apply("register_date < DATE_SUB(NOW(), INTERVAL 15 DAY)"); |
| | | // 未回款条件:pendingInvoiceTotal > 0 |
| | | lambdaWrapper.gt(SalesLedgerProduct::getPendingInvoiceTotal, 0); |
| | | return salesLedgerProductMapper.selectCount(lambdaWrapper); |
| | | } |
| | | |
| | | |