mescloud/db/mysql/add_mes_screen_notice_honor.sql

-- 智能中控大屏：通知栏、荣誉墙
-- 父菜单：生产管理 (menu_code: 1672118505143263232)

CREATE TABLE IF NOT EXISTS `mes_screen_notice` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `title` varchar(100) DEFAULT '' COMMENT '标题（后台列表用）',
  `content` varchar(1000) DEFAULT '' COMMENT '通知正文',
  `publish_date` datetime DEFAULT NULL COMMENT '发布日期',
  `sort_order` int DEFAULT 0 COMMENT '排序，越小越靠前',
  `is_enabled` char(1) DEFAULT '1' COMMENT '是否上屏：1是 0否',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mes_screen_notice_sort` (`is_enabled`, `sort_order`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='大屏通知栏';

CREATE TABLE IF NOT EXISTS `mes_screen_honor` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `honor_title` varchar(50) DEFAULT '闪耀之星' COMMENT '奖项标题',
  `emp_name` varchar(50) DEFAULT '' COMMENT '姓名',
  `dept_name` varchar(100) DEFAULT '' COMMENT '部门',
  `sort_order` int DEFAULT 0 COMMENT '排序，越小越靠前',
  `is_enabled` char(1) DEFAULT '1' COMMENT '是否上屏：1是 0否',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mes_screen_honor_sort` (`is_enabled`, `sort_order`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='大屏荣誉墙';

-- 生产管理 / 大屏通知
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
  'mesScreenNotice',
  '1672118505143263232',
  '0,1672118505143263232,',
  160,
  '0000009290,0000000160,',
  '0',
  1,
  '生产管理/大屏通知',
  '大屏通知',
  '1',
  '/mes/mesScreenNotice/list',
  '',
  'icon-speech',
  '',
  '',
  'mes:mesScreenNotice:view',
  80,
  '1',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesScreenNotice'
);

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
  'mesScreenNoticeEdit',
  'mesScreenNotice',
  '0,1672118505143263232,mesScreenNotice,',
  30,
  '0000009290,0000000160,0000000030,',
  '1',
  2,
  '生产管理/大屏通知/编辑',
  '编辑',
  '2',
  '',
  '',
  '',
  '',
  '',
  'mes:mesScreenNotice:edit',
  40,
  '0',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesScreenNoticeEdit'
);

-- 生产管理 / 荣誉榜单
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
  'mesScreenHonor',
  '1672118505143263232',
  '0,1672118505143263232,',
  161,
  '0000009290,0000000161,',
  '0',
  1,
  '生产管理/荣誉榜单',
  '荣誉榜单',
  '1',
  '/mes/mesScreenHonor/list',
  '',
  'icon-trophy',
  '',
  '',
  'mes:mesScreenHonor:view',
  80,
  '1',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesScreenHonor'
);

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
  'mesScreenHonorEdit',
  'mesScreenHonor',
  '0,1672118505143263232,mesScreenHonor,',
  30,
  '0000009290,0000000161,0000000030,',
  '1',
  2,
  '生产管理/荣誉榜单/编辑',
  '编辑',
  '2',
  '',
  '',
  '',
  '',
  '',
  'mes:mesScreenHonor:edit',
  40,
  '0',
  'default',
  'core',
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = 'mesScreenHonorEdit'
);