ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / membrubackend / vendor / maatwebsite / excel / src /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	89.40.16.97
System	Linux server.atelieruldeit.ro 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64
User	tbf
PHP Version	7.3.33
Software	Apache
Doc root	Writable

Edit File : MappedReader.php \| Size : 1.35 KB
<?php namespace Maatwebsite\Excel; use Illuminate\Support\Collection; use Maatwebsite\Excel\Concerns\ToArray; use Maatwebsite\Excel\Concerns\ToCollection; use Maatwebsite\Excel\Concerns\ToModel; use Maatwebsite\Excel\Concerns\WithCalculatedFormulas; use Maatwebsite\Excel\Concerns\WithFormatData; use Maatwebsite\Excel\Concerns\WithMappedCells; use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet; class MappedReader { /** * @param WithMappedCells $import * @param Worksheet $worksheet * * @throws \PhpOffice\PhpSpreadsheet\Exception */ public function map(WithMappedCells $import, Worksheet $worksheet) { $mapped = []; foreach ($import->mapping() as $name => $coordinate) { $cell = Cell::make($worksheet, $coordinate); $mapped[$name] = $cell->getValue( null, $import instanceof WithCalculatedFormulas, $import instanceof WithFormatData ); } if ($import instanceof ToModel) { $model = $import->model($mapped); if ($model) { $model->saveOrFail(); } } if ($import instanceof ToCollection) { $import->collection(new Collection($mapped)); } if ($import instanceof ToArray) { $import->array($mapped); } } } Back

Edit File : MappedReader.php | Size : 1.35 KB

<?php

namespace Maatwebsite\Excel;

use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToArray;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;
use Maatwebsite\Excel\Concerns\WithFormatData;
use Maatwebsite\Excel\Concerns\WithMappedCells;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class MappedReader
{
    /**
     * @param WithMappedCells $import
     * @param Worksheet       $worksheet
     *
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    public function map(WithMappedCells $import, Worksheet $worksheet)
    {
        $mapped = [];
        foreach ($import->mapping() as $name => $coordinate) {
            $cell = Cell::make($worksheet, $coordinate);

$mapped[$name] = $cell->getValue(
                null,
                $import instanceof WithCalculatedFormulas,
                $import instanceof WithFormatData
            );
        }

if ($import instanceof ToModel) {
            $model = $import->model($mapped);

if ($model) {
                $model->saveOrFail();
            }
        }

if ($import instanceof ToCollection) {
            $import->collection(new Collection($mapped));
        }

if ($import instanceof ToArray) {
            $import->array($mapped);
        }
    }
}

Back