Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php namespace Maatwebsite\Excel;use Closure;use Illuminate\Contracts\Support\Arrayable;u..
Decoded Output download
<?php namespace Maatwebsite\Excel;use Closure;use Illuminate\Contracts\Support\Arrayable;use Illuminate\Support\Collection;use Illuminate\Support\LazyCollection;use Maatwebsite\Excel\Concerns\FromArray;use Maatwebsite\Excel\Concerns\FromCollection;use Maatwebsite\Excel\Concerns\FromGenerator;use Maatwebsite\Excel\Concerns\FromIterator;use Maatwebsite\Excel\Concerns\FromQuery;use Maatwebsite\Excel\Concerns\FromView;use Maatwebsite\Excel\Concerns\OnEachRow;use Maatwebsite\Excel\Concerns\ShouldAutoSize;use Maatwebsite\Excel\Concerns\SkipsEmptyRows;use Maatwebsite\Excel\Concerns\ToArray;use Maatwebsite\Excel\Concerns\ToCollection;use Maatwebsite\Excel\Concerns\ToModel;use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;use Maatwebsite\Excel\Concerns\WithCharts;use Maatwebsite\Excel\Concerns\WithChunkReading;use Maatwebsite\Excel\Concerns\WithColumnFormatting;use Maatwebsite\Excel\Concerns\WithColumnLimit;use Maatwebsite\Excel\Concerns\WithColumnWidths;use Maatwebsite\Excel\Concerns\WithCustomChunkSize;use Maatwebsite\Excel\Concerns\WithCustomStartCell;use Maatwebsite\Excel\Concerns\WithCustomValueBinder;use Maatwebsite\Excel\Concerns\WithDrawings;use Maatwebsite\Excel\Concerns\WithEvents;use Maatwebsite\Excel\Concerns\WithFormatData;use Maatwebsite\Excel\Concerns\WithHeadings;use Maatwebsite\Excel\Concerns\WithMappedCells;use Maatwebsite\Excel\Concerns\WithMapping;use Maatwebsite\Excel\Concerns\WithProgressBar;use Maatwebsite\Excel\Concerns\WithStrictNullComparison;use Maatwebsite\Excel\Concerns\WithStyles;use Maatwebsite\Excel\Concerns\WithTitle;use Maatwebsite\Excel\Concerns\WithValidation;use Maatwebsite\Excel\Events\AfterSheet;use Maatwebsite\Excel\Events\BeforeSheet;use Maatwebsite\Excel\Exceptions\ConcernConflictException;use Maatwebsite\Excel\Exceptions\RowSkippedException;use Maatwebsite\Excel\Exceptions\SheetNotFoundException;use Maatwebsite\Excel\Files\TemporaryFileFactory;use Maatwebsite\Excel\Helpers\ArrayHelper;use Maatwebsite\Excel\Helpers\CellHelper;use Maatwebsite\Excel\Imports\EndRowFinder;use Maatwebsite\Excel\Imports\HeadingRowExtractor;use Maatwebsite\Excel\Imports\ModelImporter;use Maatwebsite\Excel\Validators\RowValidator;use PhpOffice\PhpSpreadsheet\Cell\Cell as SpreadsheetCell;use PhpOffice\PhpSpreadsheet\Chart\Chart;use PhpOffice\PhpSpreadsheet\IOFactory;use PhpOffice\PhpSpreadsheet\Reader\Html;use PhpOffice\PhpSpreadsheet\Shared\StringHelper;use PhpOffice\PhpSpreadsheet\Spreadsheet;use PhpOffice\PhpSpreadsheet\Worksheet\BaseDrawing;use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;/** @mixin Worksheet */ class zxrp29{use DelegatedMacroable,HasEventBus;/**
* @var int
*/ protected $ktiz2a;/**
* @var TemporaryFileFactory
*/ protected $encg2b;/**
* @var object
*/ protected $jrzj2c;/**
* @var Worksheet
*/ private $soxk2d;/**
* @param Worksheet $worksheet
*/ public function gdel0(Worksheet $soxk2d){$this->$kjsn2e=$soxk2d;$this->$jogv2f=whpi30(base64_decode('ZXhjZWwuZXhwb3J0cy5jaHVua19zaXpl'),100);$this->$twxb31=jvej22(TemporaryFileFactory::class);}/**
* @param Spreadsheet $spreadsheet
* @param string|int $index
* @return Sheet
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws SheetNotFoundException
*/ public static function ntos1(Spreadsheet $jemq32,$ussz33){if(is_numeric($ussz33)){return self::rdfg2($jemq32,$ussz33);}return self::bfrt3($jemq32,$ussz33);}/**
* @param Spreadsheet $spreadsheet
* @param int $index
* @return Sheet
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws SheetNotFoundException
*/ public static function rdfg2(Spreadsheet $jemq32,int $ussz33):Sheet{if(!isset($jemq32->fxgw34()[$ussz33])){throw SheetNotFoundException::rdfg2($ussz33,$jemq32->bysk35());}return new static($jemq32->hywj36($ussz33));}/**
* @param Spreadsheet $spreadsheet
* @param string $name
* @return Sheet
*
* @throws SheetNotFoundException
*/ public static function bfrt3(Spreadsheet $jemq32,string $pxtx37):Sheet{if(!$jemq32->qyej38($pxtx37)){throw SheetNotFoundException::bfrt3($pxtx37);}return new static($jemq32->havd39($pxtx37));}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function fwrn4($fwky3a){$this->$ufih3b=$fwky3a;if($fwky3a instanceof WithCustomValueBinder){SpreadsheetCell::bnkl3c($fwky3a);}if($fwky3a instanceof WithEvents){$this->wgdw3d($fwky3a->fqoq3e());}$this->vxyh3f(new uiap40($this,$this->$ufih3b));if($fwky3a instanceof WithTitle){$hsgu41=$fwky3a->uxkd42();$hsgu41=str_replace([base64_decode('Kg=='),base64_decode('Og=='),base64_decode('Lw=='),base64_decode('XFw='),base64_decode('Pw=='),base64_decode('Ww=='),base64_decode('XQ==')],'',$hsgu41);if(StringHelper::doxk43($hsgu41)>Worksheet::SHEET_TITLE_MAXIMUM_LENGTH){$hsgu41=StringHelper::yrov44($hsgu41,0,Worksheet::SHEET_TITLE_MAXIMUM_LENGTH);}$this->$kjsn2e->surc45($hsgu41);}if(($fwky3a instanceof FromQuery||$fwky3a instanceof FromCollection||$fwky3a instanceof FromArray)&&$fwky3a instanceof FromView){throw ConcernConflictException::kstc46();}if(!$fwky3a instanceof FromView&&$fwky3a instanceof WithHeadings){if($fwky3a instanceof WithCustomStartCell){$hvan47=$fwky3a->bljp48();}$this->fuxy15(ArrayHelper::mubp49($fwky3a->vxcw4a()),$hvan47 ?? null,$this->pgib25($fwky3a));}if($fwky3a instanceof WithCharts){$this->czav1a($fwky3a->vrmt4b());}}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
*/ public function qzms5($fwky3a){$this->fwrn4($fwky3a);if($fwky3a instanceof FromView){$this->yodob($fwky3a);}else{if($fwky3a instanceof FromQuery){$this->llgac($fwky3a,$this->$kjsn2e);}if($fwky3a instanceof FromCollection){$this->fcwnf($fwky3a);}if($fwky3a instanceof FromArray){$this->mvdm10($fwky3a);}if($fwky3a instanceof FromIterator){$this->gxqu11($fwky3a);}if($fwky3a instanceof FromGenerator){$this->dnnr13($fwky3a);}}$this->xuqna($fwky3a);}/**
* @param object $import
* @param int $startRow
*/ public function getc6($zxvv4c,int $ikvk4d=1){if($zxvv4c instanceof WithEvents){$this->wgdw3d($zxvv4c->fqoq3e());}$this->vxyh3f(new uiap40($this,$zxvv4c));if($zxvv4c instanceof WithProgressBar&&!$zxvv4c instanceof WithChunkReading){$zxvv4c->gmlu4e()->wzjj4f($this->$kjsn2e->ktcu50());}$lxtz51=$zxvv4c instanceof WithCalculatedFormulas;$pkvc52=$zxvv4c instanceof WithFormatData;if($zxvv4c instanceof WithMappedCells){jvej22(MappedReader::class)->dyjm53($zxvv4c,$this->$kjsn2e);}else{if($zxvv4c instanceof ToModel){jvej22(ModelImporter::class)->getc6($this->$kjsn2e,$zxvv4c,$ikvk4d);}if($zxvv4c instanceof ToCollection){$klvk54=$this->vido8($zxvv4c,$ikvk4d,null,$lxtz51,$pkvc52);if($zxvv4c instanceof WithValidation){$klvk54=$this->tcnr21($zxvv4c,$ikvk4d,$klvk54);}$zxvv4c->txsl55($klvk54);}if($zxvv4c instanceof ToArray){$klvk54=$this->lttv7($zxvv4c,$ikvk4d,null,$lxtz51,$pkvc52);if($zxvv4c instanceof WithValidation){$klvk54=$this->tcnr21($zxvv4c,$ikvk4d,$klvk54);}$zxvv4c->jwxm56($klvk54);}}if($zxvv4c instanceof OnEachRow){$ymqy57=HeadingRowExtractor::extract($this->$kjsn2e,$zxvv4c);$gozj58=HeadingRowExtractor::jlwd59($ymqy57,$zxvv4c);$jykx5a=$zxvv4c instanceof WithColumnLimit?$zxvv4c->rbfp5b():null;$zjlz5c=$this->hxez27($zxvv4c);foreach($this->$kjsn2e->frpe5d()->pqah5e($ikvk4d ?? 1)as $kjkk5f){$eaof60=new uftz61($kjkk5f,$ymqy57,$gozj58);if($zxvv4c instanceof WithValidation){$eaof60->cjrc62($zjlz5c);}$fsbl63=$eaof60->lttv7(null,$zxvv4c instanceof WithCalculatedFormulas,$zxvv4c instanceof WithFormatData,$jykx5a);$kdym64=$zxvv4c instanceof SkipsEmptyRows&&method_exists($zxvv4c,base64_decode('aXNFbXB0eVdoZW4='))&&$zxvv4c->zarb65($fsbl63);if(!$zxvv4c instanceof SkipsEmptyRows||($zxvv4c instanceof SkipsEmptyRows&&(!$kdym64&&!$eaof60->kzkg66($lxtz51)))){if($zxvv4c instanceof WithValidation){$jyye67=[$eaof60->klyz68()=>$fsbl63];try{jvej22(RowValidator::class)->ijvg69($jyye67,$zxvv4c);$zxvv4c->velg6a($eaof60);}catch(RowSkippedException $lmnh6b){}}else{$zxvv4c->velg6a($eaof60);}}if($zxvv4c instanceof WithProgressBar){$zxvv4c->gmlu4e()->csmd6c();}}}$this->vxyh3f(new dwsw6d($this,$zxvv4c));if($zxvv4c instanceof WithProgressBar&&!$zxvv4c instanceof WithChunkReading){$zxvv4c->gmlu4e()->mibz6e();}}/**
* @param object $import
* @param int|null $startRow
* @param null $nullValue
* @param bool $calculateFormulas
* @param bool $formatData
* @return array
*/ public function lttv7($zxvv4c,int $ikvk4d=null,$fshq6f=null,$sbun70=false,$pkvc52=false){if($ikvk4d>$this->$kjsn2e->ktcu50()){return[];}$wkhg71=EndRowFinder::cdhr72($zxvv4c,$ikvk4d,$this->$kjsn2e->ktcu50());$ymqy57=HeadingRowExtractor::extract($this->$kjsn2e,$zxvv4c);$gozj58=HeadingRowExtractor::jlwd59($ymqy57,$zxvv4c);$jykx5a=$zxvv4c instanceof WithColumnLimit?$zxvv4c->rbfp5b():null;$klvk54=[];foreach($this->$kjsn2e->frpe5d($ikvk4d,$wkhg71)as $ussz33=>$kjkk5f){$kjkk5f=new uftz61($kjkk5f,$ymqy57,$gozj58);if($zxvv4c instanceof SkipsEmptyRows&&$kjkk5f->kzkg66($sbun70,$jykx5a)){continue;}$kjkk5f=$kjkk5f->lttv7($fshq6f,$sbun70,$pkvc52,$jykx5a);if($zxvv4c&&method_exists($zxvv4c,base64_decode('aXNFbXB0eVdoZW4='))&&$zxvv4c->zarb65($kjkk5f)){continue;}if($zxvv4c instanceof WithMapping){$kjkk5f=$zxvv4c->dyjm53($kjkk5f);}if($zxvv4c instanceof WithValidation&&method_exists($zxvv4c,base64_decode('cHJlcGFyZUZvclZhbGlkYXRpb24='))){$kjkk5f=$zxvv4c->pjmp73($kjkk5f,$ussz33);}$klvk54[]=$kjkk5f;if($zxvv4c instanceof WithProgressBar){$zxvv4c->gmlu4e()->csmd6c();}}return $klvk54;}/**
* @param object $import
* @param int|null $startRow
* @param null $nullValue
* @param bool $calculateFormulas
* @param bool $formatData
* @return Collection
*/ public function vido8($zxvv4c,int $ikvk4d=null,$fshq6f=null,$sbun70=false,$pkvc52=false):Collection{$klvk54=$this->lttv7($zxvv4c,$ikvk4d,$fshq6f,$sbun70,$pkvc52);return new yman9(array_map(function(array$kjkk5f){return new yman9($kjkk5f);},$klvk54));}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function xuqna($fwky3a){if($fwky3a instanceof WithDrawings){$this->orlq1b($fwky3a->zlcs74());}$this->$ufih3b=$fwky3a;if($fwky3a instanceof WithColumnFormatting){foreach($fwky3a->dhpn75()as $ldpy76=>$fmxm77){$this->dkka17($ldpy76,$fmxm77);}}if($fwky3a instanceof ShouldAutoSize){$this->xhzl16();}if($fwky3a instanceof WithColumnWidths){foreach($fwky3a->gyru78()as $ldpy76=>$waym79){$this->$kjsn2e->foww7a($ldpy76)->dvxk7b(false)->laqh7c($waym79);}}if($fwky3a instanceof WithStyles){$xqhl7d=$fwky3a->hngj7e($this->$kjsn2e);if(is_array($xqhl7d)){foreach($xqhl7d as $edzn7f=>$vjrt80){if(is_numeric($edzn7f)){$edzn7f=base64_decode('QQ==').$edzn7f.base64_decode('Og==').$this->$kjsn2e->ebwi81($edzn7f).$edzn7f;}$this->$kjsn2e->qzzk82($edzn7f)->vskt83($vjrt80);}}}$this->vxyh3f(new dwsw6d($this,$this->$ufih3b));$this->nlpm84();}/**
* @param FromView $sheetExport
* @param int|null $sheetIndex
*
* @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
*/ public function yodob(FromView $fwky3a,$fqye85=null){$pphk86=$this->$twxb31->oyfj87(null,base64_decode('aHRtbA=='));$pphk86->vavx88($fwky3a->xktd89()->tszv8a());$jemq32=$this->$kjsn2e->dgtq8b();/** @var Html $reader */ $gnvm8c=IOFactory::zwsp8d(base64_decode('SHRtbA=='));$gnvm8c->tfds8e($fqye85 ?? $jemq32->bysk35()-1);$gnvm8c->rpvn8f($pphk86->nrpw90(),$jemq32);$pphk86->iakr91();}/**
* @param FromQuery $sheetExport
* @param Worksheet $worksheet
*/ public function llgac(FromQuery $fwky3a,Worksheet $soxk2d){if($fwky3a->oirl92()instanceof \Laravel\Scout\Builder){$this->ksabe($fwky3a,$soxk2d);return;}$fwky3a->oirl92()->icxj93($this->xrod26($fwky3a),function($iocv94)use($fwky3a){$this->bvwxd($iocv94,$fwky3a);});}/**
* @param FromQuery $sheetExport
* @param Worksheet $worksheet
*/ public function ksabe(FromQuery $fwky3a,Worksheet $soxk2d){$dwzk95=$fwky3a->oirl92();$ktiz2a=$this->xrod26($fwky3a);$iocv94=$dwzk95->pmke96($ktiz2a);$this->bvwxd($iocv94->fxmf97(),$fwky3a);for($bfuj98=2;$bfuj98<=$iocv94->fxds99();$bfuj98++){$this->bvwxd($dwzk95->pmke96($ktiz2a,base64_decode('cGFnZQ=='),$bfuj98)->fxmf97(),$fwky3a);}}/**
* @param FromCollection $sheetExport
*/ public function fcwnf(FromCollection $fwky3a){$this->bvwxd($fwky3a->txsl55()->ovez9a(),$fwky3a);}/**
* @param FromArray $sheetExport
*/ public function mvdm10(FromArray $fwky3a){$this->bvwxd($fwky3a->jwxm56(),$fwky3a);}/**
* @param FromIterator $sheetExport
*/ public function gxqu11(FromIterator $fwky3a){$igns9b=class_exists(LazyCollection::class)?new smpw9c(function()use($fwky3a){foreach($fwky3a->tpoj12()as $kjkk5f){yield $kjkk5f;}}):$fwky3a->tpoj12();$this->bvwxd($igns9b,$fwky3a);}/**
* @param FromGenerator $sheetExport
*/ public function dnnr13(FromGenerator $fwky3a){$kmzd9d=class_exists(LazyCollection::class)?new smpw9c(function()use($fwky3a){foreach($fwky3a->nlvg14()as $kjkk5f){yield $kjkk5f;}}):$fwky3a->nlvg14();$this->bvwxd($kmzd9d,$fwky3a);}/**
* @param array $rows
* @param string|null $startCell
* @param bool $strictNullComparison
*/ public function fuxy15(array$klvk54,string $hvan47=null,bool $obur9e=false){if(!$hvan47){$hvan47=base64_decode('QTE=');}if($this->jmxp24()){$hvan47=CellHelper::omep9f($hvan47).($this->$kjsn2e->ktcu50()+1);}$this->$kjsn2e->mvdm10($klvk54,null,$hvan47,$obur9e);}public function xhzl16(){foreach($this->jkva23(base64_decode('QQ=='),$this->$kjsn2e->noqea0())as $dznna1){$pjzla2=$this->$kjsn2e->foww7a($dznna1);if($pjzla2->qrida3()==-1){$pjzla2->dvxk7b(true);}}}/**
* @param string $column
* @param string $format
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function dkka17(string $ldpy76,string $fmxm77){if(stripos($ldpy76,base64_decode('Og=='))!==false){$this->$kjsn2e->qzzk82($ldpy76)->dthia4()->zhnca5($fmxm77);}else{$this->$kjsn2e->qzzk82($ldpy76.base64_decode('MTo=').$ldpy76.$this->$kjsn2e->ktcu50())->dthia4()->zhnca5($fmxm77);}}/**
* @param int $chunkSize
* @return Sheet
*/ public function fwaw18(int $ktiz2a){$this->$jogv2f=$ktiz2a;return $this;}/**
* @return Worksheet
*/ public function ryjt19(){return $this->$kjsn2e;}/**
* @param Chart|Chart[] $charts
*/ public function czav1a($kllwa6){$kllwa6=\is_array($kllwa6)?$kllwa6:[$kllwa6];foreach($kllwa6 as $kffda7){$this->$kjsn2e->yeqha8($kffda7);}}/**
* @param BaseDrawing|BaseDrawing[] $drawings
*/ public function orlq1b($prwfa9){$prwfa9=\is_array($prwfa9)?$prwfa9:[$prwfa9];foreach($prwfa9 as $oavwaa){$oavwaa->qoodab($this->$kjsn2e);}}/**
* @param string $concern
* @return string
*/ public function usjp1c(string $rzumac):string{return $this->$ufih3b instanceof $rzumac;}/**
* @param iterable $rows
* @param object $sheetExport
*/ public function bvwxd($klvk54,$fwky3a){if(method_exists($fwky3a,base64_decode('cHJlcGFyZVJvd3M='))){$klvk54=$fwky3a->uzxcad($klvk54);}$klvk54=$klvk54 instanceof LazyCollection?$klvk54:new yman9($klvk54);$klvk54->wgmdae(function($kjkk5f)use($fwky3a){if($fwky3a instanceof WithMapping){$kjkk5f=$fwky3a->dyjm53($kjkk5f);}if($fwky3a instanceof WithCustomValueBinder){SpreadsheetCell::bnkl3c($fwky3a);}return ArrayHelper::mubp49(static::sjfx1e($kjkk5f));})->icxj93(1000)->oomiaf(function($klvk54)use($fwky3a){$this->fuxy15($klvk54->lttv7(),$fwky3a instanceof WithCustomStartCell?$fwky3a->bljp48():null,$this->pgib25($fwky3a));});}/**
* @param mixed $row
* @return array
*/ public static function sjfx1e($kjkk5f):array{if(is_object($kjkk5f)&&method_exists($kjkk5f,base64_decode('YXR0cmlidXRlc1RvQXJyYXk='))){return $kjkk5f->roqob0();}if($kjkk5f instanceof Arrayable){return $kjkk5f->lttv7();}if(is_object($kjkk5f)){return json_decode(json_encode($kjkk5f),true);}return $kjkk5f;}/**
* @param $sheetImport
* @return int
*/ public function ostr1f($gvcsb1):int{return HeadingRowExtractor::aaolb2($gvcsb1);}/**
* Disconnect the sheet.
*/ public function lvtj20(){$this->$kjsn2e->ecwvb3();unset($this->$kjsn2e);}/**
* @return Collection|array
*/ protected function tcnr21(WithValidation $zxvv4c,int $ikvk4d,$klvk54){$jyye67=(new yman9($klvk54))->thzcb4(function($kjkk5f,$ussz33)use($ikvk4d){return[($ikvk4d+$ussz33)=>$kjkk5f];});try{jvej22(RowValidator::class)->ijvg69($jyye67->lttv7(),$zxvv4c);}catch(RowSkippedException $lmnh6b){foreach($lmnh6b->lrytb5()as $kjkk5f){unset($klvk54[$kjkk5f-$ikvk4d]);}}return $klvk54;}/**
* @param string $lower
* @param string $upper
* @return \Generator
*/ protected function jkva23(string $wvdgb6,string $bhiub7){$bhiub7++;for($qvvnb8=$wvdgb6;$qvvnb8!==$bhiub7;$qvvnb8++){yield $qvvnb8;}}/**
* @return bool
*/ private function jmxp24():bool{$hvan47=base64_decode('QTE=');if($this->$ufih3b instanceof WithCustomStartCell){$hvan47=$this->$ufih3b->bljp48();}return $this->$kjsn2e->dmqsb9($hvan47);}/**
* @param object $sheetExport
* @return bool
*/ private function pgib25($fwky3a):bool{if($fwky3a instanceof WithStrictNullComparison){return true;}return whpi30(base64_decode('ZXhjZWwuZXhwb3J0cy5zdHJpY3RfbnVsbF9jb21wYXJpc29u'),false);}/**
* @param object|WithCustomChunkSize $export
* @return int
*/ private function xrod26($hojhba):int{if($hojhba instanceof WithCustomChunkSize){return $hojhba->fwaw18();}return $this->$jogv2f;}/**
* @param object|WithValidation $import
* @return Closure|null
*/ private function hxez27($zxvv4c){if(!$zxvv4c instanceof WithValidation||!method_exists($zxvv4c,base64_decode('cHJlcGFyZUZvclZhbGlkYXRpb24='))){return null;}return function(array$jnizbb,int $ussz33)use($zxvv4c){return $zxvv4c->pjmp73($jnizbb,$ussz33);};}}?>
Did this file decode correctly?
Original Code
<?php namespace Maatwebsite\Excel;use Closure;use Illuminate\Contracts\Support\Arrayable;use Illuminate\Support\Collection;use Illuminate\Support\LazyCollection;use Maatwebsite\Excel\Concerns\FromArray;use Maatwebsite\Excel\Concerns\FromCollection;use Maatwebsite\Excel\Concerns\FromGenerator;use Maatwebsite\Excel\Concerns\FromIterator;use Maatwebsite\Excel\Concerns\FromQuery;use Maatwebsite\Excel\Concerns\FromView;use Maatwebsite\Excel\Concerns\OnEachRow;use Maatwebsite\Excel\Concerns\ShouldAutoSize;use Maatwebsite\Excel\Concerns\SkipsEmptyRows;use Maatwebsite\Excel\Concerns\ToArray;use Maatwebsite\Excel\Concerns\ToCollection;use Maatwebsite\Excel\Concerns\ToModel;use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;use Maatwebsite\Excel\Concerns\WithCharts;use Maatwebsite\Excel\Concerns\WithChunkReading;use Maatwebsite\Excel\Concerns\WithColumnFormatting;use Maatwebsite\Excel\Concerns\WithColumnLimit;use Maatwebsite\Excel\Concerns\WithColumnWidths;use Maatwebsite\Excel\Concerns\WithCustomChunkSize;use Maatwebsite\Excel\Concerns\WithCustomStartCell;use Maatwebsite\Excel\Concerns\WithCustomValueBinder;use Maatwebsite\Excel\Concerns\WithDrawings;use Maatwebsite\Excel\Concerns\WithEvents;use Maatwebsite\Excel\Concerns\WithFormatData;use Maatwebsite\Excel\Concerns\WithHeadings;use Maatwebsite\Excel\Concerns\WithMappedCells;use Maatwebsite\Excel\Concerns\WithMapping;use Maatwebsite\Excel\Concerns\WithProgressBar;use Maatwebsite\Excel\Concerns\WithStrictNullComparison;use Maatwebsite\Excel\Concerns\WithStyles;use Maatwebsite\Excel\Concerns\WithTitle;use Maatwebsite\Excel\Concerns\WithValidation;use Maatwebsite\Excel\Events\AfterSheet;use Maatwebsite\Excel\Events\BeforeSheet;use Maatwebsite\Excel\Exceptions\ConcernConflictException;use Maatwebsite\Excel\Exceptions\RowSkippedException;use Maatwebsite\Excel\Exceptions\SheetNotFoundException;use Maatwebsite\Excel\Files\TemporaryFileFactory;use Maatwebsite\Excel\Helpers\ArrayHelper;use Maatwebsite\Excel\Helpers\CellHelper;use Maatwebsite\Excel\Imports\EndRowFinder;use Maatwebsite\Excel\Imports\HeadingRowExtractor;use Maatwebsite\Excel\Imports\ModelImporter;use Maatwebsite\Excel\Validators\RowValidator;use PhpOffice\PhpSpreadsheet\Cell\Cell as SpreadsheetCell;use PhpOffice\PhpSpreadsheet\Chart\Chart;use PhpOffice\PhpSpreadsheet\IOFactory;use PhpOffice\PhpSpreadsheet\Reader\Html;use PhpOffice\PhpSpreadsheet\Shared\StringHelper;use PhpOffice\PhpSpreadsheet\Spreadsheet;use PhpOffice\PhpSpreadsheet\Worksheet\BaseDrawing;use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;/** @mixin Worksheet */ class zxrp29{use DelegatedMacroable,HasEventBus;/**
* @var int
*/ protected $ktiz2a;/**
* @var TemporaryFileFactory
*/ protected $encg2b;/**
* @var object
*/ protected $jrzj2c;/**
* @var Worksheet
*/ private $soxk2d;/**
* @param Worksheet $worksheet
*/ public function gdel0(Worksheet $soxk2d){$this->$kjsn2e=$soxk2d;$this->$jogv2f=whpi30(base64_decode('ZXhjZWwuZXhwb3J0cy5jaHVua19zaXpl'),100);$this->$twxb31=jvej22(TemporaryFileFactory::class);}/**
* @param Spreadsheet $spreadsheet
* @param string|int $index
* @return Sheet
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws SheetNotFoundException
*/ public static function ntos1(Spreadsheet $jemq32,$ussz33){if(is_numeric($ussz33)){return self::rdfg2($jemq32,$ussz33);}return self::bfrt3($jemq32,$ussz33);}/**
* @param Spreadsheet $spreadsheet
* @param int $index
* @return Sheet
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws SheetNotFoundException
*/ public static function rdfg2(Spreadsheet $jemq32,int $ussz33):Sheet{if(!isset($jemq32->fxgw34()[$ussz33])){throw SheetNotFoundException::rdfg2($ussz33,$jemq32->bysk35());}return new static($jemq32->hywj36($ussz33));}/**
* @param Spreadsheet $spreadsheet
* @param string $name
* @return Sheet
*
* @throws SheetNotFoundException
*/ public static function bfrt3(Spreadsheet $jemq32,string $pxtx37):Sheet{if(!$jemq32->qyej38($pxtx37)){throw SheetNotFoundException::bfrt3($pxtx37);}return new static($jemq32->havd39($pxtx37));}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function fwrn4($fwky3a){$this->$ufih3b=$fwky3a;if($fwky3a instanceof WithCustomValueBinder){SpreadsheetCell::bnkl3c($fwky3a);}if($fwky3a instanceof WithEvents){$this->wgdw3d($fwky3a->fqoq3e());}$this->vxyh3f(new uiap40($this,$this->$ufih3b));if($fwky3a instanceof WithTitle){$hsgu41=$fwky3a->uxkd42();$hsgu41=str_replace([base64_decode('Kg=='),base64_decode('Og=='),base64_decode('Lw=='),base64_decode('XFw='),base64_decode('Pw=='),base64_decode('Ww=='),base64_decode('XQ==')],'',$hsgu41);if(StringHelper::doxk43($hsgu41)>Worksheet::SHEET_TITLE_MAXIMUM_LENGTH){$hsgu41=StringHelper::yrov44($hsgu41,0,Worksheet::SHEET_TITLE_MAXIMUM_LENGTH);}$this->$kjsn2e->surc45($hsgu41);}if(($fwky3a instanceof FromQuery||$fwky3a instanceof FromCollection||$fwky3a instanceof FromArray)&&$fwky3a instanceof FromView){throw ConcernConflictException::kstc46();}if(!$fwky3a instanceof FromView&&$fwky3a instanceof WithHeadings){if($fwky3a instanceof WithCustomStartCell){$hvan47=$fwky3a->bljp48();}$this->fuxy15(ArrayHelper::mubp49($fwky3a->vxcw4a()),$hvan47 ?? null,$this->pgib25($fwky3a));}if($fwky3a instanceof WithCharts){$this->czav1a($fwky3a->vrmt4b());}}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
* @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
*/ public function qzms5($fwky3a){$this->fwrn4($fwky3a);if($fwky3a instanceof FromView){$this->yodob($fwky3a);}else{if($fwky3a instanceof FromQuery){$this->llgac($fwky3a,$this->$kjsn2e);}if($fwky3a instanceof FromCollection){$this->fcwnf($fwky3a);}if($fwky3a instanceof FromArray){$this->mvdm10($fwky3a);}if($fwky3a instanceof FromIterator){$this->gxqu11($fwky3a);}if($fwky3a instanceof FromGenerator){$this->dnnr13($fwky3a);}}$this->xuqna($fwky3a);}/**
* @param object $import
* @param int $startRow
*/ public function getc6($zxvv4c,int $ikvk4d=1){if($zxvv4c instanceof WithEvents){$this->wgdw3d($zxvv4c->fqoq3e());}$this->vxyh3f(new uiap40($this,$zxvv4c));if($zxvv4c instanceof WithProgressBar&&!$zxvv4c instanceof WithChunkReading){$zxvv4c->gmlu4e()->wzjj4f($this->$kjsn2e->ktcu50());}$lxtz51=$zxvv4c instanceof WithCalculatedFormulas;$pkvc52=$zxvv4c instanceof WithFormatData;if($zxvv4c instanceof WithMappedCells){jvej22(MappedReader::class)->dyjm53($zxvv4c,$this->$kjsn2e);}else{if($zxvv4c instanceof ToModel){jvej22(ModelImporter::class)->getc6($this->$kjsn2e,$zxvv4c,$ikvk4d);}if($zxvv4c instanceof ToCollection){$klvk54=$this->vido8($zxvv4c,$ikvk4d,null,$lxtz51,$pkvc52);if($zxvv4c instanceof WithValidation){$klvk54=$this->tcnr21($zxvv4c,$ikvk4d,$klvk54);}$zxvv4c->txsl55($klvk54);}if($zxvv4c instanceof ToArray){$klvk54=$this->lttv7($zxvv4c,$ikvk4d,null,$lxtz51,$pkvc52);if($zxvv4c instanceof WithValidation){$klvk54=$this->tcnr21($zxvv4c,$ikvk4d,$klvk54);}$zxvv4c->jwxm56($klvk54);}}if($zxvv4c instanceof OnEachRow){$ymqy57=HeadingRowExtractor::extract($this->$kjsn2e,$zxvv4c);$gozj58=HeadingRowExtractor::jlwd59($ymqy57,$zxvv4c);$jykx5a=$zxvv4c instanceof WithColumnLimit?$zxvv4c->rbfp5b():null;$zjlz5c=$this->hxez27($zxvv4c);foreach($this->$kjsn2e->frpe5d()->pqah5e($ikvk4d ?? 1)as $kjkk5f){$eaof60=new uftz61($kjkk5f,$ymqy57,$gozj58);if($zxvv4c instanceof WithValidation){$eaof60->cjrc62($zjlz5c);}$fsbl63=$eaof60->lttv7(null,$zxvv4c instanceof WithCalculatedFormulas,$zxvv4c instanceof WithFormatData,$jykx5a);$kdym64=$zxvv4c instanceof SkipsEmptyRows&&method_exists($zxvv4c,base64_decode('aXNFbXB0eVdoZW4='))&&$zxvv4c->zarb65($fsbl63);if(!$zxvv4c instanceof SkipsEmptyRows||($zxvv4c instanceof SkipsEmptyRows&&(!$kdym64&&!$eaof60->kzkg66($lxtz51)))){if($zxvv4c instanceof WithValidation){$jyye67=[$eaof60->klyz68()=>$fsbl63];try{jvej22(RowValidator::class)->ijvg69($jyye67,$zxvv4c);$zxvv4c->velg6a($eaof60);}catch(RowSkippedException $lmnh6b){}}else{$zxvv4c->velg6a($eaof60);}}if($zxvv4c instanceof WithProgressBar){$zxvv4c->gmlu4e()->csmd6c();}}}$this->vxyh3f(new dwsw6d($this,$zxvv4c));if($zxvv4c instanceof WithProgressBar&&!$zxvv4c instanceof WithChunkReading){$zxvv4c->gmlu4e()->mibz6e();}}/**
* @param object $import
* @param int|null $startRow
* @param null $nullValue
* @param bool $calculateFormulas
* @param bool $formatData
* @return array
*/ public function lttv7($zxvv4c,int $ikvk4d=null,$fshq6f=null,$sbun70=false,$pkvc52=false){if($ikvk4d>$this->$kjsn2e->ktcu50()){return[];}$wkhg71=EndRowFinder::cdhr72($zxvv4c,$ikvk4d,$this->$kjsn2e->ktcu50());$ymqy57=HeadingRowExtractor::extract($this->$kjsn2e,$zxvv4c);$gozj58=HeadingRowExtractor::jlwd59($ymqy57,$zxvv4c);$jykx5a=$zxvv4c instanceof WithColumnLimit?$zxvv4c->rbfp5b():null;$klvk54=[];foreach($this->$kjsn2e->frpe5d($ikvk4d,$wkhg71)as $ussz33=>$kjkk5f){$kjkk5f=new uftz61($kjkk5f,$ymqy57,$gozj58);if($zxvv4c instanceof SkipsEmptyRows&&$kjkk5f->kzkg66($sbun70,$jykx5a)){continue;}$kjkk5f=$kjkk5f->lttv7($fshq6f,$sbun70,$pkvc52,$jykx5a);if($zxvv4c&&method_exists($zxvv4c,base64_decode('aXNFbXB0eVdoZW4='))&&$zxvv4c->zarb65($kjkk5f)){continue;}if($zxvv4c instanceof WithMapping){$kjkk5f=$zxvv4c->dyjm53($kjkk5f);}if($zxvv4c instanceof WithValidation&&method_exists($zxvv4c,base64_decode('cHJlcGFyZUZvclZhbGlkYXRpb24='))){$kjkk5f=$zxvv4c->pjmp73($kjkk5f,$ussz33);}$klvk54[]=$kjkk5f;if($zxvv4c instanceof WithProgressBar){$zxvv4c->gmlu4e()->csmd6c();}}return $klvk54;}/**
* @param object $import
* @param int|null $startRow
* @param null $nullValue
* @param bool $calculateFormulas
* @param bool $formatData
* @return Collection
*/ public function vido8($zxvv4c,int $ikvk4d=null,$fshq6f=null,$sbun70=false,$pkvc52=false):Collection{$klvk54=$this->lttv7($zxvv4c,$ikvk4d,$fshq6f,$sbun70,$pkvc52);return new yman9(array_map(function(array$kjkk5f){return new yman9($kjkk5f);},$klvk54));}/**
* @param object $sheetExport
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function xuqna($fwky3a){if($fwky3a instanceof WithDrawings){$this->orlq1b($fwky3a->zlcs74());}$this->$ufih3b=$fwky3a;if($fwky3a instanceof WithColumnFormatting){foreach($fwky3a->dhpn75()as $ldpy76=>$fmxm77){$this->dkka17($ldpy76,$fmxm77);}}if($fwky3a instanceof ShouldAutoSize){$this->xhzl16();}if($fwky3a instanceof WithColumnWidths){foreach($fwky3a->gyru78()as $ldpy76=>$waym79){$this->$kjsn2e->foww7a($ldpy76)->dvxk7b(false)->laqh7c($waym79);}}if($fwky3a instanceof WithStyles){$xqhl7d=$fwky3a->hngj7e($this->$kjsn2e);if(is_array($xqhl7d)){foreach($xqhl7d as $edzn7f=>$vjrt80){if(is_numeric($edzn7f)){$edzn7f=base64_decode('QQ==').$edzn7f.base64_decode('Og==').$this->$kjsn2e->ebwi81($edzn7f).$edzn7f;}$this->$kjsn2e->qzzk82($edzn7f)->vskt83($vjrt80);}}}$this->vxyh3f(new dwsw6d($this,$this->$ufih3b));$this->nlpm84();}/**
* @param FromView $sheetExport
* @param int|null $sheetIndex
*
* @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
*/ public function yodob(FromView $fwky3a,$fqye85=null){$pphk86=$this->$twxb31->oyfj87(null,base64_decode('aHRtbA=='));$pphk86->vavx88($fwky3a->xktd89()->tszv8a());$jemq32=$this->$kjsn2e->dgtq8b();/** @var Html $reader */ $gnvm8c=IOFactory::zwsp8d(base64_decode('SHRtbA=='));$gnvm8c->tfds8e($fqye85 ?? $jemq32->bysk35()-1);$gnvm8c->rpvn8f($pphk86->nrpw90(),$jemq32);$pphk86->iakr91();}/**
* @param FromQuery $sheetExport
* @param Worksheet $worksheet
*/ public function llgac(FromQuery $fwky3a,Worksheet $soxk2d){if($fwky3a->oirl92()instanceof \Laravel\Scout\Builder){$this->ksabe($fwky3a,$soxk2d);return;}$fwky3a->oirl92()->icxj93($this->xrod26($fwky3a),function($iocv94)use($fwky3a){$this->bvwxd($iocv94,$fwky3a);});}/**
* @param FromQuery $sheetExport
* @param Worksheet $worksheet
*/ public function ksabe(FromQuery $fwky3a,Worksheet $soxk2d){$dwzk95=$fwky3a->oirl92();$ktiz2a=$this->xrod26($fwky3a);$iocv94=$dwzk95->pmke96($ktiz2a);$this->bvwxd($iocv94->fxmf97(),$fwky3a);for($bfuj98=2;$bfuj98<=$iocv94->fxds99();$bfuj98++){$this->bvwxd($dwzk95->pmke96($ktiz2a,base64_decode('cGFnZQ=='),$bfuj98)->fxmf97(),$fwky3a);}}/**
* @param FromCollection $sheetExport
*/ public function fcwnf(FromCollection $fwky3a){$this->bvwxd($fwky3a->txsl55()->ovez9a(),$fwky3a);}/**
* @param FromArray $sheetExport
*/ public function mvdm10(FromArray $fwky3a){$this->bvwxd($fwky3a->jwxm56(),$fwky3a);}/**
* @param FromIterator $sheetExport
*/ public function gxqu11(FromIterator $fwky3a){$igns9b=class_exists(LazyCollection::class)?new smpw9c(function()use($fwky3a){foreach($fwky3a->tpoj12()as $kjkk5f){yield $kjkk5f;}}):$fwky3a->tpoj12();$this->bvwxd($igns9b,$fwky3a);}/**
* @param FromGenerator $sheetExport
*/ public function dnnr13(FromGenerator $fwky3a){$kmzd9d=class_exists(LazyCollection::class)?new smpw9c(function()use($fwky3a){foreach($fwky3a->nlvg14()as $kjkk5f){yield $kjkk5f;}}):$fwky3a->nlvg14();$this->bvwxd($kmzd9d,$fwky3a);}/**
* @param array $rows
* @param string|null $startCell
* @param bool $strictNullComparison
*/ public function fuxy15(array$klvk54,string $hvan47=null,bool $obur9e=false){if(!$hvan47){$hvan47=base64_decode('QTE=');}if($this->jmxp24()){$hvan47=CellHelper::omep9f($hvan47).($this->$kjsn2e->ktcu50()+1);}$this->$kjsn2e->mvdm10($klvk54,null,$hvan47,$obur9e);}public function xhzl16(){foreach($this->jkva23(base64_decode('QQ=='),$this->$kjsn2e->noqea0())as $dznna1){$pjzla2=$this->$kjsn2e->foww7a($dznna1);if($pjzla2->qrida3()==-1){$pjzla2->dvxk7b(true);}}}/**
* @param string $column
* @param string $format
*
* @throws \PhpOffice\PhpSpreadsheet\Exception
*/ public function dkka17(string $ldpy76,string $fmxm77){if(stripos($ldpy76,base64_decode('Og=='))!==false){$this->$kjsn2e->qzzk82($ldpy76)->dthia4()->zhnca5($fmxm77);}else{$this->$kjsn2e->qzzk82($ldpy76.base64_decode('MTo=').$ldpy76.$this->$kjsn2e->ktcu50())->dthia4()->zhnca5($fmxm77);}}/**
* @param int $chunkSize
* @return Sheet
*/ public function fwaw18(int $ktiz2a){$this->$jogv2f=$ktiz2a;return $this;}/**
* @return Worksheet
*/ public function ryjt19(){return $this->$kjsn2e;}/**
* @param Chart|Chart[] $charts
*/ public function czav1a($kllwa6){$kllwa6=\is_array($kllwa6)?$kllwa6:[$kllwa6];foreach($kllwa6 as $kffda7){$this->$kjsn2e->yeqha8($kffda7);}}/**
* @param BaseDrawing|BaseDrawing[] $drawings
*/ public function orlq1b($prwfa9){$prwfa9=\is_array($prwfa9)?$prwfa9:[$prwfa9];foreach($prwfa9 as $oavwaa){$oavwaa->qoodab($this->$kjsn2e);}}/**
* @param string $concern
* @return string
*/ public function usjp1c(string $rzumac):string{return $this->$ufih3b instanceof $rzumac;}/**
* @param iterable $rows
* @param object $sheetExport
*/ public function bvwxd($klvk54,$fwky3a){if(method_exists($fwky3a,base64_decode('cHJlcGFyZVJvd3M='))){$klvk54=$fwky3a->uzxcad($klvk54);}$klvk54=$klvk54 instanceof LazyCollection?$klvk54:new yman9($klvk54);$klvk54->wgmdae(function($kjkk5f)use($fwky3a){if($fwky3a instanceof WithMapping){$kjkk5f=$fwky3a->dyjm53($kjkk5f);}if($fwky3a instanceof WithCustomValueBinder){SpreadsheetCell::bnkl3c($fwky3a);}return ArrayHelper::mubp49(static::sjfx1e($kjkk5f));})->icxj93(1000)->oomiaf(function($klvk54)use($fwky3a){$this->fuxy15($klvk54->lttv7(),$fwky3a instanceof WithCustomStartCell?$fwky3a->bljp48():null,$this->pgib25($fwky3a));});}/**
* @param mixed $row
* @return array
*/ public static function sjfx1e($kjkk5f):array{if(is_object($kjkk5f)&&method_exists($kjkk5f,base64_decode('YXR0cmlidXRlc1RvQXJyYXk='))){return $kjkk5f->roqob0();}if($kjkk5f instanceof Arrayable){return $kjkk5f->lttv7();}if(is_object($kjkk5f)){return json_decode(json_encode($kjkk5f),true);}return $kjkk5f;}/**
* @param $sheetImport
* @return int
*/ public function ostr1f($gvcsb1):int{return HeadingRowExtractor::aaolb2($gvcsb1);}/**
* Disconnect the sheet.
*/ public function lvtj20(){$this->$kjsn2e->ecwvb3();unset($this->$kjsn2e);}/**
* @return Collection|array
*/ protected function tcnr21(WithValidation $zxvv4c,int $ikvk4d,$klvk54){$jyye67=(new yman9($klvk54))->thzcb4(function($kjkk5f,$ussz33)use($ikvk4d){return[($ikvk4d+$ussz33)=>$kjkk5f];});try{jvej22(RowValidator::class)->ijvg69($jyye67->lttv7(),$zxvv4c);}catch(RowSkippedException $lmnh6b){foreach($lmnh6b->lrytb5()as $kjkk5f){unset($klvk54[$kjkk5f-$ikvk4d]);}}return $klvk54;}/**
* @param string $lower
* @param string $upper
* @return \Generator
*/ protected function jkva23(string $wvdgb6,string $bhiub7){$bhiub7++;for($qvvnb8=$wvdgb6;$qvvnb8!==$bhiub7;$qvvnb8++){yield $qvvnb8;}}/**
* @return bool
*/ private function jmxp24():bool{$hvan47=base64_decode('QTE=');if($this->$ufih3b instanceof WithCustomStartCell){$hvan47=$this->$ufih3b->bljp48();}return $this->$kjsn2e->dmqsb9($hvan47);}/**
* @param object $sheetExport
* @return bool
*/ private function pgib25($fwky3a):bool{if($fwky3a instanceof WithStrictNullComparison){return true;}return whpi30(base64_decode('ZXhjZWwuZXhwb3J0cy5zdHJpY3RfbnVsbF9jb21wYXJpc29u'),false);}/**
* @param object|WithCustomChunkSize $export
* @return int
*/ private function xrod26($hojhba):int{if($hojhba instanceof WithCustomChunkSize){return $hojhba->fwaw18();}return $this->$jogv2f;}/**
* @param object|WithValidation $import
* @return Closure|null
*/ private function hxez27($zxvv4c){if(!$zxvv4c instanceof WithValidation||!method_exists($zxvv4c,base64_decode('cHJlcGFyZUZvclZhbGlkYXRpb24='))){return null;}return function(array$jnizbb,int $ussz33)use($zxvv4c){return $zxvv4c->pjmp73($jnizbb,$ussz33);};}}?>
Function Calls
None |
Stats
MD5 | 8b77f9e23afe1d39479b8e3524e00603 |
Eval Count | 0 |
Decode Time | 126 ms |