44 行
2.0 KiB
SQL
44 行
2.0 KiB
SQL
-- 补全后台「充值提现」菜单（修复版）
|
||
-- 问题：旧脚本把菜单挂到了 shopro/link 的父级，而不是 shopro/config(id=85) 下
|
||
-- 请将 fa_ 替换为实际表前缀，执行后：后台右上角清除缓存 → 退出重新登录
|
||
|
||
SET @now = UNIX_TIMESTAMP();
|
||
|
||
-- 商城配置节点 id（截图里一般是 85）
|
||
SET @config_id = (SELECT id FROM `fa_auth_rule` WHERE `name` = 'shopro/config' LIMIT 1);
|
||
|
||
-- 不存在则插入
|
||
INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`url`,`condition`,`remark`,`ismenu`,`menutype`,`extend`,`createtime`,`updatetime`,`weigh`,`status`)
|
||
SELECT 'file', @config_id, 'shopro/config/index', '充值提现', 'fa fa-jpy', '', '', '配置提现方式、手续费、最低/最高提现金额', 1, NULL, '', @now, @now, 25, 'normal'
|
||
FROM DUAL
|
||
WHERE @config_id IS NOT NULL
|
||
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name` = 'shopro/config/index');
|
||
|
||
-- 强制挂到 shopro/config 下并设为可见菜单
|
||
UPDATE `fa_auth_rule`
|
||
SET `pid` = @config_id,
|
||
`title` = '充值提现',
|
||
`icon` = 'fa fa-jpy',
|
||
`ismenu` = 1,
|
||
`status` = 'normal',
|
||
`weigh` = 25,
|
||
`remark` = '配置提现方式、手续费、最低/最高提现金额'
|
||
WHERE `name` = 'shopro/config/index';
|
||
|
||
-- 保存配置需要 platform 权限节点
|
||
INSERT INTO `fa_auth_rule` (`type`,`pid`,`name`,`title`,`icon`,`url`,`condition`,`remark`,`ismenu`,`menutype`,`extend`,`createtime`,`updatetime`,`weigh`,`status`)
|
||
SELECT 'file', @config_id, 'shopro/config/platform', '平台配置', 'fa fa-circle-o', '', '', '', 0, NULL, '', @now, @now, 0, 'normal'
|
||
FROM DUAL
|
||
WHERE @config_id IS NOT NULL
|
||
AND NOT EXISTS (SELECT 1 FROM `fa_auth_rule` WHERE `name` = 'shopro/config/platform');
|
||
|
||
UPDATE `fa_auth_rule`
|
||
SET `pid` = @config_id, `status` = 'normal'
|
||
WHERE `name` = 'shopro/config/platform';
|
||
|
||
-- 验证：应看到 shopro/config/index 的 pid = @config_id
|
||
SELECT id, pid, name, title, ismenu, status, weigh
|
||
FROM `fa_auth_rule`
|
||
WHERE `name` LIKE 'shopro/config%'
|
||
ORDER BY pid, weigh DESC, id;
|