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.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>
|
* 销售订单 Mapper 接口
|
* </p>
|
*
|
* @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);
|
|
}
|
