order-food-admin/database/seeders/RolesSeeder.php

122 lines
2.5 KiB
PHP

<?php
namespace Database\Seeders;
use Illuminate\Database\Seeder;
use DB;
class RolesSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//清空现有权限
DB::table('admin_roles')->truncate();
$json_data = '[
{
"name":"Administrator",
"slug":"administrator"
},
{
"name":"管理员",
"slug":"admin"
}]';
$list = json_decode($json_data);
$insert_data = array();
foreach ($list as $key => $value) {
$insert_data[] = [
'name' => $value->name,
'slug' => $value->slug,
];
}
if(count($insert_data) > 0){
DB::table('admin_roles')->insert($insert_data);
}
//清空角色菜单
DB::table('admin_role_menu')->truncate();
$json_data = '[
{
"role_id":2,
"menu_id":1
},
{
"role_id":2,
"menu_id":8
},
{
"role_id":2,
"menu_id":9
},
{
"role_id":2,
"menu_id":10
},
{
"role_id":2,
"menu_id":11
},
{
"role_id":2,
"menu_id":12
},
{
"role_id":2,
"menu_id":13
},
{
"role_id":2,
"menu_id":14
},
{
"role_id":2,
"menu_id":15
},
{
"role_id":2,
"menu_id":16
},
{
"role_id":2,
"menu_id":17
},
{
"role_id":2,
"menu_id":18
},
{
"role_id":2,
"menu_id":19
},
{
"role_id":2,
"menu_id":20
},
{
"role_id":2,
"menu_id":21
}]';
$list = json_decode($json_data);
$insert_data = array();
foreach ($list as $key => $value) {
$insert_data[] = [
'role_id' => $value->role_id,
'menu_id' => $value->menu_id,
];
}
if(count($insert_data) > 0){
DB::table('admin_role_menu')->insert($insert_data);
}
}
}