双报到双服务 问题清单 bug修改

LuoTong

2024-04-23 898892c5114dcd2be4bedcd711fc016e1af4c431

双报到双服务 问题清单 bug修改

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

@@ -322,9 +322,15 @@
            ctn.`name` as categoryName
        FROM
            com_act_neighbor_circle_topic_new AS ctn
         LEFT JOIN new_fight_need_problem_inventory AS npi ON npi.classify_id = ctn.id
        WHERE npi.creation_time >= concat(#{yearTime},'-01-01 00:00:00')
            AND npi.creation_time <= concat(#{yearTime},'-12-31 59:59:59')
        LEFT JOIN (
        SELECT * from new_fight_need_problem_inventory
        <if test="yearTime != null and yearTime != '' ">
            WHERE
            creation_time &gt;= concat(#{yearTime},'-01-01 00:00:00')
            AND creation_time &lt;= concat(#{yearTime},'-12-31 59:59:59')
        </if>
        )
        AS npi ON npi.classify_id = ctn.id
        GROUP BY
            ctn.id