Location: PHPKode > projects > EmploiNet : a timetable web manager > EmploiNet/v0.8.0/gdn/page1.php3
<?



	

	include("../BarreDeMenu.php3");

	

	include("../security.php");



// Entete

    buildHeader("Gestion des notes");



// Verification de la session

	$autorisation_list[0]=1; // Professeur

	$user_type = validateSession($id_session);

	if ($user_type == -1 || !security($id_session,$autorisation_list)) print("Accès refusé");

    else

    {

// Barre de menu

		buildMenuBar($id_session,$user_type,"gdn/page1.php3",false);

// Determination du id_user a l'aide du id_session

		$user_id = getUserID($id_session);

// Ouverture de la connexion

	    $connection = openConnection($databaseName);


	    if (!isset($index)) $index=0;


    print("<form name=\"form1\" action=\"\" method=post>\n");

    print("  <input type=\"hidden\" name=\"login\" value=\"$login\">\n");

if(isset($choice)){

    print("  <input type=\"hidden\" name=\"choice\" value=\"$choice\">\n");

}else{

    print("  <input type=\"hidden\" name=\"choice\" value=\"-1\">\n");

}

	print("  <input type=\"hidden\" name=\"index\" value=$index>\n");	// index=1 => etape de selection		

																		// index=2 => differentes epreuves

																		// index=3 => toutes les notes d'une epreuve

    print("  <input type=\"hidden\" name=\"id_session\" value=\"$id_session\">\n");

    print("  <input type=\"hidden\" name=\"user_type\" value=\"$user_type\">\n");

    print("  <input type=\"hidden\" name=\"user_id\" value=\"$user_id\">\n");

    print("  <input type=\"hidden\" name=\"display\" value=\"$display\">\n");





//***********************************************************************************************

//********			PREMIERE ETAPE : SELECTION DES MATIERE/PROMOTION/(GROUPE)			*********

//***********************************************************************************************

if($index==0 ){

    print("  <table align=center border=0 cellspacing=0 cellpading=0 bgcolor=\"#C0C000\">\n");



//***********************************************************************************************

//***************			liste des matieres dispo							*****************

//***********************************************************************************************



$result1 = mysql_query("SELECT DISTINCT matiere.id_matiere, matiere.nom FROM assurer, matiere WHERE assurer.id_professeur=$user_id AND assurer.id_matiere=matiere.id_matiere");



    print("  <tr>\n");

    print("    <td>\n");

    print("		<font size=3><i>Mati&egrave;re : </i></font> \n");

    print("    </td>\n");

    print("    <td>\n");

    //if($choice>=0) 

	//	print("		<SELECT SIZE=4 tabindex=-1 NAME=\"mat\" width=60 onChange=\"choice.value=0;index.value=0;promo.selectedIndex=-1;submit();\">  \n");

	//else

		print("		<SELECT SIZE=4 tabindex=-1 NAME=\"mat\" width=60 onChange=\"choice.value=0;index.value=0;submit();\">  \n");



	for($i=0;$i<mysql_num_rows($result1);$i++){

		$temp = mysql_fetch_row($result1);

		if(isset($mat) && $temp[0]==$mat)

		    print("	<OPTION SELECTED VALUE=$temp[0]> $temp[1] \n");

		else

		    print("	<OPTION VALUE=$temp[0]> $temp[1] \n");



	}

    print("		</SELECT>  \n");

    print("    </td>\n");

    print("  </tr>\n");



//***********************************************************************************************

//**  liste des promotions dont au moins un groupe voire toute la promo suit la matiere		*****

//***********************************************************************************************

if(isset($choice) && $choice>=0){



	$result2 = mysql_query("SELECT DISTINCT promotion.id_promotion, promotion.libelle FROM promotion, suiviparpromotion, suivipargroupe, associer WHERE (promotion.id_promotion=suiviparpromotion.id_promotion AND suiviparpromotion.id_matiere=$mat) OR (suivipargroupe.id_matiere=$mat AND suivipargroupe.id_groupe=associer.id_groupe AND associer.id_promotion=promotion.id_promotion) ");



    print("  <tr>\n");

    print("    <td>\n");

    print("		<font size=3><i>Promotion : </i></font> \n");

    print("    </td>\n");

    print("    <td>\n");

    print("		<SELECT SIZE=3 tabindex=-1 NAME=\"promo\" onChange=\"index.value=2;submit();\">  \n");

	for($i=0;$i<mysql_num_rows($result2);$i++){

		$temp = mysql_fetch_row($result2);

		if(isset($promo) && $temp[0]==$promo)

		    print("	<OPTION SELECTED VALUE=$temp[0]> $temp[1] \n");

		else

		    print("	<OPTION VALUE=$temp[0]> $temp[1] \n");

	}

    print("		</SELECT>  \n");

    print("    </td>\n");

    print("  </tr>\n");

}



	print("  </table>\n");

//***********************************************************************************************

//***************			boutons de validation de formulaire					*****************

//***********************************************************************************************

if($choice>=0){

	 print("  <table align=center border=0 cellspacing=0 cellpading=0>\n");

     print("  <tr valign=bottom>\n");

     print("    <td align=center colspan=3>\n");

     print("	 <table border=1 cellpading=0 cellspacing=0><tr><td>\n");

     print("      <table border=0 cellspacing=1 cellpading=0 align=center bgcolor=\"#FFFFD0\">\n");

     print("        <tr valign=middle align=center>\n");

     print("          <td width=40><input type=\"image\" src=\"img/NewButton.gif\" border=0 alt=\"Valider\" OnClick=\"index.value=2;submit();\"></td>\n");

	 print("          <td width=40></td>\n");

     print("          <td width=40><input type=\"image\" src=\"img/EraseButton.gif\" border=0 alt=\"Effacer\" OnClick=\"index.value=0;choice.value=-1;mat.selectedIndex=-1;submit();\"></td>\n");

     print("        </tr>\n");

     print("      </table>\n");

     print("    </td></tr></table>\n");

     print("    </td>\n");

     print("  </tr>\n");

	 print("</table>\n");

}



}// fin index==1



//***********************************************************************************************

//*****************				DEUXIEME ETAPE : LES DIFFÉRENTES NOTES			*****************

//***********************************************************************************************



if($index==2){

    print("  <input type=\"hidden\" name=\"mat\" value=\"$mat\">\n");

    print("  <input type=\"hidden\" name=\"promo\" value=\"$promo\">\n");

    print("  <input type=\"hidden\" name=\"id_typenote\" value=\"\">\n");

    print("  <input type=\"hidden\" name=\"id_note\" value=\"\">\n");

    print("  <input type=\"hidden\" name=\"id_groupe\" value=\"-1\">\n");



	// on regarde si la matiere est suivie par toute la promo ou seulement par un groupe => dans ce cas

	// on retient le numero du groupe concerné

	$les_groupes = mysql_query(" SELECT G.id_groupe, G.nom FROM groupe G, suivipargroupe SPG, associer A WHERE A.id_promotion=$promo AND A.id_groupe=SPG.id_groupe AND SPG.id_groupe=G.id_groupe AND SPG.id_matiere=$mat ");

	$nb_groupes = mysql_num_rows($les_groupes);  // nombre de groupes qui suivent la matiere (= 1 ou 0)

	if($nb_groupes==0){

		$id_groupe = -1;

		$nom_groupe = "toute la promotion";

	}else{

		$data = mysql_fetch_row($les_groupes);

		$id_groupe = $data[0];

		$nom_groupe = $data[1];

	}	



	// affichage du nom de la matiere et de la promotion :

	$result_b = mysql_query("SELECT matiere.nom, promotion.libelle FROM promotion, matiere WHERE promotion.id_promotion=$promo AND matiere.id_matiere=$mat");

	$infos = mysql_fetch_row($result_b);

	print(" <DIV ALIGN=center><B><I><U>Mati&egrave;re :</U> $infos[0]<br><U>Promotion :</U> $infos[1]<br> \n");

	if($id_groupe!=-1)	print("<U>Groupe concern&eacute; :</U> $nom_groupe<br>");

	print("</I></B></DIV> <br>\n");



	// on parcoure  les differents types de notes

	$result_b = mysql_query("SELECT * FROM typenote ORDER BY id_typenote");



	for($i=0;$i<mysql_num_rows($result_b);$i++){

			$tmp = mysql_fetch_row($result_b);

			$id_typ = $tmp[0];

			$TYP = strtoupper($tmp[1]);

			print("  <table align=center border=1 cellspacing=0 cellpading=0 width=642> <tr><td>\n");

			print("  <table align=center border=1 cellspacing=0 cellpading=0 width=640>\n");

			print("  <tr>\n");

			print("    <td COLSPAN=6 bgcolor=\"#C0C000\"> <font size=3><b> LES NOTES $TYP </b></font> </td> \n");

			print("  </tr>\n");

			print("  <tr>\n");

			print("    <td width=100 ><i> &nbsp;Libell&eacute;  </i></td> \n");

			print("    <td width=80 align=center><i> Concerne  </i></td> \n");

			print("    <td width=190 align=center><i> Date </i></td> \n");

			print("    <td width=70 align=center><i> Coefficient </i></td> \n");

			print("    <td width=80 align=center><i> Not&eacute; sur  </i></td> \n");

			print("    <td width=120 align=center> &nbsp; </td> \n");

			print("  </tr>\n");



			// on recherche toutes les notes de la matiere choisie pour la promotion choisie et le type de note en cours



			// requete pour les notes se rapportant a toute la promo :

			if($id_groupe==-1){

				$result = mysql_query("SELECT DISTINCT note.id_note, note.id_matiere, note.id_typenote, note.libelle, note.coefficient, note.rapport, DATE_FORMAT(note.date,'%d/%m/%Y') FROM note, suiviparpromotion ANAP WHERE note.id_matiere=$mat AND note.id_typenote=$id_typ AND ANAP.id_matiere=$mat AND ANAP.id_promotion=$promo");

			}else{

				$result = mysql_query("SELECT DISTINCT note.id_note, note.id_matiere, note.id_typenote, note.libelle, note.coefficient, note.rapport, DATE_FORMAT(note.date,'%d/%m/%Y') FROM note, suivipargroupe ANAP WHERE note.id_matiere=$mat AND note.id_typenote=$id_typ AND ANAP.id_matiere=$mat AND ANAP.id_groupe=$id_groupe");

			}



			$num=0;

			while($num<mysql_num_rows($result)){

				$data = mysql_fetch_row($result);

				$id_note      = $data[0];

				$id_matiere   = $data[1];

				$id_typenote  = $data[2];

				$libelle      = $data[3];

				$coefficient  = $data[4];

				$rapport      = $data[5];

				$date         = $data[6];



				$nomVariable = $id_typ . "_" . $id_note;

				print("  <tr>\n");

				//print("    <td> &nbsp; <INPUT type=button value=\"(...)\"  onClick=\"index.value=3;id_typenote.value=$id_typ;id_note.value=$id_note;submit();\"><font face=\"arial\" size=2>$libelle</font> </td> \n");

				// quand on clique suur le libelle de la note on accede a la partie suivante : 

				// saisie / visionnage des notes correspondant a l'epreuve

				print("    <td> &nbsp; <a href=\"Javascript:document.form1.index.value=3;document.form1.id_typenote.value=$id_typ;document.form1.id_note.value=$id_note;document.form1.id_groupe.value=$id_groupe;document.form1.submit();\"><font face=\"arial\" size=2><b>$libelle</b></font></a> </td> \n");



				print("	   <td > <font face=\"arial\" size=2>&nbsp;");

				if($id_groupe!=-1) print("groupe ");

				print("$nom_groupe</font></td>  \n");



				print("    <td align=center> <font face=\"arial\" size=2>$date &nbsp;</font> </td> \n");

				print("    <td align=center> <INPUT type=text name=\"coefficient_$nomVariable\" size=4 VALUE=\"$coefficient\"> </td> \n");

			    print("    <td align=center> <INPUT type=text name=\"rapport_$nomVariable\" size=4 VALUE=\"$rapport\"> </td> \n");



				print("    <td align=center> <font face=\"arial\" size=1><a href=\"Javascript:document.form1.index.value=4;document.form1.choice.value=1;document.form1.id_typenote.value=$id_typ;document.form1.id_note.value=$id_note;document.form1.submit();\">modifier</a> | ");

				print("     <a href=\"Javascript:document.form1.index.value=4;document.form1.choice.value=2;document.form1.id_typenote.value=$id_typ;document.form1.id_note.value=$id_note;document.form1.submit();\">supprimer</a> </font></td> ");



				print("  </tr>\n");



				$num++;

			}

				// FERME UN TABLEAU (AVEC UNE LIGNE DE SAISIE POUR EVENTUELLEMENT AJOUTER DES NOTES)

			print("  <tr>\n");

		    print("    <td> &nbsp; <INPUT type=text name=\"libelle_$id_typ\" size=8>  </td> \n");



		    print("    <td align=left> <INPUT TYPE=hidden name=\"groupe_$id_typ\" value=\"$id_groupe\"><font face=\"arial\" size=2>&nbsp;");

			if($id_groupe!=-1) print("groupe ");

			print("$nom_groupe</font></td>  \n");



			print("    <td align=center> <SELECT name=\"jour_$id_typ\">  \n");

			for($j=01;$j<=31;$j++)	print("			<OPTION VALUE=$j>$j \n");

			print("			</SELECT>  \n");

		    print("			<SELECT name=\"mois_$id_typ\">  \n");

			for($j=01;$j<=12;$j++)	print("			<OPTION VALUE=$j>$j \n");

			print("			</SELECT>  \n");

		    print("			<SELECT name=\"annee_$id_typ\">  \n");

			for($j=2001;$j<=2050;$j++)	print("			<OPTION VALUE=$j>$j \n");

			print("			</SELECT>  \n");

			print("    </td> \n");

		    print("    <td align=center> <INPUT type=text name=\"coefficient_$id_typ\" size=4 VALUE=\"1\"> </td> \n");

		    print("    <td align=center> <INPUT type=text name=\"rapport_$id_typ\" size=4 VALUE=\"20\"> </td> \n");



			print("    <td align=center> <font face=\"arial\" size=1> <a href=\"Javascript:document.form1.index.value=4;document.form1.choice.value=3;document.form1.id_typenote.value=$id_typ;document.form1.submit();\">a j o u t e r</a> </td> \n");

		    print("  </tr>\n");

			print(" </TABLE>	</td></tr></TABLE> <BR> \n");

	}// for



}// fin index=2



//***********************************************************************************************

//************			TROISIEME ETAPE : TOUTES LES NOTES D'UNE EPREUVE		*****************

//***********************************************************************************************



if($index==3){

    print("  <input type=\"hidden\" name=\"mat\" value=\"$mat\">\n");

    print("  <input type=\"hidden\" name=\"promo\" value=\"$promo\">\n");

    print("  <input type=\"hidden\" name=\"id_typenote\" value=\"$id_typenote\">\n");

    print("  <input type=\"hidden\" name=\"id_note\" value=\"$id_note\">\n");

    print("  <input type=\"hidden\" name=\"id_groupe\" value=\"$id_groupe\">\n");



	

	// on recherche les caracteristiques de l'epreuve + la liste de tous les etudiants :

	if($id_groupe==-1){			// CAS N°1 : MATIERE SUIVIE PAR TOUTE LA PROMOTION

		$res = mysql_query("SELECT TN.libelle, N.libelle, FLOOR(N.coefficient), FLOOR(N.rapport), DATE_FORMAT(N.date,'%d/%m/%Y'), M.nom, P.libelle  FROM note N, typenote TN, matiere M, promotion P  WHERE N.id_note=$id_note AND TN.id_typenote=$id_typenote AND M.id_matiere=$mat AND P.id_promotion=$promo");



		$result = mysql_query("SELECT E.id_etudiant, UPPER(E.nom), E.prenom FROM etudiant E, appartient AP, associer ASS WHERE E.id_etudiant=AP.id_etudiant AND AP.id_groupe=ASS.id_groupe AND ASS.id_promotion=$promo ORDER BY E.nom, E.prenom");

	}else{						// CAS N°2 : MATIERE SUIVI SEULEMENT PAR GROUPE

		$res = mysql_query("SELECT TN.libelle, N.libelle, FLOOR(N.coefficient), FLOOR(N.rapport), DATE_FORMAT(N.date,'%d/%m/%Y'), M.nom, P.libelle, G.nom  FROM note N, typenote TN, matiere M, promotion P, groupe G  WHERE N.id_note=$id_note AND TN.id_typenote=$id_typenote AND M.id_matiere=$mat AND P.id_promotion=$promo AND G.id_groupe=$id_groupe");



		$result = mysql_query("SELECT E.id_etudiant, UPPER(E.nom), E.prenom FROM etudiant E, appartient AP WHERE E.id_etudiant=AP.id_etudiant AND AP.id_groupe=$id_groupe ORDER BY E.nom, E.prenom");

	}

	$la_note = mysql_fetch_row($res);

	$nbre = mysql_num_rows($result); // nbre d'etudiants concernés





	print(" <DIV align=center> <H3>Saisie des notes : $la_note[1] </H3><H4> $la_note[0] du $la_note[4] - coeff $la_note[2], note/$la_note[3]</H4></DIV> \n");

	print(" <I><u>Mati&egrave;re :</u> $la_note[5] <BR> <u>Promotion :</u> $la_note[6]</I>  <BR> \n");

	if($id_groupe!=-1)	print("  <I><u>Groupe :</u> $la_note[7]</I> <br> \n");

	print("  <br>  \n");



	print("  <table align=center border=1 cellspacing=0 cellpading=0 width=600>\n");

	print("  <tr> <td COLSPAN=4 bgcolor=\"#C0C000\"> <font size=3><b> Les notes de l'&eacute;preuve </b></font>  \n");

	print("  </td></tr>\n");

	print("  <tr>\n");

	print("    <td width=300 align=center><i> Nom & Pr&eacute;nom </i></td> \n");

	print("    <td width=100 align=center><i> Note </i> <INPUT type=hidden name=\"nombre\" value=\"$nbre\"> </td> \n");

	print("    <td width=100 align=center><i> Absent </i></td> \n");

	print("    <td width=100 align=center><i><font color=red> D&eacute;faillant </font></i></td> \n");

	print("  </tr>\n");



	

	for($n=0;$n<mysql_num_rows($result);$n++){

		$un_etudiant = mysql_fetch_row($result);



		// on regarde si l'etudiant a deja une note

		$temp = mysql_query("SELECT note FROM avoirUneNote WHERE id_note=$id_note AND id_etudiant=$un_etudiant[0]");

		print("  <tr>\n");

		print("    <td > $un_etudiant[1] $un_etudiant[2]</td> \n");

		if(mysql_num_rows($temp)!=0){

			$la_note_etudiant=mysql_fetch_row($temp); 

			if($la_note_etudiant[0]!=-1 && $la_note_etudiant[0]!=-2)

				print("    <td align=center> <INPUT type=hidden name=\"id_etudiant_$n\" value=\"$un_etudiant[0]\"> <INPUT type=text name=\"note_etudiant_$n\" size=10 value=\"$la_note_etudiant[0]\"></td> \n");

			else

				print("    <td align=center> <INPUT type=hidden name=\"id_etudiant_$n\" value=\"$un_etudiant[0]\"> <INPUT type=text name=\"note_etudiant_$n\" size=10 value=\"\"></td> \n");



			if($la_note_etudiant[0]==-1)

				print("    <td align=center><INPUT type=checkbox name=\"abs_etudiant_$n\" checked> </td> \n");

			else

				print("    <td align=center><INPUT type=checkbox name=\"abs_etudiant_$n\"> </td> \n");



			if($la_note_etudiant[0]==-2)

				print("    <td align=center><INPUT type=checkbox name=\"def_etudiant_$n\" checked> </td> \n");

			else

				print("    <td align=center><INPUT type=checkbox name=\"def_etudiant_$n\"> </td> \n");

		}else{

			print("    <td align=center> <INPUT type=hidden name=\"id_etudiant_$n\" value=\"$un_etudiant[0]\"> <INPUT type=text name=\"note_etudiant_$n\" size=10></td> \n");

			print("    <td align=center><INPUT type=checkbox name=\"abs_etudiant_$n\"> </td> \n");

			print("    <td align=center><INPUT type=checkbox name=\"def_etudiant_$n\"> </td> \n");

		}



		print("  </tr>\n");

	}

	print(" </TABLE> \n");

	print(" <br> \n");

	print("  <DIV align=center> <INPUT type=button value=\"Valider\" onClick=\"index.value=5;submit();\"> </DIV> \n");

	

	// A SUIVRE ...



}// fin index=3



//***********************************************************************************************

//********		INDEX = 4 : MODIFICATION, SUPPRESSION OU AJOUT D'UNE EPREUVE		*************

//***********************************************************************************************



if($index==4){





    print("  <input type=\"hidden\" name=\"mat\" value=\"$mat\">\n");

    print("  <input type=\"hidden\" name=\"promo\" value=\"$promo\">\n");

    print("  <input type=\"hidden\" name=\"id_typenote\" value=\"$id_typenote\">\n");

    print("  <input type=\"hidden\" name=\"id_note\" value=\"$id_note\">\n");

    print("  <input type=\"hidden\" name=\"id_groupe\" value=\"$id_groupe\">\n");



	switch($choice){

		case 1 : //MODIFICATION D'UNE EPREUVE

					$coeff = "$" . "coefficient_" . $id_typenote . "_" . $id_note;

					$rapp = "$" . "rapport_" . $id_typenote . "_" . $id_note;

					eval( "\$coeff = \"$coeff\";" );

					eval( "\$rapp = \"$rapp\";" );

					mysql_query("UPDATE note SET coefficient=$coeff, rapport=$rapp WHERE id_note=$id_note"); 

					break;

		case 2 : //SUPPRESSION D'UNE EPREUVE

					mysql_query("DELETE FROM note WHERE id_note=$id_note");

					mysql_query("DELETE FROM avoirUneNote WHERE id_note=$id_note");

					break;

		case 3 : //AJOUT D'UNE EPREUVE

					$lib = "$" . "libelle_" . $id_typenote ;

					$groupe = "$" . "groupe_" . $id_typenote ;

					$jour = "$" . "jour_" . $id_typenote ;

					$mois = "$" . "mois_" . $id_typenote ;

					$annee = "$" . "annee_" . $id_typenote ;

					$coeff = "$" . "coefficient_" . $id_typenote ;

					$rapp = "$" . "rapport_" . $id_typenote ;

					eval( "\$lib = \"$lib\";" );

					eval( "\$groupe = \"$groupe\";" );

					eval( "\$jour = \"$jour\";" );

					eval( "\$mois = \"$mois\";" );

					eval( "\$annee = \"$annee\";" );

					eval( "\$coeff = \"$coeff\";" );

					eval( "\$rapp = \"$rapp\";" );

					$date = $annee . "-" . $mois . "-" . $jour ;

					mysql_query("INSERT INTO note VALUES ('','$mat','$id_typenote','$lib','$coeff','$rapp','$date')");

					$numero_note = mysql_insert_id();

					break;

	}





	print(" <SCRIPT LANGUAGE=javascript> \n");

	print("		document.form1.index.value=\"2\"; \n");		//	IL FAUT RECHARGER LE FORMULAIRE

	print("		document.form1.submit(); \n");

	print(" </SCRIPT> \n");

	print("  \n");





}// fin index=4



//***********************************************************************************************

//**************		INDEX = 5 : INSERTION / MODIFICATION DES NOTES SAISIES		*************

//***********************************************************************************************



if($index==5){





    print("  <input type=\"hidden\" name=\"mat\" value=\"$mat\">\n");

    print("  <input type=\"hidden\" name=\"promo\" value=\"$promo\">\n");

    print("  <input type=\"hidden\" name=\"id_typenote\" value=\"$id_typenote\">\n");

    print("  <input type=\"hidden\" name=\"id_note\" value=\"$id_note\">\n");

    print("  <input type=\"hidden\" name=\"id_groupe\" value=\"$id_groupe\">\n");



	for($i=0;$i<$nombre;$i++){

		$id_etudiant = "$" . "id_etudiant_" . $i ;

		$note_etudiant = "$" . "note_etudiant_" . $i ;

		$absent = "$" . "abs_etudiant_" . $i ;

		$defaillant = "$" . "def_etudiant_" . $i ;



		eval( "\$id_etudiant = \"$id_etudiant\";" );

		eval( "\$note_etudiant = \"$note_etudiant\";" );

		eval( "\$absent = \"$absent\";" );

		eval( "\$defaillant = \"$defaillant\";" );



		mysql_query("DELETE FROM avoirUneNote WHERE id_etudiant=$id_etudiant AND id_note=$id_note");

		if($defaillant=='on'){

			mysql_query("INSERT INTO avoirUneNote VALUES ('$id_etudiant', '$id_note', '-2')");

		}else{

			if($absent=='on')

				mysql_query("INSERT INTO avoirUneNote VALUES ('$id_etudiant', '$id_note', '-1')");

			else{

				if($note_etudiant!="")

					mysql_query("INSERT INTO avoirUneNote VALUES ('$id_etudiant', '$id_note', '$note_etudiant')");

				

			}

		}

	}



	print(" <SCRIPT LANGUAGE=javascript> \n");

	print("		document.form1.index.value=\"2\"; \n");	//		IL FAUT RECHARGER LE FORMULAIRE

	print("		document.form1.submit(); \n");

	print(" </SCRIPT> \n");

	print("  \n");



}// fin index=5





    print("</form> \n");



//***********************************************************************************************

//*		INDEX = 2 - suite : bouton d'acces a la suite (apercu de ttes les notes + moyennes)	 ****

//***********************************************************************************************



if($index==2){

    print("<form name=\"form2\" action=\"moyenne.php3\" method=post>\n");



    print("  <input type=\"hidden\" name=\"login\" value=\"$login\">\n");

	print("  <input type=\"hidden\" name=\"index\" value=\"1\">\n");	

    print("  <input type=\"hidden\" name=\"id_session\" value=\"$id_session\">\n");

    print("  <input type=\"hidden\" name=\"user_type\" value=\"$user_type\">\n");

    print("  <input type=\"hidden\" name=\"user_id\" value=\"$user_id\">\n");

    print("  <input type=\"hidden\" name=\"display\" value=\"$display\">\n");

    print("  <input type=\"hidden\" name=\"mat\" value=\"$mat\">\n");

    print("  <input type=\"hidden\" name=\"promo\" value=\"$promo\">\n");

    print("  <input type=\"hidden\" name=\"id_groupe\" value=\"$id_groupe\">\n");



	print("  <input type=button value=\"aperçu g&eacute;n&eacute;ral / calcul des moyennes\" onClick=\"submit();\"> \n");

	

	print("</form> \n");

}



//***********************************************************************************************

//***********************************************************************************************

//***********************************************************************************************

}

	

	buildEndOfPage();	



?>

Return current item: EmploiNet : a timetable web manager