From 179c4d64313c9b7572778da4aaaf6c6584fe457d Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期二, 20 五月 2025 23:48:08 +0800 Subject: [PATCH] 修改文件上传类型限制 --- springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActNeighborCircleCommentWestDAO.java | 86 ++++++------------------------------------- 1 files changed, 12 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 c33d6dc..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 @@ -21,86 +21,24 @@ @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>") +// @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>") +// @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); - - } -- Gitblit v1.7.1