public function get_UeUserList_csv($id)
{
if (!(Helpers::isProf() || Helpers::isSecr())) {
return redirect('/');
}
$ue = Ue::FindOrFail($id);
$parcours_ue = $ue->parcours_ues->first();
$output = fopen('php://memory', 'w');
$filename = $ue->intitule . '.csv';
// output the column headings
fputcsv($output, array($ue->intitule), ';');
fputcsv($output, array('Nom', 'Prénom', '@mail', 'actif'), ';');
// loop over the rows, outputting them
foreach ($parcours_ue->choixes as $choix) {
$user = $choix->user;
fputcsv($output, array($user->nom, $user->prenom, $user->mail, $user->actif), ';');
}
// reset the file pointer to the start of the file
fseek($output, 0);
// tell the browser it's going to be a csv file
header('Content-Type: application/csv');
// tell the browser we want to save it instead of displaying it
header('Content-Disposition: attachment; filename="' . $filename . '";');
// make php send the generated csv lines to the browser
fpassthru($output);
return null;
}
public function update_user_post(Request $request, $id)
{
$user = Auth::user();
if ($user->profil->intitule == "administrateur") {
$erreurs = new Collection();
$this->validate($request, ['nom' => 'required', 'prenom' => 'required', 'mail' => 'required', 'login' => 'required|min:8', 'mdp2' => 'min:8', 'profil' => 'exists:profil,id']);
$user = User::find($id);
$users = User::all();
foreach ($users as $u) {
if ($request->input('login') != $user->login) {
if ($request->input('login') == $u->login) {
$erreurs->prepend("Ce login existe déjà !");
break;
}
}
}
foreach ($users as $u) {
if ($request->input('mail') != $user->mail) {
if ($request->input('mail') == $u->mail) {
$erreurs->prepend("Cet email existe déjà !");
break;
}
}
}
$user->parcours_id = null;
$user->groupe_id = null;
$user->profil_id = null;
$user->nom = $request->input('nom');
$user->prenom = $request->input('prenom');
$user->mail = $request->input('mail');
$user->login = $request->input('login');
if ($request->input('mdp2')) {
$user->mdp = $request->input('mdp2');
}
if ($request->input('actif') == 1) {
$user->actif = $request->input('actif');
} else {
$user->actif = 0;
}
if ($request->input('parcours') != 0) {
$user->parcours_id = $request->input('parcours');
}
if ($request->input('groupe') != 0) {
$user->groupe_id = $request->input('groupe');
$user->parcours_id = Groupe::find($request->input('groupe'))->parcours->id;
}
if (count($erreurs) > 0) {
$parcours = Parcours::all();
$profils = Profil::all();
$groupes = Groupe::all();
$ues = Ue::all();
return response()->view('auth/update_compte', ['erreurs' => $erreurs, 'parcours' => $parcours, 'profils' => $profils, 'groupes' => $groupes, 'ues' => $ues, 'user' => $user]);
}
if ($request->input('profil') != 0) {
$user->profil_id = $request->input('profil');
}
$user->save();
if (count($request->input('ues')) > 0) {
$user->uesEnseignees()->detach();
foreach ($request->input('ues') as $ue_id) {
$enseigner = new Enseigner();
$enseigner->user_id = $user->id;
$enseigner->ue_id = $ue_id;
$enseigner->save();
}
}
return redirect('admin/user');
}
return "Vous êtes pas administrateur";
}
public function post_DeleteConfirm(Ue $ue)
{
if (!Helpers::isAdmin()) {
return redirect('/');
}
$text = $ue->intitule . " à été supprimée";
Choix::parUe($ue->id)->delete();
$ue->delete();
return view('confirmation', compact('text'));
}
