Nextrek
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 { |