/**
* GeocoderBehaviorTest::testDistanceField()
*
* @return void
*/
public function testDistanceField()
{
$condition = $this->Addresses->distanceField(12, 14);
//$expected = '6371.04 * ACOS(COS(PI()/2 - RADIANS(90 - Addresses.lat)) * COS(PI()/2 - RADIANS(90 - 12)) * COS(RADIANS(Addresses.lng) - RADIANS(14)) + SIN(PI()/2 - RADIANS(90 - Addresses.lat)) * SIN(PI()/2 - RADIANS(90 - 12))) AS Addresses.distance';
$this->assertInstanceOf('\\Cake\\Database\\Expression\\QueryExpression', $condition['Addresses.distance']);
}
/**
* GeocoderBehaviorTest::testDistanceField()
*
* @return void
*/
public function testDistanceField()
{
$res = $this->Addresses->distanceField(12, 14);
$expected = '6371.04 * ACOS(COS(PI()/2 - RADIANS(90 - Addresses.lat)) * COS(PI()/2 - RADIANS(90 - 12)) * COS(RADIANS(Addresses.lng) - RADIANS(14)) + SIN(PI()/2 - RADIANS(90 - Addresses.lat)) * SIN(PI()/2 - RADIANS(90 - 12))) AS Addresses.distance';
$this->assertEquals($expected, $res);
}
