You are here

class CaptchaQuestionsDblogController in Captcha Questions 8

Provides route responses for the Example module.

Hierarchy

Expanded class hierarchy of CaptchaQuestionsDblogController

File

captcha_questions_dblog/src/Controller/CaptchaQuestionsDblogController.php, line 14

Namespace

Drupal\captcha_questions_dblog\Controller
View source
class CaptchaQuestionsDblogController extends ControllerBase {

  /**
   * DateFormatter services object.
   *
   * @var \Drupal\Core\Datetime\DateFormatter
   */
  private $dateFormatter;

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

  /**
   * {@inheritdoc}
   */
  public static function create(ContainerInterface $container) {
    return new static($container
      ->get('date.formatter'), $container
      ->get('database'));
  }

  /**
   * CaptchaQuestionsDblog Constuctor.
   *
   * @param \Drupal\Core\Datetime\DateFormatter $dateFormatter
   *   DateFormatter services object.
   * @param \Drupal\Core\Database\Connection $database
   *   The Database Connection.
   */
  public function __construct(DateFormatter $dateFormatter, Connection $database) {
    $this->dateFormatter = $dateFormatter;
    $this->database = $database;
  }

  /**
   * Fetch and display failed form submissions.
   *
   * @return array
   *   Returns themed table with pager
   */
  public function captchaQuestionsDblogView() {
    $header = [
      [
        'data' => $this
          ->t('Submission'),
        'field' => 'dblogid',
      ],
      [
        'data' => $this
          ->t('Timestamp'),
        'field' => 'timestamp',
      ],
      [
        'data' => $this
          ->t('IP'),
        'field' => 'IP',
      ],
      [
        'data' => $this
          ->t('Form ID'),
        'field' => 'form_id',
      ],
      [
        'data' => $this
          ->t('Question asked'),
        'field' => 'question_asked',
      ],
      [
        'data' => $this
          ->t('Answer given'),
        'field' => 'answer_given',
      ],
      [
        'data' => $this
          ->t('Correct answer'),
        'field' => 'answer_correct',
      ],
    ];
    $rows = [];
    $query = $this->database
      ->select('captcha_questions_dblog', 'log');
    $query
      ->fields('log', [
      'dblogid',
      'timestamp',
      'ip',
      'form_id',
      'question_asked',
      'answer_given',
      'answer_correct',
    ]);

    // The actual action of sorting the rows is here.
    $table_sort = $query
      ->extend('Drupal\\Core\\Database\\Query\\TableSortExtender')
      ->orderByHeader($header);

    // Limit the rows to 5 for each page.
    $pager = $table_sort
      ->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
      ->limit(5);
    $result = $pager
      ->execute();

    // Constructing rows from $entries matching $header.
    foreach ($result as $e) {
      $rows[] = [
        $e->dblogid,
        $this->dateFormatter
          ->format($e->timestamp, 'custom', 'Y-m-d H:m:s'),
        $e->ip,
        $e->form_id,
        Unicode::truncate($e->question_asked, '30', TRUE, 20),
        $e->answer_given,
        $e->answer_correct,
      ];
    }
    $count = count($rows);

    // The table description.
    $build = [
      '#markup' => $this
        ->t('Found a total of @count failed submissions', [
        '@count' => $count,
      ]),
    ];

    // Generate the table.
    $build['config_table'] = [
      '#theme' => 'table',
      '#header' => $header,
      '#rows' => $rows,
    ];

    // Finally add the pager.
    $build['pager'] = [
      '#type' => 'pager',
    ];
    return $build;
  }

}

Members

Namesort descending Modifiers Type Description Overrides
CaptchaQuestionsDblogController::$database protected property The Database Connection.
CaptchaQuestionsDblogController::$dateFormatter private property DateFormatter services object.
CaptchaQuestionsDblogController::captchaQuestionsDblogView public function Fetch and display failed form submissions.
CaptchaQuestionsDblogController::create public static function Instantiates a new instance of this class. Overrides ControllerBase::create
CaptchaQuestionsDblogController::__construct public function CaptchaQuestionsDblog Constuctor.
ControllerBase::$configFactory protected property The configuration factory.
ControllerBase::$currentUser protected property The current user service. 1
ControllerBase::$entityFormBuilder protected property The entity form builder.
ControllerBase::$entityManager protected property The entity manager.
ControllerBase::$entityTypeManager protected property The entity type manager.
ControllerBase::$formBuilder protected property The form builder. 2
ControllerBase::$keyValue protected property The key-value storage. 1
ControllerBase::$languageManager protected property The language manager. 1
ControllerBase::$moduleHandler protected property The module handler. 2
ControllerBase::$stateService protected property The state service.
ControllerBase::cache protected function Returns the requested cache bin.
ControllerBase::config protected function Retrieves a configuration object.
ControllerBase::container private function Returns the service container.
ControllerBase::currentUser protected function Returns the current user. 1
ControllerBase::entityFormBuilder protected function Retrieves the entity form builder.
ControllerBase::entityManager Deprecated protected function Retrieves the entity manager service.
ControllerBase::entityTypeManager protected function Retrieves the entity type manager.
ControllerBase::formBuilder protected function Returns the form builder service. 2
ControllerBase::keyValue protected function Returns a key/value storage collection. 1
ControllerBase::languageManager protected function Returns the language manager service. 1
ControllerBase::moduleHandler protected function Returns the module handler. 2
ControllerBase::redirect protected function Returns a redirect response object for the specified route. Overrides UrlGeneratorTrait::redirect
ControllerBase::state protected function Returns the state storage service.
LinkGeneratorTrait::$linkGenerator protected property The link generator. 1
LinkGeneratorTrait::getLinkGenerator Deprecated protected function Returns the link generator.
LinkGeneratorTrait::l Deprecated protected function Renders a link to a route given a route name and its parameters.
LinkGeneratorTrait::setLinkGenerator Deprecated public function Sets the link generator service.
LoggerChannelTrait::$loggerFactory protected property The logger channel factory service.
LoggerChannelTrait::getLogger protected function Gets the logger for a specific channel.
LoggerChannelTrait::setLoggerFactory public function Injects the logger channel factory.
MessengerTrait::$messenger protected property The messenger. 29
MessengerTrait::messenger public function Gets the messenger. 29
MessengerTrait::setMessenger public function Sets the messenger.
RedirectDestinationTrait::$redirectDestination protected property The redirect destination service. 1
RedirectDestinationTrait::getDestinationArray protected function Prepares a 'destination' URL query parameter for use with \Drupal\Core\Url.
RedirectDestinationTrait::getRedirectDestination protected function Returns the redirect destination service.
RedirectDestinationTrait::setRedirectDestination public function Sets the redirect destination service.
StringTranslationTrait::$stringTranslation protected property The string translation service. 1
StringTranslationTrait::formatPlural protected function Formats a string containing a count of items.
StringTranslationTrait::getNumberOfPlurals protected function Returns the number of plurals supported by a given language.
StringTranslationTrait::getStringTranslation protected function Gets the string translation service.
StringTranslationTrait::setStringTranslation public function Sets the string translation service to use. 2
StringTranslationTrait::t protected function Translates a string to the current language or to a given language.
UrlGeneratorTrait::$urlGenerator protected property The url generator.
UrlGeneratorTrait::getUrlGenerator Deprecated protected function Returns the URL generator service.
UrlGeneratorTrait::setUrlGenerator Deprecated public function Sets the URL generator service.
UrlGeneratorTrait::url Deprecated protected function Generates a URL or path for a specific route based on the given parameters.