mescloud/db/mysql/add_mes_material_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_material_screen',
	'物料管理看板',
	'MES_MATERIAL_SCREEN',
	'/js/a/mes/mesMaterial/materialScreen',
	'物料管理',
	60,
	70,
	'1',
	'基于物料、库存、报检、来料检查、入库、出库、领料、不良、退货、报废记录展示物料管理状态',
	'system',
	NOW(),
	'system',
	NOW()
WHERE NOT EXISTS (
	SELECT 1 FROM mes_screen_config WHERE screen_code = 'MES_MATERIAL_SCREEN'
);