Merge pull request #516 from aledeg/stats

Refactor statistics

1 files changed, 20 insertions, 0 deletions

diff --git a/app/Models/StatsDAO.php b/app/Models/StatsDAO.php
index 60cec7847..eafe86407 100644
--- a/app/Models/StatsDAO.php
+++ b/app/Models/StatsDAO.php
@@ -180,6 +180,26 @@ SQL;
 		$stm->execute();
 		return $stm->fetchAll(PDO::FETCH_ASSOC);
 	}
+	
+	/**
+	 * Calculates the last publication date for each feed
+	 * 
+	 * @return array
+	 */
+	public function calculateFeedLastDate() {
+		$sql = <<<SQL
+SELECT MAX(f.name) AS name
+, MAX(date) AS last_date
+FROM {$this->prefix}feed AS f,
+{$this->prefix}entry AS e
+WHERE f.id = e.id_feed
+GROUP BY f.id
+ORDER BY name
+SQL;
+		$stm = $this->bd->prepare($sql);
+		$stm->execute();
+		return $stm->fetchAll(PDO::FETCH_ASSOC);
+	}
 
 	private function convertToSerie($data) {
 		$serie = array();