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

select
    distinct sys_menu.*
from
    sys_menu
LEFT JOIN
    sys_role_menu
ON
    sys_menu.id = sys_role_menu.menu_id
LEFT JOIN
    sys_user_role
ON
    sys_role_menu.role_id = sys_user_role.role_id
LEFT JOIN
    sys_user
ON
    sys_user_role.user_id = sys_user.id
where
    sys_menu.del_flag = 0
{{if ne .name ""}}
    and sys_menu.name like '%{{.name}}%'
{{end}}
{{if ne .code ""}}
    and sys_menu.code like '%{{.code}}%'
{{end}}
{{if ne .cn_id ""}}
    and sys_menu.inheritance like '%{{.cn_id}}%'
{{end}}
{{if ne .type_op ""}}
    and sys_menu.type {{.type_op}} {{.type}}
{{end}}
{{if ne .user_id ""}}
    and sys_user.id = '{{.user_id}}'
{{else}}
    group by sys_menu.id
{{end}}
order by order_num
LIMIT {{.rows}} OFFSET {{.offset}}