Nextrek
Diff Revisions
526
vs
533
for /Android/SmartCharging/endPoints/nightly/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 |
|
} |