Nextrek

Explore

Commits

Diff Revisions 586 vs 593 for /Android/SmartCharging/endPoints/repositories/LocalRepository.php

		@@ -328,7 +328,7 @@
328	328
329	329		$whereClause = ($tipologia>=0) ? "WHERE tipologia='".$tipologia."'" : "";
330	330
331		-	$harvesinFormulaSQL = "SELECT id, id_utente_owner, lat, lon, indirizzo, tipologia, nomelocale, telefono, email, sito, n_punti_ricarica
	331	+	$harvesinFormulaSQL = "SELECT id, id_utente_owner, lat, lon, indirizzo, tipologia, nomelocale, telefono, email, sito, n_punti_ricarica,
332	332		( 6371 * acos( cos( radians(".$lat.") ) * cos( radians( lat ) ) * cos( radians( lon ) - radians(".$lon.") ) + sin( radians(".$lat.") ) * sin( radians( lat ) ) ) ) AS distance
333	333		FROM locale
334	334		".$whereClause."