85 行
5.8 KiB
SQL
85 行
5.8 KiB
SQL
-- ============================================================================
|
|
-- 优匠优服 · Phase 11 后台菜单结构聚合重构与奇兵到家模式大盘配置
|
|
-- 1. 收敛散乱的 17 个一级菜单，聚合成四大业务中心（服务与调度、运力商户、财务资金、运营营销）
|
|
-- 2. 原控制台完整迁移至「常规管理 -> 控制台 (general/dashboard)」
|
|
-- 3. 顶级首页设立全新「数据大盘 (home)」，并设为系统默认 fixedpage
|
|
-- ============================================================================
|
|
SET NAMES utf8mb4;
|
|
|
|
-- 1. 创建四大业务顶级目录（若不存在则插入）
|
|
INSERT INTO `fa_auth_rule` (`type`, `pid`, `name`, `title`, `icon`, `condition`, `remark`, `ismenu`, `createtime`, `updatetime`, `weigh`, `status`)
|
|
SELECT 'file', 0, 'order_manage', '服务与调度', 'fa fa-tasks', '', '同城服务订单流转与类目管理', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 190, 'normal'
|
|
WHERE NOT EXISTS (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'order_manage');
|
|
|
|
INSERT INTO `fa_auth_rule` (`type`, `pid`, `name`, `title`, `icon`, `condition`, `remark`, `ismenu`, `createtime`, `updatetime`, `weigh`, `status`)
|
|
SELECT 'file', 0, 'capacity_manage', '运力与商户', 'fa fa-id-badge', '', '维修师傅与合作企业商户管理', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 170, 'normal'
|
|
WHERE NOT EXISTS (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'capacity_manage');
|
|
|
|
INSERT INTO `fa_auth_rule` (`type`, `pid`, `name`, `title`, `icon`, `condition`, `remark`, `ismenu`, `createtime`, `updatetime`, `weigh`, `status`)
|
|
SELECT 'file', 0, 'finance_manage', '财务与资金', 'fa fa-money', '', '平台结算、提现审核与发票开具', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 150, 'normal'
|
|
WHERE NOT EXISTS (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'finance_manage');
|
|
|
|
INSERT INTO `fa_auth_rule` (`type`, `pid`, `name`, `title`, `icon`, `condition`, `remark`, `ismenu`, `createtime`, `updatetime`, `weigh`, `status`)
|
|
SELECT 'file', 0, 'operation_manage', '运营与营销', 'fa fa-bullhorn', '', '优惠券、轮播运营位与消息通知', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 130, 'normal'
|
|
WHERE NOT EXISTS (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'operation_manage');
|
|
|
|
-- 2. 动态跨表更新 (JOIN 模式，完美兼容各 MySQL 版本)
|
|
-- 服务与调度子项
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'order_manage'
|
|
SET r.pid = p.id, r.title = '订单管理', r.icon = 'fa fa-shopping-cart', r.weigh = 195 WHERE r.name = 'order';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'order_manage'
|
|
SET r.pid = p.id, r.title = '服务项目', r.icon = 'fa fa-th-list', r.weigh = 194 WHERE r.name = 'service';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'order_manage'
|
|
SET r.pid = p.id, r.title = '服务类目', r.icon = 'fa fa-cubes', r.weigh = 193 WHERE r.name = 'service/cat';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'order_manage'
|
|
SET r.pid = p.id, r.title = '评价管理', r.icon = 'fa fa-star', r.weigh = 192 WHERE r.name = 'review';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'order_manage'
|
|
SET r.pid = p.id, r.title = '申诉工单', r.icon = 'fa fa-shield', r.weigh = 191 WHERE r.name = 'appeal';
|
|
|
|
-- 运力与商户子项
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'capacity_manage'
|
|
SET r.pid = p.id, r.title = '师傅档案', r.icon = 'fa fa-wrench', r.weigh = 175 WHERE r.name = 'master';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'capacity_manage'
|
|
SET r.pid = p.id, r.title = '商家档案', r.icon = 'fa fa-building', r.weigh = 174 WHERE r.name = 'merchant';
|
|
|
|
-- 财务与资金子项
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'finance_manage'
|
|
SET r.pid = p.id, r.title = '结算账单', r.icon = 'fa fa-calculator', r.weigh = 155 WHERE r.name = 'settle';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'finance_manage'
|
|
SET r.pid = p.id, r.title = '提现申请', r.icon = 'fa fa-credit-card', r.weigh = 154 WHERE r.name = 'withdraw';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'finance_manage'
|
|
SET r.pid = p.id, r.title = '开票申请', r.icon = 'fa fa-file-text-o', r.weigh = 153 WHERE r.name = 'invoice';
|
|
|
|
-- 运营与营销子项
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'operation_manage'
|
|
SET r.pid = p.id, r.title = '优惠券管理', r.icon = 'fa fa-ticket', r.weigh = 135 WHERE r.name = 'coupon';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'operation_manage'
|
|
SET r.pid = p.id, r.title = '轮播管理', r.icon = 'fa fa-picture-o', r.weigh = 134 WHERE r.name = 'banner';
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'operation_manage'
|
|
SET r.pid = p.id, r.title = '消息通知', r.icon = 'fa fa-bell', r.weigh = 133 WHERE r.name = 'message';
|
|
|
|
-- 3. 将原控制台搬迁至「常规管理 (general)」下的子菜单
|
|
INSERT INTO `fa_auth_rule` (`type`, `pid`, `name`, `title`, `icon`, `condition`, `remark`, `ismenu`, `createtime`, `updatetime`, `weigh`, `status`)
|
|
SELECT 'file', p.id, 'general/dashboard', '控制台', 'fa fa-dashboard', '', '原系统控制台（已迁移至常规管理）', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 68, 'normal'
|
|
FROM `fa_auth_rule` p
|
|
WHERE p.name = 'general'
|
|
AND NOT EXISTS (SELECT `id` FROM `fa_auth_rule` WHERE `name` = 'general/dashboard');
|
|
|
|
UPDATE `fa_auth_rule` r JOIN `fa_auth_rule` p ON p.name = 'general'
|
|
SET r.pid = p.id, r.title = '控制台', r.icon = 'fa fa-dashboard', r.weigh = 68, r.ismenu = 1 WHERE r.name = 'general/dashboard';
|
|
|
|
-- 4. 顶级首页菜单升级为全新生成的大盘页面 home
|
|
UPDATE `fa_auth_rule` SET `name` = 'home', `title` = '数据大盘', `icon` = 'fa fa-tachometer', `weigh` = 200, `pid` = 0, `ismenu` = 1, `status` = 'normal' WHERE `id` = 1;
|
|
|
|
-- 5. 更新系统配置：默认固定首页为 home
|
|
UPDATE `fa_config` SET `value` = 'home' WHERE `name` = 'fixedpage';
|