File: /var/www/vhost/disk-apps/qas.sports-crowd.com/app/Http/Controllers/Exports/PublicationsExport.php
<?php
namespace App\Http\Controllers\Exports;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
class PublicationsExport implements FromCollection, WithHeadings, WithEvents
{
private $results;
public function __construct($results)
{
$this->results = $results;
}
// set the headings
public function headings(): array
{
return [
__('messages.photos_club.name'),
__('messages.academy_tournaments.type'),
__('messages.publications.reactions'),
__('messages.screen_alliance_tag5'),
__('messages.publications.date')
];
}
// freeze the first row with headings
public function registerEvents(): array
{
return [];
}
public function collection()
{
$data = [];
foreach ($this->results as $item) {
unset($item[5]);
$data[] = $item;
}
return collect($data);
}
}