fix_menu_component_paths.sql 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  1. -- =====================================================
  2. -- 修复菜单组件路径不匹配问题
  3. -- 数据库中的 component 字段与实际文件名不一致
  4. -- =====================================================
  5. SET NAMES utf8mb4;
  6. -- 修复委外交料单的组件路径
  7. -- 数据库中是 OutsourceDeliveryList,实际文件是 OutsourcingDeliveryList
  8. UPDATE `system_menu`
  9. SET `component` = 'jianmo/views/wms/OutsourcingDeliveryList',
  10. `component_name` = 'JianmoOutsourcingDeliveryList'
  11. WHERE `id` = 6601;
  12. -- 修复仓库数据相关的组件路径
  13. -- 标签查询: LabelQueryList -> TagQuery
  14. UPDATE `system_menu`
  15. SET `component` = 'jianmo/views/inventory/TagQuery'
  16. WHERE `id` = 6701;
  17. -- 标签历史记录: LabelHistoryList -> TagHistory
  18. UPDATE `system_menu`
  19. SET `component` = 'jianmo/views/inventory/TagHistory'
  20. WHERE `id` = 6702;
  21. -- 库存查询: InventoryQueryList -> StockQuery
  22. UPDATE `system_menu`
  23. SET `component` = 'jianmo/views/inventory/StockQuery'
  24. WHERE `id` = 6704;
  25. -- 进出存查询: StockMovementList -> StockFlow
  26. UPDATE `system_menu`
  27. SET `component` = 'jianmo/views/inventory/StockFlow'
  28. WHERE `id` = 6705;
  29. -- 销售发货通知: SalesShippingNoticeList -> SalesShipmentNotice
  30. UPDATE `system_menu`
  31. SET `component` = 'jianmo/views/s7/SalesShipmentNotice'
  32. WHERE `id` = 6802;
  33. -- =====================================================
  34. -- 完成提示
  35. -- =====================================================
  36. -- 执行完成后,请:
  37. -- 1. 清除浏览器缓存或使用无痕模式
  38. -- 2. 重新登录管理后台
  39. -- 3. 刷新页面查看菜单是否正常