<?php

namespace App\Imports;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;

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] ?? '')));
        })->map(function ($row) {
            return [
                'registration' => trim((string) $row[0]),
                'name'         => trim((string) $row[1]),
            ];
        })->values();
    }
}