location.views.inc in Location 7.3

Views 3 support for Location.

File

location.views.inc

<?php

/**
 * @file
 * Views 3 support for Location.
 */

/**
 * @TODO:
 * Finish porting!
 * Write "relationships" -- see book.views.inc, upload.views.inc, nodequeue...
 */

/**
 * Implementation of hook_views_data().
 */
function location_views_data() {

  // Location table -- basic table information.
  // Define the base group of this table. Fields that don't
  // have a group defined will go into this field by default.
  $data['location']['table']['group'] = t('Location', array(), array(
    'context' => 'geolocation',
  ));

  // Advertise this table as a possible base table.
  $data['location']['table']['base'] = array(
    'field' => 'lid',
    'title' => t('Location', array(), array(
      'context' => 'geolocation',
    )),
    'help' => t('Locations are addresses and map coordinates.'),
    'weight' => -10,
  );
  $data['location']['table']['join'] = array(
    // Location links to node through location_instance via lid.
    'node' => array(
      'left_table' => 'location_instance',
      'left_field' => 'lid',
      'field' => 'lid',
    ),
    // Location links to node_revision through location_instance via lid.
    'node_revision' => array(
      'left_table' => 'location_instance',
      'left_field' => 'lid',
      'field' => 'lid',
    ),
    // Location links to taxonomy_term_data through location_instance via lid.
    'taxonomy_term_data' => array(
      'left_table' => 'location_instance',
      'left_field' => 'lid',
      'field' => 'lid',
    ),
    // Location links to users through location_instance via lid.
    'users' => array(
      'left_table' => 'location_instance',
      'left_field' => 'lid',
      'field' => 'lid',
    ),
  );

  // Location table -- fields.
  $data['location']['lid'] = array(
    'title' => t('Lid'),
    // The help that appears on the UI.
    'help' => t('The location ID of the location.'),
    // Information for displaying the lid.
    'field' => array(
      'handler' => 'views_handler_field',
      'click sortable' => TRUE,
    ),
    // Information for accepting a lid as an argument

    /*
    'argument' => array(
      'handler' => 'views_handler_argument_node_nid',
      'name field' => 'title', // the field to display in the summary.
      'numeric' => TRUE,
      'validate type' => 'nid',
    ),
    */

    // Information for accepting a lid as a filter.
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
      'allow empty' => TRUE,
    ),
    // Information for sorting on a lid.
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['name'] = array(
    'title' => t('Name'),
    'help' => t('The name of the selected location.'),
    'field' => array(
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

  // @@@ 1.x Conversion -- 'additional' => 'street', style 'additional'
  $data['location']['street'] = array(
    'title' => t('Street'),
    'help' => t('The street address of the selected location.'),
    'field' => array(
      'handler' => 'location_handler_field_location_street',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['additional'] = array(
    'title' => t('Additional'),
    'help' => t('Additional street address of the selected location.'),
    'field' => array(
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['city'] = array(
    'title' => t('City'),
    'help' => t('The city of the selected location.'),
    'field' => array(
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'views_handler_argument_string',
      'empty field name' => t('Unknown'),
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

  // @@@ 1.x Conversion -- 'province' => 'province', style 'name'; 'province_code' => 'province', style 'code'
  $data['location']['province'] = array(
    'title' => t('Province'),
    'help' => t('The province of the selected location.'),
    'field' => array(
      'handler' => 'location_handler_field_location_province',
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'location_handler_argument_location_province',
    ),
    'filter' => array(
      'handler' => 'location_handler_filter_location_province',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['postal_code'] = array(
    'title' => t('Postal Code'),
    'help' => t('The postal code of the selected location.'),
    'field' => array(
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

  // @@@ 1.x Conversion -- 'country' => 'country', style 'name'; 'country_code' => 'country', style 'code'.
  $data['location']['country'] = array(
    'title' => t('Country'),
    'help' => t('The country of the selected location.'),
    'field' => array(
      'handler' => 'location_handler_field_location_country',
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'location_handler_argument_location_country',
    ),
    'filter' => array(
      'handler' => 'location_handler_filter_location_country',
    ),
    'sort' => array(
      'handler' => 'location_handler_sort_location_country',
    ),
  );
  $data['location']['latitude'] = array(
    'title' => t('Latitude'),
    'help' => t('The latitude of the selected location.'),
    'field' => array(
      'handler' => 'location_views_handler_field_latitude',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['longitude'] = array(
    'title' => t('Longitude'),
    'help' => t('The longitude of the selected location.'),
    'field' => array(
      'handler' => 'location_views_handler_field_longitude',
      'click sortable' => TRUE,
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_numeric',
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );
  $data['location']['coordinates'] = array(
    'title' => t('Coordinates'),
    'help' => t("The coordinates of the selected location in 'lat, long' format."),
    'field' => array(
      // The handler adds the longitude.
      'field' => 'latitude',
      'handler' => 'location_views_handler_field_coordinates',
      'click sortable' => FALSE,
    ),
  );
  $data['location']['distance'] = array(
    'title' => t('Distance / Proximity'),
    'help' => t("The distance from the selected location and either the current user or a specific location."),
    'field' => array(
      'handler' => 'location_handler_field_location_distance',
      'click sortable' => TRUE,
    ),
    'sort' => array(
      'handler' => 'location_handler_sort_location_distance',
    ),
    'argument' => array(
      'handler' => 'location_handler_argument_location_proximity',
    ),
    'filter' => array(
      'handler' => 'location_views_handler_filter_proximity',
    ),
  );
  $data['location']['address'] = array(
    'title' => t('Address'),
    'help' => t('The entire address block for the location.'),
    'field' => array(
      'field' => 'lid',
      'handler' => 'location_handler_field_location_address',
      'element type' => 'div',
    ),
  );
  $data['location_instance']['table']['group'] = t('Location', array(), array(
    'context' => 'geolocation',
  ));
  $data['location_instance']['table']['join'] = array(
    'location' => array(
      'left_field' => 'lid',
      'field' => 'lid',
    ),
    'users' => array(
      'left_field' => 'uid',
      'field' => 'uid',
    ),
    'node' => array(
      'left_field' => 'vid',
      'field' => 'vid',
    ),
    'node_revision' => array(
      'left_field' => 'vid',
      'field' => 'vid',
    ),
    'taxonomy_term_data' => array(
      'left_field' => 'tid',
      'field' => 'vid',
    ),
  );

  // Tell the base tables about us.
  $data['node']['table']['join']['location'] = array(
    'left_table' => 'location_instance',
    'left_field' => 'vid',
    'field' => 'vid',
  );
  $data['node_revision']['table']['join']['location'] = array(
    'left_table' => 'location_instance',
    'left_field' => 'vid',
    'field' => 'vid',
  );
  $data['taxonomy_term_data']['table']['join']['location'] = array(
    'left_table' => 'location_instance',
    'left_field' => 'vid',
    'field' => 'tid',
  );
  $data['users']['table']['join']['location'] = array(
    'left_table' => 'location_instance',
    'left_field' => 'uid',
    'field' => 'uid',
  );
  return $data;
}

/**
 * Helper function for proximity handlers.
 *
 * Gets a list of available node location and cck location fields.
 *
 * @return array
 *   An array of the location field options.
 */
function location_views_proximity_get_location_field_options() {

  // Get the CCK location field options.
  $field_options = array(
    'node' => t('Node location'),
  );
  if (module_exists('location_cck')) {
    $fields = field_info_fields();
    foreach ($fields as $field) {
      if ($field['module'] == 'location_cck') {
        $field_options[$field['field_name']] = t('CCK Location: @name', array(
          '@name' => $field['field_name'],
        ));
      }
    }
  }
  return $field_options;
}

/**
 * Helper function for proximity handlers.
 *
 * Gets available arguments for argument related handler options.
 *
 * @param object $view
 *   The view object.
 *
 * @return array
 *   An array containing arrays of the nid arguments and the uid arguments.
 */
function location_views_proximity_get_argument_options($view) {

  // Get the arguments for this view so we can use nid, uid or Global: Null arguments.
  $uid_argument_options = array();
  $nid_argument_options = array();
  $arguments = $view->display_handler
    ->get_handlers('argument');
  foreach ($arguments as $id => $handler) {
    if ($handler->field == 'null') {
      $uid_argument_options[$id] = $handler
        ->ui_name();
      $nid_argument_options[$id] = $handler
        ->ui_name();
    }
    else {
      if ($handler->field == 'nid') {
        $nid_argument_options[$id] = $handler
          ->ui_name();
      }
      else {
        if ($handler->field == 'uid') {
          $uid_argument_options[$id] = $handler
            ->ui_name();
        }
      }
    }
  }
  return array(
    $nid_argument_options,
    $uid_argument_options,
  );
}

/**
 * Helper function for proximity handlers.
 *
 * Retrieves the coordinates of the location that this field measures distances against.
 *
 * @param object $view
 *   The view object.
 *
 * @param array $options
 *   An array of the options (or values in the case of the filter) of the handler.
 *
 * @return array
 *   An array with keys 'latitude' and 'longitude' or an empty array.
 */
function location_views_proximity_get_reference_location($view, $options) {
  $coordinates = array();
  switch ($options['origin']) {
    case 'user':
    case 'hybrid':
      global $user;
      $user_locations = isset($user->locations) ? $user->locations : location_load_locations($user->uid, 'uid');

      // This user_location_delta will only possibly be set if we are dealing with the filter.
      $i = isset($options['user_location_delta']) && !empty($options['user_location_delta']) ? $options['user_location_delta'] : 0;
      if (isset($user_locations[$i]['latitude']) || !empty($user_locations[$i]['latitude'])) {
        $coordinates['latitude'] = (double) $user_locations[$i]['latitude'];
        $coordinates['longitude'] = (double) $user_locations[$i]['longitude'];
      }
      else {
        if ($options['origin'] == 'hybrid') {
          $coordinates['latitude'] = (double) $options['latitude'];
          $coordinates['longitude'] = (double) $options['longitude'];
        }
      }
      break;
    case 'static':
    case 'latlon_gmap':

      // Validate actual values.
      if (!empty($options['latitude']) && !empty($options['longitude'])) {
        $coordinates['latitude'] = (double) $options['latitude'];
        $coordinates['longitude'] = (double) $options['longitude'];
      }
      break;
    case 'tied':
      if (!empty($view->filter)) {
        foreach ($view->filter as $filter) {
          if ($filter->table == 'location' && $filter->field == 'distance' && $filter->options['relationship'] == $options['relationship']) {
            $filter_options = array_merge($filter->options, $filter->options['value'], $filter->value);
            if ($coords = location_views_proximity_get_reference_location($view, $filter_options)) {
              $coordinates['latitude'] = (double) $coords['latitude'];
              $coordinates['longitude'] = (double) $coords['longitude'];
            }
          }
        }
      }

      // If at this stage we don't have coordinates then check for a distance contextual filter.
      if (!count($coordinates) && !empty($view->argument) && !empty($view->argument->value['latitude']) && !empty($view->argument->value['longitude'])) {
        foreach ($view->argument as $argument) {
          if ($argument->table == 'location' && $argument->field == 'distance') {
            $coordinates['latitude'] = (double) $argument->value['latitude'];
            $coordinates['longitude'] = (double) $argument->value['longitude'];
          }
        }
      }
      break;
    case 'postal':
    case 'postal_default':

      // Force default for country.
      if ($options['origin'] == 'postal_default') {
        $options['country'] = variable_get('location_default_country', 'us');
      }

      // Zip code lookup.
      if (!empty($options['postal_code']) && !empty($options['country'])) {
        $coords = location_latlon_rough($options);
        if ($coords) {
          $coordinates['latitude'] = (double) $coords['lat'];
          $coordinates['longitude'] = (double) $coords['lon'];
        }
      }
      break;
    case 'php':
      ob_start();
      $result = eval($options['php_code']);
      ob_end_clean();
      if ($result && $result['latitude'] && $result['longitude']) {
        $coordinates['latitude'] = (double) $result['latitude'];
        $coordinates['longitude'] = (double) $result['longitude'];
      }
      break;
    case 'nid_arg':
      if ($nodehandler = $view->display_handler
        ->get_handler('argument', $options['nid_arg'])) {
        $nid = $nodehandler
          ->get_value(NULL);
        if ($nid && is_numeric($nid) && ($tempnode = node_load($nid))) {
          $field_name = $options['nid_loc_field'];
          if ($field_name == 'node') {
            $coordinates['latitude'] = (double) $tempnode->location['latitude'];
            $coordinates['longitude'] = (double) $tempnode->location['longitude'];
          }
          else {
            if (isset($tempnode->{$field_name})) {
              $cck_location = $tempnode->{$field_name};
              if (isset($cck_location[LANGUAGE_NONE][0]['longitude']) && isset($cck_location[LANGUAGE_NONE][0]['latitude'])) {
                $coordinates['latitude'] = (double) $cck_location[LANGUAGE_NONE][0]['latitude'];
                $coordinates['longitude'] = (double) $cck_location[LANGUAGE_NONE][0]['longitude'];
              }
              else {
                if (isset($cck_location[0]['longitude']) && isset($cck_location[0]['latitude'])) {
                  $coordinates['latitude'] = (double) $cck_location[0]['latitude'];
                  $coordinates['longitude'] = (double) $cck_location[0]['longitude'];
                }
              }
            }
          }
        }
      }
      break;
    case 'uid_arg':
      if ($userhandler = $view->display_handler
        ->get_handler('argument', $options['uid_arg'])) {
        $uid = $userhandler
          ->get_value();
        if ($uid && is_numeric($uid) && ($tempuser = user_load($uid))) {
          $coordinates['latitude'] = (double) $tempuser->location['latitude'];
          $coordinates['longitude'] = (double) $tempuser->location['longitude'];
        }
      }
      break;
    case 'distance_arg':
      foreach ($view->argument as $argument) {
        if ($argument->field == 'distance') {
          list($coords, $search_distance) = explode('_', $view->args[$argument->position]);
          list($lat, $lon) = explode(',', $coords);
          break;
        }
      }
      $coordinates['latitude'] = (double) $lat;
      $coordinates['longitude'] = (double) $lon;
      break;
    case 'geoip':
      $coordinates['latitude'] = (double) $options['latitude'];
      $coordinates['longitude'] = (double) $options['longitude'];
      if (module_exists('smart_ip')) {
        $smart_ip_session = smart_ip_session_get('smart_ip');
        if (isset($smart_ip_session['location']['latitude']) && isset($smart_ip_session['location']['longitude'])) {
          $coordinates['latitude'] = (double) $smart_ip_session['location']['latitude'];
          $coordinates['longitude'] = (double) $smart_ip_session['location']['longitude'];
        }
      }
      elseif (module_exists('geoip')) {

        // Intentional assignment of $geoip.
        if ($geoip_location = geoip_city()) {
          $coordinates['latitude'] = $geoip_location->latitude;
          $coordinates['longitude'] = $geoip_location->longitude;
        }
      }
      break;
  }
  return $coordinates;
}

Functions

Name	Description
location_views_data	Implementation of hook_views_data().
location_views_proximity_get_argument_options	Helper function for proximity handlers.
location_views_proximity_get_location_field_options	Helper function for proximity handlers.
location_views_proximity_get_reference_location	Helper function for proximity handlers.