<?php


namespace App\Komma\Excel\Types\Exports;


use App\Komma\Excel\Types\Row\AbsenceRow;
use Illuminate\Contracts\View\View;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithColumnFormatting;
use Maatwebsite\Excel\Concerns\WithColumnWidths;
use Maatwebsite\Excel\Concerns\WithTitle;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

class AbsencesExport implements FromView, ShouldAutoSize, WithTitle, WithColumnFormatting, WithColumnWidths
{

    protected Collection $groups;
    protected array $attributes;

    public function __construct(Collection $groups)
    {
        $this->groups = $groups;
        $this->attributes = AbsenceRow::getAttributes();
    }

    public function view(): View
    {
        return view('excel.export', [
            'attributes' => $this->attributes,
            'groups' => $this->groups,
        ]);
    }

    /**
     * @return string
     */
    public function title(): string
    {
        return 'Uren';
    }

    public function columnFormats(): array
    {
        return [
            'C' => NumberFormat::FORMAT_DATE_DDMMYYYY,
        ];
    }

    public function columnWidths(): array
    {
        return [
            'A' => 80,
        ];
    }
}