Hi Jossi,
wir hatten das gleiche Problem. Die Lösung ist ziemlich einfach: In der Start.php ca. ab Zeile 82 jedes Vorkommen von ot.value durch ot.value/o.currency_value austauschen. Bei uns sieht das jetzt so aus (o.orders_status ist bei dir eventuell anders):
// turnover
$turnover_query = xtc_db_query('select
round(coalesce(sum(if(date(o.date_purchased) = current_date, ot.value/o.currency_value, null)), 0), 2) today,
round(coalesce(sum(if(date(o.date_purchased) = current_date - interval 1 day, ot.value/o.currency_value, null)), 0), 2) yesterday,
round(coalesce(sum(if(extract(year_month from o.date_purchased) = extract(year_month from current_date), ot.value/o.currency_value, null)), 0), 2) this_month,
round(coalesce(sum(if(extract(year_month from o.date_purchased) = extract(year_month from current_date - interval 1 year_month), ot.value/o.currency_value, null)), 0), 2) last_month,
round(coalesce(sum(if(extract(year_month from o.date_purchased) = extract(year_month from current_date - interval 1 year_month) and o.orders_status <> 1, ot.value/o.currency_value, null)), 0), 2) last_month_paid,
round(coalesce(sum(ot.value/o.currency_value), 0), 2) total
from ' . TABLE_ORDERS . ' o
join ' . TABLE_ORDERS_TOTAL . ' ot on ot.orders_id = o.orders_id
where ot.class = \'ot_total\'');
In der Umsatzstatistik hingegen scheint es von Hause aus zu funktionieren. Zumindest ist in der /admin/includes/classes/sales_report.php in Zeile 106 folgendes zu finden:
$this->queryShipping = "SELECT sum(ot.value/o.currency_value) ...
Viele Grüße
WandbilderXXL (
http://www.wandbilderxxl.de )