<?php

namespace App\Imports;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use PhpOffice\PhpSpreadsheet\Shared\Date;

class AssociadoImport implements ToCollection
{
    public Collection $rows;

    public function collection(Collection $rows): void
    {
        $this->rows = $rows->skip(1)->values()->filter(function ($row) {
            return !empty(trim((string) ($row[0] ?? '')))
                && !empty(trim((string) ($row[1] ?? '')))
                && !empty(trim((string) ($row[2] ?? '')));
        })->map(function ($row) {
            return [
                'registration' => trim((string) $row[0]),
                'name'         => trim((string) $row[1]),
                'admission_date' => Date::excelToDateTimeObject($row[2] ?? '')->format('Y-m-d'),
            ];
        })->values();
    }
}