Viewing File: /home/ubuntu/route-and-root-backend-base/app/Exports/UsersExport.php

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromCollection;

use Illuminate\Contracts\View\View;

use Maatwebsite\Excel\Concerns\FromView;

use Illuminate\Http\Request;

use App\Models\User;

use App\Helpers\Helper;

class UsersExport implements FromView
{
    public function __construct(Request $request)
    {
        $this->search_key = $request->search_key;
        $this->status = $request->status;
        $this->is_email_verified = $request->is_email_verified;
    }

    /**
    * @return \Illuminate\Support\Collection
    */
    public function view(): View {

        $base_query = User::Query()
                        ->when(isset($this->status), function ($query) {
                            $query->where('status', $this->status);
                        })->when(isset($this->is_email_verified), function ($query) {
                            $query->where('is_email_verified', $this->is_email_verified);
                        })->when($this->search_key, function($query) {
                            $query->where('name', "LIKE", "%" . $this->search_key . "%");
                            $query->orWhere('email', "LIKE", "%" . $this->search_key . "%");
                            $query->orWhere('mobile', "LIKE", "%" . $this->search_key . "%");
                        });

        $users = $base_query->orderBy('created_at', 'DESC')->get();

        return view('exports.users', [ 'data' => $users ]);
    }
}