From fbaeeeff5704f210bc6347454c0f16d255001822 Mon Sep 17 00:00:00 2001 From: gaoluyang <2820782392@qq.com> Date: 星期三, 04 十一月 2026 16:32:09 +0800 Subject: [PATCH] refactor(srm): 重构供应商采购域，新增询价比价与保证金管理 --- yudao-module-srm/src/main/resources/sql/srm_menu_init.sql | 118 +++++++++++++++++------------------------------------------ 1 files changed, 34 insertions(+), 84 deletions(-) diff --git a/yudao-module-srm/src/main/resources/sql/srm_menu_init.sql b/yudao-module-srm/src/main/resources/sql/srm_menu_init.sql index 1887397..70619f5 100644 --- a/yudao-module-srm/src/main/resources/sql/srm_menu_init.sql +++ b/yudao-module-srm/src/main/resources/sql/srm_menu_init.sql @@ -1,100 +1,50 @@ -- ===================================================== --- SRM 妯″潡鑿滃崟鏁版嵁 +-- SRM 妯″潡鑿滃崟鏁版嵁锛堟柊搴撳垵濮嬪寲鐢級 +-- 宸茬Щ闄わ細渚涘簲鍟嗗噯鍏�/璧勮川/缁╂晥/鎷涙姇鏍�/缁熻鍒嗘瀽 +-- 淇濈暀锛氫緵搴斿晢妗ｆ銆佽浠锋瘮浠枫�佹姇鏍囦繚璇侀噾銆佷緵搴斿晢寰�鏉� +-- 璇存槑锛氫娇鐢� INSERT IGNORE锛岄噸澶嶆墽琛屼笉浼氭姤涓婚敭鍐茬獊銆� -- ===================================================== --- 1. 浜岀骇鐩綍锛歋RM 渚涘簲鍟嗙鐞嗭紙鎸傚湪閲囪喘绠＄悊涓嬶級 -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES -(602524, 'SRM 渚涘簲鍟嗙鐞�', '', 1, 5, 2602, 'srm', 'ep:avatar', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +-- 1. 渚涘簲鍟嗘。妗堬紙鐩存帴鎸傚湪閲囪喘绠＄悊鏍硅彍鍗曚笅锛� +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +VALUES (602525, '渚涘簲鍟嗘。妗�', '', 2, 1, 2602, 'supplier', 'ep:document', 'srm/supplier/index', 'SrmSupplier', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); --- 2. 渚涘簲鍟嗘。妗� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602525, '渚涘簲鍟嗘。妗�', '', 2, 10, 602524, 'supplier', 'ep:document', 'srm/supplier/index', 'SrmSupplier', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (602526, '渚涘簲鍟嗘煡璇�', 'srm:supplier:query', 3, 1, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (602527, '渚涘簲鍟嗗垱寤�', 'srm:supplier:create', 3, 2, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (602528, '渚涘簲鍟嗘洿鏂�', 'srm:supplier:update', 3, 3, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602529, '渚涘簲鍟嗗垹闄�', 'srm:supplier:delete', 3, 4, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +(602529, '渚涘簲鍟嗗垹闄�', 'srm:supplier:delete', 3, 4, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(1075301, '渚涘簲鍟嗗鍑�', 'srm:supplier:export', 3, 5, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(1075302, '渚涘簲鍟嗗鍏�', 'srm:supplier:import', 3, 6, 602525, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); --- 3. 渚涘簲鍟嗗噯鍏� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602530, '渚涘簲鍟嗗噯鍏�', '', 2, 20, 602524, 'supplier-apply', 'ep:checked', 'srm/supplierApply/index', 'SrmSupplierApply', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +-- 2. 璇环姣斾环 +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +VALUES (602620, '璇环姣斾环', '', 2, 2, 2602, 'inquiry', 'ep:search', 'srm/inquiry/index', 'SrmInquiry', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES -(602531, '鍑嗗叆鏌ヨ', 'srm:supplier-apply:query', 3, 1, 602530, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602532, '鍑嗗叆鍒涘缓', 'srm:supplier-apply:create', 3, 2, 602530, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602533, '鍑嗗叆鏇存柊', 'srm:supplier-apply:update', 3, 3, 602530, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602534, '鍑嗗叆鍒犻櫎', 'srm:supplier-apply:delete', 3, 4, 602530, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +(602621, '璇环鏌ヨ', 'srm:inquiry:query', 3, 1, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602622, '璇环鍒涘缓', 'srm:inquiry:create', 3, 2, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602623, '璇环鏇存柊', 'srm:inquiry:update', 3, 3, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602624, '璇环鍒犻櫎', 'srm:inquiry:delete', 3, 4, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602625, '璇环纭杞鍗�', 'srm:inquiry:confirm', 3, 5, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602626, '璇环褰曞叆鎶ヤ环', 'srm:inquiry:quote', 3, 6, 602620, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); --- 4. 渚涘簲鍟嗚祫璐� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602535, '渚涘簲鍟嗚祫璐�', '', 2, 30, 602524, 'supplier-certificate', 'ep:medal', 'srm/supplierCertificate/index', 'SrmSupplierCertificate', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +-- 3. 鎶曟爣淇濊瘉閲� +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +VALUES (602630, '鎶曟爣淇濊瘉閲�', '', 2, 3, 2602, 'bid-bond', 'ep:money', 'srm/bidBond/index', 'SrmBidBond', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES -(602536, '璧勮川鏌ヨ', 'srm:supplier-certificate:query', 3, 1, 602535, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602537, '璧勮川鍒涘缓', 'srm:supplier-certificate:create', 3, 2, 602535, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602538, '璧勮川鏇存柊', 'srm:supplier-certificate:update', 3, 3, 602535, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602539, '璧勮川鍒犻櫎', 'srm:supplier-certificate:delete', 3, 4, 602535, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +(602631, '淇濊瘉閲戞煡璇�', 'srm:bid-bond:query', 3, 1, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602632, '淇濊瘉閲戝垱寤�', 'srm:bid-bond:create', 3, 2, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602633, '淇濊瘉閲戞洿鏂�', 'srm:bid-bond:update', 3, 3, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), +(602634, '淇濊瘉閲戝垹闄�', 'srm:bid-bond:delete', 3, 4, 602630, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); --- 5. 渚涘簲鍟嗙哗鏁� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602540, '渚涘簲鍟嗙哗鏁�', '', 2, 40, 602524, 'supplier-evaluation', 'ep:data-analysis', 'srm/supplierEvaluation/index', 'SrmSupplierEvaluation', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +-- 4. 渚涘簲鍟嗗線鏉ワ紙閲囪喘绠＄悊鏍硅彍鍗曚笅锛� +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +VALUES (602640, '渚涘簲鍟嗗線鏉�', '', 2, 8, 2602, 'supplier-statement', 'ep:wallet', 'erp/purchase/statement/index', 'ErpSupplierStatement', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES -(602541, '璇勪环鏌ヨ', 'srm:supplier-evaluation:query', 3, 1, 602540, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602542, '璇勪环鍒涘缓', 'srm:supplier-evaluation:create', 3, 2, 602540, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602543, '璇勪环鏇存柊', 'srm:supplier-evaluation:update', 3, 3, 602540, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602544, '璇勪环鍒犻櫎', 'srm:supplier-evaluation:delete', 3, 4, 602540, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - --- 6. 鎷涙姇鏍囩鐞� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602545, '鎷涙姇鏍囩鐞�', '', 2, 50, 602524, 'tender', 'ep:files', 'srm/tender/index', 'SrmTender', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES --- 鎷涙爣椤圭洰 -(602546, '鎷涙爣鏌ヨ', 'srm:tender-project:query', 3, 1, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602547, '鎷涙爣鍒涘缓', 'srm:tender-project:create', 3, 2, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602548, '鎷涙爣鏇存柊', 'srm:tender-project:update', 3, 3, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602549, '鎷涙爣鍒犻櫎', 'srm:tender-project:delete', 3, 4, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), --- 鎶曟爣 -(602550, '鎶曟爣鏌ヨ', 'srm:tender-bid:query', 3, 5, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602551, '鎶曟爣鍒涘缓', 'srm:tender-bid:create', 3, 6, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602552, '鎶曟爣鏇存柊', 'srm:tender-bid:update', 3, 7, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), --- 鎶ヤ环 -(602553, '鎶ヤ环鏌ヨ', 'srm:supplier-quote:query', 3, 8, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602554, '鎶ヤ环鍒涘缓', 'srm:supplier-quote:create', 3, 9, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602555, '鎶ヤ环鏇存柊', 'srm:supplier-quote:update', 3, 10, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), --- 璇勬爣 -(602556, '璇勬爣鏌ヨ', 'srm:bid-evaluation:query', 3, 11, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602557, '璇勬爣鍒涘缓', 'srm:bid-evaluation:create', 3, 12, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602558, '璇勬爣鏇存柊', 'srm:bid-evaluation:update', 3, 13, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), --- 寮�鏍� -(602559, '寮�鏍囨煡璇�', 'srm:bid-open:query', 3, 14, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602560, '寮�鏍囧垱寤�', 'srm:bid-open:create', 3, 15, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), --- 瀹氭爣 -(602561, '瀹氭爣鏌ヨ', 'srm:bid-award:query', 3, 16, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602562, '瀹氭爣鍒涘缓', 'srm:bid-award:create', 3, 17, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602563, '瀹氭爣鏇存柊', 'srm:bid-award:update', 3, 18, 602545, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - --- 7. 鎷涙姇鏍囬厤缃� -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602612, '鎷涙姇鏍囬厤缃�', '', 2, 55, 602524, 'tender-config', 'ep:setting', 'srm/tender/config/index', 'SrmTenderConfig', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES -(602613, '閰嶇疆鏌ヨ', 'srm:tender-config:query', 3, 1, 602612, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), -(602614, '閰嶇疆鏇存柊', 'srm:tender-config:update', 3, 2, 602612, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - --- 8. 缁熻鍒嗘瀽 -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES (602569, '缁熻鍒嗘瀽', '', 2, 70, 602524, 'statistics', 'ep:trend-charts', 'srm/statistics/index', 'SrmStatistics', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); - -INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) -VALUES -(602570, '缁熻鏌ヨ', 'srm:statistics:query', 3, 1, 602569, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); +INSERT IGNORE INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) +VALUES (602641, '渚涘簲鍟嗗線鏉ユ煡璇�', 'erp:supplier-statement:query', 3, 1, 602640, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -- Gitblit v1.9.3