ldc-cocotte/app/Exports/SalariesExport.php
2025-07-08 15:36:23 +02:00

89 lines
1.8 KiB
PHP

<?php
namespace App\Exports;
use App\Models\Salarie;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithCustomCsvSettings;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithMapping;
class SalariesExport implements FromCollection, WithHeadings, WithMapping, WithCustomCsvSettings
{
/**
* @var array
*/
public $salariesImport = null;
/**
* Create a new instance.
*
* @param array $salariesImport
* @return void
*/
public function __construct(array $salariesImport)
{
$this->salariesImport = $salariesImport;
}
/**
* Set the header of the .csv.
*
* @return array
*/
public function headings(): array
{
return [
'Matricule',
'Nom',
'Prenom',
'Site',
'Code',
];
}
/**
* Set data to specific column.
*
* @param \App\Models\Salarie $salaries
* @return array
* @phpcs:disable Squiz.Commenting.FunctionComment.TypeHintMissing
*/
public function map($salaries): array
{
//phpcs:enable
return [
$salaries->matricule,
$salaries->nom,
$salaries->prenom,
$salaries->site,
$salaries->code,
];
}
/**
* Surchage defaults config of Laravel.
*
* @return array
*/
public function getCsvSettings(): array
{
return [
'delimiter' => ';'
];
}
/**
*
* @return \Illuminate\Support\Collection
*/
public function collection()
{
$salaries = Salarie::query();
foreach ($this->salariesImport as $salarieImport) {
$salaries->orWhere('matricule', $salarieImport);
}
return $salaries->get();
}
}