UsersServiceImpl.java
3.51 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
package com.cnlive.shenhe.service.serviceImpl;
import com.alibaba.fastjson.JSON;
import com.cnlive.shenhe.dto.UsersDTO;
import com.cnlive.shenhe.entity.ShyUsers;
import com.cnlive.shenhe.mapper.ShyUsersMapper;
import com.cnlive.shenhe.service.UsersService;
import com.cnlive.shenhe.utils.CommonUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.entity.Example;
import java.util.List;
/**
* @Auther: 周伟鹏
* @Date: 2018/11/29 14:23
* @Description:
*/
@Service
public class UsersServiceImpl implements UsersService {
private static Logger logger = LoggerFactory.getLogger(UsersServiceImpl.class);
@Autowired
ShyUsersMapper shyUsersMapper;
/**
* 用户分页列表
*
* @param usersDTO
* @return
*/
@Override
public PageInfo<ShyUsers> getPage(UsersDTO usersDTO) {
logger.info("接受参数列表为，UsersDTO:{}", JSON.toJSONString(usersDTO));
Example example = new Example(ShyUsers.class);
Example.Criteria criteria = example.createCriteria();
if (CommonUtils.isNotEmpty(usersDTO.getOrderByClause())) {
example.setOrderByClause(usersDTO.getOrderByClause());
} else {
example.setOrderByClause("created_at desc");
}
if (CommonUtils.isNotEmpty(usersDTO.getUsername())) {
criteria.andLike("username", "%" + usersDTO.getUsername() + "%");
}
if (CommonUtils.isNotEmpty(usersDTO.getMobile())) {
criteria.andLike("mobile", "%" + usersDTO.getMobile() + "%");
}
if (CommonUtils.isNotEmpty(usersDTO.getCompany_brief())) {
criteria.andLike("company_brief", "%" + usersDTO.getCompany_brief() + "%");
}
if (CommonUtils.isNotNull(usersDTO.getSp_id())) {
criteria.andEqualTo("sp_id", usersDTO.getSp_id());
}
PageHelper.startPage(usersDTO.getPage(), usersDTO.getPageSize(), true);
List<ShyUsers> shyUsersList = shyUsersMapper.selectByExample(example);
PageInfo<ShyUsers> pageInfo = new PageInfo<ShyUsers>(shyUsersList);
return pageInfo;
}
/**
* 根据spid查询名字
*
* @param shenAuditorId
* @return
*/
@Override
public String findSpIdByName(String shenAuditorId) {
Example example = new Example(ShyUsers.class);
Example.Criteria criteria = example.createCriteria();
criteria.andEqualTo("username", shenAuditorId);
List<ShyUsers> shyUsersList = shyUsersMapper.selectByExample(example);
if (CommonUtils.isNotNull(shyUsersList) && shyUsersList.size() > 0) {
ShyUsers shyUsers = shyUsersList.get(0);
return shyUsers.getUser_id();
}
return null;
}
/**
* 根据主键id查询用户对象
*
* @param id
* @return
*/
@Override
public ShyUsers get(Integer id) {
return shyUsersMapper.selectByPrimaryKey(id);
}
/**
* 根据对象查询
*
* @param shyUsers
* @return
*/
@Override
public ShyUsers select(ShyUsers shyUsers) {
return shyUsersMapper.selectOne(shyUsers);
}
/**
* 修改用户
*
* @param shyUsers
* @return
*/
@Override
public boolean update(ShyUsers shyUsers) {
return shyUsersMapper.updateByPrimaryKeySelective(shyUsers) == 1;
}
}