<?php

namespace Database\Seeders;

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

class BackendUsersPermissionsTableSeeder extends Seeder
{

    private $table = 'backend_users_permissions';

    protected function _getData()
    {
        return [
            [
                'backend_user_id'       => 1,
                'backend_permission_id' => 1
            ],
            [
                'backend_user_id'       => 1,
                'backend_permission_id' => 2
            ],
            [
                'backend_user_id'       => 1,
                'backend_permission_id' => 3
            ],
            [
                'backend_user_id'       => 1,
                'backend_permission_id' => 4
            ]
        ];
    }

    /**
     * Run the database seeders.
     *
     * @return void
     */
    public function run()
    {
        $data = $this->_getData();

        foreach ($data as $dataItem) {
            $dbItem = DB::table($this->table)->where([
                ['backend_user_id', '=', $dataItem['backend_user_id']],
                ['backend_permission_id', '=', $dataItem['backend_permission_id']],
            ])->first();

            if (!empty($dbItem)) {
                continue;
            }

            DB::table($this->table)->insert($dataItem);
        }
    }
}