From 7dbe348fa7fd4c24d2111b7bd6c41ec76192a50a Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期四, 07 五月 2026 18:02:16 +0800
Subject: [PATCH] feat(customer-contact): 修改客户联系人删除接口支持批量删除
---
src/main/java/com/ruoyi/basic/controller/CustomerContactController.java | 6 ++++--
src/main/resources/mapper/basic/CustomerContactMapper.xml | 16 +++++++++++-----
2 files changed, 15 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/ruoyi/basic/controller/CustomerContactController.java b/src/main/java/com/ruoyi/basic/controller/CustomerContactController.java
index e5e8ce9..f468b8d 100644
--- a/src/main/java/com/ruoyi/basic/controller/CustomerContactController.java
+++ b/src/main/java/com/ruoyi/basic/controller/CustomerContactController.java
@@ -9,6 +9,8 @@
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.*;
+import java.util.List;
+
/**
* <p>
* 瀹㈡埛鑱旂郴浜鸿〃 鍓嶇鎺у埗鍣�
@@ -58,7 +60,7 @@
@DeleteMapping("/delete")
@Operation(summary = "鍒犻櫎")
- public R delete(@RequestBody CustomerContactDto customerContact) {
- return R.ok(customerContactService.removeById(customerContact));
+ public R delete(@RequestBody List<Long> ids) {
+ return R.ok(customerContactService.removeByIds(ids));
}
}
diff --git a/src/main/resources/mapper/basic/CustomerContactMapper.xml b/src/main/resources/mapper/basic/CustomerContactMapper.xml
index 8a184e4..c680e53 100644
--- a/src/main/resources/mapper/basic/CustomerContactMapper.xml
+++ b/src/main/resources/mapper/basic/CustomerContactMapper.xml
@@ -17,22 +17,28 @@
<result column="del_flag" property="delFlag" />
</resultMap>
<select id="listPage" resultType="com.ruoyi.basic.dto.CustomerContactDto">
+ select * from (
SELECT
- cc.*,
+ c.*,
(
SELECT GROUP_CONCAT(ci.customer_name SEPARATOR ',')
FROM customer ci
- WHERE FIND_IN_SET(ci.id, cc.customer_id)
+ WHERE FIND_IN_SET(ci.id, c.customer_id)
) AS customer_names
- FROM customer_contact cc
+ FROM customer_contact c
+ ) as cc
<where>
cc.del_flag = 0
<if test="customerContactDto.contactPerson != null and customerContactDto.contactPerson !=''">
- and cc.contact_person = #{customerContactDto.contactPerson}
+ and cc.contact_person like concat('%',#{customerContactDto.contactPerson},'%')
</if>
<if test="customerContactDto.contactPhone != null and customerContactDto.contactPhone !=''">
- and cc.contact_phone = #{customerContactDto.contactPhone}
+ and cc.contact_phone like concat('%',#{customerContactDto.contactPhone},'%')
</if>
+ <if test="customerContactDto.customerId != null and customerContactDto.customerId !=''">
+ and FIND_IN_SET(#{customerContactDto.customerId}, cc.customer_id)
+ </if>
+
</where>
</select>
</mapper>
--
Gitblit v1.9.3