INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('9912122b-15d2-4e93-ac5e-06e4b091ee65', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, null, 20, '大数据分析', '大数据分析', null, 'trending_up', null, 1, 0, null); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('9cbf8369-9b94-4baf-b75d-3e3bf045a4d1', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 10, 'home.bigdataList', '大数据维护', null, null, null, 1, 1, null); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('432db382-6a35-4788-b6d8-2b0e85785f49', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 2, '../main/index-dsj.html#!/showDjdsj', '党建概况', null, null, null, 1, 1, 1); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('67ddad23-18a3-4336-b3ca-f148ff220589', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 4, '../main/index-dsj.html#!/showDjdsj_dwgzz', '党务工作者', null, null, null, 1, 1, 1); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('3c57eec8-fcb7-4cbd-a910-92633f2d8874', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 3, '../main/index-dsj.html#!/teams', '党员队伍', null, null, null, 1, 1, 1); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('e1c6f537-cc54-4f39-939a-afb65ae7086b', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '9912122b-15d2-4e93-ac5e-06e4b091ee65', null, 5, '../main/index-dsj.html#!/showDjdsj_dwdt', '党务动态', null, null, null, 1, 1, 1); --7.05 update cf_menu set MENUNO='home.reportDataScore',MENUNAME='述职评议评分' where MENUID='2237844c-2194-430f-bef7-ea68469c9f33'; --7.06 INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('4c6f7f03-453e-4fd1-af0e-61f702ee649b', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1137844c-2194-430f-bef7-ea68469c9f33', null, 1, 'reportData.generate', '生成述职名单', null, null, '', 0, 1, null); INSERT INTO CF_MENU (MENUID, APPLICATIONID, PARENTMENUID, MNUSYSTEM, MENUORDER, MENUNO, MENUNAME, MENUPROGRAM, MENUPIC, MENUDESC, ISVISIBLE, ISLEAF, ISBLANK) VALUES ('56f0b4b0-467a-4b15-b394-e5f86542921c', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1137844c-2194-430f-bef7-ea68469c9f33', null, 2, 'reportData.downZip', '打包下载', null, null, '', 0, 1, null); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-re1c-829d-cc85c2a00001', 1, '优秀', 'reportResult', 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-re2c-829d-dd85c2a00002', 2, '好', 'reportResult', 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-re3c-829d-dd85c2a00002', 3, '一般', 'reportResult', 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-re4c-829d-dd85c2a00002', 4, '差', 'reportResult', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', NULL, '2022-04-01 15:45:10', 'a', 'n'); -- 2024.7.11 专题建设 -- ---------------------------- -- Table structure for zz_mzpyxx -- ---------------------------- DROP TABLE IF EXISTS `pf_dnjzjy`; CREATE TABLE `pf_dnjzjy` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '面向对象（选择党组织）', `jykssj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育开始时间', `jyjssj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育结束时间', `zt` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主题', `zygzbz` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主要工作步骤', `qddcx` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '取得的成效', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党内集中教育'; SET FOREIGN_KEY_CHECKS = 1; -- 党建“双创”工作 DROP TABLE IF EXISTS `pf_djscgz`; CREATE TABLE `pf_djscgz` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '党组织（工作室）名称', `pxqdsj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评选启动时间', `pxjgqdsj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评选结果确定时间', `pxjb` int NULL DEFAULT NULL COMMENT '评选级别 pxjbType', `pxlb` int NULL DEFAULT NULL COMMENT '评选类别 pxlbType', `zygzbz` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主要工作步骤', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党建“双创”工作'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0001-0000-bdb74a278a72', 1, '国家级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0002-0000-bdb74a278a72', 2, '省级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0003-0000-bdb74a278a72', 3, '市级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0004-0000-bdb74a278a72', 4, '校级', 'pxjbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选级别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0011-0000-bdb74a278a72', 1, '示范高校', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0022-0000-bdb74a278a72', 2, '标杆院系', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0033-0000-bdb74a278a72', 3, '样板支部', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0044-0000-bdb74a278a72', 4, '“双带头人”教师党支部书记工作室', 'pxlbType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '评选类别', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-43db-8946-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 6, '专题建设', '专题建设', '', '', '', 1, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-0000-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 2, 'home.pf_dnjzjyAdd', '新增党内集中教育', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-0001-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 3, 'home.pf_dnjzjyDetail', '查看党内集中教育详情', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('bc66c398-074a-435c-82c1-126d465d1239', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-28bf-4051-813c-4e95032b6937', NULL, 1, 'home.pf_dnjzjyEdit', '编辑党内集中教育', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-28bf-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-43db-8946-b24618f90175', NULL, 1, 'home.pf_dnjzjyList', '党内集中教育', '', '', '', 1, 0, 0); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0003-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 2, 'home.pf_djscgzAdd', '新增党建“双创”工作', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0002-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 3, 'home.pf_djscgzDetail', '查看党建“双创”工作详情', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0001-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e6b08580-0000-4051-813c-4e95032b6937', NULL, 1, 'home.pf_djscgzEdit', '编辑党建“双创”工作', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e6b08580-0000-4051-813c-4e95032b6937', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-43db-8946-b24618f90175', NULL, 2, 'home.pf_djscgzList', '党建“双创”工作', '', '', '', 1, 0, 0); -- 2024.7.11 党风廉政建设 -- 纪律教育学习月活动 DROP TABLE IF EXISTS `pf_jljyxxyhd`; CREATE TABLE `pf_jljyxxyhd` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属党组织', `hdmc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '活动名称', `rq` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '日期', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'纪律教育学习月活动'; SET FOREIGN_KEY_CHECKS = 1; -- 纪律教育学习月活动-统计明细表 DROP TABLE IF EXISTS `pf_jljyxxyhd_fb`; CREATE TABLE `pf_jljyxxyhd_fb` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `jljyxxyhd_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '纪律教育学习月活动id', `zdgz` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '重点工作', `mc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称', `sj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时间', `jydx` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教育对象', `cjrs` int NULL DEFAULT NULL COMMENT '参加人数', `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'纪律教育学习月活动-统计明细表'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-8946-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 7, '党风廉政建设', '党风廉政建设', '', '', '', 1, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0003-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 3, 'home.pf_jljyxxyhdDetail', '查看纪律教育学习月活动详情', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0002-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 2, 'home.pf_jljyxxyhdAdd', '新增纪律教育学习月活动', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0001-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-0000-b24618f90175', NULL, 1, 'home.pf_jljyxxyhdEdit', '编辑纪律教育学习月活动', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-0000-0000-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-8946-b24618f90175', NULL, 1, 'home.pf_jljyxxyhdList', '纪律教育学习月活动', '', '', '', 1, 0, 0); -- 2024.7.12 听取党风廉政管理 alter table pf_partylifemeeting add meetingType int COMMENT '会议类型 meetingType'; INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0001-9999-bdb74a278a72', 1, '听取党风廉政会议', 'meetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '会议类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-7417-0002-9999-bdb74a278a72', 2, '其他党风廉政', 'meetingType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '会议类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('23f5e615-b16a-11ec-829d-7085c2a00007', 7, '听取党风廉政管理', '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 ('1f783c90-a760-9999-0003-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 3, 'home.pf_tqdflzhyMeetingDetail', '查看听取党风廉政管理详情', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0002-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 2, 'home.pf_tqdflzhyMeetingAdd', '新增听取党风廉政管理', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0001-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-9999-0000-b24618f90175', NULL, 1, 'home.pf_tqdflzhyMeetingEdit', '编辑听取党风廉政管理', '', '', '', 0, 0, 1); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1f783c90-a760-9999-0000-b24618f90175', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1f783c90-a760-0000-8946-b24618f90175', NULL, 1, 'home.pf_tqdflzhyMeetingList', '听取党风廉政管理', '', '', '', 1, 0, 0); -- 2024.7.15 党员学习教育-党组织风采 DROP TABLE IF EXISTS `pub_dzzfc`; CREATE TABLE `pub_dzzfc` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所在组织', `ztmc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主题名称', `fc_type` int NULL DEFAULT NULL COMMENT '类型 fcType', `jj` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '简介', `nr` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内容', `sj` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '时间', `lj` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '链接', `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'党组织风采'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1b7e571e-0000-4475-9e24-98636ba0bd76', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '70958848-d81c-4679-9d89-11b5a5998060', NULL, 4, 'home.pub_dzzfcList', '党组织风采', '', '', '', 1, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('15c3ea7a-0000-4914-a17d-c985164e9428', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 1, 'pub_dzzfcList.btnAdd', '新增', NULL, NULL, NULL, 0, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('cb3e03df-0000-4e66-b8d8-93f707dbdaa1', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 2, 'pub_dzzfcList.btnUpdate', '编辑', NULL, NULL, NULL, 0, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('2067919a-0000-4a95-ba14-b84bf6100ced', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 3, 'pub_dzzfcList.btnDelete', '删除', NULL, NULL, NULL, 0, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('cd7e7a09-0000-4bbc-8246-36f7b0f62bcd', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 11, 'home.pub_dzzfcAdd', '新增党组织风采信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('8638ba30-0000-4487-8c78-2e953857e6d4', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 12, 'home.pub_dzzfcEdit', '修改党组织风采信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f6ec1d5a-0000-47c0-bb7e-ce03f7eaf575', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0000-4475-9e24-98636ba0bd76', NULL, 13, 'home.pub_dzzfcDetail', '查看党组织风采信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-0001-9999-bdb74a278a72', 1, '媒体报道', 'fcType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '风采类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-0002-9999-bdb74a278a72', 2, '其他', 'fcType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '风采类型', '2019-09-26 15:13:15', 'M', 'N'); ---7.18 INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('3e8addee-6666-4c46-94d8-111138164863', 1, '待考试', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N'); INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-7777-4710-90fd-222e6bb77993', 2, '考试中', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N'); INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-8888-4710-90fd-222e6bb77993', 3, '已交卷', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N'); INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-9999-4710-90fd-333e6bb77993', 4, '缺考', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N'); INSERT INTO CF_DICTIONARY (DICTIONARYID, DICKEY, DICVALUE, DICTYPEKEY, DICTYPE, APPLICATIONID, DICNOTE, OPERATETIME, OPERATESTATE, SYNCSTATE) VALUES ('855867d0-0000-4710-90fd-333e6bb77993', 5, '已公布成绩', 'testmanRecordStauts', 1, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', null, TIMESTAMP '2022-04-20 16:51:33', 'A', 'N'); -- 2024.7.19 alter table cf_users add wxUserId varchar(50); -- 2024.7.22 delete from zzzd_jczzflnew; insert into zzzd_jczzflnew values('100','党委',10,null,null,null); insert into zzzd_jczzflnew values('200','院系',20,null,null,null); insert into zzzd_jczzflnew values('300','综合',30,null,null,null); insert into zzzd_jczzflnew values('400','离退休',40,null,null,null); insert into zzzd_jczzflnew values('500','其他',50,null,null,null); update zz_zzqkxxfb set JCZZFL=null; update zz_zzqkxxfb fb inner join zz_zzqkxx p on p.dzzdm = fb.dzzdm set fb.JCZZFL='100' where p.dzzmc like '%党委%'; update zz_zzqkxxfb fb inner join zz_zzqkxx p on p.dzzdm = fb.dzzdm set fb.JCZZFL='300' where p.dzzmc like '%综合%'; update zz_zzqkxxfb fb inner join zz_zzqkxx p on p.dzzdm = fb.dzzdm set fb.JCZZFL='400' where p.dzzmc like '%离退休%'; update zz_zzqkxxfb fb inner join zz_zzqkxx p on p.dzzdm = fb.dzzdm set fb.JCZZFL='200' where fb.JCZZFL is null; -- 2024.7.22 -- 民主生活会 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4189070a-b18e-0001-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4189070a-b18e-11ec-829d-7085c2a9999e', NULL, 1, 'home.pf_meetingEdit2', '编辑民主生活会', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4189070a-b18e-0002-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4189070a-b18e-11ec-829d-7085c2a9999e', NULL, 2, 'home.pf_meetingAdd2', '新增民主生活会', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4189070a-b18e-0003-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '4189070a-b18e-11ec-829d-7085c2a9999e', NULL, 3, 'home.pf_meetingDetail2', '查看民主生活会详情', NULL, NULL, NULL, 0, 0, NULL); -- 组织生活会 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('3e8c2439-b18e-0001-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '3e8c2439-b18e-11ec-829d-7085c2a9999e', NULL, 1, 'home.pf_meetingEdit1', '编辑组织生活会', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('3e8c2439-b18e-0002-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '3e8c2439-b18e-11ec-829d-7085c2a9999e', NULL, 2, 'home.pf_meetingAdd1', '新增组织生活会', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('3e8c2439-b18e-0003-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '3e8c2439-b18e-11ec-829d-7085c2a9999e', NULL, 3, 'home.pf_meetingDetail1', '查看组织生活会详情', NULL, NULL, NULL, 0, 0, NULL); -- 2024.7.25 干部培训记录管理 DROP TABLE IF EXISTS `px_training_record`; CREATE TABLE `px_training_record` ( `id` 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 NOT NULL COMMENT '人员编码', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名（可选择系统中的人员，如非系统人员可直接输入姓名）', `pxdxlx` int NULL DEFAULT NULL COMMENT '培训对象类型pxdxlxType（中层干部、青年干部、党务纪检干部、其他）', `gender` int NULL DEFAULT NULL COMMENT '性别', `sfzh` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '身份证号', `gzbm` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '工作部门', `zw` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '职务', `pxxmmc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '培训项目名称', `pxxs` int NULL DEFAULT NULL COMMENT '培训形式pxxsType（面授、研讨会、专题讲座、网络培训、实践研学、其它）', `xxkssj` date NULL DEFAULT NULL COMMENT '学习开始时间', `xxjssj` date NULL DEFAULT NULL COMMENT '学习结束时间', `cxts` int NULL DEFAULT NULL COMMENT '参训天数', `xss` int NULL DEFAULT NULL COMMENT '学时数', `khqk` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考核情况', `ssjgmc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '实施机构名称', `xxdd` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学习地点', `xxnr` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学习内容', `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'干部培训记录管理'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('0af16d13-c7f9-494e-0000-333edf772bbb', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e1a2a3cc-0001-404b-b58e-517e4a9f3aef', NULL, 1, 'home.PxTrainingRecordAdd', '新增干部培训记录管理', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('43820be1-c1fb-49bc-0000-218cc17947e1', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e1a2a3cc-0001-404b-b58e-517e4a9f3aef', NULL, 2, 'home.PxTrainingRecordEdit', '编辑干部培训记录管理', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('4aaeb0a8-0657-4dda-0000-cb21c08f26f2', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'e1a2a3cc-0001-404b-b58e-517e4a9f3aef', NULL, 3, 'home.PxTrainingRecordDetail', '查看干部培训记录管理详情', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('e1a2a3cc-0001-404b-b58e-517e4a9f3aef', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '996c7331-1f94-48f0-b246-d6ddb178ae7f', NULL, 13, 'home.PxTrainingRecordList', '干部培训记录管理', '', '', '', 1, 0, NULL); -- 培训对象类型pxdxlxType（中层干部、青年干部、党务纪检干部、其他） INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-1001-9999-bdb74a278a72', 1, '中层干部', 'pxdxlxType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训对象类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-2002-9999-bdb74a278a72', 2, '青年干部', 'pxdxlxType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训对象类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-3002-9999-bdb74a278a72', 3, '党务纪检干部', 'pxdxlxType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训对象类型', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-4002-9999-bdb74a278a72', 4, '其他', 'pxdxlxType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训对象类型', '2019-09-26 15:13:15', 'M', 'N'); -- 培训形式pxxsType（面授、研讨会、专题讲座、网络培训、实践研学、其它） INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-1101-9999-bdb74a278a72', 1, '面授', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-2202-9999-bdb74a278a72', 2, '研讨会', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-3302-9999-bdb74a278a72', 3, '专题讲座', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-4402-9999-bdb74a278a72', 4, '网络培训', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-4502-9999-bdb74a278a72', 5, '实践研学', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('058a7fc0-0000-4602-9999-bdb74a278a72', 6, '其他', 'pxxsType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '培训形式', '2019-09-26 15:13:15', 'M', 'N'); -- 2024.7.26 -- 培训班管理 DROP TABLE IF EXISTS `px_training_class`; CREATE TABLE `px_training_class` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '录入组织', `training_class_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '培训班名称', `begin_date` datetime NULL DEFAULT NULL COMMENT '培训开始时间', `end_date` datetime NULL DEFAULT NULL COMMENT '培训结束时间', `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '培训详细地址', `department` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主办部门', `contact_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系人', `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话', `content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '培训内容', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'培训班管理'; SET FOREIGN_KEY_CHECKS = 1; -- 培训班报名人员 DROP TABLE IF EXISTS `px_training_class_user`; CREATE TABLE `px_training_class_user` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `training_class_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '培训班id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '所属组织', `user_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '人员编码', `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '姓名', `gender_id` int NULL DEFAULT NULL COMMENT '性别', `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'培训班报名人员'; SET FOREIGN_KEY_CHECKS = 1; -- 培训班课程 DROP TABLE IF EXISTS `px_training_class_course`; CREATE TABLE `px_training_class_course` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `training_class_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '培训班id', `course_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '课程名称', `teacher` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '授课老师', `training_time` datetime NULL DEFAULT NULL COMMENT '培训时间', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'培训班课程'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('1b7e571e-0001-4475-9e24-98636ba0bd76', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '70958848-d81c-4679-9d89-11b5a5998060', NULL, 1, 'home.pxTrainingClassList', '培训班管理', '', '', '', 1, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('8638ba30-0002-4487-8c78-2e953857e6d4', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0001-4475-9e24-98636ba0bd76', NULL, 1, 'home.pxTrainingClassEdit', '修改培训班信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('cd7e7a09-0003-4bbc-8246-36f7b0f62bcd', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0001-4475-9e24-98636ba0bd76', NULL, 2, 'home.pxTrainingClassAdd', '新增培训班信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f6ec1d5a-0004-47c0-bb7e-ce03f7eaf575', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0001-4475-9e24-98636ba0bd76', NULL, 3, 'home.pxTrainingClassDetail', '查看培训班信息', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f6ec1d5a-0004-47c0-bb7e-ce03f7eaf575', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '1b7e571e-0001-4475-9e24-98636ba0bd76', NULL, 3, 'home.pxTrainingClassCourseList', '授课课程', NULL, NULL, NULL, 0, 0, NULL); -- 2024.7.30 党内职务视图更新 create or replace view vw_partyduty as SELECT `t`.`rybm` AS `RYBM`, GROUP_CONCAT(`t`.`zwmc` SEPARATOR ',') AS `DNZW`, MAX(`t`.`PZRZRQ`) AS `PZRZRQ` FROM (SELECT `b`.`RYBM` AS `rybm`, `zwmc`.`HZMC` AS `zwmc`, `b`.`PZRZRQ` AS `PZRZRQ` FROM ((`zz_bzcyxx` `b` JOIN `zz_zzqkxxfb` `t1` ON (((`b`.`DZZDM` = `t1`.`DZZDM`) AND (`b`.`JC` = `t1`.`LDJTJC`)))) JOIN `zzzd_zwmc` `zwmc` ON ((`b`.`ZWMC` = `zwmc`.`BM`))) WHERE (`b`.`PZMZRQ` IS NULL or `b`.`PZMZRQ`='')) `t` GROUP BY `t`.`rybm` -- 2024.8.1 -- 基层党组织评比-考核模板 DROP TABLE IF EXISTS `zz_asses_template`; CREATE TABLE `zz_asses_template` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `template_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '模板名称', `year` int NULL DEFAULT NULL COMMENT '年度', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'基层党组织评比-考核模板'; SET FOREIGN_KEY_CHECKS = 1; -- 基层党组织评比-考核模板-考核项目 DROP TABLE IF EXISTS `zz_asses_template_item`; CREATE TABLE `zz_asses_template_item` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `asses_template_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '考核模板id', `item_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '考核项目', `item_score` int NULL DEFAULT NULL COMMENT '分数', `content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评比内容', `standard` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评比标准', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'基层党组织评比-考核模板-考核项目'; SET FOREIGN_KEY_CHECKS = 1; -- 基层党组织评比-评比材料 DROP TABLE IF EXISTS `zz_asses_materials`; CREATE TABLE `zz_asses_materials` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '所在组织', `materials_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评比材料名称', `year` int NULL DEFAULT NULL COMMENT '年度', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'基层党组织评比-评比材料'; SET FOREIGN_KEY_CHECKS = 1; -- 基层党组织评比-评比确定 DROP TABLE IF EXISTS `zz_asses_confirm`; CREATE TABLE `zz_asses_confirm` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `asses_template_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '考核模板id', `dzzdm` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评定支部', `year` int NULL DEFAULT NULL COMMENT '年度', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'基层党组织评比-评比确定'; SET FOREIGN_KEY_CHECKS = 1; -- 基层党组织评比-评比项目得分 DROP TABLE IF EXISTS `zz_asses_item_score`; CREATE TABLE `zz_asses_item_score` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `asses_confirm_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评比确定id', `asses_template_item_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '考核模板-考核项目id', `score` int NULL DEFAULT NULL COMMENT '分数', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'基层党组织评比-评比项目得分'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f237844c-0000-430f-bef7-ea68469c9f28', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a2640551-3b11-484b-9420-4376641a760c', NULL, 8, 'jcdzzpb', '基层党组织评比', NULL, NULL, NULL, 1, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('20a57810-0000-4f11-a983-57a4d907c124', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-0000-430f-bef7-ea68469c9f28', NULL, 1, 'home.assesTemplate', '考核模板管理', NULL, NULL, NULL, 1, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('20a57810-0001-0000-a983-57a4d907c124', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '20a57810-0000-4f11-a983-57a4d907c124', NULL, 1, 'home.assesTemplateEdit', '修改考核模板', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('20a57810-0002-0000-a983-57a4d907c124', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '20a57810-0000-4f11-a983-57a4d907c124', NULL, 2, 'home.assesTemplateAdd', '新增考核模板', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('20a57810-0003-0000-a983-57a4d907c124', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '20a57810-0000-4f11-a983-57a4d907c124', NULL, 3, 'home.assesTemplateDetail', '查看考核模板', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('3039d18c-0000-4345-af35-3ac79fa0aed4', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-0000-430f-bef7-ea68469c9f28', NULL, 2, 'home.assesMaterials', '上传材料报告', NULL, NULL, NULL, 1, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f237844c-0000-430f-bef7-ea34569c9f28', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-0000-430f-bef7-ea68469c9f28', NULL, 3, 'home.assesConfirm', '基层党组织评比管理', NULL, NULL, NULL, 1, 1, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f237844c-0000-0001-bef7-ea34569c9f28', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-0000-430f-bef7-ea34569c9f28', NULL, 1, 'home.assesConfirmAdd', '新增评级', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('f237844c-0000-0002-bef7-ea34569c9f28', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'f237844c-0000-430f-bef7-ea34569c9f28', NULL, 2, 'home.assesConfirmEdit', '更新评级', NULL, NULL, NULL, 0, 0, NULL); -- 2024.8.6 -- 组织生活-实践活动 DROP TABLE IF EXISTS `pf_practical_activity`; CREATE TABLE `pf_practical_activity` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `activity_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动主题', `activity_type` int NULL DEFAULT NULL COMMENT '活动类型 activityType', `address` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动地点', `begin_date` datetime NULL DEFAULT NULL COMMENT '活动举办开始时间', `end_date` datetime NULL DEFAULT NULL COMMENT '活动举办结束时间', `begin_the_registration_time` datetime NULL DEFAULT NULL COMMENT '开始报名时间', `end_the_registration_time` datetime NULL DEFAULT NULL COMMENT '结束报名时间', `remark` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动备注', `content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动内容', `other_explain` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动其它说明', `activity_record_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动记录文件编号', `activity_image_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '活动图片编号', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'组织生活-实践活动'; SET FOREIGN_KEY_CHECKS = 1; -- 组织生活-实践活动-报名人员信息 DROP TABLE IF EXISTS `pf_practical_activity_user`; CREATE TABLE `pf_practical_activity_user` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'id', `practical_activity_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '实践活动id', `user_no` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '人员编号', `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '人员姓名', `party_code` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '组织编号', `party_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '组织名称', `phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '手机号', `state` int NULL DEFAULT NULL COMMENT '报名状态 1-未报名；2-已报名；', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_userid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC COMMENT'组织生活-实践活动-报名人员信息'; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('44bd6982-0000-0000-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'c4516fca-2dd8-4373-9be8-1df510c8e5e1', NULL, 6, 'home.practicalActivity', '实践活动管理', NULL, NULL, NULL, 1, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('44bd6982-0000-0001-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '44bd6982-0000-0000-829d-7085c2a9999e', NULL, 1, 'home.practicalActivityAdd', '新增实践活动', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('44bd6982-0000-0002-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '44bd6982-0000-0000-829d-7085c2a9999e', NULL, 2, 'home.practicalActivityEdit', '编辑实践活动', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('44bd6982-0000-0003-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '44bd6982-0000-0000-829d-7085c2a9999e', NULL, 3, 'home.practicalActivityUser', '活动名单管理', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('44bd6982-0000-0004-829d-7085c2a9999e', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '44bd6982-0000-0000-829d-7085c2a9999e', NULL, 4, 'home.practicalActivityDetail', '查看实践活动详情', NULL, NULL, NULL, 0, 0, NULL); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-0000-0001-a173acf6009a', 1, '未开始', 'activityState', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '实践活动状态', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-0000-0002-a173acf6009a', 2, '报名中', 'activityState', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '实践活动状态', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-0000-0003-a173acf6009a', 3, '已结束', 'activityState', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '实践活动状态', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-0000-0004-a173acf6009a', 4, '已归档', 'activityState', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '实践活动状态', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-aaaa-0001-a173acf6009a', 1, '主题党日', 'activityType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '活动类型', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('17455b74-0000-aaaa-0002-a173acf6009a', 2, '其他', 'activityType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '活动类型', '2019-09-23 09:19:12', 'A', 'N'); -- 2024-8-9 中层干部换届与考核 -- 干部换届管理 DROP TABLE IF EXISTS `lw_leader_reshuffle`; CREATE TABLE `lw_leader_reshuffle` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `reshuffleType` int NULL DEFAULT NULL COMMENT '换届类型 reshuffleType(1-中层换届、2-职位补充、3-其他)', `date` varchar(12) NULL DEFAULT NULL COMMENT '任职时间', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任职人姓名', `position` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任职职位', `departmentName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任职单位', `fileTitle` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任职文件标题', `fileNo` 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 COMMENT = '干部换届管理' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- 干部任（试用）期届满考核 DROP TABLE IF EXISTS `lw_leader_assess`; CREATE TABLE `lw_leader_assess` ( `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `assessType` int NULL DEFAULT NULL COMMENT '考核类型 assessType 1-任期； 2-试用期；', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名', `sex` int NULL DEFAULT NULL COMMENT '性别', `idCard` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '身份证号', `birthDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '出生年月', `education` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学历', `jobTitle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '职称', `workDate` varchar(12) NULL DEFAULT NULL COMMENT '参加工作时间', `position` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '职位', `beginDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任(试用)期开始日期', `endDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '任(试用)期结束日期', `assessBeginDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考核开始时间', `assessEndDate` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考核结束时间', `grade` int NULL DEFAULT NULL COMMENT '等次 gradeType（优秀、称职、基本称职、不称职）', `result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考核结果', `content` varchar(2000) 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 COMMENT = '干部任（试用）期届满考核' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; -- 换届类型 reshuffleType(1-中层换届、2-职位补充、3-其他) INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0001-4481-ab20-3c0e016aa59e', 1, '中层换届', 'reshuffleType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '换届类型', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0002-4481-ab20-3c0e016aa59e', 2, '职位补充', 'reshuffleType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '换届类型', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0003-4481-ab20-3c0e016aa59e', 3, '其他', 'reshuffleType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '换届类型', '2019-09-23 09:19:12', 'A', 'N'); -- 考核类型 assessType 1-任期； 2-试用期； INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0004-0001-ab20-3c0e016aa59e', 1, '干部任期届满考核', 'assessType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '考核类型', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0005-0002-ab20-3c0e016aa59e', 2, '干部试用期届满考核', 'assessType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '考核类型', '2019-09-23 09:19:12', 'A', 'N'); -- 等次 gradeType（优秀、称职、基本称职、不称职） INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0006-0000-0001-3c0e016aa59e', 1, '优秀', 'gradeType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '等次', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0007-0000-0002-3c0e016aa59e', 2, '称职', 'gradeType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '等次', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0008-0000-0003-3c0e016aa59e', 3, '基本称职', 'gradeType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '等次', '2019-09-23 09:19:12', 'A', 'N'); INSERT INTO `cf_dictionary` (`DICTIONARYID`, `DICKEY`, `DICVALUE`, `DICTYPEKEY`, `DICTYPE`, `APPLICATIONID`, `DICNOTE`, `OPERATETIME`, `OPERATESTATE`, `SYNCSTATE`) VALUES ('ea6cad8a-0009-0000-0004-3c0e016aa59e', 4, '不称职', 'gradeType', 2, 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '等次', '2019-09-23 09:19:12', 'A', 'N'); -- 中层干部换届与考核 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0000-0000-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', '996c7331-1f94-48f0-b246-d6ddb178ae7f', NULL, 14, 'leaderReshuffleAndAssess', '中层干部换届与考核', NULL, 'receipt', NULL, 1, 0, NULL); -- 干部换届管理 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0000-0001-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0000-0001-557a666c7ff8', NULL, 1, 'home.leaderReshuffle', '干部换届管理', '', '', '', 1, 0, NULL); -- 干部任期届满考核 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0004-0002-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0002-0001-557a666c7ff8', NULL, 1, 'home.leaderAssessAdd1', '新增干部任期届满考核', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0005-0002-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0002-0001-557a666c7ff8', NULL, 2, 'home.leaderAssessEdit1', '编辑干部任期届满考核', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0006-0002-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0002-0001-557a666c7ff8', NULL, 3, 'home.leaderAssessDetail1', '查看干部任期届满考核详情', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0000-0002-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0000-0001-557a666c7ff8', NULL, 2, 'home.leaderAssessList1', '干部任期届满考核', '', '', '', 1, 0, NULL); -- 干部试用期届满考核 INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0007-0003-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0003-0001-557a666c7ff8', NULL, 1, 'home.leaderAssessAdd2', '新增干部试用期届满考核', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0008-0003-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0003-0001-557a666c7ff8', NULL, 2, 'home.leaderAssessEdit2', '编辑干部试用期届满考核', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0009-0003-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0003-0001-557a666c7ff8', NULL, 3, 'home.leaderAssessDetail2', '查看干部试用期届满考核详情', '', '', '', 0, 0, NULL); INSERT INTO `cf_menu` (`MENUID`, `APPLICATIONID`, `PARENTMENUID`, `MNUSYSTEM`, `MENUORDER`, `MENUNO`, `MENUNAME`, `MENUPROGRAM`, `MENUPIC`, `MENUDESC`, `ISVISIBLE`, `ISLEAF`, `ISBLANK`) VALUES ('a30bc101-0000-0003-0001-557a666c7ff8', 'f0c4fa7f9f3c4fb6bd56aac608b7ad3f', 'a30bc101-0000-0000-0001-557a666c7ff8', NULL, 3, 'home.leaderAssessList2', '干部试用期届满考核', '', '', '', 1, 0, NULL); -- 年龄计算函数 set global log_bin_trust_function_creators=TRUE; DELIMITER $$ CREATE FUNCTION `calculate_age` (birthdate DATE) RETURNS INTEGER BEGIN declare age int; set age =0; if month(current_date) > MONTH(birthdate) then set age= year(current_date) - YEAR(birthdate) ; elseif month(current_date) = MONTH(birthdate) and day(current_date) > DAY(birthdate) then set age = year(current_date) - YEAR(birthdate); else set age = year(current_date) - YEAR(birthdate) - 1; end if; return age; END$$ DELIMITER ;