/**
* @Title: selectOrderCommentByGoodsId @Description: TODO(根据商品id查询评论列表)
*
* @author <a href="*****@*****.**">赖彩妙</a>
* @date 2015-5-13 下午2:19:50
* @version 1.0.0
* @param @param data
* @param @return
* @return Object 返回类型
* @throws
*/
public Object selectOrderCommentByGoodsId(Object data) {
log.info("start[OrderCommentService.selectOrderCommentByGoodsId]");
net.sf.json.JSONObject jsonObject = net.sf.json.JSONObject.fromObject(data);
Integer pageIndex = jsonObject.getInt("pageIndex");
Integer pageSize = jsonObject.getInt("pageSize");
Integer goodsId = jsonObject.getInt("goodsId");
PageHelper.startPage(pageIndex, pageSize);
ResultPage<OrderCommentDetailDTO> commentPage =
new ResultPage(orderCommentMapper.selectOrderCommentByGoodsId(goodsId));
if (commentPage.getRows() != null && commentPage.getRows().size() >= 1) {
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
CommentPraiseExample example = null;
for (int i = 0; i < commentPage.getRows().size(); i++) {
if (commentPage.getRows().get(i).getOrderCreateTime() != null) {
commentPage
.getRows()
.get(i)
.setOrderCreateDate(format.format(commentPage.getRows().get(i).getOrderCreateTime()));
}
// 查询点赞数量
// example = new CommentPraiseExample();
//
// example.createCriteria().andCommentIdEqualTo(commentPage.getRows().get(i).getCommentId().intValue());
// commentPage.getRows().get(i).setPraise(commentPraiseMapper.countByExample(example));
commentPage
.getRows()
.get(i)
.setPraise(
commentPraiseMapper.selectCountByCommentId(
commentPage.getRows().get(i).getCommentId().intValue()));
// 查询回复数量
commentPage
.getRows()
.get(i)
.setReplyCount(
orderCommentMapper.selectReplyCountByCommentId(
commentPage.getRows().get(i).getCommentId().intValue()));
}
}
return new ResultObject(
new HeadObject(ErrorCode.SUCCESS), com.alibaba.fastjson.JSONObject.toJSON(commentPage));
}
/**
* @Title: selectCommentById @Description: TODO(根据主键查询评论对象)
*
* @author <a href="*****@*****.**">赖彩妙</a>
* @date 2015-5-18 下午7:24:23
* @version 1.0.0
* @param @param data
* @param @return
* @return Object 返回类型
* @throws
*/
public Object selectCommentById(Object data) {
log.info("start[MemberCommentService.selectCommentById]");
OrderCommentDetailDTO comment = orderCommentMapper.selectCommentById((Integer) data);
if (comment != null) {
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
if (comment.getOrderCreateTime() != null) {
comment.setOrderCreateDate(format.format(comment.getOrderCreateTime()));
}
if (comment.getCreateTime() != null) {
comment.setCommentDate(format.format(comment.getCreateTime()));
}
// 查询点赞数量
comment.setPraise(
commentPraiseMapper.selectCountByCommentId(comment.getCommentId().intValue()));
// 查询回复数量
comment.setReplyCount(
orderCommentMapper.selectReplyCountByCommentId(comment.getCommentId().intValue()));
}
log.info("end[MemberCommentService.selectCommentById]");
return new ResultObject(new HeadObject(ErrorCode.SUCCESS), comment);
}