package com.zteits.bill.mapper;

import com.zteits.bill.domain.TVipAreaCardCustInfo;
import com.zteits.bill.domain.TVipAreaCardCustInfoExample;

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

import com.zteits.clouds.api.dto.bill.vipcard.param.VipAreaCardExpireRequest;
import com.zteits.clouds.api.dto.bill.vipcard.param.VipCardInfoReq;
import org.apache.ibatis.annotations.Param;

public interface TVipAreaCardCustInfoMapper {
    long countByExample(TVipAreaCardCustInfoExample example);

    int deleteByExample(TVipAreaCardCustInfoExample example);

    int deleteByPrimaryKey(Long id);

    int insert(TVipAreaCardCustInfo record);

    int insertSelective(TVipAreaCardCustInfo record);

    List<TVipAreaCardCustInfo> selectByExample(TVipAreaCardCustInfoExample example);

    TVipAreaCardCustInfo selectByPrimaryKey(Long id);

    int updateByExampleSelective(@Param("record") TVipAreaCardCustInfo record, @Param("example") TVipAreaCardCustInfoExample example);

    int updateByExample(@Param("record") TVipAreaCardCustInfo record, @Param("example") TVipAreaCardCustInfoExample example);

    int updateByPrimaryKeySelective(TVipAreaCardCustInfo record);

    int updateByPrimaryKey(TVipAreaCardCustInfo record);

    /**
     * 根据停车场编号与车牌号码查询当前有效的会员车信息
     * @param request
     * @author: zengqc
     * @return
     */
    TVipAreaCardCustInfo queryCardCustInfoByParkcodeAndCarnumber(VipCardInfoReq request);

    /**
     * 到期即将到期会员卡信息查询
     * @param beginTime
     * @param endTime
     * @return
     */
    List<TVipAreaCardCustInfo> queryVipCardCustInfoByExpDate(@Param("beginTime")  Date beginTime ,@Param("endTime")  Date endTime);

    /**
     * 据停车场编号与车牌号码查询该车所有有效的会员卡记录,包括已过期数据
     *
     * @Author: zegnqc
     */
    List<TVipAreaCardCustInfo> queryAllAreaVipCardByParkcodeAndCarnumber(VipCardInfoReq request);
}