FM / Jobs

/home/techb158/ileadtechnology.com/SSM/vendor/maatwebsite/excel/src/Jobs/

/home/techb158/ileadtechnology.com/SSM/vendor/maatwebsite/excel/src/Jobs

Name	Size	Mode	Actions
AfterImportJob.php	1318	0644	edit dl rm
AppendDataToSheet.php	1967	0644	edit dl rm
AppendQueryToSheet.php	2326	0644	edit dl rm
AppendViewToSheet.php	1908	0644	edit dl rm
CloseSheet.php	1752	0644	edit dl rm
ExtendedQueueable.php	402	0644	edit dl rm
ProxyFailures.php	291	0644	edit dl rm
QueueExport.php	1848	0644	edit dl rm
QueueImport.php	640	0644	edit dl rm
ReadChunk.php	3858	0644	edit dl rm
StoreQueuedExport.php	1301	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/vendor/maatwebsite/excel/src/Jobs/AppendQueryToSheet.php (2326B)

<?php

namespace Maatwebsite\Excel\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Files\TemporaryFile;
use Maatwebsite\Excel\Writer;

class AppendQueryToSheet implements ShouldQueue
{
    use Queueable, Dispatchable, ProxyFailures;

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

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

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

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

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

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

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

/**
     * 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)
    {
        $writer = $writer->reopen($this->temporaryFile, $this->writerType);

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

$query = $this->sheetExport->query()->forPage($this->page, $this->chunkSize);

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

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

sheetExport = $sheetExport; $this->temporaryFile = $temporaryFile; $this->writerType = $writerType; $this->sheetIndex = $sheetIndex; $this->page = $page; $this->chunkSize = $chunkSize; } /** * 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) { $writer = $writer->reopen($this->temporaryFile, $this->writerType); $sheet = $writer->getSheetByIndex($this->sheetIndex); $query = $this->sheetExport->query()->forPage($this->page, $this->chunkSize); $sheet->appendRows($query->get(), $this->sheetExport); $writer->write($this->sheetExport, $this->temporaryFile, $this->writerType); } }