SitesServiceImpl.java
4.45 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
package com.cnlive.shenhe.serviceImpl;
import com.cnlive.shenhe.dto.SitesDTO;
import com.cnlive.shenhe.entity.ShySites;
import com.cnlive.shenhe.entity.ShyUsers;
import com.cnlive.shenhe.mapper.ShySitesMapper;
import com.cnlive.shenhe.utils.CommonConst;
import com.cnlive.shenhe.utils.CommonUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import tk.mybatis.mapper.entity.Example;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
/**
* @Auther: 周伟鹏
* @Date: 2018/11/29 14:23
* @Description:
*/
@Service
public class SitesServiceImpl {
@Autowired
ShySitesMapper shySitesMapper;
@Autowired
UsersServiceImpl usersService;
public PageInfo<ShySites> getPage(SitesDTO sitesDTO) {
Example example = new Example(ShySites.class);
Example.Criteria criteria = example.createCriteria();
Example.Criteria criteria2 = example.createCriteria();
if (CommonUtils.isNotEmpty(sitesDTO.getOrderByClause())) {
example.setOrderByClause(sitesDTO.getOrderByClause());
}
if (CommonUtils.isNotEmpty(sitesDTO.getKeyword())) {
criteria.andLike("name", "%" + sitesDTO.getKeyword() + "%");
criteria2.andLike("spid", "%" + sitesDTO.getKeyword() + "%");
example.or(criteria2);
}
if (CommonUtils.isNotNull(sitesDTO.getSpId())) {
criteria.andEqualTo("spid", sitesDTO.getSpId());
criteria2.andEqualTo("spid", sitesDTO.getSpId());
}
PageHelper.startPage(sitesDTO.getPage(), sitesDTO.getPageSize(), true);
List<ShySites> shySitesList = shySitesMapper.selectByExample(example);
PageInfo<ShySites> pageInfo = new PageInfo<ShySites>(shySitesList);
return pageInfo;
}
public ShySites get(Integer siteId) {
return shySitesMapper.selectByPrimaryKey(siteId);
}
public boolean update(ShySites site) {
return shySitesMapper.updateByPrimaryKeySelective(site) == 1;
}
public List<ShySites> findAll() {
List<ShySites> shySites = shySitesMapper.selectAll();
return shySites;
}
public ShySites findspidDescByspid(int spId) {
Example example = new Example(ShySites.class);
Example.Criteria criteria = example.createCriteria();
if (CommonUtils.isNotNull(spId)) {
criteria.andEqualTo("spid", spId);
}
List<ShySites> shySites = shySitesMapper.selectByExample(example);
if(CommonUtils.isNotNull(shySites)&­Sites.size()>0){
return shySites.get(0);
}
return null;
}
public ShySites findspidBySpdesc(String sp_desc) {
Example example = new Example(ShySites.class);
Example.Criteria criteria = example.createCriteria();
if (CommonUtils.isNotEmpty(sp_desc)) {
criteria.andEqualTo("name", sp_desc);
}
List<ShySites> shySites = shySitesMapper.selectByExample(example);
if(CommonUtils.isNotNull(shySites)&­Sites.size()>0){
return shySites.get(0);
}
return null;
}
/**
* 获取免审白名单列表（点播）
* @return
*/
public List<Integer> getBusinessList(Integer business_) {
List<ShySites> sitesList = shySitesMapper.selectAll();
List<Integer> sites = new ArrayList<Integer>();
for (ShySites shySites : sitesList) {
if (CommonUtils.isNotEmpty(shySites.getWrite_business())) {
String[] business = shySites.getWrite_business().split(",");
List<String> asList = Arrays.asList(business);
if (asList.contains(business_ + "")) {
sites.add(shySites.getSpid());
}
}
}
return sites;
}
public String getUpdater(String updater,String auditor_id){
if (CommonUtils.isNotEmpty(auditor_id)) {
ShyUsers user = new ShyUsers();
user.setUser_id(auditor_id);
user = usersService.select(user);
if (CommonUtils.isNotNull(user)) {
String email = CommonUtils.isEmpty(user.getEmail()) || "null".equals(user.getEmail()) ? "" : user.getEmail();
String userName = CommonUtils.isEmpty(user.getUsername()) ? email : user.getUsername();
updater = userName ;
}
}
return updater;
}
}