Subversion Repository Public Repository

Nextrek

Diff Revisions 585 vs 586 for /Android/SmartCharging/endPoints/nightly/get_list_locali.php

Diff revisions: vs.
  @@ -4,42 +4,43 @@
4 4
5 5 require_once("constants.php");
6 6
7 - require_once("repositories/LocalRepository.php");
7 + require_once("repositories/LocalRepository.php");
8 8
9 - /*$servername = "localhost";
10 - $username = "smartcharging";
11 - $password = "LXRLBaEAuRr7M7jY";*/
9 + /*$servername = "localhost";
10 + $username = "smartcharging";
11 + $password = "LXRLBaEAuRr7M7jY";*/
12 12
13 - //$params = json_decode($_REQUEST["params"], true);
13 + //$params = json_decode($_REQUEST["params"], true);
14 14
15 15 //$input = file_get_contents('php://input');
16 16 $params = json_decode(file_get_contents('php://input'), true);
17 17
18 - $conn;
19 - $risposta = array();
20 - $local_repo;
18 + $conn;
19 + $risposta = array();
20 + $local_repo;
21 21 $local_list;
22 22
23 - try {
24 - $conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
25 - $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
26 - //echo "Connesso con successo al DB";
27 -
28 - $local_repo = new LocalRepository($conn);
29 -
30 - $local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]);
31 -
32 - $risposta["locals"] = $local_list;
33 -
23 + try {
24 + $conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
25 + $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
26 + //echo "Connesso con successo al DB";
27 +
28 + if (!array_key_exists("lat", $params) || !array_key_exists("lon", $params)) {
29 + $risposta["locals"] = array();
30 + } else {
31 + $local_repo = new LocalRepository($conn);
32 + $local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]);
33 + $risposta["locals"] = $local_list;
34 + }
34 35 }
35 - catch(PDOException $e)
36 + catch(PDOException $e)
36 37 {
37 - echo $e->getMessage();
38 + echo $e->getMessage();
38 39 $risposta = createErrorMessage(1, "Errore DB");
39 - //$risposta["locals"] = null;
40 + //$risposta["locals"] = null;
40 41 }
41 42
42 43 echo json_encode($risposta);
43 - $conn = null; //Close the connection to the DBMS
44 + $conn = null; //Close the connection to the DBMS
44 45
45 46 ?>