区域下所有场所可见

最新推荐文章于 2023-03-17 11:52:49 发布

weixin_44282540

最新推荐文章于 2023-03-17 11:52:49 发布

阅读量108

点赞数

分类专栏： Postgresql

本文链接：https://blog.csdn.net/weixin_44282540/article/details/99693879

版权

Postgresql 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

区域下所有场所可见

/*区域下的场所展示出来   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 )