/**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     // Return all Artworks
     $term = $request->input('query');
     $dbField = $request->input('dbField');
     $sortBy = $request->input('sortBy');
     if (is_null($sortBy)) {
         $sortBy = 'artist_lastname';
     }
     if (is_null($term)) {
         $term = '';
     }
     if (is_null($dbField)) {
         $dbField = 'artist_lastname';
     }
     if (isset($term)) {
         $artworks = Artwork::where(strtolower($dbField), 'LIKE', '%' . $term . '%')->orderBy($sortBy, 'asc')->get();
     } else {
         $artworks = Artwork::all();
     }
     return view('artworks.index')->with('artworks', $artworks);
 }
Example #2
0
 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     // request search query term & field for search
     $term = $request->input('query');
     $dbField = $request->input('dbField');
     $sortBy = $request->input('sortBy');
     if (is_null($sortBy)) {
         $sortBy = 'artist_fullname';
     }
     if (isset($term)) {
         if ($dbField == 'artist_lastname') {
             $artworks = Artwork::where(strtolower($dbField), 'ILIKE', '' . $term . '%')->orderBy($sortBy, 'asc')->get();
         } elseif ($dbField == 'art_fair_year') {
             $artworks = Artwork::where(strtolower($dbField), 'ILIKE', '%' . $term . '%')->orderBy($sortBy, 'asc')->get();
         } else {
             $artworks = Artwork::where(strtolower($dbField), 'ILIKE', '%' . $term . '%')->orderBy($sortBy, 'asc')->get();
         }
     } else {
         $artworks = Artwork::all();
     }
     // Pass in articles data to view
     return view('search.index', ['artworks' => $artworks]);
 }