我必须从具有纬度/经度值的表中获取所有数据。实际上,我只需要距离源1000英里以内的所有纬度/经度值,因此为此我使用了概念,并且它正确地计算了纬度/经度,但是当我创建一个查找查询来获取具有table.latitudes <=纬度北和表.纬度>=南纬的数据时
经度也是如此。
我已经制作了这些计算代码并查找查询
$lat1 = $coodSearch['lat'];
$lon1 = $coodSearch['long'];
$d = $coodSearch['dis'];
$r = 3959;//earth's radius in miles
//compute max and min latitudes / longitudes for search square
$latN = rad2deg(asin(sin(deg2rad($lat1)) * cos($d / $r) + cos(deg2rad($lat1)) * sin($d / $r) * cos(deg2rad(0))));
$latS = rad2deg(asin(sin(deg2rad($lat1)) * cos($d / $r) + cos(deg2rad($lat1)) * sin($d / $r) * cos(deg2rad(180))));
$lonE = rad2deg(deg2rad($lon1) + atan2(sin(deg2rad(90)) * sin($d / $r) * cos(deg2rad($lat1)), cos($d / $r) - sin(deg2rad($lat1)) * sin(deg2rad($latN))));
$lonW = rad2deg(deg2rad($lon1) + atan2(sin(deg2rad(270)) * sin($d / $r) * cos(deg2rad($lat1)), cos($d / $r) - sin(deg2rad($lat1)) * sin(deg2rad($latN))));
$this->loadModel('City');
$finder1 = array( 'and' => array('City.latitude <=' => $latN,'City.latitude >=' => $latS ));
$latArr = $this->City->find('all', array('conditions' => $finder1));
$finder2 = array( 'and' => array('City.longitude >=' => $lonE,'City.longitude <=' => $lonW ));
$longArr = $this->City->find('all', array('conditions' => $finder2));
我已经检查了计算值($latN,$lonE(它的给出结果,但发现所有查询都不起作用。
请帮助我哪里出错了。
这可能会解决问题
$data = $this->ModelName->find('all', array('conditions' => array('ModelName.DbColumn >=' => 10)));
$data = $this->ModelName->find('all', array('conditions' => array('ModelName.DbColumn <=' => 10)));
$data = $this->ModelName->find('all', array('conditions' => array('ModelName.DbColumn >=' => 10,'ModelName.DbColumn <=' => 20)));