DistanceDataExtension

Complexity

Total Complexity

2

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	5

Importance

Changes	2
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	augmentSQL()	0	14	2

<?php

class DistanceDataExtension extends DataExtension
{
    /**
     * @param SQLQuery $query
     */
    public function augmentSQL(SQLQuery &$query)
    {
        if (Controller::curr()->getRequest()->getVar('Address')) { // on frontend
            $coords = GoogleGeocoding::address_to_point(Controller::curr()->getRequest()->getVar('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',
                ));
        }
    }
}