From a1d1d928893c33fad6694b2503a425ab29af0a15 Mon Sep 17 00:00:00 2001 From: chen.lin <1442464845@qq.com> Date: 星期三, 04 三月 2026 14:52:49 +0800 Subject: [PATCH] 云仓WMS接口流程 --- version/db/wave_menu.sql | 37 +++++++++++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/version/db/wave_menu.sql b/version/db/wave_menu.sql new file mode 100644 index 0000000..72d4535 --- /dev/null +++ b/version/db/wave_menu.sql @@ -0,0 +1,37 @@ +-- 娉㈡绠＄悊鑿滃崟锛氳嫢 sys_menu 涓凡瀛樺湪 component='wave' 鐨勮彍鍗曞垯璺宠繃 +-- 鎵ц鍚庨渶鍦ㄣ�愮郴缁熺鐞� -> 瑙掕壊绠＄悊 -> 鍒嗛厤鏉冮檺銆戜腑涓哄搴旇鑹插嬀閫夈�屾尝娆＄鐞嗐�嶅苟淇濆瓨锛岃彍鍗曟墠浼氬湪渚ф爮鏄剧ず + +INSERT INTO `sys_menu` (`name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 'menu.wave', 0, NULL, '', '', '/orders/wave', 'wave', NULL, NULL, 0, NULL, 'Waves', 0, NULL, 1, 1, 0, NOW(), NULL, NOW(), NULL, '娉㈡绠＄悊' +FROM DUAL +WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `component` = 'wave' AND `type` = 0 LIMIT 1); + +-- 娉㈡绠＄悊-鍒楄〃鏌ヨ鏉冮檺锛堣闂尝娆″垪琛ㄩ〉鍜屾帴鍙ｉ渶瑕侊級 +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `path_name`, `route`, `component`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Query 娉㈡', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), NULL, NULL, NULL, 1, 'manager:wave:list', 0, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; + +-- 娉㈡绠＄悊-淇濆瓨鏉冮檺 +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Create 娉㈡', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), 1, 'manager:wave:save', 1, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; + +-- 娉㈡绠＄悊-鏇存柊鏉冮檺 +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Update 娉㈡', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), 1, 'manager:wave:update', 2, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; + +-- 娉㈡绠＄悊-鍒犻櫎鏉冮檺 +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Delete 娉㈡', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), 1, 'manager:wave:remove', 3, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; + +-- 娉㈡鏄庣粏-鍒楄〃鏉冮檺锛堣繘鍏ユ尝娆℃槑缁嗛渶 manager:waveItem:list锛岃嫢鎺ュ彛鏈夎姹傚彲鍐嶅姞锛� +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Query 娉㈡鏄庣粏', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), 1, 'manager:waveItem:list', 4, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; + +-- 娉㈡鏄庣粏-鏇存柊鏉冮檺锛堜笅鍙戜换鍔＄瓑鎿嶄綔锛� +INSERT INTO `sys_menu` (`name`, `parent_id`, `path`, `type`, `authority`, `sort`, `tenant_id`, `status`, `deleted`) +SELECT 'Update 娉㈡鏄庣粏', m.id, CONCAT(IFNULL(m.path,''), ',', m.id), 1, 'manager:waveItem:update', 5, 1, 1, 0 +FROM `sys_menu` m WHERE m.component = 'wave' AND m.type = 0 LIMIT 1; -- Gitblit v1.9.1