From 590591c13adaa8e37f33d484a3cb3d6a0885d975 Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期五, 10 六月 2022 16:29:00 +0800
Subject: [PATCH] 大屏修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialOrgMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialOrgMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialOrgMapper.xml
index 72c90df..c786911 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialOrgMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialOrgMapper.xml
@@ -123,7 +123,7 @@
WHERE t2.user_id = #{userId} AND t1.is_society = 1
</select>
<select id="pageHatchResult" resultType="com.panzhihua.common.model.vos.community.ComActSocialOrgVO">
- SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName, t.create_at, t.service_type
+ SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName, t.create_at, t.service_type,
(SELECT COUNT(id) FROM com_act_social_member WHERE org_id = t.id) AS staffCount,
(SELECT COUNT(id) FROM com_act_social_project WHERE responsibility_type = 3 AND responsibility_id = t.id) AS undertakeProjectNum,
(SELECT COUNT(id) FROM com_act_activity WHERE `type` = 4 AND project_id IN (
@@ -180,7 +180,7 @@
</select>
<select id="pageSocialOrgList" resultType="com.panzhihua.common.model.vos.community.ComActSocialOrgVO">
- SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName,, t.create_at, t.service_type
+ SELECT t.id, t.`name`, t.company_type, t.attach_url, t.streetName,, t.create_at, t.service_type,
(SELECT COUNT(id) FROM com_act_social_member WHERE org_id = t.id) AS staffCount,
(SELECT COUNT(id) FROM com_act_social_project WHERE responsibility_type = 3 AND responsibility_id = t.id) AS undertakeProjectNum,
(SELECT COUNT(id) FROM com_act_activity WHERE `type` = 4 AND project_id IN (
--
Gitblit v1.7.1