FM / Imports

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

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

Name	Size	Mode	Actions
EndRowFinder.php	677	0644	edit dl rm
HeadingRowExtractor.php	1722	0644	edit dl rm
HeadingRowFormatter.php	2277	0644	edit dl rm
ModelImporter.php	2115	0644	edit dl rm
ModelManager.php	4748	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/vendor/maatwebsite/excel/src/Imports/ModelImporter.php (2115B)

<?php

namespace Maatwebsite\Excel\Imports;

use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithBatchInserts;
use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithProgressBar;
use Maatwebsite\Excel\Row;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class ModelImporter
{
    /**
     * @var ModelManager
     */
    private $manager;

/**
     * @param ModelManager $manager
     */
    public function __construct(ModelManager $manager)
    {
        $this->manager = $manager;
    }

/**
     * @param Worksheet $worksheet
     * @param ToModel   $import
     * @param int|null  $startRow
     */
    public function import(Worksheet $worksheet, ToModel $import, int $startRow = 1)
    {
        $headingRow       = HeadingRowExtractor::extract($worksheet, $import);
        $batchSize        = $import instanceof WithBatchInserts ? $import->batchSize() : 1;
        $endRow           = EndRowFinder::find($import, $startRow);
        $progessBar       = $import instanceof WithProgressBar;
        $withMapping      = $import instanceof WithMapping;
        $withCalcFormulas = $import instanceof WithCalculatedFormulas;

$i = 0;
        foreach ($worksheet->getRowIterator($startRow, $endRow) as $spreadSheetRow) {
            $i++;

$row      = new Row($spreadSheetRow, $headingRow);
            $rowArray = $row->toArray(null, $withCalcFormulas);

if ($withMapping) {
                $rowArray = $import->map($rowArray);
            }

$this->manager->add(
                $row->getIndex(),
                $rowArray
            );

// Flush each batch.
            if (($i % $batchSize) === 0) {
                $this->manager->flush($import, $batchSize > 1);
                $i = 0;

if ($progessBar) {
                    $import->getConsoleOutput()->progressAdvance($batchSize);
                }
            }
        }

// Flush left-overs.
        $this->manager->flush($import, $batchSize > 1);
    }
}

manager = $manager; } /** * @param Worksheet $worksheet * @param ToModel $import * @param int|null $startRow */ public function import(Worksheet $worksheet, ToModel $import, int $startRow = 1) { $headingRow = HeadingRowExtractor::extract($worksheet, $import); $batchSize = $import instanceof WithBatchInserts ? $import->batchSize() : 1; $endRow = EndRowFinder::find($import, $startRow); $progessBar = $import instanceof WithProgressBar; $withMapping = $import instanceof WithMapping; $withCalcFormulas = $import instanceof WithCalculatedFormulas; $i = 0; foreach ($worksheet->getRowIterator($startRow, $endRow) as $spreadSheetRow) { $i++; $row = new Row($spreadSheetRow, $headingRow); $rowArray = $row->toArray(null, $withCalcFormulas); if ($withMapping) { $rowArray = $import->map($rowArray); } $this->manager->add( $row->getIndex(), $rowArray ); // Flush each batch. if (($i % $batchSize) === 0) { $this->manager->flush($import, $batchSize > 1); $i = 0; if ($progessBar) { $import->getConsoleOutput()->progressAdvance($batchSize); } } } // Flush left-overs. $this->manager->flush($import, $batchSize > 1); } }