View source
<?php
namespace Drupal\visitors\Controller\Report;
use Drupal\Component\Utility\Html;
use Drupal\Core\Controller\ControllerBase;
use Drupal\Core\Datetime\Date;
use Drupal\Core\Datetime\DateFormatterInterface;
use Drupal\Core\Link;
use Drupal\Core\Url;
use Symfony\Component\DependencyInjection\ContainerInterface;
class HitDetails extends ControllerBase {
protected $date;
public static function create(ContainerInterface $container) {
return new static($container
->get('date.formatter'));
}
public function __construct(DateFormatterInterface $date_formatter) {
$this->date = $date_formatter;
}
public function display($hit_id) {
return array(
'visitors_table' => array(
'#type' => 'table',
'#rows' => $this
->_getData($hit_id),
),
);
}
protected function _getData($hit_id) {
$query = \Drupal::database()
->select('visitors', 'v');
$query
->leftJoin('users_field_data', 'u', 'u.uid=v.visitors_uid');
$query
->fields('v');
$query
->fields('u', array(
'name',
'uid',
));
$query
->condition('v.visitors_id', (int) $hit_id);
$hit_details = $query
->execute()
->fetch();
$rows = array();
if ($hit_details) {
$url = urldecode($hit_details->visitors_url);
$referer = $hit_details->visitors_referer;
$date = $this->date
->format($hit_details->visitors_date_time, 'large');
$whois_enable = \Drupal::service('module_handler')
->moduleExists('whois');
$attr = array(
'attributes' => array(
'target' => '_blank',
'title' => t('Whois lookup'),
),
);
$ip = long2ip($hit_details->visitors_ip);
$user = \Drupal::entityTypeManager()
->getStorage('user')
->load($hit_details->visitors_uid);
$array = array(
'URL' => $url,
'Title' => Html::escape($hit_details->visitors_title),
'Referer' => $referer,
'Date' => $date,
'User' => $user
->getAccountName(),
'IP' => $whois_enable ? Link::fromTextAndUrl($ip, Url::fromUri('whois/' . $ip, $attr)) : $ip,
'User Agent' => Html::escape($hit_details->visitors_user_agent),
);
if (\Drupal::service('module_handler')
->moduleExists('visitors_geoip')) {
$geoip_data_array = array(
'Country' => Html::escape($hit_details->visitors_country_name),
'Region' => Html::escape($hit_details->visitors_region),
'City' => Html::escape($hit_details->visitors_city),
'Postal Code' => Html::escape($hit_details->visitors_postal_code),
'Latitude' => Html::escape($hit_details->visitors_latitude),
'Longitude' => Html::escape($hit_details->visitors_longitude),
'DMA Code' => Html::escape($hit_details->visitors_dma_code),
'PSTN Area Code' => Html::escape($hit_details->visitors_area_code),
);
$array = array_merge($array, $geoip_data_array);
}
foreach ($array as $key => $value) {
$rows[] = array(
array(
'data' => t($key),
'header' => TRUE,
),
$value,
);
}
}
return $rows;
}
}