Distance / Proximity from cck location field ? not from user or node location?

Question

I try to get a distance between cck location nodes / users but I didn't succeed at that point because the only avalaible views field to do that is "EMPLACEMENT : DISTANCE / PROXIMITY" which concerns node location or user location, not cck location field.

How to get that point ?

Regards, Yoann

Answer 1

Results may vary based upon your drupal version, but basically when you create a proximity filter:

the first option is "Node location" but when you click on that:

it will allow you to use a Location CCK field as well.

Answer 2

Here is the code I used in the "php code for latitue, longitude" origin section in the "Emplacement: Distance / Proximity field" views :

global $user;
global $databases;
$res = db_set_active('default');
$query1 = db_query("SELECT field_lien_adresse_utilisateur_target_id FROM
{field_data_field_lien_adresse_utilisateur} WHERE entity_id = :uid", array('uid' => $user->uid));
$results1 = $query1->fetchAll();
$query2 = db_query("SELECT field_adresse_utilisateur_lid FROM
{field_data_field_adresse_utilisateur} WHERE entity_id = :entity_id", array('entity_id' => $results1[0]->field_lien_adresse_utilisateur_target_id));
$results2 = $query2->fetchAll();
$query3 = db_query("SELECT latitude, longitude FROM {location} WHERE lid = :lid",
array('lid' => $results2[0]->field_adresse_utilisateur_lid));
$results3 = $query3->fetchAll();
$result['latitude'] = (float) $results3[0]->latitude;
$result['longitude'] = (float) $results3[0]->longitude;
return $result;

Then I got the latitude and longitude of the current user.

Hope it's useful.