PHP get_reporting_data Examples

Example #1

File: admin_functions.php Project: aiurlano/mAdserve-Fork

function graph_report_widget($location, $type, $duration)
{
    echo '<div class="widget">';
    echo '<div class="widget-header">';
    echo '<span class="icon-chart"></span>';
    echo '<h3 class="icon chart">Quick Statistics - Last 7 Days</h3>';
    echo '</div>';
    echo '<div class="widget-content">';
    echo '<table class="stats" data-chart-type="line" data-chart-colors="">';
    echo '<thead>';
    echo '<tr>';
    echo '<td>&nbsp;</td>';
    echo '<th>';
    echo date('d/M/Y', mktime(0, 0, 0, date("m"), date("d") - 6, date("Y")));
    echo '</th>';
    echo '<th>';
    echo date('d/M/Y', mktime(0, 0, 0, date("m"), date("d") - 5, date("Y")));
    echo '</th>';
    echo '<th>';
    echo date('d/M/Y', mktime(0, 0, 0, date("m"), date("d") - 4, date("Y")));
    echo '</th>';
    echo '<th>';
    echo date('d/M/Y', mktime(0, 0, 0, date("m"), date("d") - 3, date("Y")));
    echo '</th>';
    echo '<th>';
    echo date('d/M/Y', mktime(0, 0, 0, date("m"), date("d") - 2, date("Y")));
    echo '</th>';
    echo '<th>Yesterday</th>';
    echo '<th>Today</th>';
    echo '</tr>';
    echo '</thead>';
    $data_m6 = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 6, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 6, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 6, date("Y"))), '');
    $data_m5 = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 5, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 5, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 5, date("Y"))), '');
    $data_m4 = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 4, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 4, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 4, date("Y"))), '');
    $data_m3 = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 3, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 3, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 3, date("Y"))), '');
    $data_m2 = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 2, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 2, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 2, date("Y"))), '');
    $data_yesterday = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), '');
    $data_today = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d"), date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d"), date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d"), date("Y"))), '');
    echo '<tbody>';
    echo '<tr>';
    echo '<th>Ad Requests</th>';
    echo '<td>' . $data_m6['total_requests'] . '</td>';
    echo '<td>' . $data_m5['total_requests'] . '</td>';
    echo '<td>' . $data_m4['total_requests'] . '</td>';
    echo '<td>' . $data_m3['total_requests'] . '</td>';
    echo '<td>' . $data_m2['total_requests'] . '</td>';
    echo '<td>' . $data_yesterday['total_requests'] . '</td>';
    echo '<td>' . $data_today['total_requests'] . '</td>';
    echo '</tr>';
    echo '<tr>';
    echo '<th>Impressions</th>';
    echo '<td>' . $data_m6['total_impressions'] . '</td>';
    echo '<td>' . $data_m5['total_impressions'] . '</td>';
    echo '<td>' . $data_m4['total_impressions'] . '</td>';
    echo '<td>' . $data_m3['total_impressions'] . '</td>';
    echo '<td>' . $data_m2['total_impressions'] . '</td>';
    echo '<td>' . $data_yesterday['total_impressions'] . '</td>';
    echo '<td>' . $data_today['total_impressions'] . '</td>';
    echo '</tr>';
    echo '<tr>';
    echo '<th>Clicks</th>';
    echo '<td>' . $data_m6['total_clicks'] . '</td>';
    echo '<td>' . $data_m5['total_clicks'] . '</td>';
    echo '<td>' . $data_m4['total_clicks'] . '</td>';
    echo '<td>' . $data_m3['total_clicks'] . '</td>';
    echo '<td>' . $data_m2['total_clicks'] . '</td>';
    echo '<td>' . $data_yesterday['total_clicks'] . '</td>';
    echo '<td>' . $data_today['total_clicks'] . '</td>';
    echo '</tr>';
    echo '</tbody>';
    echo '</table>';
    echo '</div> <!-- .widget-content -->';
    echo '</div> <!-- .widget -->';
}

Example #2

File: dashboard.php Project: liulingfu/madserve

        ?>
style="text-decoration:line-through;"<?php 
    }
    ?>
 href="create_campaign.php">Add a Campaign</a></li>
					</ul>
				</div>
                <?php 
}
?>
				
                <?php 
if (getconfig_var('update_check') == 1) {
    $box_url = 'http://network.madserve.org/newsbox.php?dv=' . urlencode(getconfig_var('db_install_version')) . '&cv=' . urlencode(MAD_VERSION) . '';
    if (getconfig_var('allow_statistical_info') == 1) {
        $data_yesterday = get_reporting_data("publisher", date('d', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), date('m', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), date('Y', mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"))), '');
        $box_url = $box_url . '&u=' . urlencode(getconfig_var('installation_id')) . '&d=' . urlencode(date('dmy', time() - 86400)) . '&re=' . urlencode($data_yesterday['total_requests']) . '&im=' . urlencode($data_yesterday['total_impressions']) . '&cl=' . urlencode($data_yesterday['total_clicks']) . '';
    }
    ?>
			  <div class="box">
                <iframe width="100%" height="350" allowtransparency="1" scrolling="no" frameborder="0" src="<?php 
    echo $box_url;
    ?>
"></iframe>
				<!--<ul class="bullet secondary">
						<li><a href="<?php 
    echo "../../sdk/ios_latest.zip";
    ?>
">mAdserve iOS SDK</a></li>
						<li><a href="<?php 
    echo "../../sdk/android_latest.zip";