自定义权限控制模板实现

楼主
沐浴在阳光下

不同步业务系统的权限,从帆软填报实现数据权限控制

1.把数据权限按类型分类填报

 

2. 新增具体的角色选择类别

 

 

3.给角色授权组织和部门权限

 

 

 

 

4.往角色里面添加对应的人员

 

 

5.在帆软模板使用的时候拼接sql

${if(fine_role="superusers","",if(SQL("dcresult"," select rt.role_permission from DIM_FIN_USER_ROLES fr
left join dim_fin_roles_permission_org fp on fp.fin_role_id=fr.fin_user_role
left join dim_fin_roles ro on ro.fin_role_id=fr.fin_user_role
left join dim_fin_roles_type rt on rt.role_type_id=ro.role_type_id
where fr.fin_user_code='"+fine_username+"'",1,1)='0',"",if(SQL("dcresult"," select rt.role_permission from DIM_FIN_USER_ROLES fr
left join dim_fin_roles_permission_org fp on fp.fin_role_id=fr.fin_user_role
left join dim_fin_roles ro on ro.fin_role_id=fr.fin_user_role
left join dim_fin_roles_type rt on rt.role_type_id=ro.role_type_id
where fr.fin_user_code='"+fine_username+"'",1,1)='1'," and t.dept_id in (select du.pk_dept from DIM_PERMISSION_USER_DEPT du where du.user_code='"+fine_username+"') "," and (t.corp_code in ('"+SUBSTITUTE(sql("dcresult"," select fp.fin_org_code from DIM_FIN_USER_ROLES fr
left join dim_fin_roles_permission_org fp on fp.fin_role_id=fr.fin_user_role
where fr.fin_user_code ='"+fine_username+"'",1,null),",","','")+"') or
regexp_like(t.dept_name,'("+SUBSTITUTE(SQL("dcresult"," select fp.remark from DIM_FIN_USER_ROLES fr
left join dim_fin_roles_permission_org fp on fp.fin_role_id=fr.fin_user_role
left join dim_fin_roles ro on ro.fin_role_id=fr.fin_user_role
left join dim_fin_roles_type rt on rt.role_type_id=ro.role_type_id
where fr.fin_user_code='"+fine_username+"'",1,null),",","|")+")')
 
)"
 
)))}

 

 

分享扩散:

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

返回顶部 返回列表