java/zhihuishenqu.git

			@@ -9,6 +9,7 @@
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleAdminVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleAppVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCircleDetailAppVO;
			import com.panzhihua.common.model.vos.neighbor.ComActNeighborCommentReplyAppVO;
			import com.panzhihua.common.model.vos.user.AdministratorsUserVO;
			import com.panzhihua.service_community.model.dos.ComActNeighborCircleDO;
			import org.apache.ibatis.annotations.Mapper;
			@@ -66,10 +67,12 @@
			@Select("<script> \n"+
			"SELECT\n" +
			"nc.*,\n" +
			"u.`name` AS releaseName \n" +
			"u.`name` AS releaseName,u.`type` as userType\n" +
			",ca.name as communityName\n" +
			"FROM\n" +
			"com_act_neighbor_circle nc\n" +
			"LEFT JOIN sys_user u ON nc.release_id = u.user_id\n" +
			"left join com_act ca on u.community_id=ca.community_id \n" +
			"<where>"+
			"nc.community_id = #{neighborCircleAdminDTO.communityId} \n"+
			"<if test='neighborCircleAdminDTO.releaseContent != null and neighborCircleAdminDTO.releaseContent != ""'>" +
			@@ -79,7 +82,9 @@
			"and nc.create_at between #{neighborCircleAdminDTO.startAt} and #{neighborCircleAdminDTO.endAt} \n" +
			" </if> " +
			"</where>"+
			"order by nc.`status` asc,nc.create_at desc " +
			"order by " +
			"case when nc.`status`=1 then 0 else 1 end, \n" +
			"nc.`status` asc,nc.create_at desc " +
			"</script>")
			IPage<ComActNeighborCircleAdminVO> pageNeighborByAdmin(Page page,@Param("neighborCircleAdminDTO") ComActNeighborCircleAdminDTO neighborCircleAdminDTO);

			@@ -93,4 +98,12 @@
			" </script>")
			IPage<ComActNeighborCircleAppVO> neighborExamineByApp(Page page,@Param("userId") Long userId);

			@Select("select reply.id,reply.comment_id,reply.reply_content,reply.fabulous_num,reply.create_at" +
			",reply.is_release,su.nick_name as userName,su.image_url as userHeadUrl,su1.nick_name as oldUserName" +
			" from com_act_neighbor_circle_comment_reply as reply" +
			" left join sys_user as su on su.user_id = reply.user_id" +
			" left join sys_user as su1 on su1.user_id = reply.parent_user_id" +
			" where reply.comment_id = #{commentId}")
			IPage<ComActNeighborCommentReplyAppVO> neighborCommentReplyByApp(Page page, @Param("commentId") Long commentId);

			}