/** * Execute the job. * * @return void */ public function handle() { $recordsPerPage = 3; $offset = ($this->page - 1) * $recordsPerPage; $count = Photo::count(); if ($this->page > 1) { $previousPage = $this->page - 1; } else { $previousPage = null; } if ($this->page * $recordsPerPage < $count) { $nextPage = $this->page + 1; } else { $nextPage = null; } $photos = Photo::orderBy('posted_date', 'desc')->skip($offset)->take($recordsPerPage)->get(); //$previousUrl = action('PhotosController@index', ['page' => $previousPage]); //$nextUrl = action('PhotosController@index', ['page' => $nextPage]); if ($previousPage) { $previousUrl = url('photos/display/' . $previousPage); } else { $previousUrl = null; } if ($nextPage) { $nextUrl = url('photos/display/' . $nextPage); } else { $nextUrl = null; } return ['photos' => $photos, 'previousUrl' => $previousUrl, 'nextUrl' => $nextUrl]; }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { return view('photos', ['photos' => Photo::orderBy('created_at', 'asc')->get()]); }
$date = date("Y-m-d"); $heure = date("H:i:s"); $iduser = Auth::user()->idutilisateur; $anecdote = new Anecdote(); $anecdote->anecdote = $request->anecdote; $anecdote->idperle = $request->input('idperle'); $anecdote->dateanecdote = $date; $anecdote->heureanecdote = $heure; $anecdote->idutilisateur = $iduser; if ($anecdote->save()) { return view('accueil_bootstrap'); } }); // Rècupere aléatoirement des photos dans la base de données afin de la afficher sur la page d'accueil (bandeau à droite) Route::get('/photosaleatoires', function () { $photos = Photo::orderBy(DB::raw('RAND()'))->get(); /* $photos= DB::table('photos') ->select(['nomphoto']) ->orderBy('RAND()'); */ echo json_encode($photos); }); // Affiche la page de consultation Route::get('/consulter', function () { $perles = Perle::get(); return view('consulter_perle'); }); /* --------------- FORMULAIRE DE CONSULTATION ------------------- */ // Affiche au format JSON de toutes les catégories Route::get('/categoriesREST', function () { $categories = Categorie::get(); echo json_encode($categories);
/** * Display view for homepage * * @param Photo $images * @return $this */ public function index(Photo $images) { return view('welcome')->with('images', $images->orderBy('created_at', 'desc')->paginate(20)); }