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

select
    sys_area.*,
	sys_org.name org_name,
	sys_org.inheritance org_inheritance,
	sys_user.name manager_name,
	sys_user.mobile manager_mobile,
	sys_area_template.name temp_name
from
    sys_area
left join
	sys_org
on
	sys_area.org_id = sys_org.id
left join
	sys_user
on
	sys_area.manager = sys_user.id
left join
    sys_area_template
on
    sys_area_template.id = sys_area.temp_id
where
{{if ne .del_flag ""}}
	sys_area.del_flag = {{.del_flag}}
{{else}}
    sys_area.del_flag = 0
{{end}}
{{if ne .id ""}}
	and sys_area.id = "{{.id}}"
{{end}}
{{if ne .name ""}}
	and sys_area.name like "%{{.name}}%"
{{end}}
{{if ne .parent ""}}
	and sys_area.parent = "{{.parent}}"
{{end}}
{{if ne .inheritance ""}}
	and sys_area.inheritance like "%{{.inheritance}}%"
{{end}}
{{if ne .temp_id ""}}
	and sys_area.temp_id = "{{.temp_id}}"
{{end}}
{{if ne .manager ""}}
	and sys_area.manager = "{{.manager}}"
{{end}}
{{if ne .org_id ""}}
	and sys_area.org_id = "{{.org_id}}"
{{end}}
{{if ne .org_name ""}}
	and sys_org.name like "%{{.org_name}}%"
{{end}}
{{if ne .org_inheritance ""}}
	and sys_org.inheritance like "%{{.org_inheritance}}%"
{{end}}
{{if ne .manager_name ""}}
	and sys_user.name = "{{.manager_name}}"
{{end}}
LIMIT {{.rows}} OFFSET {{.offset}}