<?php

use Illuminate\Database\Seeder;
use Spatie\Permission\Models\Role;
use App\Models\User;
use App\Http\Controllers\Auth;

class UserSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
		$users						= DB::connection('mysql_alt')->select("SELECT * FROM ikarus_sf_guard_user");

		foreach($users as $user)
		{
			$item					= new User;
			$item->id				= $user->id;
			if($user->id == 1)
			{
				$item->name			= 'Admin';
			}
			else
			{
                $new_user = User::find(1);
                \Auth::login( $new_user );
				$item->name			= $user->username;
			}
			$item->email			= $user->username.'@feuerwehr-eppingen.de';
			$item->password			= 'ffw';
			$item->save();

			if($user->id == 1)
			{
				$adminRole			= Role::where('name', 'Administrator')->first();
				if($adminRole)
				{
					$item->assignRole($adminRole);
				}
			}
		}
    }
}