修改定时任务报名人数为空

lidongdong

2023-08-23 d9e457aef36ebe54be3fe18b13ed1c83ddb6b0af

修改定时任务报名人数为空

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerActivityMapper.xml

@@ -339,12 +339,13 @@
    <!-- 分页查询 -->
    <select id="timedTaskList" resultMap="VolunteerActivityMap">
        select
        ac_state,
        (select count(id) from volunteer_activities_people_involved where activity_id=id) volunteerNum,
        apply_begin_time,
        apply_end_time,
        actity_begin_time,
        actity_end_time
            id,
            ac_state,
            (select count(id) from volunteer_activities_people_involved where activity_id=id) volunteerNum,
            apply_begin_time,
            apply_end_time,
            actity_begin_time,
            actity_end_time
        from volunteer_activity
        where ac_state in (2,3,4)
    </select>