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();
}
