Laravel-excel: [QUESTION] Get current row on rules function using WithValidation trait

[HamzaDevz]

• [x] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [x] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [x] Checked that your question isn't already asked before.
• [x] Filled in the entire issue template

Versions

• PHP version: 7.3
• Laravel version: 7.12.0
• Package version: 3.1.19

Description

My question is simple, is it possible to get the value of the row on validation ?

Thank you by advance.

[patrickbrouwers]

Currently not. You could always do the validation yourself inside the collection/onEachRow/Model method if you need that kind of control.

[HamzaDevz]

Okay thank you, I'm going to do this in the model method, is there a way to find the row index ?

For now I added it with a global variable in my import class

private $startRow;

    public function __construct()
    {
        $this->startRow = 2;
    }
    public function model(array $row)
    {
        $this->startRow++;
    }

[patrickbrouwers]

@HamzaDevz that's for current release the best option yes, however our next release will have a trait that does this for you automatically.

[HamzaDevz]

Sorry again @patrickbrouwers is it the proper way to add manually a failure ?
Here is what I did :

public function model(array $row)
{
        $this->startRow++;
        $purchaseRequestProduct = $this->purchaseRequest->purchaseRequestProducts()->whereSku($row['ean'])->first();

        if (!isset($purchaseRequestProduct))
        {
            $this->failures[] = new Failure($this->startRow, 'ean', [ 'This product does not exist.' ], $row);
            return;
        }
}

Thank you.

[patrickbrouwers]

I think so yes