1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| // Inclusion pdf
include("../pdf/creation_pdf.php");
// Instanciation de la classe dérivée
$pdf=new PDF();
$titre = "Annuaire interne de la mairie de Vigneux s/Seine";
$tcolor1 = 128;
$tcolor2 = 128;
$tcolor3 = 192;
$pdf->SetTitle($titre);
$pdf->AliasNbPages();
$pdf->AddPage();
$resultat = mysql_query($_POST["requete"],$base);
if(controle_table($resultat,$requete))
{
$pdf->SetDrawColor(51,153,102);
$ligne = 0;
while ($annuaire = mysql_fetch_array($resultat))
{
if ($ligne%38 == 0)
{
// Entêtes des colonnes
$pdf->SetFillColor(255,255,255);
$pdf->SetTextColor(51,153,102);
$pdf->SetFont('Arial','',10);
$pdf->Cell(30,6,"Nom",1,0,"C",1);
$pdf->Cell(30,6,"Prénom",1,0,"C",1);
$pdf->Cell(60,6,"Service",1,0,"C",1);
$pdf->Cell(25,6,"N° tél 1",1,0,"C",1);
$pdf->Cell(25,6,"N° tél 2",1,0,"C",1);
$pdf->Cell(25,6,"N° tél 3",1,1,"C",1);
$pdf->SetTextColor(128,128,192);
$pdf->SetFont('Arial','',7);
}
if ($ligne%2 == 0)
$pdf->SetFillColor(255,255,255);
else
$pdf->SetFillColor(255,255,213);
$ligne++;
// Calcul de la largeur du titre et positionnement
$w=$pdf->GetStringWidth($annuaire[annu_nom])+6;
// Ecriture des données dans cellules
$pdf->Cell(30,6,$annuaire[annu_nom],1,0,"",1);
$pdf->Cell(30,6,$annuaire[annu_prenom],1,0,"",1);
$pdf->Cell(60,6,$annuaire[annu_libserv],1,0,"",1);
$pdf->Cell(25,6,$annuaire[annu_tel1],1,0,"C",1);
$pdf->Cell(25,6,$annuaire[annu_tel2],1,0,"C",1);
$pdf->Cell(25,6,$annuaire[annu_tel3],1,1,"C",1);
}
}
$pdf->Output('annuaire.pdf','D'); |
Partager