Blog personal

Este artículo recoge los ejemplos anteriores que había hecho con los productos:

  • Office/PHPWord (Word)
  • Office/PhpSpreadsheet (Excel)
  • Setasign PDF / FPDI (PDF)

Y además he añadido el envio del PDF por Email por petición de algunos usuarios.

DEMO: https://fhumanes.com/invoice

Para que recibáis vosotros la factura por email es necesario:

  • Que creeis un Cliente con una cuenta de email a la que tengáis acceso.
  • Que creais un Factura con dicho Cliente
  • Que pulseis el botón de “enviar PDF” en la consulta de la factura.

Los botones para obtener las facturas en Word, Excel y PDF están en la consulta de las Facturas.

Os muestro el código de los ejemplos:

FacturaWord
 
<?php
require_once __DIR__ . '/../../ComponentCode/PHPWord_0.17/autoload.php'; 
// ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$idfactura= $_SESSION['idfactura'] ; // identificación de factura a obtener
// Template processor instance creation
$template_word = __DIR__.'/PlantillaFactura.docx';
$templateProcessor = new \PhpOffice\PhpWord\TemplateProcessor($template_word);
// -------------------- ^ cabecera necesaria para las plantillas de Word ------------------
$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
$templateProcessor->setValue('NIF', $data['Nif']); 
$templateProcessor->setValue('Nombre', $data['NombreRazonSocial']);  
$templateProcessor->setValue('Direccion1', $data['Domicilio']);
$templateProcessor->setValue('Direccion2', $data['RestoDomicilio']);
$templateProcessor->setValue('Total', $data['TotalFactura']);
$FechaFactura=$data['FechaFactura'];
$sql="SELECT count(*) Lineas FROM linea_factura where factura_idfactura= $idfactura";
$resql=db_query($sql,$conn);
$data=db_fetch_array($resql);
$NumeroLineas= $data['Lineas']; // número de líneaas de factura
// Simple table
$templateProcessor->cloneRow('rowArticulo', $NumeroLineas);
$sql="SELECT Nombre, Precio, Cantidad, Valor  FROM linea_factura where factura_idfactura= $idfactura ";
$rsSql=db_query($sql,$conn);
$countLines=0;
while ($data2 = db_fetch_array($rsSql)){
            $countLines=$countLines+1;
            $templateProcessor->setValue('rowArticulo#'.$countLines, $data2['Nombre']);
            $templateProcessor->setValue('rowPrecio#'.$countLines, $data2['Precio']);
            $templateProcessor->setValue('rowCantidad#'.$countLines, $data2['Cantidad']);
            $templateProcessor->setValue('rowValor#'.$countLines, $data2['Valor']);
      }
// Date Local completed
$date = DateTime::createFromFormat('Y-m-d', $FechaFactura);
$formatter = new IntlDateFormatter('es_ES', IntlDateFormatter::LONG, IntlDateFormatter::LONG);
$formatter->setPattern("d 'de' MMMM 'de' yyyy");
$mydate = $formatter->format($date);
$templateProcessor->setValue('FechaDeHoyCompleta', $mydate);
// $templateProcessor->setValue('FechaDeHoyCompleta', $FechaFactura);
// -------------------- v pie para salvar el nuevo documento Word ------------------
$temp_file = tempnam(sys_get_temp_dir(), 'Word');
$templateProcessor->saveAS($temp_file);
// ------------------ Operation with file result -------------------------------------------
$documento = file_get_contents($temp_file);
unlink($temp_file);  // delete file tmp
header("Content-Disposition: attachment; filename= factura.docx");
header('Content-Type: application/word');
echo $documento;
?>
FacturaExcel
 
<?php
require_once __DIR__ . '/../../ComponentCode/PhpSpreadsheet_1.10/autoload.php';
 
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PhpOffice\PhpSpreadsheet\NamedRange;
use PhpOffice\PhpSpreadsheet\RichText\RichText;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;;
//  Template processor instance creation
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load(__DIR__ . '/PlantillaFactura.xlsx');
$idfactura= $_SESSION['idfactura'] ; // identificación de factura a obtener
// Recuperar datos de factura
$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
$FechaFactura=$data['FechaFactura'];
$spreadsheet->getActiveSheet()->setCellValue('D1', Date::PHPToExcel($data['FechaFactura']));
$spreadsheet->getActiveSheet()->setCellValue('B2', $data['Nif']);
$spreadsheet->getActiveSheet()->setCellValue('B3', $data['NombreRazonSocial']);
$spreadsheet->getActiveSheet()->setCellValue('B5', $data['Domicilio']);
$spreadsheet->getActiveSheet()->setCellValue('B6', $data['RestoDomicilio']);
// read lines the invoice
$sql="SELECT Nombre, Precio, Cantidad, Valor  FROM linea_factura where factura_idfactura= $idfactura ";
$rsSql=db_query($sql,$conn);
$baseRow = 10;
$r=0;
while ($data2 = db_fetch_array($rsSql)){
    $row = $baseRow + $r;
    $spreadsheet->getActiveSheet()->insertNewRowBefore($row, 1);
    $spreadsheet->getActiveSheet()->setCellValue('A' . $row, $r + 1)
        ->setCellValue('B' . $row, $data2['Nombre'])
        ->setCellValue('C' . $row, $data2['Precio'])
        ->setCellValue('D' . $row, $data2['Cantidad'])
        ->setCellValue('E' . $row, $data2['Valor']);
            $r= $r+1;
      }
$spreadsheet->getActiveSheet()->removeRow($baseRow - 1, 1);
// -------------------- v pie para salvar el nuevo documento Word ------------------
$temp_file = tempnam(sys_get_temp_dir(), 'Excel');
// Save EXCEL
$writer = new Xlsx($spreadsheet);
$writer->save($temp_file);
// ------------------ Operation with file result -------------------------------------------
$documento = file_get_contents($temp_file);
unlink($temp_file);  // delete file tmp
header("Content-Disposition: attachment; filename= factura.xlsx");
header('Content-Type: application/excel');
echo $documento;
?>
FacturaPDF
 
<?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;
*/
?>
FacturaEmailPDF
 
<?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, Email, 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;
// ------------------ Email ------------------------------------------------------------------
$from = "[email protected]";
$to = $data['Email'];
$msg = "I enclose your invoice.";
$subject="Invoice";
 
$attachments = array();
// Attachments description. The 'path'(a path to the attachment) is required. Others parameters are optional: 
//'name' overrides the attachment name, 'encoding' sets a file encoding, 'type' sets a MIME type 
$attachments = array(
       array('path' => $temp_file, 
                   'name' => 'invoice.pdf', 
                   'encoding' => 'base64', 
                   'type' => 'application/pdf'));
 
$ret = runner_mail(array('from' => $from, 'to' => $to, 'subject' => $subject, 'body' => $msg, 'attachments' => $attachments));
 
if(!$ret["mailed"]){
   echo $ret["message"];
} else {
   echo "Email successfully sent";
}
unlink($temp_file);  // delete file tmp
?>

 

También os dejo el ejemplo completo para que lo podáis desplegar en vuestros equipos.

Para cualquier duda escribirme un email a [email protected]