20 lines
403 B
SQL
20 lines
403 B
SQL
-- 查询所有订单和工单相关的菜单配置
|
|
SELECT
|
|
menu_id,
|
|
menu_name,
|
|
parent_id,
|
|
order_num,
|
|
path,
|
|
component,
|
|
query,
|
|
menu_type,
|
|
visible
|
|
FROM sys_menu
|
|
WHERE menu_name LIKE '%订单%'
|
|
OR menu_name LIKE '%工单%'
|
|
OR path LIKE '%order%'
|
|
OR path LIKE '%work%'
|
|
OR component LIKE '%order%'
|
|
OR component LIKE '%work%'
|
|
ORDER BY parent_id, order_num;
|