From dbe455642a20055f5873a4ee8d757ed86431e457 Mon Sep 17 00:00:00 2001
From: tangxiaobao <303826152@qq.com>
Date: 星期五, 03 九月 2021 18:13:36 +0800
Subject: [PATCH] 办事指南改版
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActWorkGuideDAO.java | 6 ++++--
1 files changed, 4 insertions(+), 2 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 4758142..a607a3e 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
@@ -16,10 +16,12 @@
**/
@Mapper
public interface ComActWorkGuideDAO extends BaseMapper<ComActWorkGuideDO> {
- @Select("<script> " + "select id ,title,content,time_at,address,phone,create_at from com_act_work_guide "
+ @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.title != null and pageActWorkGuideDTO.title.trim() != ""'>"
- + "title like concat('%',#{pageActWorkGuideDTO.title},'%')" + " </if> " + " </where>" + "order by update_at asc"
+ + "and title like concat('%',#{pageActWorkGuideDTO.title},'%')" + " </if> " + " </where>" + "order by update_at asc"
+ "</script>")
IPage<ComActWorkGuideVO> pageWorkGuide(Page page,
@Param("pageActWorkGuideDTO") PageActWorkGuideDTO pageActWorkGuideDTO);
--
Gitblit v1.7.1