From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001 From: liujie <1793218484@qq.com> Date: 星期一, 09 六月 2025 11:54:00 +0800 Subject: [PATCH] 6.9新增登录失败冻结逻辑 --- 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