Import Multiple Sheets with validation using ToCollection

[chammeow]

I have a multiple sheets (different import class each) that inserts in different table that needs validation.

I need to failed the overall import when a sheet validation failed.

Currently my code is insert the sheets with success validation and stop when a sheet validation failed.

Here is my code.

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

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

}

Class MerchantBranchImport implements ToCollection, WithHeadingRow, SkipsEmptyRows
{
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
        ...
    ])->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,
                ...
            ]);
        }
        
    }

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

}

Class MerchantBranchSectionImport implements ToCollection, WithHeadingRow, SkipsEmptyRows
{
/**
* @param Collection $collection
/
public function collection(Collection $rows)
{
Validator::make($rows->toArray(), [
'.section_name' => ['required','string', 'min:3'],
'.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;
}

}

AND HERE IS THE 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()]);
    }

}