foreach ($adstats as $result) { if ($result->clicks == null) { $result->clicks = '0'; } if ($result->impressions == null) { $result->impressions = '0'; } $dates .= ',"' . date_i18n("d M", $result->thetime) . '"'; $clicks .= ',' . $result->clicks; $impressions .= ',' . $result->impressions; } $dates = trim($dates, ","); $clicks = trim($clicks, ","); $impressions = trim($impressions, ","); echo '<div id="chart-1" style="height:150px; width:100%;"></div>'; adrotate_draw_graph(1, $dates, $clicks, $impressions); } else { _e('No data to show!', 'adrotate'); } ?> </td> </tr> </tbody> <?php } ?> <thead> <tr class="first"> <td colspan="2"><strong><?php _e('Support AdRotate', 'adrotate');
function adrotate_stats_graph($type, $id, $chartid, $start, $end, $height = 300) { global $wpdb; if ($type == 'ads' or $type == 'advertiser') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `ad` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($type == 'groups') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `group` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($type == 'fullreport') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $start, $end), ARRAY_A); } if ($type == 'advertiserfull') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats`, `" . $wpdb->prefix . "adrotate_linkmeta` WHERE `" . $wpdb->prefix . "adrotate_stats`.`ad` = `" . $wpdb->prefix . "adrotate_linkmeta`.`ad` AND `" . $wpdb->prefix . "adrotate_linkmeta`.`user` = %d AND (`" . $wpdb->prefix . "adrotate_stats`.`thetime` >= %d AND `" . $wpdb->prefix . "adrotate_stats`.`thetime` <= %d) GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($stats) { $dates = $clicks = $impressions = ''; foreach ($stats as $result) { if (empty($result['clicks'])) { $result['clicks'] = '0'; } if (empty($result['impressions'])) { $result['impressions'] = '0'; } $dates .= ',"' . date_i18n("d M", $result['thetime']) . '"'; $clicks .= ',' . $result['clicks']; $impressions .= ',' . $result['impressions']; } $dates = trim($dates, ","); $clicks = trim($clicks, ","); $impressions = trim($impressions, ","); $output = ''; $output .= '<div id="chart-' . $chartid . '" style="height:' . $height . 'px; width:100%;"></div>'; $output .= adrotate_draw_graph($chartid, $dates, $clicks, $impressions); unset($stats, $dates, $clicks, $impressions); } else { $output = __('No data to show!', 'adrotate-pro'); } return $output; }
function adrotate_stats_graph($type, $id, $chartid, $start, $end) { global $wpdb, $adrotate_debug; if ($type == 'ads' or $type == 'advertiser') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `ad` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($type == 'groups') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `group` = %d AND `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($type == 'global-report') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats` WHERE `thetime` >= %d AND `thetime` <= %d GROUP BY `thetime` ASC;", $start, $end), ARRAY_A); } if ($type == 'advertiser-global') { $stats = $wpdb->get_results($wpdb->prepare("SELECT `thetime`, SUM(`clicks`) as `clicks`, SUM(`impressions`) as `impressions` FROM `" . $wpdb->prefix . "adrotate_stats`, `" . $wpdb->prefix . "adrotate_linkmeta` WHERE `" . $wpdb->prefix . "adrotate_stats`.`ad` = `" . $wpdb->prefix . "adrotate_linkmeta`.`ad` AND `" . $wpdb->prefix . "adrotate_linkmeta`.`user` = %d AND (`" . $wpdb->prefix . "adrotate_stats`.`thetime` >= %d AND `" . $wpdb->prefix . "adrotate_stats`.`thetime` <= %d) GROUP BY `thetime` ASC;", $id, $start, $end), ARRAY_A); } if ($stats) { $dates = $clicks = $impressions = ''; foreach ($stats as $result) { if (empty($result['clicks'])) { $result['clicks'] = '0'; } if (empty($result['impressions'])) { $result['impressions'] = '0'; } $dates .= ',"' . date_i18n("d M", $result['thetime']) . '"'; $clicks .= ',' . $result['clicks']; $impressions .= ',' . $result['impressions']; } $dates = trim($dates, ","); $clicks = trim($clicks, ","); $impressions = trim($impressions, ","); $output = ''; if ($adrotate_debug['stats'] == true) { $output .= "<p><strong>[DEBUG] Dates</strong><pre>" . $dates . "</pre></p>"; $output .= "<p><strong>[DEBUG] Clicks</strong><pre>" . $clicks . "</pre></p>"; $output .= "<p><strong>[DEBUG] Impressions</strong><pre>" . $impressions . "</pre></p>"; } $output .= '<div id="chart-1" style="height:300px; width:100%;"></div>'; $output .= adrotate_draw_graph($chartid, $dates, $clicks, $impressions); unset($stats, $dates, $clicks, $impressions); } else { $output = __('No data to show!', 'adrotate'); } return $output; }