修改街道获取接口数据重复

lidongdong

2023-07-10 06556a0304b9e109d09b5f4405f647ce65868549

修改街道获取接口数据重复

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

@@ -232,20 +232,18 @@

         <if test="comActDynVO.typeS != null and comActDynVO.typeS == 2 ">
             AND d.type in (
            (SELECT cadt.id FROM `com_act_dyn_type` as cadt WHERE cadt.name in
             (SELECT cadt.id FROM `com_act_dyn_type` as cadt WHERE cadt.name in
             <foreach collection="comActDynVO.typeList" item="id" index="index" open="(" close=")" separator=",">
                 #{id}
             </foreach>

             <if test="comActDynVO.communityId != null and comActDynVO.communityId != '' ">
                 and cadt.community_id in (${comActDynVO.communityId})
             </if>)
             ,
             (SELECT cadt2.id FROM `com_act_dyn_type` as cadt2 WHERE cadt2.name in
             <foreach collection="comActDynVO.typeList" item="id" index="index" open="(" close=")" separator=",">
             (SELECT cadt2.id FROM `com_act_dyn_type` as cadt2 WHERE  cadt2.area=1 and cadt2.name in
              <foreach collection="comActDynVO.typeList" item="id" index="index" open="(" close=")" separator=",">
                 #{id}
             </foreach>
                and cadt2.area=1)
              </foreach>  )
             )
        </if>