<?php

use Illuminate\Database\Seeder;
use App\Models\Department;
use App\Models\User;
use App\Http\Controllers\Auth;
use App\Models\Tag;

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

		foreach($departments as $department)
		{
			$instances				= DB::connection('mysql_alt')->select("SELECT instanz_id FROM ikarus_instanz_abteilung WHERE abteilung_id = ".$department->id);
			$i						= array();
			foreach($instances as $instance)
			{
				$i[]				= $instance->instanz_id;
			}

            $new_user = User::find($department->benutzer_id);
            \Auth::login( $new_user );

			echo "INSERT department: $department->id\n";
            $item					= new Department;
			$item->id				= $department->id;
			$item->name				= $department->name;
			$item->user_id			= $department->benutzer_id;
			$item->save();
			$item->instances()->sync($i);
		}
    }
}