'adverts_posts'
));
$currency_sign = get_option('revenue_currency');
while (have_posts()) : the_post();
$post_id = get_the_ID();
$image = akp_get_featured_image($post_id);
$dets = akp_return_fields($post_id);
// Get All Time Click Count
$all_clicks = $wpdb->get_results("SELECT COUNT(*) as clicks FROM ".$wpdb->prefix."akp_click_log WHERE post_id = '$post_id'");
$all_impressions = $wpdb->get_results("SELECT COUNT(*) as impressions FROM ".$wpdb->prefix."akp_impressions_log WHERE post_id = '$post_id'");
$all_impression_cost = $dets['akp_revenue_per_impression'][0];
$all_click_cost = $dets['akp_revenue_per_click'][0];
$all_per_impression = $currency_sign.number_format((int) $all_impression_cost, 2);
$all_impression_total = $all_impression_cost * $all_impressions[0]->impressions;
$all_impression_total_output = $currency_sign.number_format($all_impression_total, 2);
$all_per_click = $currency_sign.number_format((int) $all_click_cost, 2);
$all_click_total = $all_click_cost * $all_clicks[0]->clicks;
$all_click_total_output = $currency_sign.number_format((int) $all_click_total, 2);
$all_total_made = $all_impression_total + $all_click_total;
$all_total_made_output = $currency_sign.number_format((int) $all_total_made, 2);
// Get This Month Click Count
$month_start = mktime(0, 0, 0, date('n', current_time('timestamp')), 1, date('Y', current_time('timestamp')));
$month_end = mktime(23, 59, 59, date('n', current_time('timestamp')), date('t', current_time('timestamp')), date('Y', current_time('timestamp')));
$month_clicks = $wpdb->get_results("SELECT COUNT(*) as clicks FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$month_start' AND '$month_end' AND post_id = '$post_id'");
$month_impressions = $wpdb->get_results("SELECT COUNT(*) as impressions FROM ".$wpdb->prefix."akp_impressions_log WHERE timestamp BETWEEN '$month_start' AND '$month_end' AND post_id = '$post_id'");
$month_impression_cost = $dets['akp_revenue_per_impression'][0];
$month_click_cost = $dets['akp_revenue_per_click'][0];
$month_per_impression = $currency_sign.number_format((int) $month_impression_cost, 2);
$month_impression_total = $month_impression_cost * $month_impressions[0]->impressions;
$month_impression_total_output = $currency_sign.number_format((int) $month_impression_total, 2);
$month_per_click = $currency_sign.number_format((int) $month_click_cost, 2);
$month_click_total = $month_click_cost * $month_clicks[0]->clicks;
$month_click_total_output = $currency_sign.number_format((int) $month_click_total, 2);
$month_total_made = $month_impression_total + $month_click_total;
$month_total_made_output = $currency_sign.number_format((int) $month_total_made, 2);
// Get This Week click count
$start_week = get_option('week_starts');
if (strtolower(date('l', current_time('timestamp'))) == $start_week) {
$day = date('j', current_time('timestamp'));
$month = date('n', current_time('timestamp'));
$year = date('Y', current_time('timestamp'));
} else {
$day = date('j', strtotime('last '.$start_week));
$month = date('n', strtotime('last '.$start_week));
$year = date('Y', strtotime('last '.$start_week));
}
$week_start = mktime(0, 0, 0, $month, $day, $year);
$week_end = mktime(23, 59, 59, date('n', strtotime("+7 days", $week_start)), date('j', strtotime("+7 days", $week_start)), date('Y', strtotime("+7 days", $week_start)));
$week_clicks = $wpdb->get_results("SELECT COUNT(*) as clicks FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$week_start' AND '$week_end' AND post_id = '$post_id'");
$week_impressions = $wpdb->get_results("SELECT COUNT(*) as impressions FROM ".$wpdb->prefix."akp_impressions_log WHERE timestamp BETWEEN '$week_start' AND '$week_end' AND post_id = '$post_id'");
$week_impression_cost = $dets['akp_revenue_per_impression'][0];
$week_click_cost = $dets['akp_revenue_per_click'][0];
$week_per_impression = $currency_sign.number_format((int) $week_impression_cost, 2);
$week_impression_total = $week_impression_cost * $week_impressions[0]->impressions;
$week_impression_total_output = $currency_sign.number_format((int) $week_impression_total, 2);
$week_per_click = $currency_sign.number_format((int) $week_click_cost, 2);
$week_click_total = $week_click_cost * $week_clicks[0]->clicks;
$week_click_total_output = $currency_sign.number_format((int) $week_click_total, 2);
$week_total_made = $week_impression_total + $week_click_total;
$week_total_made_output = $currency_sign.number_format((int) $week_total_made, 2);
// Get Today Click count
$today_start = mktime(0, 0, 0, date('n', current_time('timestamp')), date('j', current_time('timestamp')), date('Y', current_time('timestamp')));
$today_end = mktime(23, 59, 59, date('n', current_time('timestamp')), date('j', current_time('timestamp')), date('Y', current_time('timestamp')));
$today_clicks = $wpdb->get_results("SELECT COUNT(*) as clicks FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$today_start' AND '$today_end' AND post_id = '$post_id'");
$today_impressions = $wpdb->get_results("SELECT COUNT(*) as impressions FROM ".$wpdb->prefix."akp_impressions_log WHERE timestamp BETWEEN '$today_start' AND '$today_end' AND post_id = '$post_id'");
$today_impression_cost = $dets['akp_revenue_per_impression'][0];
$today_click_cost = $dets['akp_revenue_per_click'][0];
$today_per_impression = $currency_sign.number_format((int) $today_impression_cost, 2);
$today_impression_total = $today_impression_cost * $today_impressions[0]->impressions;
$today_impression_total_output = $currency_sign.number_format((int) $today_impression_total, 2);
$today_per_click = $currency_sign.number_format((int) $today_click_cost, 2);
$today_click_total = $today_click_cost * $today_clicks[0]->clicks;
$today_click_total_output = $currency_sign.number_format((int) $today_click_total, 2);
$today_total_made = $today_impression_total + $today_click_total;
$today_total_made_output = $currency_sign.number_format((int) $today_total_made, 2);
// Initilize Detail log
$all_clicks_detailed = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."akp_click_log WHERE post_id = '$post_id' ORDER BY timestamp DESC");
$month_clicks_detailed = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$month_start' AND '$month_end' AND post_id = '$post_id' ORDER BY timestamp DESC");
$week_clicks_detailed = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$week_start' AND '$week_end' AND post_id = '$post_id' ORDER BY timestamp DESC");
$day_clicks_detailed = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."akp_click_log WHERE timestamp BETWEEN '$today_start' AND '$today_end' AND post_id = '$post_id' ORDER BY timestamp DESC");
?>
Summary
All Time
= $all_clicks[0]->clicks ?>
This Month
= $month_clicks[0]->clicks ?>
This Week
= $week_clicks[0]->clicks ?>
Today
= $today_clicks[0]->clicks ?>
Detailed
|
Count |
Cost Per |
Total |
| Impressions |
= $all_impressions[0]->impressions ?> |
= $all_per_impression ?> |
= $all_impression_total_output ?> |
| Clicks |
= $all_clicks[0]->clicks ?> |
= $all_per_click ?> |
= $all_click_total_output ?> |
|
|
TOTAL |
= $all_total_made_output ?> |
| Date/Time |
IP Address |
| = date('d/m/Y h:i:sa', $acd->timestamp) ?> |
= $acd->ip_address ?> |
| Date/Time |
IP Address |
|
Count |
Cost Per |
Total |
| Impressions |
= $month_impressions[0]->impressions ?> |
= $month_per_impression ?> |
= $month_impression_total_output ?> |
| Clicks |
= $month_clicks[0]->clicks ?> |
= $month_per_click ?> |
= $month_click_total_output ?> |
|
|
TOTAL |
= $month_total_made_output ?> |
| Date/Time |
IP Address |
| = date('d/m/Y h:i:sa', $acd->timestamp) ?> |
= $acd->ip_address ?> |
| Date/Time |
IP Address |
|
Count |
Cost Per |
Total |
| Impressions |
= $week_impressions[0]->impressions ?> |
= $week_per_impression ?> |
= $week_impression_total_output ?> |
| Clicks |
= $week_clicks[0]->clicks ?> |
= $week_per_click ?> |
= $week_click_total_output ?> |
|
|
TOTAL |
= $week_total_made_output ?> |
| Date/Time |
IP Address |
| = date('d/m/Y h:i:sa', $acd->timestamp) ?> |
= $acd->ip_address ?> |
| Date/Time |
IP Address |
|
Count |
Cost Per |
Total |
| Impressions |
= $today_impressions[0]->impressions ?> |
= $today_per_impression ?> |
= $today_impression_total_output ?> |
| Clicks |
= $today_clicks[0]->clicks ?> |
= $today_per_click ?> |
= $today_click_total_output ?> |
|
|
TOTAL |
= $today_total_made_output ?> |
| Date/Time |
IP Address |
| = date('d/m/Y h:i:sa', $acd->timestamp) ?> |
= $acd->ip_address ?> |
| Date/Time |
IP Address |