public function VarbaseContentOverview::build in Varbase Total Control Dashboard 8.5

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. 9.0.x 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 25

Class

VarbaseContentOverview

Provides a 'Varbase Content Overview'.

Namespace

Drupal\varbase_total_control\Plugin\Block

Code

public function build() {
  $header = [
    [
      'data' => t('Content'),
    ],
    [
      'data' => t('Discussion'),
    ],
  ];
  $rows = [];
  $types = node_type_get_types();
  $config = $this
    ->getConfiguration();
  $moduleHandler = \Drupal::service('module_handler');
  $comments_exist = $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_count = db_query("SELECT count(*) FROM {node_field_data} WHERE type = :type and status = 1", [
        ':type' => $type,
      ])
        ->fetchField();
      $content_data[$type] = \Drupal::translation()
        ->formatPlural(number_format($type_count), '<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_count = db_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,
          ])
            ->fetchField();
          $content_data[$type . '_comments'] = \Drupal::translation()
            ->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_count = db_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,
            ])
              ->fetchField();
            $content_data[$type . '_comments_spam'] = \Drupal::translation()
              ->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,
      ];
      $url = new Url('system.admin_content', $options);
      $link = \Drupal::l($content_data[$type], $url);
      if ($comments_exist) {
        $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' => Markup::create($link),
              'class' => [
                'type',
              ],
            ],
            [
              'data' => $comment,
              'class' => [
                'discussion',
              ],
            ],
          ],
        ];
      }
      else {
        $header = [
          [
            'data' => t('Content'),
          ],
        ];
        $rows[] = [
          'data' => [
            $link,
          ],
        ];
      }
    }
  }
  $body_data = [
    '#theme' => 'table',
    '#header' => $header,
    '#rows' => $rows,
  ];
  return [
    '#type' => 'markup',
    '#markup' => drupal_render($body_data),
  ];
}