Nextrek

URLs

Explore

Commits

Diff Revisions 537 vs 579 for /Android/SmartCharging/endPoints/nightly/repositories/LocalRepository.php

		@@ -265,6 +265,47 @@
265	265		}
266	266		}
267	267
	268	+	public function getFullLocalInfo($id_local) {
	269	+	$local = new Local();
	270	+	$queryLocal;
	271	+
	272	+	$sqlLocal = "SELECT l.id as id, u.id_utente_owner as id_utente_owner, u.username as username_owner,
	273	+	l.nomelocale as nomelocale, l.descrizione as descrizione, l.tipologia as tipologia,
	274	+	l.lat as lat, l.lon as lon, l.indirizzo as indirizzo, l.email as email,
	275	+	l.telefono as telefono, l.sito as sito
	276	+	FROM locale l ,utente u
	277	+	WHERE l.id=".$id_local." AND u.id=l.id_utente_owner";
	278	+
	279	+	//echo "<br/>".$sql."<br/>";
	280	+
	281	+	try {
	282	+	$queryLocal = $this->db->query($sqlLocal);
	283	+
	284	+	if (!$queryLocal) return null;
	285	+
	286	+	$rowLocal = $queryLocal->fetch(PDO::FETCH_ASSOC);
	287	+
	288	+	$local->id = $rowLocal["id"];
	289	+	$local->id_utente_owner = $rowLocal["id_utente_owner"];
	290	+	$local->username_owner = $rowLocal["username_owner"];
	291	+	$local->nomelocale = $rowLocal["nomelocale"];
	292	+	$local->descrizione = $rowLocal["descrizione"];
	293	+	$local->tipologia = $rowLocal["tipologia"];
	294	+	$local->lat = $rowLocal["lat"];
	295	+	$local->lon = $rowLocal["lon"];
	296	+	$local->indirizzo = (!is_null($rowLocal["indirizzo"])) ? $rowLocal["indirizzo"] : "";
	297	+	$local->email = $rowLocal["email"];
	298	+	$local->telefono = $rowLocal["telefono"];
	299	+	$local->sito = $rowLocal["sito"];
	300	+
	301	+	return $local;
	302	+
	303	+	} catch (PDOException $e) {
	304	+	echo $e->getMessage();
	305	+	return null;
	306	+	}
	307	+	}
	308	+
268	309		public function deleteImage($id_local, $img) {
269	310		$sql = "DELETE FROM immagini_locali WHERE id_locale=".$id_local." AND img='".$img."'";
270	311		try {

View View this file contents

History View the full history

Feeds

Commits for /Android/SmartCharging/endPoints/nightly/repositories/LocalRepository.php