class EventLogStorage in Events Log Track 8.2

Controller class for event log track required special handling for events.

Hierarchy

• class \Drupal\event_log_track\EventLogStorage

File

src/EventLogStorage.php, line 8

Namespace

Drupal\event_log_track

class EventLogStorage {

  /**
   * Display event data listing.
   *
   * @param array $getData
   *   Filter to display data.
   * @param array $header
   *   Data sorting type.
   * @param int $limit
   *   Limit to display data.
   *
   * @return array
   *   The result to display.
   */
  public static function getSearchData(array $getData, array $header, $limit = NULL) {
    $db = \Drupal::database();
    $query = $db
      ->select('event_log_track', 'e');
    $query
      ->fields('e');
    $table_sort = $query
      ->extend('Drupal\\Core\\Database\\Query\\TableSortExtender')
      ->orderByHeader($header);
    $pager = $table_sort
      ->extend('Drupal\\Core\\Database\\Query\\PagerSelectExtender')
      ->limit($limit);

    // Apply filters.
    if (!empty($getData['type'])) {
      $query
        ->condition('type', $getData['type']);
      if (!empty($getData['operation'])) {
        $query
          ->condition('operation', $getData['operation']);
      }
    }
    if (!empty($getData['id'])) {
      $query
        ->condition('ref_numeric', $getData['id']);
    }
    if (!empty($getData['ip'])) {
      $query
        ->condition('ip', $getData['ip']);
    }
    if (!empty($getData['name'])) {
      $query
        ->condition('ref_char', $getData['name']);
    }
    if (!empty($getData['path'])) {
      $query
        ->condition('path', '%' . db_like($getData['path']) . '%', 'LIKE');
    }
    if (!empty($getData['keyword'])) {
      $query
        ->condition('description', '%' . db_like($getData['keyword']) . '%', 'LIKE');
    }
    if (!empty($getData['user'])) {
      $getUid = substr($getData['user'], strrpos($getData['user'], '(') + 1, -1);
      $query
        ->condition('uid', $getUid);
    }
    $result = $pager
      ->execute();
    return $result;
  }

  /**
   * Returns the form element for the operations based on the event log type.
   *
   * @param string $type
   *   Event type.
   *
   * @return array
   *   A form element.
   */
  public static function formGetOperations($type) {
    $element = [
      '#type' => 'select',
      '#name' => 'operation',
      '#title' => t('CUD Operation'),
      '#options' => [
        '' => t('Choose an operation'),
      ],
      '#prefix' => '<div id="operation-dropdown-replace">',
      '#suffix' => '</div>',
    ];
    if ($type) {
      $db = \Drupal::database();
      $query = $db
        ->select('event_log_track', 'e')
        ->fields('e', [
        'operation',
      ])
        ->condition('type', $type)
        ->groupBy('operation');
      $query
        ->addExpression('COUNT(e.lid)', 'c');
      $query
        ->distinct(TRUE);
      $results = $query
        ->execute()
        ->fetchAllKeyed(0);
      $operations = [];
      foreach ($results as $name => $count) {
        $operations[$name] = $name . ' (' . $count . ')';
      }
      $element['#options'] += $operations;
    }
    return $element;
  }

}

Members

Name	Modifiers	Type	Description	Overrides
EventLogStorage::formGetOperations	public static	function	Returns the form element for the operations based on the event log type.
EventLogStorage::getSearchData	public static	function	Display event data listing.