public function VarbaseContentOverview::build in Varbase Total Control Dashboard 9.0.x

Same name and namespace in other branches

1. 8.6 src/Plugin/Block/VarbaseContentOverview.php \Drupal\varbase_total_control\Plugin\Block\VarbaseContentOverview::build()
2. 8 src/Plugin/Block/VarbaseContentOverview.php \Drupal\varbase_total_control\Plugin\Block\VarbaseContentOverview::build()
3. 8.5 src/Plugin/Block/VarbaseContentOverview.php \Drupal\varbase_total_control\Plugin\Block\VarbaseContentOverview::build()

Builds and returns the renderable array for this block plugin.

If a block should not be rendered because it has no content, then this method must also ensure to return no content: it must then only return an empty array, or an empty array with #cache set (with cacheability metadata indicating the circumstances for it being empty).

Return value

array A renderable array representing the content of the block.

Overrides BlockPluginInterface::build

See also

\Drupal\block\BlockViewBuilder

File

src/Plugin/Block/VarbaseContentOverview.php, line 113

Class

VarbaseContentOverview

Provides a 'Varbase Content Overview'.

Namespace

Drupal\varbase_total_control\Plugin\Block

Code

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) {

    // Compare against type option on pane config.
    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');

      // Check if comments module is enabled.
      if ($comments_exist) {

        // Compare against comment options on pane config.
        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>');

          // Compare against spam option checkbox on pane config.
          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,
  ];
}