TdCCustSuggestDaoImpl.java
2.96 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
package com.zteits.pay.dao.impl;
import java.util.List;
import org.apache.commons.lang3.StringUtils;
import com.zteits.clouds.api.apibase.bean.BizResult;
import com.zteits.clouds.api.dto.owner.dto.TdCCustSuggestDTO;
import com.zteits.clouds.api.dto.pay.param.QueryTdCCustSuggestRequest;
import com.zteits.pay.mapper.smapper.TdCCustSuggestSMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import com.zteits.clouds.api.dto.owner.param.CustSuggestRequest;
import com.zteits.pay.dao.TdCCustSuggestDao;
import com.zteits.pay.domain.TdCCustSuggest;
import com.zteits.pay.domain.TdCCustSuggestExample;
import com.zteits.pay.domain.TdCCustSuggestExample.Criteria;
import com.zteits.pay.mapper.TdCCustSuggestMapper;
@Component
public class TdCCustSuggestDaoImpl implements TdCCustSuggestDao {
@Autowired
private TdCCustSuggestMapper tdCCustSuggestMapper;
@Autowired
private TdCCustSuggestSMapper tdCCustSuggestSMapper;
@Override
public Integer insertTdCCustSuggest(TdCCustSuggest record) {
return tdCCustSuggestMapper.insertSelective(record);
}
@Override
public PageInfo<TdCCustSuggest> queryFeedbackAndSuggestForPage(CustSuggestRequest request) {
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
TdCCustSuggestExample example = new TdCCustSuggestExample();
Criteria sql = example.createCriteria();
sql.andStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
if(StringUtils.isNotEmpty(request.getCustId())) {
sql.andCustIdEqualTo(request.getCustId());
}
if(request.getFeedbackCode() != null){
sql.andFeedbackCodeEqualTo(request.getFeedbackCode());
}
if(request.getIsAnswer() != null){
sql.andIsAnswerEqualTo(request.getIsAnswer());
}
if(StringUtils.isNotEmpty(request.getUserPhone())){
sql.andUserPhoneEqualTo(request.getUserPhone());
}
if(request.getOrgId() != null){
sql.andOrgIdEqualTo(request.getOrgId());
}
example.setOrderByClause("create_date desc");
List<TdCCustSuggest> list = tdCCustSuggestMapper.selectByExample(example);
return new PageInfo<>(list);
}
@Override
public List<TdCCustSuggestDTO> queryTdCCustSuggestForAPP(QueryTdCCustSuggestRequest suggestRequest) {
List<TdCCustSuggestDTO> list = tdCCustSuggestSMapper.queryTdCCustSuggestForAPP(suggestRequest);
return list;
}
@Override
public TdCCustSuggest queryTdCCustSuggestByIdForAPP(QueryTdCCustSuggestRequest suggestRequest) {
return tdCCustSuggestMapper.selectByPrimaryKey(Long.parseLong(suggestRequest.getSuggestId()));
}
@Override
public int updateSuggestIsAnswer(TdCCustSuggest tdCCustSuggest) {
return tdCCustSuggestMapper.updateByPrimaryKeySelective(tdCCustSuggest);
}
public TdCCustSuggest getTdCCustSuggestById(String id){
return tdCCustSuggestMapper.selectByPrimaryKey(Long.parseLong(id));
}
}