112 lines
2.3 KiB
PHP
112 lines
2.3 KiB
PHP
<?php
|
|
|
|
namespace Database\Seeders;
|
|
|
|
use Illuminate\Database\Seeder;
|
|
use DB;
|
|
|
|
class RolesPermissionSeeder extends Seeder
|
|
{
|
|
/**
|
|
* Run the database seeds.
|
|
*
|
|
* @return void
|
|
*/
|
|
public function run()
|
|
{
|
|
//清空现有权限
|
|
DB::table('admin_role_permissions')->truncate();
|
|
$json_data = '[
|
|
{
|
|
"role_id":2,
|
|
"permission_id":7
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":8
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":10
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":11
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":13
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":14
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":16
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":17
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":18
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":20
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":21
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":23
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":24
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":25
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":26
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":27
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":28
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":29
|
|
},
|
|
{
|
|
"role_id":2,
|
|
"permission_id":30
|
|
}]';
|
|
|
|
$list = json_decode($json_data);
|
|
|
|
$insert_data = array();
|
|
foreach ($list as $key => $value) {
|
|
$insert_data[] = [
|
|
'role_id' => $value->role_id,
|
|
'permission_id' => $value->permission_id,
|
|
];
|
|
}
|
|
|
|
if(count($insert_data) > 0){
|
|
DB::table('admin_role_permissions')->insert($insert_data);
|
|
}
|
|
}
|
|
}
|