mescloud/db/mysql/add_mes_integrated_screen.sql

-- 智能中控大屏配置及错误 URL 修正
-- 1. 修正 /js/a/js/a/ 重复前缀
-- 2. 修正缺少 context-path 的 /a/... 路径

UPDATE mes_screen_config
SET screen_url = REPLACE(screen_url, '/js/a/js/a/', '/js/a/')
WHERE screen_url LIKE '%/js/a/js/a/%';

UPDATE mes_screen_config
SET screen_url = CONCAT('/js/a/', SUBSTRING(screen_url, 6))
WHERE screen_url LIKE 'js/a/%';

UPDATE mes_screen_config
SET screen_url = CONCAT('/js', screen_url)
WHERE screen_url LIKE '/a/%'
  AND screen_url NOT LIKE '/js/%';

INSERT INTO mes_screen_config (
	id,
	screen_name,
	screen_code,
	screen_url,
	screen_type,
	play_duration,
	sort_order,
	is_enabled,
	remarks,
	create_by,
	create_date,
	update_by,
	update_date
)
SELECT
	'mes_integrated_screen',
	'MES智能中控大屏',
	'MES_INTEGRATED_SCREEN',
	'/js/a/mes/mesProduct/integratedScreen',
	'生产管理',
	60,
	10,
	'1',
	'智能中控大屏，含生产订单、品质指标、设备状态等模块',
	'system',
	NOW(),
	'system',
	NOW()
WHERE NOT EXISTS (
	SELECT 1 FROM mes_screen_config WHERE screen_code = 'MES_INTEGRATED_SCREEN'
);