package com.nova.sankuai.infra.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.nova.sankuai.domain.dto.CustomerPageDto;
import com.nova.sankuai.domain.entity.Customer;
import com.nova.sankuai.domain.vo.InletFlowProportionVo;
import com.nova.sankuai.domain.vo.customer.CustomerCountVo;
import com.nova.sankuai.domain.vo.customer.CustomerVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.List;

/**
 * @author weikangdi
 */
@Component
@Mapper
public interface CustomerMapper extends BaseMapper<Customer> {
    /**
     * 分页查询客户信息
     *
     * @param page
     * @param customerPageDto
     * @return
     */
    IPage<CustomerVo> pageModel(@Param("page") Page page, @Param("customerPageDto") CustomerPageDto customerPageDto);

    /**
     * 批量根据机构ID列表查询当天内客户数据
     *
     * @param endOfDay
     * @param beginOfDay
     * @param list
     * @return
     */
    List<CustomerCountVo> getCustomersOfDay(@Param("list") List<Long> list, @Param("beginOfDay") Date beginOfDay, @Param("endOfDay") Date endOfDay);

    /**
     * 批量获取机构的客户历史推送数量
     *
     * @param ids
     * @return
     */
    List<CustomerCountVo> getCustomerCounts(@Param("ids") List<Long> ids);

    /**
     * 获取机构的客户推送数量
     *
     * @param id
     * @param beginOfDay
     * @param endOfDay
     * @return
     */
    CustomerCountVo getCustomerCount(@Param("id") Long id, @Param("beginOfDay") Date beginOfDay, @Param("endOfDay") Date endOfDay);

    /**
     * 获取用户有效记录
     *
     * @param phone
     * @return
     */
    List<Customer> getUserRecord(@Param("phone") String phone);

    /**
     * 获取最近一条客户记录（名字不为空）
     *
     * @param phone
     * @return
     */
    Customer getLatestCustomerRecord(@Param("phone") String phone);


    /**
     * 查询渠道占比
     * @param startDate
     * @param endDate
     * @param chCode
     * @param startDayStr
     * @param endDayStr
     * @param hourStr
     * @return
     */
    List<InletFlowProportionVo> getInletFlowProportion(@Param("startDate") Date startDate,@Param("endDate") Date endDate,
                                                   @Param("chCode") Integer chCode,
                                                   @Param("startDayStr") String startDayStr,
                                                   @Param("endDayStr") String endDayStr,
                                                   @Param("hourStr") String[] hourStr);

}