[Bug]: Error with queued exports when filesystems are different

[adamgoucher]

Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before?

• Yes, it's still reproducable

What version of Laravel Excel are you using?

3.1.50

What version of Laravel are you using?

10.32.1

What version of PHP are you using?

8.2

Describe your issue

#3863 which was fixed in #3876 deals with Imports. I am experiencing the equivalent of it with exporting.

We're changing some infrastructure around and so running a mixed environment with the report job gets picked up on one box (aws linux 2), but actually dealt with on another (ubuntu) and thus have different filesystems.

How can the issue be reproduced?

Using 2 different boxes...

• create a queued report on box a
• have box b actually execute the report

What should be the expected behaviour?

The path it tries to write to on box b is the path it stored in the queued job payload on box a, which isn't necessarily the correct thing.

[axyr]

For the time being, when this fixed is not yet merged, I made an EventListener to ensure the temporary path exists:

<?php

namespace App\Shared\Excel;

use Illuminate\Queue\Events\JobProcessing;
use Illuminate\Support\Arr;
use Maatwebsite\Excel\Files\RemoteTemporaryFile;
use Maatwebsite\Excel\Files\TemporaryFile;
use Maatwebsite\Excel\Files\TemporaryFileFactory;
use Maatwebsite\Excel\Jobs\QueueExport;
use ReflectionObject;

// EventServiceProvider:
// \Illuminate\Queue\Events\JobProcessing::class => [
//      EnsureExcelTemporaryFileExists::class,
// ],

class EnsureExcelTemporaryFileExists
{
    public function handle(JobProcessing $jobProcessing): void
    {
        if ($export = $this->getQueueExport($jobProcessing)) {

            $temporaryFile = $this->getTemporaryFile($export);

            $this->ensureTemporaryFileExists($temporaryFile);
        }
    }

    private function getQueueExport(JobProcessing $jobProcessing): ?QueueExport
    {
        $payload = $jobProcessing->job->payload();

        if ($payload['data']['commandName'] === QueueExport::class) {
            return unserialize($payload['data']['command'], [QueueExport::class]);
        }

        return null;
    }

    private function getTemporaryFile(QueueExport $export): TemporaryFile
    {
        return (new ReflectionObject($export))
            ->getProperty('temporaryFile')
            ->getValue($export);
    }

    private function ensureTemporaryFileExists(TemporaryFile $temporaryFile): void
    {
        if ($temporaryFile instanceof RemoteTemporaryFile && !$temporaryFile->existsLocally()) {
            resolve(TemporaryFileFactory::class)
                ->makeLocal(Arr::last(explode('/', $temporaryFile->getLocalPath())));
        }
    }
}

[patrickbrouwers]

It is merged right?

[axyr]

Maybe I am a bit noob when it comes to tagging, but when using "maatwebsite/excel": "^3.1" it is pulling 3.1.50, but this change is not there, so I assume it on the feature branch, but not on the latest tag?

[patrickbrouwers]

https://github.com/SpartnerNL/Laravel-Excel/releases/tag/3.1.51