public static function filterAndPaginateDelete($name) { /*return \DB::table('selectPartners') ->onlyTrashed() ->where('name','like','%'.$name.'%') ->orderBy('name','ASC') ->paginate();*/ return Partner::name($name)->join('countrys', 'partners.country_id', '=', 'countrys.id')->join('citys', 'partners.city_id', '=', 'citys.id')->join('states', 'partners.state_id', '=', 'states.id')->select('partners.*', 'countrys.name as country_name', 'citys.name as city_name', 'states.name as state_name')->onlyTrashed()->orderBy('partners.name', 'ASC')->paginate(); }