DistanceDataExtension

Complexity

Total Complexity

3

Size/Duplication

Total Lines	24
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Test Coverage

Coverage

0%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	augmentSQL()	0	18	3

<?php

class DistanceDataExtension extends DataExtension
{
    /**
     * @param SQLQuery $query
     */
    public function augmentSQL(SQLQuery &$query)
    {
        $address = Controller::curr()->getRequest()->getVar('Address');
        if ($this->owner->hasMethod('updateAddressValue')) {
            $address = $this->owner->updateAddressValue($address);
        }
        if ($address) { // on frontend
            $coords = GoogleGeocoding::address_to_point($address);

            $Lat = $coords['lat'];
            $Lng = $coords['lng'];

            $query
                ->addSelect(array(
                    '( 3959 * acos( cos( radians(' . $Lat . ') ) * cos( radians( `Lat` ) ) * cos( radians( `Lng` ) - radians(' . $Lng . ') ) + sin( radians(' . $Lat . ') ) * sin( radians( `Lat` ) ) ) ) AS distance',
                ));
        }
    }
}