} //echo "<option value='$lig_class->id'>" . htmlspecialchars("$lig_class->classe") . "</option>\n"; echo "<a href='" . $_SERVER['PHP_SELF'] . "?id_classe={$lig_class->id}" . $ajout_href_2 . "'>" . htmlspecialchars("{$lig_class->classe}") . "</a><br />\n"; $tab_classe[$lig_class->id] = $lig_class->classe; $cpt++; } echo "</td>\n"; echo "</tr>\n"; echo "</table>\n"; } // Tableau des PP echo "<a name='liste_pp'></a>\n<div align='center'>\n\t<table class='boireaus boireaus_alt'>\n\t\t<tr>\n\t\t\t<th>Classe</th>\n\t\t\t<th>\n\t\t\t\t<div style='float:right; width:16px'><a href='" . $_SERVER['PHP_SELF'] . "?export_prof_suivi=y&export=csv' class='noprint' title=\"Exporter l'équipe au format CSV (tableur)\" target='_blank'><img src='../images/icons/csv.png' class='icone16' alt='CSV' /></a></div>\n\t\t\t\t" . ucfirst(getSettingValue('gepi_prof_suivi')) . "\n\t\t\t</th>\n\t\t</tr>"; $tab_pp = get_tab_prof_suivi(); foreach ($tab_classe as $current_id_classe => $current_classe) { echo "\n\t\t<tr>\n\t\t\t<td>{$current_classe}</td>\n\t\t\t<td>"; if (isset($tab_pp[$current_id_classe])) { for ($loop = 0; $loop < count($tab_pp[$current_id_classe]); $loop++) { if ($loop > 0) { echo "<br />"; } $designation_user = civ_nom_prenom($tab_pp[$current_id_classe][$loop]); echo "<div style='float:right; width:16px'>" . affiche_lien_mailto_si_mail_valide($tab_pp[$current_id_classe][$loop], $designation_user) . "</div>"; echo $designation_user; } } echo "</td>\n\t\t</tr>"; } echo "\n\t</table>\n</div>"; } echo "<p><br /></p>\n"; require "../lib/footer.inc.php";
function affiche_tableau_pp($tab_classe = array()) { if (count($tab_classe) == 0) { if ($_SESSION['statut'] == 'scolarite') { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c, j_scol_classes jsc WHERE jsc.id_classe=c.id AND jsc.login='******'login'] . "' ORDER BY classe"; } if ($_SESSION['statut'] == 'professeur') { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c,j_groupes_classes jgc,j_groupes_professeurs jgp WHERE jgp.login = '******'login'] . "' AND jgc.id_groupe=jgp.id_groupe AND jgc.id_classe=c.id ORDER BY c.classe"; } if ($_SESSION['statut'] == 'cpe') { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c,j_eleves_cpe jec,j_eleves_classes jecl WHERE jec.cpe_login = '******'login'] . "' AND jec.e_login=jecl.login AND jecl.id_classe=c.id ORDER BY c.classe"; } if ($_SESSION['statut'] == 'administrateur') { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c ORDER BY c.classe"; } if ($_SESSION['statut'] == 'scolarite' && getSettingValue("GepiAccesVisuToutesEquipScol") == "yes") { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c ORDER BY c.classe"; } if ($_SESSION['statut'] == 'cpe' && getSettingValue("GepiAccesVisuToutesEquipCpe") == "yes") { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c ORDER BY c.classe"; } if ($_SESSION['statut'] == 'professeur' && getSettingValue("GepiAccesVisuToutesEquipProf") == "yes") { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c ORDER BY c.classe"; } if ($_SESSION['statut'] == 'autre' && acces('/groupes/visu_profs_class.php', 'autre')) { $sql = "SELECT DISTINCT c.id,c.classe FROM classes c ORDER BY c.classe"; } $result_classes = mysqli_query($GLOBALS["mysqli"], $sql); $nb_classes = mysqli_num_rows($result_classes); $tab_classe = array(); if (mysqli_num_rows($result_classes) > 0) { $nb_classes = mysqli_num_rows($result_classes); while ($lig_class = mysqli_fetch_object($result_classes)) { $tab_classe[$lig_class->id] = $lig_class->classe; } } } $retour = "\n\t<table class='boireaus boireaus_alt'>\n\t\t<tr>\n\t\t\t<th>Classe</th>\n\t\t\t<th>\n\t\t\t\t" . ucfirst(getSettingValue('gepi_prof_suivi')) . "\n\t\t\t</th>\n\t\t</tr>"; $tab_pp = get_tab_prof_suivi(); foreach ($tab_classe as $current_id_classe => $current_classe) { $retour .= "\n\t\t<tr>\n\t\t\t<td>{$current_classe}</td>\n\t\t\t<td>"; if (isset($tab_pp[$current_id_classe])) { for ($loop = 0; $loop < count($tab_pp[$current_id_classe]); $loop++) { if ($loop > 0) { $retour .= "<br />"; } $designation_user = civ_nom_prenom($tab_pp[$current_id_classe][$loop]); $retour .= "<div style='float:right; width:16px'>" . affiche_lien_mailto_si_mail_valide($tab_pp[$current_id_classe][$loop], $designation_user) . "</div>"; $retour .= $designation_user; } } $retour .= "</td>\n\t\t</tr>"; } $retour .= "\n\t</table>"; return $retour; }