From 69a90c3e631813e5373eaa357896a4003040cab2 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期一, 01 四月 2024 15:33:51 +0800
Subject: [PATCH] 修改活动交流详情的评论列表没数据 数据不全
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java | 92 +++++++++++++++++++++++++++++++++++++++-------
1 files changed, 78 insertions(+), 14 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java
index e95bb96..667b49d 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java
@@ -21,21 +21,85 @@
@Mapper
public interface ComActNeighborCircleCommentWestDAO extends BaseMapper<ComActNeighborCircleCommentWestDO> {
- @Select("<script> " + "select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num"
- + ",cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl "
- + " from com_act_neighbor_circle_comment as cancc " + " left join sys_user as su on su.user_id = cancc.user_id"
- + " where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1"
- + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 1'>"
- + " order by cancc.create_at desc" + " </if> "
- + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 2'>"
- + " order by cancc.create_at asc" + " </if> " + " </script>")
- IPage<ComActNeighborCircleCommentAppVO> pageNeighborCommentByApp(Page page,
- @Param("neighborCircleAppDTO") ComActNeighborCircleDetailAppDTO neighborCircleAppDTO);
+// @Select("<script> " + "select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num"
+// + ",cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl "
+// + " from com_act_neighbor_circle_comment as cancc " + " left join sys_user as su on su.user_id = cancc.user_id"
+// + " where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1"
+// + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 1'>"
+// + " order by cancc.create_at desc" + " </if> "
+// + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 2'>"
+// + " order by cancc.create_at asc" + " </if> " + " </script>")
+// IPage<ComActNeighborCircleCommentAppVO> pageNeighborCommentByApp(Page page,
+// @Param("neighborCircleAppDTO") ComActNeighborCircleDetailAppDTO neighborCircleAppDTO);
+
+
+// @Select("<script> "
+// + "select nc.*,u.nick_name as userName,u.phone as userPhone from com_act_neighbor_circle_comment nc left join sys_user u on nc.user_id=u.user_id "
+// + "<where>" + "<if test='dto.id != null and dto.id!= 0l'>" + "nc.circle_id = #{dto.id}" + " </if> " + "</where>"
+// + " ORDER BY create_at" + "</script>")
+// IPage<ComActNeighborCommentByAdminVO> selectPageDetailNeighborComment(Page page,
+// @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
+
+
+
+
+
@Select("<script> "
- + "select nc.*,u.nick_name as userName,u.phone as userPhone from com_act_neighbor_circle_comment nc left join sys_user u on nc.user_id=u.user_id "
- + "<where>" + "<if test='dto.id != null and dto.id!= 0l'>" + "nc.circle_id = #{dto.id}" + " </if> " + "</where>"
- + " ORDER BY create_at" + "</script>")
+ + "select * FROM ("
+ + "select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num"
+ + ",cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl "
+ + " from com_act_neighbor_circle_comment as cancc " + " left join sys_user as su on su.user_id = cancc.user_id"
+ + " where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1"
+ + "union" + "select cancc.id,cancc.circle_id,cancc.user_id,cancc.content,cancc.fabulous_num"
+ + ",cancc.create_at,cancc.is_release,su.nick_name as userName,su.image_url as userHeadUrl "
+ + " from com_act_neighbor_circle_comment_west as cancc " + " left join sys_user as su on su.user_id = cancc.user_id"
+ + " where cancc.circle_id = #{neighborCircleAppDTO.circleId} and cancc.status = 1" + ") temp"
+ + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 1'>"
+ + " order by temp.create_at desc" + " </if> "
+ + "<if test='neighborCircleAppDTO.order != null and neighborCircleAppDTO.order == 2'>"
+ + " order by temp.create_at asc" + " </if> "
+ + " </script>")
+ IPage<ComActNeighborCircleCommentAppVO> pageNeighborCommentByApp(Page page,
+ @Param("neighborCircleAppDTO") ComActNeighborCircleDetailAppDTO neighborCircleAppDTO);
+
+
+
+
+
+ @Select("<script> "
+ + "select * FROM ("
+ + "(select"
+ + "nc.id,"
+ + "nc.circle_id,"
+ + "nc.user_id,"
+ + "nc.content,"
+ + "nc.user_phone,"
+ + "nc.fabulous_num,"
+ + "nc.status,"
+ + "nc.create_at,"
+ + "nc.is_release,u.nick_name as userName,u.phone as userPhone"
+ + "from com_act_neighbor_circle_comment nc left join sys_user u on nc.user_id=u.user_id"
+ + "<where>"+ "<if test='dto.id != null and dto.id!= 0l'>"+ "nc.circle_id = #{dto.id}" + " </if> "+"<where>"+")"
+ + "union"
+ + "(select nc.id,"
+ + "nc.circle_id,"
+ + "nc.user_id,"
+ + "nc.content,"
+ + "nc.user_phone,"
+ + "nc.fabulous_num,"
+ + "nc.status,"
+ + "nc.create_at,"
+ + "nc.is_release,"
+ + "u.nick_name as userName,u.phone as userPhone "
+ + "from com_act_neighbor_circle_comment_west nc left join sys_user u on nc.user_id=u.user_id "
+ + "<where>"+ "<if test='dto.id != null and dto.id!= 0l'>"+ "nc.circle_id = #{dto.id}" + " </if> "+"<where>"+")"
+ + "ORDER BY temp.create_at"
+ + "</script>")
IPage<ComActNeighborCommentByAdminVO> selectPageDetailNeighborComment(Page page,
- @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
+ @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
+
+
+
+
}
--
Gitblit v1.7.1