Coverage index

src/Service/UpgradeService.php

Lines: 100.00%

LineHitsSource
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Drupal\visitors\Service;
6
7
use Drupal\Core\Database\Connection;
8
use Drupal\visitors\Helper\VisitorsUrl;
9
use Drupal\visitors\VisitorsReferrerInterface;
10
use Drupal\visitors\VisitorsTrackerInterface;
11
use Drupal\visitors\VisitorsUpgradeInterface;
12
13
/**
14
 * A class for upgrading data.
15
 */
16
class UpgradeService implements VisitorsUpgradeInterface {
17
18
  /**
19
   * The database connection.
20
   *
21
   * @var \Drupal\Core\Database\Connection
22
   */
23
  protected $database;
24
25
  /**
26
   * The visitors tracker.
27
   *
28
   * @var \Drupal\visitors\VisitorsTrackerInterface
29
   */
30
  protected $tracker;
31
32
  /**
33
   * The referrer parser.
34
   *
35
   * @var \Drupal\visitors\VisitorsReferrerInterface
36
   */
37
  protected $referrer;
38
39
  /**
40
   * The constructor.
41
   *
42
   * @param \Drupal\Core\Database\Connection $database
43
   *   The database connection.
44
   * @param \Drupal\visitors\VisitorsTrackerInterface $tracker
45
   *   The visitors tracker.
46
   * @param \Drupal\visitors\VisitorsReferrerInterface $referrer
47
   *   The referrer parser.
48
   */
49
  public function __construct(Connection $database, VisitorsTrackerInterface $tracker, VisitorsReferrerInterface $referrer) {
504
    $this->database = $database;
514
    $this->tracker = $tracker;
524
    $this->referrer = $referrer;
53
  }
54
55
  /**
56
   * {@inheritdoc}
57
   */
58
  public function doLogRecord(array $row): array {
591
    $log = [];
601
    $request_time = (int) $row['visitors_date_time'];
61
621
    $url = $row['visitors_url'];
631
    $visitors_url = new VisitorsUrl($url);
64
651
    $log['url'] = $visitors_url->getUrl();
661
    $log['url_prefix'] = $visitors_url->getPrefix();
67
681
    $page_host = $this->referrer->hostOf((string) ($row['visitors_url'] ?? ''));
691
    $referrer = $this->referrer->storageFields((string) ($row['visitors_referer'] ?? ''), $page_host);
70
711
    $log['uid']                 = $row['visitors_uid'] ?? 0;
721
    $log['title']               = $row['visitors_title'];
731
    $log['referrer_url']        = $referrer['referrer_url'];
741
    $log['referrer_url_prefix'] = $referrer['referrer_url_prefix'];
751
    $log['referrer_internal']   = $referrer['referrer_internal'];
761
    $log['referrer_path']       = $referrer['referrer_path'];
771
    $log['referrer_route']      = $referrer['referrer_route'];
781
    $log['path']                = $row['visitors_path'];
791
    $log['route']               = $row['route'];
801
    $log['server']              = $row['server'];
811
    $log['pf_network']          = $row['pf_network'];
821
    $log['pf_server']           = $row['pf_server'];
831
    $log['pf_transfer']         = $row['pf_transfer'];
841
    $log['pf_dom_processing']   = $row['pf_dom_processing'];
851
    $log['pf_dom_complete']     = $row['pf_dom_complete'];
861
    $log['pf_on_load']          = $row['pf_on_load'];
871
    $log['pf_total']            = $row['pf_total'];
881
    $log['created']             = $request_time;
89
901
    return $log;
91
  }
92
93
  /**
94
   * {@inheritdoc}
95
   */
96
  public function doVisitRecord(array $row): array {
971
    $visit = [];
981
    $request_time = (int) $row['visitors_date_time'];
99
1001
    $visit['location_browser_lang'] = $row['language'];
101
1021
    $visit['localtime']              = $row['visitor_localtime'];
1031
    $visit['config_browser_engine']  = $row['config_browser_engine'];
1041
    $visit['config_browser_name']    = $row['config_browser_name'];
1051
    $visit['config_browser_version'] = $row['config_browser_version'];
1061
    $visit['config_client_type']     = $row['config_client_type'];
1071
    $visit['config_device_brand']    = $row['config_device_brand'];
1081
    $visit['config_device_model']    = $row['config_device_model'];
1091
    $visit['config_device_type']     = $row['config_device_type'];
1101
    $visit['config_os']              = $row['config_os'];
1111
    $visit['config_os_version']      = $row['config_os_version'];
1121
    $visit['bot']                    = $row['bot'];
1131
    $visit['config_resolution']      = $row['config_resolution'];
1141
    $visit['config_pdf']             = $row['config_pdf'];
1151
    $visit['config_flash']           = $row['config_flash'];
1161
    $visit['config_java']            = $row['config_java'];
1171
    $visit['config_quicktime']       = $row['config_quicktime'];
1181
    $visit['config_realplayer']      = $row['config_realplayer'];
1191
    $visit['config_windowsmedia']    = $row['config_windowsmedia'];
1201
    $visit['config_silverlight']     = $row['config_silverlight'];
1211
    $visit['config_cookie']          = $row['config_cookie'];
1221
    $visit['location_continent']     = $row['location_continent'];
1231
    $visit['location_country']       = $row['location_country'];
1241
    $visit['location_region']        = $row['location_region'] ?? NULL;
1251
    $visit['location_city']          = $row['location_city'] ?? NULL;
1261
    $visit['location_latitude']      = $row['location_latitude'] ?? NULL;
1271
    $visit['location_longitude']     = $row['location_longitude'] ?? NULL;
1281
    $visit['visitor_id']             = $row['visitor_id'];
1291
    $visit['total_time']             = 0;
1301
    $visit['total_page_views']       = 0;
1311
    $visit['total_events']           = 0;
1321
    $visit['returning']              = 0;
1331
    $visit['total_visits']           = 1;
1341
    $visit['entry_time']             = $request_time;
1351
    $visit['exit_time']              = $request_time;
1361
    $visit['location_ip']            = $row['visitors_ip'];
137
1381
    return $visit;
139
  }
140
141
  /**
142
   * {@inheritdoc}
143
   */
144
  public function getVisitorsRows(int $batch = 50): array {
1451
    $select = $this->database->select('visitors', 'v');
1461
    $rows = $select->fields('v')
1471
      ->orderBy('v.visitors_date_time', 'ASC')
1481
      ->range(0, $batch)
1491
      ->execute()->fetchAll();
150
1511
    return $rows;
152
  }
153
154
  /**
155
   * {@inheritdoc}
156
   */
157
  public function deleteVisitorsRow($id) {
1581
    $this->database
1591
      ->delete('visitors')
1601
      ->condition('visitors_id', $id)
1611
      ->execute();
162
  }
163
164
  /**
165
   * {@inheritdoc}
166
   */
167
  public function getTotal(): int {
1681
    $select = $this->database->select('visitors', 'v');
1691
    $select->fields('v')
1701
      ->countQuery();
171
1721
    $count = $select->execute()->fetchField();
173
1741
    return (int) $count;
175
  }
176
177
  /**
178
   * {@inheritdoc}
179
   */
180
  public function upgradeRow(array $row) {
1811
    $id = $row['visitors_id'];
1821
    $request_time = (int) $row['visitors_date_time'];
183
1841
    $visit = $this->doVisitRecord($row);
1851
    $event = $this->doLogRecord($row);
1861
    $uid = isset($event['uid']) ? (string) $event['uid'] : '0';
1871
    $visit['uid'] = ($uid === '' || $uid === '0') ? NULL : $uid;
188
1891
    $visit_id = $this->tracker->getVisitId($visit, $request_time);
1901
    $event['visit_id'] = $visit_id;
1911
    $event_id = $this->tracker->writeEvent($event);
192
1931
    $this->tracker->updateVisit($visit_id, $event_id, $request_time, $visit['uid']);
194
1951
    $this->deleteVisitorsRow($id);
196
  }
197
198
}