| | |
| | | WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = 0); |
| | | |
| | | INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) |
| | | SELECT '提交质检', 'mes:qc-seed-quality:submit', 3, 1, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' |
| | | SELECT '查询质检', 'mes:qc-seed-quality:query', 3, 1, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' |
| | | FROM system_menu |
| | | WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = 0 |
| | | AND NOT EXISTS ( |
| | | SELECT 1 FROM system_menu child |
| | | WHERE child.parent_id = system_menu.id |
| | | AND child.permission = 'mes:qc-seed-quality:query' |
| | | AND child.deleted = 0 |
| | | ); |
| | | |
| | | INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) |
| | | SELECT '提交质检', 'mes:qc-seed-quality:submit', 3, 2, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0' |
| | | FROM system_menu |
| | | WHERE parent_id = 5500 AND path = 'seed-quality' AND deleted = 0 |
| | | AND NOT EXISTS ( |