Built motion from commit c2984ba.|0.0.114

[motion.git] / server / models / report_chat.js

diff --git a/server/models/report_chat.js b/server/models/report_chat.js
index 08a9e88..7c523a8 100644 (file)
--- a/server/models/report_chat.js
+++ b/server/models/report_chat.js
@@ -7,39 +7,42 @@ var moment = require('moment');
 module.exports = function(sequelize, DataTypes) {
 
   var ReportChat = sequelize.define('ReportChat', {
-    uniqueid: DataTypes.INTEGER,
-    sorting: DataTypes.INTEGER,
+    uniqueid: DataTypes.STRING,
     timeslot: DataTypes.INTEGER,
-    visitorname: DataTypes.STRING,
-    visitoremail: DataTypes.STRING,
     websitename: DataTypes.STRING,
     websiteaddress: DataTypes.STRING,
     websiteid: DataTypes.INTEGER,
     application: DataTypes.STRING,
-    fullname: DataTypes.STRING,
+    memberid: DataTypes.INTEGER,
     membername: DataTypes.STRING,
-    agentid: DataTypes.INTEGER,
-    chatqueuename: DataTypes.STRING,
-    lastevent: DataTypes.STRING,
-    agentcalledAt: DataTypes.DATE,
-    chatroomid: DataTypes.INTEGER,
-    connectId: {
-      type: DataTypes.INTEGER,
-      unique: true
+    visitorid: DataTypes.STRING,
+    visitorname: DataTypes.STRING,
+    visitoremail: DataTypes.STRING,
+    queue: DataTypes.INTEGER,
+    queuename: DataTypes.STRING,
+    roomid: DataTypes.INTEGER,
+    reason: {
+      type: DataTypes.STRING,
+      defaultValue: 'called'
+    },
+    connectid: {
+      type: DataTypes.STRING,
+      unique: true,
+      set: function(connectid) {
+        this.setDataValue('connectid', connectid);
+        this.setDataValue('reason', 'connect');
+        this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
+      }
     },
-    agentconnectedAt: DataTypes.DATE,
-    connect: {
-      type: DataTypes.BOOLEAN,
-      defaultValue: false,
-      set: function(agentconnectedAt) {
-        this.setDataValue('connectId', this.uniqueid);
-        this.setDataValue('agentconnectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
-        this.setDataValue('reason', 'agent');
-        this.setDataValue('lastevent', 'agent');
+    calledAt: DataTypes.DATE,
+    rejectedAt: {
+      type: DataTypes.DATE,
+      set: function(rejectedAt) {
+        this.setDataValue('rejectedAt', rejectedAt);
+        this.setDataValue('reason', 'rejected');
       }
     },
-    agentringnoanswerAt: DataTypes.DATE,
-    reason: DataTypes.STRING
+    connectedAt: DataTypes.DATE
   }, {
     tableName: 'report_chat'
   });