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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| <?php
require('../fpdf.php');
class PDF extends FPDF
{
// Pied de page
function Footer()
{
// Positionnement à 1,5 cm du bas
$this->SetY(-13);
// Police Arial italique 8
$this->SetFont('Arial','',9);
// Numéro de page
$this->Cell(0,10,'A : 73, rue Vergniaud, 75013 Paris, France | T : +33 (1) 83 64 42 52 | M : diagram@diagramarchitectes.fr | S : www.diagramarchitectes.fr',0,0,'C');
}
}
$pdf = new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
require_once('../includes/connexion.inc.php');
$id=isset($_GET['id'])?mysql_real_escape_string($_GET['id']):'';
if(empty($id)){
header('location: index.php?code=idVide');
exit();
}
$sql = mysql_query("SELECT projets.*, projets.id AS projet FROM projets WHERE projets.id=$id", $connect);
$sql1 = mysql_query("SELECT projets.*, medias.* FROM projets
JOIN medias ON projets.id = $id
WHERE type='diaporama' AND nom_projet = nom_ref LIMIT 0,1", $connect);
while ($row = mysql_fetch_array($sql)) {
$nom_projet = $row["nom_projet"];
$annee = $row["annee"];
$lieu = $row["lieu"];
$programme = $row["programme"];
$maitrise_ouvrage = $row["maitrise_ouvrage"];
$equipe = $row["equipe"];
$type_mission = $row["type_mission"];
$superficie = $row["superficie"];
$montant = $row["montant"];
$description = $row["description"];
$description = strip_tags($description);
// titre en gras
$pdf->Image('../medias/images/logo_diagram.jpg',10,10,50);
$pdf->SetFont('Arial','B',20);
$pdf->Write(55,utf8_decode($nom_projet));
$pdf->Ln();
// titre en gras
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,utf8_decode('Année : '));
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($annee));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Lieu : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($lieu));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Programme : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($programme));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Maitrise d\'ouvrage : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($maitrise_ouvrage));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Type de mission : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($type_mission));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Superficie : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($superficie));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,'Montant : ');
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($montant));
$pdf->Ln();
$pdf->SetFont('Arial','B',10);
$pdf->Write(5,utf8_decode('Équipe : '));
$pdf->SetFont('Arial','',10);
$pdf->Write(5,utf8_decode($equipe));
$pdf->Ln();
$pdf->Ln();
// description
$pdf->SetFont('Arial','',9);
$pdf->MultiCell(0,5,utf8_decode($description));
$pdf->Ln();
$pdf->Ln();
}
while ($row1 = mysql_fetch_array($sql1)) {
$fichier=$row1["fichier"];
$pdf->Image('../medias/images/fiche_projet/'.$row1['fichier'].'',10,45,100);
}
// sortie du fichier
$pdf->Output('Projet Diagram.pdf', 'I');
?> |
Partager