Warning: mktime() [function.mktime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/globalIncludes/hilfsfunktionen.php on line 875
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for 'UTC/0.0/no DST' instead in /var/www/html/globalIncludes/hilfsfunktionen.php on line 875
cron sonos umsatz aggregation 2025-03-14 13:18:54-----------------------------------------------
select
o.id 'Location ID',
e.id 'Einsatz ID',
e.id_promoter,
date_format(e.datum,'%u') 'KW',
pro.nachname 'PT Name',
pro.vorname 'PT Vorname',
p.name,
v.menge,
p.uvp 'UVP',
p.uvp*v.menge 'Umsatz',
ppp.provision_doit * v.menge 'Provision'
from verkauf v
join einsatz e on e.id=v.id_einsatz
join ort o on o.id=e.id_ort
join promotion pr on e.id_promotion=pr.id
join promoter pro on pro.id=e.id_promoter
join produkt p on v.id_produkt=p.id
join promotionprodukt pp on pp.id_produkt=p.id and pp.id_promotion='848'
left join promotion_jobnummer pj on pj.jobnummer=e.jobnummer and pj.id_promotion=e.id_promotion
left join sonos_ort so on so.id_ort=o.id
left join promotionproduktprovision ppp on ppp.id_promotionprodukt=pp.id and e.datum between ppp.datum_von and datum_bis
where e.id_promotion='848' and pp.zaehlt_fuer_bonus=1
and (v.menge > 0 ) and date_format(e.datum,'%Y%u')='202511'
Total Umsatz: 0
Total Provision: 0