大屏 左边数据 去掉分区查询

LuoTong

2024-04-23 b4b60d3ccf5f7124eef8126a7675dadc3346381e

大屏 左边数据 去掉分区查询

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComStreetServiceImpl.java

@@ -392,7 +392,7 @@
        if(type.equals("3")){// 3 查询 小区
            qry.eq( !StringUtils.isEmpty(code),ComActDO::getCommunityId,code);
        }
        qry.eq(ComActDO::getAppId,"wx118de8a734d269f0");
//        qry.eq(ComActDO::getAppId,"wx118de8a734d269f0");
        List<ComActDO> doList = comActDAO.selectList(qry);
        //解析 社区id
        List<Long> ids = doList.stream().map(ComActDO::getCommunityId).collect(Collectors.toList());

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

@@ -37,12 +37,11 @@
                (
                    SELECT count(*) FROM com_convenient_consultation_statistics ccs inner JOIN
                    ( SELECT cm.id from com_convenient_merchants as cm INNER JOIN com_act as ca on  ca.community_id = cm.community_id
                            where ca.app_id = 'wx118de8a734d269f0'
                        )  as mc on mc.id = ccs.merchant_id
                ) as consultationStatistics,

                ( SELECT count(*) FROM event_grid_member_relation as mr INNER JOIN com_act as ca  on ca.community_id  = mr.grid_community_id
                        where ca.app_id = 'wx118de8a734d269f0' ) as gridMember
                       ) as gridMember



@@ -340,7 +339,7 @@
        com_act_neighbor_circle_topic_new AS ctn
        LEFT JOIN (
        SELECT new_fight_need_problem_inventory.* from new_fight_need_problem_inventory  inner join (
            SELECT community_id from com_act WHERE app_id ='wx118de8a734d269f0'
            SELECT community_id from com_act
        ) as ca on  ca.community_id = new_fight_need_problem_inventory.community_id
        <if test="yearTime != null and yearTime != '' ">
            WHERE