Google Map get distance from latitude and longitude

GeoCalDistanceByLatLon.sql

DELIMITER $$

USE `fashino`$$

DROP FUNCTION IF EXISTS `GeoCalDistanceByLatLon`$$

CREATE DEFINER=`root`@`localhost` FUNCTION `GeoCalDistanceByLatLon`( TYPE ENUM('mi', 'km'), lat1 DECIMAL(10,7), lon1 DECIMAL(10,7), lat2 DECIMAL(10,7), lon2 DECIMAL(10,7) ) RETURNS DECIMAL(10,7)
BEGIN
  RETURN IF(TYPE = 'km', 6371, 3959)*ACOS(SIN(lat1*PI()/180)*SIN(lat2*PI()/180)+COS(lat1*PI()/180)*COS(lat2*PI()/180)*COS((lon2*PI()/180)-(lon1*PI()/180)));
END$$

DELIMITER ;

GeoDistDiff.sql

DELIMITER $$

USE `fashino`$$

DROP FUNCTION IF EXISTS `GeoDistDiff`$$

CREATE DEFINER=`root`@`localhost` FUNCTION `GeoDistDiff`( TYPE ENUM('mi', 'km'), lat1 DECIMAL(10,7), lon1 DECIMAL(10,7), lat2 DECIMAL(10,7), lon2 DECIMAL(10,7) ) RETURNS DECIMAL(10,7)
BEGIN
  RETURN ( IF(TYPE = 'km', 6371, 3959) * ACOS( COS( RADIANS(lat2) ) * COS( RADIANS( lat1 ) ) * COS( RADIANS( lon1 ) - RADIANS(lon2) ) + SIN( RADIANS(lat2) ) * SIN( RADIANS( lat1 ) ) ) );
END$$

DELIMITER ;

GeoDistDiffFunction.php

<?php
namespace CoreBundle\DQL;

use \Doctrine\ORM\Query\AST\Functions\FunctionNode;
use \Doctrine\ORM\Query\Lexer;
use \Doctrine\ORM\Query\SqlWalker;
use \Doctrine\ORM\Query\Parser;

/**
 * Symfony DQL Custom Functions
 * http://www.doctrine-project.org/api/orm/2.5/source-class-Doctrine.ORM.Query.Lexer.html#33
 */
class GeoDistDiffFunction extends FunctionNode
{
    public $type = null;
    public $lat1 = null;
    public $lon1 = null;
    public $lat2 = null;
    public $lon2 = null;

    public $parameters = array();

    public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
    {
        return sprintf(
            'GeoDistDiff(%s, %s, %s, %s, %s)',
            $this->type->dispatch($sqlWalker),
            $this->lat1->dispatch($sqlWalker),
            $this->lon1->dispatch($sqlWalker),
            $this->lat2->dispatch($sqlWalker),
            $this->lon2->dispatch($sqlWalker)
        );
    }

    public function parse(\Doctrine\ORM\Query\Parser $parser)
    {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);

        $this->type = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->lat1 = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->lon1 = $parser->StringPrimary();
        $parser->match(Lexer::T_COMMA);
        $this->lat2 = $parser->SimpleArithmeticExpression();
        $parser->match(Lexer::T_COMMA);
        $this->lon2 = $parser->SimpleArithmeticExpression();

        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

gistfile1.txt

// Use
$query->addSelect("GeoDistDiff(:type, :latitude, :longitude, s.locationLatitude, s.locationLongitude) AS distance")
    ->setParameter('type', 'km')
    ->setParameter('latitude', $latitude)
    ->setParameter('longitude', $longitude);