-- 计划
DROP TABLE IF EXISTS `blade_plan`;
CREATE TABLE `blade_plan`
(
    `id`                 bigint(20) NOT NULL,
    `name`               varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '计划类型名称',
    `description`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
    `type_id`            bigint(20) DEFAULT NULL COMMENT '所属计划类型',
    `code`               varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '计划编号',
    `indent_code`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单编号',
    `category`           int(11) DEFAULT NULL COMMENT '计划类别：1 产品计划 2 来料计划',
    `product_id`         bigint(20) DEFAULT NULL COMMENT '所属产品id',
    `product_code`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '所属产品编码',
    `product_name`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '所属产品名称',
    `plan_num`           int(11) DEFAULT '0' COMMENT '计划数量',
    `unassigned_num`     int(11) DEFAULT '0' COMMENT '待派发数量',
    `report_num`         int(11) DEFAULT '0' COMMENT '报工数量',
    `qualify_num`        int(11) DEFAULT '0' COMMENT '合格数量',
    `scrapped_num`       int(11) DEFAULT '0' COMMENT '报废数量',
    `craft_id`           bigint(20) DEFAULT NULL COMMENT '所属产品工艺id',
    `craft_name`         varchar(50) COLLATE utf8mb4_general_ci                        DEFAULT NULL COMMENT '所属产品工艺名称',
    `craft_version`      bigint(20) DEFAULT NULL COMMENT '所属工艺版本id',
    `craft_version_name` varchar(50) COLLATE utf8mb4_general_ci                        DEFAULT NULL COMMENT '所属工艺版本名称',
    `plan_start_time`    datetime                                                      DEFAULT NULL COMMENT '计划开始时间',
    `plan_end_time`      datetime                                                      DEFAULT NULL COMMENT '计划结束时间',
    `start_time`         datetime                                                      DEFAULT NULL COMMENT '实际开始时间',
    `end_time`           datetime                                                      DEFAULT NULL COMMENT '实际结束时间',
    `standard_model`     varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '规格型号',
    `plan_status_before` int(11) DEFAULT NULL COMMENT '暂停前的状态',
    `plan_status`        int(11) DEFAULT NULL COMMENT '计划状态(1:待派发 2.待加工 3.加工中 4.暂停 5.关闭 6.完工)',
    `bom_id`             bigint(20) DEFAULT NULL COMMENT '产品bom主键',
    `bom_version`        varchar(50) COLLATE utf8mb4_general_ci                        DEFAULT NULL COMMENT '所属bom版本名称',
    `customer_id`        bigint(20) DEFAULT NULL COMMENT '客户id',
    `customer_name`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '客户名称',
    `extend_field`       json                                                          DEFAULT NULL COMMENT '扩展字段',
    `create_user`        bigint(20) DEFAULT NULL COMMENT '创建人',
    `create_dept`        bigint(20) DEFAULT NULL COMMENT '创建部门',
    `create_time`        datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20) DEFAULT NULL COMMENT '修改人',
    `update_time`        datetime                                                      DEFAULT NULL COMMENT '修改时间',
    `status`             int(11) DEFAULT NULL COMMENT '状态',
    `is_deleted`         int(11) unsigned zerofill DEFAULT NULL,
    `source_plan_id`     bigint(20) DEFAULT NULL COMMENT '源计划',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `idx_typeid_planstatus_code` (`type_id`,`plan_status`,`code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 计划工序
DROP TABLE IF EXISTS `blade_plan_process`;
CREATE TABLE `blade_plan_process`
(
    `id`               bigint(20) NOT NULL,
    `tenant_id`        bigint(20) NULL DEFAULT NULL COMMENT '租户id',
    `type_name`        varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计划类型名称',
    `description`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
    `plan_id`          bigint(20) NULL DEFAULT NULL COMMENT '所属计划id',
    `main_sequence_id` bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
    `sort`             int(11) NULL DEFAULT NULL COMMENT '工序顺序',
    `code`             varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序编号',
    `name`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序名称',
    `program_id`       bigint(20) NULL DEFAULT NULL COMMENT '程序id',
    `program_name`     varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称',
    `standard_time`    int(11) NULL DEFAULT NULL COMMENT '标准工时',
    `workstation_id`   varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
    `workstation_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
    `art_bag_id`       bigint(20) NULL DEFAULT NULL COMMENT '工艺包id',
    `art_bag_name`     varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包名称',
    `prepare_time`     int(11) NULL DEFAULT NULL COMMENT '准备工时',
    `disassembly_time` int(11) NULL DEFAULT NULL COMMENT '拆卸工时',
    `transport_time`   int(11) NULL DEFAULT NULL COMMENT '运输工时',
    `whether_test`     int(11) NULL DEFAULT 0 COMMENT '是否质检 默认 0否 1是',
    `whether_parallel` int(11) NULL DEFAULT NULL COMMENT '是否并行 默认 0否 1是',
    `assign_status`    int(11) NULL DEFAULT 0 COMMENT '工序派发状态 默认 0未派发 1已派发',
    `create_user`      bigint(20) NULL DEFAULT NULL COMMENT '创建人',
    `create_dept`      bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
    `create_time`      datetime NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`      bigint(20) NULL DEFAULT NULL COMMENT '修改人',
    `update_time`      datetime NULL DEFAULT NULL COMMENT '修改时间',
    `status`           int(11) NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`       int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX              `plan_process_index` (`plan_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT = '计划工序'
  ROW_FORMAT = DYNAMIC;

-- 工单
DROP TABLE IF EXISTS `blade_order`;
CREATE TABLE `blade_order`
(
    `id`                  bigint(20) NOT NULL COMMENT '主键',
    `status`              tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`          bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT '删除状态：0-未删除，1-已删除',
    `create_user`         bigint(20) NULL DEFAULT NULL COMMENT '创建人',
    `create_dept`         bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
    `create_time`         datetime NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`         bigint(20) NULL DEFAULT NULL COMMENT '更新人',
    `update_time`         datetime NULL DEFAULT NULL COMMENT '更新时间',
    `tenant_id`           varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属租户',
    `order_code`          varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工单号',
    `assign_num`          int(11) NULL DEFAULT 0 COMMENT '投产数量',
    `scrapped_num`        int(11) NULL DEFAULT 0 COMMENT '报废数量',
    `qualify_num`         int(11) NULL DEFAULT 0 COMMENT '合格数量',
    `order_status`        int(1) NULL DEFAULT 1 COMMENT '工单状态(1：待加工，2：加工中，3：暂停，4：关闭,5:完工)',
    `plan_id`             bigint(20) NULL DEFAULT NULL COMMENT '计划ID，cpc生成的ID',
    `order_status_before` int(1) NULL DEFAULT NULL COMMENT '变更前工单状态',
    `start_time`          datetime NULL DEFAULT NULL COMMENT '开始时间',
    `end_time`            datetime NULL DEFAULT NULL COMMENT '结束时间',
    `description`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX                 `order_index` (`plan_id`, `order_status`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT = '计划工单'
  ROW_FORMAT = Dynamic;

-- 工单工序
DROP TABLE IF EXISTS `blade_order_process`;
CREATE TABLE `blade_order_process`
(
    `id`                    bigint(20) NOT NULL COMMENT '主键',
    `tenant_id`             varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`           bigint(20) NULL DEFAULT NULL COMMENT '创建人',
    `create_time`           datetime NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`           bigint(20) NULL DEFAULT NULL COMMENT '更新人',
    `update_time`           datetime NULL DEFAULT NULL COMMENT '更新时间',
    `remark`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`                tinyint(3) NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`            bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`           bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
    `plan_id`               bigint(20) NULL DEFAULT NULL COMMENT '计划id',
    `order_id`              bigint(20) NULL DEFAULT NULL COMMENT '工单id',
    `sort`                  int(11) NULL DEFAULT NULL COMMENT '工序顺序',
    `process_sequence`      varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序序号',
    `process_code`          varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序编号',
    `process_name`          varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工序名称',
    `program_id`            bigint(20) NULL DEFAULT NULL COMMENT '程序id',
    `program_name`          varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '程序名称',
    `process_status_before` int(11) NULL DEFAULT NULL COMMENT '暂停前状态',
    `process_status`        int(11) NULL DEFAULT NULL COMMENT '工序状态(1.待加工 2.加工中 3.暂停 4.关闭 5.完工)',
    `input_num`             int(11) NULL DEFAULT 0 COMMENT '投产数量',
    `qualify_num`           int(11) NULL DEFAULT 0 COMMENT '工序合格数量',
    `scrapped_num`          int(11) NULL DEFAULT 0 COMMENT '工序报废数量',
    `standard_time`         int(11) NULL DEFAULT NULL COMMENT '标准工时（单位：s）',
    `start_time`            datetime NULL DEFAULT NULL COMMENT '开始时间',
    `end_time`              datetime NULL DEFAULT NULL COMMENT '结束时间',
    `workstation_id`        varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位id，用逗号隔开',
    `workstation_name`      varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '多工位名称，用逗号隔开',
    `art_bag_id`            bigint(20) NULL DEFAULT NULL COMMENT '工艺包id',
    `art_bag_name`          varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工艺包名称',
    `prepare_time`          int(11) NULL DEFAULT NULL COMMENT '准备工时（单位：s）',
    `disassembly_time`      int(11) NULL DEFAULT NULL COMMENT '拆卸工时（单位：s）',
    `transport_time`        int(11) NULL DEFAULT NULL COMMENT '运输工时（单位：s）',
    `whether_test`          int(11) NULL DEFAULT 0 COMMENT '是否质检： 0 否 1 是',
    `whether_parallel`      int(11) NULL DEFAULT 0 COMMENT '是否并行： 0 否 1 是',
    `main_sequence_id`      bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX                   `plan_order` (`plan_id`, `order_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

-- 工单工位
DROP TABLE IF EXISTS `blade_order_workstation`;
CREATE TABLE `blade_order_workstation`
(
    `id`                 bigint(20) NOT NULL COMMENT '主键',
    `tenant_id`          varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`        bigint(20) NULL DEFAULT NULL COMMENT '创建人',
    `create_time`        datetime NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20) NULL DEFAULT NULL COMMENT '更新人',
    `update_time`        datetime NULL DEFAULT NULL COMMENT '更新时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`             tinyint(3) NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`         bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`        bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
    `plan_id`            bigint(20) NULL DEFAULT NULL COMMENT '计划id',
    `order_id`           bigint(20) NULL DEFAULT NULL COMMENT '工单id',
    `process_id`         bigint(20) NULL DEFAULT NULL COMMENT '工单工序id',
    `workstation_id`     bigint(20) NULL DEFAULT NULL COMMENT '加工工位id',
    `workstation_name`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加工工位名称',
    `producer_id`        bigint(20) NULL DEFAULT NULL COMMENT '当前生产人员id',
    `producer_code`      varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前生产人员编号',
    `producer_name`      varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前生产人员名称',
    `qualify_num`        int(11) NULL DEFAULT 0 COMMENT '报工合格数量',
    `scrapped_num`       int(11) NULL DEFAULT 0 COMMENT '报工报废数量',
    `workstation_status` int(11) NULL DEFAULT 1 COMMENT '状态：1.未开工 2.已开工 ',
    `current_record_id`  bigint(20) NULL DEFAULT NULL COMMENT '当前报工记录的id',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX                `plan_order_process_workstation` (`order_id`, `process_id`, `workstation_id`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = Dynamic;

-- 开报工记录
DROP TABLE IF EXISTS `blade_order_report_record`;
CREATE TABLE `blade_order_report_record`
(
    `id`                 bigint(20) NOT NULL COMMENT '主键',
    `tenant_id`          varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户ID',
    `create_user`        bigint(20) NULL DEFAULT NULL COMMENT '创建人',
    `create_time`        datetime NULL DEFAULT NULL COMMENT '创建时间',
    `update_user`        bigint(20) NULL DEFAULT NULL COMMENT '更新人',
    `update_time`        datetime NULL DEFAULT NULL COMMENT '更新时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    `status`             tinyint(4) NULL DEFAULT NULL COMMENT '状态',
    `is_deleted`         bigint(20) NULL DEFAULT NULL COMMENT '删除标识',
    `create_dept`        bigint(20) NULL DEFAULT NULL COMMENT '创建部门',
    `plan_id`            bigint(20) NULL DEFAULT NULL COMMENT '计划id',
    `order_id`           bigint(20) NULL DEFAULT NULL COMMENT '工单id',
    `process_id`         bigint(20) NULL DEFAULT NULL COMMENT '工单工序id',
    `workstation_id`     bigint(20) NULL DEFAULT NULL COMMENT '加工工位id',
    `workstation_name`   varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加工工位名称',
    `producer_user_id`   bigint(20) NULL DEFAULT NULL COMMENT '开工人员id',
    `producer_user_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开工人员编码',
    `producer_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开工人员名称',
    `start_time`         datetime NULL DEFAULT NULL COMMENT '开工时间',
    `workshop_time`      datetime NULL DEFAULT NULL COMMENT '报工时间',
    `quality_time`       datetime NULL DEFAULT NULL COMMENT '质检报工时间',
    `workshop_user_id`   bigint(20) NULL DEFAULT NULL COMMENT '报工人员id',
    `workshop_user_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报工人员编码',
    `workshop_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报工人员名称',
    `quality_user_id`    bigint(20) NULL DEFAULT NULL COMMENT '质检报工人员id',
    `quality_user_code`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '质检报工人员编码',
    `quality_user_name`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '质检报工人员名称',
    `qualify_num`        int(11) NULL DEFAULT 0 COMMENT '报工合格数量',
    `scrapped_num`       int(11) NULL DEFAULT 0 COMMENT '报工报废数量',
    `record_status`      int(11) NULL DEFAULT 0 COMMENT '记录状态：0 开工 1 完工',
    `main_sequence_id`   bigint(20) NULL DEFAULT NULL COMMENT '主序id（当主序id不为空时，代表工序是子序）',
    `open_sequence_id`   bigint(20) NULL DEFAULT NULL COMMENT '并序报工记录id（并序开工时子序的开工记录中）',
    `version`            int(11) DEFAULT '0' COMMENT '乐观锁',
    `system_or_ordinary` int(11) DEFAULT '0' COMMENT '0:普通报工 1:系统报工',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX                `record_index` (`process_id`, `workstation_id`, `record_status`) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8mb4
  COLLATE = utf8mb4_0900_ai_ci
  ROW_FORMAT = Dynamic;

-- 计划工单菜单
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
                        is_deleted, belong_application, keep_alive)
VALUES (1594520271959724033, 0, 'job', '计划工单', 'job', '/job', 'iconfont saber-jihuagongdan', 12, 0, 0, 1, '', 0, 'CPS',
        1),
       (1594521413162733569, 1594520271959724033, 'job_plan', '计划', 'menu', '/job/plan/index', '', 1, 1, 0, 1, '', 0,
        'CPS', 1),
       (1594524229658841089, 1594520271959724033, 'job_order', '工单1', 'job_order', '/job/order/index', '', 2, 1, 0, 1,
        '', 0, 'CPS', 1),
       (1599717577688829954, 1594524229658841089, 'job_work_start', '开工', 'job_work_start', '', '', 1, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599717707783557122, 1594524229658841089, 'job_work_report', '报工', 'job_work_report', '', '', 2, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599717873215295489, 1594524229658841089, 'job_work_complete', '完工', 'job_work_complete', '', '', 3, 2, 0, 1,
        '', 0, 'CPS', 1),
       (1599718446291443713, 1594524229658841089, 'job_work_assigned', '工位指派', 'job_work_assigned', '', '', 4, 2, 0, 1,
        '', 0, 'CPS', 1),
       (1599725934163382273, 1594524229658841089, 'report_history_edit', '报工记录编辑', 'report_history_edit', '', '', 5, 2,
        0, 1, '', 0, 'CPS', 1),
       (1599726500805464065, 1594524229658841089, 'report_history_delete', '报工记录删除', 'report_history_delete', '', '', 6,
        2, 0, 1, '', 0, 'CPS', 1),
       (1599727121952526337, 1594524229658841089, 'report_history', '报工记录列表', 'report_history', '', '', 7, 2, 0, 1, '',
        0, 'CPS', 1),
       (1599948830497501186, 1594521413162733569, 'job_plan_create', '计划新增', 'button', '', '', 1, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599948991642660865, 1594521413162733569, 'job_plan_edit', '计划编辑', 'button', '', '', 2, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599949079353946114, 1594521413162733569, 'job_plan_import', '计划导入', 'button', '', '', 3, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599949217078112257, 1594521413162733569, 'job_plan_export', '计划导出', 'button', '', '', 4, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599949426399047681, 1594521413162733569, 'job_plan_distributed', '计划派工', 'button', '', '', 5, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599949565360533506, 1594521413162733569, 'job_plan_additional', '计划追加', 'button', '', '', 6, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599949740036517889, 1594521413162733569, 'job_plan_suspended', '计划暂停', 'button', '', '', 7, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599949969905348609, 1594521413162733569, 'job_plan_close', '计划关闭', 'button', '', '', 8, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599950097730957313, 1594521413162733569, 'job_plan_delete', '计划删除', 'button', '', '', 9, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599967268410040322, 1594524229658841089, 'report_history_export', '报工记录导出', 'report_history_export', '', '', 8,
        2, 0, 1, '', 0, 'CPS', 1),
       (1600664450734919681, 1594524229658841089, 'job_work_delete', '删除', 'job_work_delete', '', '', 9, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599950099730957311, 1594521413162733569, 'job_plan_list', '计划列表', 'button', '', '', 10, 2, 0, 1, '', 0, 'CPS',
        1),
       (1599950099730957312, 1594521413162733569, 'job_plan_reboot', '计划重启', 'button', '', '', 11, 2, 0, 1, '', 0,
        'CPS', 1),
       (1599950099730957313, 1594521413162733569, 'job_plan_finish', '计划完工', 'button', '', '', 12, 2, 0, 1, '', 0, 'CPS',
        1);



-- 工单编码规则
INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted)
VALUES (1595651058122289153, 1531087267316621313, 'code_rule_for_biz_objects', 'Order', '工单', 1, '', 0, 0);
INSERT INTO blade_meta_object_type (f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key,
                                    rule_field, rule_dict_code, code)
VALUES ('Order', '工单', NULL, 'CoProduction', 'blade_order', 'id', 'plan_id', 'id', NULL, NULL, 'order_code');
INSERT INTO blade_meta_object_type_field (id, object_id, f_code, f_name, field, element_type, enum_type, seq)
VALUES (1595653060172640257, 'Order', 'plan_id', '计划', 'planId', '5', NULL, 0);
INSERT INTO blade_bas_coderule (id, name, remark, bill_form_id, system_default, auto_billno, repair_billno,
                                const_length, create_user, create_dept, create_time, update_user, update_time, status,
                                is_deleted, rule_field_dict_key, preview)
VALUES (1595657697210212353, '工单', '工单', 'Order', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201,
        '2022-11-24 13:56:56', 1123598821738675201, '2022-11-28 16:22:16', 1, 0, NULL, '-001');
INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
                                      element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                      add_style, code_only_by, code_element)
VALUES (1595657697231183873, 1595657697210212353, 1, 5, 'plan_id', 1, 0, '', '', 1, 1, '', '', '', 1, 0, 0, 1);
INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
                                      element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                      add_style, code_only_by, code_element)
VALUES (1595657697235378178, 1595657697210212353, 3, 0, '', NULL, 3, '', '', 1, 1, '', '', '0', 1, 0, 0, 1);
INSERT INTO blade_bas_coderule_entry (id, rule_id, seq, element_type, element_source, source_property, length, format,
                                      element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                      add_style, code_only_by, code_element)
VALUES (1595658353455210498, 1595657697210212353, 2, 1, '', NULL, 1, '', '-', 1, 1, '', '', '', 1, 0, 0, 1);
INSERT INTO blade_meta_ref_object_type (object_type_id, ref_object_type_id, field_name, id)
VALUES ('Order', 'CoPlan', 'plan_id', 1595657548199174145);

-- 计划编号编码规则
INSERT INTO blade_bas_coderule(id, name, remark, bill_form_id, system_default, auto_billno, repair_billno, const_length,
                               create_user, create_dept, create_time, update_user, update_time, status, is_deleted,
                               rule_field_dict_key, preview)
VALUES (1598203747095384066, '计划', '计划编码', 'CoPlan', 1, 0, 0, NULL, 1123598821738675201, 1123598813738675201,
        '2022-12-01 14:34:01', 1123598821738675201, '2022-12-01 14:34:03', 1, 0, NULL, '20221201-RS5-R-001');
INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
                                     element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                     add_style, code_only_by, code_element)
VALUES (1598203747158298626, 1598203747095384066, 1, 2, 'create_time', NULL, 8, 'yyyyMMdd', '', 1, 1, '-', '', '', 1, 0,
        0, 1);
INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
                                     element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                     add_style, code_only_by, code_element)
VALUES (1598203747162492929, 1598203747095384066, 2, 1, '', NULL, 3, '', 'RS5', 1, 1, '-', '', '', 1, 0, 0, 1);
INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
                                     element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                     add_style, code_only_by, code_element)
VALUES (1598203747166687234, 1598203747095384066, 3, 1, '', NULL, 1, '', 'R', 1, 1, '-', '', '', 1, 0, 0, 1);
INSERT INTO blade_bas_coderule_entry(id, rule_id, seq, element_type, element_source, source_property, length, format,
                                     element_value, seed, increment_step, separator_char, re_char, add_char, cut_style,
                                     add_style, code_only_by, code_element)
VALUES (1598203747166687235, 1598203747095384066, 4, 0, '', NULL, 3, '', '', 1, 1, '', '', '0', 1, 0, 0, 1);
INSERT INTO blade_meta_object_type_field(id, object_id, f_code, f_name, field, element_type, enum_type, seq)
VALUES (1598203200812453890, 'CoPlan', 'create_time', '创建时间', 'createTime', '2', NULL, 0);
INSERT INTO blade_dict (id, parent_id, code, dict_key, dict_value, sort, remark, is_sealed, is_deleted)
VALUES (1531090589473823540, 1531087267316621313, 'code_rule_for_biz_objects', 'CoPlan', '计划', 0, '', 0, 0);
INSERT INTO blade_meta_object_type(f_id, name, model_type_id, subsys_id, table_name, ref_code, ref_name, primary_key,
                                   rule_field, rule_dict_code, code)
VALUES ('CoPlan', '计划', NULL, 'CoProduction', 'blade_plan', 'id', 'code', 'id', NULL, NULL, 'code');
-- 数据权限
INSERT INTO blade_scope_api VALUES (1599960953099784192, 1599950099730957311, 'coproduction_plan.detail', '计划查看详情', '/blade-coproduction/plan/get/*', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784193, 1599950099730957311, 'coproduction_plan.page', '计划列表分页', '/blade-coproduction/plan/page', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784194, 1599948830497501186, 'coproduction_plan.save', '计划新增', '/blade-coproduction/plan/save', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784195, 1599948991642660865, 'coproduction_plan.modify', '计划修改', '/blade-coproduction/plan/modify', NULL, NULL, 'PUT', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784196, 1599950097730957313, 'coproduction_plan.remove', '计划删除', '/blade-coproduction/plan/remove', NULL, NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784197, 1599949565360533506, 'coproduction_plan.append', '计划追加', '/blade-coproduction/plan/append', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784198, 1599949740036517889, 'coproduction_plan.pause', '计划暂停', '/blade-coproduction/plan/pause', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784199, 1599950099730957312, 'coproduction_plan.reboot', '计划重启', '/blade-coproduction/plan/reboot', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784200, 1599949079353946114, 'coproduction_plan.template', '计划导入模板下载', '/blade-coproduction/plan/template', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784201, 1599949079353946114, 'coproduction_plan.import', '计划导入', '/blade-coproduction/plan/import', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784202, 1599949217078112257, 'coproduction_plan.export', '计划导出', '/blade-coproduction/plan/export', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784203, 1599950099730957313, 'coproduction_plan.finish', '计划完工', '/blade-coproduction/plan/finish', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784204, 1599949969905348609, 'coproduction_plan.close', '计划关闭', '/blade-coproduction/plan/close', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784205, 1599717873215295489, 'coproduction_plan.editWorkstation', '编辑工位', '/blade-coproduction/plan/editWorkstation', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);
INSERT INTO blade_scope_api VALUES (1599960953099784222, 1594521413162733569, 'coproduction_plan.statusCount', '计划页上方状态数量总览','/blade-coproduction/plan/statusCount', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,'2022-12-06 11:09:10', 1123598821738675201, '2022-12-06 11:09:10', 1, 0);


INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599961117681328130, 1599949426399047681, 'order.assign', '工单派发', '/blade-coproduction/order/assign', NULL,
        NULL, 'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 10:57:11', 1123598821738675201,
        '2022-12-06 10:57:11', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599961227261714434, 1594521413162733569, 'plan_process.list_by_plan_id', '计划工序列表',
        '/blade-coproduction/plan-process/list-by-plan-id', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-12-06 10:57:37', 1123598821738675201, '2022-12-06 10:57:37', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599961446795780098, 1594521413162733569, 'order_process.tree_workstation', '获取指派的工位组以及工位',
        '/blade-coproduction/order-process/tree-workstation', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 10:58:29', 1123598821738675201, '2022-12-06 10:58:29', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599961674936557570, 1594521413162733569, 'order.plan_order_list', '计划工单列表',
        '/blade-coproduction/order/plan-order-list', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
        '2022-12-06 10:59:24', 1123598821738675201, '2022-12-06 10:59:24', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599962064025362434, 1594521413162733569, 'plan.detail', 'blade_plan详情', '/blade-coproduction/plan/get/*', NULL,
        NULL, 'GET', 1123598821738675201, 1123598813738675201, '2022-12-06 11:00:57', 1123598821738675201,
        '2022-12-06 11:00:57', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599962305147510786, 1594524229658841089, 'order.list', '工单主页列表', '/blade-coproduction/order/list', NULL, NULL,
        'POST', 1123598821738675201, 1123598813738675201, '2022-12-06 11:01:54', 1123598821738675201,
        '2022-12-06 11:01:54', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599962398688878593, 1594524229658841089, 'order_process.detail', '工单工序详情',
        '/blade-coproduction/order-process/detail', NULL, NULL, 'GET', 1123598821738675201, 1123598813738675201,
        '2022-12-06 11:02:16', 1123598821738675201, '2022-12-06 11:02:16', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599962692835418114, 1594524229658841089, 'order_process.tree_workstation', '获取指派的工位组以及工位',
        '/blade-coproduction/order-process/tree-workstation', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:03:26', 1123598821738675201, '2022-12-06 11:03:26', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599962774611763201, 1594524229658841089, 'order_process.get_relation', '获取刀具、夹具信息',
        '/blade-coproduction/order-process/get-relation', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
        '2022-12-06 11:03:46', 1123598821738675201, '2022-12-06 11:03:46', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599966795124776961, 1599727121952526337, 'order_report_record.page_query', '分页查询工单报工记录',
        '/blade-coproduction/order-report-record/page-query', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:19:45', 1123598821738675201, '2022-12-06 11:19:45', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599967401986039809, 1599967268410040322, 'order_report_record.record_export', '导出报工记录',
        '/blade-coproduction/order-report-record/record-export', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:22:09', 1123598821738675201, '2022-12-06 11:22:09', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599969158061432833, 1599727121952526337, 'order_report_record.query_child_record', '查询主序下子序相关信息',
        '/blade-coproduction/order-report-record/query-child-record', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:29:08', 1123598821738675201, '2022-12-06 11:29:08', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970340100567042, 1599717707783557122, 'order_process.report_parallel', '报工(并行序)',
        '/blade-coproduction/order-process/report-parallel', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:33:50', 1123598821738675201, '2022-12-06 11:33:50', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970340104761345, 1599717707783557122, 'order_process.report_work', '报工(非并行序)',
        '/blade-coproduction/order-process/report-work', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
        '2022-12-06 11:33:50', 1123598821738675201, '2022-12-06 11:33:50', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970386216939521, 1599717577688829954, 'order_process.start_detail_general', '开工页面详情(非并行序)',
        '/blade-coproduction/order-process/start-detail-general', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970386216939522, 1599717577688829954, 'order_process.start_detail_parallel', '开工页面详情(并行序)',
        '/blade-coproduction/order-process/start-detail-parallel', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970386221133825, 1599717577688829954, 'order_process.start_general', '开工(非并行序)',
        '/blade-coproduction/order-process/start-general', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
        '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970386221133826, 1599717577688829954, 'order_process.start_parallel', '开工(并行序)',
        '/blade-coproduction/order-process/start-parallel', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:01', 1123598821738675201, '2022-12-06 11:34:01', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970399634518017, 1599725934163382273, 'order_report_record.edit_order_parallel_record', '编辑并行序报工记录',
        '/blade-coproduction/order-report-record/edit-parallel-record', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:04', 1123598821738675201, '2022-12-06 11:34:04', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970399638712321, 1599725934163382273, 'order_report_record.edit_order_record', '编辑非行序报工记录',
        '/blade-coproduction/order-report-record/edit-common-record', NULL, NULL, 'POST', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:04', 1123598821738675201, '2022-12-06 11:34:04', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970433344139265, 1599726500805464065, 'order_report_record.remove_report_record', '删除报工记录id',
        '/blade-coproduction/order-report-record/remove-report-record', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:12', 1123598821738675201, '2022-12-06 11:34:12', 1, 0);
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
                             create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
VALUES (1599970533021773826, 1599717577688829954, 'order_workstation.get_workstation_can_start', '获得可开工的工位)',
        '/blade-coproduction/order-workstation/get-workstation-can-start', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-06 11:34:36', 1123598821738675201, '2022-12-06 11:34:36', 1, 0);
INSERT INTO blade_boot.blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type,
                                        remark, http_method, create_user, create_dept, create_time,
                                        update_user, update_time, status, is_deleted)
VALUES (1601031782210977794, 1600664450734919681, 'order.remove', '计划工单删除', '/blade-coproduction/order/remove', NULL,
        NULL, 'DELETE', 1123598821738675201, 1123598813738675201, '2022-12-09 09:51:37', 1123598821738675201,
        '2022-12-09 09:51:37', 1, 0);
INSERT INTO `blade_scope_api` (`id`, `menu_id`, `resource_code`, `scope_name`, `scope_path`, `scope_type`, `remark`,
                               `http_method`, `create_user`, `create_dept`, `create_time`, `update_user`, `update_time`,
                               `status`, `is_deleted`)
VALUES (1602122216145076226, 1599725934163382273, 'order_report_record.report_records_detail', '编辑报工记录展开详情',
        '/blade-coproduction/order-report-record/report-record-detail', NULL, NULL, 'GET', 1123598821738675201,
        1123598813738675201, '2022-12-12 10:04:37', 1123598821738675201, '2022-12-12 10:04:37', 1, 0);