CiviCRM Community Forums (archive)

Hi

I've been trying to work out how you can restrict the Google Maps lookup so only the Post Code / Country is sent.

The static function used is listed below but whatever changes I make it still seems to send all address fields.
Any help would be really appreciated, Oliver


    static function &getMapInfo( $ids, $locationTypeID = null )
    {
        $idString = ' ( ' . implode( ',', $ids ) . ' ) ';
        $sql = "
   SELECT civicrm_contact.id as contact_id,
          civicrm_contact.contact_type as contact_type,
          civicrm_contact.display_name as display_name,
          civicrm_address.street_address as street_address,
          civicrm_address.supplemental_address_1 as supplemental_address_1,
          civicrm_address.supplemental_address_2 as supplemental_address_2,
          civicrm_address.city as city,
          civicrm_address.postal_code as postal_code,
          civicrm_address.postal_code_suffix as postal_code_suffix,
          civicrm_address.geo_code_1 as latitude,
          civicrm_address.geo_code_2 as longitude,
          civicrm_state_province.abbreviation as state,
          civicrm_country.name as country,
          civicrm_location_type.name as location_type
     FROM civicrm_contact
LEFT JOIN civicrm_address ON civicrm_address.contact_id = civicrm_contact.id
LEFT JOIN civicrm_state_province ON civicrm_address.state_province_id = civicrm_state_province.id
LEFT JOIN civicrm_country ON civicrm_address.country_id = civicrm_country.id
LEFT JOIN civicrm_location_type ON civicrm_location_type.id = civicrm_address.location_type_id
WHERE civicrm_address.geo_code_1 IS NOT NULL
AND civicrm_address.geo_code_2 IS NOT NULL
AND civicrm_contact.id IN $idString ";

        $params = array( );
        if (!$locationTypeID) {
            $sql .= " AND civicrm_address.is_primary = 1";
        } else {
            $sql .= " AND civicrm_address.location_type_id = %1";
            $params[1] = array( $locationTypeID, 'Integer' );
        }

        $dao =& CRM_Core_DAO::executeQuery( $sql, $params );

        $locations = array( );
        $config = CRM_Core_Config::singleton( );

        while ( $dao->fetch( ) ) {
            $location = array( );
            $location['contactID'   ] = $dao->contact_id;
            $location['displayName' ] = addslashes( $dao->display_name );
            $location['city'        ] = $dao->city;
            $location['state'       ] = $dao->state;
            $location['postal_code' ] = $dao->postal_code;
            $location['lat'         ] = $dao->latitude;
            $location['lng'         ] = $dao->longitude;
            $location['marker_class'] = $dao->contact_type;
            $address = '';
           
            CRM_Utils_String::append( $address, '<br />',
                                      array( $dao->street_address,
                                             $dao->supplemental_address_1,
                                             $dao->supplemental_address_2,
                                             $dao->city ) );
            CRM_Utils_String::append( $address, ', ',
                                      array(   $dao->state, $dao->postal_code ) );
            CRM_Utils_String::append( $address, '<br /> ',
                                      array( $dao->country ) );
            $location['address'       ] = addslashes( $address );
            $location['displayAddress'] = str_replace( '<br />', ', ', $address );
            $location['url'           ] = CRM_Utils_System::url( 'civicrm/contact/view', 'reset=1&cid=' . $dao->contact_id );
            $location['location_type' ] = $dao->location_type;
            require_once 'CRM/Contact/BAO/Contact/Utils.php';
            $location['image'] =
                CRM_Contact_BAO_Contact_Utils::getImage( isset( $dao->contact_sub_type ) ?
                                                         $dao->contact_sub_type : $dao->contact_type,false,$dao->contact_id );
            $locations[] = $location;
        }
        return $locations;
    }   
}

Hi Rajan

I tried the fix (and it is something I'd tried myself) but when you save a contact it still seems to send all the standard data to Google maps for geo coding. i.e. When I edit a contact and change the city this is picked up in the geo data.
Am I missing something? Have I got the correct function?

I'm not sure this should be built into the system admin as this is a specific case; the contacts are UK Churches who have very poor addresses and I know only the Post Code data is accurate.

Thanks for your help with this
Oliver

Hi Rajan

That works perfectly!
Thank you for your help

Oliver