25 lines
424 B
SQL
25 lines
424 B
SQL
-- 查询工单管理相关的菜单配置
|
|
SELECT
|
|
menu_id,
|
|
menu_name,
|
|
parent_id,
|
|
order_num,
|
|
path,
|
|
component,
|
|
query,
|
|
is_frame,
|
|
is_cache,
|
|
menu_type,
|
|
visible,
|
|
status,
|
|
perms,
|
|
icon,
|
|
create_time,
|
|
update_time,
|
|
remark
|
|
FROM sys_menu
|
|
WHERE menu_name LIKE '%工单%'
|
|
OR path LIKE '%work_order%'
|
|
OR component LIKE '%work_order%'
|
|
ORDER BY parent_id, order_num;
|