KanbanStatisticService.php in Content Planner 8

Namespace

Drupal\content_kanban

File

modules/content_kanban/src/KanbanStatisticService.php

<?php

namespace Drupal\content_kanban;

use Drupal\Core\Database\Driver\mysql\Connection;
use Drupal\workflows\Entity\Workflow;

/**
 * Class KanbanStatisticService.
 */
class KanbanStatisticService {

  /**
   * The database service.
   *
   * @var \Drupal\Core\Database\Connection
   */
  protected $database;

  /**
   * Constructs a new NewsService object.
   */
  public function __construct(Connection $database) {
    $this->database = $database;
  }

  /**
   * Get content counts from a given Workflow.
   *
   * @param \Drupal\workflows\Entity\Workflow $workflow
   *   The workflow object.
   *
   * @return array
   *   Returns an array with the workflow state content counts.
   */
  public function getWorkflowStateContentCounts(Workflow $workflow) {

    // Get all workflow states form a given workflow.
    $workflow_states = KanbanWorkflowService::getWorkflowStates($workflow);
    $data = [];
    foreach ($workflow_states as $state_id => $state_label) {
      $count = $this
        ->getWorkflowStateContentCount($workflow
        ->id(), $state_id);
      $data[$state_id] = [
        'id' => $state_id,
        'label' => $state_label,
        'count' => $count,
      ];
    }
    return $data;
  }

  /**
   * Get the content count of a given workflow state.
   *
   * @param string $workflow_id
   *   The workflow ID.
   * @param string $state_id
   *   The state ID.
   *
   * @return mixed
   *   Returns the workflow state content count.
   */
  public function getWorkflowStateContentCount($workflow_id, $state_id) {
    $query = $this->database
      ->select('content_moderation_state_field_data', 'c');
    $query
      ->addField('c', 'id');
    $query
      ->condition('c.workflow', $workflow_id);
    $query
      ->condition('c.moderation_state', $state_id);
    $count_query = $query
      ->countQuery();
    $result = $count_query
      ->execute()
      ->fetchObject();
    return $result->expression;
  }

}

Classes

Name	Description
KanbanStatisticService	Class KanbanStatisticService.