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
|
<?php
require('tableau2.php');
include ('../includes/Connexion.php');
$pdf=new PDF_MC_Table();
$pdf->AddPage();
$pdf->SetFont('times','',20); // police, taille
$mid_x = 100; // the middle of the "PDF screen", fixed by now.
$text = ' TABLEAU DES COMPETENCES DE JULIE';
$pdf->Text($mid_x - ($pdf->GetStringWidth($text) / 2), 20, $text); // centrer le texte
$pdf->Ln(18); // saut de ligne
// *********************** PROJETS ******************
$pdf->SetFont('times','B',14); // police : times, gras, taille 14
$pdf->SetWidths(array(90,50,50)); // taille des cellules
$pdf->SetLineWidth(0.3); // Epaisseur du cadre (0.5 mm)
srand(microtime()*1000000);
$pdf->Row(array("", "Stage 2012", "Stage 2013")); // texte des cellules
/********************2e colonne*************************/
$pdf->SetWidths(array(20,70,25,25,25,25));
srand(microtime()*1000000);
$pdf->SetFont('times','B',10);
$pdf->Row(array("Code Activite","Activite", "Eval du Prof", "Eval de l'eleve", "Eval du prof", "Eval de l'élève"));
$resultat = $connexion->query("SELECT projact.NumDom, projact.NumProc, projact.NumAct, LibAct, Prof, Eleve FROM activite, projact WHERE activite.NumAct=projact.NumAct AND activite.NumProc=projact.NumProc AND activite.NumDom=projact.NumDom AND IdProjet=1");
$resultat2 = $connexion->query("SELECT projact.NumDom, projact.NumProc, projact.NumAct, LibAct, Prof, Eleve FROM activite, projact WHERE activite.NumAct=projact.NumAct AND activite.NumProc=projact.NumProc AND activite.NumDom=projact.NumDom AND IdProjet=2");
$pdf->SetFont('times','',10);
while ($ligne = $resultat->fetch(PDO::FETCH_OBJ))
{
$ligne2 = $resultat2->fetch(PDO::FETCH_OBJ);
$code = $ligne->NumProc." ".$ligne->NumDom." ".$ligne->NumAct;
$activite = $ligne->LibAct;
$prof1 = $ligne->Prof ;
$prof2 = $ligne2->Prof;
$eleve1 = $ligne->Eleve;
$eleve2 = $ligne2->Eleve;
$pdf->Row(array($code, $activite, $prof1, $eleve1, $prof2, $eleve2 ));
}
$pdf->write(1,html_entity_decode($activite));
$pdf->Output();
?> |
Partager