Totally Zenned
- Join Date:
- Sep 2004
- Posts:
- 1,237
- Plugin Contributions:
- 1
Sales report 2.0
Yes, the Sales Report works with all versions of Zen Cart 1.3.x.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
Totally Zenned
Yes, the Sales Report works with all versions of Zen Cart 1.3.x.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
excellent, thanks for the reply BS
New Zenner
quick question.... is there anyway that instead of having this report on manufacturers, to have it report on record label/record artist instead?
Totally Zenned
It's not a drag-n-drop kind of feature, it would require customizing the report, both the class file (does the searching/calculations) and the admin page (search and report output).
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
Doesn't work with either Firefox of Safari.
Thank you
Totally Zenned
Make sure that the JavaScript file, sales_report.js.php, is in it's place in the admin/includes/javascript folder. For that matter, I would check the entire file upload.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
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.
Totally Zenned
What version of PHP are you running? Windows or Linux?
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
PHP Version 5.1.2
running on Mac OS X
New Zenner
I'd kind of like to know why mine isn't working. I've uploaded everything correctly.
Zen Cart 1.3.7
**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
New Zenner
FullUp:
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. :D
Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services
New Zenner
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:
Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services
New Zenner
Ajeh:
Go to the Tools ... Install SQL Patches ...
ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL;
In my case, I was seeing the same error, but tinytext wasn't large enough, so instead I did the *alter table* like so...
```php
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. :D
Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services
New Zenner
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
New Zenner
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
- Replace all "<?php////////////" with "////////////".
- 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!
Steve Magruder, Freelance Web Programmer
WebCommons :: Web Programming Services
Totally Zenned
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?
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
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
Totally Zenned
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
Totally Zenned
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
Your welcome. Glad you like it! :D
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
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.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
Blindside,
I'd also like to offer you my thanks for a module that is now something I use on almost a daily basis (an addict ... moi!). I know you receive a lot of features requests but if you don't mind I'd like to offer a few of my own:
Multiple selection for Payment Method, Manufacturer and Current Order Status.
An option to show orders by discount code or code(s) used.
Finally I'd echo my support for a UK date format!!
Thanks for all the continued work.
Visit our shop - RVOps - where compromise is not an option
Tell staff why this post should be reviewed.