package com.kmall.admin.dao.statistics;

import com.kmall.admin.entity.MonthlySalesGrowthEntity;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author zhangchuangbiao
 * @version 1.0
 * 2020-09-01 16:16
 */
public interface MonthlyCustomersDao {

    List<MonthlySalesGrowthEntity> queryMonthlyCustomers(@Param("startMonth") String startMonth, @Param("endMonth") String endMonth, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> top10ForProduct(@Param("month") String month, @Param("week") String week, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> top10ByBrand(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> top10BySupplier(@Param("startDate")String startDate, @Param("endDate") String endDate, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> queryWeeklyCustomers(@Param("startWeek") String startWeek, @Param("endWeek") String endWeek, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> salesByCategory(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> monthlyCategory(@Param("startMonth") String startMonth, @Param("endMonth") String endMonth, @Param("merchSn") String merchSn);

    List<MonthlySalesGrowthEntity> queryAvgSales(@Param("startMonth") String startMonth, @Param("endMonth") String endMonth,
                                                 @Param("merchSn") String merchSn,
                                                 @Param("size") int size, @Param("monthNumber") Integer monthNumber);

}