From 00df7f384ee12747096e1211133a304ccc10b3f6 Mon Sep 17 00:00:00 2001
From: 陶杰 <1378534974@qq.com>
Date: 星期三, 09 十月 2024 15:20:05 +0800
Subject: [PATCH] 1.商品评论-查询返回字段新增信息
---
src/main/resources/mapper/comment/FlowerCommentMapperCustom.xml | 10 +++++++++-
src/main/java/com/mzl/flower/dto/response/comment/FlowerCommentVO.java | 12 ++++++++++++
2 files changed, 21 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/comment/FlowerCommentVO.java b/src/main/java/com/mzl/flower/dto/response/comment/FlowerCommentVO.java
index 47d7adb..0952207 100644
--- a/src/main/java/com/mzl/flower/dto/response/comment/FlowerCommentVO.java
+++ b/src/main/java/com/mzl/flower/dto/response/comment/FlowerCommentVO.java
@@ -22,6 +22,18 @@
@ApiModelProperty(value = "商户头像")
private String customerCover;
+ @ApiModelProperty(value = "订单编号")
+ private String orderNo;
+
+ @ApiModelProperty(value = "供应商名称")
+ private String supplierName;
+ @ApiModelProperty(value = "供应商联系人名称")
+ private String supplierContactName;
+ @ApiModelProperty(value = "供应商联系电话")
+ private String supplierContactTel;
+
+
+
diff --git a/src/main/resources/mapper/comment/FlowerCommentMapperCustom.xml b/src/main/resources/mapper/comment/FlowerCommentMapperCustom.xml
index bb03787..177bdb0 100644
--- a/src/main/resources/mapper/comment/FlowerCommentMapperCustom.xml
+++ b/src/main/resources/mapper/comment/FlowerCommentMapperCustom.xml
@@ -24,12 +24,20 @@
oi.flower_level,
oi.flower_category,
ci.name as customer_name,
- ci.cover as customer_cover
+ ci.cover as customer_cover,
+ o.order_no,
+ sui.name as supplier_name,
+ sui.contact_name as supplier_contact_name,
+ sui.contact_tel as supplier_contact_tel
from t_flower_comment c
left join t_order_item oi
on c.order_item_id=oi.id
+ left join t_order o
+ on c.order_id=o.id
left join t_customer_info ci
on c.customer_id=ci.id
+ left join t_supplier_info sui
+ on c.supplier_id =sui.id
where c.deleted=false
<if test="param.id != null and param.id != ''">
and c.id = #{param.id}
--
Gitblit v1.9.3