FM / Jobs

/home/techb158/dev.balacoffee.com/vendor/maatwebsite/excel/src/Jobs/

/home/techb158/dev.balacoffee.com/vendor/maatwebsite/excel/src/Jobs

Name	Size	Mode	Actions
Middleware/	-	0755	rm
AfterImportJob.php	2317	0644	edit dl rm
AppendDataToSheet.php	2176	0644	edit dl rm
AppendPaginatedToSheet.php	3022	0644	edit dl rm
AppendQueryToSheet.php	2520	0644	edit dl rm
AppendViewToSheet.php	2117	0644	edit dl rm
CloseSheet.php	1738	0644	edit dl rm
ExtendedQueueable.php	507	0644	edit dl rm
ProxyFailures.php	293	0644	edit dl rm
QueueExport.php	2254	0644	edit dl rm
QueueImport.php	642	0644	edit dl rm
ReadChunk.php	6618	0644	edit dl rm
StoreQueuedExport.php	1301	0644	edit dl rm

Edit: /home/techb158/dev.balacoffee.com/vendor/maatwebsite/excel/src/Jobs/AppendPaginatedToSheet.php (3022B)

<?php

namespace Maatwebsite\Excel\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Database\Eloquent\Builder as EloquentBuilder;
use Illuminate\Database\Eloquent\Relations\Relation;
use Illuminate\Database\Query\Builder;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Laravel\Scout\Builder as ScoutBuilder;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Files\TemporaryFile;
use Maatwebsite\Excel\Jobs\Middleware\LocalizeJob;
use Maatwebsite\Excel\Writer;

class AppendPaginatedToSheet implements ShouldQueue
{
    use Queueable, Dispatchable, ProxyFailures, InteractsWithQueue;

/**
     * @var TemporaryFile
     */
    public $temporaryFile;

/**
     * @var string
     */
    public $writerType;

/**
     * @var int
     */
    public $sheetIndex;

/**
     * @var FromQuery
     */
    public $sheetExport;

/**
     * @var int
     */
    public $page;

/**
     * @var int
     */
    public $perPage;

/**
     * @param  FromQuery  $sheetExport
     * @param  TemporaryFile  $temporaryFile
     * @param  string  $writerType
     * @param  int  $sheetIndex
     * @param  int  $page
     * @param  int  $perPage
     */
    public function __construct(
        FromQuery $sheetExport,
        TemporaryFile $temporaryFile,
        string $writerType,
        int $sheetIndex,
        int $page,
        int $perPage
    ) {
        $this->sheetExport   = $sheetExport;
        $this->temporaryFile = $temporaryFile;
        $this->writerType    = $writerType;
        $this->sheetIndex    = $sheetIndex;
        $this->page          = $page;
        $this->perPage       = $perPage;
    }

/**
     * Get the middleware the job should be dispatched through.
     *
     * @return array
     */
    public function middleware()
    {
        return (method_exists($this->sheetExport, 'middleware')) ? $this->sheetExport->middleware() : [];
    }

/**
     * @param  Writer  $writer
     *
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
     */
    public function handle(Writer $writer)
    {
        (new LocalizeJob($this->sheetExport))->handle($this, function () use ($writer) {
            $writer = $writer->reopen($this->temporaryFile, $this->writerType);

$sheet = $writer->getSheetByIndex($this->sheetIndex);

$sheet->appendRows($this->chunk($this->sheetExport->query()), $this->sheetExport);

$writer->write($this->sheetExport, $this->temporaryFile, $this->writerType);
        });
    }

/**
     * @param  Builder|Relation|EloquentBuilder|ScoutBuilder  $query
     */
    protected function chunk($query)
    {
        if ($query instanceof \Laravel\Scout\Builder) {
            return $query->paginate($this->perPage, 'page', $this->page)->items();
        }

// Fallback
        return $query->forPage($this->page, $this->perPage)->get();
    }
}

cmd: