Changeset 6f39595 for src/mvc

Timestamp:

01/17/10 18:18:22 (12 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

Location:

src/mvc

Files:

• event.cpp (modified) (1 diff)
• event.h (modified) (2 diffs)
• eventmodel.cpp (modified) (1 diff)
• eventmodel.h (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);
+}
+

src/mvc/event.h

@@ -28 +28 @@
     static Event getById(int id, int conferenceId);
     static QList<Event> getByDate(const QDate& date, int conferenceId);
+    static QList<Event> getFavByDate(const QDate& date, int conferenceId); // get Favourities by Date
 
 public:
@@ -54 +55 @@
     void setType(const QString& type) { setValue("type", type); }
     void setLanguage(const QString& language) { setValue("language", language); }
-    void setFavourite(bool favourite) { setValue("favourite", favourite); }
+    void setFavourite(bool favourite) { setValue("favourite", (int)favourite); }
     // Table 2 : virtual table for FTS (Full Text Search)
     void setTag(const QString& tag) { setValue("tag", tag); }

src/mvc/eventmodel.cpp

@@ -131 +131 @@
 }
 
+void EventModel::loadFavEvents(const QDate &aDate, int aConferenceId)
+{
+    mEvents.clear();
+
+    // check for existence of the conference in the DB
+    if(Conference::getAll().count())
+    {
+        qDebug() << "Loading FAV Conference Data: [" << Conference::getById(aConferenceId).title() << "] " << aDate;
+        mEvents = Event::getFavByDate(QDate(aDate.year(), aDate.month(), aDate.day()), aConferenceId);
+    }
+    createTimeGroups();
+}
+

src/mvc/eventmodel.h

@@ -16 +16 @@
     int rowCount ( const QModelIndex & parent = QModelIndex() ) const;
     void loadEvents(const QDate &aDate, int aConferenceId); // loads Events from the DB
+    void loadFavEvents(const QDate &aDate, int aConferenceId); // loads Favourite events from the DB
 
 private: