-- 凸焊数据（焊机参数上传）表及菜单（挂载：生产管理 / 工艺过程参数）
-- 说明：本工位无二维码/条码，表中不含 sn、line_sn

CREATE TABLE IF NOT EXISTS `mes_welder_param_record` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_date` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_date` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1删除 2停用）',
  `oprno` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工序号，如 OP030A',
  `ucode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作员工号/登录账号',
  `weld_count` int NOT NULL COMMENT '焊接计数（触发上传的计数值）',
  `spec_no` int NULL DEFAULT NULL COMMENT '当前规范号',
  `work_mode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作模式：焊接/调整',
  `run_state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '运行状态：运行/待机',
  `tooling_state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修模状态：修模/正常',
  `alarm_text` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警信息：无报警 / Erxx',
  `cap_voltage` int NULL DEFAULT NULL COMMENT '电容电压 V',
  `pre_press_time` int NULL DEFAULT NULL COMMENT '预压时间 t',
  `press_time` int NULL DEFAULT NULL COMMENT '加压时间 t',
  `spec_preheat_voltage` int NULL DEFAULT NULL COMMENT '规范-预热电压 V',
  `spec_preheat_current` int NULL DEFAULT NULL COMMENT '规范-预热电流',
  `spec_preheat_time` int NULL DEFAULT NULL COMMENT '规范-预热时间 ms',
  `spec_weld_voltage` int NULL DEFAULT NULL COMMENT '规范-焊接电压 V',
  `spec_weld_current` int NULL DEFAULT NULL COMMENT '规范-焊接电流',
  `spec_weld_time` int NULL DEFAULT NULL COMMENT '规范-焊接时间 ms',
  `spec_temper_voltage` int NULL DEFAULT NULL COMMENT '规范-回火电压 V',
  `spec_temper_current` int NULL DEFAULT NULL COMMENT '规范-回火电流',
  `spec_temper_time` int NULL DEFAULT NULL COMMENT '规范-回火时间 ms',
  `preheat_voltage` int NULL DEFAULT NULL COMMENT '结果-预热电压 V',
  `weld_voltage` int NULL DEFAULT NULL COMMENT '结果-焊接电压 V',
  `temper_voltage` int NULL DEFAULT NULL COMMENT '结果-回火电压 V',
  `preheat_peak_current` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结果-预热峰值电流',
  `weld_peak_current` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结果-焊接峰值电流',
  `temper_peak_current` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结果-回火峰值电流',
  `record_time` datetime NOT NULL COMMENT '客户端采集时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_welder_oprno_count` (`oprno`, `weld_count`) USING BTREE,
  KEY `idx_welder_oprno_time` (`oprno`, `record_time`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '凸焊数据（焊机参数）' ROW_FORMAT = DYNAMIC;

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
  'mesWelderParamRecord',
  m.`parent_code`,
  m.`parent_codes`,
  IFNULL(m.`tree_sort`, 0) + 2,
  m.`tree_sorts`,
  '1',
  m.`tree_level`,
  REPLACE(m.`tree_names`, SUBSTRING_INDEX(m.`tree_names`, '/', -1), '凸焊数据'),
  '凸焊数据',
  '1',
  '/mes/mesWelderParamRecord/list',
  '',
  IFNULL(m.`menu_icon`, 'icon-notebook'),
  '',
  '',
  'mes:mesWelderParamRecord:view,mes:mesWelderParamRecord:edit',
  IFNULL(m.`weight`, 40),
  '1',
  IFNULL(m.`sys_code`, 'default'),
  IFNULL(m.`module_codes`, 'core'),
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM `js_sys_menu` m
WHERE m.`menu_href` IN (
  '/mes/mesProductArcWelding/listSpot',
  '/mes/mesProductArcWelding/listArc',
  '/mes/mesProductGlueDuration/list',
  '/mes/mesProductQm/listWhitePart',
  '/mes/mesProductProd/list'
)
  AND NOT EXISTS (
    SELECT 1 FROM `js_sys_menu` x WHERE x.`menu_code` = 'mesWelderParamRecord'
  )
ORDER BY
  CASE m.`menu_href`
    WHEN '/mes/mesProductArcWelding/listSpot' THEN 1
    WHEN '/mes/mesProductArcWelding/listArc' THEN 2
    ELSE 9
  END,
  m.`update_date` DESC
LIMIT 1;

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
  'mesWelderParamRecordEdit',
  'mesWelderParamRecord',
  CONCAT(m.`parent_codes`, 'mesWelderParamRecord,'),
  30,
  CONCAT(m.`tree_sorts`, '0000000030,'),
  '1',
  m.`tree_level` + 1,
  CONCAT(m.`tree_names`, '/编辑'),
  '编辑',
  '2',
  '',
  '',
  '',
  '',
  '',
  'mes:mesWelderParamRecord:edit',
  30,
  '1',
  IFNULL(m.`sys_code`, 'default'),
  IFNULL(m.`module_codes`, 'core'),
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM `js_sys_menu` m
WHERE m.`menu_code` = 'mesWelderParamRecord'
  AND NOT EXISTS (
    SELECT 1 FROM `js_sys_menu` x WHERE x.`menu_code` = 'mesWelderParamRecordEdit'
  )
LIMIT 1;