Jump to content
Sign in to follow this  
tejure

Independent invoice number with PDF Invoice

Recommended Posts

Hello,

 

I have a problem with Independent invoice number + PDF invoice. When I was make the firts install with original oscommerce invoice, both contributions run ok, but whith PDF invoice, not appear an invoice number.

 

somebody can help me?, please

 

This is the code of PDF invoice (is clean without independent invoice number). I make some test with code, but don' work correctly.

 

 

Thank you

<?php
/*
 $Id: create_customer_pdf,v 1.1 2007/07/25 clefty (osc forum id chris23)

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License

 Based on create_pdf , originally written by Neil Westlake (nwestlake@gmail.com

 Rewritten to display a PDF invoice for the customer to print / download within account_history_info.php

 Changelog v1.1
 --------------
 i)   Added invoice date config choice - today or same as order date - date now follows locale format set in /includes/languages/your-lang/your-lang.php
 ii)  Decode html entities for all invoice text (better multilinual support)
 iii) Remove hardcoded address format. Now uses $order->customer['format_id']
 iv)  Config option to only display pdf link for delivered orders.
 v)   Remove all hardcoded English language
 vi)  Support for vector store logo  - ai / eps formats
 vii) Added customer reference.

*/

define('FPDF_FONTPATH','fpdf/font/');
require('fpdf/fpdf.php');
require('includes/application_top.php');

// perform security check to prevent "get" tampering to view other customer's invoices

 if (!tep_session_is_registered('customer_id')) {
$navigation->set_snapshot();
tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
 }

 if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) {
tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }

 $customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'");
 $customer_info = tep_db_fetch_array($customer_info_query);
 if ($customer_info['customers_id'] != $customer_id) {
tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));
 }







require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CUSTOMER_PDF);

// function to return rgb value for fpdf from supplied hex (#abcdef)

function html2rgb($color){
if ($color[0] == '#')
	$color = substr($color, 1);

if (strlen($color) == 6)
	list($r, $g, $b) = array($color[0].$color[1],
							 $color[2].$color[3],
							 $color[4].$color[5]);
elseif (strlen($color) == 3)
	list($r, $g, $b) = array($color[0], $color[1], $color[2]);
else
	return false;

$r = hexdec($r); $g = hexdec($g); $b = hexdec($b);

return array($r,$g,$b);
  }

// function to decode html entities
function tep_html_entity_decode($text, $quote_style = ENT_QUOTES){
	return html_entity_decode($text, $quote_style);
	}

  // find image type
  function findextension ($filename)
{
$filename = strtolower($filename);
$extension= split("\.", $filename);
$n = count($extension)-1;
$extension = $extension[$n];
return $extension;
}

 $border_color = html2rgb(PDF_INV_BORDER_COLOR);
 $cell_color = html2rgb(PDF_INV_CELL_COLOR);
 $invoice_line = html2rgb(PDF_INV_INVLINE_COLOR);
 $highlight_color = html2rgb(PDF_INV_HIGHLIGHT_COLOR);
 $standard_color = html2rgb(PDF_INV_STANDARD_COLOR);
 $watermark_color = html2rgb(PDF_INV_WATERMARK_COLOR);


 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT_HISTORY_INFO);

 require(DIR_WS_CLASSES . 'order.php');
 $order = new order($HTTP_GET_VARS['order_id']);

 // set invoice date - today or day ordered. set in config
$date = (PDF_INV_DATE_TODAY == 'today') ? strftime(DATE_FORMAT_LONG) : tep_date_long($order->info['date_purchased']);

class PDF extends FPDF
{

//Page header
function RoundedRect($x, $y, $w, $h,$r, $style = '')
{
	$k = $this->k;
	$hp = $this->h;
	if($style=='F')
		$op='f';
	elseif($style=='FD' or $style=='DF')
		$op='B';
	else
		$op='S';
	$MyArc = 4/3 * (sqrt(2) - 1);
	$this->_out(sprintf('%.2f %.2f m',($x+$r)*$k,($hp-$y)*$k ));
	$xc = $x+$w-$r;
	$yc = $y+$r;
	$this->_out(sprintf('%.2f %.2f l', $xc*$k,($hp-$y)*$k ));

	$this->_Arc($xc + $r*$MyArc, $yc - $r, $xc + $r, $yc - $r*$MyArc, $xc + $r, $yc);
	$xc = $x+$w-$r;
	$yc = $y+$h-$r;
	$this->_out(sprintf('%.2f %.2f l',($x+$w)*$k,($hp-$yc)*$k));
	$this->_Arc($xc + $r, $yc + $r*$MyArc, $xc + $r*$MyArc, $yc + $r, $xc, $yc + $r);
	$xc = $x+$r;
	$yc = $y+$h-$r;
	$this->_out(sprintf('%.2f %.2f l',$xc*$k,($hp-($y+$h))*$k));
	$this->_Arc($xc - $r*$MyArc, $yc + $r, $xc - $r, $yc + $r*$MyArc, $xc - $r, $yc);
	$xc = $x+$r;
	$yc = $y+$r;
	$this->_out(sprintf('%.2f %.2f l',($x)*$k,($hp-$yc)*$k ));
	$this->_Arc($xc - $r, $yc - $r*$MyArc, $xc - $r*$MyArc, $yc - $r, $xc, $yc - $r);
	$this->_out($op);
}

function _Arc($x1, $y1, $x2, $y2, $x3, $y3)
{
	$h = $this->h;
	$this->_out(sprintf('%.2f %.2f %.2f %.2f %.2f %.2f c ', $x1*$this->k, ($h-$y1)*$this->k,
		$x2*$this->k, ($h-$y2)*$this->k, $x3*$this->k, ($h-$y3)*$this->k));
}




function Header()
{
global $HTTP_GET_VARS, $highlight_color, $date, $image_function, $customer_id;


//Logo
$size =getimagesize(PDF_INVOICE_IMAGE);
$this->$image_function(PDF_INVOICE_IMAGE,7,10,($size[0]*PDF_INV_IMG_CORRECTION),($size[1]*PDF_INV_IMG_CORRECTION),'', FILENAME_DEFAULT);

// Invoice Number, customer reference and date
$this->SetFont(PDF_INV_CORE_FONT,'B',10);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->SetY(43);
$this->Cell(100,6, tep_html_entity_decode(PRINT_INVOICE_TITLE) . (int)$HTTP_GET_VARS['order_id'],0,'L');
$this->SetY(48);
$this->Cell(100,6, $date ,0,'L');

// Company name
$this->SetX(-10);
$this->SetY(12);
$this->SetFont(PDF_INV_CORE_FONT,'B',12);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Ln(0);
$this->Cell(149);
$this->MultiCell(50, 3.5, tep_html_entity_decode(STORE_NAME),0,'L'); 

// Company Address
$this->SetX(-10);
$this->SetY(16);
$this->SetFont(PDF_INV_CORE_FONT,'B',10);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Ln(0);
$this->Cell(149);
$this->MultiCell(50, 3.5, tep_html_entity_decode(STORE_NAME_ADDRESS),0,'L'); 

//Email
$this->SetX(0);
$this->SetY(43);
$this->SetFont(PDF_INV_CORE_FONT,'B',10);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Ln(0);
$this->Cell(88);
$this->MultiCell(100, 6, tep_html_entity_decode(PDF_INV_EMAIL) . STORE_OWNER_EMAIL_ADDRESS,0,'R');

//Website
$this->SetX(0);
$this->SetY(48);
$this->SetFont(PDF_INV_CORE_FONT,'B',10);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Ln(0);
$this->Cell(88);
$this->MultiCell(100, 6, tep_html_entity_decode(PDF_INV_WEB) . HTTP_SERVER,0,'R');

// VAT / Tax number (if enabled)
if (DISPLAY_PDF_TAX_NUMBER == 'true'){
$this->SetX(0);
$this->SetY(53);
$this->SetFont(PDF_INV_CORE_FONT,'B',10);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Ln(0);
$this->Cell(88);
$this->MultiCell(100, 6, tep_html_entity_decode(PDF_TAX_NAME) . " " . PDF_TAX_NUMBER,0,'R');
  }
}

// function taken and modified from $Id: pdf_datasheet_functions v1.40 2005/06/16 13:46:29 ip chilipepper.it Exp $

 function RotatedText($x,$y,$txt,$angle)
{
//Text rotated around its origin
$this->Rotate($angle,$x,$y);
$this->Text($x,$y,$txt);
$this->Rotate(0);
}


function Watermark()
{
global $watermark_color;
$this->SetFont(PDF_INV_CORE_FONT,'B',60);
$this->SetTextColor($watermark_color[0], $watermark_color[1], $watermark_color[2]);
$ang=30;																			 
$cos=cos(deg2rad($ang));
$wwm=($this->GetStringWidth(tep_html_entity_decode(PDF_INV_WATERMARK_TEXT))*$cos);
$this->RotatedText(($this->w-$wwm)/2,$this->w,PDF_INV_WATERMARK_TEXT,$ang);
}

function Footer()
{
global $highlight_color, $invoice_line;

// insert horiz line
$this->SetY(-19);
$this->SetDrawColor($invoice_line[0],$invoice_line[1],$invoice_line[2]);
$this->Cell(198,.1,'',1,1,'L',1);

//Position at 1.5 cm from bottom
$this->SetY(-22);
$this->SetFont(PDF_INV_CORE_FONT,'',8);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Cell(0,10, tep_html_entity_decode(PDF_INV_FOOTER_TEXT), 0,0,'C');

//Position at 1.5 cm from bottom
$this->SetY(-19);
$this->SetFont(PDF_INV_CORE_FONT,'',8);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Cell(0,10, tep_html_entity_decode(PDF_INV_FOOTER_TEXT2), 0,0,'C');

//Position at 1.5 cm from bottom
$this->SetY(-16);
$this->SetFont(PDF_INV_CORE_FONT,'',8);
$this->SetTextColor($highlight_color[0],$highlight_color[1],$highlight_color[2]);
$this->Cell(0,10, tep_html_entity_decode(PDF_INV_FOOTER_TEXT3), 0,0,'C');


}
}






/***************************
* Software: FPDF_EPS
* Version:  1.3
* Date:	 2006-07-28
* Author:   Valentin Schmidt
****************************/
class PDF_EPS extends PDF{

function PDF_EPS($orientation='P',$unit='mm',$format='A4'){
parent::FPDF($orientation,$unit,$format);
}

function ImageEps ($file, $x, $y, $w=0, $h=0, $link='', $useBoundingBox=true){
$data = file_get_contents($file);
if ($data===false) $this->Error('EPS file not found: '.$file);

# strip binary bytes in front of PS-header
$start = strpos($data, '%!PS-Adobe');
if ($start>0) $data = substr($data, $start);

# find BoundingBox params
ereg ("%%BoundingBox:([^\r\n]+)", $data, $regs);
if (count($regs)>1){
	list($x1,$y1,$x2,$y2) = explode(' ', trim($regs[1]));
}
else $this->Error('No BoundingBox found in EPS file: '.$file);

$start = strpos($data, '%%EndSetup');
if ($start===false) $start = strpos($data, '%%EndProlog');
if ($start===false) $start = strpos($data, '%%BoundingBox');

$data = substr($data, $start);

$end = strpos($data, '%%PageTrailer');
if ($end===false) $end = strpos($data, 'showpage');
if ($end) $data = substr($data, 0, $end);

# save the current graphic state
$this->_out('q');

$k = $this->k;

if ($useBoundingBox){
	$dx = $x*$k-$x1;
	$dy = $y*$k-$y1;
}else{
	$dx = $x*$k;
	$dy = $y*$k;
}

# translate
$this->_out(sprintf('%.3f %.3f %.3f %.3f %.3f %.3f cm', 1,0,0,1,$dx,$dy+($this->hPt - 2*$y*$k - ($y2-$y1))));

if ($w>0){
	$scale_x = $w/(($x2-$x1)/$k);
	if ($h>0){
		$scale_y = $h/(($y2-$y1)/$k);
	}else{
		$scale_y = $scale_x;
		$h = ($y2-$y1)/$k * $scale_y;
	}
}else{
	if ($h>0){
		$scale_y = $h/(($y2-$y1)/$k);
		$scale_x = $scale_y;
		$w = ($x2-$x1)/$k * $scale_x;
	}else{
		$w = ($x2-$x1)/$k;
		$h = ($y2-$y1)/$k;
	}
}

# scale	
if (isset($scale_x))
	$this->_out(sprintf('%.3f %.3f %.3f %.3f %.3f %.3f cm', $scale_x,0,0,$scale_y, $x1*(1-$scale_x), $y2*(1-$scale_y)));

# handle pc/unix/mac line endings
$lines = split ("\r\n|[\r\n]", $data);

$u=0;
$cnt = count($lines);
for ($i=0;$i<$cnt;$i++){
	$line = $lines[$i];
	if ($line=='' || $line{0}=='%') continue;
	$len = strlen($line);
	if ($len>2 && $line{$len-2}!=' ') continue;
	$cmd = $line{$len-1};

	switch ($cmd){
		case 'm':
		case 'l':
		case 'v':
		case 'y':
		case 'c':

		case 'k':
		case 'K':
		case 'g':
		case 'G':

		case 's':
		case 'S':

		case 'J':
		case 'j':
		case 'w':
		case 'M':
		case 'd' :

		case 'n' :
		case 'v' :
			$this->_out($line);
			break;

		case 'x': # custom colors
			list($c,$m,$y,$k) = explode(' ', $line);
			$this->_out("$c $m $y $k k");
			break;

		case 'Y':
			$line{$len-1}='y';
			$this->_out($line);
			break;

		case 'N':
			$line{$len-1}='n';
			$this->_out($line);
			break;

		case 'V':
			$line{$len-1}='v';
			$this->_out($line);
			break;

		case 'L':
			$line{$len-1}='l';
			$this->_out($line);
			break;

		case 'C':
			$line{$len-1}='c';
			$this->_out($line);
			break;

		case 'b':
		case 'B':
			$this->_out($cmd . '*');
			break;

		case 'f':
		case 'F':
			if ($u>0){
				$isU = false;
				$max = min($i+5,$cnt);
				for ($j=$i+1;$j<$max;$j++)
					$isU = ($isU || ($lines[$j]=='U' || $lines[$j]=='*U'));
				if ($isU) $this->_out("f*");
			}else
				$this->_out("f*");
			break;

		case 'u':
			if ($line{0}=='*') $u++;
			break;

		case 'U':
			if ($line{0}=='*') $u--;
			break;

		#default: echo "$cmd<br>"; #just for debugging
	}

}

# restore previous graphic state
$this->_out('Q');
if ($link)
	$this->Link($x,$y,$w,$h,$link);
}

}# END CLASS

# for backward compatibility
if (!function_exists('file_get_contents')){
function file_get_contents($filename, $use_include_path = 0){
	$file = @fopen($filename, 'rb', $use_include_path);
	if ($file){
		if ($fsize = @filesize($filename))
			$data = fread($file, $fsize);
		else {
			$data = '';
			while (!feof($file)) $data .= fread($file, 1024);
		}
		fclose($file);
		return $data;
	}else
		return false;
}
}

// Instanciation of inherited class - choose according to logo supplied, vector or raster
if(findextension(PDF_INVOICE_IMAGE) == 'ai' || findextension(PDF_INVOICE_IMAGE) == 'eps'){
	$pdf=new PDF_EPS();
	$image_function = "ImageEps";
	}
	else{
	$pdf=new PDF();
	$image_function = "Image";
	}

// Set the Page Margins
$pdf->SetMargins(6,2,6);

// Add the first page
$pdf->AddPage();

  // add watermark if required

if(PDF_SHOW_WATERMARK == 'true'){
$pdf->Watermark();
}

//Draw the top line with invoice text
$pdf->Cell(50);
$pdf->SetY(60);
$pdf->SetDrawColor($invoice_line[0],$invoice_line[1],$invoice_line[2]);
$pdf->Cell(15,.1,'',1,1,'L',1);
$pdf->SetFont(PDF_INV_CORE_FONT,'BI',15);
$pdf->SetTextColor($invoice_line[0],$invoice_line[1],$invoice_line[2]);
$pdf->Text(22,61.5,tep_html_entity_decode(PRINT_INVOICE_HEADING));
$pdf->SetY(60);
$pdf->SetDrawColor($invoice_line[0],$invoice_line[1],$invoice_line[2]);
$pdf->Cell(38);
$pdf->Cell(160,.1,'',1,1,'L',1);

//Draw Box for Invoice Address
$pdf->SetDrawColor($border_color[0],$border_color[1],$border_color[2]);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor($cell_color[0],$cell_color[1],$cell_color[2]);
$pdf->RoundedRect(6, 67, 90, 35, 2, 'DF');




//Draw the invoice address text
$pdf->SetFont(PDF_INV_CORE_FONT,'B',10);
$pdf->SetTextColor($standard_color[0],$standard_color[1],$standard_color[2]);
$pdf->Text(11,77, tep_html_entity_decode(ENTRY_SOLD_TO));
$pdf->SetX(0);
$pdf->SetY(80);
$pdf->Cell(9);
$pdf->MultiCell(70, 3.3, tep_html_entity_decode(tep_address_format($order->customer['format_id'], $order->customer, '', '', "\n")),0,'L');

//Draw Box for Delivery Address
$pdf->SetDrawColor($border_color[0],$border_color[1],$border_color[2]);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor(255);
$pdf->RoundedRect(108, 67, 90, 35, 2, 'DF');

//Draw the invoice delivery address text
$pdf->SetFont(PDF_INV_CORE_FONT,'B',10);
$pdf->SetTextColor($standard_color[0],$standard_color[1],$standard_color[2]);
$pdf->Text(113,77,tep_html_entity_decode(ENTRY_SHIP_TO));
$pdf->SetX(0);
$pdf->SetY(80);
$pdf->Cell(111);
$pdf->MultiCell(70, 3.3, tep_html_entity_decode(tep_address_format($order->delivery['format_id'], $order->delivery, '', '', "\n")),0,'L');

//Draw Box for Order Number, Date & Payment method
$pdf->SetDrawColor($border_color[0],$border_color[1],$border_color[2]);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor($cell_color[0],$cell_color[1],$cell_color[2]);
$pdf->RoundedRect(6, 107, 192, 14, 2, 'DF');

//Draw Order Number Text
$pdf->Text(10,113, tep_html_entity_decode(PRINT_INVOICE_ORDERNR) . (int)$HTTP_GET_VARS['order_id']);	
//Draw Date of Order Text
$pdf->Text(120,113, tep_html_entity_decode(PRINT_INVOICE_DATE) . tep_date_short($order->info['date_purchased']));	
//Draw Payment Method Text
$temp = substr ($order->info['payment_method'] , 0, 23);
$pdf->Text(120,117, tep_html_entity_decode(ENTRY_PAYMENT_METHOD) . ' ' . tep_html_entity_decode($temp));
// Draw customer reference
$pdf->Text(10,117, tep_html_entity_decode(PDF_INV_CUSTOMER_REF) . (int)$customer_id);

//Draw Box for Comments
$pdf->SetDrawColor($border_color[0],$border_color[1],$border_color[2]);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor($cell_color[0],$cell_color[1],$cell_color[2]);
$pdf->RoundedRect(6, 124, 192, 22, 2, 'DF');

// Output comments - limited by $n, here set to 1. Any more and you need to adjust box height, product table y position etc
$pdf->SetFont(PDF_INV_CORE_FONT,'B',10);
$pdf->Text(10 ,128, tep_html_entity_decode(PDF_INV_COMMENTS));
$pdf->SetFont(PDF_INV_CORE_FONT,'',8);
for ($i = 0, $n = 1; $i < $n; $i++){
$pdf->Text(10 , 133+(5*$i), $order->comments[$i]['comments']);
}



//Fields Name position
$Y_Fields_Name_position = 150;
//Table position, under Fields Name
$Y_Table_Position = 156;



function output_table_heading($Y_Fields_Name_position){
global  $pdf, $cell_color;
//First create each Field Name
// Config color filling each Field Name box
$pdf->SetFillColor($cell_color[0],$cell_color[1],$cell_color[2]);
//Bold Font for Field Name
$pdf->SetFont(PDF_INV_CORE_FONT,'B',10);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(6);
$pdf->Cell(9,6,tep_html_entity_decode(PDF_INV_QTY_CELL),1,0,'C',1);
$pdf->SetX(15);
$pdf->Cell(20,6,tep_html_entity_decode(TABLE_HEADING_PRODUCTS_MODEL),1,0,'C',1);
$pdf->SetX(35);
$pdf->Cell(100,6,tep_html_entity_decode(TABLE_HEADING_PRODUCTS),1,0,'C',1);
//$pdf->SetX(118);
//$pdf->Cell(20,6,tep_html_entity_decode(TABLE_HEADING_PRICE_EXCLUDING_TAX),1,0,'C',1);
//$pdf->SetX(138);
//$pdf->Cell(20,6,tep_html_entity_decode(TABLE_HEADING_PRICE_INCLUDING_TAX),1,0,'C',1);
$pdf->SetX(135);
$pdf->Cell(15,6,tep_html_entity_decode(TABLE_HEADING_TAX),1,0,'C',1);
$pdf->SetX(150);
$pdf->Cell(24,6,tep_html_entity_decode(TABLE_HEADING_TOTAL_EXCLUDING_TAX),1,0,'C',1);
$pdf->SetX(174);
$pdf->Cell(24,6,tep_html_entity_decode(TABLE_HEADING_TOTAL_INCLUDING_TAX),1,0,'C',1);
$pdf->Ln();
}

output_table_heading($Y_Fields_Name_position);
//Show the products information line by line
for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
$pdf->SetFont(PDF_INV_CORE_FONT,'',10);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(6);
$pdf->MultiCell(9,6,$order->products[$i]['qty'],1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(35);

$prod_attribs='';

//get attribs and concat
	if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
	for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
	$prod_attribs .= " - " .$order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];
	}
}	

$product_name_attrib_contact = $order->products[$i]['name'] . $prod_attribs;

if (strlen($product_name_attrib_contact) > 40 && strlen($product_name_attrib_contact) < 50){
	$pdf->SetFont(PDF_INV_CORE_FONT,'',6);
	$pdf->MultiCell(100,6,tep_html_entity_decode($product_name_attrib_contact),1,'L');
	}

else if (strlen($product_name_attrib_contact) > 50){
	$pdf->SetFont(PDF_INV_CORE_FONT,'',6);
	$pdf->MultiCell(100,6,tep_html_entity_decode(substr($product_name_attrib_contact,0,60)) ." .. ",1,'L');
	}


else{
	$pdf->SetFont(PDF_INV_CORE_FONT,'',6);
	$pdf->MultiCell(78,6,tep_html_entity_decode($product_name_attrib_contact),1,'L');
	$pdf->Ln();
	}	
$pdf->SetFont('Arial','',10);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(135);
$pdf->MultiCell(15,6,tep_display_tax_value($order->products[$i]['tax']) . '%',1,'C');   
$pdf->SetFont(PDF_INV_CORE_FONT,'',10);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(15);
$pdf->SetFont(PDF_INV_CORE_FONT,'',8);
$pdf->MultiCell(20,6,tep_html_entity_decode($order->products[$i]['model']),1,'C');
//$pdf->SetY($Y_Table_Position);
//$pdf->SetX(118);
//$pdf->SetFont(PDF_INV_CORE_FONT,'',10);
//$pdf->MultiCell(20,6,$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
//$pdf->SetY($Y_Table_Position);
//$pdf->SetX(138);
//$pdf->MultiCell(20,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']),1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(24,6,$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(174);
$pdf->MultiCell(24,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
$Y_Table_Position += 6;








//Check for product line overflow
 $item_count++;
if ((is_long($item_count / 32) && $i >= 20) || ($i == 20)){
	$pdf->AddPage();
	//Fields Name position
	$Y_Fields_Name_position = 125;
	//Table position, under Fields Name
	$Y_Table_Position = 70;
	output_table_heading($Y_Table_Position-6);
	if ($i == 20) $item_count = 1;
}
}
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
$pdf->SetY($Y_Table_Position + 5);
$pdf->SetX(95);
$temp = substr ($order->totals[$i]['text'],0 ,3);
if ($temp == '<b>')
	{
	$pdf->SetFont(PDF_INV_CORE_FONT,'B',10);
	$temp2 = substr($order->totals[$i]['text'], 3);
	$order->totals[$i]['text'] = substr($temp2, 0, strlen($temp2)-4);
	}
$pdf->MultiCell(100,6,$order->totals[$i]['title'] . ' ' . $order->totals[$i]['text'],0,'R');
$Y_Table_Position += 5;


}













 // set PDF metadata
 $pdf->SetTitle(PDF_META_TITLE);
 $pdf->SetSubject(PDF_META_SUBJECT . $HTTP_GET_VARS['order_id']);
 $pdf->SetAuthor(STORE_OWNER);

  // PDF created

function safe_filename ($filename) {
$search = array(
'/ß/',
'/ä/','/Ä/',
'/ö/','/Ö/',
'/ü/','/Ü/',
'([^[:alnum:]._])' 
);
$replace = array(
'ss',
'ae','Ae',
'oe','Oe',
'ue','Ue',
'_'
);

// return a safe filename, lowercased and suffixed with invoice number.

return strtolower(preg_replace($search,$replace,$filename));
}
$file_name = safe_filename(STORE_NAME);
$file_name .= "_invoice_" . $HTTP_GET_VARS['order_id'] . ".pdf";
$mode = (FORCE_PDF_INVOICE_DOWNLOAD == 'true') ? 'D' : 'I';
// what do we do? display inline or force download  
$pdf->Output($file_name , $mode);
?>

Share this post


Link to post
Share on other sites

I have used an older code which replaces the invoice.php in the admin folder, just create the code as invoice.php and replace the file ( attention ! backup you older invoice.php file )

 

My logo image is in a different spot, so if you want to replace the logo, search for logo in the code

you have fpdf to be installed in the admin folder

 

<?php
/*
 $Id: create_pdf,v 1.4 2005/04/07

 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]

 Copyright © 2003 osCommerce

 Released under the GNU General Public License

 Written by Neil Westlake (nwestlake@gmail.com) for www.Digiprintuk.com

 Version History:
 1.1
 Initial release
 1.2
 Corrected problem displaying PDF when from a HTTPS URL.
 1.3
 Modified item display to allow page continuation when more than 20 products are on one invoice.
 1.4
 Corrected problem with page continuation, now invoices will allow for an unlimited amount of products on one invoice
*/

define('FPDF_FONTPATH','fpdf/font/');
require('fpdf/fpdf.php');

require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ORDERS_INVOICE);

require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();

include(DIR_WS_CLASSES . 'order.php');

while (list($key, $oID) = each($_GET)) {
if ($key != "oID")
	break;
	 $orders_query = tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . $oID . "'");
	 $order = new order($oID);

class PDF extends FPDF
{
//Page header
function RoundedRect($x, $y, $w, $h,$r, $style = '')
   {
       $k = $this->k;
       $hp = $this->h;
       if($style=='F')
           $op='f';
       elseif($style=='FD' or $style=='DF')
           $op='B';
       else
           $op='S';
       $MyArc = 4/3 * (sqrt(2) - 1);
       $this->_out(sprintf('%.2f %.2f m',($x+$r)*$k,($hp-$y)*$k ));
       $xc = $x+$w-$r ;
       $yc = $y+$r;
       $this->_out(sprintf('%.2f %.2f l', $xc*$k,($hp-$y)*$k ));

       $this->_Arc($xc + $r*$MyArc, $yc - $r, $xc + $r, $yc - $r*$MyArc, $xc + $r, $yc);
       $xc = $x+$w-$r ;
       $yc = $y+$h-$r;
       $this->_out(sprintf('%.2f %.2f l',($x+$w)*$k,($hp-$yc)*$k));
       $this->_Arc($xc + $r, $yc + $r*$MyArc, $xc + $r*$MyArc, $yc + $r, $xc, $yc + $r);
       $xc = $x+$r ;
       $yc = $y+$h-$r;
       $this->_out(sprintf('%.2f %.2f l',$xc*$k,($hp-($y+$h))*$k));
       $this->_Arc($xc - $r*$MyArc, $yc + $r, $xc - $r, $yc + $r*$MyArc, $xc - $r, $yc);
       $xc = $x+$r ;
       $yc = $y+$r;
       $this->_out(sprintf('%.2f %.2f l',($x)*$k,($hp-$yc)*$k ));
       $this->_Arc($xc - $r, $yc - $r*$MyArc, $xc - $r*$MyArc, $yc - $r, $xc, $yc - $r);
       $this->_out($op);
   }

   function _Arc($x1, $y1, $x2, $y2, $x3, $y3)
   {
       $h = $this->h;
       $this->_out(sprintf('%.2f %.2f %.2f %.2f %.2f %.2f c ', $x1*$this->k, ($h-$y1)*$this->k,
           $x2*$this->k, ($h-$y2)*$this->k, $x3*$this->k, ($h-$y3)*$this->k));
   }

function Header()
{
global $oID;
 $date = strftime('%A, %d %B %Y');
//Logo
   $this->Image('images/invoice_logo.jpg',5,5,0);

   // Invoice Number and date
$this->SetFont('Arial','B',8);
$this->SetTextColor(0);
$this->SetY(37);
$this->MultiCell(100,6, $date ,0,'L');

// Company Address
$this->SetX(0);
$this->SetY(5);
   $this->SetFont('Arial','B',8);
$this->SetTextColor(0);
   $this->Ln(0);
   $this->Cell(149);
$this->MultiCell(50, 3.5, STORE_NAME_ADDRESS,0,'L');

//email
$this->SetX(0);
$this->SetY(40);
$this->SetFont('Arial','B',8);
$this->SetTextColor(0);
$this->Ln(0);
   $this->Cell(149);
$this->MultiCell(50, 3.5, "E-mail: " . STORE_OWNER_EMAIL_ADDRESS,0,'L');

//website
$this->SetX(0);
$this->SetY(43);
$this->SetFont('Arial','B',8);
$this->SetTextColor(0);
$this->Ln(0);
   $this->Cell(149);
$this->MultiCell(50, 3.5, "Internet: " . HTTP_SERVER,0,'L');
}

function Footer()
{
   //Position at 1.5 cm from bottom
   $this->SetY(-17);
   //Arial italic 8
   $this->SetFont('Arial','',10);
$this->SetTextColor(158,11,14);
$this->Cell(0,10, PRINT_INVOICE_TEXT, 0,0,'C');
//$this->SetY(-15);
  	//$this->Cell(0,10, PRINT_INVOICE_URL, 0,0,'C');
//Page number
   //$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}
}
//Instanciation of inherited class
$pdf=new PDF();

// Set the Page Margins
$pdf->SetMargins(6,2,6);

// Add the first page
$pdf->AddPage();

//Draw the top line with invoice text
$pdf->Cell(50);
$pdf->SetY(60);
$pdf->SetDrawColor(153,153,153);
$pdf->Cell(15,.1,'',1,1,'L',1);
$pdf->SetFont('Arial','BI',15);
$pdf->SetTextColor(153,153,153);
$pdf->Text(22,61.5,'Invoice');
$pdf->SetY(60);
$pdf->SetDrawColor(153,153,153);
$pdf->Cell(38);
$pdf->Cell(160,.1,'',1,1,'L',1);

//Draw Box for Invoice Address
$pdf->SetDrawColor(0);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor(245);
$pdf->RoundedRect(6, 67, 90, 35, 2, 'DF');

//Draw the invoice address text
   $pdf->SetFont('Arial','B',8);
$pdf->SetTextColor(0);
$pdf->Text(11,77, ENTRY_SOLD_TO);
$pdf->SetX(0);
$pdf->SetY(80);
   //$pdf->SetFont('Arial','B',8);
//$pdf->SetTextColor(0);
   $pdf->Cell(9);
$pdf->MultiCell(70, 3.3, tep_address_format(1, $order->customer, '', '', "\n"),0,'L');

//Draw Box for Delivery Address
$pdf->SetDrawColor(0);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor(255);
$pdf->RoundedRect(108, 67, 90, 35, 2, 'DF');

//Draw the invoice delivery address text
   $pdf->SetFont('Arial','B',8);
$pdf->SetTextColor(0);
$pdf->Text(113,77,ENTRY_SHIP_TO);
$pdf->SetX(0);
$pdf->SetY(80);
   $pdf->Cell(111);
$pdf->MultiCell(70, 3.3, tep_address_format(1, $order->delivery, '', '', "\n"),0,'L');

//Draw Box for Order Number, Date & Payment method
$pdf->SetDrawColor(0);
$pdf->SetLineWidth(0.2);
$pdf->SetFillColor(245);
$pdf->RoundedRect(6, 107, 192, 11, 2, 'DF');

//Draw Order Number Text
$temp = substr ($order->billing['invoice_serial'].$order->billing['invoice_number'] , 0, 23);
$pdf->Text(10,113,TEXT_INVOICE . ' ' . $temp);


//Draw Payment Method Text
$temp = substr ($order->info['payment_method'] , 0, 23);
$pdf->Text(100,113,ENTRY_PAYMENT_METHOD . ' ' . $temp);
//$pdf->Cell(198,29,ENTRY_PAYMENT_METHOD . ' ' . $temp, 0, 0, 'R');


//Fields Name position
$Y_Fields_Name_position = 125;
//Table position, under Fields Name
$Y_Table_Position = 131;


function output_table_heading($Y_Fields_Name_position){
   global $pdf;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(245);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',8);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(6);
$pdf->Cell(9,6,'Qty',1,0,'C',1);
$pdf->SetX(15);
$pdf->Cell(27,6,TABLE_HEADING_PRODUCTS_MODEL,1,0,'C',1);
$pdf->SetX(40);
$pdf->Cell(78,6,TABLE_HEADING_PRODUCTS,1,0,'C',1);
//$pdf->SetX(105);
//$pdf->Cell(15,6,TABLE_HEADING_TAX,1,0,'C',1);
$pdf->SetX(118);
$pdf->Cell(20,6,TABLE_HEADING_PRICE_EXCLUDING_TAX,1,0,'C',1);
$pdf->SetX(138);
$pdf->Cell(20,6,TABLE_HEADING_PRICE_INCLUDING_TAX,1,0,'C',1);
$pdf->SetX(158);
$pdf->Cell(20,6,TABLE_HEADING_TOTAL_EXCLUDING_TAX,1,0,'C',1);
$pdf->SetX(178);
$pdf->Cell(20,6,TABLE_HEADING_TOTAL_INCLUDING_TAX,1,0,'C',1);
$pdf->Ln();
}
output_table_heading($Y_Fields_Name_position);
//Show the products information line by line
for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
$pdf->SetFont('Arial','',8);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(6);
$pdf->MultiCell(9,6,$order->products[$i]['qty'],1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(40);
if (strlen($order->products[$i]['name']) > 40 && strlen($order->products[$i]['name']) < 50){
	$pdf->SetFont('Arial','',8);
	$pdf->MultiCell(78,6,$order->products[$i]['name'],1,'L');
	}
else if (strlen($order->products[$i]['name']) > 50){
	$pdf->SetFont('Arial','',8);
	$pdf->MultiCell(78,6,substr($order->products[$i]['name'],0,50),1,'L');
	}
else{
	$pdf->MultiCell(78,6,$order->products[$i]['name'],1,'L');
	}
$pdf->SetFont('Arial','',8);
//$pdf->SetY($Y_Table_Position);
//$pdf->SetX(95);
//$pdf->MultiCell(15,6,tep_display_tax_value($order->products[$i]['tax']) . '%',1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(15);
   $pdf->SetFont('Arial','',8);
$pdf->MultiCell(25,6,$order->products[$i]['model'],1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(118);
   $pdf->SetFont('Arial','',8);
$pdf->MultiCell(20,6,$currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(138);
$pdf->MultiCell(20,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']),1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(158);
$pdf->MultiCell(20,6,$currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(178);
$pdf->MultiCell(20,6,$currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']),1,'C');
$Y_Table_Position += 6;

   //Check for product line overflow
    $item_count++;
   if ((is_long($item_count / 32) && $i >= 20) || ($i == 20)){
       $pdf->AddPage();
       //Fields Name position
       $Y_Fields_Name_position = 125;
       //Table position, under Fields Name
       $Y_Table_Position = 70;
       output_table_heading($Y_Table_Position-6);
       if ($i == 20) $item_count = 1;
   }
}
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
$pdf->SetY($Y_Table_Position + 5);
$pdf->SetX(102);
$temp = substr ($order->totals[$i]['text'],0 ,3);
//if ($i == 3) $pdf->Text(10,10,$temp);
if ($temp == '<b>')
	{
	$pdf->SetFont('Arial','B',8);
	$temp2 = substr($order->totals[$i]['text'], 3);
	$order->totals[$i]['text'] = substr($temp2, 0, strlen($temp2)-4);
	}
$pdf->MultiCell(94,6,$order->totals[$i]['title'] . ' ' . $order->totals[$i]['text'],0,'R');
$Y_Table_Position += 5;
}
// Draw the shipping address for label
//Draw the invoice delivery address text
/*
   $pdf->SetFont('Arial','B',8);
$pdf->SetTextColor(0);
//$pdf->Text(117,61,ENTRY_SHIP_TO);
//$pdf->SetX(0);
$pdf->SetY(240);
   $pdf->Cell(20);
$pdf->MultiCell(50, 4, strtoupper(tep_address_format(1, $order->delivery, '', '', "\n")),0,'L');
	*/
	}
// PDF's created now output the file
$pdf->Output();
?>

Share this post


Link to post
Share on other sites

Yes, now are running correctly. Only I need make a the changes that I had before with care and backup.

 

Thank you Frogger34.

Edited by tejure

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×