CiviCRM Community Forums (archive)

Hello,

   I've been trying to add the "Distance" from target as a field to the list of fields
that i want to display in the search result. Unable to add it so far.

  The distance field would calculate the actual distance of the Contact from the Target Location
and would be displayed as a sortable field in the Search Results.

Any help, pointers are appreciated.

Thanks.

Yashesh Bhatia.

Joe Murray:

  Thanks for the reply. I studied the CRM/Contact/BAO/ProximityQuery.php yesterday and went thru it today too.
What function are you referring to which adds the distance from contact id to the actual target location ?

  After putting breakpoints i noticed the code goes through the function

Nov 30 11:29:58  [info] entering function where() in ProximityQuery.php
Nov 30 11:29:58  [info] $distance = 8046.72

Also, i did put a breakpoint in alterRow

Nov 30 11:29:58  [info] entering function alterRow() in ProximityNJAPM.php
Nov 30 11:29:58  [info] $row = Array
(
    [sort_name] => Foobar
    [street_address] => 111 Foo, Bldg. 1, Suite 111
    [city] => Princeton
    [state_province] => New Jersey
    [postal_code] => 08540
    [country] => United States
    [geo_code_1] => 40.32437
    [geo_code_2] => -74.636905
    [phone] => 111-111-1111
    [email] => foo@bar.com
    [website_url] => http://foobar.com
    [profession] => Foo
    [firm_name] => Foobar
    [title] =>
    [checkbox] => mark_x_1100
    [action] => <span><a href="http://www.foobar.com/civicrm/contact/view?reset=1&amp;cid=1100" class="action-item action-item-first" title="View Contact Details"  >View</a><a href="http://www.foobar.com/civicrm/contact/add?reset=1&amp;action=update&amp;cid=1100" class="action-item" title="Edit Contact Details"  >Edit</a></span>
    [contact_id] => 1100
)

but could not find the actual distance of the Contact to the Target.

Can you please point out the exact function in sites/all/modules/civicrm/CRM/Contact/BAO/ProximityQuery.php

Here's a list of functions i have in my code for the above class

[njapm@bfc33 BAO]$ grep function ProximityQuery.php
     * All function arguments and return values measure distances in metres
    static function initialize( ) {
    static function earthRadius( $latitude ) {
    static function earthXYZ( $longitude, $latitude, $height = 0 ) {
    static function earthArcLength( $angle, $latitude ) {
    static function earthDistance( $longitudeSrc, $latitudeSrc,
    static function earthLongitudeRange( $longitude, $latitude, $distance ) {
    static function earthLatitudeRange( $longitude, $latitude, $distance ) {
    static function earthDistanceSQL( $longitude, $latitude ) {
    static function where( $latitude, $longitude, $distance, $tablePrefix = 'civicrm_address' ) {
      Logger::le_function();
        Logger::ll_function();
    static function process( &$query, &$values ) {
      Logger::le_function();
        Logger::ll_function();


Thanks for your help. Appreciate it.

Yashesh Bhatia

hey yashesh:

as the comments indicate most of that code has been "borrowed" from the drupal location module. You might want to check if there are any bug fixes / improvements to that code

I suspect none of us understand those calculations too much. If you do improve it, please submit your changes back to the core

thanx

lobo

A client of ours - a large foodbank - wanted to be able to sort the Proximity results ranked by the closeness of the result. They wanted to help their clients in finding the closest resource to their home. After some searching I found some information on taking the geo_code and converting them into distances. I adapted it for use in this project.

The links where I had initially found a technique for calculating the distances no longer contain that information, so I wonder now if it is a good technique or not. I do know that through testing, the calculated distances where close to distances on a map. The distances are a point to point distance and do not take into account the actual road/path that the clients would follow to get between their homes and the depot.

The calculation for distance:

ROUND(SQRT(POW((53.5362308-geo_code_1),2)+POW((-113.5762697-geo_code_2),2))*100,1)


In order to use the calculation, copy, modify and override the CRM/Contact/Form/Search/Custom/Proximity.php file:

This will add the distance variable to the search results.


   function __construct( &$formValues ) {
       ...
       $this->_columns = array( ts('Distance')       => 'distance'       ,



   function all( $offset = 0, $rowcount = 0, $sort = null,
                 $includeContactIDs = false ) {
       ...
       $selectClause = "
       ...
ROUND(SQRT(POW((".$this->_latitude."-geo_code_1),2)+POW((".$this->_longitude."-geo_code_2),2))*100,1) AS distance
";



   function where( $includeContactIDs = false ) {
       ...
       $where .= " AND ROUND(SQRT(POW((".$this->_latitude."-geo_code_1),2)+POW((".$this->_longitude."-geo_code_2),2))*100,1) <= ".( $this->_distance / 1000 );


This code calculates the distance between the two points and sets the result.

Apparantly using code tags caused the error "Sorry, you are not allowed to post external links."

(jeff at freeform dot ca)
(Freeform Solutions)