light-apiengine/sqlconfig/system_controller/system_find_user_page_count.tpl

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