TdCBusinessAcctSourceDaoImpl.java
5.41 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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
package com.zteits.business.dao.impl;
import org.apache.commons.collections4.CollectionUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.business.domain.TdCBusinessAcct;
import com.zteits.business.domain.TdCBusinessAcctExample;
import com.zteits.business.domain.TdCBusinessAcctSource;
import com.zteits.business.domain.TdCBusinessAcctSourceExample;
import com.zteits.business.mapper.smapper.TdCBusinessAcctSourceSMapper;
import com.zteits.clouds.api.dto.business.dto.BusinessAcctSourceRechargeStaticDTO;
import com.zteits.clouds.api.dto.business.param.TdCBusinessAcctSourceRequest;
import com.zteits.business.dao.TdCBusinessAcctSourceDao;
import com.zteits.business.mapper.TdCBusinessAcctSourceMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import org.springframework.util.StringUtils;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@Component
public class TdCBusinessAcctSourceDaoImpl implements TdCBusinessAcctSourceDao {
@Autowired
private TdCBusinessAcctSourceMapper tdCBusinessAcctSourceMapper;
@Autowired
private TdCBusinessAcctSourceSMapper tdCBusinessAcctSourceSMapper;
@Override
public int saveTdCBusinessAcctSource(TdCBusinessAcctSource tdCBusinessAcctSource) {
if(tdCBusinessAcctSource.getCreateDate()==null){
tdCBusinessAcctSource.setCreateDate(new Date());
}
return tdCBusinessAcctSourceMapper.insertSelective(tdCBusinessAcctSource);
}
@Override
public int updateByExampleSelective(TdCBusinessAcctSource record, TdCBusinessAcctSourceExample example) {
return tdCBusinessAcctSourceMapper.updateByExampleSelective(record,example);
}
@Override
public int updateByPrimaryKeySelective(TdCBusinessAcctSource record) {
return tdCBusinessAcctSourceMapper.updateByPrimaryKeySelective(record);
}
@Override
public List<TdCBusinessAcctSource> selectByExample(TdCBusinessAcctSourceExample example) {
return tdCBusinessAcctSourceMapper.selectByExample(example);
}
@Override
public TdCBusinessAcctSource queryByPrimaryKey(Long id) {
return tdCBusinessAcctSourceMapper.selectByPrimaryKey(id);
}
@Override
public List<TdCBusinessAcctSource> queryTdCBusinessAcctSource(TdCBusinessAcctSourceRequest request) {
TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
TdCBusinessAcctSourceExample.Criteria sql = example.createCriteria();
if(!StringUtils.isEmpty(request.getBusinessId())){
sql.andBusinessIdEqualTo(request.getBusinessId());
}
if(!StringUtils.isEmpty(request.getSourceBillId())){
sql.andSourceBillIdEqualTo(request.getSourceBillId());
}
List<TdCBusinessAcctSource> list = tdCBusinessAcctSourceMapper.selectByExample(example);
return list;
}
@Override
public int batchDeleteTdCBusinessAcctSourceByPrimaryKey(List<Long> ids, String opId, String opName) {
TdCBusinessAcctSource record = new TdCBusinessAcctSource();
record.setDataState(DataStatusEnum.DATA_STATUS_NO_VALID.value());
TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
example.createCriteria().andIdIn(ids);
return tdCBusinessAcctSourceMapper.updateByExampleSelective(record,example);
}
@Override
public PageInfo<TdCBusinessAcctSource> queryTdCBusinessAcctSourceForPage(TdCBusinessAcctSourceRequest request) {
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
TdCBusinessAcctSourceExample example = new TdCBusinessAcctSourceExample();
TdCBusinessAcctSourceExample.Criteria sql = example.createCriteria();
if(!StringUtils.isEmpty(request.getBusinessId())){
sql.andBusinessIdEqualTo(request.getBusinessId());
}
if(!StringUtils.isEmpty(request.getBeginDate())){
sql.andRechargeTimeGreaterThan(request.getBeginDate());
}
if(!StringUtils.isEmpty(request.getEndDate())){
sql.andRechargeTimeLessThan(request.getEndDate());
}
if(!StringUtils.isEmpty(request.getBusinessName())){
sql.andBusinessNameLike("%"+request.getBusinessName()+"%");
}
if(!StringUtils.isEmpty(request.getUserPhone())){
sql.andUserPhoneLike("%"+request.getUserPhone()+"%");
}
if(!StringUtils.isEmpty(request.getExamineState())){
sql.andExamineStateEqualTo(request.getExamineState());
}
if(!StringUtils.isEmpty(request.getRechargeType())){
sql.andRechargeTypeEqualTo(request.getRechargeType());
}
sql.andDataStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
example.setOrderByClause("id desc");
List<TdCBusinessAcctSource> list = tdCBusinessAcctSourceMapper.selectByExample(example);
if (CollectionUtils.isNotEmpty(list)) {
return new PageInfo<TdCBusinessAcctSource>(list);
}
return new PageInfo<TdCBusinessAcctSource>(new ArrayList<TdCBusinessAcctSource>());
}
@Override
public BusinessAcctSourceRechargeStaticDTO queryBusinessRechargeFeeStatic(TdCBusinessAcctSourceRequest request) {
return tdCBusinessAcctSourceSMapper.queryBusinessRechargeFeeStatic(request);
}
}