-- 客户往来、销售对账、核销管理菜单 -- 幂等:按 id 判断,已存在则跳过 -- 客户往来(挂在 回款与开票 1075497 下) INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show) SELECT 1075660, '客户往来', 'crm:receivable:query', 2, 6, 1075497, 'customer-statement', '', 'crm/customerStatement/index', 0, 1, 1, 1 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075660); -- 销售对账(挂在 财务管理 2645 下) INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show) SELECT 1075661, '销售对账', 'crm:receivable:query', 2, 8, 2645, 'sale-reconciliation', '', 'erp/finance/reconciliation/index', 0, 1, 1, 1 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075661); -- 核销管理(挂在 财务管理 2645 下) INSERT INTO system_menu (id, name, permission, type, sort, parent_id, path, icon, component, status, visible, keep_alive, always_show) SELECT 1075662, '核销管理', 'crm:receivable:query', 2, 9, 2645, 'write-off', '', 'erp/finance/writeoff/index', 0, 1, 1, 1 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE id = 1075662);