ONE PIECE HACKING

Ngiler SH3LL 360
: / home / tbf / cursbackend / app / Exports /

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 : KeyResultsOverviewExport.php \| Size : 1.17 KB
<?php namespace App\Exports; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromView; use Maatwebsite\Excel\Concerns\ShouldAutoSize; use Maatwebsite\Excel\Concerns\WithEvents; use Maatwebsite\Excel\Events\AfterSheet; use Illuminate\Http\Request; use App\Models\Instance; class KeyResultsOverviewExport implements FromView, ShouldAutoSize, WithEvents { function __construct(Request $request, Instance $instance) { $this->request = $request; $this->instance = $instance; } public function registerEvents(): array { return [ AfterSheet::class => function(AfterSheet $event) { $cellRange = 'A1:Z1'; // All headers $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14)->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED); $event->sheet->freezePane('A2'); $event->sheet->getRowDimension(1)->setRowHeight(20); }, ]; } public function view(): View { return view('exports.xls.key_results_overview', [ 'data' => keyResultsOverviewReport($this->request, $this->instance), ]); } } Back

Edit File : KeyResultsOverviewExport.php | Size : 1.17 KB

<?php

namespace App\Exports;

use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
use Illuminate\Http\Request;
use App\Models\Instance;

class KeyResultsOverviewExport implements FromView, ShouldAutoSize, WithEvents
{
	function __construct(Request $request, Instance $instance) {
	    $this->request = $request;
	    $this->instance = $instance;
	}

public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
                $cellRange = 'A1:Z1'; // All headers
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14)->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
                $event->sheet->freezePane('A2');
                $event->sheet->getRowDimension(1)->setRowHeight(20);
            },
        ];
    }

public function view(): View
    {
        return view('exports.xls.key_results_overview', [
        	'data'	=> keyResultsOverviewReport($this->request, $this->instance),
        ]);
    }
}

Back