opt: sql改造其他模块改造4

linwei

2026-04-02 55cb206652615a09182e2177fba026720f2ec5be

opt: sql改造其他模块改造4

 drone-service/drone-fw/src/main/java/org/sxkj/fw/area/mapper/FwAreaDivideMapper.xml

@@ -262,7 +262,7 @@
            ad.area_name,
            ad.area_type_keys,
            (
                select group_concat(distinct ds.scene_name)
                select string_agg(distinct ds.scene_name)
                from ja_fw_defense_scene ds
                join ja_fw_defense_scene_manage dsm on dsm.defense_scene_id = ds.id::VARCHAR and dsm.is_deleted = 0
                where ds.is_deleted = 0

 drone-service/drone-gd/src/main/java/org/sxkj/gd/orderdata/mapper/GdDataObjectionMapper.xml

@@ -31,7 +31,7 @@
    <select id="selectGdDataObjectionPage" resultMap="gdDataObjectionResultMap">
        select
            obj.*,
            GROUP_CONCAT(da.attach_name SEPARATOR ',') as attach_names,
        string_agg(da.attach_name SEPARATOR ',') as attach_names,
            bd.dept_name as create_dept_name
        from
            ja_gd_data_objection obj
@@ -73,8 +73,8 @@
    <select id="getDetail" resultType="org.sxkj.gd.orderdata.vo.GdDataObjectionVO">
        select
            obj.*,
            GROUP_CONCAT(da.attach_name SEPARATOR ',') as attach_names ,
            GROUP_CONCAT(da.attach_id SEPARATOR ',') as attach_ids
        string_agg(da.attach_name SEPARATOR ',') as attach_names ,
        string_agg(da.attach_id SEPARATOR ',') as attach_ids
        from
            ja_gd_data_objection obj
        left join

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/MenuMapper.xml

@@ -567,7 +567,7 @@

    <select id="authRoutes" resultType="org.sxkj.system.dto.MenuDTO">
        SELECT
            GROUP_CONCAT(r.role_alias) as alias,
        string_agg(r.role_alias) as alias,
            m.path
        FROM
            blade_role_menu rm

 drone-service/drone-system/src/main/java/org/sxkj/system/mapper/UserMapper.xml

@@ -32,7 +32,7 @@
    <select id="selectUserPage" resultMap="userResultMap">
        SELECT
        u.*,
        GROUP_CONCAT(r.id) AS roleId
        string_agg(r.id) AS roleId
        FROM blade_user u
        INNER JOIN blade_role r
        ON r.id = ANY(string_to_array(u.role_id, ',')::bigint[])