Nextrek

Explore

Commits

Diff Revisions 607 vs 612 for /Android/SmartCharging/endPoints/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