修改导办人员管理区域未显示，未显示

lidongdong

2022-10-19 b1fa4eb66f040a6f814e95bee26d1d762dcbe300

修改导办人员管理区域未显示，未显示

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

@@ -67,12 +67,12 @@
            second_level_id,
            concat(
                    IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select city from automessage_organization_chart
                                                                                       where automessage_organization_chart.id=department_id)),''),
                            where automessage_organization_chart.id=department_id)),''),
                    IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select district from automessage_organization_chart
                                                                                       where automessage_organization_chart.id=department_id)),''),
                            where automessage_organization_chart.id=department_id)),''),
                    IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select village from automessage_organization_chart
                                                                                       where automessage_organization_chart.id=department_id)),'')
                ) AS department_area,,
                            where automessage_organization_chart.id=department_id)),'')
                ) AS department_area,
            leisure_state,
            master_ids,
            master_names,