Nextrek

Explore

Commits

Diff Revisions 728 vs 729 for /Android/SmartCharging/endPoints/nightly/repositories/TipologiaRepository.php

		@@ -97,6 +97,46 @@
97	97		}
98	98		}
99	99
	100	+	public function getTipologiaList() {
	101	+	$status = array();
	102	+
	103	+	$queryTipologia = "SELECT id,tipologia FROM tipologie";
	104	+
	105	+	$tipologie = array();
	106	+
	107	+	try {
	108	+	$stmt = $this->db->prepare($queryTipologia);
	109	+	$query = $stmt->execute();
	110	+
	111	+	if (!$query \|\| $stmt->rowCount()==0) {
	112	+	$status = createErrorMessage(1, "Errore DB");
	113	+	$status["tipologie"] = null;
	114	+	return $status;
	115	+	}
	116	+
	117	+	$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
	118	+
	119	+	foreach ($rows as $row) {
	120	+	$tipologia = new Tipologia();
	121	+
	122	+	$tipologia->id = $row["id"];
	123	+	$tipologia->tipologia = $row["tipologia"];
	124	+
	125	+	array_push($tipologie, $tipologia);
	126	+	}
	127	+
	128	+	$status["return"] = 0;
	129	+	$status["tipologie"] = $tipologie;
	130	+	return $status;
	131	+
	132	+	} catch (PDOException $e) {
	133	+	echo $e->getMessage();
	134	+	$status = createErrorMessage(1, "Errore DB");
	135	+	$status["tipologie"] = null;
	136	+	return $status;
	137	+	}
	138	+	}
	139	+
100	140		}
101	141
102	142		?>