GHSCPartyBuild/lib/数据更新脚本.txt

--2024.6.26 党政联席会、民主集中制

-- 会议表新增主持人、列会人员、会议主要议程及结果字段
alter table pf_partylifemeeting add compere varchar(36) NULL COMMENT '主持人';
alter table pf_partylifemeeting add personnel varchar(500) NULL COMMENT '列会人员';
alter table pf_partylifemeeting add result varchar(1000) NULL COMMENT '会议主要议程及结果';

CREATE TABLE `pf_partylifemeeting_personnel`  (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `partyLifeMeetingId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会议id',
  `rybm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '人员编码',
  `isAbsenteeism` int NULL DEFAULT NULL COMMENT '是否缺勤 0-缺勤；1-出勤',
  `absenteeismCause` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '缺勤原因',
  `createTime` datetime NULL DEFAULT NULL,
  `createUserId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `updateTime` datetime NULL DEFAULT NULL,
  `updateUserId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

-- 字典
INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-829d-7085c2a00001', 4, '党政联席会', 'PartyLifeMeetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-829d-7085c2a00002', 5, '民主集中制', 'PartyLifeMeetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');

-- 菜单
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4806821b-b18e-11ec-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 18, 'home.pf_meetingList4', '党政联席会', NULL, NULL, NULL, 1, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900001', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a9999e', NULL, 1, 'home.pf_meetingEdit4', '编辑党政联席会', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900002', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a9999e', NULL, 2, 'home.pf_meetingAdd4', '新增党政联席会', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900003', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a9999e', NULL, 3, 'home.pf_meetingDetail4', '查看党政联席会详情', NULL, NULL, NULL, 0, 0, NULL);

INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4806821b-b18e-11ec-829d-7085c2a99990', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 1, 'home.pf_meetingList5', '民主集中制', NULL, NULL, NULL, 1, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900011', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99990', NULL, 1, 'home.pf_meetingEdit5', '编辑民主集中制', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900022', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99990', NULL, 2, 'home.pf_meetingAdd5', '新增民主集中制', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900033', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99990', NULL, 3, 'home.pf_meetingDetail5', '查看民主集中制详情', NULL, NULL, NULL, 0, 0, NULL);


-- 组织生活会议 “三重一大”副表
CREATE TABLE `pf_partylifemeeting_scyd`  (
  `partyLifeMeetingId` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会议id',
  `scydType` int NOT NULL COMMENT '“三重一大”类别  1-重大事项决策、2-重要干部任免、3-重大项目投资决策、4-大额资金使用',
  PRIMARY KEY (`partyLifeMeetingId`,`scydType`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;


INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-829d-7085c2a00003', 6, '“三重一大”制度', 'PartyLifeMeetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');

INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-0001-7085c2a00003', 1, '重大事项决策', 'scydType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-0002-7085c2a00003', 2, '重要干部任免', 'scydType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-0003-7085c2a00003', 3, '重大项目投资决策', 'scydType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');
INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-0004-7085c2a00003', 4, '大额资金使用', 'scydType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n');


INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4806821b-b18e-11ec-829d-7085c2a99991', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 2, 'home.pf_scydMeetingList', '“三重一大”制度', NULL, NULL, NULL, 1, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900111', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99991', NULL, 1, 'home.pf_scydMeetingEdit', '编辑“三重一大”制度', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900122', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99991', NULL, 2, 'home.pf_scydMeetingAdd', '新增“三重一大”制度', NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('873f7565-0dd8-4a1c-877a-06f6e2900133', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4806821b-b18e-11ec-829d-7085c2a99991', NULL, 3, 'home.pf_scydMeetingDetail', '查看“三重一大”制度详情', NULL, NULL, NULL, 0, 0, NULL);


---7.04 党建工作考核建表
create table pt_checkData
(
    dataId               varchar(36) not null comment '唯一标识',
    dzzdm                varchar(300) comment '组织代码',
    year                 int comment '考核资料文件标识',
    remark               varchar(300) comment '备注',
    leadingDepartment    varchar(200) comment '考核资料是否上传',
    checkDataUserId      varchar(36) comment '考核资料上传人',
    checkDataUserName    varchar(36) comment '考核资料上传人姓名',
    recordStatus         int comment '状态',
    createTime           datetime comment '创建时间',
    createUserId         varchar(36) comment '创建人id',
    createUserName       varchar(300) comment '创建人姓名',
    updateTime           datetime comment '修改时间',
    updateUserId         varchar(36) comment '修改人id',
    updateUserName       varchar(300) comment '修改人姓名',
    primary key (dataId)
);

alter table pt_checkData comment '考核材料';

create table pt_checkNameList
(
    nameId               varchar(36) not null comment '唯一标识',
    dzzdm                varchar(300) comment '所在组织代码',
    year                 int comment '年度',
    quarter              int comment '季度',
    checkUserId          varchar(36) comment '核查人',
    checkUserName        varchar(36) comment '核查人姓名',
    recordStatus         int comment '状态1、启用0、禁用',
    createTime           datetime comment '创建时间',
    createUserId         varchar(36) comment '创建人id',
    createUserName       varchar(300) comment '创建人姓名',
    primary key (nameId)
);

alter table pt_checkNameList comment '考核名单';

create table pt_checkParty
(
    partyId              varchar(36) not null comment '唯一标识',
    nameId               varchar(36) comment '关联名单',
    partyCode            varchar(60) comment '支部代码',
    partyName            varchar(200) comment '支部名称',
    primary key (partyId)
);

alter table pt_checkParty comment '考核名单检查支部';

alter table pt_checkParty add constraint FK_Reference_43 foreign key (nameId)
    references pt_checkNameList (nameId) on delete restrict on update restrict;

create table pt_checkScore
(
    scoreId              varchar(36) not null comment '唯一标识',
    dzzdm                varchar(300) comment '组织代码',
    year                 int comment '考核资料文件标识',
    quarter              int comment '季度',
    checkUserId          varchar(36) comment '核查人',
    checkUserName        varchar(36) comment '核查人姓名',
    score                decimal(8,2) comment '评分',
    recordStatus         int comment '状态1、已评分0、未评分',
    primary key (scoreId)
);

alter table pt_checkScore comment '考核评分';

create table pt_checkQuestion
(
    questionId           varchar(36) not null comment '唯一标识',
    scoreId              varchar(36) comment '关联评分',
    questionName         varchar(260) comment '问题名称',
    questionDesc         varchar(500) comment '问题描述',
    primary key (questionId)
);

alter table pt_checkQuestion comment '考核问题';

alter table pt_checkQuestion add constraint FK_Reference_42 foreign key (scoreId)
    references pt_checkScore (scoreId) on delete restrict on update restrict;

create table pt_reportData
(
    reportId             varchar(36) not null comment '唯一标识',
    dzzdm                varchar(300) comment '组织代码',
    year                 int comment '年度',
    reportUserId         varchar(36) comment '述职人',
    reportUserName       varchar(36) comment '述职人姓名',
    recordStatus         int comment '状态1:已经上传0：未上传',
    createTime           datetime comment '创建时间',
    createUserId         varchar(36) comment '创建人id',
    createUserName       varchar(300) comment '创建人姓名',
    updateTime           datetime comment '修改时间',
    updateUserId         varchar(36) comment '修改人id',
    updateUserName       varchar(300) comment '修改人姓名',
    primary key (reportId)
);

alter table pt_reportData comment '述职材料';


create table pt_reportScore
(
    scoreId              varchar(36) not null comment '唯一标识',
    reportId             varchar(36) comment '关联述职材料',
    writtenScore         decimal(8,2) comment '书面述职评分',
    sceneScore           decimal(8,2) comment '现场述职评分',
    dailyScore           decimal(8,2) comment '日常党建工作考核评分',
    total                decimal(8,2) comment '述职评分（总分）',
    remark               varchar(360) comment '备注',
    reportResult         int comment '评议结果',
    createTime           datetime comment '创建时间',
    createUserId         varchar(36) comment '创建人id',
    createUserName       varchar(300) comment '创建人姓名',
    updateTime           datetime comment '修改时间',
    updateUserId         varchar(36) comment '修改人id',
    updateUserName       varchar(300) comment '修改人姓名',
    primary key (scoreId)
);

alter table pt_reportScore comment '述职评分';

alter table pt_reportScore add constraint FK_Reference_44 foreign key (reportId)
    references pt_reportData (reportId) on delete restrict on update restrict;

---7.04 党建工作考核管理菜单
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('f237844c-2194-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a2640551-3b11-484b-9420-4376641a760c', null, 8, 'workCheckMgr', '党建工作考核管理', null, null, '', 1, 0, null);
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('f237844c-4494-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-2194-430f-bef7-ea68469c9f33', null, 1, 'home.checkNameList', '核查名单管理', null, null, '', 1, 0, null);
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('f237844c-5594-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-2194-430f-bef7-ea68469c9f33', null, 2, 'home.checkData', '考核材料管理', null, null, '', 1, 0, null);
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('f237844c-6694-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-2194-430f-bef7-ea68469c9f33', null, 3, 'home.checkScore', '考核评分管理', null, null, '', 1, 0, null);

INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('f237844c-2194-430f-bef7-ea68469c9f44', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a2640551-3b11-484b-9420-4376641a760c', null, 9, 'reportScoreMgr', '述职评议管理', null, null, '', 1, 0, null);
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('1137844c-2194-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-2194-430f-bef7-ea68469c9f44', null, 1, 'home.reportData', '上传述职材料', null, null, '', 1, 0, null);
INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK)
VALUES ('2237844c-2194-430f-bef7-ea68469c9f33', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-2194-430f-bef7-ea68469c9f44', null, 2, 'home.reportScore', '上传述职材料', null, null, '', 1, 0, null);