Changeset 680a4da

Timestamp:

01/16/10 16:31:15 (12 years ago)

Author:

pavelpa <pavelpa@…>

Branches:

master, qt5

Children:

c790268

Parents:

8860ff4

Message:

work on favourite

• created 'favourite' column in EVENT table
• modified 'ormrecord' for setting record's elements
• favourities view not implemented

Location:

src

Files:

• fosdem.pro (modified) (1 diff)
• mvc/delegate.cpp (modified) (2 diffs)
• mvc/delegate.h (modified) (1 diff)
• mvc/event.cpp (modified) (2 diffs)
• mvc/event.h (modified) (3 diffs)
• mvc/treeview.cpp (modified) (2 diffs)
• orm/ormrecord.h (modified) (5 diffs)
• sql/sqlengine.cpp (modified) (3 diffs)

src/fosdem.pro

@@ -1 +1 @@
 TEMPLATE = subdirs
-SUBDIRS  = orm mvc sql gui app test
+SUBDIRS  = orm mvc sql gui app
+#SUBDIRS += test
 CONFIG += ordered
 

src/mvc/delegate.cpp

@@ -84 +84 @@
 
         // draw Controls
-        painter->drawImage(mControls[FavouriteControl]->drawPoint(option.rect),*mControls[FavouriteControl]->image());
-        painter->drawImage(mControls[AlarmControl]->drawPoint(option.rect),*mControls[AlarmControl]->image());
+        if(static_cast<Event*>(index.internalPointer())->isFavourite())
+            painter->drawImage(mControls[FavouriteControlOn]->drawPoint(option.rect),*mControls[FavouriteControlOn]->image());
+        else
+            painter->drawImage(mControls[FavouriteControlOff]->drawPoint(option.rect),*mControls[FavouriteControlOff]->image());
+        painter->drawImage(mControls[AlarmControlOn]->drawPoint(option.rect),*mControls[AlarmControlOn]->image());
         painter->drawImage(mControls[MapControl]->drawPoint(option.rect),*mControls[MapControl]->image());
     }
@@ -201 +204 @@
 {
     Control *control;
-    // FAVOURITE ICON
-    control = new Control(FavouriteControl,QString(":icons/favourite-on.png"));
+    // FAVOURITE ICONs
+    // on
+    control = new Control(FavouriteControlOn,QString(":icons/favourite-on.png"));
     control->setDrawPoint(QPoint(-control->image()->width()-SPACER,SPACER));
-    mControls.insert(FavouriteControl,control);
-
-    // ALARM ICON
-    control = new Control(AlarmControl,QString(":icons/alarm-on.png"));
-    control->setDrawPoint(QPoint(-mControls[FavouriteControl]->image()->width()-control->image()->width()-2*SPACER,SPACER));
-    mControls.insert(AlarmControl,control);
+    mControls.insert(FavouriteControlOn,control);
+    // off
+    control = new Control(FavouriteControlOff,QString(":icons/favourite-off.png"));
+    control->setDrawPoint(QPoint(-control->image()->width()-SPACER,SPACER));
+    mControls.insert(FavouriteControlOff,control);
+
+    // ALARM ICONs
+    // on
+    control = new Control(AlarmControlOn,QString(":icons/alarm-on.png"));
+    control->setDrawPoint(QPoint(-mControls[FavouriteControlOn]->image()->width()-control->image()->width()-2*SPACER,SPACER));
+    mControls.insert(AlarmControlOn,control);
+    // off
+    control = new Control(AlarmControlOff,QString(":icons/alarm-off.png"));
+    control->setDrawPoint(QPoint(-mControls[FavouriteControlOff]->image()->width()-control->image()->width()-2*SPACER,SPACER));
+    mControls.insert(AlarmControlOff,control);
 
     // MAP ICON
     control = new Control(MapControl,QString(":icons/compass.png"));
-    control->setDrawPoint(QPoint(-mControls[AlarmControl]->image()->width()-control->image()->width()
-                                 -mControls[FavouriteControl]->image()->width()-3*SPACER,SPACER));
+    control->setDrawPoint(QPoint(-mControls[AlarmControlOn]->image()->width()-control->image()->width()
+                                 -mControls[FavouriteControlOn]->image()->width()-3*SPACER,SPACER));
     mControls.insert(MapControl,control);
 }

src/mvc/delegate.h

@@ -15 +15 @@
         {
             ControlNone = 0,
-            FavouriteControl,
-            AlarmControl,
+            FavouriteControlOn,
+            FavouriteControlOff,
+            AlarmControlOn,
+            AlarmControlOff,
             MapControl
         };

src/mvc/event.cpp

@@ -8 +8 @@
     << QSqlField("xid_activity", QVariant::Int)
     << QSqlField("type", QVariant::String)
-    << QSqlField("language", QVariant::String));
+    << QSqlField("language", QVariant::String)
+    << QSqlField("favourite", QVariant::Bool));
 
 QString const Event::sTableName = QString("event");
@@ -31 +32 @@
     return load(query);
 }
+

src/mvc/event.h

@@ -7 +7 @@
 
 #include <ormrecord.h>
-
 
 /**
@@ -34 +33 @@
     QString type() const { return value("type").toString(); }
     QString language() const { return value("language").toString(); }
+    bool isFavourite() const { return value("favourite").toBool(); }
 
     void setId(int id) { setValue("id", id); }
@@ -42 +42 @@
     void setType(const QString& type) { setValue("type", type); }
     void setLanguage(const QString& language) { setValue("language", language); }
+    void setFavourite(bool favourite) { setValue("favourite", favourite); }
 
 friend class EventTest;
 };
 
+#endif // EVENT_H
 
-
-#endif // EVENT_H

src/mvc/treeview.cpp

@@ -3 +3 @@
 #include "treeview.h"
 #include "delegate.h"
+#include "event.h"
 
 #include <QDebug>
@@ -31 +32 @@
     switch(delegate->whichControlClicked(aIndex,aPoint))
     {
-        case Delegate::FavouriteControl:
+        case Delegate::FavouriteControlOn:
+        case Delegate::FavouriteControlOff:
             {
                 // handle Favourite Control clicked
-                qDebug() << "FAVOURITE CLICKED: " << qVariantValue<QString>(aIndex.data());
+                Event event = Event::getById(aIndex.data().toInt(),1);
+                if(event.isFavourite())
+                {
+                    static_cast<Event*>(aIndex.internalPointer())->setFavourite(false); // list of events
+                    event.setFavourite(false); // update DB
+                }
+                else
+                {
+                    static_cast<Event*>(aIndex.internalPointer())->setFavourite(true); // list of events
+                    event.setFavourite(true);
+                }
+                qDebug() << " FAVOURITE [" << qVariantValue<QString>(aIndex.data()) << "] -> " << event.isFavourite();
+                event.update("favourite");
+                // TODO: since the Favourite icon has changed, update TreeView accordingly
+                // not really working solution is the following
+                // maybe the call to MainWindow->update() fix the problem ???
+                QTreeView::update();
+                update();
             }
             break;
-        case Delegate::AlarmControl:
+        case Delegate::AlarmControlOn:
+        case Delegate::AlarmControlOff:
             {
                 // handle Alarm Control clicked

src/orm/ormrecord.h

@@ -34 +34 @@
     OrmRecord();
     static T hydrate(const QSqlRecord& record);
+    void update(QString col, QVariant value = QVariant()); // updates specified column 'col'
 
 protected:
@@ -45 +46 @@
     static QString columnsForSelect(const QString& prefix = QString());
     static QString selectQuery();
+    static QString updateQuery();
     static QSqlRecord toRecord(const QList<QSqlField> & columnList);
 
@@ -63 +65 @@
     object.QSqlRecord::operator=(record);
     return object;
+}
+
+// updates specified column 'col'
+// if the value is not specified  as an argument,
+// it's taken from the reford itself
+// see also: setValue() method for more details
+template <typename T>
+void OrmRecord<T>::update(QString col, QVariant value)
+{
+    QSqlQuery query;
+    query.prepare(QString(updateQuery() + "SET %1 = :col WHERE id = :id").arg(col));
+    if(value.isValid()) // take 'col' value from the method's arguments
+        query.bindValue(":col", value);
+    else // take 'col' value from the record; see setValue()
+        query.bindValue(":col", convertToDb(this->value(col), this->value(col).type()));
+    query.bindValue(":id", this->value("id"));
+    //query.bindValue(":id", convertToDb(value("id"), QVariant::Int));
+    query.exec();
 }
 
@@ -103 +123 @@
         if (!query.exec())
         {
-            //TODO Palo: exception handling !
-                QString start = "START\n";
-                QString end = "\nEND\n";
-                QString message = start + query.lastError().text() + end;
-                const char *data = message.toLatin1().data();
-                qDebug(data);
             throw new OrmSqlException(query.lastError().text());
         }
@@ -139 +153 @@
 {
     return QString("SELECT %1 FROM %2 ").arg(columnsForSelect(), T::sTableName);
+}
+
+template <typename T>
+QString OrmRecord<T>::updateQuery()
+{
+    return QString("UPDATE %1 ").arg(T::sTableName);
 }
 

src/sql/sqlengine.cpp

@@ -91 +91 @@
         // VIRTUAL_EVENT is for Full-Text-Serach Support
         QDateTime startDateTime = QDateTime(QDate::fromString(aEvent["date"],DATE_FORMAT),QTime::fromString(aEvent["start"],TIME_FORMAT));
-        QString values = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7'") \
+        QString values = QString("'%1', '%2', '%3', '%4', '%5', '%6', '%7', '%8'") \
                          .arg(aEvent["conference_id"]) \
                          .arg(aEvent["id"]) \
@@ -98 +98 @@
                          .arg("123456") \
                          .arg(aEvent["type"]) \
-                         .arg(aEvent["language"]);
-
-        QString query = QString("INSERT INTO EVENT (xid_conference, id, start, duration, xid_activity, type, language) VALUES (%1)").arg(values);
+                         .arg(aEvent["language"]) \
+                         .arg("0"); // not favourite when added
+
+        QString query = QString("INSERT INTO EVENT (xid_conference, id, start, duration, xid_activity, type, language, favourite) VALUES (%1)").arg(values);
         QSqlQuery result (query, db);
         //LOG_AUTOTEST(query);
@@ -227 +228 @@
             type VARCHAR, \
             language VARCHAR, \
+            favourite INTEGER DEFAULT 0, \
             PRIMARY KEY (xid_conference,id), \
             FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id) \