37 行
3.5 KiB
SQL
37 行
3.5 KiB
SQL
-- 商学院财务结算后台菜单
|
|
-- 请将 fa_ 替换为实际表前缀
|
|
|
|
SET @now = UNIX_TIMESTAMP();
|
|
SET @parent_id = (SELECT id FROM `fa_auth_rule` WHERE `name` = 'shopro' LIMIT 1);
|
|
|
|
INSERT IGNORE INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`url`,`condition`,`remark`,`ismenu`,`extend`,`createtime`,`updatetime`,`weigh`,`status`) VALUES
|
|
('file', @parent_id, 'shopro/business_school', '商学院管理', 'fa fa-graduation-cap', '', '', '', 1, '', @now, @now, 4, 'normal');
|
|
|
|
SET @bs_id = (SELECT id FROM `fa_auth_rule` WHERE `name` = 'shopro/business_school' LIMIT 1);
|
|
|
|
UPDATE `fa_auth_rule` SET `pid` = @parent_id, `ismenu` = 1, `status` = 'normal' WHERE `name` = 'shopro/business_school';
|
|
|
|
INSERT IGNORE INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`url`,`condition`,`remark`,`ismenu`,`extend`,`createtime`,`updatetime`,`weigh`,`status`) VALUES
|
|
('file', @bs_id, 'shopro/business_school/school', '商学院列表', 'fa fa-list', '', '', '', 1, '', @now, @now, 10, 'normal'),
|
|
('file', @bs_id, 'shopro/business_school/settlement', '商学院结算', 'fa fa-money', '', '', '', 1, '', @now, @now, 9, 'normal');
|
|
|
|
SET @school_id = (SELECT id FROM `fa_auth_rule` WHERE `name` = 'shopro/business_school/school' LIMIT 1);
|
|
SET @settle_id = (SELECT id FROM `fa_auth_rule` WHERE `name` = 'shopro/business_school/settlement' LIMIT 1);
|
|
|
|
INSERT IGNORE INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`url`,`condition`,`remark`,`ismenu`,`extend`,`createtime`,`updatetime`,`weigh`,`status`) VALUES
|
|
('file', @school_id, 'shopro/business_school/school/index', '查看', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @school_id, 'shopro/business_school/school/add', '添加', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @school_id, 'shopro/business_school/school/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @school_id, 'shopro/business_school/school/del', '删除', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/index', '查看', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/add', '添加', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/edit', '编辑', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/del', '删除', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/submit', '提交审核', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/audit', '审核', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/markPay', '打款标记', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/import', '导入', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/export', '导出', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/downloadTemplate', '下载模板', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal'),
|
|
('file', @settle_id, 'shopro/business_school/settlement/logs', '日志', 'fa fa-circle-o', '', '', '', 0, '', @now, @now, 0, 'normal');
|