GuestInfoController.java
8.4 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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
package com.skua.modules.guest.controller;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
import com.skua.core.api.vo.Result;
import com.skua.core.aspect.annotation.AutoLog;
import com.skua.modules.guest.dto.GuestInfoDTO;
import com.skua.modules.guest.entity.GuestInfo;
import com.skua.modules.guest.service.IGuestInfoService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.modules.guest.util.DateUtil;
import com.skua.modules.guest.vo.GuestInfoVO;
import com.skua.modules.guest.vo.StatisticsByChartsVO;
import com.skua.modules.guest.vo.StatisticsByTimeVO;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
/**
* 来访人员信息
*/
@Slf4j
@Api(tags = "来访人员信息")
@RestController
@RequestMapping("/guest/guestInfo")
public class GuestInfoController {
@Autowired
private IGuestInfoService guestInfoService;
@AutoLog(value = "来访人员信息-分页列表查询")
@ApiOperation(value = "来访人员信息-分页列表查询", notes = "来访人员信息-分页列表查询")
@PostMapping(value = "/list")
public Result<IPage<GuestInfo>> queryPageList(@RequestBody GuestInfoDTO guestInfoDTO) {
Result<IPage<GuestInfo>> result = new Result<>();
try {
QueryWrapper<GuestInfo> queryWrapper = new QueryWrapper<>();
Date startTime = DateUtil.strToDate(guestInfoDTO.getStartTime() + " 00:00:00", "yyyy-MM-dd HH:mm:ss");
Date endTime = DateUtil.strToDate(guestInfoDTO.getEndTime() + " 23:59:59", "yyyy-MM-dd HH:mm:ss");
if (!StringUtils.isEmpty(guestInfoDTO.getGuestName())) {
queryWrapper.lambda().like(GuestInfo::getGuestName, guestInfoDTO.getGuestName());
}
queryWrapper.lambda().ge(GuestInfo::getCreateTime, startTime).le(GuestInfo::getCreateTime, endTime);
queryWrapper.orderByDesc("create_time");
Page<GuestInfo> page = new Page<>(guestInfoDTO.getPageNo(), guestInfoDTO.getPageSize());
IPage<GuestInfo> pageList = guestInfoService.page(page, queryWrapper);
result.setSuccess(true);
result.setResult(pageList);
} catch (Exception e) {
log.error("查询访客信息失败: {}", e.getMessage());
result.setCode(500);
result.setMessage("查询访客信息失败: " + e.getMessage());
}
return result;
}
/**
* 添加
*
* @param guestInfo
* @return
*/
@AutoLog(value = "来访人员信息-添加")
@ApiOperation(value = "来访人员信息-添加", notes = "来访人员信息-添加")
@PostMapping(value = "/add")
public Result<GuestInfo> add(@RequestBody GuestInfo guestInfo) {
Result<GuestInfo> result = new Result<>();
try {
boolean flag = guestInfoService.save(guestInfo);
if (flag) {
result.success("添加成功!");
result.setResult(guestInfo);
} else {
result.error500("操作失败");
}
} catch (Exception e) {
log.error(e.getMessage(), e);
result.error500("操作失败");
}
return result;
}
/**
* 编辑
*
* @param guestInfo
* @return
*/
@AutoLog(value = "来访人员信息-编辑")
@ApiOperation(value = "来访人员信息-编辑", notes = "来访人员信息-编辑")
@PutMapping(value = "/edit")
public Result<GuestInfo> edit(@RequestBody GuestInfo guestInfo) {
Result<GuestInfo> result = new Result<>();
GuestInfo guestInfoEntity = guestInfoService.getById(guestInfo.getId());
if (guestInfoEntity == null) {
result.error500("未找到对应实体");
} else {
boolean ok = guestInfoService.updateById(guestInfo);
//TODO 返回false说明什么?
if (ok) {
result.success("修改成功!");
}
}
return result;
}
/**
* 通过id删除
*
* @param id
* @return
*/
@AutoLog(value = "来访人员信息-通过id删除")
@ApiOperation(value = "来访人员信息-通过id删除", notes = "来访人员信息-通过id删除")
@DeleteMapping(value = "/delete")
public Result<?> delete(@RequestParam(name = "id", required = true) String id) {
try {
guestInfoService.removeById(id);
} catch (Exception e) {
log.error("删除失败: {}", e.getMessage());
return Result.error("删除失败!");
}
return Result.ok("删除成功!");
}
/**
* 批量删除
*
* @param ids
* @return
*/
@AutoLog(value = "来访人员信息-批量删除")
@ApiOperation(value = "来访人员信息-批量删除", notes = "来访人员信息-批量删除")
@DeleteMapping(value = "/deleteBatch")
public Result<GuestInfo> deleteBatch(@RequestParam(name = "ids", required = true) String ids) {
Result<GuestInfo> result = new Result<>();
if (ids == null || "".equals(ids.trim())) {
result.error500("参数不识别!");
} else {
this.guestInfoService.removeByIds(Arrays.asList(ids.split(",")));
result.success("删除成功!");
}
return result;
}
/**
* 通过id查询
*
* @param id
* @return
*/
@AutoLog(value = "来访人员信息-通过id查询")
@ApiOperation(value = "来访人员信息-通过id查询", notes = "来访人员信息-通过id查询")
@GetMapping(value = "/queryById")
public Result<GuestInfo> queryById(@RequestParam(name = "id", required = true) String id) {
Result<GuestInfo> result = new Result<>();
GuestInfo guestInfo = guestInfoService.getById(id);
if (guestInfo == null) {
result.error500("未找到对应实体");
} else {
result.setResult(guestInfo);
result.setSuccess(true);
}
return result;
}
/**
* 通过手机号查询
*
* @param mobilePhone
* @return
*/
@AutoLog(value = "来访人员信息-通过mobilePhone查询")
@ApiOperation(value = "来访人员信息-通过mobilePhone查询", notes = "来访人员信息-通过mobilePhone查询")
@GetMapping(value = "/queryByPhone")
public Result<GuestInfo> queryByPhone(@RequestParam(name = "mobilePhone") String mobilePhone) {
Result<GuestInfo> result = new Result<>();
QueryWrapper<GuestInfo> queryWrapper = new QueryWrapper<>();
queryWrapper.lambda().eq(GuestInfo::getMobilePhone, mobilePhone);
queryWrapper.orderByDesc("create_time");
List<GuestInfo> guestInfoList = guestInfoService.list(queryWrapper);
if (guestInfoList == null || guestInfoList.isEmpty()) {
result.setResult(null);
result.setSuccess(true);
} else {
result.setResult(guestInfoList.get(0));
result.setSuccess(true);
}
return result;
}
@AutoLog(value = "来访人员信息-统计历史信息")
@ApiOperation(value = "来访人员信息-统计历史信息", notes = "来访人员信息-统计历史信息")
@GetMapping(value = "/statistics")
public Result<GuestInfoVO> statisticsGuestInfoCtrl() {
Result<GuestInfoVO> result = new Result<>();
GuestInfoVO guestInfoVO = new GuestInfoVO();
try {
// 统计 今日、本周、本月、累计
StatisticsByTimeVO statisticsByTimeVO = guestInfoService.statisticsByTime();
guestInfoVO.setStatisticsByTimeVO(statisticsByTimeVO);
// echarts 本周、本月、全年
StatisticsByChartsVO statisticsByChartsVO = guestInfoService.statisticsByCharts();
guestInfoVO.setStatisticsByChartsVO(statisticsByChartsVO);
result.setResult(guestInfoVO);
} catch (Exception e) {
log.error("统计来访人员信息异常: {}", e.getMessage());
result.error500("统计来访人员信息异常: " + e.getMessage());
}
return result;
}
}