From d3c42bc8c75dd63daabe60ca0ae790744ff987f3 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 14 十一月 2023 14:35:14 +0800
Subject: [PATCH] 修改问题任务报名人员列表

---
 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml
index 51ec5ef..1100518 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemInventoryMapper.xml
@@ -58,7 +58,7 @@
             nfpi.community_id,
             nfnpc.punch_start_time,
             nfnpc.punch_end_time,
-            count(nfnpc.id) as isJoin,
+            if(nfnpc.user_id>0,1,0) as isJoin,
             nfpi.status,
             nfpi.user_id
         FROM new_fight_need_problem_inventory as nfpi
@@ -112,7 +112,7 @@
             nfpi.community_id,
             nfnpc.punch_start_time,
             nfnpc.punch_end_time,
-            count(nfnpc.id) as isJoin,
+            if(nfnpc.user_id>0,1,0) as isJoin,
             nfpi.status,
             nfpi.user_id
         FROM new_fight_need_problem_inventory as nfpi
@@ -163,7 +163,7 @@
             nfpi.community_id,
             nfnpc.punch_start_time,
             nfnpc.punch_end_time,
-            count(nfnpc.id) as isJoin,
+            if(nfnpc.user_id>0,1,0) as isJoin,
             nfpi.status,
             nfpi.user_id
         FROM new_fight_need_problem_inventory as nfpi

--
Gitblit v1.7.1