package com.yuanchu.mom.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.dto.DataComparisonDto;
import com.yuanchu.mom.dto.DataReportingPageDto;
import com.yuanchu.mom.dto.ProductCountDto;
import com.yuanchu.mom.dto.RegistrantCountDto;
import com.yuanchu.mom.pojo.DataReporting;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
* @author Administrator
* @description 针对表【data_reporting(数据上报)】的数据库操作Mapper
* @createDate 2023-12-23 10:39:43
* @Entity com.yuanchu.mom.pojo.DataReporting
*/
public interface DataReportingMapper extends BaseMapper<DataReporting> {

    IPage<DataReportingPageDto> selectDataReportingDtoPageList(IPage<DataReportingPageDto> page, QueryWrapper<DataReportingPageDto> ew);

    IPage<ProductCountDto> selectProductCountDtoPageList(IPage<ProductCountDto> page, QueryWrapper<ProductCountDto> ew);

    IPage<RegistrantCountDto> selectRegistrantCountDtoPageList(IPage<RegistrantCountDto> page, QueryWrapper<RegistrantCountDto> ew);

    Map<String, BigDecimal> getDataFor1();

    List<Map<String, String>> getDataFor2();

    List<Map<String, String>> getDataFor3();

    List<Map<String, String>> getDataFor4();

    List<Map<String, String>> getDataFor5();

    Map<String, String> selectUser(Integer userId);

    IPage<DataComparisonDto> selectDataComparisonDtoPageList(Page page, DataComparisonDto dataComparisonDto);

    List<String> selectDataReportingForCreateUserNames(String time);

    List<String> selectDataReportingForProduct(String time);
}