From cdaec80a5ffa474f69e5c36f0312be3c0abf2210 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 05 十一月 2026 18:31:11 +0800
Subject: [PATCH] feat(crm): 投标保证金迁移到销售管理并关联销售台账

---
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivablePlanMapper.java |   17 +++++++++++++----
 1 files changed, 13 insertions(+), 4 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 e9e28b8..60dbd91 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
@@ -18,10 +18,20 @@
 /**
  * 鍥炴璁″垝 Mapper
  *
- * @author 鑺嬮亾婧愮爜
+ * @author 瓒呯骇绠$悊鍛�
  */
 @Mapper
 public interface CrmReceivablePlanMapper extends BaseMapperX<CrmReceivablePlanDO> {
+
+    /**
+     * 鏌ヨ寮�绁ㄥ崟鐢熸垚鐨勬敹娆捐妭鐐�
+     */
+    default java.util.List<CrmReceivablePlanDO> selectListByInvoiceId(Long invoiceId) {
+        return selectList(new cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX<CrmReceivablePlanDO>()
+                .eq(CrmReceivablePlanDO::getInvoiceId, invoiceId)
+                .orderByAsc(CrmReceivablePlanDO::getStage)
+                .orderByAsc(CrmReceivablePlanDO::getId));
+    }
 
     default CrmReceivablePlanDO selectMaxPeriodByContractId(Long contractId) {
         return selectOne(new MPJLambdaWrapperX<CrmReceivablePlanDO>()
@@ -78,11 +88,10 @@
         // 鎴戣礋璐g殑 + 闈炲叕娴�
         CrmPermissionUtils.appendPermissionCondition(query, CrmBizTypeEnum.CRM_RECEIVABLE_PLAN.getType(),
                 CrmReceivablePlanDO::getId, userId, CrmSceneTypeEnum.OWNER.getType());
-        // 鏈洖娆� + 宸查�炬湡 + 浠婂ぉ寮�濮嬫彁閱�
+        // 涓庡緟鍥炴鎻愰啋鍒楄〃涓�鑷达細鏈洖娆撅紝涓斿凡鍒版彁閱掓棩鏈燂紝涓嶈姹傚凡缁忛�炬湡銆�
         LocalDateTime beginOfToday = LocalDateTimeUtil.beginOfDay(LocalDateTime.now());
         query.isNull(CrmReceivablePlanDO::getReceivableId) // 鏈洖娆�
-                .lt(CrmReceivablePlanDO::getReturnTime, beginOfToday) // 宸查�炬湡
-                .lt(CrmReceivablePlanDO::getRemindTime, beginOfToday); // 浠婂ぉ寮�濮嬫彁閱�
+                .le(CrmReceivablePlanDO::getRemindTime, beginOfToday); // 鍖呭惈浠婂ぉ寮�濮嬫彁閱�
         return selectCount(query);
     }
 

--
Gitblit v1.9.3