Sales report 2.0

[linuxw00t]

[FONT=Arial Narrow]I'd kind of like to know why mine isn't working. I've uploaded everything correctly.

[/FONT][FONT=Arial Narrow] Zen Cart 1.3.7[/FONT]

[FONT=Arial Narrow][/FONT]PHP Version 4.3.11


Server OS: Linux 2.4.21-47.0.1.ELsmp

Database: MySQL 4.0.27-max-log

HTTP Server: Apache

[Stevietheman]

OK, I reloaded it again. Triple checked the locations. Now I have this error:

Parse error: syntax error, unexpected $end in /Library/WebServer/Documents/tc/admin/stats_sales_report.php on line 1187

Thanks for the help.

Here's the fix for this error...

On both lines 693 and 1029, change "<?" to "<?php".

Some PHP servers are configured such that they will choke if "<?" is used instead of "<?php" to begin PHP script.

Enjoy your sales report.

[Stevietheman]

Also, the "Show me the money!" button not doing anything can be fixed by going into sales_report.js.php and doing the following replaces:

1) Replace all "<?php////////////" with "////////////".
2) Replace all "///////////////?>" with "///////////////"

[Stevietheman]

Go to the Tools ... Install SQL Patches ...

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL; 

Does this correct the problem?

In my case, I was seeing the same error, but tinytext wasn't large enough, so instead I did the alter table like so...

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TEXT NULL DEFAULT NULL; 

Perhaps TEXT is too big, but I was lazy and just wanted it to work without too many steps.

[FullUp]

Hey Steve,

Thanks a bunch. Your changes fixed everything.

Jim

stats_sales_report.php
On both lines 693 and 1029, change "<?" to "<?php".

sales_report.js.php
1) Replace all "<?php////////////" with "////////////".
2) Replace all "///////////////?>" with "///////////////"

[Stevietheman]

Hey Steve,

Thanks a bunch. Your changes fixed everything.

Jim

stats_sales_report.php
On both lines 693 and 1029, change "<?" to "<?php".

sales_report.js.php
1) Replace all "<?php////////////" with "////////////".
2) Replace all "///////////////?>" with "///////////////"

My pleasure. It was just a result of my minor struggle to get it working for myself, and I figured I would help spare everyone else the pain.

It looks like a great mod. I can't wait to make some use out of it. Thanks BlindSide!

[BlindSide]

Huh, well my apologies to everyone on that one. The goal of the odd tags and comment slashes was to make the description appear when viewing the code but leave it out when the file was included at page load. I'll take it out for the next release.

Did that solution work for you, linuxw00t?

[FullUp]

BlindSide, your report is awesome and we all appreciate your sharing it and the time you spend keeping it up to date. Zen-cart is a great community.

Thank you!!!

Jim

[MikeyG]

Blind side

Just got this working having changed the admin log to text as above (Steve's fix - Thank you)

I have noticed that if I customise my date selection my start date is UK format (d-m-y) but the end is in US (m-d-Y) format. So If I choose 1st Jan to 2nd Jan I in fact get a report that finishes on 1st Feb.

Where can I fix this to be UK (d-m-y) format for everything.

I have changed the language file to get the reports showing the correct date format, it appears to be just this end date selection box which interprets the selection in the wrong way.

Thanks

MG

[BlindSide]

BlindSide, your report is awesome and we all appreciate your sharing it and the time you spend keeping it up to date. Zen-cart is a great community.

Thank you!!!

Jim

Your welcome. Glad you like it!

Blind side

Just got this working having changed the admin log to text as above (Steve's fix - Thank you)

I have noticed that if I customise my date selection my start date is UK format (d-m-y) but the end is in US (m-d-Y) format. So If I choose 1st Jan to 2nd Jan I in fact get a report that finishes on 1st Feb.

Where can I fix this to be UK (d-m-y) format for everything.

I have changed the language file to get the reports showing the correct date format, it appears to be just this end date selection box which interprets the selection in the wrong way.

Thanks

MG

This problem has been reported in the past. Currently, there is no way to change the date format accepted in the date search boxes. You must either enter the date manually in US m-d-y format or use the JavaScript calendar dropdown to set it for you automatically. An oversight on my part that I'll correct in a future release, my apologies.