修改走访任务定时新建

lidongdong

2023-02-27 d88e79ad61012f8b42a095a4865f8ad4c4e52ac7

修改走访任务定时新建

 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>