Blame view

app/library/App/Controllers/GaController.php 3.64 KB
b38ef228   Alex Savenko   generate GaResource
1
2
3
4
5
6
7
8
9
10
11
  <?php
  /**
   * Created by PhpStorm.
   * User: Alex Savenko
   * Date: 09.02.2017
   * Time: 18:12
   */
  
  namespace App\Controllers;
  
  
897d06c3   Alex Savenko   generate GaResource
12
13
14
15
16
17
  use Google_Client;
  use Google_Service_AnalyticsReporting;
  use Google_Service_AnalyticsReporting_DateRange;
  use Google_Service_AnalyticsReporting_GetReportsRequest;
  use Google_Service_AnalyticsReporting_Metric;
  use Google_Service_AnalyticsReporting_ReportRequest;
b38ef228   Alex Savenko   generate GaResource
18
  use PhalconRest\Mvc\Controllers\CrudResourceController;
7fe1d3b2   Alex Savenko   create response
19
  use Google_Service_AnalyticsReporting_Report;
b38ef228   Alex Savenko   generate GaResource
20
21
22
  
  class GaController extends CrudResourceController {
  
897d06c3   Alex Savenko   generate GaResource
23
24
      const SECRET_JSON = 'ca4a1bd8aa14.json';
      const VIEW_ID = '119240817';
b38ef228   Alex Savenko   generate GaResource
25
  
897d06c3   Alex Savenko   generate GaResource
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
      public function getAction() {
  
          putenv('GOOGLE_APPLICATION_CREDENTIALS=/var/www/phalcon/'.self::SECRET_JSON);
          $client = new Google_Client();
          $client->useApplicationDefaultCredentials();
          $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
          $api_key = 'AIzaSyBNYr7n7bcHbO-sJ9xuWwS9xQ2OY5aFAiE';
          $client->setDeveloperKey($api_key);
          $analytics = new Google_Service_AnalyticsReporting($client);
  
          $param[] = ['metric' => 'ga:sessions', 'alias' => 'Сессии'];
  
          $response = [];
  
          foreach ($param as $item) {
  
              // Создание объекта DateRange.
              $dateRange = new Google_Service_AnalyticsReporting_DateRange();
              $dateRange->setStartDate("30daysAgo");
              $dateRange->setEndDate("today");
  
              // Создание объекта Metrics.
              $sessions = new Google_Service_AnalyticsReporting_Metric();
              $sessions->setExpression($item['metric']);
              $sessions->setAlias($item['alias']);
  
  
              // Создание объекта ReportRequest.
              $request = new Google_Service_AnalyticsReporting_ReportRequest();
              $request->setViewId(self::VIEW_ID);
              $request->setDateRanges($dateRange);
              $request->setMetrics(array($sessions));
  
              $body = new Google_Service_AnalyticsReporting_GetReportsRequest();
              $body->setReportRequests( array( $request) );
  
              $response =  $analytics->reports->batchGet( $body );
          }
  
7fe1d3b2   Alex Savenko   create response
65
          return $this->printResults($response);
1da92831   Alex Savenko   var_dump
66
  
7fe1d3b2   Alex Savenko   create response
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
      }
  
      function printResults($reports) {
          $res = '';
          for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
              $report = $reports[ $reportIndex ];
              $header = $report->getColumnHeader();
              $dimensionHeaders = $header->getDimensions();
              $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
              $rows = $report->getData()->getRows();
  
              for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
                  $row = $rows[ $rowIndex ];
                  $dimensions = $row->getDimensions();
                  $metrics = $row->getMetrics();
                  for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
                      print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n");
                  }
  
                  for ($j = 0; $j < count( $metricHeaders ) && $j < count( $metrics ); $j++) {
                      $entry = $metricHeaders[$j];
                      $values = $metrics[$j];
                      //print("Metric type: " . $entry->getType() . "\n" );
                      for ( $valueIndex = 0; $valueIndex < count( $values->getValues() ); $valueIndex++ ) {
                          $value = $values->getValues()[ $valueIndex ];
                          $res .= "<b>" . $entry->getName() . "</b>: " . $value . '<br/>';
                      }
                  }
              }
          }
b38ef228   Alex Savenko   generate GaResource
97
  
7fe1d3b2   Alex Savenko   create response
98
          return $res;
b38ef228   Alex Savenko   generate GaResource
99
100
      }
  
7fe1d3b2   Alex Savenko   create response
101
  
b38ef228   Alex Savenko   generate GaResource
102
  }