Changeset b8a3ad1 for src/mvc/event.cpp

Timestamp:

01/22/10 07:18:25 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

8b71fb3

Parents:

d336730

Message:

implemented NOW tab

File:

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

src/mvc/event.cpp

@@ -36 +36 @@
     query.bindValue(":start", convertToDb(date, QVariant::DateTime));
     query.bindValue(":end", convertToDb(date.addDays(1), QVariant::DateTime));
+
+    return load(query);
+}
+
+QList<Event> Event::nowEvents(int conferenceId, QString orderBy)
+{
+    //uint curTime_t =  QDateTime(QDate::currentDate(),QTime::currentTime(),Qt::UTC).toTime_t();
+    uint curTime_t = 1265457610; // for testing
+
+    QSqlQuery query;
+    query.prepare(selectQuery() + QString("WHERE xid_conference = :conf AND start <= :now1 AND ( start + duration ) > :now2 ORDER BY %1").arg(orderBy));
+    query.bindValue(":conf", conferenceId);
+    query.bindValue(":now1", convertToDb(curTime_t, QVariant::DateTime));
+    query.bindValue(":now2", convertToDb(curTime_t, QVariant::DateTime));
 
     return load(query);