PenangananPiutangExport.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace App\Exports;
  3. use App\Model\Service\PenangananPiutang;
  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 PenangananPiutangExport 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', 'Provinsi', 'Nama UPT','No.Klien', 'Wajib Bayar','Nilai Penyerahan', 'Tahun Pelimpahan', 'Nama KPKNL', 'Tahapan Pengurusan', 'Lunas', 'Angsuran', 'Tanggal','PSBDT', 'Tanggal PSBDT', 'Pembatalan', 'Tanggal Pembatalan','Tanggal Dibuat','Tanggal Update', 'Sisa Piutang', 'Keterangan'];
  28. }
  29. public function startCell(): string
  30. {
  31. return 'A1';
  32. }
  33. }