36 lines
2.6 KiB
SQL
36 lines
2.6 KiB
SQL
-- ========================================
|
|
-- 入库管理系统 - 菜单导入SQL
|
|
-- 执行此SQL将在系统中添加入库管理菜单
|
|
-- ========================================
|
|
|
|
-- 1. 主菜单 - 入库管理
|
|
INSERT INTO `sys_menu` VALUES (2000, '入库管理', 0, 5, 'warehouse', NULL, '', 1, 0, 'M', '0', '0', '', 'education', 'admin', NOW(), '', NULL, '入库管理目录');
|
|
|
|
-- 2. 入库单管理菜单
|
|
INSERT INTO `sys_menu` VALUES (2001, '入库单管理', 2000, 1, 'receipt', 'warehouse/receipt/index', '', 1, 0, 'C', '0', '0', 'warehouse:receipt:list', 'form', 'admin', NOW(), '', NULL, '入库单管理菜单');
|
|
INSERT INTO `sys_menu` VALUES (2002, '入库单查询', 2001, 1, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:receipt:query', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2003, '入库单新增', 2001, 2, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:receipt:add', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2004, '入库单修改', 2001, 3, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:receipt:edit', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2005, '入库单删除', 2001, 4, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:receipt:remove', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2006, '入库单导出', 2001, 5, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:receipt:export', '#', 'admin', NOW(), '', NULL, '');
|
|
|
|
-- 3. 样品管理菜单
|
|
INSERT INTO `sys_menu` VALUES (2011, '样品管理', 2000, 2, 'sample', 'warehouse/sample/index', '', 1, 0, 'C', '0', '0', 'warehouse:sample:list', 'list', 'admin', NOW(), '', NULL, '样品管理菜单');
|
|
INSERT INTO `sys_menu` VALUES (2012, '样品查询', 2011, 1, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:sample:query', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2013, '样品新增', 2011, 2, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:sample:add', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2014, '样品修改', 2011, 3, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:sample:edit', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2015, '样品删除', 2011, 4, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:sample:remove', '#', 'admin', NOW(), '', NULL, '');
|
|
INSERT INTO `sys_menu` VALUES (2016, '样品导出', 2011, 5, '', '', '', 1, 0, 'F', '0', '0', 'warehouse:sample:export', '#', 'admin', NOW(), '', NULL, '');
|
|
|
|
-- ========================================
|
|
-- 导入完成后请：
|
|
-- 1. 重新登录系统或刷新页面
|
|
-- 2. 在左侧菜单中查看"入库管理"
|
|
-- ========================================
|
|
|
|
|
|
|
|
|
|
|
|
|