mescloud/db/mysql/add_mes_quality_screen.sql

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_quality_screen',
	'质量管理看板',
	'MES_QUALITY_SCREEN',
	'/js/a/mes/mesProduct/qualityScreen',
	'质量管理',
	60,
	60,
	'1',
	'基于过程检查、首件检查、NG、返修、报废记录展示最近7天生产过程质量状态，不包含来料质量数据',
	'system',
	NOW(),
	'system',
	NOW()
WHERE NOT EXISTS (
	SELECT 1 FROM mes_screen_config WHERE screen_code = 'MES_QUALITY_SCREEN'
);