Import Multiple sheet validation using ToCollection with SkipsOnFailure and SkipsOnError but still import the first sheet

[chammeow]

The logic is...

I have 3 sheets. Sheet 1 validation success, sheet2 validation fails, sheet3 validation success. With this scenario, all import must fail but currently Sheet1Import class insert to database successfully. Please help me. Here is my code.

==================
IMPORT CONTROLLER

public function importMerchant(Request $request)
{
$merchant = Merchant::find($request['merchant_id']);

    try {
        Excel::import(new MerchantImport($merchant), $request['file_merchant']);
    } catch (ValidationException $e) {
         return response()->json(['status'=>'false','message'=> $e->errors()]);
    }

}

==================
SHEET IMPORT CLASS

namespace App\Imports;

use App\Models\Merchant;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;

class MerchantImport implements WithMultipleSheets
{
public function __construct(Merchant $merchant)
{
$this->merchant = $merchant;
}

public function sheets(): array
{
    return [
        'sheet1' => new MerchantBranchImport($this->merchant),
        'sheet2' => new MerchantBranchSectionImport()
    ];
}

}

==================
SHEET1 IMPORT CLASS

class Sheet1 implements ToCollection, WithHeadingRow, SkipsEmptyRows, SkipsOnFailure, SkipsOnError, Skips
{
use SkipsFailures, SkipsErrors;

public function  __construct(Merchant $merchant)
{
    $this->merchant = $merchant;
}

public function collection(Collection $rows)
{
    Validator::make($rows->toArray(), [
        '*.branch_name' => ['required','string', 'min:3'], //branch name
        '*.contact_number' => ['required','unique:mysql_api.merchant_branches,contact_number'], //contact number
        '*.email' => ['required','email', 'unique:mysql_api.merchant_branches,email'], //email
        '*.password' => ['required','string', 'min:8'], //password
        '*.longitude' => ['required', 'min:3'], //longitude
        '*.latitude' => ['required', 'min:3'], //latitude
        '*.address_line' => ['required','string', 'min:3'], //address line
        '*.preferred_merchant' => ['required','in:1,0'], //preferred merchant
        '*.mdr' => ['required','numeric', 'between:0,9999.99'], //mdr
        '*.mdr_type' => ['required','in:flat,percent'], //mdr type,
        '*.tags' => ['required','string', 'min:3'], //tags
        '*.is_active' => ['required','in:1,0'], //is_active
    ])->validate();

    foreach ($rows as $row) 
    {
        if($row->filter()->isNotEmpty()) {
            $latest = Merchant_branch::orderBy('id', 'DESC')->first();
            $accountNumber = 'MB' . str_pad(($latest ? $latest->id : 0) + 1, 8, "0", STR_PAD_LEFT);

            $merchantBranchInsert = Merchant_branch::create([
                'merchant_id' => $this->merchant['id'],
                'account_number' => $accountNumber,
                'name' => $row['branch_name'],
                'contact_number' => $row['contact_number'],
                'email' => $row['email'],
                'password' => bcrypt($row['password']),
                'longitude' => $row['longitude'],
                'latitude' => $row['latitude'],
                'address_line' => $row['address_line'],
                'preferred_merchant' => $row['preferred_merchant'],
                'mdr' => $row['mdr'],
                'mdr_type' => $row['mdr_type'],
                'tags' => $row['tags'],
                'is_active' => $row['is_active']
            ]);

            $branchHours = [];
            for ($i = 1; $i <= 7; $i++) {
                $branchHours = [
                    'merchant_branch_id'=>$merchantBranchInsert->id,
                    'day'=>$i,
                    'open'=>'10:00:00',
                    'close'=>'19:00:00'
                ];
                Merchant_branch_hours::create($branchHours);
            }
        }
        
    }

    Session::put('merchantBranchId', $merchantBranchInsert->id);
    return $merchantBranchInsert;
}

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

}

==================
SHEET 2 IMPORT CLASS (this is where validation fails)

class MerchantBranchSectionImport implements ToCollection, WithHeadingRow, SkipsEmptyRows
{
/**
* @param Collection $collection
/
public function collection(Collection $rows)
{
Validator::make($rows->toArray(), [
'.section_name' => ['required','string', 'min:3'], //this is where validation fails
'.description' => ['required','string', 'min:3'],
'.order' => ['required','integer'],
'.tags' => ['required','string', 'min:3'],
'.is_active' => ['required','in:1,0']
])->validate();

    foreach ($rows as $row) 
    {
        if($row->filter()->isNotEmpty()) {
            $merchantBranchSectionInsert = Merchant_branch_section::create([
                'merchant_branch_id' => Session::get('merchantBranchId'),
                'name' => $row['section_name'],
                'description' => $row['description'],
                'tags' => $row['tags'],
                'order' => $row['order'],
                'is_active' => $row['is_active']
            ]);
        }
    }

    Session::put('merchantBranchSectionId', $merchantBranchSectionInsert->id);
    return $merchantBranchSectionInsert;
}

}