修改问题任务报名人员列表参与人数问题

lidongdong

2023-11-14 d902b6250e9c864aacba66a51a9cbb8b21669020

修改问题任务报名人员列表参与人数问题

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml

@@ -59,6 +59,7 @@
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            if(nfnpc.user_id>0,1,0) as isJoin,
            (count(task_id)) as joinNum,
            nfpi.status,
            nfpi.user_id
        FROM new_fight_need_problem_inventory as nfpi
@@ -82,6 +83,7 @@
                and nfpi.user_id =#{userId}
            </if>
        </where>
        GROUP BY nfpi.id
    </select>


@@ -113,6 +115,7 @@
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            if(nfnpc.user_id>0,1,0) as isJoin,
            (count(task_id)) as joinNum,
            nfpi.status,
            nfpi.user_id
        FROM new_fight_need_problem_inventory as nfpi
@@ -133,6 +136,7 @@
                and nfpi.id in(SELECT task_id FROM new_fight_need_problem_claim where user_id=#{userId} )
            </if>
        </where>
        GROUP BY nfpi.id
    </select>


@@ -164,6 +168,7 @@
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            if(nfnpc.user_id>0,1,0) as isJoin,
            (count(task_id)) as joinNum,
            nfpi.status,
            nfpi.user_id
        FROM new_fight_need_problem_inventory as nfpi
@@ -175,6 +180,7 @@
                and nfpi.id =#{id}
            </if>
        </where>
        GROUP BY nfpi.id
    </select>