修改办事指南所属部门集合

lidongdong

2022-11-15 2d25e6b0185514c95552c41af1da371cc1cc17cd

修改办事指南所属部门集合

 flower_city/src/main/java/com/dg/core/db/gen/entity/TransactionEvent.java

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

@@ -104,6 +104,12 @@
            transaction_area_name,
            classify_ids,
            department_ids,
            (SELECT GROUP_CONCAT(organization_name) FROM automessage_organization_chart WHERE id in (SELECT
                 substring_index(substring_index(department_ids,',', b.help_topic_id + 1), ',', -1) result
             FROM
                 mysql.help_topic b
             where
                     b.help_topic_id < (LENGTH(department_ids) - LENGTH(REPLACE(department_ids, ',', '')) + 1))) as departmentNames,
            (IF((select classify_grade from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)='2',
                (select classify_name from automessage_classify_administration where automessage_classify_administration.id=(select parent_id from
                automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)),