From 3ee62e76c51a78e0cd1854c8b35c6b02e6f7369a Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 12 十一月 2024 11:50:46 +0800
Subject: [PATCH] 花城 修改志愿者返回参数内容
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java | 68 +--------------------------------
1 files changed, 3 insertions(+), 65 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..2f8c6ac 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
@@ -29,78 +29,16 @@
// + " 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);
+ 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 * 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