function visitors_node in Visitors 7

Same name and namespace in other branches

1. 8 reports/node.inc \visitors_node()
2. 7.2 reports/node.inc \visitors_node()
3. 7.0 reports/node.inc \visitors_node()

Display node visitors report.

Return value

string node visitors report html source

1 string reference to 'visitors_node'

visitors_menu in ./visitors.module

Menu callback. Prints a listing of active nodes on the site.

File

reports/node.inc, line 14

Node page callbacks for the visitors module.

Code

function visitors_node() {
  if ($node = node_load(arg(1))) {
    $date_format = variable_get('date_format_short_custom', 'Y-m-d H:i:s');
    $items_per_page = variable_get('visitors_lines_per_page', 10);
    $header = array(
      array(
        'data' => t('#'),
      ),
      array(
        'data' => t('ID'),
        'field' => 'visitors_id',
        'sort' => 'desc',
      ),
      array(
        'data' => t('Date'),
        'field' => 'visitors_date_time',
      ),
      array(
        'data' => t('Referer'),
        'field' => 'visitors_referer',
      ),
      array(
        'data' => t('User'),
        'field' => 'u.name',
      ),
      array(
        'data' => t('Operations'),
      ),
    );
    $query = db_select('visitors', 'v')
      ->extend('PagerDefault')
      ->extend('TableSort');
    $query
      ->leftJoin('users', 'u', 'u.uid=v.visitors_uid');
    $query
      ->fields('v', array(
      'visitors_uid',
      'visitors_id',
      'visitors_date_time',
      'visitors_referer',
    ));
    $query
      ->fields('u', array(
      'name',
      'uid',
    ));
    $db_or = db_or();
    $db_or
      ->condition('v.visitors_path', 'node/' . (int) $node->nid, '=');
    $db_or
      ->condition('v.visitors_path', 'node/' . (int) $node->nid . '/%', 'LIKE');
    $query
      ->condition($db_or);
    visitors_date_filter_sql_condition($query);
    $query
      ->orderByHeader($header);
    $query
      ->limit($items_per_page);
    $results = $query
      ->execute();
    $rows = array();
    $page = isset($_GET['page']) ? $_GET['page'] : '';
    $i = 0 + $page * $items_per_page;
    foreach ($results as $data) {
      $user = user_load($data->visitors_uid);
      $user_page = theme('username', array(
        'account' => $user,
      ));
      $rows[] = array(
        ++$i,
        $data->visitors_id,
        format_date($data->visitors_date_time, 'custom', $date_format),
        l($data->visitors_referer, $data->visitors_referer),
        $user_page,
        l(t('details'), 'visitors/hits/' . $data->visitors_id),
      );
    }
    $output = visitors_date_filter();
    $output .= theme('table', array(
      'header' => $header,
      'rows' => $rows,
    ));
    $output .= theme('pager', array(
      'quantity' => $items_per_page,
    ));
    return $output;
  }
}