Failed Error not being displayed when Excel Maatwebsite import failed

[noblemfd]

Using Laravel-5.8 and Maatwebsite-3.1, I have a table called employees (Employee).

Excel Import:

class EmployeeGradeLevelsImport implements
    ToCollection,
    WithHeadingRow,
    SkipsOnError,
    WithValidation,
    SkipsOnFailure
{
    use Importable, SkipsErrors, SkipsFailures;

    public function collection(Collection $rows)
    {            
        foreach ($rows as $row) 
        {
            $this->gradelevel = $row['grade_level_code'];

            HrEmployee::where('company_id', auth()->user()->company_id)
                ->where('employee_code', $row['staff_id'])
                ->where('email', $row['official_email'])     
                ->update([
                    'grade_level_id' => $this->getGradeLevel(),
                    'employee_code' => $row['staff_id'],
                    'email'         => $row['official_email'],
                ]);
        }
    } 

    public function rules(): array
    {
        return [
            '*.employee_code' => [
                'required',
                'min:2',
                'max:20',               
            ], 
            '*first_name' => [
                'required',
                'string',
                'min:3',
                'max:50'               
            ],  
            '*last_name' => [
                'required',
                'string',
                'min:3',
                'max:50'               
            ],            
            '*grade_level_code'            => 'required',  
            '*official_email' => [
                'required',
                'email', // official email
                'max:100',               
            ],            
        ];    
    } 

    public function customValidationAttributes()
    {
        return [
            'company_id'                                => 'Company',
            'grade_level_code'                          => 'Grade Level Code',
            'employee_code'                             => 'Staff ID',
            'first_name'                                => 'First Name',
            'last_name'                                 => 'Last Name',            
        ];
    }

    public function getGradeLevel(){
        if(!empty($this->gradelevel) || !$this->gradelevel){

            return HrGradeLevel::where('grade_level_code',$this->gradelevel)->where('company_id',Auth::user()->company_id)->pluck('id')->first();
        } else {
            return 0;
        }
    }

    public function headingRow(): int
    {
        return 1;
    }          
}

Here is my Controller function

Controller:

public function importEmployeeGradeLevel(Request $request){
    if (empty($request->file('file'))) 
    {
        return back()->with('error','File cannot be empty!');
    }
    else{   
        request()->validate([
           'file'  => 'required|mimes:xls,xlsx,csv|max:2048',
        ]); 
            
        $pathTofile = $request->file('file')->store('import');        

        $import =  new EmployeeGradeLevelsImport;
        $import->import($pathTofile); 
        if($import->failures()->isNotEmpty()){
            $failures = $import->failures();
            Session::flash('failures', $failures);
            return view('hr.employees.import_employee_grade_form')->with('failures', $failures);
        } 
    Session::flash('success', 'Employee Grade Records Update Imported Successfully');
    return redirect()->route('hr.employees.index');     
    }    
}

Finally the view blade error message:

@if (Session::has('failures'))
<div class="alert alert-danger alert-block" role="alert">
  <button type="button" class="close" data-dismiss="alert">×</button>
  <strong>Failed Upload(s): </strong>
  <table class=" table table-bordered table-striped table-hover">
    <thead>
      <tr>
        <th>
          Row
        </th>
        <th>
          Attribute
        </th>
        <th>
          Error
        </th>
        <th>
          Values
        </th>
      </tr>
    </thead>
    <tbody>
      @foreach( $failures as $validation )
      <tr>
        <td>
          {{ $validation->row() ?? '' }}
        </td>
        <td>
          {{ $validation->attribute() ?? '' }}
        </td>
        <td>
          <ul>
            @foreach($validation->errors() as $e)
            <li>{{$e ?? '' }}</li>
            @endforeach
          </ul>
        </td>
        <td>
          <ul>
            @foreach($validation->values() as $v)
            <li>{{$v ?? '' }}</li>
            @endforeach
          </ul>
        </td>
      </tr>
      @endforeach
    </tbody>
  </table>
</div>
@endif

I want to use the excel upload to update these two (2) fields: email and grade_level_id for each of the employees where:

company_id = Auth::user()->company_id AND employee_code = $row['staff_id'].

Also, it should only perform the update for those that meet the condition. I should only perform update and don't create.

I observe that when there is failure, it won't update failed message but it will only exclude the failed ones. Also it will display Success, and yet some did not meet the condition (though it won't update those ones.)

In the controller, I dd($import);

But got this:

 App\Imports\EmployeeGradeLevelsImport {#1140 ▼
  #output: null
  #errors: []
  #failures: []
  +"gradelevel": null
}

Yes, some failed.

How do I correct this?

Thanks

[Zubair-Iftikhar]

@noblemfd Please Share Logs.

[noblemfd]

@Zu007 - There is no error in the Log