From add54dd13a9a63cb5d51e3285418186752b56392 Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期四, 05 六月 2025 14:35:23 +0800
Subject: [PATCH] 首页统计导出修改
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java | 41 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 40 insertions(+), 1 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java
index 09630e0..047397c 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java
@@ -3,6 +3,8 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.TOrderSale;
+import com.ruoyi.system.export.SumGeneratorClient;
+import com.ruoyi.system.export.SumGeneratorDetailClient;
import com.ruoyi.system.query.*;
import com.ruoyi.system.vo.*;
import org.apache.ibatis.annotations.Mapper;
@@ -36,7 +38,7 @@
* @param query
* @return
*/
- AmountSumVO amountSum(@Param("query") TOrderMealQuery query);
+ AmountSumVO amountSum(@Param("query") TOrderSaleQuery query);
/**
* 查询销售销售量统计
@@ -79,4 +81,41 @@
* @return
*/
List<TDataGeneratorVO> saleGeneratorListExport(@Param("query")TDataGeneratorQuery query);
+
+ /**
+ * 销售利润详情列表
+ * @param query
+ * @param pageInfo
+ * @return
+ */
+ List<GoodsProfitVO> profitDetails(@Param("query")ProfitDetailsQuery query, @Param("pageInfo")PageInfo<GoodsProfitVO> pageInfo);
+
+ /**
+ * 查询利润详情统计
+ * @param query
+ * @return
+ */
+ Map<String, Double> profitDetailsStatistics(@Param("query")ProfitDetailsQuery query);
+
+ /**
+ * 导出
+ * @param query
+ * @return
+ */
+ List<GoodsProfitVO> profitDetailsExport(@Param("query")ProfitDetailsQuery query);
+
+ /**
+ * 删除
+ * @param shopId
+ */
+ void deleteByShopId(@Param("shopId")Long shopId);
+
+ Map<String, Double> getDataGeneratorSaleDetailOrderMoney(@Param("query")TDataGeneratorSaleQuery query);
+
+ /**
+ * 导出汇总
+ * @param query
+ * @return
+ */
+ List<SumGeneratorDetailClient> sumExport(@Param("query") ProfitDetailsQuery query);
}
--
Gitblit v1.7.1