From 68963ff1c275b88e1f72a5449f60f7fba82c6563 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期一, 01 四月 2024 15:51:55 +0800
Subject: [PATCH] 修改活动交流详情的评论列表没数据 数据不全3
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java | 148 ++++++++++++++++++++++++------------------------
1 files changed, 74 insertions(+), 74 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 4e51dd6..c33d6dc 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,84 +21,84 @@
@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>"+")"
+// + ") temp"
+// + "ORDER BY temp.create_at"
+// + "</script>")
// IPage<ComActNeighborCommentByAdminVO> selectPageDetailNeighborComment(Page page,
-// @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
-
-
-
-
-
-
- @Select("<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>"+")"
- + ") temp"
- + "ORDER BY temp.create_at"
- + "</script>")
- IPage<ComActNeighborCommentByAdminVO> selectPageDetailNeighborComment(Page page,
- @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
+// @Param("dto") DetailNeighborAllCommentByAdminDTO dto);
--
Gitblit v1.7.1