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
40
41
| -- =====================================================
| -- SRM 模块菜单数据（新库初始化用）
| -- 已移除：供应商准入/资质/绩效/招投标/统计分析
| -- 保留：供应商档案、询价比价、投标保证金、供应商往来
| -- 说明：使用 INSERT IGNORE，重复执行不会报主键冲突。
| -- =====================================================
|
| -- 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');
|
| 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'),
| (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');
|
| -- 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 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
| (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');
|
| -- 3. 投标保证金已迁至 CRM 销售管理（crm_bid_bond，菜单见 sql/mysql/20261105_crm_bid_bond.sql）
|
| -- 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 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');
|
|
