package com.zteits.bill.mapper.smapper;

import com.zteits.bill.domain.TVipAreaCardCustInfo;
import com.zteits.bill.domain.TVipNoPushCardCustInfoDO;
import com.zteits.clouds.api.dto.bill.dto.TVipAreaCardCustInfoDTO;
import com.zteits.clouds.api.dto.bill.param.TVipAreaCardCustInfoQueryRequest;
import com.zteits.clouds.api.dto.bill.param.TVipAreaCardCustInfoRequest;
import com.zteits.clouds.api.dto.bill.param.ValidVipAreaCardCustInfoRequest;
import com.zteits.clouds.api.dto.bill.vipcard.param.QueryIsBuyVipCardCustReq;
import com.zteits.clouds.api.dto.bill.vipcard.param.QueryVipCardOrderDetailTotalReq;
import com.zteits.clouds.api.dto.bill.vipcard.param.VipAreaCardExpireRequest;
import com.zteits.clouds.api.dto.order.vipcardorder.dto.OrderVipAreacardDetailTotalDTO;
import com.zteits.clouds.api.dto.order.vipcardorder.dto.ParkVipAreaCardNumDTO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TVipAreaCardCustInfoSMapper {


    List<TVipAreaCardCustInfoDTO> queryTVipAreaCardCustInfoForPage(TVipAreaCardCustInfoQueryRequest request);

    List<TVipAreaCardCustInfoDTO> queryVipAreaCardInfoByCarNumbers(TVipAreaCardCustInfoQueryRequest request);

    List<TVipAreaCardCustInfoDTO> queryVipAreaCardInfoByCarNumbersForApp(TVipAreaCardCustInfoQueryRequest request);

    List<TVipNoPushCardCustInfoDO> queryNoPustVipCardCustInfo(@Param("currentDate")String currentDate,@Param("id") Long id);

    List<TVipNoPushCardCustInfoDO> queryPustVipCardCustInfo(@Param("currentDate")String currentDate,@Param("id") Long id);

    /**
     * 查询是否购买区域卡
     * @param request
     * @return
     */
    Integer queryIsBuyVipCardCust(QueryIsBuyVipCardCustReq request);

    List<OrderVipAreacardDetailTotalDTO> queryVipAreaCardStatisticTotal(QueryVipCardOrderDetailTotalReq request);

    /**
     * 根据车场编码查询购买的区域卡（非失效）数量（车场编号-卡数量）
     * @param plNo
     * @return
     */
    ParkVipAreaCardNumDTO queryParkVipAreaCardNumByPlNo(@Param("plNo")String plNo,@Param("orgId") Long orgId);

    /**
     * 查询即将到期的区域卡
     * @param
     * @return
     * @Author: xiejianpeng
     * @Date: 2020/4/8 18:52
     *
     */
    List<TVipAreaCardCustInfo> queryExpireVipCardCustInfo(VipAreaCardExpireRequest vipPushRequest);




    /**********************************************时域卡*********************************/

    List<TVipAreaCardCustInfoDTO> queryTVipTimeCardCustInfoForPage(TVipAreaCardCustInfoQueryRequest request);

    List<TVipAreaCardCustInfoDTO> queryVipTimeCardInfoByCarNumbers(TVipAreaCardCustInfoQueryRequest request);

    List<TVipAreaCardCustInfoDTO> queryVipTimeCardInfoByCarNumbersForApp(TVipAreaCardCustInfoQueryRequest request);

    /**
     * 查询是否购买区域卡
     * @param request
     * @return
     */
    Integer queryIsBuyTimeVipCardCust(QueryIsBuyVipCardCustReq request);

    List<OrderVipAreacardDetailTotalDTO> queryVipTimeCardStatisticTotal(QueryVipCardOrderDetailTotalReq request);

    /**
     * 查询即将到期的时域卡
     * @param
     * @return
     * @Author: xiejianpeng
     * @Date: 2020/4/8 18:52
     *
     */
    List<TVipAreaCardCustInfo> queryExpireTimeVipCardCustInfo(VipAreaCardExpireRequest vipPushRequest);

    /**
     * 根据车牌号查询当月购买的时域卡总次数和总时长
     * @param request
     * @return
     */
    TVipAreaCardCustInfo queryTimeCardBuyTimesByCarNumber(ValidVipAreaCardCustInfoRequest request);

    /**
     * 查询全域卡的生效的购买记录
     * @param
     * @return
     * @Author: xiejianpeng
     * @Date: 2020/9/14 16:19
     */
    List<TVipAreaCardCustInfo> queryTVipAreaCardCustInfoListByAreaCardType(TVipAreaCardCustInfoRequest request);

    List<TVipAreaCardCustInfo> queryAllActiveInfo(TVipAreaCardCustInfoRequest request);
}