| | |
| | | List<ComActNeighborCircleCommentReplyAppVO> getCircleCommentReplyList(@Param("commentId") Long commentId); |
| | | |
| | | @Select("<script> " + |
| | | "select cr.*,u.name as userName from com_act_neighbor_circle_comment_reply cr left join sys_user u on cr.user_id=u.user_id " + |
| | | "select cr.*,u.name as userName,u.phone as userPhone,u.nick_name as userNickName from com_act_neighbor_circle_comment_reply cr left join sys_user u on cr.user_id=u.user_id " + |
| | | "<where>"+ |
| | | "<if test='dto.id != null and pageActWorkGuideDTO.dto!= 0l'>" + |
| | | "comment_id = #{dto.id}"+ |
| | | "<if test='dto.id != null and dto.id!= 0l'>" + |
| | | "cr.comment_id = #{dto.id}"+ |
| | | " </if> " + |
| | | "</where>"+ |
| | | " ORDER BY create_at"+ |
| | | " ORDER BY cr.create_at"+ |
| | | "</script>") |
| | | Page<ComActNeighborCommentReplyByAdminVO> selectListByComment(Page<ComActNeighborCircleCommentReplyDO> page, DetailNeighborCommentReplyByAdminDTO dto); |
| | | Page<ComActNeighborCommentReplyByAdminVO> selectListByComment(Page page,@Param("dto") DetailNeighborCommentReplyByAdminDTO dto); |
| | | |
| | | } |