/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $universites = Universite::all(); $user = User::find($id); if (Auth::user()->site_id == null) { $idUniversite = 0; $sites = null; $site = 0; } else { $idUniversite = DB::table('universite')->join('site', 'site.universite_id', '=', 'universite.universite_id')->join('users', 'users.site_id', '=', 'site.site_id')->select('universite.universite_id')->where('users.id', $id)->get()[0]->universite_id; $sites = DB::table('universite')->join('site', 'site.universite_id', '=', 'universite.universite_id')->select('site.*')->where('universite.universite_id', $idUniversite)->get(); $site = DB::table('users')->join('site', 'users.site_id', '=', 'site.site_id')->select('site.*')->where('users.id', $id)->get()[0]->site_id; } return view('dashboard.profile.universite', ['user' => $user, 'universites' => $universites, 'sites' => $sites, 'siteCourant' => $site, 'universiteCourante' => $idUniversite]); }
/** * 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); }
/** * Run the database seeds. * * @return void */ public function run() { Universite::create(['idUniv' => 1, 'nomUniv' => 'Aix Marseille Université', 'adr1Univ' => 'adresse', 'adr2Univ' => NULL, 'telUniv' => '0411223344', 'mailUniv' => '*****@*****.**', 'photoUniv' => NULL, 'logoUniv' => NULL, 'latUniv' => NULL, 'longUniv' => NULL, 'inseeVille' => 13001]); Universite::create(['idUniv' => 2, 'nomUniv' => 'Avignon Université', 'adr1Univ' => 'adresse 2', 'adr2Univ' => NULL, 'telUniv' => '0411223344', 'mailUniv' => '*****@*****.**', 'photoUniv' => NULL, 'logoUniv' => NULL, 'latUniv' => NULL, 'longUniv' => NULL, 'inseeVille' => 84007]); }
public function getList() { $sites = Site::all(); $universites = Universite::all(); return view('backoffice.sites', compact("sites", "universites")); }
public function add(Request $request) { $universite = Universite::create(['nomUniv' => $request->input('nomUniv'), 'adr1Univ' => $request->input('adr1Univ'), 'adr2Univ' => $request->input('adr2Univ'), 'telUniv' => $request->input('telUniv'), 'mailUniv' => $request->input('mailUniv'), 'photoUniv' => $request->input('photoUniv'), 'logoUniv' => $request->input('logoUniv'), 'latUniv' => $request->input('latUniv'), 'longUniv' => $request->input('longUniv'), 'inseeVille' => $request->input('inseeVille')]); $universite->save(); return redirect()->route('backuniv'); }