【融和】权限中台生产数据修改汇总
导出dpad启源的标签人员信息
-- 主管,取层级, 非主管,取管辖范围
select l.`label_name`, a.`user_name`, orgs.ranges from `account_label` al
left join label l on l.id = al.`label_id` and l.`is_deleted` = 0
left join account a on a.id = al.`account_id` and a.`is_deleted` = 0
left join (select lo.`account_label_id` , GROUP_CONCAT(o.name) as ranges from label_org lo inner join `organization` o on o.id = lo.`organization_id` and o.`is_deleted` = 0
where lo.`is_deleted` = 0 and lo.`source_type` = 'group'
GROUP BY lo.`account_label_id`) orgs on al.id = orgs.account_label_id
where al.`is_deleted` = 0
and al.`label_id` in (select id from label where `application_id` = 1010001 and `company_id` = 1000001)
and l.`label_name` = '主管'
union all
select l.`label_name`, a.`user_name`, orgs.ranges from `account_label` al
left join label l on l.id = al.`label_id` and l.`is_deleted` = 0
left join account a on a.id = al.`account_id` and a.`is_deleted` = 0
left join (select lo.`account_label_id` , GROUP_CONCAT(o.name) as ranges from label_org lo inner join `organization` o on o.id = lo.`organization_id` and o.`is_deleted` = 0
where lo.`is_deleted` = 0 and lo.`source_type` = 'range'
GROUP BY lo.`account_label_id`) orgs on al.id = orgs.account_label_id
where al.`is_deleted` = 0
and al.`label_id` in (select id from label where `application_id` = 1010001 and `company_id` = 1000001)
and l.`label_name` <> '主管'
;
SYS-29894 图远系保留所有用户的查看权限,去掉新增、编辑等相关权限
update role_function set is_deleted = 1 where `is_deleted` = 0
and `role_id` in (select id
from `role`
where `company_id` in
(1000226,1000228,1000001002,1000002000,1000003000,1000004000,1000004030,1000004080,1000004260,1000005100,1000008204)
and `application_id` = 1010001
and `is_deleted` = 0)
and `function_id` in (select id
from `function_code`
where `application_id` = 1010001
and `is_deleted` = 0
and type = 'button'
and `name` not like '%查看%'
and `name` not like '%详情%'
and `name` not like '%下载%'
and `name` not like '%明细%'
and `name` not like '%导出%'
and `name` not like '%报表%'
and `name` not like '%统计%'
and `name` not like '%记录%'
and `name` not like '%列表'
and `name` not like '%打印%'
and `name` not like '%信息'
and `name` not like '%查询'
and `name` not like '%管理'
and `name` not in
('上线日志', '预览', '审批履历', '组织架构', '入库任务', '物流', '库存确认任务',
'商业伙伴', '资产清单',
'现金流', '合同文本', '现金流', '现金流-付款项', '租赁物方案', '文件归档', '交付申请',
'销售方案', '承租物方案', '换电站', '车辆', '内部租赁', '租售决策', '业务类采购决策',
'其他业务决策', '采购决策任务',
'充换电服务决策', '审批流程监控', '看关联交付申请', '现金流-收款项')
order by `code`);
备注:
恢复的话在角色管理全部勾选即可。
更改后页面没有任何变化,需要先重新登录。
dpad 合资公司创建分配佳慧为管理员
INSERT INTO `account_role` (`role_id`, `account_id`, `create_by`, `create_name`, `update_by`, `update_name`, `create_org_code`, `is_deleted`, `company_id`, `ordinal`)
value (1000027455,1000025520, 0, '', 0, '', 0, 0, 1000009486, 0);
INSERT INTO `org_account` (`org_id`,`account_id`, `ordinal`, `create_by`, `create_name`, `update_by`, `update_name`, `create_org_code`, `is_deleted`, `create_app_id`)
value (1100113751, 1000025520, 00000000000, 0, '', 0, '', '0', b'0', 0);
insert into user_company (company_id, user_id, default_company, is_deleted) value (1000009486,1000010490,0,0);
最后更新于