function supprime_id($tableau_des_ids, $prefix_base, $table, $selection)
{
$id_init = '0';
while(!empty($tableau_des_ids[$id_init]))
{
// on attribue les variables
$id_selectionne = $tableau_des_ids[$id_init];
if ( isset($selection[$id_init]) and $selection[$id_init] != '' )
{
$cocher = 'oui';
}
else
{
$cocher = 'non';
}
// si les variables sont correct et non vide on continue
if(verif_texte($table) and verif_num($id_selectionne) and $id_selectionne != '' and $table != '' and $cocher === 'oui')
{
// on vérifie s'il y a du courrier
if ( $table === 'absences_eleves' )
{
modif_suivi_du_courrier($id_selectionne);
}
// suppression dans la table absence_rb
suppr_absences_rb($id_selectionne);
$requete = "DELETE
FROM ".$prefix_base.$table."
WHERE id_absence_eleve ='".$id_selectionne."'";
mysqli_query($GLOBALS["mysqli"], $requete) or die('Erreur SQL !'.$requete.'<br />'.mysqli_error($GLOBALS["mysqli"]));
}
$id_init = $id_init + 1;
}
}
$req_delete = "DELETE FROM ".$prefix_base."absences_eleves WHERE id_absence_eleve ='".$id_abs."'";
$req_sql2 = mysqli_query($GLOBALS["mysqli"], $req_delete);
// vérification du courrier lettre de justificatif
modif_suivi_du_courrier($id_abs, $eleve_absence_eleve);
} elseif(($d_date_absence_eleve_ins >= $data['d_date_absence_eleve'] and $d_date_absence_eleve_ins <= $data['a_date_absence_eleve']) and $a_date_absence_eleve_ins > $data['a_date_absence_eleve'])
{
$id_abs = $data['id_absence_eleve'];
// rédéfinie la date de debut
$d_date_absence_eleve_ins = $data['d_date_absence_eleve'];
$d_heure_absence_eleve_ins = $data['d_heure_absence_eleve'];
// supprime l'absences dans la base
$req_delete = "DELETE FROM ".$prefix_base."absences_eleves WHERE id_absence_eleve ='".$id_abs."'";
$req_sql2 = mysqli_query($GLOBALS["mysqli"], $req_delete);
// vérification du courrier lettre de justificatif
modif_suivi_du_courrier($id_abs, $eleve_absence_eleve);
} elseif($d_date_absence_eleve_ins < $data['d_date_absence_eleve'] and $a_date_absence_eleve_ins > $data['a_date_absence_eleve'])
{
$erreur = '1';
$verification = '10';
$texte_erreur="vous essayez d'enregistrer une absence dans un intervale de temps d'absence déja saisie";
$id_abs = $data['id_absence_eleve'];
$erreur_aff_d_date_absence_eleve = date_fr($data['d_date_absence_eleve']);
$erreur_aff_a_date_absence_eleve = date_fr($data['a_date_absence_eleve']);
$erreur_aff_d_heure_absence_eleve = $data['d_heure_absence_eleve'];
$erreur_aff_a_heure_absence_eleve= $data['a_heure_absence_eleve'];
/*
$id_abs = $data['id_absence_eleve'];
// supprime l'absences dans la base
$req_delete = "DELETE FROM ".$prefix_base."absences_eleves WHERE id_absence_eleve ='".$id_abs."'";
if($data['d_heure_absence_eleve'] <= $heuredebut_definie_periode_ins and $data['a_heure_absence_eleve'] >= $heurefin_definie_periode_ins) {
//on ne fait rien
} else {
if($data['d_heure_absence_eleve'] <= $heuredebut_definie_periode_ins and $data['a_heure_absence_eleve'] < $heurefin_definie_periode_ins) {
//Update de Fin
$id_abs = $data['id_absence_eleve'];
$miseajour='fin';
// vérification du courrier lettre de justificatif
modif_suivi_du_courrier($id_abs, $eleve_absent_ins);
}
if($data['d_heure_absence_eleve'] >= $heuredebut_definie_periode_ins and $data['a_heure_absence_eleve'] > $heurefin_definie_periode_ins) {
//Update de Début
$id_abs = $data['id_absence_eleve'];
$miseajour='debut';
// vérification du courrier lettre de justificatif
modif_suivi_du_courrier($id_abs, $eleve_absent_ins);
}
if($data['d_heure_absence_eleve'] > $heuredebut_definie_periode_ins and $data['a_heure_absence_eleve'] < $heurefin_definie_periode_ins) {
//Delete de l'enregistrement
$req_delete = "DELETE FROM absences_eleves WHERE id_absence_eleve ='".$id_abs."'";
$req_sql2 = mysqli_query($GLOBALS["mysqli"], $req_delete);
}
}
} // fin while ($data = mysql_fetch_array($resultat))
while ($data_retard = mysqli_fetch_array($resultat_retard)) {
if ($data_retard['d_heure_absence_eleve'] >= $heuredebut_definie_periode_ins and $data_retard['d_heure_absence_eleve'] <= $heurefin_definie_periode_ins) {
$id_ret = $data_retard['id_absence_eleve'];
// supprime le retard de la base
$req_delete = "DELETE FROM absences_eleves WHERE id_absence_eleve ='".$id_ret."'";
$req_sql2 = mysqli_query($GLOBALS["mysqli"], $req_delete);
