mescloud/db/mysql/mes_screen.sql

-- 大屏目录：名称、地址、说明，供大屏管理新增和删除

CREATE TABLE IF NOT EXISTS `mes_screen` (
  `id` varchar(64) NOT NULL,
  `title` varchar(100) DEFAULT '' COMMENT '名称',
  `screen_url` varchar(255) DEFAULT '' COMMENT '地址',
  `remark` varchar(255) DEFAULT '' COMMENT '说明',
  `sort_no` int(11) DEFAULT 30 COMMENT '排序',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1删除 2停用）',
  `create_by` varchar(64) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='大屏目录';

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051001', '综合数据大屏', '/mes/mesProduct/screen', '车间总览，看产量、工位和报警。', 10, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051001');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051002', '生产运营看板', '/mes/mesProduct/screen10', '现场远看。达成率、直通率、OEE、班次报工和分段完工。', 20, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051002');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051003', '生产简报', '/mes/mesProduct/screen11', '领导近看。今天完成多少、质量是否稳、近七日走势，以及该过问的事项。', 30, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051003');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051004', '返修区看板', '/mes/mesProduct/screen9', '待返修、待检查、今日完成和返修清单。', 40, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051004');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051005', 'GP12不良问题点看板', '/mes/mesProduct/screen8', 'GP12 检验项目、判定标准和不良问题点。', 50, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051005');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051006', '加工记录（OP010-OP100）', '/mes/mesProduct/screen5', '前段工位加工数量，默认工位可在屏上调整。', 60, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051006');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051007', '加工记录（OP110-OP190）', '/mes/mesProduct/screen6', '中段工位加工数量，默认工位可在屏上调整。', 70, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051007');

INSERT INTO `mes_screen` (`id`, `title`, `screen_url`, `remark`, `sort_no`, `status`, `create_by`, `create_date`, `update_by`, `update_date`)
SELECT '2099051008', '加工记录（OP200-OP360）', '/mes/mesProduct/screen7', '后段工位加工数量，默认工位可在屏上调整。', 80, '0', 'system', NOW(), 'system', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `mes_screen` WHERE `id` = '2099051008');

UPDATE `js_sys_menu`
SET `menu_href` = '/mes/mesScreen/list',
    `permission` = 'mes:mesScreen:view,mes:mesScreen:edit',
    `update_by` = 'system',
    `update_date` = NOW()
WHERE `menu_code` = '2099051000000000001';