} else { $donnees[$eleve_id]['sortie'] = ""; } // 20141105 if (isset($_POST['export_avec_resp'])) { //get_resp_from_ele_login($ele_login, $meme_en_resp_legal_0="n") //get_adresse_responsable($pers_id, $login_resp="") //responsables_adresses_separees($login_eleve) //$sql="SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r, eleves e WHERE e.login='******' AND rp.pers_id=r.pers_id AND r.ele_id=e.ele_id AND (r.resp_legal='1' OR r.resp_legal='2')"; $sql = "SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r, eleves e WHERE e.login='******' AND rp.pers_id=r.pers_id AND r.ele_id=e.ele_id AND r.resp_legal='1';"; //echo "$sql<br />"; $res_resp = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res_resp) > 0) { $tab_resp = mysqli_fetch_assoc($res_resp); $donnees[$eleve_id]['resp_legal'][1] = $tab_resp; $tab_adr = get_adresse_responsable($tab_resp['pers_id']); $donnees[$eleve_id]['resp_legal'][1]['adr1'] = $tab_adr['adr1']; $donnees[$eleve_id]['resp_legal'][1]['adr2'] = $tab_adr['adr2']; $donnees[$eleve_id]['resp_legal'][1]['adr3'] = $tab_adr['adr3']; $donnees[$eleve_id]['resp_legal'][1]['cp'] = $tab_adr['cp']; $donnees[$eleve_id]['resp_legal'][1]['commune'] = $tab_adr['commune']; $donnees[$eleve_id]['resp_legal'][1]['pays'] = $tab_adr['pays']; $donnees[$eleve_id]['resp_legal'][1]['en_ligne'] = $tab_adr['en_ligne']; } else { $donnees[$eleve_id]['resp_legal'][1]['pers_id'] = ""; $donnees[$eleve_id]['resp_legal'][1]['login'] = ""; $donnees[$eleve_id]['resp_legal'][1]['nom'] = ""; $donnees[$eleve_id]['resp_legal'][1]['prenom'] = ""; $donnees[$eleve_id]['resp_legal'][1]['civilite'] = ""; $donnees[$eleve_id]['resp_legal'][1]['tel_pers'] = ""; $donnees[$eleve_id]['resp_legal'][1]['tel_port'] = "";
function get_info_responsable($login_resp, $pers_id = "") { $tab = array(); if ($login_resp != "" || $pers_id != "") { if ($login_resp != "") { $sql = "SELECT * FROM resp_pers WHERE login='******';"; } elseif ($pers_id != "") { $sql = "SELECT * FROM resp_pers WHERE pers_id='{$pers_id}';"; } $res = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res) > 0) { $lig = mysqli_fetch_object($res); $tab['login'] = $lig->login; $tab['pers_id'] = $lig->pers_id; $tab['civilite'] = $lig->civilite; $tab['nom'] = $lig->nom; $tab['prenom'] = $lig->prenom; $tab['denomination'] = casse_mot($lig->nom, "maj") . " " . casse_mot($lig->prenom, "majf2"); $tab['civ_denomination'] = $tab['civilite'] . " " . $tab['denomination']; $tab['tel_pers'] = $lig->tel_pers; $tab['tel_port'] = $lig->tel_port; $tab['tel_prof'] = $lig->tel_prof; $tab['mel'] = $lig->mel; $tab['email'] = $lig->mel; $tab['adr_id'] = $lig->adr_id; $tab['adresse'] = get_adresse_responsable($lig->pers_id); $tab['enfants'] = get_enfants_from_pers_id($lig->pers_id); $tab['statut'] = "responsable"; } } return $tab; }
$tab_lignes_OOo_eleve["resp_nom"] = ""; $tab_lignes_OOo_eleve["resp_prenom"] = ""; $tab_lignes_OOo_eleve['resp_adr_id'] = ""; $tab_lignes_OOo_eleve['resp_adr1'] = ""; $tab_lignes_OOo_eleve['resp_adr2'] = ""; $tab_lignes_OOo_eleve['resp_adr3'] = ""; $tab_lignes_OOo_eleve['resp_cp'] = ""; $tab_lignes_OOo_eleve['resp_commune'] = ""; $tab_lignes_OOo_eleve['resp_pays'] = ""; $tab_lignes_OOo_eleve['resp_adr_en_ligne'] = ""; } else { $lig_resp = mysqli_fetch_object($res_resp); $tab_lignes_OOo_eleve['responsable']["civilite"] = $lig_resp->civilite; $tab_lignes_OOo_eleve['responsable']["nom"] = $lig_resp->nom; $tab_lignes_OOo_eleve['responsable']["prenom"] = $lig_resp->prenom; $tab_adr_courante = get_adresse_responsable($lig_resp->pers_id); $tab_lignes_OOo_eleve['responsable']["tab_adresse"] = $tab_adr_courante; $tab_lignes_OOo_eleve["resp_civilite"] = $lig_resp->civilite; $tab_lignes_OOo_eleve["resp_nom"] = $lig_resp->nom; $tab_lignes_OOo_eleve["resp_prenom"] = $lig_resp->prenom; $tab_lignes_OOo_eleve['resp_adr_id'] = $tab_adr_courante['adr_id']; $tab_lignes_OOo_eleve['resp_adr1'] = $tab_adr_courante['adr1']; $tab_lignes_OOo_eleve['resp_adr2'] = $tab_adr_courante['adr2']; $tab_lignes_OOo_eleve['resp_adr3'] = $tab_adr_courante['adr3']; $tab_lignes_OOo_eleve['resp_cp'] = $tab_adr_courante['cp']; $tab_lignes_OOo_eleve['resp_commune'] = $tab_adr_courante['commune']; $tab_lignes_OOo_eleve['resp_pays'] = $tab_adr_courante['pays']; $tab_lignes_OOo_eleve['resp_adr_en_ligne'] = $tab_adr_courante['en_ligne']; } $nb_ligne = 0; $res_incident = mysqli_query($GLOBALS["mysqli"], $sql);
$tab_lignes_OOo_eleve['responsable']["tab_adresse"]['adr_id']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['adr1']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['adr2']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['adr3']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['cp']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['commune']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['pays']=""; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]['en_ligne']=""; } else { $lig_resp=mysqli_fetch_object($res_resp); $tab_lignes_OOo_eleve['responsable']["civilite"]=$lig_resp->civilite; $tab_lignes_OOo_eleve['responsable']["nom"]=$lig_resp->nom; $tab_lignes_OOo_eleve['responsable']["prenom"]=$lig_resp->prenom; $tab_lignes_OOo_eleve['responsable']["tab_adresse"]=get_adresse_responsable($lig_resp->pers_id); } $nb_ligne=0; $res_incident=mysqli_query($GLOBALS["mysqli"], $sql); while($lig_incident=mysqli_fetch_object($res_incident)) { $tab_lignes_OOo[$nb_ligne]=array(); $tab_lignes_OOo[$nb_ligne]['etab']=getSettingValue("gepiSchoolName"); $tab_lignes_OOo[$nb_ligne]['acad']=getSettingValue("gepiSchoolAcademie"); $tab_lignes_OOo[$nb_ligne]['adr1']=getSettingValue("gepiSchoolAdress1")." ".getSettingValue("gepiSchoolAdress2"); $tab_lignes_OOo[$nb_ligne]['cp']=getSettingValue("gepiSchoolZipCode"); $tab_lignes_OOo[$nb_ligne]['ville']=getSettingValue("gepiSchoolCity"); $tab_lignes_OOo[$nb_ligne]['id_incident']=$lig_incident->id_incident; $tab_lignes_OOo[$nb_ligne]['declarant']=civ_nom_prenom($lig_incident->declarant,'');