Huge website update.

[people/shoehn/ipfire.org.git] / www / webapp / backend / news.py

diff --git a/www/webapp/backend/news.py b/www/webapp/backend/news.py
index 75b3d934e93ad57abfc0cadc2b6ae93e58e59f38..eddd036c016a1bb609d4ca9c715c931d65552144 100644 (file)
--- a/www/webapp/backend/news.py
+++ b/www/webapp/backend/news.py
@@ -41,6 +41,29 @@ class News(object):
 
                return news
 
+       def get_by_year(self, year, locale=None):
+               query = "SELECT * FROM news WHERE published = 'Y' AND YEAR(date) = %s"
+               args  = [year,]
+
+               if locale:
+                       query += " AND lang = %s"
+                       args.append(locale.code[:2])
+
+               query += " ORDER BY date DESC"
+
+               return self.db.query(query, *args)
+
+       @property
+       def years(self):
+               years = []
+
+               for row in self.db.query("SELECT DISTINCT YEAR(date) AS year FROM news \
+                               WHERE published = 'Y' ORDER BY year DESC"):
+                       years.append(row.year)
+
+               return years
+
+
 if __name__ == "__main__":
        n = News()