Google AnalyticsからPV順に記事を取得するその② - サイドバーに表示-

<?php
Class GoogleAnalyticsService{

    private $analytics;
    private $view_id;
    private $result;
    private $display_count;
    private $reports;

    function __construct($keyfile,$view_id,$display_count)
    {
        $client = new Google_Client();
        $client->setApplicationName("GoogleAnalyticsService");
        $client->setAuthConfig($keyfile);
        $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
        $analytics = new Google_Service_AnalyticsReporting($client);

        $this->analytics = $analytics;
        $this->view_id = $view_id;
        $this->display_count = $display_count;
    }

    function report_request() {
        // Create the DateRange object.
        $dateRange = new Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate("90daysAgo");
        $dateRange->setEndDate("today");

        // Create the Metrics object.
        $sessions = new Google_Service_AnalyticsReporting_Metric();
        $sessions->setExpression("ga:pageviews");
        $sessions->setAlias("pv");

        // Create the Dimension object.
        $dimention = new Google_Service_AnalyticsReporting_Dimension();
        $dimention->setName("ga:pagePathLevel4");

        // Filter
        $filter = new Google_Service_AnalyticsReporting_DimensionFilter();
        $filter->setDimensionName("ga:pagePathLevel4");
        $filter->setNot(true);
        $filter->setOperator("IN_LIST");
        $filter->setExpressions( ["/"] );

        $filters = new Google_Service_AnalyticsReporting_DimensionFilterClause();
        $filters->setFilters(array($filter));

        // OrderBy
        $orderby = new Google_Service_AnalyticsReporting_OrderBy();
        $orderby->setFieldName("ga:pageviews");
        $orderby->setOrderType("VALUE");
        $orderby->setSortOrder("DESCENDING");

        // Create the ReportRequest object.
        $request = new Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($this->view_id);
        $request->setDateRanges($dateRange);
        $request->setMetrics(array($sessions));
        $request->setDimensions(array($dimention));
        $request->setDimensionFilterClauses(array($filters));
        $request->setOrderBys($orderby);

        $body = new Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array($request) );

        $this->reports = $this->analytics->reports->batchGet( $body );
    }

    function fetch_result_as_array() {
        $result = [];
        for ( $reportIndex = 0; $reportIndex < count($this->reports); $reportIndex++ ) {
            $report = $this->reports[ $reportIndex ];
            $rows = $report->getData()->getRows();

            $display_count = $this->display_count > count($rows) ? count($rows) : $this->display_count;
            for ( $rowIndex = 0; $rowIndex < $display_count; $rowIndex++) { $row = $rows[ $rowIndex ]; $dimensions = $row->getDimensions();
                $metrics = $row->getMetrics();

                $result[] = [
                    'pageview' => $metrics[0]->getValues()[0],
                    'url'      => $dimensions[0]
                ];
            }
        }
        return $result;
    }
}

<?php

/*
* Plugin Name: Google Analytics Popular Rankings
*/


require_once __DIR__ . '/vendor/autoload.php';
require_once __DIR__ . '/classes/GoogleAnalyticsService.php';
require_once __DIR__ . '/classes/WPDatabaseService.php';

function ga_popular_rankings(){
    $KEY_FILE_LOCATION = __DIR__ . '/service-account-credentials.json';
    $VIEW_ID = '<REPLACE YOUR VIEW ID>';

    $analytics = new GoogleAnalyticsService($KEY_FILE_LOCATION,$VIEW_ID,5);
    $analytics->report_request();
    $response = $analytics->fetch_result_as_array();

    $db = new WPDatabaseService($response);
    $pop_posts =  $db->fetch_post_data();

    pop_posts_render($pop_posts);

}


function pop_posts_render($pop_posts){
    echo "<h2 class='widget-title'>人気記事</h2>";
    echo "<ul style='list-style:none;padding-left:0px;'>";
    foreach($pop_posts as $post){
        echo "<li><a href='".$post['url']."'>".$post['title']."</a></li>";
    }
    echo "</ul>";
}

add_filter('widget_text', 'do_shortcode');
add_shortcode( 'ga_popular_rankings', 'ga_popular_rankings' );

$analytics = new GoogleAnalyticsService($KEY_FILE_LOCATION,$VIEW_ID,5);
    $analytics->report_request();
    $response = $analytics->fetch_result_as_array();

<?php
Class WPDatabaseService{
    private $posts;

    function __construct($posts){
        $this->posts = $posts;
    }

    private function get_tilte_by_path_name($post_name){
        global $wpdb;
        $query = $wpdb->prepare('select post_title from wp_posts where post_name = %s',$post_name);
        return $wpdb->get_var($query,0,0);
    }

    function fetch_post_data(){
        $result = [];
        foreach($this->posts as $post){
           $path_name = urlencode(mb_convert_encoding(str_replace('/','',$post['url']), 'UTF-8', 'auto'));
           $post['title'] = $this->get_tilte_by_path_name($path_name);
           $result[] = $post;
        }
        return $result;
    }
}

/*
* Plugin Name: Google Analytics Popular Rankings
*/

[ga_popular_rankings]

add_filter('widget_text', 'do_shortcode');
add_shortcode( 'ga_popular_rankings', 'ga_popular_rankings' );