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/ReadChunk.php (3858B)

<?php

namespace Maatwebsite\Excel\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithCustomValueBinder;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\ImportFailed;
use Maatwebsite\Excel\Files\TemporaryFile;
use Maatwebsite\Excel\Filters\ChunkReadFilter;
use Maatwebsite\Excel\HasEventBus;
use Maatwebsite\Excel\Imports\HeadingRowExtractor;
use Maatwebsite\Excel\Sheet;
use Maatwebsite\Excel\Transactions\TransactionHandler;
use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Reader\IReader;
use Throwable;

class ReadChunk implements ShouldQueue
{
    use Queueable, HasEventBus;

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

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

/**
     * @var WithChunkReading
     */
    private $import;

/**
     * @var IReader
     */
    private $reader;

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

/**
     * @var string
     */
    private $sheetName;

/**
     * @var object
     */
    private $sheetImport;

/**
     * @var int
     */
    private $startRow;

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

/**
     * @param  WithChunkReading  $import
     * @param  IReader  $reader
     * @param  TemporaryFile  $temporaryFile
     * @param  string  $sheetName
     * @param  object  $sheetImport
     * @param  int  $startRow
     * @param  int  $chunkSize
     */
    public function __construct(WithChunkReading $import, IReader $reader, TemporaryFile $temporaryFile, string $sheetName, $sheetImport, int $startRow, int $chunkSize)
    {
        $this->import        = $import;
        $this->reader        = $reader;
        $this->temporaryFile = $temporaryFile;
        $this->sheetName     = $sheetName;
        $this->sheetImport   = $sheetImport;
        $this->startRow      = $startRow;
        $this->chunkSize     = $chunkSize;
        $this->timeout       = $import->timeout ?? null;
        $this->tries         = $import->tries ?? null;
    }

/**
     * @param  TransactionHandler  $transaction
     *
     * @throws \Maatwebsite\Excel\Exceptions\SheetNotFoundException
     * @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
     */
    public function handle(TransactionHandler $transaction)
    {
        if ($this->sheetImport instanceof WithCustomValueBinder) {
            Cell::setValueBinder($this->sheetImport);
        }

$headingRow = HeadingRowExtractor::headingRow($this->sheetImport);

$filter = new ChunkReadFilter(
            $headingRow,
            $this->startRow,
            $this->chunkSize,
            $this->sheetName
        );

$this->reader->setReadFilter($filter);
        $this->reader->setReadDataOnly(true);
        $this->reader->setReadEmptyCells(false);

$spreadsheet = $this->reader->load(
            $this->temporaryFile->sync()->getLocalPath()
        );

$sheet = Sheet::byName(
            $spreadsheet,
            $this->sheetName
        );

if ($sheet->getHighestRow() < $this->startRow) {
            $sheet->disconnect();

return;
        }

$transaction(function () use ($sheet) {
            $sheet->import(
                $this->sheetImport,
                $this->startRow
            );

$sheet->disconnect();
        });
    }

/**
     * @param  Throwable  $e
     */
    public function failed(Throwable $e)
    {
        if ($this->import instanceof WithEvents) {
            $this->registerListeners($this->import->registerEvents());
            $this->raise(new ImportFailed($e));

if (method_exists($this->import, 'failed')) {
                $this->import->failed($e);
            }
        }
    }
}

import = $import; $this->reader = $reader; $this->temporaryFile = $temporaryFile; $this->sheetName = $sheetName; $this->sheetImport = $sheetImport; $this->startRow = $startRow; $this->chunkSize = $chunkSize; $this->timeout = $import->timeout ?? null; $this->tries = $import->tries ?? null; } /** * @param TransactionHandler $transaction * * @throws \Maatwebsite\Excel\Exceptions\SheetNotFoundException * @throws \PhpOffice\PhpSpreadsheet\Reader\Exception */ public function handle(TransactionHandler $transaction) { if ($this->sheetImport instanceof WithCustomValueBinder) { Cell::setValueBinder($this->sheetImport); } $headingRow = HeadingRowExtractor::headingRow($this->sheetImport); $filter = new ChunkReadFilter( $headingRow, $this->startRow, $this->chunkSize, $this->sheetName ); $this->reader->setReadFilter($filter); $this->reader->setReadDataOnly(true); $this->reader->setReadEmptyCells(false); $spreadsheet = $this->reader->load( $this->temporaryFile->sync()->getLocalPath() ); $sheet = Sheet::byName( $spreadsheet, $this->sheetName ); if ($sheet->getHighestRow() < $this->startRow) { $sheet->disconnect(); return; } $transaction(function () use ($sheet) { $sheet->import( $this->sheetImport, $this->startRow ); $sheet->disconnect(); }); } /** * @param Throwable $e */ public function failed(Throwable $e) { if ($this->import instanceof WithEvents) { $this->registerListeners($this->import->registerEvents()); $this->raise(new ImportFailed($e)); if (method_exists($this->import, 'failed')) { $this->import->failed($e); } } } }