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_test_data.sql | 101 ++++++++++++-------------------------------------- 1 files changed, 25 insertions(+), 76 deletions(-) diff --git a/yudao-module-srm/src/main/resources/sql/srm_test_data.sql b/yudao-module-srm/src/main/resources/sql/srm_test_data.sql index 87461a5..e0752e6 100644 --- a/yudao-module-srm/src/main/resources/sql/srm_test_data.sql +++ b/yudao-module-srm/src/main/resources/sql/srm_test_data.sql @@ -1,90 +1,39 @@ -- ===================================================== -- SRM 妯″潡娴嬭瘯鏁版嵁 -- 杩愯鍓嶈鍏堢‘淇� srm_init.sql 宸叉墽琛� +-- 浠呭寘鍚細渚涘簲鍟嗐�佽仈绯讳汉銆侀摱琛岃处鎴枫�佸垎绫诲叧鑱� +-- 璇环/淇濊瘉閲戞暟鎹閫氳繃椤甸潰鎴栨帴鍙ｅ垱寤猴紝閬垮厤涓庣湡瀹炲崟鎹紪鍙峰啿绐� -- ===================================================== -- 1. 渚涘簲鍟嗘祴璇曟暟鎹� -INSERT INTO srm_supplier (id, code, name, type, status, contact_name, contact_mobile, contact_email, address, bank_name, bank_account, tax_no, remark, create_time, update_time, creator, updater, deleted) +INSERT IGNORE INTO srm_supplier (id, code, name, type, status, contact_name, contact_mobile, contact_email, address, bank_name, bank_account, tax_no, remark, create_time, update_time, creator, updater, deleted) VALUES -(1001, 'SUP-20240001', '姹熻嫃鏅鸿兘鍒堕�犳湁闄愬叕鍙�', 1, 1, '寮犱笁', '13800001111', 'zhangsan@test.com', '姹熻嫃鐪佸崡浜競姹熷畞鍖簒x璺�100鍙�', '涓浗閾惰鍗椾含鍒嗚', '6222024301000000001', '91320115MA1XXXXXX1', '浼樿川渚涘簲鍟�', NOW(), NOW(), 'admin', 'admin', 0), -(1002, 'SUP-20240002', '涓婃捣璐告槗杩涘嚭鍙ｅ叕鍙�', 2, 1, '鏉庡洓', '13800002222', 'lisi@test.com', '涓婃捣甯傛郸涓滄柊鍖簒x璺�200鍙�', '宸ュ晢閾惰涓婃捣鍒嗚', '1002024301000000002', '91310115MA2XXXXXX2', '闀挎湡鍚堜綔', NOW(), NOW(), 'admin', 'admin', 0), -(1003, 'SUP-20240003', '娣卞湷绉戞妧鏈嶅姟鏈夐檺鍏徃', 3, 1, '鐜嬩簲', '13800003333', 'wangwu@test.com', '娣卞湷甯傚崡灞卞尯xx璺�300鍙�', '鎷涘晢閾惰娣卞湷鍒嗚', '6225884301000000003', '91440300MA3XXXXXX3', '鏂颁緵搴斿晢', NOW(), NOW(), 'admin', 'admin', 0), -(1004, 'SUP-20240004', '娴欐睙绮惧瘑鏈烘鏈夐檺鍏徃', 1, 0, '璧靛叚', '13800004444', 'zhaoliu@test.com', '娴欐睙鐪佹澀宸炲競瑗挎箹鍖簒x璺�400鍙�', '寤鸿閾惰鏉窞鍒嗚', '6227004301000000004', '91330100MA4XXXXXX4', '鏆傚仠鍚堜綔', NOW(), NOW(), 'admin', 'admin', 0); +(1001, 'SUP-20240001', '姹熻嫃鏅鸿兘鍒堕�犳湁闄愬叕鍙�', 1, 0, '寮犱笁', '13800001111', 'zhangsan@test.com', '姹熻嫃鐪佸崡浜競姹熷畞鍖簒x璺�100鍙�', '涓浗閾惰鍗椾含鍒嗚', '6222024301000000001', '91320115MA1XXXXXX1', '浼樿川渚涘簲鍟�', NOW(), NOW(), 'admin', 'admin', b'0'), +(1002, 'SUP-20240002', '涓婃捣璐告槗杩涘嚭鍙ｅ叕鍙�', 2, 0, '鏉庡洓', '13800002222', 'lisi@test.com', '涓婃捣甯傛郸涓滄柊鍖簒x璺�200鍙�', '宸ュ晢閾惰涓婃捣鍒嗚', '1002024301000000002', '91310115MA2XXXXXX2', '闀挎湡鍚堜綔', NOW(), NOW(), 'admin', 'admin', b'0'), +(1003, 'SUP-20240003', '娣卞湷绉戞妧鏈嶅姟鏈夐檺鍏徃', 3, 0, '鐜嬩簲', '13800003333', 'wangwu@test.com', '娣卞湷甯傚崡灞卞尯xx璺�300鍙�', '鎷涘晢閾惰娣卞湷鍒嗚', '6225884301000000003', '91440300MA3XXXXXX3', '鏂颁緵搴斿晢', NOW(), NOW(), 'admin', 'admin', b'0'), +(1004, 'SUP-20240004', '娴欐睙绮惧瘑鏈烘鏈夐檺鍏徃', 1, 1, '璧靛叚', '13800004444', 'zhaoliu@test.com', '娴欐睙鐪佹澀宸炲競瑗挎箹鍖簒x璺�400鍙�', '寤鸿閾惰鏉窞鍒嗚', '6227004301000000004', '91330100MA4XXXXXX4', '鏆傚仠鍚堜綔', NOW(), NOW(), 'admin', 'admin', b'0'); --- 2. 渚涘簲鍟嗚仈绯讳汉 -INSERT INTO srm_supplier_contact (id, supplier_id, name, mobile, email, position, is_primary, remark, create_time, update_time, creator, updater, deleted) +-- 2. 渚涘簲鍟嗚仈绯讳汉锛堟瘡涓緵搴斿晢涓�鏉￠粯璁よ仈绯讳汉锛� +INSERT IGNORE INTO srm_supplier_contact (id, supplier_id, name, mobile, email, position, is_default, sort, create_time, update_time, creator, updater, deleted) VALUES -(2001, 1001, '寮犱笁', '13800001111', 'zhangsan@test.com', '閲囪喘缁忕悊', 1, '涓昏鑱旂郴浜�', NOW(), NOW(), 'admin', 'admin', 0), -(2002, 1001, '寮犱笁涓�', '13800001112', 'zhangsanfeng@test.com', '鎶�鏈�荤洃', 0, '鎶�鏈鎺�', NOW(), NOW(), 'admin', 'admin', 0), -(2003, 1002, '鏉庡洓', '13800002222', 'lisi@test.com', '鎬荤粡鐞�', 1, NULL, NOW(), NOW(), 'admin', 'admin', 0); +(2001, 1001, '寮犱笁', '13800001111', 'zhangsan@test.com', '閲囪喘缁忕悊', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2002, 1001, '寮犱笁涓�', '13800001112', 'zhangsanfeng@test.com', '鎶�鏈�荤洃', b'0', 1, NOW(), NOW(), 'admin', 'admin', b'0'), +(2003, 1002, '鏉庡洓', '13800002222', 'lisi@test.com', '鎬荤粡鐞�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2004, 1003, '鐜嬩簲', '13800003333', 'wangwu@test.com', '閿�鍞粡鐞�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2005, 1004, '璧靛叚', '13800004444', 'zhaoliu@test.com', '鍘傞暱', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'); --- 3. 渚涘簲鍟嗗垎绫诲叧鑱� -INSERT INTO srm_supplier_category (id, supplier_id, category_id, category_name, create_time, update_time, creator, updater, deleted) +-- 3. 渚涘簲鍟嗛摱琛岃处鎴凤紙姣忎釜渚涘簲鍟嗕竴鏉￠粯璁よ处鎴凤級 +INSERT IGNORE INTO srm_supplier_bank (id, supplier_id, bank_name, bank_account, bank_no, bank_address, is_default, sort, create_time, update_time, creator, updater, deleted) +VALUES +(2101, 1001, '涓浗閾惰鍗椾含鍒嗚', '6222024301000000001', '104301000013', '鍗椾含甯備腑灞辫矾1鍙�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2102, 1001, '宸ュ晢閾惰鍗椾含姹熷畞鏀', '6222024301000000099', '102301000088', '鍗椾含甯傛睙瀹佸尯xx璺�100鍙�', b'0', 1, NOW(), NOW(), 'admin', 'admin', b'0'), +(2103, 1002, '宸ュ晢閾惰涓婃捣鍒嗚', '1002024301000000002', '102290000001', '涓婃捣甯傛郸涓滄柊鍖簒x璺�200鍙�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2104, 1003, '鎷涘晢閾惰娣卞湷鍒嗚', '6225884301000000003', '103584000002', '娣卞湷甯傚崡灞卞尯xx璺�300鍙�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'), +(2105, 1004, '寤鸿閾惰鏉窞鍒嗚', '6227004301000000004', '105331000003', '鏉窞甯傝タ婀栧尯xx璺�400鍙�', b'1', 0, NOW(), NOW(), 'admin', 'admin', b'0'); + +-- 4. 渚涘簲鍟嗗垎绫诲叧鑱� +INSERT IGNORE INTO srm_supplier_category (id, supplier_id, category_id, category_name, create_time, update_time, creator, updater, deleted) VALUES (3001, 1001, 1, '鏈烘鍔犲伐', NOW(), NOW(), 'admin', 'admin', 0), (3002, 1001, 2, '绮惧瘑鍒堕��', NOW(), NOW(), 'admin', 'admin', 0), (3003, 1002, 3, '璐告槗鏈嶅姟', NOW(), NOW(), 'admin', 'admin', 0); - --- 4. 渚涘簲鍟嗗噯鍏ョ敵璇� -INSERT INTO srm_supplier_apply (id, apply_no, supplier_name, contact_name, contact_mobile, contact_email, address, bank_name, bank_account, tax_no, apply_status, audit_comment, remark, create_time, update_time, creator, updater, deleted) -VALUES -(4001, 'AP2024010001', '姹熻嫃鏅鸿兘鍒堕�犳湁闄愬叕鍙�', '寮犱笁', '13800001111', 'zhangsan@test.com', '姹熻嫃鐪佸崡浜競姹熷畞鍖簒x璺�100鍙�', '涓浗閾惰鍗椾含鍒嗚', '6222024301000000001', '91320115MA1XXXXXX1', 4, '璧勮川榻愬叏锛屽鎵归�氳繃', NULL, NOW(), NOW(), 'admin', 'admin', 0), -(4002, 'AP2024020002', '鍖椾含鏂扮鎶�鏈夐檺鍏徃', '鍒樹竷', '13800005555', 'liuqi@test.com', '鍖椾含甯傛捣娣�鍖簒x璺�500鍙�', '鍐滀笟閾惰鍖椾含鍒嗚', '6228484301000000005', '91110108MA5XXXXXX5', 1, NULL, '寰呭鏍�', NOW(), NOW(), 'admin', 'admin', 0); - --- 5. 渚涘簲鍟嗚祫璐ㄨ瘉涔� -INSERT INTO srm_supplier_certificate (id, supplier_id, certificate_name, certificate_no, certificate_type, issuing_authority, issue_date, expire_date, remark, create_time, update_time, creator, updater, deleted) -VALUES -(5001, 1001, 'ISO9001璐ㄩ噺绠＄悊浣撶郴璇佷功', 'ISO9001-2024-001', 1, 'SGS璁よ瘉鏈烘瀯', '2024-01-15', '2027-01-14', '涓夊勾鏈夋晥鏈�', NOW(), NOW(), 'admin', 'admin', 0), -(5002, 1001, 'ISO14001鐜绠＄悊浣撶郴璇佷功', 'ISO14001-2024-002', 2, 'TUV璁よ瘉鏈烘瀯', '2024-03-01', '2027-02-28', NULL, NOW(), NOW(), 'admin', 'admin', 0), -(5003, 1002, '杩涘嚭鍙ｈ锤鏄撹鍙瘉', 'TRADE-2024-001', 4, '鍟嗗姟閮�', '2024-02-01', '2025-01-31', '鍗冲皢鍒版湡', NOW(), NOW(), 'admin', 'admin', 0); - --- 6. 渚涘簲鍟嗙哗鏁堣瘎浠� -INSERT INTO srm_supplier_evaluation (id, supplier_id, evaluation_period, quality_score, delivery_score, price_score, service_score, composite_score, grade, remark, create_time, update_time, creator, updater, deleted) -VALUES -(6001, 1001, '2024-Q1', 92, 88, 85, 90, 89, 'B', '璐ㄩ噺绋冲畾锛屼氦浠樺強鏃�', NOW(), NOW(), 'admin', 'admin', 0), -(6002, 1001, '2024-Q2', 95, 92, 88, 93, 92, 'A', '鍚勯」鎸囨爣浼樼', NOW(), NOW(), 'admin', 'admin', 0), -(6003, 1002, '2024-Q1', 80, 75, 90, 85, 81, 'B', '浠锋牸鏈変紭鍔匡紝浜や粯鐣ユ參', NOW(), NOW(), 'admin', 'admin', 0); - --- 7. 鎷涙爣椤圭洰 -INSERT INTO srm_tender_project (id, tender_no, tender_name, tender_type, purchase_org, project_leader_id, project_leader_name, tender_status, budget_amount, start_time, end_time, bid_open_time, tender_desc, qualification_requirements, purchase_request_id, create_time, update_time, creator, updater, deleted) -VALUES -(7001, 'TEN-202401001', '2024骞碤1鍘熸潗鏂欓噰璐嫑鏍�', 1, '閲囪喘閮�', 1, '绠＄悊鍛�', 4, 5000000.00, '2024-01-01 00:00:00', '2024-01-31 23:59:59', '2024-02-01 10:00:00', '閲囪喘涓嶉攬閽㈡澘鏉�200鍚�', '1. 娉ㄥ唽璧勯噾鈮�500涓� 2. 鍏峰ISO9001璁よ瘉', NULL, NOW(), NOW(), 'admin', 'admin', 0), -(7002, 'TEN-202402002', '2024骞碤2璁惧閲囪喘鎷涙爣', 2, '璁惧閮�', 2, '鐜嬬粡鐞�', 1, 2000000.00, '2024-04-01 00:00:00', '2024-04-30 23:59:59', '2024-05-01 14:00:00', '閲囪喘鏁版帶鏈哄簥5鍙�', '1. 鍏峰璁惧浠ｇ悊璧勮川 2. 鎻愪緵鍞悗鏈嶅姟鎵胯', NULL, NOW(), NOW(), 'admin', 'admin', 0); - --- 8. 鎷涙爣鐗╂枡 -INSERT INTO srm_tender_material (id, tender_project_id, item_code, item_name, spec, unit, quantity, remark, create_time, update_time, creator, updater, deleted) -VALUES -(8001, 7001, 'MAT-001', '涓嶉攬閽㈡澘304', '2.0*1500*3000mm', '鍚�', 100, NULL, NOW(), NOW(), 'admin', 'admin', 0), -(8002, 7001, 'MAT-002', '涓嶉攬閽㈡澘316L', '1.5*1500*3000mm', '鍚�', 100, '鑰愯厫铓�瑕佹眰', NOW(), NOW(), 'admin', 'admin', 0), -(8003, 7002, 'MAT-003', '鏁版帶鏈哄簥CNC-500', '鍔犲伐鑼冨洿500*400mm', '鍙�', 5, '鍚畨瑁呰皟璇�', NOW(), NOW(), 'admin', 'admin', 0); - --- 9. 鎶曟爣璁板綍 -INSERT INTO srm_tender_bid (id, tender_project_id, supplier_id, bid_no, bid_status, bid_time, bid_total_amount, withdraw_reason, create_time, update_time, creator, updater, deleted) -VALUES -(9001, 7001, 1001, 'BID-202401-001', 1, '2024-01-15 10:00:00', 4800000.00, NULL, NOW(), NOW(), 'admin', 'admin', 0), -(9002, 7001, 1002, 'BID-202401-002', 1, '2024-01-20 14:00:00', 4900000.00, NULL, NOW(), NOW(), 'admin', 'admin', 0); - --- 10. 渚涘簲鍟嗘姤浠� -INSERT INTO srm_supplier_quote (id, bid_id, material_id, unit_price, total_price, delivery_days, remark, create_time, update_time, creator, updater, deleted) -VALUES -(10001, 9001, 8001, 22000.00, 2200000.00, 30, NULL, NOW(), NOW(), 'admin', 'admin', 0), -(10002, 9001, 8002, 26000.00, 2600000.00, 30, '鍚繍璐�', NOW(), NOW(), 'admin', 'admin', 0), -(10003, 9002, 8001, 23000.00, 2300000.00, 25, NULL, NOW(), NOW(), 'admin', 'admin', 0), -(10004, 9002, 8002, 26000.00, 2600000.00, 28, NULL, NOW(), NOW(), 'admin', 'admin', 0); - --- 11. 寮�鏍囪褰� -INSERT INTO srm_bid_open (id, tender_project_id, open_no, open_time, bid_count, supplier_count, open_status, remark, create_time, update_time, creator, updater, deleted) -VALUES -(11001, 7001, 'OPEN-20240201', '2024-02-01 10:00:00', 2, 2, 1, '鎶曟爣鎴锛屽叡2瀹朵緵搴斿晢鍙備笌', NOW(), NOW(), 'admin', 'admin', 0); - --- 12. 璇勬爣璁板綍 -INSERT INTO srm_bid_evaluation (id, tender_project_id, bid_id, technical_score, commercial_score, composite_score, rank, comment, create_time, update_time, creator, updater, deleted) -VALUES -(12001, 7001, 9001, 88, 85, 86, 1, '鎶�鏈柟妗堜紭绉�锛屼环鏍煎悎鐞�', NOW(), NOW(), 'admin', 'admin', 0), -(12002, 7001, 9002, 82, 90, 87, 2, '浠锋牸鏈変紭鍔匡紝鎶�鏈柟妗堜竴鑸�', NOW(), NOW(), 'admin', 'admin', 0); - --- 13. 瀹氭爣璁板綍 -INSERT INTO srm_bid_award (id, tender_project_id, supplier_id, bid_id, award_no, award_status, award_amount, award_time, purchase_order_id, purchase_order_no, remark, create_time, update_time, creator, updater, deleted) -VALUES -(13001, 7001, 1001, 9001, 'AWARD-202402-001', 1, 4800000.00, '2024-02-05 16:00:00', NULL, NULL, '缁煎悎璇勫垎绗竴', NOW(), NOW(), 'admin', 'admin', 0); - -- Gitblit v1.9.3