function ulogin_report in uLogin (advanced version) 7

Same name and namespace in other branches

1. 6 ulogin.admin.inc \ulogin_report()

1 string reference to 'ulogin_report'

ulogin_menu in ./ulogin.module

Implements hook_menu().

File

./ulogin.admin.inc, line 358

Administration pages functions for uLogin module.

Code

function ulogin_report() {
  $providers = _ulogin_providers_list();
  $header = array(
    t('Authentication provider'),
    t('Users count'),
  );
  $rows = array();
  $query = db_select('ulogin_identity', 'ul_id');
  $query
    ->addField('ul_id', 'network', 'network');
  $query
    ->addExpression('COUNT(ulogin_uid)', 'count');
  $query
    ->groupBy('network');
  $results = $query
    ->execute()
    ->fetchAllAssoc('network', PDO::FETCH_ASSOC);
  foreach ($results as $result) {
    $rows[] = array(
      $providers[$result['network']],
      $result['count'],
    );
  }
  $form = array();
  $form['report'] = array(
    '#theme' => 'table',
    '#header' => $header,
    '#rows' => $rows,
  );
  return $form;
}