From 508f3e225df87e0da974424981e7782fc5ce875c Mon Sep 17 00:00:00 2001
From: xuhy <3313886187@qq.com>
Date: 星期一, 19 五月 2025 14:21:39 +0800
Subject: [PATCH] 修改
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java | 105 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 105 insertions(+), 0 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 00561bb..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
@@ -1,7 +1,18 @@
package com.ruoyi.system.mapper;
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;
+import org.apache.ibatis.annotations.Param;
+
+import java.math.BigDecimal;
+import java.util.List;
+import java.util.Map;
/**
* <p>
@@ -11,6 +22,100 @@
* @author xiaochen
* @since 2024-08-14
*/
+@Mapper
public interface TOrderSaleMapper extends BaseMapper<TOrderSale> {
+ /**
+ * 查询销售分页列表
+ * @param query
+ * @param pageInfo
+ * @return
+ */
+ List<TOrderSaleVO> pageList(@Param("query") TOrderSaleQuery query, @Param("pageInfo")PageInfo<TOrderSaleVO> pageInfo);
+
+ /**
+ * 查询销售金额统计
+ * @param query
+ * @return
+ */
+ AmountSumVO amountSum(@Param("query") TOrderSaleQuery query);
+
+ /**
+ * 查询销售销售量统计
+ * @param query
+ * @return
+ */
+ SalesVolumeVO salesVolume(@Param("query")TDataStatisticsQuery query);
+
+ /**
+ * 导出
+ * @param query
+ * @return
+ */
+ List<TOrderSaleVO> exportOrderSale(@Param("query")TOrderMealQuery query);
+
+ /**
+ * 查询销售订单趋势
+ * @param query
+ * @return
+ */
+ List<OrderTrendsVO> orderingTrends(@Param("query")TDataStatisticsQuery query);
+
+ /**
+ * 查询生成销售数据详情统计
+ * @param query
+ * @return
+ */
+ Map<String, Double> getDataGeneratorSaleDetail(@Param("query")TDataGeneratorSaleQuery query);
+
+ /**
+ * 销售生成数据详情导出
+ * @param query
+ * @return
+ */
+ List<TOrderSaleVO> saleGeneratorExport(@Param("query")TDataGeneratorSaleQuery query);
+
+ /**
+ * 销售生成数据详情导出
+ * @param query
+ * @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