AssociadoImport.php 657 B

123456789101112131415161718192021222324
  1. <?php
  2. namespace App\Imports;
  3. use Illuminate\Support\Collection;
  4. use Maatwebsite\Excel\Concerns\ToCollection;
  5. class AssociadoImport implements ToCollection
  6. {
  7. public Collection $rows;
  8. public function collection(Collection $rows): void
  9. {
  10. $this->rows = $rows->skip(1)->values()->filter(function ($row) {
  11. return !empty(trim((string) ($row[0] ?? '')))
  12. && !empty(trim((string) ($row[1] ?? '')));
  13. })->map(function ($row) {
  14. return [
  15. 'registration' => trim((string) $row[0]),
  16. 'name' => trim((string) $row[1]),
  17. ];
  18. })->values();
  19. }
  20. }