<?php
  
namespace App\Exports;
  
use DB;
use Maatwebsite\Excel\Concerns\FromArray;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use App\User; 
use Auth;
   
class ContactExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    use Exportable; 

   
    public function collection()
    {  
        return DB::table('contact AS contct')
                    ->select(\DB::raw('contct.id, contct.name, contct.email, contct.phone_no, contct.subject, contct.message, contct.created_at'))
                    ->get();
        
    }

    public function headings(): array
    {
        return [
            'Id',
            'User Name',
            'Email',
            'Mobile No',
            'Subject',
            'Message',
            'Created At',
        ];
    }
}