File Manager

X7ROOT File Manager

Current Path: /home/gfecatvj/sites/restate/vendor/maatwebsite/excel/src/Jobs

home / gfecatvj / sites / restate / vendor / maatwebsite / excel / src / Jobs /

📁 ..
📄 AfterImportJob.php(1.29 KB)
📄 AppendDataToSheet.php(1.92 KB)
📄 AppendQueryToSheet.php(2.27 KB)
📄 AppendViewToSheet.php(1.86 KB)
📄 CloseSheet.php(1.71 KB)
📄 ExtendedQueueable.php(402 B)
📄 ProxyFailures.php(291 B)
📄 QueueExport.php(1.8 KB)
📄 QueueImport.php(640 B)
📄 ReadChunk.php(3.77 KB)
📄 StoreQueuedExport.php(1.27 KB)

Editing: AppendQueryToSheet.php

<?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);
    }
}

X7ROOT File Manager

Editing: AppendQueryToSheet.php

Upload File

Create Folder