<?php
/**
 * 后台菜单迁移文件
 * @author yupoxiong<i@yufuping.com>
 */

use think\Db;
use think\migration\Migrator;
use think\migration\db\Column;

class AdminMenu extends Migrator
{
    public function change()
    {
        $table = $this->table('admin_menu', ['comment'=>'后台菜单','engine' => 'InnoDB', 'encoding' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci']);
        $table->addColumn('parent_id', 'integer', ['limit' => 11, 'default' => 0, 'comment' => '父级菜单'])
            ->addColumn('name', 'string', ['limit' => 30, 'default' => '', 'comment' => '名称'])
            ->addColumn('url', 'string', ['limit' => 100, 'default' => '', 'comment' => 'url'])
            ->addColumn('icon', 'string', ['limit' => 30, 'default' => 'fa-list', 'comment' => '图标'])
            ->addColumn('is_show', 'boolean', ['limit' => 1, 'default' => 1, 'comment' => '等级'])
            ->addColumn('sort_id', 'integer', ['limit' => 10, 'default' => '1000', 'comment' => '排序'])
            ->addColumn('log_method', 'string', ['limit' => 8, 'default' => '不记录', 'comment' => '记录日志方法'])
            ->addIndex(['url'], ['name' => 'index_url'])
            ->create();
        $this->insertData();
    }

    protected function insertData()
    {
        $sql = "INSERT INTO `agency_admin_menu` (`id`, `parent_id`, `name`, `url`, `icon`, `is_show`, `sort_id`, `log_method`) VALUES
(1, 0, '后台首页', 'admin/index/index', 'fa-home', 1, 99, '不记录'),
(2, 0, '系统管理', 'admin/sys', 'fa-desktop', 1, 1099, '不记录'),
(3, 2, '用户管理', 'admin/admin_user/index', 'fa-user', 1, 1000, '不记录'),
(4, 3, '添加用户', 'admin/admin_user/add', 'fa-plus', 0, 1000, 'POST'),
(5, 3, '修改用户', 'admin/admin_user/edit', 'fa-edit', 0, 1000, 'POST'),
(6, 3, '删除用户', 'admin/admin_user/del', 'fa-close', 0, 1000, 'POST'),
(7, 2, '角色管理', 'admin/admin_role/index', 'fa-group', 1, 1000, '不记录'),
(8, 7, '添加角色', 'admin/admin_role/add', 'fa-plus', 0, 1000, 'POST'),
(9, 7, '修改角色', 'admin/admin_role/edit', 'fa-edit', 0, 1000, 'POST'),
(10, 7, '删除角色', 'admin/admin_role/del', 'fa-close', 0, 1000, 'POST'),
(11, 7, '角色授权', 'admin/admin_role/access', 'fa-key', 0, 1000, 'POST'),
(12, 2, '菜单管理', 'admin/admin_menu/index', 'fa-align-justify', 1, 1000, '不记录'),
(13, 12, '添加菜单', 'admin/admin_menu/add', 'fa-plus', 0, 1000, 'POST'),
(14, 12, '修改菜单', 'admin/admin_menu/edit', 'fa-edit', 0, 1000, 'POST'),
(15, 12, '删除菜单', 'admin/admin_menu/del', 'fa-close', 0, 1000, 'POST'),
(16, 2, '操作日志', 'admin/admin_log/index', 'fa-keyboard-o', 1, 1000, '不记录'),
(17, 16, '查看操作日志详情', 'admin/admin_log/view', 'fa-search-plus', 0, 1000, '不记录'),
(18, 2, '个人资料', 'admin/admin_user/profile', 'fa-smile-o', 1, 1000, 'POST'),
(19, 0, '玩家管理', 'admin/user/mange', 'fa-users', 1, 1000, '不记录'),
(20, 19, '账号列表', 'admin/user/index', 'fa-user', 1, 1000, '不记录'),
(23, 20, '删除账号', 'admin/user/del', 'fa-trash', 0, 1000, 'POST'),
(24, 20, '启用账号', 'admin/user/enable', 'fa-circle', 0, 1000, 'POST'),
(25, 20, '禁用账号', 'admin/user/disable', 'fa-circle', 0, 1000, 'POST'),
(32, 2, '开发管理', 'admin/develop/manager', 'fa-code', 1, 1005, '不记录'),
(33, 32, '代码生成', 'admin/generate/index', 'fa-file-code-o', 1, 1000, '不记录'),
(34, 32, '设置配置', 'admin/develop/setting', 'fa-cogs', 1, 995, '不记录'),
(35, 34, '设置管理', 'admin/setting/index', 'fa-cog', 1, 1000, '不记录'),
(36, 35, '添加设置', 'admin/setting/add', 'fa-plus', 0, 1000, 'POST'),
(37, 35, '修改设置', 'admin/setting/edit', 'fa-pencil', 0, 1000, 'POST'),
(38, 35, '删除设置', 'admin/setting/del', 'fa-trash', 0, 1000, 'POST'),
(39, 34, '设置分组管理', 'admin/setting_group/index', 'fa-list', 1, 1000, '不记录'),
(40, 39, '添加设置分组', 'admin/setting_group/add', 'fa-plus', 0, 1000, 'POST'),
(41, 39, '修改设置分组', 'admin/setting_group/edit', 'fa-pencil', 0, 1000, 'POST'),
(42, 39, '删除设置分组', 'admin/setting_group/del', 'fa-trash', 0, 1000, 'POST'),
(43, 0, '设置中心', 'admin/setting/center', 'fa-cogs', 1, 1000, '不记录'),
(44, 43, '所有配置', 'admin/setting/all', 'fa-list', 1, 1000, '不记录'),
(47, 43, '后台设置', 'admin/setting/admin', 'fa-adjust', 1, 1000, '不记录'),
(48, 43, '更新设置', 'admin/setting/update', 'fa-pencil', 0, 1000, 'POST'),
(49, 32, '数据维护', 'admin/database/table', 'fa-database', 1, 1000, '不记录'),
(50, 49, '查看表详情', 'admin/database/view', 'fa-eye', 0, 1000, '不记录'),
(51, 49, '优化表', 'admin/database/optimize', 'fa-refresh', 0, 1000, 'POST'),
(52, 49, '修复表', 'admin/database/repair', 'fa-circle-o-notch', 0, 1000, 'POST'),
(61, 0, '代理管理', 'admin/agency', 'fa-address-card-o', 1, 100, '不记录'),
(70, 61, '代理列表', 'admin/agency/index', 'fa-user', 1, 1000, 'GET'),
(71, 70, '添加', 'admin/agency/add', 'fa-plus', 0, 1000, 'POST'),
(72, 70, '修改', 'admin/agency/edit', 'fa-pencil', 0, 1000, 'POST'),
(73, 70, '删除', 'admin/agency/del', 'fa-trash', 0, 1000, 'POST'),
(80, 0, '游戏管理', 'admin/game', 'fa-gamepad', 1, 1000, 'GET'),
(87, 19, '角色列表', 'admin/player/index', 'fa-list', 1, 1000, 'GET'),
(88, 80, 'GM工具', 'admin/game_gm/index', 'fa-circle-o', 1, 1000, 'GET'),
(89, 0, 'CDK管理', 'admin/cdk', 'fa-credit-card', 1, 1000, 'GET'),
(90, 89, 'CDK列表', 'admin/cdk/index', 'fa-circle-o', 1, 1000, 'GET'),
(91, 90, '添加', 'admin/cdk/add', 'fa-list', 0, 1000, 'POST'),
(92, 89, '兑换记录', 'admin/cdk_record/index', 'fa-bar-chart-o', 1, 1000, 'GET'),
(95, 0, '提成管理', 'admin/data', 'fa-cny', 1, 1000, '不记录'),
(96, 95, '提成统计', 'admin/revenue/index', 'fa-bar-chart-o', 1, 1000, '不记录'),
(99, 70, '结算账户', 'admin/agency/bank_info', 'fa-list', 0, 1000, 'POST'),
(100, 95, '结算提成', 'admin/check_out/index', 'fa-circle-o', 1, 1000, '不记录'),
(101, 100, '添加结算', 'admin/check_out/param_add', 'fa-plus', 0, 1000, 'POST'),
(102, 100, '删除结算提成', 'admin/check_out/del', 'fa-trash', 0, 1000, 'POST'),
(103, 100, '启用结算提成', 'admin/check_out/enable', 'fa-circle', 0, 1000, 'POST'),
(104, 100, '禁用结算提成', 'admin/check_out/disable', 'fa-circle', 0, 1000, 'POST'),
(105, 0, '打金管理', 'admin/currency_withdraw', 'fa-list', 1, 1000, '不记录'),
(106, 105, '游戏提现', 'admin/currency_withdraw/index', 'fa-circle-o', 1, 1000, 'GET'),
(109, 106, '完成打款', 'admin/currency_withdraw/enable', 'fa-circle', 0, 1000, 'POST'),
(111, 106, '拒绝提现', 'admin/currency_withdraw/disable', 'fa-list', 0, 1000, 'POST'),
(112, 80, '碎片商城', 'admin/debris/index', 'fa-circle-o', 1, 1000, 'GET'),
(113, 112, '添加', 'admin/debris/add', 'fa-circle-o', 0, 1000, 'POST'),
(114, 112, '修改', 'admin/debris/edit', 'fa-circle-o', 0, 1000, 'POST'),
(115, 112, '删除', 'admin/debris/del', 'fa-circle-o', 0, 1000, 'POST'),
(116, 80, '多宝推荐', 'admin/recommend/index', 'fa-circle-o', 1, 1000, 'GET'),
(117, 116, '添加', 'admin/recommend/add', 'fa-circle-o', 0, 1000, 'POST'),
(118, 116, '修改', 'admin/recommend/edit', 'fa-circle-o', 0, 1000, 'POST'),
(119, 116, '删除', 'admin/recommend/del', 'fa-circle-o', 0, 1000, 'POST'),
(120, 80, '积分商城', 'admin/integral/index', 'fa-circle-o', 1, 1000, 'GET'),
(121, 120, '添加', 'admin/integral/add', 'fa-circle-o', 0, 1000, 'POST'),
(122, 120, '修改', 'admin/integral/edit', 'fa-circle-o', 0, 1000, 'POST'),
(123, 120, '删除', 'admin/integral/del', 'fa-circle-o', 0, 1000, 'POST'),
(124, 80, '风雨同舟', 'admin/dali/index', 'fa-circle-o', 1, 1000, 'GET'),
(125, 124, '添加', 'admin/dali/add', 'fa-circle-o', 0, 1000, 'POST'),
(126, 124, '修改', 'admin/dali/edit', 'fa-circle-o', 0, 1000, 'POST'),
(127, 124, '删除', 'admin/dali/del', 'fa-circle-o', 0, 1000, 'POST'),
(128, 80, '每日签到', 'admin/sign_in/index', 'fa-circle-o', 1, 1000, 'GET'),
(129, 128, '添加', 'admin/sign_in/add', 'fa-circle-o', 0, 1000, 'POST'),
(130, 128, '修改', 'admin/sign_in/edit', 'fa-circle-o', 0, 1000, 'POST'),
(131, 128, '删除', 'admin/sign_in/del', 'fa-circle-o', 0, 1000, 'POST'),
(132, 80, '高级藏宝', 'admin/lottery/index', 'fa-circle-o', 1, 1000, 'GET'),
(133, 132, '添加', 'admin/lottery/add', 'fa-circle-o', 0, 1000, 'POST'),
(134, 132, '修改', 'admin/lottery/edit', 'fa-circle-o', 0, 1000, 'POST'),
(135, 132, '删除', 'admin/lottery/del', 'fa-circle-o', 0, 1000, 'POST'),
(136, 80, '诛仙宝图', 'admin/super/index', 'fa-circle-o', 1, 1000, 'GET'),
(137, 136, '添加', 'admin/super/add', 'fa-circle-o', 0, 1000, 'POST'),
(138, 136, '修改', 'admin/super/edit', 'fa-circle-o', 0, 1000, 'POST'),
(139, 136, '删除', 'admin/super/del', 'fa-circle-o', 0, 1000, 'POST'),
(140, 80, '限购商店', 'admin/day_limit/index', 'fa-circle-o', 1, 1000, 'GET'),
(141, 140, '添加', 'admin/day_limit/add', 'fa-circle-o', 0, 1000, 'POST'),
(142, 140, '修改', 'admin/day_limit/edit', 'fa-circle-o', 0, 1000, 'POST'),
(143, 140, '删除', 'admin/day_limit/del', 'fa-circle-o', 0, 1000, 'POST'),
(144, 80, '新鲜玩意', 'admin/fresh/index', 'fa-circle-o', 1, 1000, 'GET'),
(145, 144, '添加', 'admin/fresh/add', 'fa-circle-o', 0, 1000, 'POST'),
(146, 144, '修改', 'admin/fresh/edit', 'fa-circle-o', 0, 1000, 'POST'),
(147, 144, '删除', 'admin/fresh/del', 'fa-circle-o', 0, 1000, 'POST'),
(148, 80, '强化商店', 'admin/mall/index', 'fa-circle-o', 1, 1000, 'GET'),
(149, 148, '添加', 'admin/mall/add', 'fa-circle-o', 0, 1000, 'POST'),
(150, 148, '修改', 'admin/mall/edit', 'fa-circle-o', 0, 1000, 'POST'),
(151, 148, '删除', 'admin/mall/del', 'fa-circle-o', 0, 1000, 'POST'),
(160, 0, '大区管理', 'admin/sys', ' fa-th-large', 1, 1000, '不记录'),
(161, 160, '合区工具', 'admin/merge_server/index', 'fa-circle-o', 1, 1000, '不记录')";
        $query = Db::query($sql);
        if ($query) {
            $msg = '后台管理菜单导入成功.' . "\n";

            print ($msg);
        }

    }
}