} $ident_ville = $cp_responsable[$i][0]." ".strtoupper($ville_responsable[$i][0]); if($adresse2_responsable[$i][0] != "") { $pdf->Text(109, 55,($ident_ville)); } else { $pdf->Text(109, 50,($ident_ville)); } $pdf->SetFont('DejaVu','',12); $pdf->Text(20, 70,'Madame, Monsieur,'); $ident = "Voici le suivi de l'élève ".$nom_eleve[$i]." ".$prenom_eleve[$i]." de la classe de ".$division[$i].","; $pdf->Text(20, 80, ($ident)); $pdf->Text(20, 85,('sur la période du '.date_frl(date_sql($du))." au ".date_frl(date_sql($au)).".")); //tableau $pdf->SetX(30); $pdf->SetY(90); $pdf->SetFont('DejaVu','',9.5); $pdf->Cell(55, 5, 'Les Absences', 0, 1, '', ''); $pdf->Cell(55, 5, 'Du', 1, 0, '', ''); $pdf->Cell(55, 5, 'Au', 1, 0, '', ''); $pdf->Cell(22, 5, 'Motif', 1, 0, 'C', ''); $pdf->Cell(54, 5, ('le motif spécifié'), 1, 1, 'C', ''); $requete_1 ="SELECT * FROM ".$prefix_base."absences_eleves, ".$prefix_base."eleves WHERE ((d_date_absence_eleve >= '".date_sql($du)."' AND d_date_absence_eleve <= '".date_sql($au)."') OR (a_date_absence_eleve >= '".date_sql($du)."' AND a_date_absence_eleve <= '".date_sql($au)."')) AND type_absence_eleve = 'A' AND eleve_absence_eleve=login AND login='******'"; $execution_1 = mysqli_query($GLOBALS["mysqli"], $requete_1) or die('Erreur SQL !'.$requete_1.'<br />'.mysqli_error($GLOBALS["mysqli"])); while ( $data_1 = mysqli_fetch_array($execution_1)) { //tableau des absences $pdf->SetFont('DejaVu','',9.5); $debut = date_frc($data_1['d_date_absence_eleve'])." à ".heure($data_1['d_heure_absence_eleve']);
$nb_debut = 0; $nb_fin = 0; // compteur du passage des entree $cpt = 0; while ( $page < $nb_page ) { $pdf->AddPage(); /* *********************************** */ /* DEBUT - ENTETE */ $pdf->SetFont('DejaVu','',12); $pdf->SetY(20); $pdf->SetX(65); $pdf->SetFont('DejaVu','B',18); $pdf->Cell(0, 6, 'RELEVE DES ABSENCES', 0, 1, 'C', ''); $pdf->SetFont('DejaVu','',10); if ( $absencenj === '1' ) { $pdf->SetX(65); $pdf->Cell(0, 4, 'avec option absence sans justification', 0, 1, 'C', ''); } if ( $retardnj === '1' ) { $pdf->SetX(65); $pdf->Cell(0, 4, 'avec option retard sans justification', 0, 1, 'C', ''); } $pdf->SetFont('DejaVu','',14); $duu = "du ".date_frl(date_sql($du)); $auu = "au ".date_frl(date_sql($au)); $pdf->SetX(65); $pdf->Cell(0, 8, $duu, 0, 1, 'C', ''); if ($du != $au)