MAS开放平台

Appearance

本页目录

FIS 财政数智化支撑系统 ​

FIS（读音/fɪs/，来源于财政数智化支撑系统 Financial Intelligence Support System 的缩写）。

财政数智化支撑系统，基于全省财政行业背景，依托MAS模块化应用支撑平台和Locas低代码研发平台，为财政数智化建设提供系统功能支撑，包括全省财政单位机构管理、财政用户管理、预算单位管理、预算单位用户管理、业务条线管理、角色与岗位授权等，通过模块化应用搭建、低代码配置，实现快速交付、快速更新，适应财政数智化建设的快节奏创新迭代。

功能范围 ​

序号模块说明
1财政机构与用户管理实现多层级财政单位及内设机构和用户管理，支持分级授权
2单位机构与用户管理实现主管部门、预算单位等多层级单位及用户管理，支持单位自行授权
3业务条线管理实现财政业务条线处室对应关系管理
4角色与岗位授权实现基于岗位、角色的分级授权机制
5同步实现从浙政钉同步财政单位机构、用户数据；基于手机号从浙政钉匹配预算单位用户信息
6财政用户组实现财政用户分组管理，便于OA业务办理

详细说明 点击进入

平台基座要求 ​

  • [MAS >= v5.10.15]
  • [LOCAS >= v2.4]

注意：

  • 使用FIS系统后，请勿使用mas平台系统管理提供的账号管理、角色管理功能

版本 ​

v2.0.10，发布时间2023年10月26日

新增 ​

  • 财政预算单位（含主管）维护
  • 财政预算单位（含主管）用户维护
  • 财政预算单位（含主管）角色、岗位维护
  • 用户组管理
  • 财政账号跟一体化账号映射，解决一体化系统单点登录mas平台问题
  • 支持移动端调用

修改 ​

  • 将角色、账号、处室/预算单位的关联关系移至FIS系统维护（mas平台只能维护账号与角色的关系）
  • cz-uom 2.0.8 在cz-uom应用的actions里提供getUserInfo(ctx)方法懒加载缓存方式来获取，返回数据对象与之前cz-uom-store通过store获取保持一致 原store方式获取当前登录用户信息的方式保留，后期项目上切换完后将不再提供cz-uom-store应用 使用示例：
js
let userInfo = this.$app.ctx.app('cz-uom').getUserInfo(this.$app.ctx)
 userInfo.then(res=>{
   console.log('当前登录用户信息：',res)
 })

如何获取微服务镜像?

所有镜像可到容器仓库通过 docker pull 拉取

  • 武汉公司内网：192.168.1.10:5000/tangram/[微服务名]:[版本号]
  • 阿里云：registry.cn-hangzhou.aliyuncs.com/tangram/[微服务名]:[版本号]

如何获取微服务jar包?

所有正式发布版本可到私服仓库下载

如何获取微应用tgz包?

所有安装包可到阿里云OSS仓库下载

  • 路径：oss://foa5-oss/deploy/release/fis/[应用名称]/[版本号]/[应用名称]-[版本号].tgz 如：oss://foa5-oss/deploy/release/fis/cz-uom/2.0.8/cz-uom-2.0.8.tgz

微应用版本明细 ​

序号微应用Code版本号说明
1全省财政机构用户管理cz-uom2.0.8
2全省财政机构用户信息cz-uom-store2.0.0用于财政业务中store对象上获取当前登录用户信息

微服务版本明细 ​

  • 如需要同步浙政钉数据需部署mas平台扩展服务：mas-dingtalk
序号微应用Code版本号说明
1用户管理cz-uom-service2.0.10

1.0.x升级到2.0.10 ​

1、 cz-uom-service服务所在的库执行：

sql
CREATE TABLE "public"."cos_ys_positions" (
   "c_id" serial8 NOT NULL,
   "c_tenant_id" int4,
   "c_last_modifier" int8,
   "c_last_modify_time" timestamp(6),
   "c_creator" int8,
   "c_create_time" timestamp(6),
   "c_sort_number" int4,
   "c_main_job" BOOLEAN,
   "c_employee_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_organization_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_pos_unit_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_pos_job_rank_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_pos_inner_institution_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_job_attributes_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_pos_employee_role_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_visibility_indicator_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_order_in_organization" int8,
   "c_gmt_create" timestamp(6),
   "c_source" varchar(32) DEFAULT NULL,
   CONSTRAINT "cos_ys_positions_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_positions"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_main_job" IS '是否员工主任职';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_employee_code" IS '人员Code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_organization_code" IS '组织code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_emp_pos_unit_code" IS '所在单位Code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_pos_job_rank_code" IS '职务层次Code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_emp_pos_inner_institution_code" IS '所在内设机构Code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_job_attributes_code" IS '任职属性Code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_emp_pos_employee_role_code" IS '员工角色code';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_visibility_indicator_code" IS '可见性标签';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_order_in_organization" IS '组织内排序';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_gmt_create" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_positions"."c_source" IS '数据来源 0同步过来的数据 1自己新增的数据';

CREATE TABLE "public"."cos_ys_organizations" (
  "c_id" serial8 NOT NULL,
  "c_gmt_create" timestamp(6),
  "c_display_order" int4,
  "c_organization_code" varchar(255) COLLATE "pg_catalog"."default",
  "c_organization_name" varchar(255) COLLATE "pg_catalog"."default",
  "c_parent_code" varchar(255) COLLATE "pg_catalog"."default",
  "c_parent_name" varchar(255) COLLATE "pg_catalog"."default",
  "c_cascade" text COLLATE "pg_catalog"."default",
  "c_status" varchar(255) COLLATE "pg_catalog"."default",
  "c_type_code" varchar(255) COLLATE "pg_catalog"."default",
  "c_type_name" varchar(255) COLLATE "pg_catalog"."default",
  "c_business_strip_codes" varchar(255) COLLATE "pg_catalog"."default",
  "c_institution_level_code" varchar(255) COLLATE "pg_catalog"."default",
  "c_address" varchar(255) COLLATE "pg_catalog"."default",
  "c_division_code" varchar(255) COLLATE "pg_catalog"."default",
  "c_tenant_id" int8,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int4,
  "c_source" varchar(32) DEFAULT NULL,
  "c_xz_type" varchar(32) COLLATE "pg_catalog"."default",
  "c_unit_code" varchar(32) COLLATE "pg_catalog"."default",
  "c_gk_code" varchar(64) COLLATE "pg_catalog"."default",
  "c_xzqh_code" varchar(64),
  "c_cz_code" varchar(64),
  CONSTRAINT "cos_ys_organizations_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_gmt_create" IS '	创建时间';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_display_order" IS '排序码';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_organization_code" IS '组织code';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_organization_name" IS '显示名称';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_parent_code" IS '父组织Code';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_parent_name" IS '父组织名称';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_cascade" IS '级联关系';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_status" IS '组织状态';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_type_code" IS '组织类型Code';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_type_name" IS '组织类型名称';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_business_strip_codes" IS '条线codes,多个用|拼接';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_institution_level_code" IS '机构/单位级别';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_address" IS '详细地址';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_division_code" IS '行政区划code';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_source" IS '数据来源 0同步过来的数据 1自己新增的数据';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_xz_type" IS '行政类型 1单位 2处室';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_xzqh_code" IS '隶属财政的行政区划';
COMMENT ON COLUMN "public"."cos_ys_organizations"."c_cz_code" IS '隶属财政单位code';

CREATE TABLE "public"."cos_ys_employees" (
   "c_id" serial8 NOT NULL,
   "c_gmt_create" timestamp(6),
   "c_sys_account_id" int8,
   "c_account_id" int8,
   "c_account" varchar(255) COLLATE "pg_catalog"."default",
   "c_employee_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_employee_name" varchar(255) COLLATE "pg_catalog"."default",
   "c_status" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_gender" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_political_status_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_job_level_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_emp_budgeted_post_code" varchar(255) COLLATE "pg_catalog"."default",
   "c_tenant_id" int8,
   "c_last_modifier" int8,
   "c_last_modify_time" timestamp(6),
   "c_creator" int8,
   "c_create_time" timestamp(6),
   "c_sort_number" int4,
   "c_source" varchar(32) DEFAULT NULL,
   CONSTRAINT "cos_ys_employees_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_employees"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_gmt_create" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_sys_account_id" IS '系统平台的账号id';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_account_id" IS '人员id';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_account" IS '人员帐号';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_employee_code" IS '人员Code';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_employee_name" IS '人员姓名';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_status" IS '人员状态';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_emp_gender" IS '人员性别 Code';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_emp_political_status_code" IS '政治面貌';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_emp_job_level_code" IS '职级';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_emp_budgeted_post_code" IS '人员编制Code';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_employees"."c_source" IS '数据1来源 0同步过来的数据 1自己新增的数据';

--===================岗位
DROP TABLE IF EXISTS "public"."cos_ys_post_dept_account";
CREATE TABLE "public"."cos_ys_post_dept_account" (
  "c_id" serial8  NOT NULL,
  "c_tenant_id" int4,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int8,
  "c_post_id" int8,
  "c_account_id" int8,
  "c_organization_code" varchar(100) COLLATE "pg_catalog"."default",
  "c_unit_code" varchar(100) COLLATE "pg_catalog"."default",
  "c_site_id" int8,
  CONSTRAINT "cos_ys_post_dept_account_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_post_id" IS '岗位id';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_account_id" IS '账号id';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_organization_code" IS '组织机构code(处室)';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_unit_code" IS '财政单位code';
COMMENT ON COLUMN "public"."cos_ys_post_dept_account"."c_site_id" IS '站点id';
COMMENT ON TABLE "public"."cos_ys_post_dept_account" IS '岗位账号关联表';


DROP TABLE IF EXISTS "public"."cos_ys_post_dept";
CREATE TABLE "public"."cos_ys_post_dept" (
  "c_id" serial8 NOT NULL,
  "c_tenant_id" int4,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" numeric(11,0),
  "c_post_id" int8,
  "c_organization_code" varchar(100) COLLATE "pg_catalog"."default",
  "c_unit_code" varchar(100) COLLATE "pg_catalog"."default",
  CONSTRAINT "cos_ys_post_dept_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_post_id" IS '岗位id';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_organization_code" IS '组织机构code(处室)';
COMMENT ON COLUMN "public"."cos_ys_post_dept"."c_unit_code" IS '财政单位code';
COMMENT ON TABLE "public"."cos_ys_post_dept" IS '岗位处室关联表';



DROP TABLE IF EXISTS "public"."cos_ys_post";
CREATE TABLE "public"."cos_ys_post" (
   "c_id" serial8 NOT NULL,
   "c_tenant_id" numeric(11,0),
   "c_last_modifier" numeric(20,0),
   "c_last_modify_time" timestamp(6),
   "c_creator" numeric(20,0),
   "c_create_time" timestamp(6),
   "c_sort_number" numeric(11,0),
   "c_code" varchar(20) COLLATE "pg_catalog"."default",
   "c_name" varchar(50) COLLATE "pg_catalog"."default",
   "c_remark" varchar(4000) COLLATE "pg_catalog"."default",
   CONSTRAINT "cos_ys_post_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_post"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_post"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_post"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_post"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_post"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_post"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_post"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_post"."c_code" IS 'code';
COMMENT ON COLUMN "public"."cos_ys_post"."c_name" IS '名称';
COMMENT ON COLUMN "public"."cos_ys_post"."c_remark" IS '权限项code';
COMMENT ON TABLE "public"."cos_ys_post" IS '岗位表';


DROP TABLE IF EXISTS "public"."cos_ys_post_role";
CREATE TABLE "public"."cos_ys_post_role" (
  "c_id" serial8 NOT NULL,
  "c_tenant_id" int4,
  "c_last_modifier" int8,
  "c_last_modify_time" timestamp(6),
  "c_creator" int8,
  "c_create_time" timestamp(6),
  "c_sort_number" int8,
  "c_post_id" int8,
  "c_role_id" int8,
  "c_site_id" int8,
  CONSTRAINT "cos_ys_post_role_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_post_id" IS '岗位id';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_role_id" IS '账号id';
COMMENT ON COLUMN "public"."cos_ys_post_role"."c_site_id" IS '站点id';
COMMENT ON TABLE "public"."cos_ys_post_role" IS '岗位角色关联表';


DROP TABLE IF EXISTS "public"."cos_qscz_role_account_mapping";
CREATE TABLE "public"."cos_qscz_role_account_mapping" (
"c_id" serial8 NOT NULL,
"c_last_modifier" int8,
"c_last_modify_time" timestamp(6),
"c_creator" int8,
"c_create_time" timestamp(6),
"c_sort_number" int4,
"c_tenant_id" int8,
"c_role_id" int8,
"c_account_id" int8,
"c_organization_code" varchar(100),
"c_site_id" int8,
CONSTRAINT "cos_qscz_role_account_mapping_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_organization_code" IS '机构code';
COMMENT ON COLUMN "public"."cos_qscz_role_account_mapping"."c_site_id" IS '站点ID';
COMMENT ON TABLE "public"."cos_qscz_role_account_mapping" IS '财政角色用户关系表';



DROP TABLE IF EXISTS "public"."cos_ys_role_account_mapping";
CREATE TABLE "public"."cos_ys_role_account_mapping" (
"c_id" serial8 NOT NULL,
"c_last_modifier" int8,
"c_last_modify_time" timestamp(6),
"c_creator" int8,
"c_create_time" timestamp(6),
"c_sort_number" int4,
"c_tenant_id" int8,
"c_role_id" int8,
"c_account_id" int8,
"c_organization_code" varchar(100),
"c_site_id" int8,
CONSTRAINT "cos_ys_role_account_mapping_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_organization_code" IS '机构code';
COMMENT ON COLUMN "public"."cos_ys_role_account_mapping"."c_site_id" IS '站点ID';
COMMENT ON TABLE "public"."cos_ys_role_account_mapping" IS '预算角色用户关系表';




DROP TABLE IF EXISTS "public"."cos_user_role_info";
CREATE TABLE "public"."cos_user_role_info" (
   "c_id" serial8 NOT NULL,
   "c_tenant_id" numeric(11,0),
   "c_last_modifier" numeric(20,0),
   "c_last_modify_time" timestamp(6),
   "c_creator" numeric(20,0),
   "c_create_time" timestamp(6),
   "c_sort_number" int4,
   "c_role_code" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
   "c_role_name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
   "c_power_code" varchar(2000) COLLATE "pg_catalog"."default",
   "c_power_name" varchar(2000) COLLATE "pg_catalog"."default",
   "c_role_type" numeric(1,0) NOT NULL,
   "c_site_id" int8 NOT NULL,
   CONSTRAINT "cos_user_role_info_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_user_role_info"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_role_code" IS '角色code';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_role_name" IS '角色名称';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_power_code" IS '权限项code';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_power_name" IS '权限项名称';
COMMENT ON COLUMN "public"."cos_user_role_info"."c_role_type" IS '角色类型 0 应用角色 1 租户自定义角色';
COMMENT ON TABLE "public"."cos_user_role_info" IS '角色信息表';

DROP TABLE IF EXISTS "public"."cos_user_role_mapping";
CREATE TABLE "public"."cos_user_role_mapping" (
   "c_id" serial8 NOT NULL,
   "c_tenant_id" numeric(11,0),
   "c_last_modifier" numeric(20,0),
   "c_last_modify_time" timestamp(6),
   "c_creator" numeric(20,0),
   "c_create_time" timestamp(6),
   "c_sort_number" int4,
   "c_role_id" int8 NOT NULL,
   "c_account_id" int8 NOT NULL,
   "c_org_id" int8 NOT NULL,
   "c_site_id" int8 NOT NULL,
   CONSTRAINT "cos_user_role_mapping_pkey" PRIMARY KEY ("c_id")
)WITH (OIDS=TRUE);
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_role_id" IS '角色id';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_account_id" IS '账号id';
COMMENT ON COLUMN "public"."cos_user_role_mapping"."c_org_id" IS '机构id';
COMMENT ON TABLE "public"."cos_user_role_mapping" IS '账号角色关系表';


-- 增加用户或者机构导入记录表
DROP TABLE IF EXISTS "public"."cos_ys_import_recording";
CREATE TABLE "public"."cos_ys_import_recording" (
"c_id" serial8 NOT NULL,
"c_last_modifier" int8,
"c_last_modify_time" TIMESTAMP ( 6 ),
"c_creator" int8,
"c_create_time" TIMESTAMP ( 6 ),
"c_sort_number" int4,
"c_tenant_id" int8,
"c_type" VARCHAR ( 10 ) COLLATE "pg_catalog"."default",
"c_status" VARCHAR ( 10 ) COLLATE "pg_catalog"."default",
"c_ref_id" VARCHAR ( 255 ) COLLATE "pg_catalog"."default",
"c_result" VARCHAR ( 500 ) COLLATE "pg_catalog"."default",
CONSTRAINT "cos_ys_import_recording_pkey" PRIMARY KEY ( "c_id" )
) WITH ( OIDS = TRUE );
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_id" IS '主键';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_last_modifier" IS '修改人';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_last_modify_time" IS '修改时间';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_creator" IS '创建人';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_create_time" IS '创建时间';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_sort_number" IS '排序号';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_tenant_id" IS '租户ID';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_type" IS '类型';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_status" IS '状态: 1执行中 2成功 3失败';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_ref_id" IS '错误文件refId';
COMMENT ON COLUMN "public"."cos_ys_import_recording"."c_result" IS '导入结果';

2、 cz-uom-service服务所在的库执行：

sql
-- 单位用户表增加字段
ALTER TABLE "public"."cos_ys_employees"
ADD COLUMN "c_account1" varchar(50);
COMMENT ON COLUMN "public"."cos_ys_employees"."c_account1" IS '账号前缀(行政区划)';

ALTER TABLE "public"."cos_ys_employees"
ADD COLUMN "c_account2" varchar(50);
COMMENT ON COLUMN "public"."cos_ys_employees"."c_account2" IS '账号后缀(账号名)';

3、公权力、财政大脑站点迁移账号角色关联至FIS系统【不影响业务，可以使用FIS系统的“财政角色授权”菜单进行界面操作】 公权力迁移脚本地址：oss://foa5-oss/deploy/fis/2.0.0-updatesqls/gql-update2uom.txt 财政大脑迁移脚本地址：oss://foa5-oss/deploy/fis/2.0.0-updatesqls/jzclbds-update2uom.txt

4、 解决一体化单点登录平台账号映射处理、多个账号共浙政钉UID问题（需要mas平台升级至5.10.15）【非必须，根据实际情况执行】：

  • 将t_share_operator与t_share_useridtozzd这2张表复制到cz-uom服务连接的库里面

  • 更新cz-uom前端应用包后，在其“财政人员管理”菜单页面中点击“账号映射一体化”按钮（因需要处理的数据量较大，需要等待一段时间）

  • 在mas-admin服务连的库中执行【注意：先将？替换为对应的租户id】：

sql
update cos_admin_account_info set c_login_alias = c_login_name where c_login_name like '%\_3%' and c_tenant_id = ? and c_login_alias is null;

2.0.9升级到2.0.10 ​

1、 解决一体化单点登录平台账号映射处理、多个账号共浙政钉UID问题（需要mas平台升级至5.10.15）：

  • 将t_share_operator与t_share_useridtozzd这2张表复制到cz-uom服务连接的库里面

  • 更新cz-uom前端应用包后，在其“财政人员管理”菜单页面中点击“账号映射一体化”按钮（因需要处理的数据量较大，需要等待一段时间）

  • 在mas-admin服务连的库中执行【注意：先将？替换为对应的租户id】：

sql
update cos_admin_account_info set c_login_alias = c_login_name where c_login_name like '%\_3%' and c_tenant_id = ? and c_login_alias is null;

初始化安装 ​

  • FIS系统polardb数据库环境全新安装脚本获取地址：oss://foa5-oss/deploy/fis-polardb-sqls/2.0.1/full-init.sql

  • 部署说明点击进入

内部资料，请勿外传

Copyright © 2010-2023 中科天翔