<?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
{
    use Exportable;

    protected $exportDate;

    public function __construct($exportDate)
    {
        $this->exportDate = $exportDate;
    }

    public function collection()
    {
        return DB::table('inquiry_details AS user')
            ->select(DB::raw('user.id, user.name, user.email, user.primary_mobile_no, user.amount, user.loan_purpose, user.birth_date, user.license_number, user.ssn, user.zipcode, user.street_address, user.get_paid, user.next_paydate, user.how_get_paid, user.account_type, user.net_income, user.income_source, user.military, user.employer_name, user.employer_ph_no, user.debt_pay, user.approximate_rating, user.vehicle_free, user.bank_name, user.bank_state, user.routing_no, user.acc_no, user.created_at'))
            ->whereDate('user.created_at', '=', $this->exportDate)
            ->get();
    }

    public function headings(): array
    {
        return [
            'Id', 'User Name', 'Email', 'Mobile No', 'Amount', 'Loan Purpose',
            'Birth date', 'License Number', 'SSN', 'Zipcode', 'Street Address',
            'Get Paid', 'Next Paydate', 'How Get Paid', 'Account Type',
            'Net Income', 'Income Source', 'Military', 'Employer Name',
            'Employer Phone No', 'Debt Pay', 'Approximate Rating', 'Vehicle Free',
            'Bank Name', 'Bank State', 'Routing No', 'Account No', 'Created At',
        ];
    }
}