Changeset 64122f1 for src/mvc/event.cpp

Timestamp:

01/18/10 19:38:55 (13 years ago)

Author:

korrco <korrco@…>

Branches:

master, qt5

Children:

707cd31

Parents:

18681b3

Message:

sorting by activity id added

File:

• src/mvc/event.cpp (modified) (2 diffs)

src/mvc/event.cpp

@@ -8 +8 @@
 int const Event::sTable1ColCount = 9; // see 'toRecord()' for more details
 int const Event::sTable2ColCount = 5; // see 'toRecord()' for more details
+const QString Event::XID_ACTIVITY = "xid_activity";
+const QString Event::START = "start";
+
+
 
 QSqlRecord const Event::sColumns = Event::toRecord(QList<QSqlField>()
@@ -40 +44 @@
 }
 
-QList<Event> Event::getByDate(const QDate& date, int conferenceId)
+QList<Event> Event::getByDate(const QDate& date, int conferenceId, QString orderBy)
 {
     QSqlQuery query;
     query.prepare(
             selectQueryJoin2T("id")
-            + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end ORDER BY %1.start").arg(sTable1Name));
+            + QString("WHERE %1.xid_conference = :conf AND %1.start >= :start AND %1.start < :end ORDER BY %1.%2").arg(sTable1Name).arg(orderBy));
     query.bindValue(":conf", conferenceId);
     query.bindValue(":start", convertToDb(date, QVariant::DateTime));