1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
| -- =====================================================
| -- SRM 模块测试数据
| -- 运行前请先确保 srm_init.sql 已执行
| -- 仅包含：供应商、联系人、银行账户、分类关联
| -- 询价/保证金数据请通过页面或接口创建，避免与真实单据编号冲突
| -- =====================================================
|
| -- 1. 供应商测试数据
| 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, 0, '张三', '13800001111', 'zhangsan@test.com', '江苏省南京市江宁区xx路100号', '中国银行南京分行', '6222024301000000001', '91320115MA1XXXXXX1', '优质供应商', NOW(), NOW(), 'admin', 'admin', b'0'),
| (1002, 'SUP-20240002', '上海贸易进出口公司', 2, 0, '李四', '13800002222', 'lisi@test.com', '上海市浦东新区xx路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', '浙江省杭州市西湖区xx路400号', '建设银行杭州分行', '6227004301000000004', '91330100MA4XXXXXX4', '暂停合作', NOW(), NOW(), 'admin', 'admin', b'0');
|
| -- 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', '采购经理', 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 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', '上海市浦东新区xx路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);
|
|
