File Manager

Editing File: /home/ubuntu/route-and-root-backend-base/app/Exports/CountriesExport.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\{ Country };

use App\Helpers\Helper;

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

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

$base_query = Country::Query()
                        ->when(isset($this->status), function ($query) {
                            $query->where('status', $this->status);
                        })->when($this->search_key, function($query) {
                            $query->where('state', "LIKE", "%" . $this->search_key . "%");
                            $query->orWhere('country', "LIKE", "%" . $this->search_key . "%");
                            $query->orWhere('country_code', "LIKE", "%" . $this->search_key . "%");
                        });

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

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

Back to Directory File Manager