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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
|
<?php
include("phpToPDF.php");
mysql_connect("localhost", "root", "");
mysql_select_db("alcatel");
$dateDebut='03.05.2010';
$dateFin='03.05.2010';
$reponse = mysql_query("SELECT * FROM planning WHERE ClassStartDate BETWEEN '$dateDebut' AND '$dateFin'");
$result = mysql_num_rows($reponse);
$PDF=new phpToPDF();
$PDF->AddPage(L);
$PDF->SetFont('Arial','B',16);
$PDF->MultiCell(0,10,"CALENDRIER DES STAGES",1,"C",0);
$PDF->MultiCell(0,10,"du $dateDebut Au $dateFin <ANNEE>",1,"C",0);
// Définition des propriétés du tableau.
$proprietesTableau = array(
'TB_ALIGN' => 'L',
'L_MARGIN' => 0,
'BRD_COLOR' => array(0,92,177),
'BRD_SIZE' => '0.3',
);
// Définition des propriétés du header du tableau.
$proprieteHeader = array(
'T_COLOR' => array(150,10,10),
'T_SIZE' => 12,
'T_FONT' => 'Arial',
'T_ALIGN' => 'C',
'V_ALIGN' => 'T',
'T_TYPE' => 'B',
'LN_SIZE' => 7,
'BG_COLOR_COL0' => array(170, 240, 230),
'BG_COLOR' => array(170, 240, 230),
'BRD_COLOR' => array(0,92,177),
'BRD_SIZE' => 0.2,
'BRD_TYPE' => '1',
'BRD_TYPE_NEW_PAGE' => '',
);
// Contenu du header du tableau.
$contenuHeader = array(
60,107, 60, 50,
colonne1, colonne2, colonne3, colonne4
);
while ($donnees = mysql_fetch_array($reponse))
{
// Définition des propriétés du reste du contenu du tableau.
$proprieteContenu = array(
'T_COLOR' => array(0,0,0),
'T_SIZE' => 10,
'T_FONT' => 'Arial',
'T_ALIGN_COL0' => 'L',
'T_ALIGN' => 'R',
'V_ALIGN' => 'M',
'T_TYPE' => '',
'LN_SIZE' => 6,
'BG_COLOR_COL0' => array(245, 245, 150),
'BG_COLOR' => array(255,255,255),
'BRD_COLOR' => array(0,92,177),
'BRD_SIZE' => 0.1,
'BRD_TYPE' => '1',
'BRD_TYPE_NEW_PAGE' => '',
);
// Contenu du tableau.
$contenuTableau = array(
$donnees['ClassNumber'], $donnees['CourseNumber2'], $donnees['LastName']." ".$donnees['FirstName'], $donnees['Room'],
);
$PDF->drawTableau($PDF, $proprietesTableau, $proprieteHeader, $contenuHeader, $proprieteContenu, $contenuTableau);
}
$PDF->Output();
?> |
Partager