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')