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}}
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}}