Changeset 6f39595 for src/mvc/event.cpp

Timestamp:

01/17/10 18:18:22 (13 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

9f473ba

Parents:

c790268

Message:

started work on 'favourities'

• created tavourities tree view in the MainWindow? 'Favourities' tab
• listed some testing 'fav' events
• TODO: list isn't updated dynamically, which means that the list isn't updated if the user adds/removes an event(s) to/from the 'favourities' list

File:

• src/mvc/event.cpp (modified) (1 diff)

src/mvc/event.cpp

@@ -48 +48 @@
 }
 
+QList<Event> Event::getFavByDate(const QDate& date, int conferenceId)
+{
+    QSqlQuery query;
+    query.prepare(selectQueryJoin2T("id") + "WHERE event.xid_conference = :conf AND event.start >= :start AND event.start < :end AND event.favourite = 1 ORDER BY event.start");
+    query.bindValue(":conf", conferenceId);
+    query.bindValue(":start", convertToDb(date, QVariant::DateTime));
+    query.bindValue(":end", convertToDb(date.addDays(1), QVariant::DateTime));
+
+    return load(query);
+}
+