From abf1c0a35d85d38239ff5d2ed746a4e4b797c9d1 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期四, 20 八月 2026 14:05:02 +0800
Subject: [PATCH] feat 功能修正
---
yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java
index c27e561..19566a6 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java
@@ -3,6 +3,7 @@
import cn.hutool.core.date.LocalDateTimeUtil;
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX;
import cn.iocoder.yudao.module.crm.controller.admin.receivable.vo.plan.CrmReceivablePlanPageReqVO;
import cn.iocoder.yudao.module.crm.dal.dataobject.contract.CrmContractDO;
@@ -13,6 +14,8 @@
import org.apache.ibatis.annotations.Mapper;
import java.time.LocalDateTime;
+import java.util.Collection;
+import java.util.List;
import java.util.Objects;
/**
@@ -86,4 +89,22 @@
return selectCount(query);
}
+ /**
+ * 鏌ヨ涓�鎵瑰鎴风殑娆犺垂鍥炴璁″垝锛堟湭鍥炴 + 宸查�炬湡锛�
+ *
+ * 鍙e緞涓� {@link #selectPage(CrmReceivablePlanPageReqVO, Long)} 鐨勩�屽凡閫炬湡銆嶄竴鑷达細
+ * receivableId 涓虹┖锛堟湭鍥炴锛変笖 returnTime 鏃╀簬褰撳墠鏃堕棿
+ *
+ * @param customerIds 瀹㈡埛缂栧彿闆嗗悎
+ * @param now 褰撳墠鏃堕棿锛堥�炬湡鍒ゅ畾鏃堕棿鐐癸級
+ * @return 娆犺垂鐨勫洖娆捐鍒掑垪琛�
+ */
+ default List<CrmReceivablePlanDO> selectOverdueListByCustomerIds(Collection<Long> customerIds,
+ LocalDateTime now) {
+ return selectList(new LambdaQueryWrapperX<CrmReceivablePlanDO>()
+ .in(CrmReceivablePlanDO::getCustomerId, customerIds)
+ .isNull(CrmReceivablePlanDO::getReceivableId) // 鏈洖娆�
+ .lt(CrmReceivablePlanDO::getReturnTime, now)); // 宸查�炬湡
+ }
+
}
--
Gitblit v1.9.3