} 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,'');
