风险源，应急空间查询修改

zhongrj

2024-12-03 5c913ed05cf296ae540c4c9d3d39d4fef06f77b7

风险源，应急空间查询修改

 src/main/java/org/springblade/modules/yw/mapper/EmergencySpaceMapper.xml

@@ -7,7 +7,7 @@
        select
        yes.id,yes.name,yes.full_name,yes.type,yes.main_func,yes.lng,yes.lat,yes.pre_level,
        yes.capacity,yes.remark,yes.firm_id,yes.image_url,ST_AsGeoJSON(yes.geom) as geom,yes.ele,
        yfi.name as firmName,
        ifnull(yfi.name,'吉水化工园区') as firmName,
        bdb.dict_value as emergencySpaceType
        from yw_emergency_space yes
        left join blade_dict_biz bdb on bdb.dict_key = yes.type and bdb.code = 'emergency_space_type'

 src/main/java/org/springblade/modules/yw/mapper/RiskSourceMapper.xml

@@ -41,18 +41,16 @@
    <!--风险源统计查询-->
    <select id="getStatisticData" resultType="java.util.Map">
        SELECT
        CASE WHEN risk_level = 1 THEN '一般'
             WHEN risk_level = 2 THEN '较大'
        END AS riskLevel,
        bdb.dict_value AS riskLevel,
        count(*) AS num
        FROM
            yw_risk_source
            yw_risk_source yrs
        left join blade_dict_biz bdb on bdb.dict_key = yrs.risk_level and bdb.code = 'risk_level'
        WHERE
            is_deleted = 0
            AND risk_level IS NOT NULL
            AND firm_id IS NOT NULL
            yrs.is_deleted = 0
            AND yrs.risk_level IS NOT NULL
        GROUP BY
            risk_level
            yrs.risk_level
    </select>

</mapper>