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 84 85 86 87 88 89
| <?php
session_start();
require('../fpdf.php');
//Connexion a la base
mysql_connect('localhost','root','mdp');
mysql_select_db('pharma');
$sql_annee = "SELECT Nom_complet FROM annees WHERE NOM_ANNEE = '".$_SESSION['choix_annee']."'";
$req_annee = mysql_query($sql_annee);
$annee = mysql_fetch_array($req_annee);
//$sql_table_decisions = "SELECT * FROM decisions WHERE NOM_ANNEE = '".$_SESSION['choix_annee']."'";
$sql_table_decisions = "SELECT decisions.*, NOM_ET, PRENOM_ET FROM decisions INNER JOIN etudiants ON decisions.MATRICULE_ET = etudiants.MATRICULE_ET WHERE NOM_ANNEE = '".$_SESSION['choix_annee']."'";
//echo $sql_table_decisions;
$req_table_decisions = mysql_query($sql_table_decisions);
$table_decisions = mysql_fetch_array($req_table_decisions);
class PDF extends FPDF
{
//En-tete
function Header()
{
//Logo
$this->Image('../../Images/logo.png',10,8,17);
//Police Arial gras 15
$this->SetFont('Arial','B',12);
//Décalage a droite
$this->Cell(80);
$this->Ln(20);
}
}
function ImprovedTable($header,$data)
{
//Largeurs des colonnes
$w=array(40,75,75,30,30);
//En-tête
for($i=0;$i<count($header);$i++)
$this->Cell($w[$i],7,$header[$i],1,0,'C');
$this->Ln();
//Données
foreach($data as $row)
{
$this->Cell($w[0],6,$row[0],'LR');
$this->Cell($w[1],6,$row[1],'LR');
$this->Cell($w[2],6,number_format($row[2],0,',',' '),'LR',0,'R');
$this->Cell($w[3],6,number_format($row[3],0,',',' '),'LR',0,'R');
$this->Ln();
}
//Trait de terminaison
$this->Cell(array_sum($w),0,'','T');
}
//Instanciation de la classe dérivée
$pdf=new PDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',12);
$pdf->Cell(30,10,'Institut de Pharmacie : '. $annee['Nom_complet'],0,'C');
$pdf->Ln(5);
$pdf->Cell(30,10,'Université Libre de Bruxelles',0,'C');
$pdf->Ln(5);
$pdf->Cell(30,10,'Délibération du : '.$table_decisions['Date_delibe'],0,'C');
$pdf->Ln(15);
$pdf->Cell(30,10,'Informations de l\'étudiant : ',0,'C');
$pdf->Ln(5);
$pdf->Cell(30,10,$table_decisions['MATRICULE_ET']. ' ' . $table_decisions['NOM_ET']. ' ' . $table_decisions['PRENOM_ET'],0,'C');
//Titres des colonnes
$header=array('Mnémonique','Intitulé du cours','Nom du/des Professeur(s)','TH (sur 20)','TP(sur 20)');
//Chargement des données
$data=$pdf->LoadData($table_decisions);
$pdf->SetFont('Arial','',14);
$pdf->AddPage();
$pdf->BasicTable($header,$data);
$pdf->AddPage();
$pdf->ImprovedTable($header,$data);
$pdf->AddPage();
$pdf->FancyTable($header,$data);
$pdf->AliasNbPages();
$pdf->Output();
?> |
Partager