mescloud/_apk_work/query_menus.sql

SELECT '==== PDA CATEGORIES ====' AS t;
SELECT id, title, sort_order, status FROM mes_icons_category ORDER BY sort_order, title;

SELECT '==== PDA ICONS ====' AS t;
SELECT IFNULL(c.title,'未分类') AS category, i.title AS icon, i.mode, i.auth, i.status
FROM mes_icons i
LEFT JOIN mes_icons_category c ON c.id = i.category_id
WHERE i.status = '0'
ORDER BY IFNULL(c.sort_order,9999), IFNULL(c.title,''), i.title;

SELECT '==== GROUPED CONFIG ====' AS t;
SELECT config_key, config_value FROM js_sys_config WHERE config_key LIKE 'mes.icons%';

SELECT '==== SYS MENU ====' AS t;
SELECT tree_level, menu_name, menu_href, is_show, permission, parent_code, menu_code, tree_sorts
FROM js_sys_menu
WHERE status='0' AND menu_type IN ('1','0') AND is_show='1'
ORDER BY tree_sorts, tree_sort;

SELECT '==== LINE PROCESS ====' AS t;
SELECT l.sn AS line_sn, l.title AS line_title, p.oprno, p.title AS process_title, p.status
FROM mes_line_process p
LEFT JOIN mes_line l ON l.id = p.line_id OR l.sn = p.line_sn
WHERE p.status='0'
ORDER BY l.sn, p.oprno;