TVipAreaCardCustInfoSMapper.java
3.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
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);
}