View source
<?php
namespace Drupal\varbase_total_control\Plugin\Block;
use Drupal\Core\Url;
use Drupal\Core\Link;
use Drupal\Core\Render\Markup;
use Drupal\Core\Block\BlockBase;
use Drupal\Core\Block\BlockPluginInterface;
use Drupal\Core\Form\FormStateInterface;
use Drupal\Core\Entity\EntityTypeManagerInterface;
use Drupal\Core\Database\Connection;
use Drupal\Core\StringTranslation\TranslationInterface;
use Drupal\Core\Extension\ModuleHandlerInterface;
use Drupal\Core\Render\RendererInterface;
use Drupal\Core\Plugin\ContainerFactoryPluginInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
class VarbaseContentOverview extends BlockBase implements BlockPluginInterface, ContainerFactoryPluginInterface {
protected $moduleHandler;
protected $connection;
protected $stringTranslation;
protected $entityTypeManager;
protected $renderer;
public function __construct(array $configuration, $plugin_id, $plugin_definition, ModuleHandlerInterface $module_handler, Connection $connection, TranslationInterface $string_translation, EntityTypeManagerInterface $entity_type_manager, RendererInterface $renderer) {
parent::__construct($configuration, $plugin_id, $plugin_definition);
$this->moduleHandler = $module_handler;
$this->connection = $connection;
$this->stringTranslation = $string_translation;
$this->entityTypeManager = $entity_type_manager;
$this->renderer = $renderer;
}
public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition) {
return new static($configuration, $plugin_id, $plugin_definition, $container
->get('module_handler'), $container
->get('database'), $container
->get('string_translation'), $container
->get('entity_type.manager'), $container
->get('renderer'));
}
public function build() {
$header = [
[
'data' => $this
->t('Content'),
],
[
'data' => $this
->t('Discussion'),
],
];
$rows = [];
$types = $this->entityTypeManager
->getStorage('node_type')
->loadMultiple();
$config = $this
->getConfiguration();
$comments_exist = $this->moduleHandler
->moduleExists('comment');
$spam = isset($config['varbase_total_control_spam_overview']) && $config['varbase_total_control_spam_overview'] == 1;
foreach ($types as $type => $object) {
if (!array_key_exists($type, $config['varbase_total_control_types_overview']) || (isset($config['varbase_total_control_types_overview']) && $config['varbase_total_control_types_overview'][$type]) == $type) {
$type_query = $this->connection
->query("SELECT count(*) FROM {node_field_data} WHERE type = :type and status = 1", [
':type' => $type,
]);
$type_count = $type_query
->fetchField();
$content_data[$type] = $this->stringTranslation
->formatPlural(number_format($type_count, 0, '.', ''), '<span class="num">1</span> ' . $object
->get('name') . ' item', '<span class="num">@count</span> ' . $object
->get('name') . ' items');
if ($comments_exist) {
if (!array_key_exists($type, $config['varbase_total_control_comments_overview']) || (isset($config['varbase_total_control_comments_overview']) && $config['varbase_total_control_comments_overview'][$type]) == $type) {
$comment_query = $this->connection
->query("SELECT count(DISTINCT c.cid) FROM {comment} c INNER JOIN {comment_field_data} n ON c.cid = n.cid INNER JOIN {node} node WHERE n.entity_id = node.nid AND node.type = :type AND n.status = 1", [
':type' => $type,
]);
$comment_count = $comment_query
->fetchField();
$content_data[$type . '_comments'] = $this->stringTranslation
->formatPlural(number_format($comment_count), '<span class="comment"><span class="num">@count</span> Comment</span>', '<span class="comment"><span class="num">@count</span> Comments</span>');
if ($spam) {
$spam_query = $this->connection
->query("SELECT count(DISTINCT c.cid) FROM {comment} c INNER JOIN {comment_field_data} n ON c.cid = n.cid INNER JOIN {node} node WHERE n.entity_id = node.nid AND node.type = :type AND n.status = 0", [
':type' => $type,
]);
$spam_count = $spam_query
->fetchField();
$content_data[$type . '_comments_spam'] = $this->stringTranslation
->formatPlural(number_format($spam_count), '<span class="spam"><span class="num">@count</span> Spam</span>', '<span class="spam"><span class="num">@count</span> Spams</span>');
}
}
}
$options = [
'type' => $type,
];
$link = Link::fromTextAndUrl($content_data[$type], new Url('system.admin_content', $options));
if ($comments_exist && isset($content_data[$type . '_comments_spam'])) {
$comment = !empty($content_data[$type . '_comments_spam']) ? Markup::create($content_data[$type . '_comments']
->render() . $content_data[$type . '_comments_spam']
->render()) : Markup::create($content_data[$type . '_comments']
->render());
$rows[] = [
'data' => [
[
'data' => $link
->toString(),
'class' => [
'type',
],
],
[
'data' => $comment,
'class' => [
'discussion',
],
],
],
];
}
else {
$header = [
[
'data' => $this
->t('Content'),
],
];
$rows[] = [
'data' => [
$link,
],
];
}
}
}
$body_data = [
'#theme' => 'table',
'#header' => $header,
'#rows' => $rows,
];
$makup_data = $this->renderer
->render($body_data);
return [
'#type' => 'markup',
'#markup' => $makup_data,
];
}
public function blockForm($form, FormStateInterface $form_state) {
$form = parent::blockForm($form, $form_state);
$config = $this
->getConfiguration();
$types = $this->entityTypeManager
->getStorage('node_type')
->loadMultiple();
$type_defaults = [];
foreach ($types as $type => $object) {
if (!array_key_exists($type, $type_defaults)) {
$type_defaults[$type] = $type;
}
}
$form['varbase_total_control_types_overview'] = [
'#type' => 'checkboxes',
'#title' => $this
->t('Show post counts for the following content types'),
'#options' => $type_defaults,
'#default_value' => $config['varbase_total_control_types_overview'],
];
$form['varbase_total_control_comments_overview'] = [
'#type' => 'checkboxes',
'#title' => $this
->t('Show comment counts for the following content types'),
'#options' => $type_defaults,
'#default_value' => $config['varbase_total_control_comments_overview'],
];
$spam_options = [
0 => $this
->t('no'),
1 => $this
->t('Yes'),
];
$form['varbase_total_control_spam_overview'] = [
'#type' => 'radios',
'#title' => $this
->t('Include spam counts with comments'),
'#options' => $spam_options,
'#default_value' => $config['varbase_total_control_spam_overview'],
];
return $form;
}
public function blockSubmit($form, FormStateInterface $form_state) {
parent::blockSubmit($form, $form_state);
$values = $form_state
->getValues();
$this->configuration['varbase_total_control_types_overview'] = $values['varbase_total_control_types_overview'];
$this->configuration['varbase_total_control_comments_overview'] = $values['varbase_total_control_comments_overview'];
$this->configuration['varbase_total_control_spam_overview'] = $values['varbase_total_control_spam_overview'];
}
}