| | |
| | | LocalDateTime endOfToday = LocalDateTimeUtil.endOfDay(LocalDateTime.now()); |
| | | if (CrmContractPageReqVO.EXPIRY_TYPE_ABOUT_TO_EXPIRE.equals(pageReqVO.getExpiryType())) { // 即将到期 |
| | | query.eq(CrmContractDO::getAuditStatus, CrmAuditStatusEnum.APPROVE.getStatus()) |
| | | .between(CrmContractDO::getEndTime, beginOfToday, endOfToday.plusDays(config.getNotifyDays())); |
| | | // notifyDays 可能为 null(历史配置未填),为 null 时按 0 天处理,避免拆箱 NPE |
| | | .between(CrmContractDO::getEndTime, beginOfToday, |
| | | endOfToday.plusDays(config.getNotifyDays() != null ? config.getNotifyDays() : 0)); |
| | | } else if (CrmContractPageReqVO.EXPIRY_TYPE_EXPIRED.equals(pageReqVO.getExpiryType())) { // 已到期 |
| | | query.eq(CrmContractDO::getAuditStatus, CrmAuditStatusEnum.APPROVE.getStatus()) |
| | | .lt(CrmContractDO::getEndTime, endOfToday); |
| | |
| | | LocalDateTime beginOfToday = LocalDateTimeUtil.beginOfDay(LocalDateTime.now()); |
| | | LocalDateTime endOfToday = LocalDateTimeUtil.endOfDay(LocalDateTime.now()); |
| | | query.eq(CrmContractDO::getAuditStatus, CrmAuditStatusEnum.APPROVE.getStatus()) // 必须审批通过! |
| | | .between(CrmContractDO::getEndTime, beginOfToday, endOfToday.plusDays(config.getNotifyDays())); |
| | | // notifyDays 可能为 null(历史配置未填),为 null 时按 0 天处理,避免拆箱 NPE |
| | | .between(CrmContractDO::getEndTime, beginOfToday, |
| | | endOfToday.plusDays(config.getNotifyDays() != null ? config.getNotifyDays() : 0)); |
| | | return selectCount(query); |
| | | } |
| | | |