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;
}
