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