Nextrek

Explore

Commits

Diff Revisions 527 vs 528 for /Android/SmartCharging/endPoints/repositories/LocalRepository.php

		@@ -275,7 +275,7 @@
275	275
276	276		$whereClause = ($tipologia>=0) ? "WHERE tipologia='".$tipologia."'" : "";
277	277
278		-	$harvesinFormulaSQL = "SELECT id, lat, lon, indirizzo, tipologia, nomelocale, telefono, email, sito,
	278	+	$harvesinFormulaSQL = "SELECT id, id_utente_owner, lat, lon, indirizzo, tipologia, nomelocale, telefono, email, sito,
279	279		( 6371 * acos( cos( radians(".$lat.") ) * cos( radians( lat ) ) * cos( radians( lon ) - radians(".$lon.") ) + sin( radians(".$lat.") ) * sin( radians( lat ) ) ) ) AS distance
280	280		FROM locale
281	281		".$whereClause."
		@@ -294,15 +294,16 @@
294	294
295	295		foreach ($rows as $row) {
296	296		$local = array();
297		-	$local["id"] = $row["id"];
298		-	$local["lat"] = $row["lat"];
299		-	$local["lon"] = $row["lon"];
300		-	$local["indirizzo"] = $row["indirizzo"];
301		-	$local["tipologia"] = $row["tipologia"];
302		-	$local["nomelocale"] = $row["nomelocale"];
303		-	$local["telefono"] = $row["telefono"];
304		-	$local["email"] = $row["email"];
305		-	$local["sito"] = $row["sito"];
	297	+	$local["id"] = $row["id"];
	298	+	$local["id_utente_owner"] = $row["id_utente_owner"];
	299	+	$local["lat"] = $row["lat"];
	300	+	$local["lon"] = $row["lon"];
	301	+	$local["indirizzo"] = $row["indirizzo"];
	302	+	$local["tipologia"] = $row["tipologia"];
	303	+	$local["nomelocale"] = $row["nomelocale"];
	304	+	$local["telefono"] = $row["telefono"];
	305	+	$local["email"] = $row["email"];
	306	+	$local["sito"] = $row["sito"];
306	307
307	308		array_push($local_list, $local);
308	309		}