Nextrek
Diff Revisions
607
vs
612
for /Android/SmartCharging/endPoints/nightly/repositories/LocalRepository.php
|
@@ -339,10 +339,10 @@ |
339 |
339 |
|
|
340 |
340 |
|
$harvesinFormulaSQL; |
341 |
341 |
|
|
342 |
|
- |
$whereClause = ($tipologia>=0) ? "WHERE tipologia='".$tipologia."'" : ""; |
|
342 |
+ |
$whereClause = ($tipologia>=0) ? "WHERE tipologia='".$tipologia."' AND hidden=0" : "WHERE hidden=0"; |
343 |
343 |
|
|
344 |
344 |
|
if ($lat==="" || $lon==="") { |
345 |
|
- |
$harvesinFormulaSQL = "SELECT * FROM locale"; |
|
345 |
+ |
$harvesinFormulaSQL = "SELECT * FROM locale WHERE hidden=0"; |
346 |
346 |
|
} else { |
347 |
347 |
|
$harvesinFormulaSQL = "SELECT id, id_utente_owner, lat, lon, indirizzo, tipologia, nomelocale, telefono, email, sito, n_punti_ricarica, |
348 |
348 |
|
( 6371 * acos( cos( radians(".$lat.") ) * cos( radians( lat ) ) * cos( radians( lon ) - radians(".$lon.") ) + sin( radians(".$lat.") ) * sin( radians( lat ) ) ) ) AS distance |