菜单写入mysql_菜单配置-数据库操作

1、同步数据库新建门店出入库明细报表(store_stock_item_report)

2、菜单表(menu)插入一级菜单、功能

数据库对原表操作执行语句

1、选中表->open table

2、选中某一条数据->右键->Copy AS ->Insert Statement/Update Statemtent

/*新建一级菜单*/

INSERT INTO `stt_cas`.`menu`

(`id`, `parent_id`, `name`, `url`, `icon`, `perms`, `type`, `order_num`, `status`, `menu_type`, `create_user_id`, `update_user_id`, `create_time`, `update_time`, `is_delete`)

VALUES (201208, 208, '订货出入库明细','/statistical-report/store-report-stock-details', '', '', 0, 0, 0, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201209, 208, '订货出库门店日期汇总','/statistical-report/store-report-stock-time-details', '', '', 0, 0, 0, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201210, 208, '订货出库门店商品汇总', '/statistical-report/store-report-stock-product-details', '', '', 0, 0, 0, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201211, 208, '订货出库商品汇总','/statistical-report/store-report-product-details', '', '', 0, 0, 0, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201212, 208, '订货出库门店汇总', '/statistical-report/store-report-stock-list', '', '', 0, 0, 0, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0')

/*新建菜单下的勾选功能*/

INSERT INTO `stt_cas`.`menu`

(`id`, `parent_id`, `name`, `url`, `icon`, `perms`, `type`, `order_num`, `status`, `menu_type`, `create_user_id`, `update_user_id`, `create_time`, `update_time`, `is_delete`)

VALUES

(201213, 201208, '订货出入库明细查询','', '', 'erp:report:list', 2, 201213, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201214, 201208, '订货出入库明细导出','', '', 'erp:report:export', 2, 201214, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201215, 201209, '订货出库门店日期汇总查询','', '', 'erp:report:list', 2, 201215, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201216, 201209, '订货出库门店日期汇总导出','', '', 'erp:report:export', 2, 201216, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201217, 201210, '订货出库门店商品汇总查询', '', '', 'erp:report:list', 2, 201217, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201218, 201210, '订货出库门店商品汇总导出', '', '', 'erp:report:export', 2, 201218, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201219, 201211, '订货出库商品汇总查询','', '', 'erp:report:list', 2, 201219, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201220, 201211, '订货出库商品汇总导出','', '', 'erp:report:export', 2, 201220, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201221, 201212, '订货出库门店汇总查询', '', '', 'erp:report:list', 2, 201221, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0'),

(201222, 201212, '订货出库门店汇总导出', '', '', 'erp:report:export', 2, 201222, 100, '0', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '0')