prepare('
SELECT '.$wpdb->prefix.'ap_transaction.SubId AS postID,
round(sum('.$wpdb->prefix.'ap_transaction.Commission),2) as commission,
round(sum('.$wpdb->prefix.'ap_transaction.Confirmed), 2) as confirmed,
'.$wpdb->posts.'.post_title
FROM '.$wpdb->prefix.'ap_transaction
LEFT JOIN '.$wpdb->posts.'
ON '.$wpdb->prefix.'ap_transaction.SubId = '.$wpdb->prefix.'posts.ID
WHERE TransactionStatus <> "Cancelled"
GROUP BY SubId
ORDER BY sum('.$wpdb->prefix.'ap_transaction.Commission) DESC
LIMIT 12');
$topArticleData = $wpdb->get_results($sql, ARRAY_A);
if ($options['add-sub-ids'] === 0) {
$topArticleHeadline = 'Top SubIds';
$topArticelRowHeadline = 'SubId';
}
else {
$topArticleHeadline = 'Top Artikel / Seiten';
$topArticelRowHeadline = 'Artikel';
}
//Top Partner
$sql = $wpdb->prepare('
SELECT concat (ProgramTitle, " (", network, ")") as program,
round(sum(Commission),2) as commission,
round(sum(Confirmed), 2) as confirmed
FROM '.$wpdb->prefix.'ap_transaction
WHERE TransactionStatus <> "Cancelled"
GROUP BY ProgramId, network
ORDER BY sum(Commission) DESC
LIMIT 12');
$topPartnerData = $wpdb->get_results($sql, ARRAY_A);
//Networks
$sql = $wpdb->prepare('
SELECT network,
round(sum(Commission),2) as commission,
round(sum(Confirmed), 2) as confirmed
FROM '.$wpdb->prefix.'ap_transaction
WHERE TransactionStatus <> "Cancelled"
GROUP BY network
ORDER BY sum(Commission) DESC
LIMIT 12');
$networkData = $wpdb->get_results($sql, ARRAY_A);
//Last Days
$sql = $wpdb->prepare('
SELECT date_format(date, "%%d.%%m.%%Y") as date_de,
round(sum(Commission),2) as commission,
round(sum(Confirmed), 2) as confirmed
FROM '.$wpdb->prefix.'ap_transaction
WHERE TransactionStatus <> "Cancelled"
GROUP BY date(date)
ORDER BY date DESC
LIMIT 12');
$dayData = $wpdb->get_results($sql, ARRAY_A);
//Last Weeks
$sql = $wpdb->prepare('
SELECT concat ("KW ", weekofyear(date)) as week,
round(sum(Commission),2) as commission,
round(sum(Confirmed), 2) as confirmed
FROM '.$wpdb->prefix.'ap_transaction
WHERE TransactionStatus <> "Cancelled"
GROUP BY weekofyear(date)
ORDER BY date DESC
LIMIT 12');
$weekData = $wpdb->get_results($sql, ARRAY_A);
//Last Months
$sql = $wpdb->prepare('
SELECT concat (monthname(date), " ", year(date)) as month_year,
round(sum(Commission),2) as commission,
round(sum(Confirmed), 2) as confirmed
FROM '.$wpdb->prefix.'ap_transaction
WHERE TransactionStatus <> "Cancelled"
GROUP BY month(date), year(date)
ORDER BY year(date) DESC,
month(date) DESC
LIMIT 12');
$monthData = $wpdb->get_results($sql, ARRAY_A);
?>
Statistiken
|
Einnahmen |
|
Einnahmen |
(Id: '.$article['postID'].')';
} else {
$permalink = get_permalink($article['postID']);
$output_post = sprintf('%s',$permalink, $article['post_title']);
}
}
$total_earning = number_format($article['commission'], 2, ',', '.');
$confirmed_earning = number_format($article['confirmed'], 2, ',', '.');
$output_earning = $total_earning . ' € ('.$confirmed_earning.' €)';
echo ('| '.$output_post.' | '.$output_earning.' |
');
}
?>
Top Partner
| Partner |
Einnahmen |
| Partner |
Einnahmen |
'.$confirmed_earning.' €)';
echo ('| '.$partner['program'].' | '.$output_earnings.' |
');
}
?>
Netzwerke
| Netzwerk |
Einnahmen |
| Netzwerk |
Einnahmen |
'.$confirmed_earning.' €)';
echo ('| '.$network['network'].' | '.$output_earnings.' |
');
}
?>
Die letzten Tage
| Tag |
Einnahmen |
| Tag |
Einnahmen |
'.$confirmed_earning.' €)';
echo ('| '.$day['date_de'].' | '.$output_earnings.' |
');
}
?>
Die letzten Wochen
| Woche |
Einnahmen |
| Woche |
Einnahmen |
'.$confirmed_earning.' €)';
echo ('| '.$week['week'].' | '.$output_earnings.' |
');
}
?>
Die letzten Monate
| Monat |
Einnahmen |
| Monat |
Einnahmen |
'.$confirmed_earning.' €)';
echo ('| '.$month['month_year'].' | '.$output_earnings.' |
');
}
?>