<?php

/**
 * @file
 * Hit details report for the visitors module.
 */

/**
 * Menu callback; Displays recent page accesses.
 *
 * @param visitors_id
 *   int visitors id from visitors table
 *
 * @return
 *   string hit details report or 404 error if visitors_id not found
 */
function visitors_hit_details($visitors_id) {
  $result = db_query('SELECT a.*, u.name, u.uid
    FROM {visitors} a
    LEFT JOIN {users} u
    ON a.visitors_uid = u.uid
    WHERE visitors_id = %d',
    $visitors_id
  );

  if ($hit_details = db_fetch_object($result)) {
    $url = urldecode($hit_details->visitors_url);
    $referer = $hit_details->visitors_referer;
    $date = format_date($hit_details->visitors_date_time, 'large');
    $whois_enable = module_exists('whois');
    $attr = array(
      'attributes' => array(
        'target' => '_blank',
        'title' => t('Whois lookup')
      )
    );
    $ip = long2ip($hit_details->visitors_ip);

    $array = array(
      'URL'              => l($url, $url),
      'Title'            => check_plain($hit_details->visitors_title),
      'Referer'          => $referer ? l($referer, $referer) : '',
      'Date'             => $date,
      'User'             => theme('username', $hit_details),
      'IP'               => $whois_enable ? l($ip, 'whois/' . $ip, $attr) : $ip,
      'User Agent'       => check_plain($hit_details->visitors_user_agent),
    );

    if (module_exists('visitors_geoip')) {
      $geoip_data_array = array(
        'Country'        => check_plain($hit_details->visitors_country_name),
        'Region'         => check_plain($hit_details->visitors_region),
        'City'           => check_plain($hit_details->visitors_city),
        'Postal Code'    => check_plain($hit_details->visitors_postal_code),
        'Latitude'       => check_plain($hit_details->visitors_latitude),
        'Longitude'      => check_plain($hit_details->visitors_longitude),
        'DMA Code'       => check_plain($hit_details->visitors_dma_code),
        'PSTN Area Code' => check_plain($hit_details->visitors_area_code),
      );
      $array = array_merge($array, $geoip_data_array);
    }

    $rows = array();
    foreach ($array as $key => $value) {
      $rows[] = array(array('data' => t($key), 'header' => TRUE), $value);
    }

    drupal_set_title(t('Details'));

    return theme('table', array(), $rows);
  }
  else {
    drupal_not_found();
  }
}