fhumanes author
In other articles I have explained how we can generate an invoice (example of dynamic document chosen for the example) in Word format and / or Excel format.
Also, then I exposed and showed how we can do a webservices to convert any MS Office document to PDF (I am very proud of this solution).
The webservices is dependent on S.O. Windows and the process has a response time that is not immediate at all.
So, many people and myself, we had as pending look for a solution that would allow us to create quality documents, directly in PDF, quickly and easily.
To make it quick and easy, I have decided that we should start with a PDF template, which would greatly simplify having documents with very good quality and that we should not have to start with a "blank sheet", because that would mean that the PHP programmer would be designing PDF documents in a slow and very artisanal way.
On the Internet there are many libraries for PHP to create and modify PDF files, but in this case I have selected the Setasin solution https://www.setasign.com/products/fpdi/about/ because there is a company currently active and It perfectly matched the functionality that I wanted to incorporate into the example.
To make the PDF template I used Excel (it can be done with almost any software but Excel is one of the best solutions).
I started from the template I had for the solution to create excel, but I had to define multiple invoice lines, since this solution does not allow dynamic template objects (this is one of the limitations of using PDF templates, but it is which most closely resembles the classic solution of paper forms.
In the use of the library, we must specify the X and Y coordinates (in points) where we want to enter the texts.
Almost all viewers / reader of PDF files have the option to measure. I have used the Foxit Reader solution https://www.foxitsoftware.com/pdf-reader/, but everyone should use what they find most comfortable.
The product used tells me that each page has the size of 595.32 X 841.92 (dots).
When we use the measuring tool it indicates the distance in X axis or Y axis from one point to another. This is very important since to position the data in the template we will have to indicate the X and Y coordinates from the point 0,0.
This is an image of an example output.
Things we have to keep in mind:
<?php
require_once __DIR__ . '/../../ComponentCode/fpdi_2_2/autoload.php';
use setasign\Fpdi\Fpdi;
// initiate FPDI
$pdf = new Fpdi();
// add a page
$pdf->AddPage();
// set the source file
$template_pdf = __DIR__.'/PlantillaFactura.pdf';
$pdf->setSourceFile($template_pdf);
// import page 1
$tplIdx = $pdf->importPage(1);
// use the imported page and place it at position 10,10 with a width of 100 mm
// $pdf->useTemplate($tplIdx, 10, 10, 100);
$pdf->useTemplate($tplIdx);
// Obtain measures from the page for the transformation of the Points
$pdf->SetXY(1, 1);
$wPt = 595.32; // Measures in points of the page
$w = $pdf->GetPageWidth();
$hPt = 841.92; // Measures in points of the page
$h = $pdf->GetPageHeight();
$coef_x = $wPt/$w; // X axis transformation coefficient
$coef_y = $hPt/$h; // Y axis transformation coefficient
// now write some text above the imported page
// $pdf->SetFont('Arial','B',10); // Font, type and size
// $pdf->SetTextColor(68, 68, 68); // Color in R, G, B
// $pdf->SetXY(132/$coef_x, 118/$coef_y); // Positioning on the page
// $pdf->Write(0, 'This is just a simple text'); // Write TXT. Offset in Y points, Text and Link
// -----------------------------------------------Recover invoice data-------------------------------------------------------------------------------------------------------
$idfactura= $_SESSION['idfactura'] ; // invoice identification to obtain
$sql="SELECT Nif, NombreRazonSocial, Domicilio, RestoDomicilio, FechaFactura, TotalFactura FROM factura where idfactura = $idfactura";
$resql=db_query($sql,$conn);
$data=db_fetch_array($resql);
// Variables on different parts of document
$pdf->SetFont('Arial','',16); // Font, type and size
$pdf->SetTextColor(247, 172, 8); // Color in R, G, B
$pdf->SetXY(321/$coef_x, 101/$coef_y); // Positioning on the page
$pdf->Write(0, '#'.$idfactura); // Numbre invoce
$pdf->SetXY(435/$coef_x, 101/$coef_y); // Positioning on the page
$pdf->Write(0, $data['FechaFactura']); // Date invoce
$pdf->SetFont('Arial','B',10); // Font, type and size
$pdf->SetTextColor(68, 68, 68); // Color in R, G, B
$pdf->SetXY(132/$coef_x, 118/$coef_y); // Positioning on the page
$pdf->Write(0, $data['Nif']); // NIF
$pdf->SetXY(132/$coef_x, 132/$coef_y);
$string = iconv("UTF-8", "ISO-8859-1//TRANSLIT", $data['NombreRazonSocial']); // Convert UTf8
$pdf->Write(0, $string); // Nombre
$pdf->SetFont('Arial','',10); // Font, type and size
$pdf->SetXY(132/$coef_x, 146/$coef_y);
$string = iconv("UTF-8", "ISO-8859-1//TRANSLIT", $data['Domicilio']); // Convert UTf8
$pdf->Write(0, $string); // Domicilio
$pdf->SetXY(132/$coef_x, 160/$coef_y);
$string = iconv("UTF-8", "ISO-8859-1//TRANSLIT", $data['RestoDomicilio']); // Convert UTf8
$pdf->Write(0, $string); // RestoDomicilio
$pdf->SetFont('Courier','',10); // Font, type and size, COURIER is a fixed size font of all characters
$pdf->SetXY(443/$coef_x, 481/$coef_y);
$number = number_format($data['TotalFactura'], 2, ',', '.');
$number = sprintf("%' 11s",$number);
$pdf->Write(0,$number ); // TotalFactura
$pdf->SetXY(443/$coef_x, 453/$coef_y);
$pdf->Write(0,$number ); // TotalFactura
// --------------------------------------------------------------
$sql="SELECT producto_idproducto, Nombre, Precio, Cantidad, Valor FROM linea_factura where factura_idfactura= $idfactura ";
$rsSql=db_query($sql,$conn);
$countLines=0;
while ($data2 = db_fetch_array($rsSql)){
$pdf->SetXY(55/$coef_x, ((206.5+($countLines*14.63))/$coef_y));
$number = number_format($data2['producto_idproducto'], 0, ',', '.');
$number = sprintf("%' 9s",$number);
$pdf->Write(0,$number ); // Id Producto
$pdf->SetXY(128/$coef_x, ((206.5+($countLines*14.63))/$coef_y));
$string = iconv("UTF-8", "ISO-8859-1//TRANSLIT", $data2['Nombre']); // Convert UTf8
$pdf->Write(0,$string); // Nonbre
$pdf->SetXY(322.71/$coef_x, ((206.5+($countLines*14.63))/$coef_y));
$number = number_format($data2['Precio'], 2, ',', '.');
$number = sprintf("%' 7s",$number);
$pdf->Write(0,$number ); // Precio
$pdf->SetXY(375/$coef_x, ((206.5+($countLines*14.63))/$coef_y));
$number = number_format($data2['Cantidad'], 0, ',', '.');
$number = sprintf("%' 10s",$number);
$pdf->Write(0,$number ); // Cantidad
$pdf->SetXY(443/$coef_x, ((206.5+($countLines*14.63))/$coef_y));
$number = number_format($data2['Valor'], 2, ',', '.');
$number = sprintf("%' 11s",$number);
$pdf->Write(0,$number ); // Valor
$countLines=$countLines+1;
}
// adding the second page of the template
$tplIdx2 = $pdf->importPage(2);
$s = $pdf->getTemplatesize($tplIdx2);
$pdf->AddPage('', $s);
$pdf->useImportedPage($tplIdx2);
$pdf->Output('I','Factura.pdf');
/*
// -------------------- foot to save the new PDF document ------------------
$temp_file = tempnam(sys_get_temp_dir(), 'PDF');
$pdf->Output('F',$temp_file);
// ------------------ Operation with file result -------------------------------------------
$documento = file_get_contents($temp_file);
unlink($temp_file); // delete file tmp
header("Content-Disposition: attachment; filename= factura.pdf");
header('Content-Type: application/pdf');
echo $documento;
*/
?>
All these PHP libraries are quite heavy and so that the PHPRunner projects are not heavy and also allow me to share these libraries for several projects, I always create a "ComponentCode" directory, at the same deployment height as the projects, where I leave The bookstores. In this example are the libraries of:
Fpdi
PHPWord
PhpSpreadsheet
Keep this in mind if you download the example, because you will have to download these libraries.
You can see the result in this DEMO link https://fhumanes.com/factura/
As usual in these articles, I leave the files so you can test it on your computers.
For any questions or what you need, you indicate it to me through my email fernandohumanes@gmail.com.
To download the example, access https://fhumanes.com/blog/otros-ejemples/crear-factura-con-setasign-pdf/
|
|
