Blame view

app/library/App/Controllers/GaController.php 3.56 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
      public function getAction() {
  
d6c4c133   Alex Savenko   ga response
28
29
          $metric = $this->request->getServer('metric');
  
897d06c3   Alex Savenko   generate GaResource
30
31
32
33
          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']);
897d06c3   Alex Savenko   generate GaResource
34
35
          $analytics = new Google_Service_AnalyticsReporting($client);
  
d6c4c133   Alex Savenko   ga response
36
          $param[] = ['metric' => $metric];
897d06c3   Alex Savenko   generate GaResource
37
38
39
40
41
42
43
44
45
46
47
48
49
  
          $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']);
d6c4c133   Alex Savenko   ga response
50
              //$sessions->setAlias($item['alias']);
897d06c3   Alex Savenko   generate GaResource
51
52
53
54
55
56
57
58
59
60
61
62
63
64
  
  
              // Создание объекта 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 );
          }
  
51e8991c   Alex Savenko   create response
65
          return $response->toSimpleObject();
1da92831   Alex Savenko   var_dump
66
  
7fe1d3b2   Alex Savenko   create response
67
68
      }
  
ff25157e   Alex Savenko   ga response
69
      public function printResults($reports) {
7fe1d3b2   Alex Savenko   create response
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
          $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
  }