修改导办人员多部门显示

lidongdong

2022-11-25 289a42f9660e85ffd19107006008f3340f36ecab

修改导办人员多部门显示

 flower_city/src/main/resources/mapper/SysUserMapper.xml

@@ -108,7 +108,13 @@
             automessage_guide_repair_order.guide_department_id=automessage_sys_user.department_id) as transactionEndNum,
            (select role_name from automessage_role_management where automessage_role_management.id=role_ids) as roleName,
            (select permission from automessage_role_management where automessage_role_management.id=role_ids) as permission,
            (SELECT organization_name FROM automessage_organization_chart WHERE automessage_organization_chart.id=department_id) as department_name
            (SELECT GROUP_CONCAT(organization_name) FROM automessage_organization_chart WHERE id in (SELECT
                substring_index(substring_index(more_department_ids,',', b.help_topic_id + 1), ',', -1) result
                FROM
                mysql.help_topic b
                where
                b.help_topic_id < (LENGTH(more_department_ids) - LENGTH(REPLACE(more_department_ids, ',', '')) + 1)))
            as department_name
        FROM
            automessage_sys_user
    </sql>