区域下所有场所可见

区域下所有场所可见

/*区域下的场所展示出来   or acc.customer_id = ANY(c.arr_tree_ids)  */

select c.id ,c.name from t_account_child_customer acc
inner join t_customer c on c.id = acc.customer_id or acc.customer_id = ANY(c.arr_tree_ids)
where acc.account_id ='5368' and  c.leaf !=0;

 

 

 

 

账号下所有的配配置关系可见

 select c1.id from t_account_child_customer acc
                    inner join t_customer c1 on c1.status != 3 and c1.leaf = 1 and ( c1.id = acc.customer_id or c1.tree_ids like '%,'||acc.customer_id||',%' or  c1.tree_ids like '%,'||acc.customer_id or  c1.tree_ids like acc.customer_id||',%' or c1.tree_ids like acc.customer_id )
                  where  account_id ='1258' ;

 inner join t_activity_customer_priv acp1 on acp1.activity_id = a.id
              inner join t_customer c1 on c1.id = ? or (c1.tree_ids like '%,'||acp1.customer_id||',%' or  c1.tree_ids like '%,'
                             ||acp1.customer_id or  c1.tree_ids like acp1.customer_id||',%' or c1.tree_ids like acp1.customer_id )