EAS人员按照公司过滤

<span style="white-space: pre;"> </span>eas在单据开发时，有个f7字段，引用的是职员，需要按照公司做过滤，eas中的公司和财务组织是对应的，但和人员关系最近的是行政组织，通过财务组织的number等属性找到对应的行政组织和下级行政组织。基于此，我们对人员的按照公司过滤，可以按照行政组织过滤。
<span style="white-space: pre;"> </span>职员和行政组织的关系我们可以通过f7personquery来看出：
 
select 
 
"person".fid as "id", 
"person".fnumber as "number", 
"person".fname_l2 as "name", 
"position".fname_l2 as "position.name", 
"adminorgunit".fname_l2 as "adminorgunit.name"
 
from t_bd_person as "person"
 
inner join t_org_positionmember as "positionmember"
on "person".fid = "positionmember".fpersonid
 
inner join t_org_position as "position"
on "positionmember".fpositionid = "position".fid
 
inner join t_org_admin as "adminorgunit"
on "position".fadminorgunitid = "adminorgunit".fid