java/zhihuishenqu.git

			@@ -459,6 +459,7 @@
			LoginUserInfoVO loginUserInfoVO = comActDiscussDAO.selectUserByUserId(comActDiscussCommentDO.getUserId());
			comActDiscussCommentVO.setUserName(loginUserInfoVO.getName());
			comActDiscussCommentVO.setPhone(loginUserInfoVO.getPhone());
			comActDiscussCommentVO.setImageUrl(loginUserInfoVO.getImageUrl());

			//查询该评论下所有回复内容
			IPage<ComActDiscussCommentVO> discussCommentList = comActDiscussCommentDAO.getDiscussCommentList(new Page(pageComActDiscussCommentDTO.getPageNum(), pageComActDiscussCommentDTO.getPageSize()), pageComActDiscussCommentDTO.getId());

			@@ -26,12 +26,14 @@
			cadc.id,
			cadc.`comment`,
			cadc.`is_author`,
			su.`image_url`,
			IFNULL( su.`name`, su.nick_name ) AS userNameBack,
			cadc.create_at
			FROM
			com_act_discuss_comment AS cadc
			LEFT JOIN sys_user AS su ON su.user_id = cadc.user_id
			where cadc.parent_id = #{id} and cadc.is_del = 2
			order by cadc.create_at desc
			</select>

			</mapper>

			@@ -210,12 +210,14 @@
			SELECT
			u.`name` userName,
			u.nick_name userNickName,
			u.image_url,
			u.phone,
			c.`comment`,
			c.`parent_id`,
			COUNT( DISTINCT cu.id ) num,
			COUNT( c1.id ) replyNum,
			c.create_at,
			c.is_topping,
			c.id
			FROM
			com_act_discuss_comment c
			@@ -233,7 +235,7 @@
			c.id
			) t
			ORDER BY
			t.create_at DESC
			t.is_topping DESC,t.create_at DESC
			</select>

			<select id="getDiscussCommentReplyList" resultType="com.panzhihua.common.model.vos.community.ComActDiscussCommentVO">
			@@ -251,7 +253,8 @@
			WHERE
			cadc.is_del = 2
			AND cadc.parent_id = #{commentId}
			limit 2
			order by cadc.create_at desc
			limit 10
			</select>

			</mapper>

	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComActDiscussServiceImpl.java	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussCommentDOMapper.xml	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDiscussDOMapper.xml	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史