12 replies to this topic

[Eclipse16V]

Hi

I have a Problem with this Addon on my 2.3.1:

PDF Invoice
http://addons.oscommerce.com/info/3027

There are nothing Data on the PDF.
Layout OK but No Shipping Address, no Items, ...

Please Help

[Eclipse16V]

No one how can help me?

[14steve14]

Are you sure that it is compatible with 2.3.1. It doesnt look to be.

[Eclipse16V]

hmmmm
is there an other addon who works with 2.3.1?

[Xpajun]

I've just looked at the contribution that you list above - there is no reason that I can see why this should be incompatible with v2.3 - is is a stand alone add-on with no alteration needed to any of the existing files.

I don't know why you aren't getting the data showing ~ I'd suggest re uploading all the files again

[elminster82]

I've tried to installa Pdf Invoce 1.6.2 in OSCommerce 2.3.1
I get and error during SQL query import (with PhpMyAdmin):
[indent]ERROR: Quotes Not Closed @ 48984
STR: '
SQL: # phpMyAdmin SQL Dump
[/indent]
Also Step 4 in installation readme is not compatible with version 2.3.1:
[indent]4- - Open /admin/orders.php

Find:

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');

AFTER ADD:

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_PDF_INVOICE, 'oID=' .$oInfo->orders_id) . '" target="_blank">' . tep_image_button('button_invoice_pdf.gif', IMAGE_ORDERS_INVOICE) . '</a>');

$contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link( FILENAME_PDF_PACKINGSLIP, 'oID=' .$oInfo->orders_id) . '" target="_blank">' . tep_image_button('button_packingslip_pdf.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');


Find :

<a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>

AFTER ADD

<a href="' . tep_href_link(FILENAME_PDF_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice_pdf.gif', IMAGE_ORDERS_INVOICE) . '</a>

<a href="' . tep_href_link( FILENAME_PDF_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip_pdf.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> [/indent]


Can anyone help me please?

Thanks

[Xpajun]

You are looking for:

        $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_ORDERS_INVOICE, 'document', tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $oInfo->orders_id), null, array('newwindow' => true)) . tep_draw_button(IMAGE_ORDERS_PACKINGSLIP, 'document', tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $oInfo->orders_id), null, array('newwindow' => true)));

You should change the pdf script to match something like:

        $contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_ORDERS_INVOICE, 'document', tep_href_link(FILENAME_PDF_INVOICE, 'oID=' . $oInfo->orders_id), null, array('newwindow' => true)) . tep_draw_button(IMAGE_ORDERS_PACKINGSLIP, 'document', tep_href_link(FILENAME_PDF_PACKINGSLIP, 'oID=' . $oInfo->orders_id), null, array('newwindow' => true)));

You will probably need to play with this as I've not tested it

[Mrstech]

elminster82, on 09 February 2011, 20:05, said:

I've tried to installa Pdf Invoce 1.6.2 in OSCommerce 2.3.1
I get and error during SQL query import (with PhpMyAdmin):
[indent]ERROR: Quotes Not Closed @ 48984
STR: '
SQL: # phpMyAdmin SQL Dump
[/indent]

Hi,

I hope by now you have been able to do the sql import. If not, you will have to remove the "configuration_id" field and its empty values from the INSERT query. Since this value is "auto_increment", it should not be part of the query.

Mrstech

[berthz]

If anyone wants to know. I had the same problem as described above (no details on invoice). Just open invoice_pdf.php

find:

$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . 110 . "'");
$order = new order($oID);

change it into

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

find:

// PDF's created now output the file
  // are we streaming for email attachment or outputting to browser?

change it into

// PDF's created now output the file
  // are we streaming for email attachment or outputting to browser?
}

Should do the trick. At least for me it did.

[jhaugen]

Has anyone successfully installed this addon on a 2.3.1 store using the suggestions above. That is:
* Modify the SQL as per Mrstech
* Modify pdf_invoce.php as per berthz
* Change the instructions for order.php as per Xpajun
Is there anything else that needs to be patched to get from 2.2 to 2.3.1?

[Zrippirium]

Hmm... I've tried to install this contribution. I believe I followed the above advices too, not totally certain but believe so. I have finally been able to make it so I can see the PDF files now through admin... Although I wonder what set_magic_quotes_runtime() does...? I am sorry that I only have a basic understanding for PHP and that I'm no expert at it yet... I read about it in the posts I found on the PHP website, and it seems it might have been used for security? Am I right? If so, what should I do to get the same protection as that might have given me?

To be able to see the PDF files I had to comment out the following lines in fpdf.php; 910, 923, 1167, 1205, and 1500. This is since I got an error message saying set_magic_quotes_runtime() is deprecated. I seek an understanding for what these lines did, and also advices on what I should replace them with if anything else is required instead. (Mainly if there is a security flaw being created by removing those lines.) I am very grateful for any and all attempts at helping me gaining a greater understanding about this.


Have a nice day/evening/night/dawn
-Zrippirium

[kymation]

The problem is that the FPDF library is badly out of date. It's not only the deprecated functions that you commented out; it also doesn't understand Unicode fonts. The best solution I've found is to replace it with th TCPDF library. I haven't tried this with this Addon, but I have done it for a different one and it worked without problems.

Regards
Jim

[Zrippirium]

Okay, thank you very much for your reply. I suppose I will have to try to find out more about this "TCPDF library" then. Aswell as how to replace the FPDF library.

Edited by Zrippirium, 07 December 2011, 08:00.