app/Plugin/SiteKit42/Controller/Admin/DashboardController.php line 41

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of EC-CUBE
  5.  *
  6.  * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  7.  *
  8.  * http://www.ec-cube.co.jp/
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Plugin\SiteKit42\Controller\Admin;
  16. use Eccube\Controller\AbstractController;
  17. use Plugin\SiteKit42\Service\Google_Site_Kit_Proxy_Client;
  18. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  19. use Symfony\Component\Routing\Annotation\Route;
  20. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  22. class DashboardController extends AbstractController
  23. {
  24.     /**
  25.      * @var Google_Site_Kit_Proxy_Client
  26.      */
  27.     private $siteKitClient;
  29.     /**
  30.      * DashboardController constructor.
  31.      */
  32.     public function __construct(Google_Site_Kit_Proxy_Client $siteKitClient)
  33.     {
  34.         $this->siteKitClient = $siteKitClient;
  35.     }
  37.     /**
  38.      * @Route("/%eccube_admin_route%/site_kit/dashboard", name="site_kit_dashboard")
  39.      * @Template("@SiteKit42/admin/dashboard.twig")
  40.      */
  41.     public function showGoogleSearchData()
  42.     {
  43.         $Member = $this->getUser();
  44.         if (is_null($Member->getIdToken())) {
  45.             return $this->redirectToRoute('site_kit42_admin_config');
  46.         }
  48.         $jsonQuery = $this->getJsonFromGoogleSearchData('query');
  49.         $jsonPage = $this->getJsonFromGoogleSearchData('page');
  50.         $jsonDate = $this->getJsonFromGoogleSearchData('date', null);
  52.         $arrayResponse = json_decode($jsonDate, true);
  53.         if (!array_key_exists('rows', $arrayResponse)) {
  54.             $arrayResponse['rows'] = [];
  55.         }
  57.         $arrayDate = array_map(function ($row) {
  58.             $array[] = $row['keys'][0];
  59.             $array[] = $row['clicks'];
  60.             $array[] = $row['impressions'];
  62.             return $array;
  63.         }, $arrayResponse['rows']);
  64.         $header = [['Date', 'Clicks', 'Impression']];
  65.         $arrayDate = array_merge($header, $arrayDate);
  67.         return [
  68.             'json_query' => $this->formatJson($jsonQuery),
  69.             'json_page' => $this->formatJson($jsonPage),
  70.             'json_date' => $arrayDate,
  71.             'ownedSiteUrl' => $this->getSiteUrl(),
  72.         ];
  73.     }
  75.     private function getJsonFromGoogleSearchData($dimension, $rowLimit = '10')
  76.     {
  77.         $startDate = date('Y-m-d', strtotime('-29 days'));
  78.         $endDate = date('Y-m-d', strtotime('-1 days'));
  80.         $json = [
  81.             'dimensions' => [$dimension],
  82.             'startDate' => $startDate,
  83.             'endDate' => $endDate,
  84.             'rowLimit' => $rowLimit,
  85.         ];
  86.         $httpClient = $this->siteKitClient->authorize();
  87.         $endpoint = 'https://www.googleapis.com/webmasters/v3/sites/'.urlencode($this->getSiteUrl()).'/searchAnalytics/query';
  88.         $response = $httpClient->request('POST', $endpoint, ['json' => $json]);
  90.         return $response->getBody()->getContents();
  91.     }
  93.     public function formatJson($responseBody)
  94.     {
  95.         $arrayResponse = json_decode($responseBody, true);
  96.         if (!array_key_exists('rows', $arrayResponse)) {
  97.             $arrayResponse['rows'] = [];
  98.         }
  100.         $arrayResponse['rows'] = array_map(function ($row) {
  101.             $row['ctr'] = sprintf('%.2f', round($row['ctr'], 2));
  102.             $row['position'] = sprintf('%.1f', round($row['position'], 1));
  104.             return $row;
  105.         }, $arrayResponse['rows']);
  107.         return $arrayResponse;
  108.     }
  110.     private function getSiteUrl()
  111.     {
  112.         return env('SITE_KIT_OWNED_SITE_URL', $this->generateUrl('homepage', [], UrlGeneratorInterface::ABSOLUTE_URL));
  113.     }
  114. }