package com.yeshi.buwan.service.imp;
|
|
import java.io.Serializable;
|
import java.math.BigInteger;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.hibernate.HibernateException;
|
import org.hibernate.Session;
|
import org.springframework.cache.annotation.Cacheable;
|
import org.springframework.orm.hibernate4.HibernateCallback;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.yeshi.buwan.dao.CommentDao;
|
import com.yeshi.buwan.dao.CommentReplyDao;
|
import com.yeshi.buwan.domain.Comment2;
|
import com.yeshi.buwan.domain.CommentReply;
|
import com.yeshi.buwan.domain.user.LoginUser;
|
import com.yeshi.buwan.util.Constant;
|
import com.yeshi.buwan.util.StringUtil;
|
|
@Service
|
public class CommentService {
|
@Resource
|
private CommentDao commentDao;
|
@Resource
|
private CommentReplyDao commentReplyDao;
|
|
public void addComment2(Comment2 c) {
|
|
commentDao.create(c);
|
}
|
|
@SuppressWarnings("unchecked")
|
@Cacheable(value = "homeCache", key = "'getComment2List'+'-'+#videoId+'-'+#thirdType+'-'+#page")
|
public List<Comment2> getComment2List(final String videoId, final String thirdType, final int page) {
|
|
return (List<Comment2>) commentDao.excute(new HibernateCallback<List<Comment2>>() {
|
public List<Comment2> doInHibernate(Session session) throws HibernateException {
|
List<Comment2> list = new ArrayList<Comment2>();
|
try {
|
list = session
|
.createQuery(
|
"from Comment2 c where c.thirdType=? and c.video.id=? and c.show=1 order by c.createtime desc")
|
.setParameter(0, thirdType).setParameter(1, videoId)
|
.setFirstResult((page - 1) * Constant.pageCount).setMaxResults(Constant.pageCount).list();
|
for (Comment2 c : list) {
|
List<CommentReply> li = session.createQuery("from CommentReply cr where cr.comment.id=?")
|
.setParameter(0, c.getId()).list();
|
c.setReplyList(li);
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
}
|
|
@Cacheable(value = "homeCache", key = "'getComment2ListCount'+'-'+#videoId+'-'+#thirdType")
|
public long getComment2ListCount(String videoId, String thirdType) {
|
|
return commentDao.getCount(
|
"from Comment2 c where c.thirdType=? and c.video.id=? and c.show=1 order by c.createtime desc",
|
new String[] { thirdType, videoId });
|
}
|
|
public Comment2 getComment2ById(String id) {
|
return commentDao.find(Comment2.class, id);
|
}
|
|
public boolean isHaveNewMessage(String uid) {
|
long count = commentDao.getCount(
|
"select count(*) from CommentReply cr where cr.parent!=null and cr.parent.user.id=? and cr.read=0",
|
new String[] { uid });
|
if (count > 0)
|
return true;
|
else
|
return false;
|
}
|
|
@SuppressWarnings("unchecked")
|
public List<CommentReply> getCommentReplyList(final String uid, final int pageIndex) {
|
return (List<CommentReply>) commentDao.excute(new HibernateCallback<List<CommentReply>>() {
|
public List<CommentReply> doInHibernate(Session session) throws HibernateException {
|
List<CommentReply> crlist = new ArrayList<CommentReply>();
|
try {
|
List<BigInteger> list = session
|
.createSQLQuery(
|
"SELECT cr.id FROM wk_video_comment_reply cr LEFT JOIN wk_video_comment2 c ON cr.`commentid`=c.`id` LEFT JOIN wk_video_comment_reply ccr ON ccr.`id`=cr.`parentid` WHERE (cr.`parentid` IS NULL AND c.`loginuid`=?) OR (cr.`parentid` IS NOT NULL AND ccr.`uid`=?) order by cr.createtime desc")
|
.setParameter(0, uid).setParameter(1, uid)
|
.setFirstResult((pageIndex - 1) * Constant.pageCount).setMaxResults(Constant.pageCount)
|
.list();
|
for (BigInteger c : list) {
|
crlist.add((CommentReply) session.get(CommentReply.class, c + ""));
|
}
|
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return crlist;
|
}
|
});
|
}
|
|
public void updateCommentReply(CommentReply cr) {
|
commentReplyDao.update(cr);
|
}
|
|
public CommentReply getCommentReplay(String id) {
|
return commentReplyDao.find(CommentReply.class, id);
|
}
|
|
public long getCommentReplyListCount(String uid) {
|
|
return commentReplyDao.getCountSQL(
|
"SELECT count(cr.id) FROM wk_video_comment_reply cr LEFT JOIN wk_video_comment2 c ON cr.`commentid`=c.`id` LEFT JOIN wk_video_comment_reply ccr ON ccr.`id`=cr.`parentid` WHERE (cr.`parentid` IS NULL AND c.`loginuid`="
|
+ uid + ") OR (cr.`parentid` IS NOT NULL AND ccr.`uid`=" + uid + ")");
|
}
|
|
@SuppressWarnings("unchecked")
|
public void setCommentReplyRead(final String uid) {
|
commentDao.excute(new HibernateCallback() {
|
public Object doInHibernate(Session session) throws HibernateException {
|
try {
|
List<CommentReply> list = session
|
.createQuery(
|
"from CommentReply cr where (cr.parent!=null and cr.parent.user.id=?) or (cr.parent = null and cr.comment.user.id=?)")
|
.setParameter(0, uid).setParameter(1, uid).list();
|
session.getTransaction().begin();
|
for (CommentReply cr : list) {
|
cr.setRead(true);
|
session.update(cr);
|
}
|
session.flush();
|
session.getTransaction().commit();
|
} catch (Exception e) {
|
e.printStackTrace();
|
session.getTransaction().rollback();
|
}
|
return null;
|
}
|
});
|
}
|
|
public Serializable replyComment(String commentid, String commentReplyId, String uid, String content) {
|
CommentReply cr = new CommentReply();
|
cr.setComment(new Comment2(commentid));
|
cr.setContent(content);
|
cr.setCreatetime(System.currentTimeMillis() + "");
|
if (!StringUtil.isNullOrEmpty(commentReplyId))
|
cr.setParent(new CommentReply(commentReplyId));
|
cr.setRead(false);
|
cr.setUser(new LoginUser(uid));
|
Serializable result = commentReplyDao.save(cr);
|
return result;
|
}
|
|
/**
|
* 查询某个用户或者内容的信息
|
*
|
* @param key
|
* @param page
|
* @return
|
*/
|
public List<Comment2> getCommentList(String key, int page) {
|
List<Comment2> list = commentDao.list(
|
"from Comment2 c where c.user.name=? or c.content like ? order by c.id desc",
|
(page - 1) * Constant.pageCount, Constant.pageCount, new Serializable[] { key, "%" + key + "%" });
|
return list;
|
}
|
|
/**
|
* 查询评论的数量
|
*
|
* @param key
|
* @return
|
*/
|
public long getCommentCount(String key) {
|
long count = commentDao.getCount("select count(*) from Comment2 c where c.user.name=? or c.content like ? ",
|
new Serializable[] { key, "%" + key + "%" });
|
return count;
|
}
|
|
@Transactional
|
public void deleteComment(String id) {
|
List<CommentReply> list = commentReplyDao.list("from CommentReply cr where cr.comment.id=" + id);
|
if (list != null)
|
for (CommentReply cr : list)
|
commentReplyDao.delete(cr);
|
commentDao.delete(new Comment2(id));
|
}
|
|
}
|
