From d88e79ad61012f8b42a095a4865f8ad4c4e52ac7 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期一, 27 二月 2023 22:46:38 +0800
Subject: [PATCH] 修改走访任务定时新建
---
springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml
index 570bb7b..1e248a9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml
@@ -82,6 +82,7 @@
order by vt.id desc
</select>
+<!-- group by cardNoStr-->
<select id="appFindListByPage" parameterType="com.panzhihua.common.model.query.visit.EventTasksQuery"
resultType="com.panzhihua.common.model.vos.visit.EventVisitingTasksVO">
select vt.id,vt.create_at,vt.create_by,vt.visiter_id,vt.visiter_name,vt.visiter_tele,vt.visiter_sex
@@ -90,7 +91,7 @@
FROM event_visiting_tasks vt
LEFT JOIN com_mng_population p ON p.id = vt.visiter_id
LEFT JOIN sys_user u ON u.user_id = vt.create_by
- where
+ where 1=1
<!-- <if test = "query.gridId != null">-->
<!-- and vt.grid_id = #{query.gridId}-->
<!-- </if>-->
@@ -103,7 +104,6 @@
<if test = "query.status == 0">
and (vt.event_status = 1 or vt.event_status = 3 or vt.event_status = 6 or vt.event_status = 6)
</if>
--- group by cardNoStr
order by vt.id desc
</select>
--
Gitblit v1.7.1