From 8348d3137b49317f20105e7e45cc30d43866b450 Mon Sep 17 00:00:00 2001
From: buhuazhen <hua100783@gmail.com>
Date: 星期五, 15 五月 2026 13:31:02 +0800
Subject: [PATCH] fix(customer): 限制未领用的公海客户不被其他模块引用

---
 src/main/resources/mapper/basic/CustomerMapper.xml |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/mapper/basic/CustomerMapper.xml b/src/main/resources/mapper/basic/CustomerMapper.xml
index 57dea6c..20aaefc 100644
--- a/src/main/resources/mapper/basic/CustomerMapper.xml
+++ b/src/main/resources/mapper/basic/CustomerMapper.xml
@@ -26,6 +26,7 @@
         from customer c
         left join sys_user u on c.usage_user = u.user_id
         <where>
+            and c.usage_status = 1
             <if test="c.customerName != null and c.customerName != ''">
                 and customer_name like concat('%', #{c.customerName}, '%')
             </if>
@@ -107,4 +108,4 @@
             </if>
         </where>
     </select>
-</mapper>
\ No newline at end of file
+</mapper>

--
Gitblit v1.9.3