SET\Handlers\Excel\CompletedTrainingExportHandler::handle()

Complexity

Conditions	1
Paths	1

Size

Total Lines

13

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

<?php
    public function handle($export)
    {
        return $export->sheet('User-Training', function ($sheet) {
            $trainings = Training::all();
            $users = User::skipSystem()->with([
                'assignedTrainings' => function ($q) {
                    $q->whereNotNull('completed_date')->orderBy('completed_date', 'desc');
                },
            ])->active()->orderBy('last_name')->get();

            $sheet->loadView('report.completed_training', ['users' => $users, 'trainings' => $trainings]);
        })->download('xlsx');
    }
}