echo_debug_itop("{$sql}<br />");
$res_ele = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_ele) > 0) {
$temoin_eleve_associe = "y";
$cpt_ele = 0;
while ($lig_ele = mysqli_fetch_object($res_ele)) {
if ($cpt_ele > 0) {
echo "<br />";
}
echo $lig_ele->nom . " " . $lig_ele->prenom;
$tab_classe = get_class_from_ele_login($lig_ele->login);
if (isset($tab_classe['liste_nbsp'])) {
echo " (<em>" . $tab_classe['liste_nbsp'] . "</em>)";
}
$sql = "SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r WHERE r.pers_id=rp.pers_id AND r.ele_id='{$lig_ele->ele_id}' AND rp.nom='" . mysqli_real_escape_string($GLOBALS["mysqli"], $nom_courant) . "' AND rp.prenom='" . mysqli_real_escape_string($GLOBALS["mysqli"], $prenom_courant) . "' AND rp.login!='';";
echo_debug_itop("{$sql}<br />");
$res_resp = mysqli_query($GLOBALS["mysqli"], $sql);
if (mysqli_num_rows($res_resp) > 0) {
while ($lig_resp = mysqli_fetch_object($res_resp)) {
if (!in_array($lig_resp->login, $tab_resp_login)) {
$tab_resp_login[] = $lig_resp->login;
$tab_resp[$cpt_resp]['login'] = $lig_resp->login;
$tab_resp[$cpt_resp]['civilite'] = $lig_resp->civilite;
$tab_resp[$cpt_resp]['nom'] = $lig_resp->nom;
$tab_resp[$cpt_resp]['prenom'] = $lig_resp->prenom;
$tab_resp[$cpt_resp]['resp_legal'] = $lig_resp->resp_legal;
$tab_resp[$cpt_resp]['info'] = $lig_resp->civilite . " " . casse_mot($lig_resp->nom, 'maj') . " " . casse_mot($lig_resp->prenom, 'majf2');
$tab_resp[$cpt_resp]['info'] .= " (N° " . $lig_resp->pers_id . ")";
$tab_resp[$cpt_resp]['info'] .= " (Légal " . $lig_resp->resp_legal . ")";
$cpt_resp++;
}
// Si la chaine est vide, proposer un champ TEXT
if($chaine!="") {
$sql="SELECT e.* FROM eleves e, sso_table_correspondance s WHERE ($chaine) AND e.login=s.login_gepi ORDER BY e.nom, e.prenom;";
echo_debug_itop("$sql<br />");
$res_ele=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($res_ele)>0) {
$temoin_eleve_associe="y";
$cpt_ele=0;
while($lig_ele=mysqli_fetch_object($res_ele)) {
if($cpt_ele>0) {echo "<br />";}
echo $lig_ele->nom." ".$lig_ele->prenom;
$tab_classe=get_class_from_ele_login($lig_ele->login);
if(isset($tab_classe['liste_nbsp'])) {echo " (<em>".$tab_classe['liste_nbsp']."</em>)";}
$sql="SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r WHERE r.pers_id=rp.pers_id AND r.ele_id='$lig_ele->ele_id' AND rp.nom='".mysqli_real_escape_string($GLOBALS["mysqli"], $nom_courant)."' AND rp.prenom='".mysqli_real_escape_string($GLOBALS["mysqli"], $prenom_courant)."' AND rp.login!='';";
echo_debug_itop("$sql<br />");
$res_resp=mysqli_query($GLOBALS["mysqli"], $sql);
if(mysqli_num_rows($res_resp)>0) {
while($lig_resp=mysqli_fetch_object($res_resp)) {
if(!in_array($lig_resp->login, $tab_resp_login)) {
$tab_resp_login[]=$lig_resp->login;
$tab_resp[$cpt_resp]['login']=$lig_resp->login;
$tab_resp[$cpt_resp]['civilite']=$lig_resp->civilite;
$tab_resp[$cpt_resp]['nom']=$lig_resp->nom;
$tab_resp[$cpt_resp]['prenom']=$lig_resp->prenom;
$tab_resp[$cpt_resp]['resp_legal']=$lig_resp->resp_legal;
$tab_resp[$cpt_resp]['info']=$lig_resp->civilite." ".casse_mot($lig_resp->nom,'maj')." ".casse_mot($lig_resp->prenom,'majf2');
$tab_resp[$cpt_resp]['info'].=" (N° ".$lig_resp->pers_id.")";
$tab_resp[$cpt_resp]['info'].=" (Légal ".$lig_resp->resp_legal.")";
$cpt_resp++;
