app查询过滤条件

xyh

2021-06-28 28a69d05203c1e6b60a47dae8ada8819583393dc

app查询过滤条件

 springcloud_k8s_panzhihuazhihuishequ/service_grid/src/main/resources/mapper/EventVisitingTasksMapper.xml

@@ -93,7 +93,10 @@
        LEFT JOIN event_grid_data gd ON gd.id = gbr.grid_id
        LEFT JOIN event_grid_member_relation gmr ON gmr.grid_id = gd.id
        LEFT JOIN sys_user u ON u.user_id = gmr.grid_member_id
        where u.use_id = #{query.userId}
        where 1=1
        <if test = "query.userId != null">
            u.use_id = #{query.userId}
        </if>
        <if test = "query.status == 1">
            and (vt.event_status = 3 or vt.event_status = 7)
        </if>