CREATE TABLE IF NOT EXISTS `blade_voucher_manage` (
  `id` bigint NOT NULL,
  `tenant_id` varchar(12) NOT NULL DEFAULT '000000',
  `project_id` bigint NOT NULL COMMENT '项目ID',
  `project_name` varchar(200) NOT NULL COMMENT '项目名称',
  `voucher_batch_no` varchar(30) NOT NULL COMMENT '凭证批次号',
  `waybill_batch_no` varchar(1000) DEFAULT NULL COMMENT '关联运单批次号',
  `file_name` varchar(100) NOT NULL COMMENT '凭证压缩包文件名',
  `file_url` varchar(1000) NOT NULL COMMENT '凭证压缩包地址',
  `file_task_id` bigint DEFAULT NULL COMMENT '分片上传任务ID',
  `upload_source` varchar(20) NOT NULL DEFAULT '内部' COMMENT '上传来源：内部、承运商',
  `carrier_name` varchar(50) DEFAULT NULL COMMENT '承运商名称',
  `process_status` varchar(20) NOT NULL DEFAULT '上传中' COMMENT '上传中、处理中、处理完成',
  `voucher_count` int NOT NULL DEFAULT 0 COMMENT '凭证数量',
  `related_waybill_count` int NOT NULL DEFAULT 0 COMMENT '已关联运单数',
  `un_related_waybill_count` int NOT NULL DEFAULT 0 COMMENT '未关联运单数',
  `audit_status` varchar(20) NOT NULL DEFAULT '-' COMMENT '待审核、审核通过、审核驳回',
  `create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL,
  `create_time` datetime DEFAULT NULL, `update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT 1, `is_deleted` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), UNIQUE KEY `uk_voucher_manage_no` (`tenant_id`, `voucher_batch_no`),
  KEY `idx_voucher_manage_create_time` (`create_time`), KEY `idx_voucher_manage_process_status` (`process_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='凭证管理';

CREATE TABLE IF NOT EXISTS `blade_voucher_waybill_batch` (
  `id` bigint NOT NULL, `tenant_id` varchar(12) NOT NULL DEFAULT '000000',
  `voucher_id` bigint NOT NULL COMMENT '凭证批次ID', `waybill_import_batch_id` bigint NOT NULL COMMENT '运单导入批次ID',
  `waybill_batch_no` varchar(64) NOT NULL COMMENT '运单批次号', `waybill_count` int NOT NULL DEFAULT 0 COMMENT '运单数',
  `create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL, `create_time` datetime DEFAULT NULL,
  `update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL, `status` tinyint NOT NULL DEFAULT 1, `is_deleted` tinyint NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`), UNIQUE KEY `uk_voucher_waybill_batch` (`voucher_id`, `waybill_import_batch_id`),
  KEY `idx_voucher_waybill_batch_voucher` (`voucher_id`), KEY `idx_voucher_waybill_batch_waybill` (`waybill_import_batch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='凭证关联运单批次';

INSERT INTO `blade_menu` (`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `component`, `remark`, `is_deleted`)
VALUES
(2090000000000000900, 2090000000000000000, 'voucher_manage', '凭证管理', 'voucher_manage', '/business/voucher-manage', 'iconfont icon-caidanguanli', 90, 1, 0, 1, NULL, '', 0),
(2090000000000000901, 2090000000000000900, 'voucher_manage_view', '查看', 'voucher_manage_view', '', '', 1, 2, 0, 1, NULL, '', 0),
(2090000000000000902, 2090000000000000900, 'voucher_manage_add', '批量导入凭证', 'voucher_manage_add', '', '', 2, 2, 0, 1, NULL, '', 0),
(2090000000000000903, 2090000000000000900, 'voucher_manage_edit', '更换运单批次', 'voucher_manage_edit', '', '', 3, 2, 0, 1, NULL, '', 0),
(2090000000000000904, 2090000000000000900, 'voucher_manage_delete', '删除', 'voucher_manage_delete', '', '', 4, 2, 0, 1, NULL, '', 0)
ON DUPLICATE KEY UPDATE `name` = VALUES(`name`), `path` = VALUES(`path`), `is_deleted` = 0;