<?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 LoanUserExport implements FromCollection, WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    use Exportable; 

   
    public function collection()
    {  
        return DB::table('inquiry_details AS user')
                    ->select(\DB::raw('user.id, user.name, user.email, user.mobile_no, user.amount, user.city,user.pincode, user.created_at'))
                    ->get();
        
    }

    public function headings(): array
    {
        return [
            'Id',
            'User Name',
            'Email',
            'Mobile No',
            'Amount',
            'City',
            'Pincode',
            'Created At',
        ];
    }
}