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