【融和】权限中台生产数据修改汇总

导出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`);

备注：

1. 恢复的话在角色管理全部勾选即可。

2. 更改后页面没有任何变化，需要先重新登录。

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);