package com.fdkankan.manage.mapper;

import com.fdkankan.manage.vo.response.DataGroupByCount;
import com.fdkankan.manage.vo.response.DataGroupBySum;
import com.fdkankan.manage.vo.response.OrderDataGroupByCount;
import com.fdkankan.manage.vo.response.SceneDataGroupByCount;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface IDataMapper {

    List<DataGroupByCount> userDataGroupBy(@Param("tb") String tb,@Param("dateFormat")String dateFormat,
                                           @Param("startTime")String startTime,@Param("endTime")String endTime);
    List<DataGroupBySum> userDataSumGroupBy(@Param("tb") String tb, @Param("dateFormat")String dateFormat,
                                            @Param("startTime")String startTime, @Param("endTime")String endTime);

    Long totalUserCount(@Param("tb") String tb,@Param("type")Integer type);

    Long preMonthAddCount(@Param("tb") String tb,@Param("type")Integer type);

    Long todayAddCount(@Param("tb") String tb,@Param("type")Integer type);

    Long todayActiveCount();

    List<DataGroupByCount> userDataGroupByWeek(@Param("tb") String tb, @Param("startTime")String startTime,@Param("endTime")String endTime);
    List<DataGroupBySum> userDataSumGroupByWeek(@Param("tb") String tb, @Param("startTime")String startTime,@Param("endTime")String endTime);

    List<DataGroupByCount> sceneGroupBy(@Param("tb") String tb, @Param("dateFormat")String dateFormat,
                                        @Param("startTime")String startTime,@Param("endTime")String endTime);

    List<DataGroupByCount> sceneGroupByWeek(@Param("tb") String tb,@Param("startTime")String startTime,@Param("endTime")String endTime);

    List<DataGroupByCount> sceneOutTimeGroupBy(@Param("tb") String tb, @Param("dateFormat")String dateFormat,
                                        @Param("startTime")String startTime,@Param("endTime")String endTime);

    List<DataGroupByCount> sceneOutTimeGroupByWeek(@Param("tb") String tb,@Param("startTime")String startTime,@Param("endTime")String endTime);

}