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 | 75 +++++++++++++++++++++++++++++++++---- 1 files changed, 67 insertions(+), 8 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 99ff756..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,16 +3,16 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.common.basic.PageInfo; import com.ruoyi.system.domain.TOrderSale; -import com.ruoyi.system.query.TDataStatisticsQuery; -import com.ruoyi.system.query.TOrderMealQuery; -import com.ruoyi.system.query.TOrderSaleQuery; -import com.ruoyi.system.vo.AmountSumVO; -import com.ruoyi.system.vo.OrderTrendsVO; -import com.ruoyi.system.vo.SalesVolumeVO; -import com.ruoyi.system.vo.TOrderSaleVO; +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> @@ -22,6 +22,7 @@ * @author xiaochen * @since 2024-08-14 */ +@Mapper public interface TOrderSaleMapper extends BaseMapper<TOrderSale> { /** @@ -37,7 +38,7 @@ * @param query * @return */ - AmountSumVO amountSum(@Param("query") TOrderMealQuery query); + AmountSumVO amountSum(@Param("query") TOrderSaleQuery query); /** * 查询销售销售量统计 @@ -59,4 +60,62 @@ * @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