-- 物料拆分
ALTER TABLE `883web`.mini_sales_returns_materials ADD order_no varchar(100) NULL COMMENT '订单号';
ALTER TABLE `883web`.mini_process_report ADD order_no varchar(100) NULL COMMENT '订单号';
ALTER TABLE `883web`.mini_production_schedule ADD order_no varchar(100) NULL COMMENT '订单号';
ALTER TABLE `883web`.mini_extrusion_schedule_detail ADD order_no varchar(100) NULL COMMENT '订单号';
ALTER TABLE `883web`.mini_product_receipt ADD order_no varchar(100) NULL COMMENT '订单号';

ALTER TABLE `883web`.mini_production_schedule ADD status TINYINT DEFAULT 0 NULL COMMENT '状态 0-未排产 1-已排产';
ALTER TABLE `883web`.mini_extrusion_schedule_detail ADD status TINYINT DEFAULT 0 NULL COMMENT '状态 0-未完 1-完成';

ALTER TABLE mini_process_report
ADD COLUMN mold_code VARCHAR(100) COMMENT '模具编码',
ADD COLUMN mold_model VARCHAR(100) COMMENT '模具型号',
ADD COLUMN mold_thickness DECIMAL(15,4) COMMENT '模厚',
ADD COLUMN mold_manufacturer VARCHAR(100) COMMENT '模具厂家',
ADD COLUMN mold_color VARCHAR(100) COMMENT '颜色',
ADD COLUMN mold_change_reason TEXT COMMENT '换模原因',
ADD COLUMN rod_count INT COMMENT '用棒支数';

ALTER TABLE mini_process_report
ADD COLUMN stock_quantity int DEFAULT 0 COMMENT '已入库数量';

-- 新增菜单
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_jy', 
'/mini/productionManagement/processReport?type=jy', 
'mini/productionManagement/processReport?type=jy', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "挤压报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_dk', 
'/mini/productionManagement/processReport?type=dk', 
'mini/productionManagement/processReport?type=dk', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "打孔报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_jingpin', 
'/mini/productionManagement/processReport?type=jingpin', 
'mini/productionManagement/processReport?type=jingpin', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "精品报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_yanghua1', 
'/mini/productionManagement/processReport?type=yanghua1', 
'mini/productionManagement/processReport?type=yanghua1', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "氧化上排报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_yanghua2', 
'/mini/productionManagement/processReport?type=yanghua2', 
'mini/productionManagement/processReport?type=yanghua2', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "氧化下排报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_jingqie', 
'/mini/productionManagement/processReport?type=jingqie', 
'mini/productionManagement/processReport?type=jingqie', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "精切报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);
INSERT INTO `883web`.sys_menu
(parent, name, `path`, component, redirect, meta, status, create_by, sort)
VALUES('processReportManage', 'processReport_bz', 
'/mini/productionManagement/processReport?type=bz', 
'mini/productionManagement/processReport?type=bz', NULL, 
'{"icon": "", "type": "menu", "affix": null, "color": null, "title": "包装报工", "active": null, "hidden": false, "hiddenBreadcrumb": false}', '0', '', NULL);