UsersServiceImpl.java
1.94 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
package com.cnlive.shenhe.serviceImpl;
import com.cnlive.shenhe.entity.ShyUsers;
import com.cnlive.shenhe.mapper.ShyUsersMapper;
import com.cnlive.shenhe.utils.CommonUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.entity.Example;
/**
* @Auther: 周伟鹏
* @Date: 2018/11/29 14:23
* @Description:
*/
@Service
public class UsersServiceImpl {
@Autowired
ShyUsersMapper shyUsersMapper;
public PageInfo<ShyUsers> getPage(Integer page, Integer pageSize, String orderByClause,
String username,String mobile,Integer sp_id,String company_brief) {
Example example = new Example(ShyUsers.class);
Example.Criteria criteria = example.createCriteria();
if (CommonUtils.isNotEmpty(orderByClause)) {
example.setOrderByClause(orderByClause);
}else{
example.setOrderByClause("created_at desc");
}
if (CommonUtils.isNotEmpty(username)) {
criteria.andLike("username", "%" + username + "%");
}
if(CommonUtils.isNotEmpty(mobile)){
criteria.andLike("mobile", "%" + mobile + "%" );
}
if(CommonUtils.isNotEmpty(company_brief)){
criteria.andLike("company_brief", "%" + company_brief + "%" );
}
if(CommonUtils.isNotNull(sp_id)){
criteria.andEqualTo("sp_id", sp_id );
}
PageHelper.startPage(page, pageSize, true);
List<ShyUsers> ShyUsersList = shyUsersMapper.selectByExample(example);
PageInfo<ShyUsers> pageInfo = new PageInfo<ShyUsers>(ShyUsersList);
return pageInfo;
}
public ShyUsers get(Integer id) {
return shyUsersMapper.selectByPrimaryKey(id);
}
public ShyUsers select(ShyUsers shyUsers) {
return shyUsersMapper.selectOne(shyUsers);
}
}