Monthly Sales and Tax Summary Report [support thread]

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.

<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

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://github.com/lat9/monthly_sales_and_tax

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://github.com/lat9/monthly_sales_and_tax
Now available for download.

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?

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.

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?

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.

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.

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

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?

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

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

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?

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.