VideosServiceImpl.java
4.79 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
package com.cnlive.shenhe.serviceImpl;
import com.cnlive.shenhe.entity.ShySites;
import com.cnlive.shenhe.entity.ShyUsers;
import com.cnlive.shenhe.entity.ShyVideos;
import com.cnlive.shenhe.mapper.ShySitesMapper;
import com.cnlive.shenhe.mapper.ShyUsersMapper;
import com.cnlive.shenhe.mapper.ShyVideosMapper;
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.sql.Timestamp;
import java.text.ParseException;
import java.util.List;
/**
* @Auther: chenhao
* @Date: 2018/11/30 14:23
* @Description:
*/
@Service
public class VideosServiceImpl {
@Autowired
ShyVideosMapper shyVideosMapper;
@Autowired
ShySitesMapper shySitesMapper;
@Autowired
ShyUsersMapper shyUsersMapper;
public boolean impotVideo(ShyVideos shyVideos) {
int result = shyVideosMapper.insert(shyVideos);
if (result == 0) {
return false;
}
return true;
}
public List<ShySites> getBusiness(ShySites shySites) {
List<ShySites> sitesList = shySitesMapper.select(shySites);
return sitesList;
}
public List<ShyVideos> findshyVideo(ShyVideos shyVideos) {
List<ShyVideos> shyVideoslist = shyVideosMapper.select(shyVideos);
return shyVideoslist;
}
public boolean updateshyVideos(ShyVideos shyVideos) {
int i = shyVideosMapper.updateByPrimaryKeySelective(shyVideos);
if (i == 0) {
return false;
}
return true;
}
public int updateVideo(Integer id, String auditor_id, Integer state, String msg) {
ShyVideos shyVideos = shyVideosMapper.selectByPrimaryKey(id);
shyVideos.setAuditor_id(auditor_id);
shyVideos.setState(state);
shyVideos.setMsg(msg);
return shyVideosMapper.updateByPrimaryKeySelective(shyVideos);
}
public PageInfo<ShyVideos> getListContent(String video_title, String start_date, String end_date, Integer state, Integer page, Integer pageSize, String video_priority, String orderByClause, Integer spid) {
Example example = new Example(ShyVideos.class);
Example.Criteria criteria = example.createCriteria();
Example.Criteria criteria2 = example.createCriteria();
if (CommonUtils.isNotEmpty(orderByClause)) {
example.setOrderByClause(orderByClause);
}
if (CommonUtils.isNotEmpty(start_date) && CommonUtils.isNotEmpty(end_date)) {
Timestamp startdate = null;
Timestamp enddate = null;
try {
startdate = CommonUtils.parseDate(start_date, "yyyy-MM-dd HH:mm:ss");
enddate = CommonUtils.parseDate(end_date, "yyyy-MM-dd HH:mm:ss");
} catch (ParseException e) {
e.printStackTrace();
}
criteria.andGreaterThanOrEqualTo("video_upload_time", startdate);
criteria.andLessThanOrEqualTo("video_upload_time", enddate);
}
if (CommonUtils.isNotEmpty(video_title)) {
criteria.andLike("video_title", "%" + video_title + "%");
}
if (CommonUtils.isNotNull(state) && state == 0) {
criteria.andEqualTo("state", state);
} else if (CommonUtils.isNotNull(state) && state == 1) {
criteria.andEqualTo("state", state);
criteria2.andEqualTo("state", 2);
example.or(criteria2);
}
if (CommonUtils.isNotEmpty(video_priority)) {
criteria.andEqualTo("video_priority", video_priority);
}
if (CommonUtils.isNotNull(spid)) {
criteria.andEqualTo("spid", spid);
}
//默认按上传时间倒序排序
example.setOrderByClause("video_upload_time desc");
PageHelper.startPage(page, pageSize, true);
List<ShyVideos> shyVideosList = shyVideosMapper.selectByExample(example);
PageInfo<ShyVideos> pageInfo = new PageInfo<>(shyVideosList);
return pageInfo;
}
public ShyVideos getDetailsContent(Integer id) {
ShyVideos DetailsshyVideos = shyVideosMapper.selectByPrimaryKey(id);
String auditorName = "白名单";
String auditor_id = DetailsshyVideos.getAuditor_id();
if (CommonUtils.isNotEmpty(auditor_id)) {
ShyUsers user = new ShyUsers();
user.setUser_id(auditor_id);
user = shyUsersMapper.selectOne(user);
String userName = CommonUtils.isEmpty(user.getUsername())?"":user.getUsername();
String email = CommonUtils.isEmpty(user.getEmail())?"":user.getEmail();
auditorName = userName + email;
}
DetailsshyVideos.setAuditor(auditorName);
return DetailsshyVideos;
}
}