Laravel excel import skiponerrors event

[RVP04]

I have an excel import class and it is working fine. I need to send email to user when any error or failure happened.

Send the failed count, records and other information to user via email. I have code need to restructure it.

<?php

namespace App\Imports;

use App\Mail\SuperAdmin\Imports\StudentImportCompletedMail;
use App\Models\Department;
use App\Models\Gender;
use App\Models\Level;
use App\Models\User;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\Hash;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Mail;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\RegistersEventListeners;
use Maatwebsite\Excel\Concerns\SkipsFailures;
use Maatwebsite\Excel\Concerns\SkipsOnFailure;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Maatwebsite\Excel\Events\AfterImport;
use Maatwebsite\Excel\Events\ImportFailed;

class UserStudentImport implements ToCollection, WithChunkReading, ShouldQueue, WithEvents, WithHeadingRow, SkipsOnFailure
{
    use Importable, RegistersEventListeners, SkipsFailures;
    /**
     * @param Collection $rows
     */
    public function collection(Collection $rows)
    {
        
    }

    public function chunkSize(): int
    {
        return 75;
    }

    public function registerEvents(): array
    {
        return [
            ImportFailed::class => function (ImportFailed $event) {
                if (isset($this->importedBy->email)) {
                    Mail::to($this->importedBy->email)->queue(new StudentImportFailedMail());
                }
            },
            AfterImport::class => function (AfterImport $event) {
                if (isset($this->importedBy->email)) {
                    Mail::to($this->importedBy->email)->queue(new StudentImportCompletedMail());
                    Log::info('User Imported Mail Sent Sucessfully');
                }
            },
        ];
    }
}

How to get failed records information from the $event object.

[patrickbrouwers]

$this->failures

[RVP04]

Can you be more specific about row number and row data. And what is the type ?

[patrickbrouwers]

Just dd() it 🤷‍♂️

[RVP04]

Okay sir will try