laravel Excel Import give user error in header file

[RabieAli95]

I have some headings at the beginning of the excel file I need if the user changes these headings throw an error to him!

my code right now (I'm using a queue to import)

class UpdateProducts implements
    ToCollection,
    WithHeadingRow,
    WithValidation,
    WithChunkReading,
    ShouldQueue,
    WithEvents,
    SkipsEmptyRows
{
    use Importable, RegistersEventListeners;

    public $merchant;

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

    public function collection(Collection $rows)
    {
        foreach ($rows as $row) {
            Product::query()
                ->where('id', $row['id'])
                ->update([
                    'trade_name'            => $row['trade_name'],
                    'price'                 => $row['price'],
                    'quantity'              => $row['quantity'],
                    'expired_date'          => $row['expired_date'] ?? null,
                ]);
        }
    }

    public function rules(): array
    {
        return [
            'id' => Rule::in(['id']),
            'trade_name' => Rule::in(['trade_name']),
            'price' => Rule::in(['price']),
            'quantity' => Rule::in(['quantity']),
            'expired_date' => Rule::in(['expired_date']),

            '*.id' => 'required',
            '*.trade_name' => ['required', 'string'],
            '*.price' => [
                'required',
                'numeric',
                'regex:/^(?=.+)(?:[1-9]\d*|0)?(?:\.\d+)?$/'
            ],
            '*.quantity' => ['required'],
            '*.expired_date' => ['nullable'],
        ];
    }

    public function customValidationAttributes()
    {
        return [
            'id'                => 'ID',
            'trade_name'        => 'Trade Name',
            'price'             => 'Price',
            'quantity'          => 'Quantity',
            'expired_date'      => 'Expired Date',
        ];
    }

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

    public function registerEvents(): array
    {
        return [
            ImportFailed::class => function (ImportFailed $errorsValidation) {
                $errors = $errorsValidation->getException()->errors();
                Mail::to($this->merchant->email)->send(new ImportedFailureMail($errors, $this->merchant->name));
            }
        ];
    }
}

In registerEvents I just send an email to merchant validation errors! but when I change and heading the queue failed without giving me any error throw email

[patrickbrouwers]

 'id' => Rule::in(['id']),
            'trade_name' => Rule::in(['trade_name']),
            'price' => Rule::in(['price']),
            'quantity' => Rule::in(['quantity']),
            'expired_date' => Rule::in(['expired_date']),

            '*.id' => 'required',
            '*.trade_name' => ['required', 'string'],
            '*.price' => [
                'required',
                'numeric',
                'regex:/^(?=.+)(?:[1-9]\d*|0)?(?:\.\d+)?$/'
            ],
            '*.quantity' => ['required'],
            '*.expired_date' => ['nullable'],

You have to merge these rules, we automatically prepend *. to the attribute, so it will not pick up all your rules. Use one of the two.

[patrickbrouwers]

Yes

[RabieAli95]

@patrickbrouwers one final question pls! is there any way to lock the headings text like users can not edit the headings?!

[patrickbrouwers]

Have a look here: https://phpspreadsheet.readthedocs.io/en/stable/topics/recipes/#setting-security-on-a-spreadsheet

[RabieAli95]

@patrickbrouwers Thanks, I already have, but I do not know to use it with your pkg! my controller:

(new ExportPorducts())->store($fileName, 's3Public')->chain([
      new NotifyMerchantOfCompleteFileExport(merchant()->email, $filePath)
]);;

[patrickbrouwers]

Inside AfterSheet event probably: https://docs.laravel-excel.com/3.1/exports/extending.html#events