<?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);
        }
    }
}