/** * 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); }