Monthly Sales and Tax Summary Report [support thread]

A report that displays a summary of monthly or daily totals:
gross income (order totals)
subtotals of all orders in the selected period
nontaxed sales subtotals
taxed sales subtotals
tax collected
shipping/handling charges
low order fees (if present)
gift vouchers (or other additional order total component, if present)

Straight forward installation.

1. Unzip to a temp directory and upload all files to your admin store directory.
(The files are already arranged and there are *no* overwrites)

TO RUN
===============
2. Go to Admin->Reports>Monthly Sales.

This mod can be found in the Downloads section of Admin Tools:
http://www.zen-cart.com/index.php?ma...oducts_id=1043


Skip

Skip, thanks for this wonderful mod addition.

Just a quick question: I have no problem getting the CSV files from the mod to work with FF, but IE (v6) chokes on them. Is this something on my system, or a known issue? I haven't had a chance to try it on another computer yet.

KMK

KMK

Have had no issues with IE that I know of. Tested again today with IE 6 and IE 7 and had no problems.

Skip

Thanks for the fast reply, Skip. Must be something on my [sometimes :blink:] screwy system then.

~KMK

I installed this and it looks to be just what I want. The summary page shows ok but whenever I click on the month, a total to drill down, print or invert, all i get is another copy of the summary page. Clicking on Save CSV just shows CSV string empty. I tried both FF and IE and it is the same in both.

A quick answer would be a bad upload of the files. Try reloading the files and see if that fixes it. If not what version of zen-cart, mysql, php are you running.

Skip

I honestly can't remember if it was this MOD or another that I recently installed in my latest ZC adventure, but one of them had an extra / in the URL it was using. I'm inclinded to think it might have been this one, because fixing it solved the problem I was having with the unintuative IE, if I remember correctly (I also believe this memory loss come-down is what they refer to as having been ZENNED after working on a big e-commerce site with too many customizations :wacko:).

View the source on the page, and see if that's what's happening to you as well.

~KMK

Skip, I deleted the code and reinstalled: same thing happened. I'm running:
ZenCart 1.3.8a
MySQL 5.0.18
PHP Version: 5.2.6 (Zend: 2.2.0)

The data presented is all correct so it is getting at the database ok.
I thought a php variable may need changing but no idea what.

Quote:

---

Originally Posted by nosnappyname

Skip, I deleted the code and reinstalled: same thing happened. I'm running:
ZenCart 1.3.8a
MySQL 5.0.18
PHP Version: 5.2.6 (Zend: 2.2.0)

The data presented is all correct so it is getting at the database ok.
I thought a php variable may need changing but no idea what.

---

Looked at the code and did find a typo for the print option.

I also noticed that a lot of the coding used an old time way of ending a if statement.
So I fix that but I am running
ZenCart 1.3.8a
MySQL 5.0.33
PHP Version: 5.2.5 (Zend: 2.2.0)
And it works so I have attached stats_monthly_sales.zip unzip and then replace /admin/stats_monthly_sales.php with this file.
Let me know if this fixed it, If so I will build a new mod file for download.

Skip

Skip, that second version acted the same as the first, but..... I found a number of notes that said: "$HTTP_GET_VARS[] Is IDENTICAL to $_GET, however, it is depreciated, and no longer in use in php 5 + (correct me if I am wrong). PHP advises you use $_GET, $_POST, $REQUEST.. etc for all your super global needs."

So I changed $HTTP_GET_VARS to $_GET and $HTTP_POST_VARS to $_POST everywhere in stats_monthly_sales.php and everything seemed to work fine. I guess something in my ISP's settings are tighter than yours.

Anyway, thanks and it really looks like a useful contribution.