Esempio n. 1
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit(Request $request, $id)
 {
     $concerts = Concert::orderBy('created_at', 'asc')->get();
     $currentConcert = Concert::where('id', $id)->first();
     $artists = Artist::orderBy('created_at', 'asc')->get();
     $lieux = array();
     foreach ($concerts as $concert) {
         if (!in_array($concert->lieu, $lieux)) {
             $lieux[] = $concert->lieu;
         }
     }
     return view('admin_edit', ['lieux' => $lieux, 'artists' => $artists, 'currentConcert' => $currentConcert]);
 }
Esempio n. 2
0
 public function getPage(Request $request, $pageIndex)
 {
     $city = $request->input('city');
     $tags = $request->input('tags');
     $price = $request->input('price');
     $matchThese = array();
     if ($city != 'unspecified') {
         $matchThese['ville'] = $city;
     }
     if ($price != 'unspecified') {
         $matchThese['prix'] = $price;
     }
     $concertsQueryBuilder = Concert::orderBy('concerts.created_at', 'asc');
     if ($tags != 'unspecified') {
         $matchThese['tags'] = $tags;
         $concertsQueryBuilder->join('artists', 'artists.id', '=', 'concerts.artist_id');
     }
     $concertsQueryBuilder->where($matchThese);
     $concerts = $concertsQueryBuilder->get();
     $villes = array();
     $tags = array();
     $prix = array();
     foreach ($concerts as $concert) {
         if (!in_array($concert->ville, $villes)) {
             $villes[] = $concert->ville;
         }
         if (!in_array($concert->prix, $prix)) {
             $prix[] = $concert->prix;
         }
         if (!in_array($concert->artist->tags, $tags)) {
             $tags[] = $concert->artist->tags;
         }
     }
     $current_page = $pageIndex - 1;
     $concert_count = count($concerts);
     $page_count = $concert_count % SELF::CONCERTS_PER_PAGE != 0 ? floor($concert_count / SELF::CONCERTS_PER_PAGE) + 1 : floor($concert_count / SELF::CONCERTS_PER_PAGE);
     return view('concert_list', ['concerts' => $concerts, 'villes' => $villes, 'tags' => $tags, 'prix' => $prix, 'page_count' => $page_count, 'current_page' => $current_page]);
 }