12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- <?php
- namespace App\Exports;
- use App\Models\Requirement;
- use Maatwebsite\Excel\Concerns\Exportable;
- use Maatwebsite\Excel\Concerns\FromQuery;
- use Maatwebsite\Excel\Concerns\WithHeadings;
- use Maatwebsite\Excel\Concerns\WithMapping;
- class RequirementExport implements FromQuery, WithMapping, WithHeadings
- {
- use Exportable;
- public function query()
- {
- return Requirement::with(['createdBy', 'plan','group', 'asset'])
- ->orderBy("created_at")
- ->filter(request()->all());
- }
- /**
- * @param Requirement $requirement
- * @return array
- */
- public function map($requirement): array
- {
- return [
- $requirement->id,
- $requirement->title,
- $requirement->group?->name,
- $requirement->status,
- $requirement->asset?->name,
- $requirement->plan?->name,
- $requirement->priority,
- $requirement->approval_status,
- $requirement->note,
- $requirement->description,
- $requirement->createdBy?->name,
- $requirement->created_at,
- ];
- }
- public function headings(): array
- {
- return [
- 'ID',
- 'Title',
- 'Requirement Group',
- 'Status',
- 'Plan',
- 'Asset',
- 'Priority',
- 'Approval Status',
- 'Note',
- 'Description',
- 'Created By',
- 'Created Date',
- ];
- }
- }
|