zzfritz Posted January 4, 2003 Share Posted January 4, 2003 I just posted version 1.5 of the Monthly Sales & Tax Report: http://www.oscommerce.com/community/contributions,539 The report works only for snapshots since 2002-04-08. It presents a summary by month of all orders or by status of orders, breaking the gross income into components (products, tax, shipping, low order fees, other) and separates taxed sales from non-taxed sales, for general accounting purposes and to assist in the preparation of sales tax filings. The data can also be shown in a printer-friendly window, or downloaded as a file of comma separated values. A descriptive Help popup is also provided. This version corrects the query for the extra class column, and clears the annual footer totals properly. And, for sites whose servers balk at the csv file capability, this is now easily disabled. Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 Very hand little report but... Im probably missing something here but when i run report i get the wonderful errors: Warning: fopen("temp.csv", "w") - Permission denied in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 416 Warning: fwrite(): supplied argument is not a valid File-Handle resource in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 417 Warning: fclose(): supplied argument is not a valid File-Handle resource in /home/stadmin/public_html/test/admin/stats_monthly_sales.php on line 418 Its probably something really stupid like a php setting but im half asleep and cant remember how to sort it. anyone know??? Quote Link to comment Share on other sites More sharing options...
zzfritz Posted January 18, 2003 Author Share Posted January 18, 2003 These errors indicate that on our server the script does not have permission to open the file for writing the csv data. Read step 6 in the install.txt: If the csv file commands cause fatal errors on your server, the csv capability may be disabled. Merely edit the file admin/stats_monthly_sales.php and change the value of the variable $csv_enabled at line 43 to false instead of true. Then, the File choice will not be displayed, and the csv data will not be stored into a file. If you disable the csv file capability, the report will run fine in all other respects. The next revision of this contribution will use another method to present the csv data, so this error does not occur. Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 great thanks for the tip, it had me puzzled Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 ah now im totally stuffed i have no reference to $csv_enabled in the file stats_monthly_sales.php in admin.??? Quote Link to comment Share on other sites More sharing options...
Snowman Posted January 18, 2003 Share Posted January 18, 2003 version 1.4a didnt have this code. Ive loaded 1.5 and fixed the issue. :) Now i wonder how hard it is going to be to intergrate this mod with the graphs from the sales report mod??? That would be a nice feature :D Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.