Community Add-Ons

Full package with french

Pack entier incluant le français qui n'était pas mis dans le précédent pack

FULL PACKAGE

Package from "Black Jack 21" of 16 Aug 2008, and put together Dutch and Swedish language.

My contribution is the Portuguese language that is also on the package.

The addition of the Swedish language file stats_sales.php and installation instruction including the adding of the name in the swedish.php file in the admin directories.

This is NOT a full package, only the Swedish language.

Just the addition of the Dutch language file stats_sales.php and the installation instruction including the adding of the name in the dutch.php file, all in the admin directories.

- Added various text definitions
- Fixed tags
- Alter page heading section to fit size equal to normal osC reports
- Added different texts for MONTHLY_TOTAL_SALES depending on status selection
- Added commission display depending on status selection and how commission is defined

This is a full package.

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.