| | |
| | | transaction_names, |
| | | openid, |
| | | transaction_num, |
| | | (select title from automessage_role_management where automessage_role_management.id=role_ids) as roleName, |
| | | (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_sys_user.department_id=automessage_organization_chart.id) as department_name |
| | | FROM |