NN2021040101/database/seeds/SettingTableSeeder.php

<?php

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;

class SettingTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {

        $rid=DB::table('admin_roles')->insertGetId(['name' => '管理员[不能删除]', 'slug' => 'admin']);
        DB::table('admin_role_menu')->insert(['menu_id' => 1, 'role_id' => $rid]);

        //1.menu
        $paht=env('ADMIN_ROUTE_PREFIX', 'admin');
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 8,'title'=>'应用设置','icon'=>'fa-cogs','uri'=>'setting/app']);
        DB::table('admin_permissions')->insert(['name' => '应用设置', 'slug' => 'love.appset','http_method'=>'','http_path'=>'/'.$paht.'/setting/app']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.1
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'系统设置','icon'=>'fa-cog','uri'=>'setting/sys']);
        DB::table('admin_permissions')->insert(['name' => '系统设置', 'slug' => 'love.sysset','http_method'=>'','http_path'=>'/'.$paht.'/setting/sys']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.3vip
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'VIP管理','icon'=>'fa-viacoin','uri'=>'vip']);
        DB::table('admin_permissions')->insert(['name' => 'VIP管理', 'slug' => 'love.vip','http_method'=>'','http_path'=>'/'.$paht.'/vip']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.4 玫瑰
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'玫瑰管理','icon'=>'fa-soccer-ball-o','uri'=>'rose']);
        DB::table('admin_permissions')->insert(['name' => '玫瑰管理', 'slug' => 'love.rose','http_method'=>'','http_path'=>'/'.$paht.'/rose']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.4订单管理
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'订单管理','icon'=>'fa-jpy','uri'=>'orders']);
        DB::table('admin_permissions')->insert(['name' => '订单管理', 'slug' => 'love.orders','http_method'=>'','http_path'=>'/'.$paht.'/orders']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.5礼物管理
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'礼物管理','icon'=>'fa-envira','uri'=>'gift']);
        DB::table('admin_permissions')->insert(['name' => '礼物管理', 'slug' => 'love.gift','http_method'=>'','http_path'=>'/'.$paht.'/gift']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.6 广告管理
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'广告管理','icon'=>'fa-buysellads','uri'=>'ads']);
        DB::table('admin_permissions')->insert(['name' => '广告管理', 'slug' => 'love.ads','http_method'=>'','http_path'=>'/'.$paht.'/ads']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.6 提现管理
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'提现管理','icon'=>'fa-credit-card','uri'=>'cashout']);
        DB::table('admin_permissions')->insert(['name' => '提现管理', 'slug' => 'love.cashout','http_method'=>'','http_path'=>'/'.$paht.'/cashout']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.6 标签管理
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'标签管理','icon'=>'fa-tags','uri'=>'tags']);
        DB::table('admin_permissions')->insert(['name' => '标签管理', 'slug' => 'love.tags','http_method'=>'','http_path'=>'/'.$paht.'/tags']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.6 动态管理
        $midf=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'动态管理','icon'=>'fa-comments','uri'=>'']);
        DB::table('admin_role_menu')->insert(['menu_id' => $midf, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $midf, 'role_id' => $rid]);

        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'朋友圈管理','icon'=>'fa-comments-o','uri'=>'dynamic']);
        DB::table('admin_permissions')->insert(['name' => '朋友圈管理', 'slug' => 'love.zone','http_method'=>'','http_path'=>'/'.$paht.'/dynamic']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'话题管理','icon'=>'fa-hand-stop-o','uri'=>'topic']);
        DB::table('admin_permissions')->insert(['name' => '话题管理', 'slug' => 'love.topic','http_method'=>'','http_path'=>'/'.$paht.'/topic']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //1.6 用户管理
        $midf=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'会员管理','icon'=>'fa-users','uri'=>'']);
        DB::table('admin_role_menu')->insert(['menu_id' => $midf, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $midf, 'role_id' => $rid]);

        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'用户管理','icon'=>'fa-hand-stop-o','uri'=>'users']);
        DB::table('admin_permissions')->insert(['name' => '用户管理', 'slug' => 'love.users','http_method'=>'','http_path'=>'/'.$paht.'/users']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'举报管理','icon'=>'fa-hand-stop-o','uri'=>'report']);
        DB::table('admin_permissions')->insert(['name' => '举报管理', 'slug' => 'love.report','http_method'=>'','http_path'=>'/'.$paht.'/report']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'红娘群管理','icon'=>'fa-object-group','uri'=>'groups']);
        DB::table('admin_permissions')->insert(['name' => '红娘群管理', 'slug' => 'love.groups','http_method'=>'','http_path'=>'/'.$paht.'/groups']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => $midf, 'order' => 9,'title'=>'房间管理','icon'=>'fa-university','uri'=>'room']);
        DB::table('admin_permissions')->insert(['name' => '房间管理', 'slug' => 'love.room','http_method'=>'','http_path'=>'/'.$paht.'/room']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' =>$rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'审核管理','icon'=>'fa-calendar-check-o','uri'=>'verify']);
        DB::table('admin_permissions')->insert(['name' => '审核管理', 'slug' => 'love.verify','http_method'=>'','http_path'=>'/'.$paht.'/verify']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 9,'title'=>'分享管理','icon'=>'fa-share-alt-square','uri'=>'share']);
        DB::table('admin_permissions')->insert(['name' => '分享管理', 'slug' => 'love.share','http_method'=>'','http_path'=>'/'.$paht.'/share']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        $mid=DB::table('admin_menu')->insertGetId(['parent_id' => 0, 'order' => 10,'title'=>'红娘申请管理','icon'=>'fa-share-alt-square','uri'=>'apply']);
        DB::table('admin_permissions')->insert(['name' => '遇遇管理', 'slug' => 'love.apply','http_method'=>'','http_path'=>'/'.$paht.'/apply']);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => 1]);
        DB::table('admin_role_menu')->insert(['menu_id' => $mid, 'role_id' => $rid]);
        //2.设置初始化
        DB::table('love_app_settings')->insert(['sole' => 'uclouds.dev', 'access_key' => '1400134106', 'secret_key' => '云通讯私钥', 'other' => 'admin云通讯管理员账号写为admin', 'extend' =>'', 'enabled' => 1,'description'=>'腾讯云-云通信和RTMP和移动直播']);
        DB::table('love_app_settings')->insert(['sole' => '377123.com', 'access_key' => '605a2134aeb74360deca463f7efe3172', 'secret_key' => '$2y$10$9KTRG.OmMcm6CN77gl9GyOOFN0yZfB241OEMoF0kpX34psAnVmnCG', 'other' =>'ME_145993771', 'extend' =>'', 'enabled' => 1,'description'=>'短信验证码']);
        DB::table('love_app_settings')->insert(['sole' => 'amap.com', 'access_key' => '5589f8dd9d080ea9d60c715062c60682', 'secret_key' => '', 'other' =>'', 'extend' =>'', 'enabled' => 1,'description'=>'高得地图']);
        DB::table('love_app_settings')->insert(['sole' => 'aliyun.com', 'access_key' => '25675638', 'secret_key' => '528c11082979b18dc57d772b035d0ad4', 'other' =>'87ea26af4a6f4499978e58fe496c7c17', 'extend' =>'', 'enabled' => 1,'description'=>'身份证二验证']);
        DB::table('love_app_settings')->insert(['sole' => 'wechat.com', 'access_key' => 'AppID', 'secret_key' => '商户号里面设置的支付密码', 'other' =>'商户号', 'extend' =>'', 'enabled' => 1,'description'=>'微信支付']);
        DB::table('love_app_settings')->insert(['sole' => 'alipay.com', 'access_key' => 'appid', 'secret_key' => '工具生成的私钥', 'other' =>'支付宝公钥', 'extend' =>'', 'enabled' => 1,'description'=>'支付宝支付']);
        DB::table('love_app_settings')->insert(['sole' => 'weixin.qq.com', 'access_key' => 'appid', 'secret_key' => 'secret', 'other' =>'', 'extend' =>'', 'enabled' => 1,'description'=>'微信登录分享']);
        DB::table('love_app_settings')->insert(['sole' => 'api.qcloud.com', 'access_key' => 'SecretId', 'secret_key' => 'SecretKey', 'other' =>'接入地域', 'extend' =>'', 'enabled' => 1,'description'=>'腾讯云-API密钥']);

        //3.系统配置
        DB::table('love_settings')->insert(['name'=>'人民币兑玫瑰比例','key' => 'love.rmb.roses.scale', 'value' => 10,'description'=>'例如:10 表示1元可购买10个玫瑰']);
        DB::table('love_settings')->insert(['name'=>'男用户注册送玫瑰数','key' => 'love.man.give.roses', 'value' => 10,'description'=>'送玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'女用户注册送玫瑰数','key' => 'love.women.give.roses', 'value' => 10,'description'=>'送玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'男用户每天随机聊次数','key' => 'love.man.give.chat', 'value' => 10,'description'=>'随机聊次数']);
        DB::table('love_settings')->insert(['name'=>'女用户每天随机聊次数','key' => 'love.women.give.chat', 'value' => 10,'description'=>'随机聊次数']);
        DB::table('love_settings')->insert(['name'=>'男用户加入红娘群需玫瑰数','key' => 'love.men.join.group', 'value' => 10,'description'=>'男用户加入群需要玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'男用户专属相亲需玫瑰数/分种','key' => 'love.men.only.love', 'value' => 10,'description'=>'专属相亲']);
        DB::table('love_settings')->insert(['name'=>'男用户申请上麦需玫瑰数/次','key' => 'love.men.apply.love', 'value' => 10,'description'=>'申请上麦需玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'男用户咨询红娘月老需玫瑰数/分种','key' => 'love.men.consultation', 'value' => 10,'description'=>'红娘咨询需玫瑰数/分种']);
        DB::table('love_settings')->insert(['name'=>'用户申请加好友需玫瑰数/次','key' => 'love.join.friend', 'value' => 10,'description'=>'用户申请加好友']);
        DB::table('love_settings')->insert(['name'=>'更新守护要多少以上的玫瑰','key' => 'love.up.guard', 'value' => 10,'description'=>'更新守护要多少玫瑰']);
        DB::table('love_settings')->insert(['name'=>'送月老/红娘礼物给分成比例','key' => 'love.give.red.scale', 'value' => 10,'description'=>'例如10 标示10%']);
        DB::table('love_settings')->insert(['name'=>'送嘉宾礼物给月老/红娘分成比例','key' => 'love.gift.red.scale', 'value' => 10,'description'=>'例如10 标示10%']);
        DB::table('love_settings')->insert(['name'=>'送嘉宾礼物给嘉宾分成比例','key' => 'love.gift.scale', 'value' => 10,'description'=>'例如10 标示10%']);
        DB::table('love_settings')->insert(['name'=>'每天分享送玫瑰数','key' => 'love.share.give.roses.day', 'value' => 10,'description'=>'每天分享送玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'邀请用户注册送vip天数','key' => 'love.share.give.vip', 'value' => 10,'description'=>'邀请用户注册送vip天数']);
        DB::table('love_settings')->insert(['name'=>'邀请用户注册送玫瑰数','key' => 'love.share.give.roses', 'value' => 10,'description'=>'邀请用户注册送玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'邀请用户注册并完成认证送体验卡','key' => 'love.share.give.card', 'value' => 10,'description'=>'邀请用户注册并完成认证送体验卡']);
        DB::table('love_settings')->insert(['name'=>'用户无征友条件提示语','key' => 'love.user.notice', 'value' => '我想找一个有缘的异性,快来联系我吧','description'=>'用户无征友条件时提示语']);
        DB::table('love_settings')->insert(['name'=>'红色情侣锁定最低送多少礼物玫瑰数！','key' => 'love.red.lovers', 'value' => '9999','description'=>'红色情侣锁定最低送礼物玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'蓝色情侣锁定最低送多少礼物玫瑰数！','key' => 'love.blue.lovers', 'value' => '18888','description'=>'蓝色情侣锁定最低送礼物玫瑰数']);
        DB::table('love_settings')->insert(['name'=>'红娘月老钱包最低多少才能提现','key' => 'love.user.min.cashout', 'value' => '100','description'=>'红娘月老钱包最低多少才能提现']);
        DB::table('love_settings')->insert(['name'=>'红娘月老提现应缴税点','key' => 'love.user.cashout.taxation', 'value' => '15','description'=>'例如：15表示15%(提现扣100*15%=15)']);
        DB::table('love_settings')->insert(['name'=>'用户发动态是否要手机号认证','key' => 'love.add.dynamic.tel', 'value' => '1','description'=>'用户发动态是否要手机号认证']);
        DB::table('love_settings')->insert(['name'=>'用户发动态是否要绑定微信','key' => 'love.add.dynamic.wechat', 'value' => '1','description'=>'用户发动态是否要绑定微信']);
        DB::table('love_settings')->insert(['name'=>'用户发动态扣他多少玫瑰','key' => 'love.add.dynamic.reduce', 'value' => '0','description'=>'用户发动态扣他多少玫瑰0表示不扣']);
        DB::table('love_settings')->insert(['name'=>'用户收费动态最多只能多少玫瑰','key' => 'love.add.dynamic.max', 'value' => '0','description'=>'用户收费动态最多只能多少玫瑰']);
        DB::table('love_settings')->insert(['name'=>'用户礼物榜查过去多少天的数据','key' => 'love.user.gift.top', 'value' => '15','description'=>'例如:15表示过去15天送礼物排行榜']);
        DB::table('love_settings')->insert(['name'=>'用户过去N天累计最小送多少礼物且排名第一为守护','key' => 'love.min.rose.guard', 'value' => '99','description'=>'此值和排行榜天数配合使用']);
        DB::table('love_settings')->insert(['name'=>'用户送最小多大的礼物才更新排行榜','key' => 'love.user.gift.top.up', 'value' => '99','description'=>'例如:99表示最低送99玫瑰的礼物才更新排行榜']);
       
        DB::table('love_settings')->insert(['name'=>'直播间虚拟人数比例','key' => 'love.rome.ratio', 'value' => '99','description'=>'例如:99表示进房间1人显示99人']);
        //新增
        DB::table('love_settings')->insert(['name'=>'红娘邀请红娘佣金功能','key' => 'love.give.red.black', 'value' => '10','description'=>'例如:10表示10%']);
        DB::table('love_settings')->insert(['name'=>'送王牌月老/王牌红娘礼物给分成比例','key' => 'love.give.wang.red.scale', 'value' => 10,'description'=>'例如10 标示10%']);
        DB::table('love_settings')->insert(['name'=>'送嘉宾礼物给王牌月老/王牌红娘分成比例','key' => 'love.gift.wang.red.scale', 'value' => 10,'description'=>'例如10 标示10%']);
        //广告位管理
        DB::table('love_ad_category')->insert(['sole'=>'home.banner', 'category_name'=>'首页banner广告','width'=>750, 'heigh'=>400, 'description'=>'首页广告']);
        DB::table('love_ad_category')->insert(['sole'=>'love.banner', 'category_name'=>'相亲页广告','width'=>750, 'heigh'=>400, 'description'=>'相亲页广告']);
        DB::table('love_ad_category')->insert(['sole'=>'dynamic.banner', 'category_name'=>'动态页banner广告','width'=>750, 'heigh'=>400, 'description'=>'动态页广告']);
        DB::table('love_ad_category')->insert(['sole'=>'start.banner', 'category_name'=>'开屏页广告','width'=>1280, 'heigh'=>720, 'description'=>'开屏页广告']);
        //默认卡数量
        DB::table('love_card')->insert(['name'=>'相亲体验卡', 'type'=>'1','num'=>750]);
        //分享设置默认值
        DB::table('love_share_settings')->insert([ 'username'=>'', 'domain'=>'域名/小程序PATH','icon'=>'图','title'=>'标题','description'=>'描述','live_rome_username'=>'', 'live_rome_title'=>'标题', 'live_rome_icon'=>'','live_rome_description'=>'描述','live_rome_domain'=>'path']);
        //默认礼物
        DB::table('love_gifts')->insert([ 'name'=>'玫瑰','file'=>env('APP_URL').'/rose.png','svga'=>'','type'=>0,'rose'=>1,'size'=>0, 'sort'=>1]);
   }
}