From c83b580b0f51a2cdf16f2b1537aa3cb113ef112f Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期五, 20 十二月 2024 17:56:10 +0800
Subject: [PATCH] add: 花材销售统计商品分类
---
src/main/java/com/mzl/flower/dto/response/statisticAnalysis/FlowerSaleVO.java | 3 +++
src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml | 2 ++
2 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/statisticAnalysis/FlowerSaleVO.java b/src/main/java/com/mzl/flower/dto/response/statisticAnalysis/FlowerSaleVO.java
index be2bb17..7617f2f 100644
--- a/src/main/java/com/mzl/flower/dto/response/statisticAnalysis/FlowerSaleVO.java
+++ b/src/main/java/com/mzl/flower/dto/response/statisticAnalysis/FlowerSaleVO.java
@@ -32,6 +32,9 @@
@ApiModelProperty(value = "品类")
private String flowerCategory;
+ @ApiModelProperty(value = "品类名称")
+ private String flowerCategoryName;
+
@ApiModelProperty(value = "商品名称")
private String flowerName;
diff --git a/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml b/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
index 757a74a..35cbbcd 100644
--- a/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
+++ b/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
@@ -31,6 +31,7 @@
o.id orderId,
o.order_no,
o.payment_time,
+ c.parent_name flowerCategoryName,
CONCAT(o.customer_province, ' ', o.customer_city, ' ', o.customer_region, ' ', o.customer_address) AS address,
COALESCE((SELECT oic.num FROM t_order_item_check oic WHERE oic.order_item_id = oi.id AND oic.type = 'replace'),
0) replaceNum,
@@ -44,6 +45,7 @@
LEFT JOIN t_supplier_info si ON si.id = oi.supplier_id
LEFT JOIN t_order o ON oi.order_id = o.id
LEFT JOIN t_flower f on oi.flower_id = f.id
+ LEFT JOIN t_flower_category c on c.id = f.category
<include refid="flowerSaleWhere"></include>
</sql>
--
Gitblit v1.9.3