Built motion from commit 1038d87.|0.0.141

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

diff --git a/server/models/report_mail.js b/server/models/report_mail.js
index e932f85..0063f40 100644 (file)
--- a/server/models/report_mail.js
+++ b/server/models/report_mail.js
@@ -1,44 +1,45 @@
-/**
- * Agent Log Model
- */
+'use strict';
 
-var moment = require('moment');
+const moment = require('moment');
 
 module.exports = function(sequelize, DataTypes) {
-
   var ReportMail = sequelize.define('ReportMail', {
-    uniqueid: DataTypes.INTEGER,
-    sorting: DataTypes.INTEGER,
+    uniqueid: DataTypes.STRING,
     timeslot: DataTypes.INTEGER,
     subject: DataTypes.STRING,
-    from: DataTypes.STRING,
-    cc: DataTypes.STRING,
-    attachment: DataTypes.BOOLEAN,
+    accountid: DataTypes.STRING,
     accountname: DataTypes.STRING,
     accountaddress: DataTypes.STRING,
     application: DataTypes.STRING,
-    fullname: DataTypes.STRING,
+    memberid: DataTypes.INTEGER,
     membername: DataTypes.STRING,
-    mailqueuename: DataTypes.STRING,
-    lastevent: DataTypes.STRING,
-    agentcalledAt: DataTypes.DATE,
-    connectId: {
-      type: DataTypes.INTEGER,
-      unique: true
+    queue: DataTypes.INTEGER,
+    queuename: DataTypes.STRING,
+    roomid: DataTypes.INTEGER,
+    messageid: 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,
+    from: DataTypes.STRING
   }, {
     tableName: 'report_mail'
   });