InspeksiDataExport.php 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace App\Exports;
  3. use App\Model\Inspeksi\Inspeksi;
  4. use Maatwebsite\Excel\Concerns\ShouldAutoSize;
  5. use Maatwebsite\Excel\Concerns\WithCustomStartCell;
  6. use Maatwebsite\Excel\Concerns\WithHeadings;
  7. use Maatwebsite\Excel\Concerns\WithMapping;
  8. use Maatwebsite\Excel\Concerns\WithTitle;
  9. use Maatwebsite\Excel\Concerns\FromArray;
  10. use Maatwebsite\Excel\Concerns\FromCollection;
  11. use Auth;
  12. class InspeksiDataExport implements FromArray, WithHeadings, WithCustomStartCell, ShouldAutoSize
  13. {
  14. /**
  15. * @return \Illuminate\Support\Collection
  16. */
  17. public function __construct(array $invoices)
  18. {
  19. $this->invoices = $invoices;
  20. }
  21. public function array(): array
  22. {
  23. return $this->invoices;
  24. }
  25. public function headings(): array
  26. {
  27. return ['ID', 'Tahun','Bulan','Provinsi', 'Nama UPT', 'Tanggal Lapor','Data Sampling', 'HI Sesuai ISR', 'HI Tidak Sesuai ISR', 'HI Tidak Aktif', 'HI Proses ISR', 'TL Sesuai ISR',
  28. 'TL Belum ISR', 'Capaian Valid', 'Keterangan', 'Nama Lampiran', 'Tipe', 'Pembuat'];
  29. }
  30. public function startCell(): string
  31. {
  32. return 'A1';
  33. }
  34. }