if (mysqli_num_rows($res_grp) == 0) { $temoin_grp = "n"; } else { while ($lig_grp = mysqli_fetch_object($res_grp)) { $tab_id_groupe[] = $lig_grp->id_groupe; $tab_grp[$lig_grp->id_groupe] = get_group($lig_grp->id_groupe); } } } if ($temoin_grp == "y") { // Boucler sur les groupes pour extraire la liste des id_devoir,... $tab_id_dev[$id_classe[$i]][$tab_per[$j]] = array(); for ($k = 0; $k < count($tab_id_groupe); $k++) { // Indices id_classe, num_periode, id_groupe $tab_id_dev[$id_classe[$i]][$tab_per[$j]][$tab_id_groupe[$k]] = array(); $id_cahier_notes = get_id_cahier_notes($tab_id_groupe[$k], $tab_per[$j]); $sql = "SELECT DISTINCT cd.id AS id_dev, \n\t\t\t\t\t\t\t\t\t\t\tcd.nom_court AS nom_court_dev, \n\t\t\t\t\t\t\t\t\t\t\tcd.nom_complet AS nom_complet_dev, \n\t\t\t\t\t\t\t\t\t\t\tcd.date AS date_dev, \n\t\t\t\t\t\t\t\t\t\t\tcd.coef AS coef_dev, \n\t\t\t\t\t\t\t\t\t\t\tcd.note_sur \n\t\t\t\t\t\t\t\t\t\tFROM cn_devoirs cd,\n\t\t\t\t\t\t\t\t\t\t\tcn_conteneurs cc \n\t\t\t\t\t\t\t\t\t\tWHERE cc.id_racine='{$id_cahier_notes}' AND \n\t\t\t\t\t\t\t\t\t\t\tcc.id=cd.id_conteneur \n\t\t\t\t\t\t\t\t\t\tORDER BY date;"; //echo "$sql<br />"; $res_dev = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res_dev) > 0) { while ($lig_dev = mysqli_fetch_assoc($res_dev)) { $tab_id_dev[$id_classe[$i]][$tab_per[$j]][$tab_id_groupe[$k]][$lig_dev['id_dev']]['devoir'] = $lig_dev; $sql = "SELECT * FROM cn_notes_devoirs WHERE id_devoir='" . $lig_dev['id_dev'] . "';"; $res_notes_dev = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res_notes_dev) > 0) { while ($lig_notes_dev = mysqli_fetch_object($res_notes_dev)) { if (in_array($lig_notes_dev->login, $tab_ele)) { if ($lig_notes_dev->statut != "") { $current_note = $lig_notes_dev->statut; } else { $current_note = $lig_notes_dev->note;
/** * Retourne le tableau des notes de devoirs obtenues dans un groupe pour une période donnée * * @param integer $id_groupe identifant de groupe * @param integer $periode numero de periode * * @return array */ function get_tab_notes($id_groupe, $periode) { // En l'état ne pas laisser vide $periode $tab = array(); $id_cahier_notes = get_id_cahier_notes($id_groupe, $periode); if ($id_cahier_notes != "") { $sql = "SELECT * FROM cn_conteneurs WHERE id_racine='" . $id_cahier_notes . "';"; //echo "$sql<br />"; $res = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res) > 0) { while ($lig = mysqli_fetch_assoc($res)) { $tab['conteneur'][$lig['id']] = $lig; } } $sql = "SELECT * FROM cn_devoirs WHERE id_racine='" . $id_cahier_notes . "' ORDER BY id_conteneur, date;"; //echo "$sql<br />"; $res = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res) > 0) { while ($lig = mysqli_fetch_assoc($res)) { $tab['devoir'][$lig['id']] = $lig; $sql = "SELECT cnd.*,e.nom,e.prenom FROM cn_notes_devoirs cnd, eleves e WHERE id_devoir='" . $lig['id'] . "' AND cnd.login=e.login ORDER BY e.nom,e.prenom;"; //echo "$sql<br />"; $res2 = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res2) > 0) { while ($lig2 = mysqli_fetch_assoc($res2)) { $tab['devoir'][$lig['id']]['note'][$lig2['login']] = $lig2; } } } } } return $tab; }