SET\Handlers\Excel\CompletedTrainingExportHandler

Complexity

Total Complexity

3

Size/Duplication

Total Lines	32
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	view()	0	11	1
A	title()	0	4	1
A	registerEvents()	0	9	1

<?php

namespace SET\Handlers\Excel;

//use Maatwebsite\Excel\Files\ExportHandler;
//use Maatwebsite\Excel\Concerns\FromCollection;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Events\AfterSheet;
use SET\Training;
use SET\User;

class CompletedTrainingExportHandler implements FromView, WithEvents, ShouldAutoSize, WithTitle
{
    public function view(): View
    {
        $trainings = Training::all();
        $users = User::skipSystem()->with([
            'assignedTrainings' => function ($q) {
                $q->whereNotNull('completed_date')->orderBy('completed_date', 'desc');
            },
        ])->active()->orderBy('last_name')->get();
        return view('report.completed_training', ['users' => $users, 'trainings' => $trainings]);

    }

    public function title(): string
    {
        return 'User-Training';
    }

    /**
     * @return array
     */
    public function registerEvents(): array
    {
        return [
            AfterSheet::class    => function(AfterSheet $event) {
                $cellRange = 'A1:ZZ1'; // All headers
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setBold(true);
            },
        ];
    }
}