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