Changeset 0bb39f5 in confclerk_git for src/mvc

Timestamp:

01/27/10 16:31:10 (13 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

a790a90

Parents:

07ae23a

Message:

removed appsettings

• created 'active' column in 'conference' table

Location:

src/mvc

Files:

• conference.cpp (modified) (2 diffs)
• conference.h (modified) (3 diffs)
• eventmodel.cpp (modified) (2 diffs)

src/mvc/conference.cpp

@@ -11 +11 @@
     << 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");
@@ -30 +31 @@
 }
 
+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];
+}
+

src/mvc/conference.h

@@ -17 +17 @@
     static Conference getById(int id);
     static QList<Conference> getAll();
+    static int activeConference();
 
 public:
@@ -29 +30 @@
     int dayChange() const { return value("day_change").toInt(); } // in seconds from 00:00
     int timeslotDuration() const { return value("timeslot_duration").toInt(); } // in seconds
+    bool isActive() const { return value("active").toBool(); }
 
     void setId(int id) { setValue("id", id); }
@@ -35 +37 @@
     void setVenue(const QString& venue) { setValue("venue", venue); }
     void setCity(const QString& city) { setValue("city", city); }
-    //void setStart(const QDate& start) { setValue("start", QDateTime(start)); }
     void setStart(const QDate& start) { setValue("start", start); }
-    //void setEnd(const QDate& end) { setValue("end", QDateTime(end)); }
     void setEnd(const QDate& end) { setValue("end", end); }
     void setDays(int days) { setValue("days", days); }
     void setDayChange(int dayChange) { setValue("day_change", dayChange); }
     void setTimeslotDuration(int timeslotDuration) { setValue("timeslot_duration", timeslotDuration); }
+    void setActive(bool active) { setValue("active", (int)((active))); }
 };
 

src/mvc/eventmodel.cpp

@@ -1 +1 @@
 #include "eventmodel.h"
-#include <appsettings.h>
 #include <conference.h>
 #include <track.h>
@@ -281 +280 @@
     {
         if(mEvents[i].id() == aEventId)
-            mEvents[i] = Event::getById(aEventId,AppSettings::confId());
+            mEvents[i] = Event::getById(aEventId,Conference::activeConference());
     }