From 23f8e1fdb85aa9cef22ecff5b30e28cd3a06d09a Mon Sep 17 00:00:00 2001 From: xuhy <3313886187@qq.com> Date: 星期六, 30 十一月 2024 18:51:19 +0800 Subject: [PATCH] 生成数据明细导出修改 --- ruoyi-system/src/main/java/com/ruoyi/system/mapper/TOrderSaleMapper.java | 54 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 44 insertions(+), 10 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 675070b..c16e023 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,14 +3,9 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ruoyi.common.basic.PageInfo; import com.ruoyi.system.domain.TOrderSale; -import com.ruoyi.system.query.TDataGeneratorSaleQuery; -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.query.*; +import com.ruoyi.system.vo.*; +import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.math.BigDecimal; @@ -25,6 +20,7 @@ * @author xiaochen * @since 2024-08-14 */ +@Mapper public interface TOrderSaleMapper extends BaseMapper<TOrderSale> { /** @@ -40,7 +36,7 @@ * @param query * @return */ - AmountSumVO amountSum(@Param("query") TOrderMealQuery query); + AmountSumVO amountSum(@Param("query") TOrderSaleQuery query); /** * 查询销售销售量统计 @@ -68,7 +64,7 @@ * @param query * @return */ - Map<String, BigDecimal> getDataGeneratorMealDetail(@Param("query")TDataGeneratorSaleQuery query); + Map<String, Double> getDataGeneratorSaleDetail(@Param("query")TDataGeneratorSaleQuery query); /** * 销售生成数据详情导出 @@ -76,4 +72,42 @@ * @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); + } -- Gitblit v1.7.1