1)&&($_SESSION['droits']<>2)&&($_SESSION['droits']<>3)&&($_SESSION['droits']<>8)) { header("Location: ../index.php");};
require_once('../Connections/conn_cahier_de_texte.php');
require_once('../inc/functions_inc.php');
$editFormAction = '#';
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
$datetoday=date('y-m-d');
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_RsClasse = "SELECT * FROM cdt_classe ORDER BY nom_classe ASC";
$RsClasse = mysql_query($query_RsClasse, $conn_cahier_de_texte) or die(mysql_error());
$row_RsClasse = mysql_fetch_assoc($RsClasse);
$totalRows_RsClasse = mysql_num_rows($RsClasse);
$i=1;
do
{
$indcl_id[$i]=$row_RsClasse['ID_classe'];
$i=$i+1;
}while ($row_RsClasse = mysql_fetch_assoc($RsClasse)) ;
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_Rsgroupe = "SELECT * FROM cdt_groupe ORDER BY ID_groupe ASC";
$Rsgroupe = mysql_query($query_Rsgroupe, $conn_cahier_de_texte) or die(mysql_error());
$row_Rsgroupe = mysql_fetch_assoc($Rsgroupe);
$totalRows_Rsgroupe = mysql_num_rows($Rsgroupe);
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1") && (isset($_GET['ID_gic']))) {
if ($_SESSION['droits']==1){$num_prof=$_POST['num_prof'];} else {$num_prof=$_SESSION['ID_prof'];};
$nom_gic= str_replace(array("/", "&", "\'"), "-",$_POST['nom_gic']);
$nom_gic= trim(str_replace('"',' ',$nom_gic));
$nom_gic= trim(str_replace("'","-",$nom_gic));
$updateSQL = sprintf(" UPDATE `cdt_groupe_interclasses` SET prof_ID=%u , nom_gic=%s , commentaire_gic =%s WHERE ID_gic=%u ",
GetSQLValueString($num_prof, "int"),
GetSQLValueString($nom_gic, "text"),
GetSQLValueString($_POST['commentaire_gic'],"text"),
GetSQLValueString($_GET['ID_gic'],"int")
);
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$Result1 = mysql_query($updateSQL, $conn_cahier_de_texte) or die(mysql_error());
//on efface
if ((isset($_GET['ID_gic'])) && ($_GET['ID_gic'] != "")) {
$deleteSQL = sprintf("DELETE FROM cdt_groupe_interclasses_classe WHERE gic_ID=%u",
GetSQLValueString($_GET['ID_gic'], "int"));
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$Result1 = mysql_query($deleteSQL, $conn_cahier_de_texte) or die(mysql_error());
}
$UID=mysql_insert_id();
$nblign=$_POST['nb_classes'];
for ($i=1; $i<=$totalRows_RsClasse; $i++) {
$refclasse='classe'.$i;
$refgroupe='groupe'.$i;
if (isset($_POST[$refclasse])&&(isset($_POST[$refgroupe])) &&($_POST[$refclasse]=='on')){
$insertSQL2= sprintf("INSERT INTO `cdt_groupe_interclasses_classe` ( `gic_ID` , `classe_ID`, `groupe_ID`) VALUES ('%s', '%s', '%s');",$_GET['ID_gic'],$indcl_id[$i], $_POST[$refgroupe]);
$Result2 = mysql_query($insertSQL2, $conn_cahier_de_texte) or die(mysql_error());
}//du if
}//du for
if (isset($_POST['gic_eleves']) ){
//on efface les references ele_gic
$deleteSQL_ele_gic = sprintf("DELETE FROM `ele_gic` WHERE ID_gic=%u",
GetSQLValueString($_GET['ID_gic'], "int"));
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$Result_del_ele_gic = mysql_query($deleteSQL_ele_gic, $conn_cahier_de_texte) or die(mysql_error());
foreach( $_POST['gic_eleves'] as $gic_eleve ) {
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$insertSQL_ele_gic = sprintf("INSERT INTO `ele_gic` ( `ID_ele`, `ID_gic`) VALUES ( '%s', '%s');", GetSQLValueString($gic_eleve, "int") , GetSQLValueString($_GET['ID_gic'], "int") );
//print $insertSQL_ele_gic ."
";
$Result_ele_gic = mysql_query($insertSQL_ele_gic, $conn_cahier_de_texte) or die(mysql_error());
}
}
if (($_SESSION['droits']==1)||($_SESSION['droits']==3)){
$insertGoTo="../inc/regroupement_liste.php";}
else {
$insertGoTo = "groupe_interclasses_ajout.php";
};
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_RsModifgic =sprintf("SELECT * FROM cdt_groupe_interclasses,cdt_prof WHERE ID_gic=%u AND cdt_groupe_interclasses.prof_ID = cdt_prof.ID_prof ",GetSQLValueString($_GET['ID_gic'], "int") );
$RsModifgic = mysql_query($query_RsModifgic, $conn_cahier_de_texte) or die(mysql_error());
$row_RsModifgic = mysql_fetch_assoc($RsModifgic);
$totalRows_RsModifgic = mysql_num_rows($RsModifgic);
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_Rsgic =sprintf("SELECT * FROM cdt_groupe_interclasses WHERE prof_ID=%u ",$row_RsModifgic['ID_prof']);
$Rsgic = mysql_query($query_Rsgic, $conn_cahier_de_texte) or die(mysql_error());
$row_Rsgic = mysql_fetch_assoc($Rsgic);
$totalRows_Rsgic = mysql_num_rows($Rsgic);
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_Rsdest =sprintf("SELECT * FROM cdt_groupe_interclasses_classe WHERE gic_ID=%u ",$_GET['ID_gic'] );
//print $query_Rsdest ;
$Rsdest = mysql_query($query_Rsdest, $conn_cahier_de_texte) or die(mysql_error());
$row_Rsdest = mysql_fetch_assoc($Rsdest);
$totalRows_Rsdest = mysql_num_rows($Rsdest);
//print $totalRows_Rsdest . "
";
// Gestion des gic avec le module d'absence
if ( (isset($_SESSION['module_absence'])) && ($_SESSION['module_absence']=='Oui')) {
// On recupere les eleves selectionnes
$selected_eles = array();
mysql_select_db($database_conn_cahier_de_texte, $conn_cahier_de_texte);
$query_Rsele_select_classe = sprintf("SELECT gic.ID_ele FROM `ele_gic` as gic, `ele_liste` as ele WHERE gic.ID_ele = ele.ID_ele AND ID_gic='%s'", GetSQLValueString($_GET['ID_gic'], "int") );
$Rsele_select_classe = mysql_query($query_Rsele_select_classe, $conn_cahier_de_texte) or die(mysql_error());
//$row_Rsele_select_classe = mysql_fetch_assoc($Rsele_select_classe);
//$totalRows_Rsele_select_classe = mysql_num_rows($Rsele_select_classe);
while (($row_rq = mysql_fetch_array($Rsele_select_classe , MYSQL_ASSOC) )) {
array_push( $selected_eles , $row_rq['ID_ele'] );
}
$classes = array();
mysql_data_seek($Rsdest,0) ;
while (($row_rq = mysql_fetch_array($Rsdest , MYSQL_ASSOC) )) {
array_push( $classes , $row_rq['classe_ID'] );
}
// print_r($classes );
$in_classes = join(" ,", $classes) ;
mysql_data_seek($Rsdest, 0);
// echo $in_classes ;
}
?>