soc/project_data/sql/1.0.14/soc/soc.sql

-- v 1.0.14 版本升级脚本

DELIMITER ??
DROP PROCEDURE IF EXISTS schema_change ??
CREATE PROCEDURE schema_change()
BEGIN

    IF NOT EXISTS(SELECT DISTINCT INDEX_NAME
            FROM INFORMATION_SCHEMA.STATISTICS
            WHERE TABLE_SCHEMA = DATABASE()
              AND TABLE_NAME = 'core_introduce_letter'
              AND INDEX_NAME = 'index_start_time') THEN
        ALTER TABLE `core_introduce_letter`
            ADD INDEX `index_start_time`(`start_time`) USING BTREE;
    end if;

    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_introduce_letter_out_in_request_user'
                    AND column_name = 'arrival_time') THEN
        ALTER TABLE `core_introduce_letter_out_in_request_user`
            ADD COLUMN `arrival_time` datetime(0) NULL DEFAULT NULL COMMENT '到达时间' ,
            ADD COLUMN `departure_time` datetime(0) NULL DEFAULT NULL COMMENT '离开时间' AFTER `arrival_time`;
    END IF;

    IF NOT EXISTS(SELECT *
              FROM information_schema.columns
              WHERE table_schema = DATABASE()
                AND table_name = 'core_introduce_letter_out_in_request_user'
                AND column_name = 'letter_user_id') THEN
    ALTER TABLE `core_introduce_letter_out_in_request_user`
        ADD COLUMN `letter_user_id` bigint NULL COMMENT '介绍信用户ID' ;
    END IF;

    IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_introduce_letter_out_in_request'
                    AND column_name = 'status') THEN
        ALTER TABLE `core_introduce_letter_out_in_request`
            ADD COLUMN `status` int DEFAULT NULL COMMENT '出入状态 ：0待审批 1 待登记 2 已完成 3 已拒绝 4 已过期 5已补登',
            ADD COLUMN `accompanying_person` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '陪同人员',
            ADD COLUMN `check_sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核对人签名',
            ADD COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息' ,
            ADD COLUMN `remark_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注照片';

    END IF;


     IF NOT EXISTS(SELECT *
                  FROM information_schema.columns
                  WHERE table_schema = DATABASE()
                    AND table_name = 'core_introduce_letter_out_in_request'
                    AND column_name = 'pdf_url') THEN
        ALTER TABLE `core_introduce_letter_out_in_request`
            ADD COLUMN `pdf_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登记簿url';
    END IF;

END ??
DELIMITER ;
CALL schema_change();

-- 修改介绍信出入类型  将 电子、纸质 统一改为 普通
ALTER TABLE `core_introduce_letter_out_in_request`
    MODIFY COLUMN `letter_type` int NULL DEFAULT NULL COMMENT '类型：2 普通，3 紧急' AFTER `letter_reasons`;

update  core_introduce_letter_out_in_request set letter_type =2 where letter_type=1;

ALTER TABLE `core_introduce_letter`
    MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '类型： 2 普通出入，3 紧急出入' AFTER `update_time`;

ALTER TABLE `core_introduce_letter_out_in_request`
    MODIFY COLUMN `letter_type` int NULL DEFAULT NULL COMMENT '类型： 2 普通出入，3 紧急出入' AFTER `letter_reasons`;

-- 修改介绍信出入类型  将 电子、纸质 统一改为 普通
update  core_introduce_letter set type =2 where type=1;


-- 修改字典
UPDATE sys_dict_data set `status` =1 WHERE dict_type ='out_in_type' AND dict_value ='1';

UPDATE sys_dict_data set `dict_label` ='普通' WHERE dict_type ='out_in_type' AND dict_value ='2';

-- APP 菜单调整
-- SELECT * from sys_menu WHERE platform_type =0 and menu_name ='出入审批';

-- 禁用之前的 APP 出入审批页面
UPDATE sys_menu set `status`=1,visible=1 WHERE platform_type =0 and menu_name ='出入审批';
UPDATE sys_menu set `status`=1,visible=1 WHERE parent_id IN (SELECT id FROM (
                        SELECT id FROM sys_menu
                        WHERE platform_type = 0 AND menu_name = '出入审批'
                    ) AS temp);

-- SELECT * from sys_menu WHERE platform_type =0 and menu_name ='出入申请';
-- UPDATE sys_menu set path ='/new/letter',menu_name='出入申请' WHERE platform_type =0 and menu_name ='出入申请';

-- SELECT * from sys_menu WHERE platform_type =0 and menu_name ='出入核验登记';
-- UPDATE sys_menu set path ='/new/outIn',menu_name='出入记录管理' WHERE platform_type =0 and menu_name ='出入核验登记';

-- 新增出入申请菜单
DELETE FROM sys_menu WHERE id in (01721714556507549698,01724017221941936130,01724017294985740290,01724017404872310786,01981602515757568002);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01721714556507549698, '出入申请', 1719176094776664066, 1, '/new/letter', NULL, NULL, 1, 0, 'C', '0', '0', 'core:letter:query', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAADnhJREFUeF7tnc1uVLkSx+3TvMBImTVhMdG8AIxYQNJLdGExYu56kicBngRmfSeaBSCWCWGBJrwAggXNeiLNC6SPLz7dDUnIh8su2+U6/yNFLPDxx7/q1+XvY43A58XB4Z4xZotQtZkxxv/hqaiAc+71g81fHlesAnvRlj1HhgwjAGEoFVkwKTC7f/fWDaa8qmcDQKqbQGUF1EACQFT6p4hGzSbz+fTe9HbTXV8AIsKX1FaieUgAiFrfFNOwpiEBIGL8SHVFmoUEgKj2S1GNaxISACLKh9RXZuas3Xlw5+Z+Ky0FIK1YSk89m4IEgOhxvJZa0gwkAKQlt9JV15lz7g/pW1M0AdJMv7YhP6fsh4tplnhItACyf//urWmMhfDOxQq8ODh0BfQRDQkAKeABrRZRCJBBHufcE4ndLQDSqvcWqHdJQKRCAkAKOFqrRZQGRCIkAKRV7y1Q7whA/M7d9dSqSepuAZBUayp+nwqId2wvh7X2UaosUiABIKmWVPx+DCB+oP389d+POSD5Eo2e3b97a6emxACkpvrCy44FxDdLCyQARLiT1qxeCiDMkFQ7wgtAanqg8LJTAdEACQAR7qQ1q8cBiK//y4PDbWfMU4a2FD9TAkAYrKY1Cy5AWoYEgGj1boZ2cQLSKiQAhMGRtGbBDUiLkAAQrd7N0K4cgAwD9zfvtqxz/nrZ1Cf7mASApJpI8fu5APGSvdp7uz6fTD4xyJcVEgDCYCGtWeQEhBuSXJdBABCt3s3QrtyAtAAJAGFwJK1ZlACEHRLmc+4ARKt3M7SrFCAnIPED99Tt8qxHeAEIgyNpzaIkIFIhASBavZuhXaUBYYaE5Zw7AGFwJK1Z1ABEGiQARKt3M7SrFiCSIAEgDI6kNYuagEiBBIBo9W6GdtUGRAIkAITBkbRmIQEQbkio59wBiFbvZmiXFEBqQgJAGBxJaxaSADkBiT+ZyHGpdtB9zgBEq3cztEsaIBkgufIyCADC4Ehas5AISGlIAIhW72Zol1RAckAymc+n96a3/dWppx4AwuBIWrOQDMgKkuOu22a6xfHcg1cARKt3M7RLOiAlIAEgDI6kNYsWAMkNCQDR6t0M7WoFkJyQABAGR9KaRUuA5IDEn3MHIFq9m6FdVECMMd/NAjFUg5pF6onEk+XNAAhV/hGljwBEnToARJ1J+RoEQIwBIHz+pC4nAAJA1Dk1Z4MACADh9Cd1eQEQAKLOqTkbBEAACKc/qcsLgAAQdU7N2SAAAkA4/UldXgAEgKhzas4GARAAwulP6vICIABEnVNzNujFwSHHp5s5q5Sal9+nRbrwASvpqZLj/WYUeP7678fU04cApBnzoqKpCgCQVAXxvmoFAIhq86JxqQoAkFQF8b5qBQCIavOicakKAJBUBfG+agUAiGrzonGpCgCQVAXxvmoFAIhq86JxqQoAkFQF8b5qBQBIZvO+2nvLeedS5trqz/6829gvazUAyegTz9+827LO7WUsAlnTFAj6QtTJLAEITWBSagBCkqtEYgBCUJksFiHvISkAoSqWPT3Z5oggGW0CQDKKG5c1ACHoRhaLkDciCFWsMunJNkcEyWgYRJCM4sZlDUAIupHFIuSNCEIVq0x6ss0RQTIaBhEko7hxWQMQgm5ksQh5I4JQxSqTnmxzRJCMhkEEyShuXNYAhKAbWSxC3oggVLHKpCfbHBEko2EQQTKKG5f1eAF5eXC43TsXvDGws3b2n7u3nsXpHPaW36jYTyakS8fCckaqGAV6a2cP7tzcp7yrJoJQGo20UCBUAQASqhTSjVIBADJKs6PRoQoAkFClkG6UCgCQUZodjQ5VAICEKoV0o1QAgIzS7Gh0qAIAJFQppBulAgBklGZHo0MVACChSiHdKBUAIKM0OxodqgAACVUK6UapgHpA/v3r5/Xjvt/21rXGXDd+Q6O1flOj/5sNVnduZqydOWM+W+Nmrp/Mfvzve9KmtlF6zwgarRKQf3Y3Hi+BeJRgQw/MH6bv9gFLgoqNv6oGkFWksMakQHGROQdYrnXdsx9+fb+IOnhGoYAKQHzEyATGWScYQPnx4YchQuHRr0DTgPzzv5+3bNc/XY4nSlprNum6KaJJScnrlNUsIAWjxqXdLkSTOo5bqtQmATn686c9Y62Uo6yztYcfbpQyGMopq0BTgPiB+Hw+fyoIjpW1AElZvy1WWjOADHD0vf8YTfDFDMVUXBQESAoLXqK4ZgAR1q26cFyC7lYJty1XRhOANAIHulvl/LZYSeIBYZytGtYwVltJrl1bbDM5PjbrtpuvO2PXv3xPcJNjfOOMeYLZrWI+nLUg0YAsxx2fEhQgr4CfWJH/PWG8M3N9tyN1i8rS6NcTdG3yVefc5webv5AWeUUDktK1Sv0VT9664tz+2m8fpxI96cXBoZ/skDJNXlIiPVePHu3+tG2M9avk1If11ztt9sztrD38mPV6U6o4Pj0ACVdNbASJih6ZfrUT1l9ETv0CkMYBWe6x8t2A8CcTHKsKxEMiL4oAkHC3EhlBYqKH67tp7kFxFCSZwQ039beUACRcNZmA7G648CYYUwKOU5Gk70kzayXrF6IbAAlRaZFGHCDkwXmFX2jq2kzqjFq4OcNSApAwnYQCsuFnroYz5CHPpOtulD6XQV6fqQDxZdoBkBDPEhtBNnz3JWxDYkXHo0aRGiBf5AYApG1ACOOPejNE1Jk2SeMQANIoINTxR+1fZdpsWz2Yz7oDABkDIBW7Vyt5KYBIGqgvAQnrxob7Ugsp/VaTHUpFRc1iHe2SBujP1h5+IDWWIkxIWso4RBIgIW1DGoGDdM2AGAERD05PV0BWBCFcxiDhF5k0ZgIgdO8U8EazgBhTf9ALQAR4cOYqNAuIjAjS1pgpsy+pzL5ZQCT06VsbM6n04MyNEgUIZVZIwjU7R7uEVX9jqs+6ZfYlldnLAmRx127wOZC1hx9sTavQAKk/ZqqpVatlNw1Ize0bpAG6Mab2qn+rDlq73qIAIe+SrXibIWUV3Ru5drSr7Witli8KEC8i1fFqRBFq9PiyOxnjj0YJkQcI/TaT4hcjUCGWsGbTqH9Wr7Y4QCK6Wabkmghxpm0wMMYf1f08ugLiAInpZvkp3xKfRqOeAVlaBd2raPes/6JIQCIdkfXCuLOmiaxT0Qsl6ruTvhqIBCQyivjXZsa4J9y3GcbCIWG1X5/Llm2RWECindKYYUzC8cnmqHuwTtivxgxbWffRX5pYQBKiyMpqSeOSFEAx9tADjmhA0i6O/mok/x2QfWPc66u6Xh4K0/VbHN9cx8KgDkhEA+IlZvglP2upBTDOnT6TzfjVXHStdMDhWyEekAGS3Y3HHL/qZcyGTYlldC5TShOAJH/MpoyWvhSseZTTukhJTQDilRAPCc6cF3HY0oU0A8hKGKHdLUSO0p5bqLzmAJE3JmlzzPFq7+0YL44z96a3h68bhz5NArLqcs374fRhLUNn3doSasCYdLh6NFy1ZgE5MQXsP5dQGpLiW+zDTXp1SgBytUarFM0B8nWw7tymYVy7CJfsVMphtd703X7uz79F1u/c1wBIuJpNAHJiBuv3CtEiVM1mYAEgoSYVvlC4XEWv0YUKV/D8lFl2FadWavU+AAlXUmQEWU7lSo4WoQonbZgMLYSaDoCEKyYKEEVgnLWAKFAASGOAZNiQGK5A2ZQiQAEg4UavHkGEroyHKxiRsuQlE+dVD4CEG60aIA0PwMPVvTxltYVGABJuwiqAjDFqXGCSKl0uACIUkNQz3uHNGlIOB6OcMZ9X71njZq6fDHtxrl0b/t8cHy9W4W03H/51xq5bY64P7/hDVWUWI2eTrpv+8Ot70j4hoh5fkwOQcOWKRZDMcHyDgXlVe1ikPDbrC4Ds5hfotjItVhaD5Pmbd1vd2ROV4T7TbMre2tmDOzf3KQ0oAgjT2XIxU6cZV/aLQUJxkjGnzQ5IzFWilxnEzwBJ2vu0bN+jL126bSZHAiRMQnJkkxUQRjiqDGYpAi/aOt8yxnpYUncXAxKK+BnTZgOEC47aawZU7RmPBgMSqvgZ0mcDhP6JgDOtc25/MpnslJrZ4daWaVKi6XMn3JrWyC8LIInrHKJ3wlKNtPzYTnS3q7UIStVHenp2QBL3VansViTO4lVbcZfuvCXqxw4I7cuvJ5qo/NqcxC4XulolaDinDFZAoscdyuFY6Z44gMfVQhUgYQMkoWs1OsPHjtFw5295QtgAiYoeI4kcZ82a0N1CV6swIyyAREaPURs7duCOKFKWEBZAYqIHDL24b3je959IJh9p1CVpxJg4GZCY6IG5/W8WXK6T+Jtbgh/8uARLlZwwGZCj3Q1v3PCNevgF/M5o5AgMDZMdPzSDJEBiugj49fveNBE6YvEw1MMT0yUBEjFdObop3VD7UKMIuqmhyqalSwKEumqO6HGxschjOXSz0jw/8O1UQFxgOf589/7abx+nwelHmJAYRUY9TV7KPaIBoc6+IHpcbVJqFIGmV2uamiIBENrsFb4bHmaqo92N4KiMcUiYpimpUgDxC1yhR0sxOA+0ErpZgUIVSpYCSPAvnTFtfsevkA1OFUPtuk667karpy5r6EstMwoQGJEqc3h66poIxiHh2sakLAIIxh8001Cmz2PGIS8PDredMf4SPDxXK0C+KNCSFgiXly9cXQ+kWCkwn8+fhl55GgPIiK8eLeJklrz/qki1RlsIeQIEgOT1FQCSV19a7hELsACEJjE1tSVORVLzR3qKAgCEolaRtD6CUNZAilRqxIWQt5wgguT1FgCSV19q7gCEqljm9B4QwiJh5toge0OdRkcEyes0GIPk1ZeWO8YgNL0KpKatgxSo0MiLwDSvMAewsVfWCGuHhuqQxx++0ehi5TW99dkDkrwiB+QefS4dgASom5BkAGQFyXHfb1vnNkO3RiSUi1cXCiR/bevFwaG/icbvMcKTQYH/A1ACk5keMEolAAAAAElFTkSuQmCC', NULL, '超级管理员', '2023-11-07 10:21:53', '超级管理员', '2025-10-24 14:02:25', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01724017221941936130, '新增', 1721714556507549698, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:add', '0', NULL, NULL, '超级管理员', '2023-11-13 18:51:51', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01724017294985740290, '修改', 1721714556507549698, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:edit', '0', NULL, NULL, '超级管理员', '2023-11-13 18:52:08', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01724017404872310786, '删除', 1721714556507549698, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:letter:remove', '0', NULL, NULL, '超级管理员', '2023-11-13 18:52:34', '', NULL, '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01981602515757568002, '出入审批', 1721714556507549698, 4, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:outinrequest:approve', '0', NULL, NULL, '超级管理员', '2025-10-24 14:03:50', '超级管理员', '2025-10-24 14:21:55', '');

-- 新增出入记录管理菜单
DELETE FROM sys_menu WHERE id in (01719180104111788033,01724016270912864258,01724016373870444545,01980566166506049538);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01719180104111788033, '出入登记', 1719176094776664066, 3, '/new/outIn', NULL, NULL, 1, 0, 'C', '0', '0', 'core:outinrequest:list', '0', 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAYAAACtWK6eAAAAAXNSR0IArs4c6QAADbxJREFUeF7tnT1sHVUWx+84ASlLQVhaQ+wiDUU+qt1Ii4w7aEAUTrPRLqZhK6RNCRKQSKQMEl0aEiKqUERLgbZzTFYKqWBT0LiInXUb8DZEYhPP+ry8ScbvzZvP+31/I0WJ8cy99/zP+XHuuXNnJlMWjjzPF5RS74y7OqKUkp+LQ/5d/tnCiOgiAAU2S2OUf5d/Xpefsyy7YdqOzEQHJSCWlFKvmeiDNlFgDI2AI8DcMAGMNkBKUHyM61DAkQICy5dZln2iq//BgACGLlfQjkYFRqDsTd2vZFlWnpp17mIQIHmeC6lkjM6yc4ElBQZnlF6AjLPGZeoLS26mm6EKCCjLfbJJZ0DyPJeie23oiLkeBSwr0CubdAKEKZVll9KdCQXOdSniWwNC5jDhK9p0pEBrSFoBAhyO3Ei3phSQ6dZqm/smbQGRmoMbfqbcRbsuFJA78YtNHTcCkuc5cDSpyO9DVUDuk6zWDb4WkDzPZf+ULOdyoECsCsjy78w9XU2AkD1iDQvsKhSQPVzLs+SYCQiFORGUkAIzs0gdIDK1KraoJ6QVpiaowMxapA6QPEGhMDlNBWYu+1YCQnGeZpQkbnXlzcNZgDC9SjxaEjS/slifBchdHoNNMETSNrnyxuEUIOOt7AIIBwqkpsDUalYVINwcTC0ssLdQYKoOqQKE+oOASVWBqTqkChDqj1TDA7un6hAAIShQ4KkCrQDhBiEhk6wC2d7jhmXjqzIIgCQbHhheCwhLvAQICqjF8ttP9mUQACE8UGD0eqAnz4dMAsIrfYiQ1BUAkNQjAPtrFQAQAgQFahQAEMIDBQCEGECBfgqQQfrpxlWJKAAgiTgaM/spACD9dOOqRBQAkEQcjZn9FACQfrpxVSIK+AXIpxvr6t6D/6p7D3bUd/cHfU4uWP8dOXR4NPZXX1xQLx96Xn14VD4OzOFIAT8AuXl/U7135xu19WDHkQ7+divA/Hn+OKC4cZEfgDz37Xk35gfU66Vjb6kz88cDGnEUQ3UPiGSOr7Z/jEJNk0ZIJvlp+X2TXdD2tALuASF7tI/Lf/7hL6PahMOaAgBiTWoNHX1wdIlaRIOOHZpwC4gU56/fvtphvGmfCiDW/Q8g1iUf0OGZ+RPq0rE3B7TApR0VcAuILOu+svZ5xzGnezqAWPc9gFiXfECHLPUOEK/fpW4BkTGzitXecwDSXitNZ7oHRLaXXNhY12RPvM1wH8SJb90DInXIG99fZZtJg/+5B5IoIGK2QPK3O98ku0GxzvXsxXICRtGp+wxSNv+r7X+rmz9vjXbzbv26k2RWYTevUyAmO/cLEK+kYTAooHizIkGAAnUKkEGIDxSoUQBACA8UABBiAAX6KUAG6acbVyWiAIAk4mjM7KcAgPTTjasSUQBAEnE0ZvZTAED66cZViSgAIIk4GjP7KQAg/XTjqkQUAJBEHI2Z/RQAkH66cVUiCgBIIo7GzH4KAEg/3bgqEQUAJBFHY2Y/BQCkn25clYgCAJKIozGznwIA0k+3OK/Kd/5TaVh2+KU4DW62CkCaNYrvDAFh94evR4blm7dU/su2mgWHnCOAZC/MK3X4JTW38MfHfy+eik+YaYsAJAUvj0AYQ5HvbKvdH64NNlugmTu5og4snx3clscNAIjHztEyNAHj0dpnWqCoGtAouyyeUnMnVmLMKgCiJQo9bKTIGI/WLlobnWSTyDIKgFiLHosdCRQ2wSibFtnUC0Asxq2Vrh5eXlG7d29Z6auuk0iyCYA4jyRNAxjVGtfPegFHYZJkk2fOuod1gMQAMkA8by6VjCGZw8cjcEgAxMeg6jImn+Eo7Jg7eVodfNveYkEX/RrOBRCNYlpvSqZV/7sYxg27QCEBEOtRrbFDXwrytiYFWLgDSFvn+naey6XcvlpIPXLw3WujrSuBHAASiKP2DTOEumOWrrKH6+Dq431gARz+ACKfYZMvTP3r5y3vP8UmX4F69cUF9fKh59WHR5es+zm0qdWkQFKwS00SwOEHIDfvb6rXb18NQK/pIQosHxxdUmfmj1sZv2w0fHg97A2CAS39ugdEMscra59bCS5TnQgkl469Ocoqpo/Qs0ehj0yzAtgy7x6QN25f9X5K1SbobXzHPIbsUWgZSC3iHpDnvj3fJv6COMf0t8xlaqXjWQ5fxAwgiwCIzmCRWsRk0f7bR/M6h+u8rQBuHroFJOTivCq6zsyfGNUiJo6YpleFPgEU624BiaFAL8NgEpDYpleFbrLb1+MbhwCi8//2l469ZWy5V/Zc1b1YQacdNtvyvA5xC4g4IpZVLLHlp+X3laxmmThiqz8KjTzfn+UeELl7/t6df5iIKattmsweYkisgHi+3OseEHH+pxvr6sLGutWA1tmZ6dWrkLa1d9XV80LdD0BEVCnYL2x8p+492FFbv+6Mfvb1kGnUkd8dVn/6/RGjy7qF/SFvTmzyIRmkSSF+36hAjEu8hdEA0uh+TmhSgAzSpJCx3/szxTJmYgQNx1yDkEEiCFDXJgCIMw+QQZxJ37HjaJd5/X7jCYB0jFNnp8fyHMikgJ4/XQggziK+Y8exAsJerI6BwOnVCsS6kvXs+W2fXU4G8dk75bHFWKjzPEgo0RfIOGObZnlef0hUkEECYWM0zNimWZ5PrwAkJDhkrDFNswLIHgASGiCjLBLBe7HEjgCyB4CECIiPH8rpqmMg2QNAujrWl/NDn2oFkj0AxJeA7zOOUF/iEFD2AJA+genLNZJFHn5xOqgXOXi+c7fKtSzz+hLwfcYR0lTL80drZ8kPIH0C06drQoHE89f7AIhPQa17LL4v/QYKBzWI7kB12Z6vkARYd5TdyBTLZVDr7tu3ty8G+E3CSZcAiO4gddGeZI9Ha595uaIlkMydXFHyBsUADwAJ0GlPhiybFx9dP+slGJO6BgoKgIQISMjbTQIDBUBCAyTE76NXaRxIfQIgoQASctaYpXEA2QRAQgAklqxRB8rBd6/5+CEdAPEZkBizRh0kB5b/ruQ5dY8OAPHIGfuGEsoWEp36eTjlAhCdDtbVVmzPnnfVxaOvTgFIV+eZPj91OAp9PXklEICYDvgu7QPHfrU8gARAugSwyXOBo1pdx5AAiMmgb9s2cNQr5bAmAZC2QWzqvBRXq/po6QgSAOnjLJ3XxPY6UZ3alNuSJeADb19U8nyJxQNALIo91VXsd8h1a+tg/xaA6HZi2/aoO9oqNbGytXhKySO8lg4AsST0vm6oO4apbvHdWgAyzFX9rqbu6KdbcZXFqRaADHNV96uZWnXXrOoKSy+DABA97mrfCtmjvVZNZ1p4nRCANDlB5+99fTWPThtttmUhiwCITYf69loem7ab6stwFgEQU46bbJfsYUZpw1kEQMy4bbpVsoc5pQ1mEQAx57anLbNyZVZlgzt+AcSs6x63HurHbmxoo6MPg59WABAdDmpqg+lVk0LDf2/o7jqADHdNfQsU56YVfty+oWIdQEy7j+mVaYWftv/M2Vu6360FIKbdx/TKtMJP2zewmgUgJt3Hrl2T6k63beCpQwAx6ULqD5PqTrdtYDULQEy6kCcGTapb3faz57d1dgogOtWcbIsC3aS61W1rrkMAxKQLKdBNqjsDEHmxg74XYAOISRf+9tG8yeZpu0IBzYU6gJiKMlawTClb3y6AuNG9c6+sYHWWTMsFmjcukkG0eKWiEQAxpWx9u5q3nACIKTcCiCllAcSNspp7BRDNgrZsjgzSUijXpwGIGw8AiBvdO/cKIJ0l03IBgGiR0XwjAGJe46oeAMSN7p17BZDOkmm5AEC0yGi+EQAxr3FlBjl5Wsnjt5oOlnk1CTnVDDt5TSnbsMwLIG6E79orr/rpqpie823eSV9QSt3VM+z0WmEvlhufawZkMcuyzcKSrGxSnucAMtDHPA8yUMAel2t+/Q+A9PBB60skizz84rSSvznsKKDzgaksy/YljX0/iDl5nud2zIq3F4Ejv3tL7f74tZK6hMOcApqzh2oDiNQgMtXi0KRAkU0EGjl2N79Xapxh8l+2yTYzdJYXMlQd2QvzKls4peZOruh+J9ZmlmWL5T6rMsiaUuo1TbFBMx0UmJyWzQqQDk1yajcFAKSbXpydmAJXsixbbcog7yilLicmDOaigCiwmmXZlSZAWOolWFJVYN8Sr4gwVYPIf2QlK9X4SNvuyRWsOkAo1NOOlRStn6o/6gD5ZC+RfJyiSticrAJT9UcdINQhycZJsoZP1R8zARnXIUyzko2V5AyvnF41AUIWSS5OkjV430NStcu85V/meU4WSTZmkjF8ZvaozSDjaZZsORFIOFAgVgVmZo9GQMaQyF11ubvOgQKxKXAjy7LlOqMqbxROTLOkFpEswg7f2MIjbXumNiZWydEIyDiLULCnHUwxWl87tSoMbgXIGBI2McYYJmna1AqOVjXIxHSLO+xpBlRMVlfeMZ9lYOsMUjSQ5zkrWzGFSzq2yJtKBI4bXUzuDEipJqFw76I057pUQOCQadWT1/m0HUwvQEqQSF3Cpsa2anOeCwXO7b2oREqDXkdvQEpTLlnhApRe8nORQQXO7d2akLvknbNGeUyDAakA5a/cMzHodpquU0Bg+HJIxphsXBsgE6BIVpE/AgtvSCGoTSkgQMif9b04k7vinQrwNoPSDkhVp+NXmgooS6XfF3fmC5jajJdz0lKgmB6V/94aS2AEiEl5/w+Kv1cyViDatQAAAABJRU5ErkJggg==', NULL, '超级管理员', '2023-10-31 10:30:52', '超级管理员', '2025-10-24 14:06:17', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01724016270912864258, '新增', 1719180104111788033, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:outinrequest:add', '0', NULL, NULL, '超级管理员', '2023-11-13 18:48:04', '超级管理员', '2025-10-24 14:19:38', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01724016373870444545, '修改', 1719180104111788033, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:outinrequest:edit', '0', NULL, NULL, '超级管理员', '2023-11-13 18:48:28', '超级管理员', '2025-10-24 14:19:50', '');
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01980566166506049538, '删除', 1719180104111788033, 0, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:outinrequest:remove', '0', NULL, NULL, '超级管理员', '2025-10-21 17:25:45', '超级管理员', '2025-10-24 14:20:18', '');

-- web 菜单调整
-- 禁用之前的 WEB 出入审批页面
UPDATE sys_menu set `status`=1,visible=1 WHERE platform_type =1 and menu_name ='出入事项审批';
UPDATE sys_menu set `status`=1,visible=1 WHERE parent_id IN (SELECT id FROM (
                                                                                SELECT id FROM sys_menu
                                                                                WHERE platform_type = 1 AND menu_name = '出入事项审批'
                                                                            ) AS temp);

UPDATE sys_menu set `perms`='core:outinrequest:list' WHERE platform_type =1 and menu_name ='出入情况跟踪';

UPDATE sys_menu set `perms`='core:outinrequest:list' WHERE parent_id IN (SELECT id FROM (
                                                                                SELECT id FROM sys_menu
                                                                                WHERE platform_type = 1 AND menu_name = '出入情况跟踪'
                                                                            ) AS temp) AND perms = 'core:record:list';
DELETE FROM sys_menu WHERE id in (01982695045176680450);
INSERT INTO `sys_menu` (`id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `platform_type`, `icon`, `image_path`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (01982695045176680450, '出入审批', 1722881657557610498, 2, '', NULL, NULL, 1, 0, 'F', '0', '0', 'core:outinrequest:approve', '1', NULL, NULL, '省联社安保管理人员', '2025-10-27 14:26:18', '', NULL, '');

-- 添加字典
DELETE FROM sys_dict_type WHERE dict_type ='out_in_request_status';
INSERT INTO `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('出入申请状态', 'out_in_request_status', '0', '省联社安保管理人员', '2025-10-27 15:26:52', '', NULL, NULL);

DELETE FROM sys_dict_data WHERE dict_type ='out_in_request_status';
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '已补登', '5', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:28:30', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '已逾期', '4', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:28:19', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '已拒绝', '3', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:28:01', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '已完成', '2', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:27:51', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '待登记', '1', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:27:38', '', NULL, NULL);
INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (0, '待审批', '0', 'out_in_request_status', NULL, 'default', 'N', '0', '省联社安保管理人员', '2025-10-27 15:27:30', '', NULL, NULL);



DROP TABLE if exists `core_introduce_letter_out_in_history_user`;
CREATE TABLE `core_introduce_letter_out_in_history_user` (
    `id` bigint NOT NULL,
    `org_id` bigint DEFAULT NULL COMMENT '接待机构',
    `user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `company_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `id_type` int DEFAULT NULL COMMENT '证件类型',
    `id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `img_file` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `out_in_request_id` bigint DEFAULT NULL,
    `create_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
    `create_time` datetime DEFAULT NULL,
    `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
    `update_time` datetime DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `index_out_in_request_id` (`out_in_request_id`) USING BTREE,
    KEY `index_org_id_user_name` (`org_id`,`user_name`) USING BTREE,
    KEY `index_org_id_id_card` (`org_id`,`id_card`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='机构出入过的历史人员表';

DROP TABLE if exists `core_introduce_letter_check_log`;