File: /var/www/vhost/disk-apps/comfama.sports-crowd.com/app/Http/Controllers/Exports/ErpLogsExport.php
<?php
namespace App\Http\Controllers\Exports;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
class ErpLogsExport implements FromCollection, WithHeadings, WithEvents
{
private $results;
public function __construct($results)
{
$this->results = $results;
}
// set the headings
public function headings(): array
{
return [
__('messages.erp_logs.origin'),
__('messages.erp_logs.object'),
__('messages.erp_logs.error'),
__('messages.erp_logs.action'),
__('messages.erp_logs.resolved'),
__('messages.erp_logs.date'),
];
}
// freeze the first row with headings
public function registerEvents(): array
{
return [];
}
public function collection()
{
$data = [];
foreach ($this->results as $log) {
$data[] = array(
$log->origin,
$log->object,
$log->message,
$log->action,
$log->resolved ? 'SI' : 'NO',
\Carbon\Carbon::parse($log->created_at)->format('Y-m-d h:i:s A'),
);
}
return collect($data);
}
}