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" ); |
