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

select
count(*) records
from sys_user
where sys_user.del_flag = 0
{{if ne .name ""}}
 and sys_user.name like '%{{.name}}%'
{{end}}
{{if ne .login_id ""}}
 and sys_user.login_id like '%{{.login_id}}%'
{{end}}