/** * @param Wifi $wifi * @return Wifi */ public function getClosestWifiToWifi(Wifi $wifi) { $coords = Coords::createCoordsRangeByLatLng($wifi->getLatitude(), $wifi->getLongitude(), 0.03); return Wifi::createWifiFromDBRow($this->getNetsRangeQuery($coords)->where("id != ?", $wifi->getId())->where('mac != ?', $wifi->getMac())->order("SQRT(POW(latitude-?,2)+POW(longitude-?,2))", $wifi->getLatitude(), $wifi->getLongitude())->limit(1)->fetch()); }