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

select
    count(*) records
from
    sys_user
{{if ne .cn_org_id ""}}
left join
    sys_org
on
    sys_user.org_id = sys_org.id
{{end}}
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}}
{{if ne .cn_org_id ""}}
    and sys_org.inheritance like '%{{.cn_org_id}}%'
{{end}}
{{if ne .role_rule ""}}
    and {{.role_rule}}
{{end}}