public function showInfo($slug)
{
$lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
$lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
$info = Alerte::where('slug', '=', $slug)->firstOrFail();
return View::make('public.pages.info')->with('info', $info)->with('lastActu', $lastActu)->with('lastInfo', $lastInfo);
}
public function plan()
{
$lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
$lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
$lignes = Ligne::all();
return View::make('public.pages.plan')->with('lastActu', $lastActu)->with('lastInfo', $lastInfo)->with('lignes', $lignes);
}
public function liensutiles()
{
$liens = Lien::all();
// POUR PAGE TYPE
$lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
$lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
return View::make('public.pages.liensutiles')->with('liens', $liens)->with('lastActu', $lastActu)->with('lastInfo', $lastInfo);
}
public function faq()
{
$faq = Faq::all();
// POUR PAGE TYPE
$lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
$lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
//--------------------
return View::make('public.pages.faq')->with('faq', $faq)->with('lastActu', $lastActu)->with('lastInfo', $lastInfo);
}
public function lieux()
{
$lieux = DB::table('lieu')->join('categorielieu', 'lieu.idCatLieu', '=', 'categorielieu.idCatLieu')->orderBy('categorielieu.idCatLieu', 'asc')->get();
$cat = DB::table('categorielieu')->orderBy('categorielieu.idCatLieu', 'asc')->get();
// POUR PAGE TYPE
$lastActu = Actualites::orderBy('dateActualite', 'desc')->take(1)->get();
$lastInfo = Alerte::orderBy('dateAlerte', 'desc')->take(1)->get();
//--------------------
return View::make('public.pages.lieu')->with('lieux', $lieux)->with('cat', $cat)->with('lastActu', $lastActu)->with('lastInfo', $lastInfo);
}