public static function GoogleAnalyticsCounterHelper::getCount in Google Analytics Counter 8.3

Get the row count of a table, sometimes with conditions.

Parameters

string $table:

Return value

mixed

2 calls to GoogleAnalyticsCounterHelper::getCount()

GoogleAnalyticsCounterController::dashboard in src/Controller/GoogleAnalyticsCounterController.php

GoogleAnalyticsCounterSettingsForm::buildForm in src/Form/GoogleAnalyticsCounterSettingsForm.php

Form constructor.

File

src/GoogleAnalyticsCounterHelper.php, line 61

Class

GoogleAnalyticsCounterHelper

Provides Google Analytics Counter helper functions.

Namespace

Drupal\google_analytics_counter

Code

public static function getCount($table) {
  $connection = \Drupal::database();
  switch ($table) {
    case 'google_analytics_counter_storage':
      $query = $connection
        ->select($table, 't');
      $query
        ->addField('t', 'field_pageview_total');
      $query
        ->condition('pageview_total', 0, '>');
      break;
    case 'google_analytics_counter_storage_all_nodes':
      $query = $connection
        ->select('google_analytics_counter_storage', 't');
      break;
    case 'queue':
      $query = $connection
        ->select('queue', 'q');
      $query
        ->condition('name', 'google_analytics_counter_worker', '=');
      break;
    default:
      $query = $connection
        ->select($table, 't');
      break;
  }
  return $query
    ->countQuery()
    ->execute()
    ->fetchField();
}