light-apiengine-feature/sqlconfig/system_controller/system_get_menu_tree.tpl

{{if ne .user_id ""}}
select
    sys_menu.*
from
    sys_menu, sys_role_menu, sys_user_role, sys_user
where
    sys_menu.id = sys_role_menu.menu_id
    and sys_role_menu.role_id = sys_user_role.role_id
    and sys_user_role.user_id = sys_user.id
    and sys_menu.del_flag = 0
    and sys_user.id = '{{.user_id}}'
{{if ne .name ""}}
    and sys_menu.name like '%{{.name}}%'
{{end}}
{{if ne .type_op ""}}
    and sys_menu.type {{.type_op }} {{.type}}
{{end}}
order by sys_menu.order_num
{{else}}
select
    sys_menu.*
from
    sys_menu
where
    sys_menu.del_flag = 0
{{if ne .name ""}}
    and sys_menu.name like '%{{.name}}%'
{{end}}
{{if ne .type_op ""}}
    and sys_menu.type {{.type_op }} {{.type}}
{{end}}
order by sys_menu.order_num
{{end}}