All Invoices Report [support]

**lat9** · 5 Jan 2014, 07:39 PM

FWIW, I submitted an updated version (v2.0.0) of this plugin that supports Zen Cart v1.5.0 and later ... last May ... and "forgot"

to note that change here! The plugin can be downloaded here: http://www.zen-cart.com/downloads.php?do=file&id=1083

**lat9** · 3 Apr 2014, 09:10 PM

v2.1.0 was just submitted to the Plugins:

Now provides capability to print all packing slips, too
BUGFIX: Page breaks didn't work in Google Chrome

**lat9** · 8 Apr 2014, 01:29 PM

v2.1.0 is now available in the Plugins: http://www.zen-cart.com/downloads.php?do=file&id=1083

**southshorepizza** · 15 Apr 2014, 06:08 PM

I am finally found most of what I was looking for! Thank you! two questions.
1) I would like to display all statuses at once.
1) I would like to make orders display descending on the page.

Can someone please provide the code changes for this. It can be for either invoices or packing slips.

Thank you!

**lat9** · 15 Apr 2014, 06:51 PM

It'll be a small edit to /YOUR_ADMIN/includes/templates/tpl_all_invoices.php (for the invoices). Locate the lines that read:

Code:

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<?php

$sql = "SELECT orders_id FROM ".TABLE_ORDERS." WHERE orders_status = ".$orderStatus;
$pending_orders = $db->Execute($sql);

while (!$pending_orders->EOF) {

and make the following changes:

Code:

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<?php

$sql = "SELECT orders_id FROM ".TABLE_ORDERS." ORDER BY orders_id DESC";
$pending_orders = $db->Execute($sql);

while (!$pending_orders->EOF) {

That will select ALL the orders from your store and print them in descending order-id order.

**southshorepizza** · 17 Apr 2014, 09:23 PM

How do I make the admin/all_invoices.php select both pending and processing statuses at the same time? Ideally this would just be a default setting. Delivered and updated don't even matter to me. But I do need to see pending and processing on the same report simultaneously.

Thank you.

**lat9** · 17 Apr 2014, 09:58 PM

Originally Posted by southshorepizza

How do I make the admin/all_invoices.php select both pending and processing statuses at the same time? Ideally this would just be a default setting. Delivered and updated don't even matter to me. But I do need to see pending and processing on the same report simultaneously.

Thank you.

Make a change similar in nature to the change I identified in post #21:

Code:

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<?php

$sql = "SELECT orders_id FROM ".TABLE_ORDERS." WHERE orders_id IN (1,2) ORDER BY orders_id DESC";
$pending_orders = $db->Execute($sql);

while (!$pending_orders->EOF) {

**lolwaut** · 6 Jul 2014, 04:23 AM

Originally Posted by lat9

v2.1.0 is now available in the Plugins: http://www.zen-cart.com/downloads.php?do=file&id=1083

Hi,

I am still on version 1.1 of this plugin because I am still running ZenCart 1.39h. I would love to have the print all packing slip functionality. Would the 1.1 code be easy to modify to allow for printing of all packing slips? Any help is greatly appreciated... thanks!

**lat9** · 6 Jul 2014, 12:58 PM

Originally Posted by lolwaut

Hi,

I am still on version 1.1 of this plugin because I am still running ZenCart 1.39h. I would love to have the print all packing slip functionality. Would the 1.1 code be easy to modify to allow for printing of all packing slips? Any help is greatly appreciated... thanks!

Taking a quick look at the code, there are no core file overwrites and I check before using the v1.5.0+ functions. The code should work, it just won't integrate into your v1.3.9h admin's menu structure so you'll need to enter its address directly into your browser:

yourhost.com/YOUR_ADMIN/all_invoices.php
yourhost.com/YOUR_ADMIN/all_packingslips.php

If it doesn't work in a ZC 1.3.9h environment, just remove the files copied (the full file list is in the readme).

**lolwaut** · 6 Jul 2014, 06:59 PM

Originally Posted by lat9

Taking a quick look at the code, there are no core file overwrites and I check before using the v1.5.0+ functions. The code should work, it just won't integrate into your v1.3.9h admin's menu structure so you'll need to enter its address directly into your browser:

yourhost.com/YOUR_ADMIN/all_invoices.php
yourhost.com/YOUR_ADMIN/all_packingslips.php

If it doesn't work in a ZC 1.3.9h environment, just remove the files copied (the full file list is in the readme).

Thanks a bunch! The new versions notes said it was strictly for 1.5 so I was worried that the code was drastically different. I'm happy to hear that isn't the case!

I got this 2.1 version working on my 1.39h install flawlessly. I managed to add the menu items for it by including this file:

/admin/includes/boxes/extra_boxes/all_invoices_reports_dhtml.php

Code:

  $za_contents[] = array('text' => BOX_ALL_INVOICES, 'link' => zen_href_link(FILENAME_ALL_INVOICES, '', 'NONSSL'));
  $za_contents[] = array('text' => BOX_ALL_PACKINGSLIPS, 'link' => zen_href_link(FILENAME_ALL_PACKINGSLIPS, '', 'NONSSL'));

Thank you!

Thread: All Invoices Report [support]

Thread Tools

Search Thread

Display

Hybrid View

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Re: All Invoices Report [support]

Similar Threads

v152 Support Thread: Report All Errors (Even Warnings)

v154 Editable Invoices & Packing Slips [Support]

v139h Print all outstanding invoices, print Avery labels, mark all orders sent

Admin Activity Report [support thread]

printing all invoices

Posting Permissions