light-apiengine/sqlconfig/system_controller/system_find_data_permission_page_select.tpl

select
    sys_data_permission.*
from
    sys_data_permission
where
    sys_data_permission.del_flag = 0
    {{if ne .name ""}}
        AND sys_data_permission.name like '%{{.name}}%'
    {{end}}
    {{if ne .code ""}}
        AND sys_data_permission.code like '%{{.code}}%'
    {{end}}
LIMIT {{.rows}} OFFSET {{.offset}}