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/ComActWorkGuideDAO.java | 41 +++++++++++++++++++++++++---------------- 1 files changed, 25 insertions(+), 16 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java index 0f8f307..45a5e7f 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java @@ -1,32 +1,41 @@ package com.panzhihua.service_community.dao; +import com.panzhihua.common.model.vos.community.ComActWorkGuideDetailAppletsVO; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; + import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.dtos.community.PageActWorkGuideDTO; import com.panzhihua.common.model.vos.community.ComActWorkGuideVO; -import com.panzhihua.common.model.vos.community.ComCvtServeVO; import com.panzhihua.service_community.model.dos.ComActWorkGuideDO; -import com.panzhihua.service_community.model.dos.ComMngFamilyDO; -import org.apache.ibatis.annotations.Mapper; -import org.apache.ibatis.annotations.Param; -import org.apache.ibatis.annotations.Select; -import org.springframework.web.bind.annotation.RequestParam; +import java.util.List; /** * @description: 办事指南 **/ @Mapper public interface ComActWorkGuideDAO extends BaseMapper<ComActWorkGuideDO> { - @Select("<script> " + - "select id ,title,content,time_at,address,phone from com_act_work_guide " + - " <where>" + - "<if test='pageActWorkGuideDTO.title != null and pageActWorkGuideDTO.title.trim() != ""'>" + - "title like concat('%',#{pageActWorkGuideDTO.title},'%')"+ - " </if> " + - " </where>" + - "order by create_at desc"+ - "</script>") - IPage<ComActWorkGuideVO> pageWorkGuide(Page page, @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); + @Select("<script> " + "select id ,title,content,classify,time_at,address,phone,create_at from com_act_work_guide " + + " <where>" + + "<if test='pageActWorkGuideDTO.classify != null'>" + + "and classify = #{pageActWorkGuideDTO.classify} " + " </if> " + + "<if test='pageActWorkGuideDTO.areaCode != null'>" + + "and area_code = #{pageActWorkGuideDTO.areaCode} " + " </if> " + + "<if test='pageActWorkGuideDTO.title != null and pageActWorkGuideDTO.title.trim() != ""'>" + + "and title like concat('%',#{pageActWorkGuideDTO.title},'%')" + " </if> " + " </where>" + "order by update_at desc" + + "</script>") + IPage<ComActWorkGuideVO> pageWorkGuide(Page page, + @Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO); + + /** + * 根据办事指南分类id查询办事指南 + * @param classifyId 办事指南分类id + * @param pageSize 默认展示条数 + * @return 办事指南列表 + */ + List<ComActWorkGuideDetailAppletsVO> getWorkGuideListByClassifyId(@Param("classifyId") Long classifyId,@Param("pageSize") Long pageSize); } -- Gitblit v1.7.1