+global\DistanceDataExtension::augmentSQL()

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    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',
                ));
        }
    }
}