RTExport.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php
  2. namespace App\Exports;
  3. use App\Model\SPP\RT;
  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\Exportable;
  11. use Auth;
  12. use Carbon\Carbon;
  13. class RTExport implements FromArray, WithHeadings, WithCustomStartCell, ShouldAutoSize
  14. {
  15. /**
  16. * @return \Illuminate\Support\Collection
  17. */
  18. public function __construct(array $invoices)
  19. {
  20. $this->invoices = $invoices;
  21. }
  22. public function array(): array
  23. {
  24. return $this->invoices;
  25. }
  26. public function headings(): array
  27. {
  28. return ['Provinsi', 'Nama UPT', 'No. Tagihan', 'No. Klien','Nama Klien', 'BHP (Rp)', 'Tanggal (BI Begin)', 'Status Pembayaran','Service','Tanggal Jatuh Tempo','Tanggal Bayar','Upaya / Methode','Tanggal Upaya', 'Keterangan'];
  29. }
  30. public function startCell(): string
  31. {
  32. return 'A1';
  33. }
  34. }