function simple_access_nodes in Simple Access 5

Same name and namespace in other branches

1. 5.2 simple_access.module \simple_access_nodes()

List hidden, editable, and deletable nodes

1 string reference to 'simple_access_nodes'

simple_access_menu in ./simple_access.module

Implementation of hook_menu().

File

./simple_access.module, line 527

This module allows administrators to make nodes viewable by specific 'access groups'. Each access group can contain any number of roles. If a node is not assigned to any access groups, it will remain viewable by all users.

Code

function simple_access_nodes() {
  switch (arg(3)) {
    case 'edit':
      drupal_set_title(t('Items With Edit Access Set'));
      $output = '<div>' . t('These nodes have been set as "additionally editable by" certain Simple Access <a href="!url">groups</a>. ', array(
        '!url' => url('admin/user/simple_access'),
      )) . '</div><br />';
      $sql = "SELECT DISTINCT n.title, na.nid FROM {node} n INNER JOIN {node_access} na ON n.nid = na.nid WHERE na.realm='simple_access' AND na.gid > 0 AND na.grant_update = 1";
      break;
    case 'delete':
      drupal_set_title(t('Items With Delete Access Set'));
      $output = '<div>' . t('These nodes have been set as "additionally deletable by" certain Simple Access <a href="!url">groups</a>. ', array(
        '!url' => url('admin/user/simple_access'),
      )) . '</div><br />';
      $sql = "SELECT DISTINCT n.title, na.nid FROM {node} n INNER JOIN {node_access} na ON n.nid = na.nid WHERE na.realm='simple_access' AND na.gid > 0 AND na.grant_delete = 1";
      break;
    case 'view':
    default:
      drupal_set_title(t('Items With View Access Set'));
      $output = '<div>' . t('These nodes have been set as "only viewable by" certain Simple Access <a href="!url">groups</a>.', array(
        '!url' => url('admin/user/simple_access'),
      )) . '</div><br />';
      $sql = "SELECT DISTINCT n.title, na.nid FROM {node} n INNER JOIN {node_access} na ON n.nid = na.nid WHERE na.realm='simple_access' AND na.gid > 0 AND na.grant_view = 1";
      break;
  }
  $header = array(
    array(
      'data' => t('ID'),
      'field' => 'n.nid',
      'sort' => 'desc',
    ),
    array(
      'data' => t('Title'),
      'field' => 'n.title',
    ),
    array(
      'data' => '&nbsp;',
    ),
  );
  $sql .= tablesort_sql($header);
  $result = pager_query($sql, 50);
  $groups_info = simple_access_get_groups();
  while ($r = db_fetch_object($result)) {
    $groups = array();
    $rs2 = db_query('SELECT na.gid, na.grant_view, na.grant_update, na.grant_delete FROM {node_access} na WHERE na.nid = %d AND na.realm = \'simple_access\'', $r->nid);
    while ($r2 = db_fetch_object($rs2)) {
      $groups[] = $groups_info[$r2->gid]['name'];
    }
    $rows[$r->nid]['nid'] = array(
      'data' => $r->nid,
      'style' => 'vertical-align:top',
    );
    $info = '<div>' . $r->title . '</div><div style="font-size:xx-small">' . implode(', ', $groups) . '</div>';
    $rows[$r->nid]['title'] = array(
      'data' => $info,
      'style' => 'vertical-align:top',
    );
    $rows[$r->nid]['ops'] = array(
      'data' => l(t('view'), 'node/' . $r->nid) . ' ' . l(t('edit'), 'node/' . $r->nid . '/edit', array(), drupal_get_destination()),
      'style' => 'vertical-align:top',
    );
  }
  if ($rows) {
    $output .= theme('table', $header, $rows, array(
      'style' => 'width:100%',
    ));
    $output .= theme('pager', array(), 50);
  }
  else {
    $output .= '<div>' . t('No nodes match this criteria.') . '</div>';
  }
  return $output;
}