function role_watchdog_grants in Role Watchdog 6

Same name and namespace in other branches

1. 6.2 role_watchdog.pages.inc \role_watchdog_grants()
2. 7.2 role_watchdog.pages.inc \role_watchdog_grants()
3. 7 role_watchdog.pages.inc \role_watchdog_grants()

1 string reference to 'role_watchdog_grants'

role_watchdog_menu in ./role_watchdog.module

Implementation of hook_menu().

File

./role_watchdog.pages.inc, line 54

User page callbacks for the role_watchdog module.

Code

function role_watchdog_grants($account) {
  $output = '';
  $rows = $rows2 = array();
  $roles = user_roles();
  $header = array(
    array(
      'data' => t('Date'),
      'style' => 'width: 25%;',
    ),
    array(
      'data' => t('Role'),
      'style' => 'width: 30%;',
    ),
    array(
      'data' => t('Change'),
      'style' => 'width: 15%;',
    ),
    array(
      'data' => t('User'),
      'style' => 'width: 30%;',
    ),
  );
  $grants_query = 'SELECT rw.rid, rw.action, rw.aid, rw.stamp, u.name FROM {role_watchdog} rw INNER JOIN {users} u ON (rw.aid = u.uid) WHERE rw.uid=%d AND rw.aid<>%d ORDER BY rw.stamp DESC';
  $items_per_page = variable_get('role_watchdog_pager', 50);
  $result = pager_query($grants_query, $items_per_page, 0, "SELECT COUNT(*) from {role_watchdog} rw WHERE rw.uid=%d AND rw.aid<>%d", $account->uid, $account->uid);
  $rows2 = _role_watchdog_history_rows($result, $roles, array(
    t('removed from'),
    t('added to'),
    t('requested by'),
    t('approved for'),
  ));
  if (sizeof($rows2)) {
    $output .= '<h3>' . t('Role Grants Made') . '</h3>' . theme('table', $header, $rows2, array(
      'style' => 'width: 99%;',
    ));
    if ($pager = theme('pager', NULL, $items_per_page, 0)) {
      $output .= $pager;
    }
  }
  return $output ? $output : t('No role grants made.');
}