babatundebusari · December 9, 2018 14:04
diff --git a/popular-posts.php b/popular-posts.php
 #!/usr/bin/php -q
 <?php
 /*
 Ampp3d - Ampp3d Google Analytics
 Version: 0.1
 Author: William Turrell
 Author URI: wturrell.co.uk
 Description: Use Google Analytics API to retrieve most popular pages and construct an HTML fragment we can use
 Adapted from http://www.techpunch.co.uk/development/oauth2-google-analytics-api-service-account-php and 
 https://github.com/lobsterdore/analytics-api-oauth2-example/blob/master/mostPopularContentExample.php
 */

 class Ampp3d_Analytics
 {
    public $service;

    function __construct()
    {
        // We're using Google API PHP Client
        require_once('../../themes/boilerplate/libraries/google-api-php-client/src/Google_Client.php');
        require_once('../../themes/boilerplate/libraries/google-api-php-client/src/contrib/Google_AnalyticsService.php');

        // create client object and set app name
        $client = new Google_Client();
        $client->setApplicationName('foo'); // name of your app

        // set assertion credentials
        $client->setAssertionCredentials(
            new Google_AssertionCredentials(
                'xxxxxxxxxxxx@developer.gserviceaccount.com', // email you added to GA
                array('https://www.googleapis.com/auth/analytics.readonly'),
                file_get_contents('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-privatekey.p12') // keyfile you downloaded
            )
        );

        // other settings
        $client->setClientId('xxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.apps.googleusercontent.com'); // from API console
        $client->setAccessType('offline_access'); // this may be unnecessary?

        // create service and get data
        $this->service = new Google_AnalyticsService($client);
        
    }

    /* Get the analytics statistics, then call render
     * $duration = string - length of period of data we want in a format that strtotime() can understand */
    function get_daily_stats($duration = '3 days')
    {
        $rows_wanted = 30;  // Grab more than we need because we'll drop non-posts (i.e. pages) and also any where the URL doesn't match the permalink

        $end_date   = date('Y-m-d');
        $start_date = date('Y-m-d', strtotime('-'.$duration));

        // https://developers.google.com/analytics/devguides/reporting/core/v3/reference

        $response = $this->service->data_ga->get(
                'ga:xxxxxxxx', // profile id
                $start_date,
                $end_date,
                'ga:uniquePageviews',
                array(
                    'dimensions' => 'ga:pagePath',
                    'sort' => '-ga:uniquePageviews',
                    'max-results' => $rows_wanted));

        $ga_list = $response['rows'];   // Set of URLs and view counts

        if (count($ga_list) != $rows_wanted) {
            echo "Potential problem with results. \n";
            exit;
        }

        $data = [];

        foreach ($ga_list as $k => $v)
        {
            // $v[0] = relative path (/2013/12/11/free-schools... etc.)
            // $v[1] = page view counter

            if (! $postid = url_to_postid($v[0]) )
            {
                continue;
            }
            
            $data[] = get_post($postid);

        }
           
        $this->render($data);
    }

    /* Generate HTML ordered-list of links to popular posts 
     * $data = array of WordPress post objects */
    function render($data = array(), $limit = 10)
    {
        $output = "<ol>\n";

        $c = 0;

        foreach(array_values($data) as $v)
        {
            $c++;

            if ($c > $limit)
            {
                break;
            }

            $output .= sprintf('<li data-post-id="%d"><a href="%s">%s</a></li>', $v->ID, get_permalink($v->ID), $v->post_title);
            $output .= "\n";
        }

        $output .= "</ol>\n";

        $cwd = getcwd();

        $fh = fopen($cwd.'/most-read.html', 'w');

        if ($fh === false) {
            echo "Problem opening output file. \n";
            return;
        }

        fwrite($fh, $output);
        fclose($fh);
    }

 }

 // Load Wordpress core (NB: if you put this inside the class, it *won't* work)
 $cwd = getcwd();
 $path = substr($cwd, 0, strpos($cwd, 'wp-content/'));
 require $path.'wp-load.php';

 $ga = new Ampp3d_Analytics();
 $ga->get_daily_stats();
	#!/usr/bin/php -q
	<?php
	/*
	Ampp3d - Ampp3d Google Analytics
	Version: 0.1
	Author: William Turrell
	Author URI: wturrell.co.uk
	Description: Use Google Analytics API to retrieve most popular pages and construct an HTML fragment we can use
	Adapted from http://www.techpunch.co.uk/development/oauth2-google-analytics-api-service-account-php and
	https://github.com/lobsterdore/analytics-api-oauth2-example/blob/master/mostPopularContentExample.php
	*/

	class Ampp3d_Analytics
	{
	public $service;

	function __construct()
	{
	// We're using Google API PHP Client
	require_once('../../themes/boilerplate/libraries/google-api-php-client/src/Google_Client.php');
	require_once('../../themes/boilerplate/libraries/google-api-php-client/src/contrib/Google_AnalyticsService.php');

	// create client object and set app name
	$client = new Google_Client();
	$client->setApplicationName('foo'); // name of your app

	// set assertion credentials
	$client->setAssertionCredentials(
	new Google_AssertionCredentials(
	'xxxxxxxxxxxx@developer.gserviceaccount.com', // email you added to GA
	array('https://www.googleapis.com/auth/analytics.readonly'),
	file_get_contents('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-privatekey.p12') // keyfile you downloaded
	)
	);

	// other settings
	$client->setClientId('xxxxxxxxxxxxx-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.apps.googleusercontent.com'); // from API console
	$client->setAccessType('offline_access'); // this may be unnecessary?

	// create service and get data
	$this->service = new Google_AnalyticsService($client);

	}

	/* Get the analytics statistics, then call render
	* $duration = string - length of period of data we want in a format that strtotime() can understand */
	function get_daily_stats($duration = '3 days')
	{
	$rows_wanted = 30; // Grab more than we need because we'll drop non-posts (i.e. pages) and also any where the URL doesn't match the permalink

	$end_date = date('Y-m-d');
	$start_date = date('Y-m-d', strtotime('-'.$duration));

	// https://developers.google.com/analytics/devguides/reporting/core/v3/reference

	$response = $this->service->data_ga->get(
	'ga:xxxxxxxx', // profile id
	$start_date,
	$end_date,
	'ga:uniquePageviews',
	array(
	'dimensions' => 'ga:pagePath',
	'sort' => '-ga:uniquePageviews',
	'max-results' => $rows_wanted));

	$ga_list = $response['rows']; // Set of URLs and view counts

	if (count($ga_list) != $rows_wanted) {
	echo "Potential problem with results. \n";
	exit;
	}

	$data = [];

	foreach ($ga_list as $k => $v)
	{
	// $v[0] = relative path (/2013/12/11/free-schools... etc.)
	// $v[1] = page view counter

	if (! $postid = url_to_postid($v[0]) )
	{
	continue;
	}

	$data[] = get_post($postid);

	}

	$this->render($data);
	}

	/* Generate HTML ordered-list of links to popular posts
	* $data = array of WordPress post objects */
	function render($data = array(), $limit = 10)
	{
	$output = "<ol>\n";

	$c = 0;

	foreach(array_values($data) as $v)
	{
	$c++;

	if ($c > $limit)
	{
	break;
	}

	$output .= sprintf('<li data-post-id="%d"><a href="%s">%s</a></li>', $v->ID, get_permalink($v->ID), $v->post_title);
	$output .= "\n";
	}

	$output .= "</ol>\n";

	$cwd = getcwd();

	$fh = fopen($cwd.'/most-read.html', 'w');

	if ($fh === false) {
	echo "Problem opening output file. \n";
	return;
	}

	fwrite($fh, $output);
	fclose($fh);
	}

	}

	// Load Wordpress core (NB: if you put this inside the class, it won't work)
	$cwd = getcwd();
	$path = substr($cwd, 0, strpos($cwd, 'wp-content/'));
	require $path.'wp-load.php';

	$ga = new Ampp3d_Analytics();
	$ga->get_daily_stats();