示例#1
0
文件: bilan.php 项目: rhertzog/lcs
	$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']);
            $pdf->Cell(55, 5, ($debut), 0, 0, '', '');
示例#2
0
	$page = 0;
	$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', '');