Community Add-Ons

This is and update to the previous package. Much thanks to tania63 and xtronics for added functionality. Many thanks to the originator denuz for this contribution and Christophe for all his hard work!

-Updates include sorting options (xtronics)
-Table updates so contribution works w/ & w/o table prefixes.
-Language files (en,fr,ger, spanish)
-Code cleaned up and all bugfixes applied
-instructions updated

This is the full package. Please check the install_readme.txt file if you need help.

This is the french language, it's not a full package, just repalce stats_sales.php in /admin/includes/langages/french
and replace, this not the full package.

Pour mettre en français, télécharger et remplacer le fichier stats_sales.php dans /admin/includes/langages/french

Merci

Using variables for table names. Report will now work even if your osCommerce tables have a prefix.

Replace the catalog/admin/stats_sales.php file with the one in this zip file.

Added some sort options - click on headers to change sorts. Most often I want to see the sort by either units sold or value sold - so I made it work.

This is just the one file - replace it after installing the latest version.

Quantities were not being caluculated properly in either of the last 2 uploads. Replace the catalog/admin/stats_sales.php file with the one in this zip file.

The daily dollar purtchase amount was not being calculated correctly. Just replace the catalog/admin/stats_sale.php file with this one and you will be all set.

The update from 23 feb 2005 is not for this contribution, but the bug was same. This update corrects it.
Also removed the display of the date when viewing the report per product (date as no meaning in this case).

Full update.

Added a column for prices including tax, as well as total with tax for the month. Language file updated.

Full package.

Bonjour,
La contrib [URL=http://www.oscommerce.com/community/contributions,539]MonthlySales$Tax2.1.1[/URL] pour MS2 propose un affichage détaillé par mois ou par jour des ventes et des taxes collectées, mais il y a un bug dans la requete SQL qui concerne l'affichage détaillé par jour, et les données affichées sont fausses (colonnes ventes taxées et ventes non taxées)
.
(Le problème ne concerne pas la vue par mois)

Pour corriger le problème :

dans le fichier admin/stats_monthly_sales.php

trouver la ligne (vers la ligne 458 )

[CODE]
$taxed_query_raw .= " and dayofmonth(o.date_purchased) = '" . $sales['row_day'] . "' group by o.date_purchased";[/CODE]
et la remplacer par
[CODE]
$taxed_query_raw .= " and dayofmonth(o.date_purchased) = '" . $sales['row_day'] . "' group by dayofmonth(o.date_purchased)";[/CODE]

Notez que la contrib installée sur la CReload 6 est antérieure à la version 2.1.1, et ne propose pas l'affichage détaillé par jour, elle n'est pas concernée par le pb.

Pour ceux que cela interresse, je prépare une version française de cette contrib ...

@++

Fix the problem of having two Lines of title displayed

- added order-status drop down
- small bugfix

thanks to christophe for code optimization.

Sorry I was too fast yesterday. The v1.2 does not display correctly the quantity of products sold when viewing the sales report per product.

See instructions inside.

Full package

You can now see your monthly sales per day (like before) or per product (new).

Added a column for the product model.

Full package.

Sorry, I've been too fast for the previous post.
Small bugs corrected:
- Define for the text in BOX moved to english.php (same for other languages), see install.txt.
- For the 1st day with sales, the date was not displayed. Corrected in admin/month_sales.php.

This is the full package

- use filenames.php and language files for more osC compliant code.
- use mysql to group sales by day and product, which makes the code easier and faster.
- added monthly total at then end.

showing per-day statistic about sales within selected month.