removed appsettings

[toast/confclerk.git] / src / mvc / conference.cpp

diff --git a/src/mvc/conference.cpp b/src/mvc/conference.cpp
index c2d7d90b2442f2f7a2b6ae746b382e519c34d232..17c4a9091293e9af63ed03de1d2edacf67435169 100644 (file)
--- a/src/mvc/conference.cpp
+++ b/src/mvc/conference.cpp
@@ -10,7 +10,8 @@ QSqlRecord const Conference::sColumns = Conference::toRecord(QList<QSqlField>()
     << QSqlField("end", QVariant::DateTime)
     << QSqlField("days", QVariant::Int)
     << QSqlField("day_change", QVariant::Int)
     << QSqlField("end", QVariant::DateTime)
     << QSqlField("days", QVariant::Int)
     << QSqlField("day_change", QVariant::Int)

-    << QSqlField("timeslot_duration", QVariant::Int));
+    << QSqlField("timeslot_duration", QVariant::Int)
+    << QSqlField("active", QVariant::Bool));

 
 QString const Conference::sTableName = QString("conference");
 
 
 QString const Conference::sTableName = QString("conference");
 


@@ -29,3 +30,18 @@ QList<Conference> Conference::getAll()
     return load(query);
 }
 
     return load(query);
 }
 

+int Conference::activeConference()
+{
+    QSqlQuery query("SELECT id FROM conference WHERE active = 1");
+    query.exec();
+
+    QList<int> activeConfs;
+    while(query.next())
+        activeConfs.append(query.record().value("id").toInt());
+
+    if(activeConfs.count()==0) // no active DB
+        return 1;
+    else // even if there are more active confs, the first from the list is confidered active
+        return activeConfs[0];
+}
+