Ejemplo n.º 1
0
 public static function findRequested()
 {
     $query = Phone::query();
     // search results based on user input
     \Request::input('id') and $query->where('id', \Request::input('id'));
     \Request::input('model') and $query->where('model', 'like', '%' . \Request::input('model') . '%');
     \Request::input('manufacturer') and $query->where('manufacturer', 'like', '%' . \Request::input('manufacturer') . '%');
     \Request::input('operating_system') and $query->where('operating_system', \Request::input('operating_system'));
     \Request::input('created_at') and $query->where('created_at', \Request::input('created_at'));
     \Request::input('updated_at') and $query->where('updated_at', \Request::input('updated_at'));
     \Request::input('release_date') and $query->where('release_date', \Request::input('release_date'));
     // sort results
     \Request::input("sort") and $query->orderBy(\Request::input("sort"), \Request::input("sortType", "asc"));
     // paginate results
     return $query->paginate(15);
 }