From 227a7460ec73dede14cf16f91e9a4f89f98acd4e Mon Sep 17 00:00:00 2001
From: cloudroam <cloudroam>
Date: 星期三, 25 十二月 2024 10:11:20 +0800
Subject: [PATCH] add: 花材销售统计商品分类
---
src/main/java/com/mzl/flower/dto/request/statisticAnalysis/FlowerSaleDTO.java | 9 +++++++--
src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml | 6 ++++++
2 files changed, 13 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/request/statisticAnalysis/FlowerSaleDTO.java b/src/main/java/com/mzl/flower/dto/request/statisticAnalysis/FlowerSaleDTO.java
index 18ea733..7d97957 100644
--- a/src/main/java/com/mzl/flower/dto/request/statisticAnalysis/FlowerSaleDTO.java
+++ b/src/main/java/com/mzl/flower/dto/request/statisticAnalysis/FlowerSaleDTO.java
@@ -66,9 +66,14 @@
@ApiModelProperty(value = "创建时间-结束；yyyy-MM-dd")
private String createEndDateStr;
- @ApiModelProperty(hidden = true)
+
private LocalDateTime createStartDate;
- @ApiModelProperty(hidden = true)
+
private LocalDateTime createEndDate;
+
+ @ApiModelProperty(value = "排序字段")
+ private String orderField;
+ @ApiModelProperty(value = "排序类型，ASC 升序，DESC 降序")
+ private String orderType;
}
diff --git a/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml b/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
index 35cbbcd..099e184 100644
--- a/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
+++ b/src/main/resources/mapper/statisticsAnalysis/SalesStatisticsAnalysisMapper.xml
@@ -62,6 +62,9 @@
<if test="dto.registerTel!=null and dto.registerTel!=''">
AND si.contact_tel LIKE CONCAT('%',#{dto.registerTel}, '%')
</if>
+ <if test="dto.contactTel!=null and dto.contactTel!=''">
+ AND si.contact_tel LIKE CONCAT('%',#{dto.contactTel}, '%')
+ </if>
<if test="dto.stationId != null">
AND oi.station_id = #{dto.stationId}
</if>
@@ -90,6 +93,9 @@
<if test="dto.createEndDate != null">
AND o.payment_time < #{dto.createEndDate}
</if>
+ <if test="dto.orderField !=null and dto.orderField !=''">
+ order by ${dto.orderField} ${dto.orderType}
+ </if>
</sql>
--
Gitblit v1.9.3