All Invoices Report [support]

**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) {

**southshorepizza** · 17 Apr 2014, 11:02 PM

That didn't work due to a typo but it set me on the right path. Here is the fix in case anyone else is ever interested.

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 IN (1,2) ORDER BY orders_id DESC";
$pending_orders = $db->Execute($sql);

while (!$pending_orders->EOF) {

**lat9** · 17 Apr 2014, 11:35 PM

Sorry 'bout that!

I'm glad I was able to point you in the right direction.

**southshorepizza** · 17 Apr 2014, 11:46 PM

This isn't really doing what I need it to do. On the admin/all_invoices.php how could I make the drop down box give me all statuses or mutliple statuses? I have the template_all_invoices.php to refresh and I can clear them off when orders are complete. However when a new order comes in with a status different than the one chosen on admin/all_invoices.php it will not show up automatically.

I tried duplicating the array but that didn't work. Another report (sales report) has a similar feature where status "doesn't matter" I haven't figured out how to make that work though.

**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).

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