Changeset e662750 for src/mvc

Timestamp:

01/21/10 10:49:41 (13 years ago)

Author:

timkoma <timkoma@…>

Branches:

master, qt5

Children:

72cd3af

Parents:

842f5f9

Message:

first working version of the search

Location:

src/mvc

Files:

• event.cpp (modified) (1 diff)
• event.h (modified) (1 diff)
• eventmodel.cpp (modified) (1 diff)
• eventmodel.h (modified) (1 diff)

src/mvc/event.cpp

@@ -114 +114 @@
 }
 
+QList<Event> Event::getSearchResultByDate(const QDate& date, int conferenceId, QString orderBy)
+{
+
+    QString strQuery = QString("SELECT %1 FROM EVENT INNER JOIN VIRTUAL_EVENT USING (xid_conference, id) "
+        "INNER JOIN SEARCH_EVENT USING (xid_conference, id) ").arg( columnsForSelectJoin2T() );
+    strQuery += QString(
+        "WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end ORDER BY %1.%2").arg(sTable1Name, orderBy);
+    qDebug() << strQuery;
+    QSqlQuery query;
+    query.prepare( strQuery );
+    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 QList<Event> getByDate(const QDate & date, int conferenceId, QString orderBy);
     static QList<Event> getFavByDate(const QDate & date, int conferenceId); // get Favourities by Date
+    static QList<Event> getSearchResultByDate(const QDate& date, int conferenceId, QString orderBy);
 public:
     // Table 1

src/mvc/eventmodel.cpp

@@ -183 +183 @@
 }
 
+void EventModel::loadSearchResultEvents(const QDate &aDate, int aConferenceId)
+{
+    clearModel();
+    // check for existence of the conference in the DB
+    if(Conference::getAll().count())
+    {
+        qDebug() << "Loading search result Data: [" << Conference::getById(aConferenceId).title() << "] " << aDate;
+        mEvents = Event::getSearchResultByDate(QDate(aDate.year(), aDate.month(), aDate.day()), aConferenceId, "start");
+    }
+    createTimeGroups();
+}
+
 void EventModel::loadEventsByTrack(const QDate &aDate, int aConferenceId)
 {

src/mvc/eventmodel.h

@@ -20 +20 @@
     void loadFavEvents(const QDate &aDate, int aConferenceId); // loads Favourite events from the DB
     void loadEventsByTrack(const QDate &aDate, int aConferenceId); // loads Events grouped by Track from the DB
+    void loadSearchResultEvents(const QDate &aDate, int aConferenceId);
     // a method to force 'EventModel' emit signal 'dataChanged()'
     // a 'view', eg. 'TreeView' listens for this signal and redraws changed items(indexes)