fengjin
2022-10-27 92fdceba701c3c953119ae43bbdac99794cac22b
修改BUG
1个文件已修改
2 ■■■ 已修改文件
flower_city/src/main/resources/mapper/ClassifyAdministrationMapper.xml 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
flower_city/src/main/resources/mapper/ClassifyAdministrationMapper.xml
@@ -49,7 +49,7 @@
            parent_id=#{parentId}
            <if test="departmentId!=null">
                and id in (
                select classify_id from  automessage_transaction_event where department_id=#{departmentId} UNION
                select classify_id from  automessage_transaction_event where department_id in (select id from automessage_organization_chart where id=#{departmentId}  or parent_id=#{departmentId}) UNION
                select parent_id from  automessage_classify_administration
                where id in (select classify_id FROM automessage_transaction_event
                where department_id in (select id from automessage_organization_chart where id=#{departmentId}  or parent_id=#{departmentId}))  )