<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromView;
use Illuminate\Contracts\View\View;
use App\Models\Customer;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\RegistersEventListeners;
use Maatwebsite\Excel\Events\AfterSheet;
class CustomerExport implements FromView, WithEvents
{
    use RegistersEventListeners;


    public function view(): View
    {
        $customer =  Customer::select('customer_id','nama_customer','nik','tanggal_lahir','gender','email','no_hp','referal_code', 'point','level_point','nomor_member', 'status','parent_referal_code', 'created_who','updated_who','created_at','updated_at','ext_member_id')
        ->orderBy('customer_id', 'desc')
        ->get();
        foreach ($customer as $customers) {
            $customers->nik = "'".$customers->nik;
        }
        return view('customer.excel_all', [
            'customers' =>$customer
        ]);

    }
     public static function afterSheet(AfterSheet $event)
    {
        $sheet = $event->sheet;

        // Mengatur tipe sel Excel ke "text" untuk semua sel dalam lembar kerja
        $sheet->getDelegate()->getParent()->getDefaultStyle()
            ->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
    }
}