-- =========================================
-- 档案管理模块（yudao-module-archive）一期
-- 建表 + 字典数据 + BPM 分类 + 菜单 + 三方归档按钮权限
-- 覆盖需求：1.书架(分类管理) 2.文档管理 3.借阅登记 4.归还登记 5.档案统计 + 课题/会员/财务归档联动
-- 二期（档案销毁、逾期罚款）不在此脚本内
-- =========================================

-- ----- 1. 档案分类表（书架/分类树，分层） -----
DROP TABLE IF EXISTS `archive_category`;
CREATE TABLE `archive_category` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父分类 ID，0=顶级',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类名称',
  `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类编码，唯一（member/research/meeting/finance/document/party）',
  `sort` int NOT NULL DEFAULT '0' COMMENT '显示排序',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '分类说明',
  `default_secret_level` tinyint NOT NULL DEFAULT '1' COMMENT '该分类下档案默认密级：1-公开 2-内部 3-保密',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态：0-启用 1-停用',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_code` (`code`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='档案-分类';

-- ----- 2. 档案主表 -----
DROP TABLE IF EXISTS `archive_document`;
CREATE TABLE `archive_document` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案编号 DA+yyyyMMdd+6位流水',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案标题',
  `category_id` bigint NOT NULL COMMENT '档案分类 ID',
  `secret_level` tinyint NOT NULL DEFAULT '1' COMMENT '密级：1-公开 2-内部 3-保密',
  `carrier_type` tinyint NOT NULL DEFAULT '3' COMMENT '载体：1-电子 2-实体 3-电子+实体',
  `shelf_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '实体-书架号',
  `layer_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '实体-层号',
  `column_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '实体-列号',
  `box_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '实体-册号/档案盒号',
  `store_place` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '实体存放位置描述（如 3号库房A架2层）',
  `source_type` tinyint NOT NULL DEFAULT '1' COMMENT '来源：1-手工 2-课题 3-会员 4-财务',
  `source_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '来源单号（立项编号/会员编号/报销单号）',
  `source_id` bigint DEFAULT NULL COMMENT '来源单据 ID',
  `source_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '来源单据标题（冗余快照，便于检索）',
  `archive_date` date DEFAULT NULL COMMENT '归档日期',
  `archivist_user_id` bigint DEFAULT NULL COMMENT '归档人用户 ID',
  `status` tinyint NOT NULL DEFAULT '10' COMMENT '档案状态：10-在库 20-借出中',
  `summary` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '摘要',
  `tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '关键词，英文逗号分隔（检索用）',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_no` (`no`) USING BTREE,
  KEY `idx_category_id` (`category_id`) USING BTREE,
  KEY `idx_secret_level` (`secret_level`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_source` (`source_type`,`source_id`) USING BTREE,
  KEY `idx_archive_date` (`archive_date`) USING BTREE,
  KEY `idx_title` (`title`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='档案-档案主表';

-- ----- 3. 借阅单表（借阅 + 归还合一） -----
DROP TABLE IF EXISTS `archive_borrow`;
CREATE TABLE `archive_borrow` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  `no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '借阅单号 JY+yyyyMMdd+6位流水',
  `document_id` bigint NOT NULL COMMENT '档案 ID',
  `document_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案编号（快照）',
  `document_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '档案标题（快照）',
  `borrower_user_id` bigint DEFAULT NULL COMMENT '借阅人用户 ID',
  `borrower_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '借阅人姓名',
  `borrower_dept` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '借阅人部门',
  `borrower_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '借阅人联系电话',
  `borrow_date` date NOT NULL COMMENT '借阅日期',
  `borrow_purpose` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '借阅目的',
  `return_deadline` date NOT NULL COMMENT '归还期限（逾期实时计算基准）',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态：0-草稿 15-审批中 20-借出中 30-已归还 35-已驳回',
  `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'BPM 流程实例 ID',
  `approve_time` datetime DEFAULT NULL COMMENT '审批通过（实际借出）时间',
  `return_time` datetime DEFAULT NULL COMMENT '实际归还时间',
  `return_confirm_user_id` bigint DEFAULT NULL COMMENT '归还确认人用户 ID',
  `return_remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '归还备注',
  `reject_reason` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '驳回原因（BPM 回写）',
  `reject_time` datetime DEFAULT NULL COMMENT '驳回时间',
  `remark` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_no` (`no`) USING BTREE,
  KEY `idx_document_id` (`document_id`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_return_deadline` (`return_deadline`) USING BTREE,
  KEY `idx_borrower_user_id` (`borrower_user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='档案-借阅单';

-- ----- 4. 初始分类（6 条，财务分类默认密级=保密） -----
DELETE FROM `archive_category` WHERE `code` IN ('member','research','meeting','finance','document','party');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (1, 0, '会员档案', 'member', 1, '会员入会材料、资质证明等', 2, 0, '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (2, 0, '课题档案', 'research', 2, '课题申报书、立项批复、结项材料等', 2, 0, '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (3, 0, '会议档案', 'meeting', 3, '学会文件、会议纪要等', 2, 0, '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (4, 0, '财务档案', 'finance', 4, '报销凭证、发票等财务单据', 3, 0, '财务档案默认密级为「保密」，需 archive:document:sensitive 权限查看', '1', NOW(), '1', NOW(), b'0');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (5, 0, '文书档案', 'document', 5, '调研报告、学术论文、合同协议等', 2, 0, '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO `archive_category` (`id`,`parent_id`,`name`,`code`,`sort`,`description`,`default_secret_level`,`status`,`remark`,`creator`,`create_time`,`updater`,`update_time`,`deleted`)
VALUES (6, 0, '党建档案', 'party', 6, '党建活动、组织建设等材料', 2, 0, '', '1', NOW(), '1', NOW(), b'0');

-- ----- 5. 字典数据 -----

-- archive_category_status（档案分类状态）
DELETE FROM system_dict_type WHERE `type` = 'archive_category_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82000, '档案分类状态', 'archive_category_status', 0, '档案分类启用/停用', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_category_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200001, 1, '启用', '0', 'archive_category_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200002, 2, '停用', '1', 'archive_category_status', 0, 'info', '', '1', NOW(), '1', NOW(), b'0');

-- archive_document_status（档案状态）
DELETE FROM system_dict_type WHERE `type` = 'archive_document_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82001, '档案状态', 'archive_document_status', 0, '档案在库/借出中', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_document_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200101, 1, '在库', '10', 'archive_document_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200102, 2, '借出中', '20', 'archive_document_status', 0, 'warning', '', '1', NOW(), '1', NOW(), b'0');

-- archive_secret_level（档案密级）
DELETE FROM system_dict_type WHERE `type` = 'archive_secret_level';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82002, '档案密级', 'archive_secret_level', 0, '公开/内部/保密，保密级需 archive:document:sensitive 权限', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_secret_level';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200201, 1, '公开', '1', 'archive_secret_level', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200202, 2, '内部', '2', 'archive_secret_level', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200203, 3, '保密', '3', 'archive_secret_level', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- archive_carrier_type（档案载体类型）
DELETE FROM system_dict_type WHERE `type` = 'archive_carrier_type';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82003, '档案载体', 'archive_carrier_type', 0, '电子/实体/电子+实体', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_carrier_type';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200301, 1, '电子', '1', 'archive_carrier_type', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200302, 2, '实体', '2', 'archive_carrier_type', 0, 'info', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200303, 3, '电子+实体', '3', 'archive_carrier_type', 0, 'warning', '', '1', NOW(), '1', NOW(), b'0');

-- archive_source_type（档案来源类型）
DELETE FROM system_dict_type WHERE `type` = 'archive_source_type';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82004, '档案来源', 'archive_source_type', 0, '手工录入/课题归档/会员归档/财务归档', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_source_type';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200401, 1, '手工录入', '1', 'archive_source_type', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200402, 2, '课题归档', '2', 'archive_source_type', 0, 'primary', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200403, 3, '会员归档', '3', 'archive_source_type', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200404, 4, '财务归档', '4', 'archive_source_type', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- archive_borrow_status（借阅单状态）
DELETE FROM system_dict_type WHERE `type` = 'archive_borrow_status';
INSERT INTO system_dict_type (id, name, type, status, remark, creator, create_time, updater, update_time, deleted)
VALUES (82005, '档案借阅状态', 'archive_borrow_status', 0, '借阅单审批与归还状态', '1', NOW(), '1', NOW(), b'0');
DELETE FROM system_dict_data WHERE dict_type = 'archive_borrow_status';
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200501, 1, '草稿', '0', 'archive_borrow_status', 0, 'default', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200502, 2, '审批中', '15', 'archive_borrow_status', 0, 'processing', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200503, 3, '借出中', '20', 'archive_borrow_status', 0, 'warning', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200504, 4, '已归还', '30', 'archive_borrow_status', 0, 'success', '', '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, remark, creator, create_time, updater, update_time, deleted)
VALUES (8200505, 5, '已驳回', '35', 'archive_borrow_status', 0, 'danger', '', '1', NOW(), '1', NOW(), b'0');

-- ----- 6. BPM 分类（档案借阅审批，两级审批） -----
-- 注意：需先部署 docs/sql/archive_borrow_approve.bpmn（见该文件头部的部署顺序说明）
DELETE FROM bpm_category WHERE `code` = 'archive_borrow_approve';
INSERT INTO bpm_category (id, name, code, description, status, sort, creator, create_time, updater, update_time, deleted)
VALUES (8003, '档案借阅审批', 'archive_borrow_approve', '档案借阅两级审批（档案管理员审核→分管领导审批）', 0, 3, '1', NOW(), '1', NOW(), b'0');

-- ----- 7. 菜单 -----
-- 注意：菜单 ID 不要与现有菜单冲突（档案管理占用 1075600~1075699，现有 MAX=1075553）
DELETE FROM system_menu WHERE id BETWEEN 1075600 AND 1075699;
-- 顶级目录（type=1），parent_id=0，图标 ep:files
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075600, '档案管理', '', 1, 82, 0, '/archive', 'ep:files', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');

-- 档案分类（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075601, '档案分类', '', 2, 1, 1075600, 'category', 'ep:collection', 'archive/category/index', 'ArchiveCategory', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 档案管理（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075602, '档案管理', '', 2, 2, 1075600, 'document', 'ep:folder-opened', 'archive/document/index', 'ArchiveDocument', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 借阅登记（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075603, '借阅登记', '', 2, 3, 1075600, 'borrow', 'ep:document-copy', 'archive/borrow/index', 'ArchiveBorrow', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 档案统计（菜单，type=2）
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
VALUES (1075604, '档案统计', '', 2, 4, 1075600, 'stat', 'ep:data-analysis', 'archive/stat/index', 'ArchiveStat', 0, b'1', b'1', b'0', '1', NOW(), '1', NOW(), b'0');

-- 按钮权限（type=3）—— 档案分类
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075610, '档案分类查询', 'archive:category:query', 3, 1, 1075601, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075611, '档案分类创建', 'archive:category:create', 3, 2, 1075601, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075612, '档案分类更新', 'archive:category:update', 3, 3, 1075601, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075613, '档案分类删除', 'archive:category:delete', 3, 4, 1075601, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 档案管理
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075620, '档案查询', 'archive:document:query', 3, 1, 1075602, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075621, '档案创建', 'archive:document:create', 3, 2, 1075602, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075622, '档案更新', 'archive:document:update', 3, 3, 1075602, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075623, '档案删除', 'archive:document:delete', 3, 4, 1075602, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075624, '档案导出', 'archive:document:export', 3, 5, 1075602, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075625, '保密档案查看', 'archive:document:sensitive', 3, 6, 1075602, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 借阅登记
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075630, '借阅查询', 'archive:borrow:query', 3, 1, 1075603, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075631, '借阅登记', 'archive:borrow:create', 3, 2, 1075603, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075632, '借阅修改', 'archive:borrow:update', 3, 3, 1075603, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075633, '借阅删除', 'archive:borrow:delete', 3, 4, 1075603, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075634, '借阅提交审批', 'archive:borrow:submit', 3, 5, 1075603, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075635, '归还登记', 'archive:borrow:return', 3, 6, 1075603, '1', NOW(), '1', NOW(), b'0');

-- 按钮权限 —— 档案统计
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075640, '档案统计查询', 'archive:stat:query', 3, 1, 1075604, '1', NOW(), '1', NOW(), b'0');

-- ----- 8. 三方模块归档按钮权限（配合归档联动） -----
-- 课题申报（父菜单 1075512）、会员列表（父菜单 1075492）；财务归档复用既有 finance:reimbursement:archive(1075424)
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075536, '课题申报归档', 'research:application:archive', 3, 7, 1075512, '1', NOW(), '1', NOW(), b'0');
INSERT INTO system_menu (id, name, permission, type, sort, parent_id, creator, create_time, updater, update_time, deleted)
VALUES (1075504, '会员归档', 'ums:member:archive', 3, 4, 1075492, '1', NOW(), '1', NOW(), b'0');