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
| <?php
ob_start();
session_start();
// Exemple de génération de devis/facture PDF
define('FPDF_FONTPATH','font/');
include("connection.inc.php");
require('invoice.php');
//Select the Products you want to show in your PDF file
$result=mysql_query("select adress_client,code_postal,civilite,ville,pays,nom,quantite,quantite2,date,interets_tracteur,interets_camion,interets_voiture from contact WHERE idcontact='".$_SESSION['idcontact']."' ORDER BY nom");
$number_of_contact = mysql_numrows($result);
//For each row, add the field to the corresponding column
while($row = mysql_fetch_array($result))
{
$adress_client = $row["adress_client"];
$code_postal
= $row["code_postal"];
$civilite
= $row["civilite"];
$ville = $row["ville"];
$pays
= $row["pays"];
$nom = $row["nom"];
$quantite = $row["quantite"];
$quantite2 = $row["quantite2"];
$date
= $row["date"];
$interets_tracteur
= $row["interets_tracteur"];
$interets_camion
= $row["interets_camion"];
$interets_voiture
= $row["interets_voiture"];
}
mysql_close();
$pdf = new INVOICE( 'P', 'mm', 'A4' );
$pdf->Open();
$pdf->AddPage();
$pdf->addSociete( "MaSociete",
"$tel\n" .
"75000 PARIS\n".
"$tel\n" .
"Capital : 18000 " . EURO );
$pdf->fact_dev( "Devis ", "TEMPO" );
$pdf->temporaire("");
$pdf->addDate($date);
$pdf->addClientAdresse($nom."\n".$adress_client."\n".$code_postal."\n".$ville."\n".$pays);
$pdf->addClient();
$pdf->addPageNumber("1");
$pdf->addReglement("Chèque à réception de facture");
$pdf->addEcheance($date);
$pdf->addNumTVA("FR888777666");
$pdf->addReference("Devis ... du ....");
$cols=array( "REFERENCE" => 23,
"DESIGNATION" => 78,
"QUANTITE" => 22,
"P.U. HT" => 26,
"MONTANT H.T." => 30,
"TVA" => 11 );
$pdf->addCols( $cols);
$cols=array( "REFERENCE" => "L",
"DESIGNATION" => "L",
"QUANTITE" => "C",
"P.U. HT" => "R",
"MONTANT H.T." => "R",
"TVA" => "C" );
$pdf->addLineFormat( $cols);
$pdf->addLineFormat($cols);
$y = 109;
$line = array( "REFERENCE" => "REF1",
"DESIGNATION" => "$interets_tracteur\n",
"QUANTITE" => "$quantite\n",
"P.U. HT" => "600.00",
"MONTANT H.T." => "700.00",
"TVA" => "1" );
$size = $pdf->addLine( $y, $line );
$y += $size + 2;
$line = array( "REFERENCE" => "REF2",
"DESIGNATION" => "$interets_voiture\n",
"QUANTITE" => "$interets\n",
"P.U. HT" => "10.00",
"MONTANT H.T." => "60.00",
"TVA" => "1" ); |
Partager