| | |
| | | @Mapper |
| | | public interface CrmContractMapper extends BaseMapperX<CrmContractDO> { |
| | | |
| | | default CrmContractDO selectByNoForUpdate(String no) { |
| | | return selectOne(new LambdaQueryWrapperX<CrmContractDO>().eq(CrmContractDO::getNo, no).last("FOR UPDATE")); |
| | | } |
| | | |
| | | default CrmContractDO selectByIdForUpdate(Long id) { |
| | | return selectOne(new LambdaQueryWrapperX<CrmContractDO>().eq(CrmContractDO::getId, id).last("FOR UPDATE")); |
| | | } |
| | | default CrmContractDO selectByNo(String no) { |
| | | return selectOne(CrmContractDO::getNo, no); |
| | | } |
| | |
| | | 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); |
| | | } |
| | | |