<?php

namespace Database\Seeders;

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

class BackendPermissionsGroupsTableSeeder extends Seeder
{

    private $table = 'backend_permissions_groups';

    protected function _getData()
    {
        $now = Carbon::now();

        return [
            [
                'id'         => 1,
                'name'       => 'BO Users and Permissions',
                'position'   => 2,
                'created_at' => $now,
            ],
            [
                'id'         => 2,
                'name'       => 'CMS',
                'position'   => 1,
                'created_at' => $now,
            ]
        ];
    }

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

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

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

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