From b53e0804fab35c8167148de07c3bbe12c68855f7 Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期日, 29 九月 2024 13:30:57 +0800
Subject: [PATCH] add:增加用户ID和注册手机号
---
src/main/java/com/mzl/flower/dto/response/supplier/SupplierDTO.java | 4 ++++
src/main/resources/mapper/supplier/SupplierMapper.xml | 4 +++-
2 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/supplier/SupplierDTO.java b/src/main/java/com/mzl/flower/dto/response/supplier/SupplierDTO.java
index 620351c..ec967dd 100644
--- a/src/main/java/com/mzl/flower/dto/response/supplier/SupplierDTO.java
+++ b/src/main/java/com/mzl/flower/dto/response/supplier/SupplierDTO.java
@@ -100,4 +100,8 @@
@ApiModelProperty("粉丝数")
private int fans;
+
+
+ @ApiModelProperty("注册手机号")
+ private String registerTel;
}
diff --git a/src/main/resources/mapper/supplier/SupplierMapper.xml b/src/main/resources/mapper/supplier/SupplierMapper.xml
index 7a06f2e..1f21e2f 100644
--- a/src/main/resources/mapper/supplier/SupplierMapper.xml
+++ b/src/main/resources/mapper/supplier/SupplierMapper.xml
@@ -7,11 +7,13 @@
SELECT
t.*,
s.name as stationName,
- st.`name` as typeName
+ st.`name` as typeName,
+ us.login_name as registerTel
FROM
t_supplier_info t
LEFT JOIN t_station s ON t.station_id = s.id
LEFT JOIN t_supplier_type st ON t.type_id = st.id
+ LEFT JOIN t_user us ON t.user_id = us.id and us.type='supplier'
WHERE t.deleted = 0
<if test="dto.name!=null and dto.name!=''">
AND t.name LIKE CONCAT('%',#{dto.name}, '%')
--
Gitblit v1.9.3