ChargerIncomeDiffDaoImpl.java
5.56 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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
package com.zteits.park.dao.impl;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.commons.collections4.CollectionUtils;
import com.clouds.common.constants.pagequery.PageSizeEnum;
import com.clouds.common.utils.page.PageUtil;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import com.zteits.clouds.api.dto.park.dto.ChargerIncomeDiffSummaryDTO;
import com.zteits.clouds.api.dto.park.param.ChargerIncomeDiffRequest;
import com.zteits.park.dao.ChargerIncomeDiffDao;
import com.zteits.park.domain.ChargerIncomeDiff;
import com.zteits.park.domain.ChargerIncomeDiffExample;
import com.zteits.park.domain.ChargerIncomeDiffExample.Criteria;
import com.zteits.park.mapper.ChargerIncomeDiffMapper;
import com.zteits.park.mapper.smapper.ChargerIncomeDiffSMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
@Component
public class ChargerIncomeDiffDaoImpl implements ChargerIncomeDiffDao {
@Autowired
private ChargerIncomeDiffMapper chargerIncomeDiffMapper;
@Autowired
private ChargerIncomeDiffSMapper chargerIncomeDiffSMapper;
@Override
public int deleteChargerIncomeDiffByPrimaryKey(Long id, String opId, String opName) {
ChargerIncomeDiff record = new ChargerIncomeDiff();
record.setId(id);
record.setModifyOp(opId);
record.setModifyTime(new Date());
return chargerIncomeDiffMapper.updateByPrimaryKeySelective(record);
}
@Override
public int saveChargerIncomeDiff(ChargerIncomeDiff chargerIncomeDiff) {
if (chargerIncomeDiff.getCreateTime() == null) {
chargerIncomeDiff.setCreateTime(new Date());
}
if (chargerIncomeDiff.getModifyTime() == null) {
chargerIncomeDiff.setModifyTime(new Date());
}
return chargerIncomeDiffMapper.insertSelective(chargerIncomeDiff);
}
@Override
public int updateByExampleSelective(ChargerIncomeDiff record, ChargerIncomeDiffExample example) {
return chargerIncomeDiffMapper.updateByExampleSelective(record, example);
}
@Override
public int updateByPrimaryKeySelective(ChargerIncomeDiff record) {
return chargerIncomeDiffMapper.updateByPrimaryKeySelective(record);
}
@Override
public List<ChargerIncomeDiff> selectByExample(ChargerIncomeDiffExample example) {
return chargerIncomeDiffMapper.selectByExample(example);
}
@Override
public ChargerIncomeDiff queryByPrimaryKey(Long id) {
return chargerIncomeDiffMapper.selectByPrimaryKey(id);
}
@Override
public List<ChargerIncomeDiff> queryChargerIncomeDiff(ChargerIncomeDiffRequest request) {
ChargerIncomeDiffExample example = new ChargerIncomeDiffExample();
Criteria sql = example.createCriteria();
sql.andDataStatusEqualTo(DataStatusEnum.DATA_STATUS_VALID.value()).andPlNoIn(request.getPlNos())
.andStaticDateBetween(request.getStartDate(), request.getEndDate());
if (CollectionUtils.isNotEmpty(request.getBerthRangeNos())) {
sql.andBerthRangeNoIn(request.getBerthRangeNos());
}
if (null != request.getChargerCode()) {
sql.andChargerCodeEqualTo(request.getChargerCode());
}
return chargerIncomeDiffMapper.selectByExample(example);
}
@Override
public int batchDeleteChargerIncomeDiffByPrimaryKey(List<Long> ids, String opId, String opName) {
ChargerIncomeDiff record = new ChargerIncomeDiff();
record.setCreateOp(opId);
record.setCreateTime(new Date());
record.setModifyOp(opId);
record.setModifyTime(new Date());
//where条件
ChargerIncomeDiffExample example = new ChargerIncomeDiffExample();
example.createCriteria().andIdIn(ids);
return chargerIncomeDiffMapper.updateByExampleSelective(record, example);
}
@Override
public Integer deleteChargerIncomeDiffByDate(Date startDate, Date endDate) {
ChargerIncomeDiffExample example = new ChargerIncomeDiffExample();
example.createCriteria().andStaticDateBetween(startDate, endDate);
return chargerIncomeDiffMapper.deleteByExample(example);
}
@Override
public ChargerIncomeDiffSummaryDTO queryChargerIncomeDiffForSummary(ChargerIncomeDiffRequest requert) {
return chargerIncomeDiffSMapper.queryChargerIncomeDiffForSummary(requert);
}
@Override
public PageInfo<ChargerIncomeDiff> queryChargerIncomeDiffForPage(ChargerIncomeDiffRequest request) {
//校验分页size
PageUtil.pageSizeValidate(PageSizeEnum.PAGE_SIZE_BASE, request);
ChargerIncomeDiffExample example = new ChargerIncomeDiffExample();
Criteria sql = example.createCriteria();
sql.andDataStatusEqualTo(DataStatusEnum.DATA_STATUS_VALID.value()).andPlNoIn(request.getPlNos())
.andStaticDateBetween(request.getStartDate(), request.getEndDate());
if (CollectionUtils.isNotEmpty(request.getBerthRangeNos())) {
sql.andBerthRangeNoIn(request.getBerthRangeNos());
}
if (null != request.getChargerCode()) {
sql.andChargerCodeEqualTo(request.getChargerCode());
}
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
List<ChargerIncomeDiff> list = chargerIncomeDiffMapper.selectByExample(example);
if (null != list) {
return new PageInfo<>(list);
}
return new PageInfo<>(new ArrayList<>());
}
}