/** * @Title: selectReplyByCommentId @Description: TODO(根据评论id查询回复列表) * * @author <a href="*****@*****.**">赖彩妙</a> * @date 2015-5-20 下午2:31:00 * @version 1.0.0 * @param @param data * @param @return * @return Object 返回类型 * @throws */ public Object selectReplyByCommentId(Object data) { log.info("start[MemberCommentService.selectReplyByCommentId]"); net.sf.json.JSONObject jsonObject = net.sf.json.JSONObject.fromObject(data); Integer pageIndex = jsonObject.getInt("pageIndex"); Integer pageSize = jsonObject.getInt("pageSize"); Integer commentId = jsonObject.getInt("commentId"); PageHelper.startPage(pageIndex, pageSize); ResultPage<OrderCommentDetailDTO> commentPage = new ResultPage(orderCommentMapper.selectReplyByCommentId(commentId)); if (commentPage.getRows() != null && commentPage.getRows().size() >= 1) { SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); for (int i = 0; i < commentPage.getRows().size(); i++) { if (commentPage.getRows().get(i).getCreateTime() != null) { commentPage .getRows() .get(i) .setCommentDate(format.format(commentPage.getRows().get(i).getCreateTime())); } } } log.info("end[MemberCommentService.selectReplyByCommentId]"); // return new ResultObject(new HeadObject(ErrorCode.SUCCESS), // JSONObject.fromObject(commentPage)); return new ResultObject( new HeadObject(ErrorCode.SUCCESS), com.alibaba.fastjson.JSONObject.toJSON(commentPage)); }
/** * @description <b>获取用户的评论信息</b> * @author 王鹏 * @version 1.0.0 * @data 2015-5-15 * @param @param data * @param @return * @return Object */ public Object findMemberComment(Object data) { HeadObject headObject = new HeadObject(); ResultPage<Object> comments = null; try { MemberCommentQryDTO qryDTO = (MemberCommentQryDTO) data; qryDTO.buildOrderByField(); PageHelper.startPage(qryDTO.getPage(), qryDTO.getRows()); comments = new ResultPage<Object>(this.orderCommentMapper.selectMemberCommentCount(qryDTO)); if (comments.getRows().size() > 0) { qryDTO.setCommentIds(comments.getRows()); qryDTO.setCommentsType(CommentsType.COMMENT.getKey().toString()); comments.setRows(orderCommentMapper.selectMemberComment(qryDTO)); } headObject.setRetCode(ErrorCode.SUCCESS); } catch (Exception e) { headObject.setRetCode(ErrorCode.FAILURE); log.error("获取用户评论失败", e); e.printStackTrace(); } return new ResultObject(headObject, JSONObject.toJSON(comments)); }
/** * @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)); }