Monthly Sales and Tax Summary Report [support thread]

Quote:

---

Originally Posted by dbltoe

You posted a problem. Admittedly after drByte fixed the other problem by realizing you were using the wrong admin.
Then, you posted the "can't get a CSV" problem. It was great that you posted the code for the error.
This (and one other) volunteer took the time to look up a solution. It was a very simple cut and paste of the problem into google that led us to a solution.
You claimedI pointed out that the dropdown had a specific fix for your failure to get a CSV.
In the time you've spent trying to avoid your host or the fix, it could have been done.
Won't bother you again.

---

Both the link you posted and the link by Haredo in the following post stated that these warnings continued after applying this fix.

Code:

---

<IfModule mod_fcgid.c>
FcgidMaxRequestsPerProcess 500
</IfModule>

---

Consequently, I was reluctant to adopt your advice.

In order to be collegiate, I decide to try your solution anyway.
My supplier does not give me access to this configuration.

I gave my supplier full details and asked them to make the change. I got the following reply

Quote:

---

no, this is a shared hosting system.
We don't think this setting is the problem here.

---

I do agree that Dr. Byte is a very competent resource.

I've just submitted v2.0.0 of the Monthly Sales and Tax Report for the Zen Cart moderators' review; I'll post back here when it's available for download (https://www.zen-cart.com/index.php?ma...oducts_id=1043).

Many changes needed to support now-current PHP versions and strict MySQL installations!

- Remove use of to-be-deprecated `strftime`.
- Modify SQL queries to support strict MySQL installations; correcting fields missing from `GROUP BY`.
- Correcting various PHP notices, deprecations and warnings.
- Use Bootstrap modals for popup displays.

Note: This report's GitHub repository is https://github.com/lat9/https://gith..._sales_and_tax

Quote:

---

Originally Posted by lat9

I've just submitted v2.0.0 of the Monthly Sales and Tax Report for the Zen Cart moderators' review; I'll post back here when it's available for download (https://www.zen-cart.com/index.php?ma...oducts_id=1043).

Many changes needed to support now-current PHP versions and strict MySQL installations!

- Remove use of to-be-deprecated `strftime`.
- Modify SQL queries to support strict MySQL installations; correcting fields missing from `GROUP BY`.
- Correcting various PHP notices, deprecations and warnings.
- Use Bootstrap modals for popup displays.

Note: This report's GitHub repository is https://github.com/lat9/https://gith..._sales_and_tax

---

Now available for download.

Quote:

---

Originally Posted by lat9

Now available for download.

---

Okay I'm feeling dumb this morning... downloaded and uploaded, tried to run the script file in tools and got an error, and when I load it directly into file manager it doesn't work either.

It's been a while since I've done one of these so what step am I missing when activating the js file?

Quote:

---

Originally Posted by Elemi

Okay I'm feeling dumb this morning... downloaded and uploaded, tried to run the script file in tools and got an error, and when I load it directly into file manager it doesn't work either.

It's been a while since I've done one of these so what step am I missing when activating the js file?

---

That script file (.js) is a jQuery file used by the report; it's not a SQL script. The installation's handled by the report's initialization file.

Quote:

---

Originally Posted by lat9

That script file (.js) is a jQuery file used by the report; it's not a SQL script. The installation's handled by the report's initialization file.

---

That's what I thought it should be... it doesn't appear to be working in that case... I'm getting an HTP Error 500 when I click on it in reports. Could I have something interfering with it even though no core files have changed?

Quote:

---

Originally Posted by Elemi

That's what I thought it should be... it doesn't appear to be working in that case... I'm getting an HTP Error 500 when I click on it in reports. Could I have something interfering with it even though no core files have changed?

---

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

Quote:

---

Originally Posted by lat9

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

---

I downloaded the plugin and it appears the file includes/classes/MonthlySalesAndTax.php is missing from the download.

Quote:

---

Originally Posted by Carbonless

I downloaded the plugin and it appears the file includes/classes/MonthlySalesAndTax.php is missing from the download.

---

Well :censored:; let me get a point-release going. Thanks for the update.

The missing file IS available on the git repository... stats_monthly_sales.php

Quote:

---

Originally Posted by lat9

Well :censored:; let me get a point-release going. Thanks for the update.

---

Just submitted v2.0.1 to include that missing class file. See https://github.com/lat9/monthly_sales_and_tax for a quick update, too.

Approved; removed v2.0.0.

Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?

Quote:

---

Originally Posted by lat9

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

---

[28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138

Quote:

---

Originally Posted by Elemi

[28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138

---

Working now thanks to the missing file. :)

And I really like it! <3 <3

Quote:

---

Originally Posted by Carbonless

Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?

---

It might be. :unsure: Due to strict MySQL installations having hissy fits about fields missing from the GROUP BY and the erroneous results returned when they were added, I had to pull the MySQL SUM()'s from the queries and do the summing in PHP.

I'll look at the code (again) to see if that can be handled differently.

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

Quote:

---

Originally Posted by persion

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

---

That field (orders_status :: sort_order) was added in zc157, which is the only Zen Cart version currently supported by the report. What version of Zen Cart are you using?

Just submitted v2.0.2 for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains the (previously missing) /YOUR_ADMIN/includes/modules/sms/tpl_stats_monthly_sales_taxes.php and modifies its data-gathering so that a report's generation doesn't take 'centuries'!

I have zen cart version info:
Zen Cart 1.5.5d
Database Patch Level: 1.5.5
v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
v1.5.4 [2015-02-18 04:55:48] (New Installation)

PHP Version: 5.6.40 (Zend: 2.6.0)
Database: MySQL 5.5.62-cll

And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.

Quote:

---

Originally Posted by WiccanWitch420

I have zen cart version info:
Zen Cart 1.5.5d
Database Patch Level: 1.5.5
v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
v1.5.4 [2015-02-18 04:55:48] (New Installation)

PHP Version: 5.6.40 (Zend: 2.6.0)
Database: MySQL 5.5.62-cll

And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.

---

The newest version requires zc157+, so you'll need to install an older version.

I've just submitted v2.0.3 of the "Monthly Sales and Tax" report for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes to correct the following GitHub issues:

#7: Correct strict MySQL 5.7 fatal error
#8: Correct PHP notices for missing totals in a given timeframe.

Quote:

---

Originally Posted by lat9

I've just submitted v2.0.3 of the "Monthly Sales and Tax" report for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes to correct the following GitHub issues:

#7: Correct strict MySQL 5.7 fatal error
#8: Correct PHP notices for missing totals in a given timeframe.

---

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=734

Zen cart 1.5.7d PHP 7.4
Can someone tell me why this is happening with the version V2.0.3 previous version worked well. Months and days all over the place . Thanks
Attachment 20005 Attachment 20006

Thanks for the report; see this GitHub issue for the root-cause (https://github.com/lat9/monthly_sales_and_tax/issues/9). v2.0.4 coming shortly.

v2.0.4 has been submitted for the Zen Cart moderators' review.

This release corrects the dates' sorting by gathering the dates using 2-digit months and days; see GitHub issue #9.

@lat9
Brilliant thanks that fixed the issue, originally thought I had done something wrong in the language/english file..

@lat9
I have noticed that refunds are not removed from the sales value is it possible to add this?

Quote:

---

Originally Posted by ianhg

@lat9
I have noticed that refunds are not removed from the sales value is it possible to add this?

---

Refunding is a payment-method-specific process. I'll consider adding a couple of notifications to enable that addition.

GitHub issue for tracking: https://github.com/lat9/monthly_sales_and_tax/issues/10

Cindy, older versions of this module had the ability to filter not just by order status but by zone as well - is this something you'd be willing to add back in?

Quote:

---

Originally Posted by swguy

Cindy, older versions of this module had the ability to filter not just by order status but by zone as well - is this something you'd be willing to add back in?

---

@swguy, I'll give it a look. That might have been in a one-off (not captured in GitHub) update. Please open an issue on https://github.com/lat9/monthly_sales_and_tax/

Done. https://github.com/lat9/monthly_sales_and_tax/issues/11

hi @lat9! When I export to a CSV and tick the "Output Order Total Validation Column" checkbox, this column is not present in the CSV. What could be wrong?

Quote:

---

Originally Posted by lolwaut

hi @lat9! When I export to a CSV and tick the "Output Order Total Validation Column" checkbox, this column is not present in the CSV. What could be wrong?

---

You have this report confused with the "Sales Report" (https://www.zen-cart.com/downloads.php?do=file&id=9).

Noting that the "Order Total Validation" column for that report is a display-only output, since the CSV can be customized using your spreadsheet tool to provide a similar function.

Just wondering if there's been any progress on adding 'filter by zone' back into this plugin? I've been using the older 1.5.4 version of this plugin to split my sales by province so I can report the correct amount of tax I collected for each province. I'm really missing this feature in the new version, and I'd love it if it could be added back in.

No progress, but you've reminded me!

Thanks!

Have been using this report for years but just recently noticed some of my months showing zero sales. I was running v1.5.4 of the report on zencart 1.5.7c when this happened. This morning I updated to 2.0.4. Now the report shows sales for each month in the main overall summary however if I click on individual months some show "NO INCOME FOR THIS DATE/STATUS SELECTION" even though the main overall page does report income. Some individual months work fine. Also some months show items under Untaxed Sales with something like 12 digits after the decimal point (example 2408.7200000000003 ). I had not made any changes to my cart system in some time. This is under php 7.3.33 according to my site cp. After further investigation I just realized that my host upgraded to mysql 8 today. I suspect 2.0.4 has some compatibility problem. Any ideas?

Quote:

---

Originally Posted by spyderrobotics

Have been using this report for years but just recently noticed some of my months showing zero sales. I was running v1.5.4 of the report on zencart 1.5.7c when this happened. This morning I updated to 2.0.4. Now the report shows sales for each month in the main overall summary however if I click on individual months some show "NO INCOME FOR THIS DATE/STATUS SELECTION" even though the main overall page does report income. Some individual months work fine. Also some months show items under Untaxed Sales with something like 12 digits after the decimal point (example 2408.7200000000003 ). I had not made any changes to my cart system in some time. This is under php 7.3.33 according to my site cp. After further investigation I just realized that my host upgraded to mysql 8 today. I suspect 2.0.4 has some compatibility problem. Any ideas?

---

Too many plugins, too little time. This is on my list, but others (and clients) take precedence.

Hi Cindy, I just wanted to let you know that I've hacked together a SQL query outside ZC that gives me what I need for my tax reporting without using this plugin, so you can take 'reinstate the filter by zone ability' off your to-do list, if it was just there because of me! Thanks :)

v3.0.0 of "Monthly Sales and Tax Report" is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=734

This is the first release of the report as a Zen Cart encapsulated plugin; requiring Zen Cart 2.1.0 or later! Now supporting the selection of the order's state for the report.

Fantastic! Thank you.

Quote:

---

Originally Posted by swguy

Fantastic! Thank you.

---

Thank @retched; he's the one that did the base encapsulation changes!

Thank you @retched!