meidu2021/daju/target/classes/cn/com/lzt/sameleveltransfer/sql/SameleveltransferMinidaoDao_getParentDepartPostUserCount.sql

select count(*) from
t_bus_user_personnel p
,t_s_user_org org
,t_s_base_user bu
,t_s_depart dep
where p.userid=org.user_id
and bu.id=p.userid
and bu.id = org.user_id
and org.org_id=dep.id
and (dep.parentdepartid=:departId or dep.id = :departId)
and p.in_postid=:postId
and org.ifpluralism='0' and org.status ='0'
and p.leave_date is null
and bu.delete_flag <> '1'