\n"; echo "\n"; echo "Gestion des projets 2000 du cours E72b\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

Gestion des projets 2000 du cours E72b

\n"; echo "
\n"; echo "


\n"; # se connecte a localhost (tecfasun1) avec l'identite de nobody mysql_pconnect( "localhost", "campus", "snowwhite") or die( "Unable to connect to SQL server"); # selectionne la bdd iconometre mysql_select_db("e72b") or die( "Unable to select database"); if (isset($mode)) { if ( $mode == "passTest" ) { if ( $password == 'iapiaget' ) { $start = 1; } } if ( $mode == "ChangeAnnee" ) { $start = 1; } if ( $mode == "modif" ) { if ( $projetIndex != '' ) { $modifOk = 1; $start = 1; } } if ( $mode == "put_modif" ) { if ( $projetNom != '' && $nom_1 != '' && $projetDescription != '' ) { $nbUser1 = 0; $nbUser2 = 0; $nbUser3 = 0; if ( $nom_1 != '' ) { if ( $user1_add == 0) { $query1 = "UPDATE users SET username='$nom_1',email='$email_1',homepage='$homepage_1',prenom='$prenom_1',nom='$nom_1' WHERE userId=$userId_1"; $result1 = mysql_query($query1); $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$nom_1' AND prenom='$prenom_1'"; $resultUser1 = mysql_query($queryUser1); $nbUser1 = mysql_result($resultUser1,0,'userId'); } else { $query1 = "INSERT INTO users VALUES (NULL,'$nom_1',PASSWORD(''),'$email_1','francais','$homepage_1',0,0,0,'0000-00-00','00:00:00','','$prenom_1','$nom_1','',0,0,'','$varannee')"; $result1 = mysql_query($query1); $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$nom_1' AND prenom='$prenom_1'"; $resultUser1 = mysql_query($queryUser1); $userId_1 = mysql_result($resultUser1,0,'userId'); $nbUser1 = $userId_1; } } else { $userId_1 = 0; } if ( $nom_2 != '' ) { if ( $user2_add == 0) { $query2 = "UPDATE users SET username='$nom_2',email='$email_2',homepage='$homepage_2',prenom='$prenom_2',nom='$nom_2' WHERE userId=$userId_2"; $result2 = mysql_query($query2); $queryUser2 = "SELECT DISTINCT userId FROM users WHERE username='$nom_2' AND prenom='$prenom_2'"; $resultUser2 = mysql_query($queryUser2); $userId_2 = mysql_result($resultUser2,0,'userId'); # echo $query2; } else { $query2 = "INSERT INTO users VALUES (NULL,'$nom_2',PASSWORD(''),'$email_2','francais','$homepage_2',0,0,0,'0000-00-00','00:00:00','','$prenom_2','$nom_2','',0,0,'','$varannee')"; $result2 = mysql_query($query2); $queryUser2 = "SELECT DISTINCT userId FROM users WHERE username='$nom_2' AND prenom='$prenom_2'"; $resultUser2 = mysql_query($queryUser2); $userId_2 = mysql_result($resultUser2,0,'userId'); } } else { $userId_2 = 0; } if ( $nom_3 != '' ) { if ( $user3_add == 0) { $query3 = "UPDATE users SET username='$nom_3',email='$email_3',homepage='$homepage_3',prenom='$prenom_3',nom='$nom_3' WHERE userId=$userId_3"; $result3 = mysql_query($query3); $queryUser3 = "SELECT DISTINCT userId FROM users WHERE username='$nom_3' AND prenom='$prenom_3'"; $resultUser3 = mysql_query($queryUser3); $userId_3 = mysql_result($resultUser3,0,'userId'); } else { $query3 = "INSERT INTO users VALUES (NULL,'$nom_3',PASSWORD(''),'$email_3','francais','$homepage_3',0,0,0,'0000-00-00','00:00:00','','$prenom_3','$nom_3','',0,0,'','$varannee')"; # echo $query3; $result3 = mysql_query($query3); $queryUser3 = "SELECT DISTINCT userId FROM users WHERE username='$nom_3' AND prenom='$prenom_3'"; $resultUser3 = mysql_query($queryUser3); $userId_3 = mysql_result($resultUser3,0,'userId'); } } else { $userId_3 = 0; } $queryProjetAll = "UPDATE projet SET projetId=$projetId,projetNom='$projetNom',userId_1=$userId_1,userId_2=$userId_2,userId_3=$userId_3,description='$projetDescription',url='$projetUrl',urlTecfa='$projetUrlTecfa' ,etat='$projetEtat' WHERE projetId=$projetId"; # echo $queryProjetAll; $resultProjetAll = mysql_query($queryProjetAll); if ($nbUser1 != 0 && $resultProjetAll) { $start = 1; $modifOk = 0; echo "
La mise à jour de l'entrée n° $projetId a été effectuée avec succès!

\n"; } else { $start = 1; $modifOk = 0; echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; } } else { $start = 1; $modifOk = 1; echo "
Vous devez remplir au minimum les trois champs suivants : le nom du projet, le participant n° 1 et une description du projet !
"; } } if ($mode=="deleteProjet") { $queryUserfind= "SELECT userId_1,userId_2,userId_3 FROM projet WHERE projetId='$projetIndex'"; $resultUserfind = mysql_query($queryUserfind); $userNb_1 = mysql_result($resultUserfind,0,'userId_1'); $userNb_2 = mysql_result($resultUserfind,0,'userId_2'); $userNb_3 = mysql_result($resultUserfind,0,'userId_3'); $query = "DELETE FROM projet WHERE projetId='$projetIndex'"; $result = mysql_query($query); if ($result) { echo "
La suppression du projet a fonctionné
\n"; $start = 1; $modifOk = 0; if ( $userNb_1 != 0 ) { $queryUserDel = "DELETE FROM users WHERE userId='$userNb_1'"; $resultUserDel = mysql_query($queryUserDel); if ( $resultUserDel ) { echo "
La suppression du Collaborateur 1 a fonctionné
\n"; } } if ( $userNb_2 != 0 ) { $queryUserDel = "DELETE FROM users WHERE userId='$userNb_2'"; $resultUserDel = mysql_query($queryUserDel); if ( $resultUserDel ) { echo "
La suppression du Collaborateur 2 a fonctionné
\n"; } } if ( $userNb_3 != 0 ) { $queryUserDel = "DELETE FROM users WHERE userId='$userNb_3'"; $resultUserDel = mysql_query($queryUserDel); if ( $resultUserDel ) { echo "
La suppression du Collaborateur 3 a fonctionné
\n"; } } } else { echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; $start = 1; $modifOk = 0; } } } ###Procedure qui test un mot de passe pour acceder aux modifications##### if ( $start == 0 ) { $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "

Cette page nécessite un mot de passe…\n"; echo "
\n"; echo "

Sélectionnez une volée :\n"; echo "
"; echo "

\n"; echo "

\n"; echo "
\n"; } else { ####Mot de passe de modifications accepte##### # se connecte a localhost (tecfasun1) avec l'identite de nobody mysql_pconnect( "localhost", "campus", "snowwhite") or die( "Unable to connect to SQL server"); # selectionne la bdd e72b mysql_select_db("e72b") or die( "Unable to select database"); $queryProjet = "SELECT DISTINCT projet.* FROM projet,users WHERE users.annee='$varannee' AND (users.userId=projet.userId_1 OR users.userId=projet.userId_2 OR users.userId=projet.userId_3) ORDER BY projetId"; $queryUserProjet = "SELECT DISTINCT * FROM users WHERE annee='$varannee' ORDER BY userId"; $resultProjet = mysql_query($queryProjet); $resultUserProjet = mysql_query($queryUserProjet); echo "

Données pour la volée $varannee

\n"; echo "
\n"; if (mysql_num_rows($resultProjet)) { $i=0; echo "\n"; while ($i < mysql_num_rows($resultProjet)) { $test_pair = $i%2; if ( $test_pair == 0) { $bgcolor = "#DDDDDD"; } else { $bgcolor = "#FFFFFF"; } $url = mysql_result($resultProjet,$i,'url'); $urlTecfa = mysql_result($resultProjet,$i,'urlTecfa'); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ($url != '') { echo "\n"; echo "\n"; echo "\n"; } else { echo "\n"; echo "\n"; echo "\n"; } if ($urlTecfa != '') { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } $participant_1 = mysql_result($resultProjet,$i,'userId_1'); $queryUser1Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_1"; $resultUser1Projet = mysql_query($queryUser1Projet); if ( $participant_1 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser1Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } $participant_2 = mysql_result($resultProjet,$i,'userId_2'); $queryUser2Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_2"; $resultUser2Projet = mysql_query($queryUser2Projet); if ( $participant_2 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser2Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } $participant_3 = mysql_result($resultProjet,$i,'userId_3'); $queryUser3Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_3"; $resultUser3Projet = mysql_query($queryUser3Projet); if ( $participant_3 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser3Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ( mysql_result($resultProjet,$i,'etat') == 'Rendu' ) { echo "\n"; echo "\n"; $i++; } echo "
"; echo "Numéro du projet : ".mysql_result($resultProjet,$i,'projetId')."."; echo "
"; echo "Nom du projet : ".mysql_result($resultProjet,$i,'projetNom').""; echo "
"; echo "Nom du projet : ".mysql_result($resultProjet,$i,'projetNom').""; echo "
"; echo "Emplacement du projet à Tecfa: ".$urlTecfa.""; echo "
"; echo "Participant au projet : ".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail) (userId = $participant_1)."; } else { echo "".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail) (userId = $participant_1)."; } echo "
"; echo "Participant au projet : ".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail) (userId = $participant_2)."; } else { echo "".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail). (userId = $participant_2)"; } echo "
"; echo "Participant au projet : ".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail) (userId = $participant_3)."; } else { echo "".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail) (userId = $participant_3)."; } echo "
"; echo "Description du projet : ".mysql_result($resultProjet,$i,'description'); echo "
"; echo "Etat du travail : ".mysql_result($resultProjet,$i,'etat')."

"; } else if ( mysql_result($resultProjet,$i,'etat') == 'Pas rendu' ) { echo "
".mysql_result($resultProjet,$i,'etat')."

"; } else { echo "
En cours de finition 

"; } echo "
\n"; } else { echo "


Aucun projet n'a encore été enregistré
\n"; } echo "
\n"; echo "

Modification de la base de données

\n"; if ( $modifOk == 0) { echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "N° du projet à modifier :

\n"; echo "
\n"; echo "\n"; echo "

Suppression d'un projet

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "N° du projet à supprimer :

\n"; echo "


\n"; echo "\n"; $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo "
\n"; echo "\n"; echo "

Sélection d'une autre volée :

\n"; echo ""; echo "

\n"; echo "

\n"; echo "
\n"; } else { $queryProjetModif = "SELECT DISTINCT * FROM projet WHERE projetId=$projetIndex"; $resultProjetModif = mysql_query($queryProjetModif); $userId_1 = mysql_result($resultProjetModif,0,'userId_1'); $userId_2 = mysql_result($resultProjetModif,0,'userId_2'); $userId_3 = mysql_result($resultProjetModif,0,'userId_3'); $tailleTD = 400; $tailleTD2 = tailleTD-10; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; if ( $userId_1 != 0 ) { echo ""; echo ""; echo "\n"; echo ""; } else { echo "\n"; echo ""; echo ""; echo "\n"; echo ""; } if ( $userId_2 != 0 ) { echo ""; echo ""; echo "\n"; echo ""; } else { echo "\n"; echo ""; echo ""; echo "\n"; echo ""; } if ( $userId_3 != 0 ) { echo ""; echo ""; echo "\n"; echo ""; } else { echo "\n"; echo ""; echo ""; echo "\n"; echo ""; } echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "
"; echo "N° du projet à modifier : \n"; echo "
\n"; echo "

\n"; echo "
\n"; echo "
"; echo "Nom du projet : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; $queryUserProjetModif = "SELECT DISTINCT * FROM users WHERE userId='".mysql_result($resultProjetModif,0,'userId_1')."'"; $resultUserProjetModif = mysql_query($queryUserProjetModif); echo "Participant n° 1 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; echo "Participant n° 1 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; $queryUserProjetModif = "SELECT DISTINCT * FROM users WHERE userId='".mysql_result($resultProjetModif,0,'userId_2')."'"; $resultUserProjetModif = mysql_query($queryUserProjetModif); echo "Participant n° 2 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; echo "Participant n° 2 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; $queryUserProjetModif = "SELECT DISTINCT * FROM users WHERE userId='".mysql_result($resultProjetModif,0,'userId_3')."'"; $resultUserProjetModif = mysql_query($queryUserProjetModif); echo "Participant n° 3 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; echo "Participant n° 3 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom :
Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "HomePage : \n"; echo "
\n"; echo "
"; echo "Description du projet : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "URL du projet : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "URL du projet à Tecfa : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "Etat du travail : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; } } echo "

Pour accéder au formulaire d'inscription des projets...

\n"; echo "

Pour accéder à la liste des projets avec leur description...

\n"; echo "

Didier Strasser / Didier.Strasser@pse.unige.ch\n"; echo "\n"; echo ""; ?>