system_get_org_tree.tpl 237 B

12345678910111213141516
  1. select
  2. distinct sys_org.id,
  3. sys_org.*
  4. from
  5. sys_org
  6. {{if ne .role_rule ""}}
  7. left join
  8. sys_user
  9. on sys_user.org_id = sys_org.id
  10. {{end}}
  11. where
  12. sys_org.del_flag = 0
  13. {{if ne .role_rule ""}}
  14. and {{.role_rule}}
  15. {{end}}