prefix.'ap_transaction WHERE date(`Date`) = date(now()) AND TransactionStatus <> "Cancelled" '; $sum_today = $wpdb->get_var($sql); //yesterday $sql = ' SELECT sum(Commission) FROM '.$wpdb->prefix.'ap_transaction WHERE date(`Date`) = date(now() - interval 1 day) AND TransactionStatus <> "Cancelled" '; $sum_yesterday = $wpdb->get_var($sql); //this month $sql = ' SELECT sum(Commission) FROM '.$wpdb->prefix.'ap_transaction WHERE month(`Date`) = month(now()) AND year(`Date`) = year(now()) AND TransactionStatus <> "Cancelled" '; $sum_this_month = $wpdb->get_var($sql); //last month $month = date('n') - 1; $year = date('Y'); if ($month == 0) {$month=12; $year--;} $sql = ' SELECT sum(Commission) FROM '.$wpdb->prefix.'ap_transaction WHERE month(`Date`) = '.$month.' AND year(`Date`) = '.$year.' AND TransactionStatus <> "Cancelled" '; $sum_last_month = $wpdb->get_var($sql); //total $sql = ' SELECT sum(Commission) FROM '.$wpdb->prefix.'ap_transaction WHERE TransactionStatus <> "Cancelled" '; $sum_total = $wpdb->get_var($sql); $refresh_button = ' '; echo $refresh_button.'

Heute:	'.number_format($sum_today, 2, ',', '.').' €
Gestern:	'.number_format($sum_yesterday, 2, ',', '.').' €
Dieser Monat:	'.number_format($sum_this_month, 2, ',', '.').' €
Letzter Monat:	'.number_format($sum_last_month, 2, ',', '.').' €
Gesamt:	'.number_format($sum_total, 2, ',', '.').' €

Detailansicht'; } } ?>