public function edit(Request $request) { $universite = Universite::where('idUniv', $request->input('idUniv'))->get()->first(); $universite->nomUniv = $request->input('nomUniv'); $universite->adr1Univ = $request->input('adr1Univ'); $universite->adr2Univ = $request->input('adr2Univ'); $universite->telUniv = $request->input('telUniv'); $universite->mailUniv = $request->input('mailUniv'); $universite->photoUniv = $request->input('photoUniv'); $universite->logoUniv = $request->input('logoUniv'); $universite->latUniv = $request->input('latUniv'); $universite->longUniv = $request->input('longUniv'); $universite->inseeVille = $request->input('inseeVille'); $universite->save(); return redirect()->route('backuniv'); }
/** * Retourne une liste des 10 premiers sites universitaires * et les 10 premières villes complétant les premiers caractères d'une recherche */ public function ville(Request $request, $univ = null) { $term = Str::lower(Input::get('term')); $jsonArr = array(); // Récupérer l'identifiant de l'université if ($univ != null) { $univ2 = Universite::where('nomUniv', $univ)->get(); $sites = DB::table("site")->distinct('nomSite')->where('nomsite', 'like', $term . '%')->where('idUniv', $univ2[0]->idUniv)->groupBy('nomSite')->take(10)->get(); foreach ($sites as $value) { $jsonArr[] = array('value' => $value->nomSite); } } if ($term != null) { $villes = DB::table("ville")->distinct('nomVille')->where('nomVille', 'like', $term . '%')->take(10)->get(); foreach ($villes as $value) { $jsonArr[] = array('value' => $value->nomVille); } } return Response::json($jsonArr); }