class Cities in Visitors 8.2
Hierarchy
- class \Drupal\Core\Controller\ControllerBase implements ContainerInjectionInterface uses LoggerChannelTrait, MessengerTrait, LinkGeneratorTrait, RedirectDestinationTrait, UrlGeneratorTrait, StringTranslationTrait
- class \Drupal\visitors\Controller\Report\Cities
Expanded class hierarchy of Cities
File
- src/
Controller/ Report/ Cities.php, line 19 - Contains Drupal\visitors\Controller\Report\Cities.
Namespace
Drupal\visitors\Controller\ReportView source
class Cities extends ControllerBase {
/**
* The date service.
*
* @var \Drupal\Core\Datetime\DateFormatterInterface
*/
protected $date;
/**
* The form builder service.
*
* @var \Drupal\Core\Form\FormBuilderInterface
*/
protected $formBuilder;
/**
* {@inheritdoc}
*/
public static function create(ContainerInterface $container) {
return new static($container
->get('date.formatter'), $container
->get('form_builder'));
}
/**
* Constructs a Cities object.
*
* @param \Drupal\Core\Datetime\DateFormatterInterface $date
* The date service.
*
* @param \Drupal\Core\Form\FormBuilderInterface $form_builder
* The form builder service.
*/
public function __construct(DateFormatterInterface $date_formatter, FormBuilderInterface $form_builder) {
$this->date = $date_formatter;
$this->formBuilder = $form_builder;
}
/**
* Returns a cities page.
*
* @return array
* A render array representing the cities page content.
*/
public function display($country) {
$form = $this->formBuilder
->getForm('Drupal\\visitors\\Form\\DateFilter');
$header = $this
->_getHeader();
return array(
'#title' => t('Visitors from') . ' ' . t($country),
'visitors_date_filter_form' => $form,
'visitors_table' => array(
'#type' => 'table',
'#header' => $header,
'#rows' => $this
->_getData($header, $country),
),
'visitors_pager' => array(
'#type' => 'pager',
),
);
}
/**
* Returns a table header configuration.
*
* @return array
* A render array representing the table header info.
*/
protected function _getHeader() {
return array(
'#' => array(
'data' => t('#'),
),
'visitors_city' => array(
'data' => t('City'),
'field' => 'visitors_city',
'specifier' => 'visitors_city',
'class' => array(
RESPONSIVE_PRIORITY_LOW,
),
),
'count' => array(
'data' => t('Count'),
'field' => 'count',
'specifier' => 'count',
'class' => array(
RESPONSIVE_PRIORITY_LOW,
),
'sort' => 'desc',
),
);
}
/**
* Returns a table content.
*
* @param array $header
* Table header configuration.
*
* @return array
* Array representing the table content.
*/
protected function _getData($header, $country) {
$items_per_page = \Drupal::config('visitors.config')
->get('items_per_page');
$original_country = $country == '(none)' ? '' : $country;
$query = \Drupal::database()
->select('visitors', 'v')
->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
->extend('Drupal\\Core\\Database\\Query\\TableSortExtender');
$query
->addExpression('COUNT(visitors_city)', 'count');
$query
->fields('v', array(
'visitors_city',
));
$query
->condition('v.visitors_country_name', $original_country);
visitors_date_filter_sql_condition($query);
$query
->groupBy('visitors_city');
$query
->orderByHeader($header);
$query
->limit($items_per_page);
$count_query = \Drupal::database()
->select('visitors', 'v');
$count_query
->addExpression('COUNT(DISTINCT visitors_city)');
$count_query
->condition('v.visitors_country_name', $original_country);
visitors_date_filter_sql_condition($count_query);
$query
->setCountQuery($count_query);
$results = $query
->execute();
$rows = array();
$page = isset($_GET['page']) ? $_GET['page'] : 0;
$i = 0 + $page * $items_per_page;
foreach ($results as $data) {
if ($data->visitors_city == '') {
$data->visitors_city = '(none)';
}
$visitors_city_url = Url::fromRoute('visitors.city_hits', array(
"country" => $country,
"city" => $data->visitors_city,
));
$visitors_city_link = Link::fromTextAndUrl($this
->t($data->visitors_city), $visitors_city_url);
$visitors_city_link = $visitors_city_link
->toRenderable();
$rows[] = array(
++$i,
render($visitors_city_link),
$data->visitors_city,
$data->count,
);
}
return $rows;
}
}
Members
Name | Modifiers | Type | Description | Overrides |
---|---|---|---|---|
Cities:: |
protected | property | The date service. | |
Cities:: |
protected | property |
The form builder service. Overrides ControllerBase:: |
|
Cities:: |
public static | function |
Instantiates a new instance of this class. Overrides ControllerBase:: |
|
Cities:: |
public | function | Returns a cities page. | |
Cities:: |
protected | function | Returns a table content. | |
Cities:: |
protected | function | Returns a table header configuration. | |
Cities:: |
public | function | Constructs a Cities object. | |
ControllerBase:: |
protected | property | The configuration factory. | |
ControllerBase:: |
protected | property | The current user service. | 1 |
ControllerBase:: |
protected | property | The entity form builder. | |
ControllerBase:: |
protected | property | The entity manager. | |
ControllerBase:: |
protected | property | The entity type manager. | |
ControllerBase:: |
protected | property | The key-value storage. | 1 |
ControllerBase:: |
protected | property | The language manager. | 1 |
ControllerBase:: |
protected | property | The module handler. | 2 |
ControllerBase:: |
protected | property | The state service. | |
ControllerBase:: |
protected | function | Returns the requested cache bin. | |
ControllerBase:: |
protected | function | Retrieves a configuration object. | |
ControllerBase:: |
private | function | Returns the service container. | |
ControllerBase:: |
protected | function | Returns the current user. | 1 |
ControllerBase:: |
protected | function | Retrieves the entity form builder. | |
ControllerBase:: |
protected | function | Retrieves the entity manager service. | |
ControllerBase:: |
protected | function | Retrieves the entity type manager. | |
ControllerBase:: |
protected | function | Returns the form builder service. | 2 |
ControllerBase:: |
protected | function | Returns a key/value storage collection. | 1 |
ControllerBase:: |
protected | function | Returns the language manager service. | 1 |
ControllerBase:: |
protected | function | Returns the module handler. | 2 |
ControllerBase:: |
protected | function |
Returns a redirect response object for the specified route. Overrides UrlGeneratorTrait:: |
|
ControllerBase:: |
protected | function | Returns the state storage service. | |
LinkGeneratorTrait:: |
protected | property | The link generator. | 1 |
LinkGeneratorTrait:: |
protected | function | Returns the link generator. | |
LinkGeneratorTrait:: |
protected | function | Renders a link to a route given a route name and its parameters. | |
LinkGeneratorTrait:: |
public | function | Sets the link generator service. | |
LoggerChannelTrait:: |
protected | property | The logger channel factory service. | |
LoggerChannelTrait:: |
protected | function | Gets the logger for a specific channel. | |
LoggerChannelTrait:: |
public | function | Injects the logger channel factory. | |
MessengerTrait:: |
protected | property | The messenger. | 29 |
MessengerTrait:: |
public | function | Gets the messenger. | 29 |
MessengerTrait:: |
public | function | Sets the messenger. | |
RedirectDestinationTrait:: |
protected | property | The redirect destination service. | 1 |
RedirectDestinationTrait:: |
protected | function | Prepares a 'destination' URL query parameter for use with \Drupal\Core\Url. | |
RedirectDestinationTrait:: |
protected | function | Returns the redirect destination service. | |
RedirectDestinationTrait:: |
public | function | Sets the redirect destination service. | |
StringTranslationTrait:: |
protected | property | The string translation service. | 1 |
StringTranslationTrait:: |
protected | function | Formats a string containing a count of items. | |
StringTranslationTrait:: |
protected | function | Returns the number of plurals supported by a given language. | |
StringTranslationTrait:: |
protected | function | Gets the string translation service. | |
StringTranslationTrait:: |
public | function | Sets the string translation service to use. | 2 |
StringTranslationTrait:: |
protected | function | Translates a string to the current language or to a given language. | |
UrlGeneratorTrait:: |
protected | property | The url generator. | |
UrlGeneratorTrait:: |
protected | function | Returns the URL generator service. | |
UrlGeneratorTrait:: |
public | function | Sets the URL generator service. | |
UrlGeneratorTrait:: |
protected | function | Generates a URL or path for a specific route based on the given parameters. |