/**
* 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));
}
