42 lines
1.0 KiB
PHP
42 lines
1.0 KiB
PHP
<?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);
|
|
}
|
|
}
|
|
}
|