nyan

<?php

namespace App\Exports;

use App\Models\ContactAtap;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;

class ContactAtapExport implements FromCollection, WithHeadings
{
    protected $startDate;
    protected $endDate;
    protected $search;
    public function __construct($startDate = null, $endDate = null, $search = null)
    {
        $this->startDate = $startDate;
        $this->endDate   = $endDate;
    }

/**
     * @return \Illuminate\Support\Collection
     */
    public function collection()
    {
        return ContactAtap::query()
            ->when($this->startDate && $this->endDate, function ($query) {
                $query->whereBetween('created_at', [
                    $this->startDate . ' 00:00:00',
                    $this->endDate . ' 23:59:59'
                ]);
            })
            ->select(
                'id',
                'name',
                'company_name',
                'customer_category',
                'no_hp',
                'email',
                'city',
                'product',
                'variant_color',
                'request_variant_color',
                'created_at'
            )
            ->get();
    }

public function headings(): array
    {
        return ['No', 'Nama', 'Nama Perusahaan', 'Kategori Customer', 'No HP', 'Email', 'Kota', 'Produk', 'Varian Warna', 'Request Varian Warna', 'Waktu'];
    }
}