Sync study groups console command

sync_command.php

<?php

namespace App\Console\Commands;

use App\Models\Course;
use App\Models\StudyGroup;
use App\Models\Teacher;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class SyncStudyGroups extends Command
{
    protected $signature = 'sync:groups';

    protected $description = 'Синхронизация учебных групп';

    public function handle()
    {
        $remoteGroups = DB::connection('tma')
            ->table('studygroup')
            ->get();

        StudyGroup::query()->truncate();

        foreach ($remoteGroups as $remoteGroup) {
            $course = Course::query()->where('remote_id', $remoteGroup->Curse)->first();
            $teacher = Teacher::query()->where('remote_id', $remoteGroup->Teacher)->first();

            if (!$course)
                continue;

            switch ($remoteGroup->Type) {
                case 1:
                    $type = 'Утро';
                    break;
                case 2:
                    $type = 'День';
                    break;
                case 3:
                    $type = 'Вечер';
                    break;
                default:
                    $type = 'Выходные дни';
                    break;
            }

            $groupTimeData = json_decode($remoteGroup->descr_json, true);

            StudyGroup::query()->updateOrCreate([
                'id' => $remoteGroup->Id,
            ], [
                'code'       => $remoteGroup->Code,
                'course_id'  => $course->id,
                'teacher_id' => $teacher
                    ? $teacher->id
                    : null,
                'is_public'  => $remoteGroup->is_public
                    ?: false,
                'start_at'   => $remoteGroup->DateStart,
                'finish_at'  => $remoteGroup->DateEnd,
                'type'       => $type,
                'days'       => isset($groupTimeData['days'])
                    ? $groupTimeData['days']
                    : null,
                'hours'      => isset($groupTimeData['hours'])
                    ? $groupTimeData['hours']
                    : null,
            ]);
        }

        $this->output->success('Учебные группы успешно синхронизированы');
    }
}