Changeset 378:77e70b2ae3e2

Timestamp:

05/18/2009 10:29:06 PM (3 years ago)

Author:

Dmitry Nezhevenko <dion@…>

Branch:

default

Message:

Calc real online time of user

Files:

• sql/update/pgsql/00374.sql (modified) (1 diff)
• src/plugins/muc/jidstat.cpp (modified) (4 diffs)
• src/plugins/muc/jidstat.h (modified) (2 diffs)
• src/plugins/muc/nick.cpp (modified) (1 diff)

sql/update/pgsql/00374.sql

@@ -3 +3 @@
   id SERIAL,
   jid_id int NOT NULL,
+
+  time_online int NOT NULL default 0, 
+
   lastaction int NOT NULL default '0',
   lastreason varchar(200) NULL,

src/plugins/muc/jidstat.cpp

@@ -32 +32 @@
         jidId_ = jidId;
 
+        dateTime_ = QDateTime::currentDateTime();
         if (jidId_ > 0)
         {
@@ -149 +150 @@
         if (!cntName.isEmpty())
         {
-                q.prepare(QString("UPDATE conference_jidstat set %1 = %1 + 1 WHERE id=?").arg(cntName, cntName));
+                q.prepare(QString("UPDATE conference_jidstat set %1 = %2 + 1 WHERE id=?").arg(cntName).arg(cntName));
                 q.addBindValue(id_);
                 if (!q.exec())
@@ -156 +157 @@
                 }
         }
+        updateOnlineTime();
 }
 
@@ -173 +175 @@
         }
 }
+
+void JidStat::updateOnlineTime()
+{
+        if (id_ <= 0)
+                return;
+        QDateTime now = QDateTime::currentDateTime();
+        int delta = dateTime_.secsTo(now);
+        QSqlQuery q = DataStorage::instance()->prepareQuery(
+                        "UPDATE conference_jidstat SET time_online = time_online + ? WHERE id=?"
+        );
+        q.addBindValue(delta);
+        q.addBindValue(id_);
+        if (!q.exec())
+        {
+                qDebug() << "ERROR: Unable to update time_online";
+        }
+        else
+        {
+                dateTime_=now;
+        }
+
+}

src/plugins/muc/jidstat.h

@@ -22 +22 @@
 
 #include <QString>
+#include <QDateTime>
 
 class JidStat
@@ -53 +54 @@
         void setLastAction(ActionType type, const QString& reason);
         void setVersion(const QString& version);
+        void updateOnlineTime();
 private:
         int id_;
         int jidId_;
+        QDateTime dateTime_;
 
         bool load();

src/plugins/muc/nick.cpp

@@ -134 +134 @@
                 delete myJid;
         }
+        if (myJidStat)
+                myJidStat->updateOnlineTime();
         delete myJidStat;
 }