5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportQueue = sequelize.define('ReportQueue', {
10 uniqueid: DataTypes.STRING,
11 calleridnum: DataTypes.STRING,
12 calleridname: DataTypes.STRING,
13 queue: DataTypes.STRING,
14 queuecallerjoinAt: DataTypes.DATE,
17 set: function(queuecallerleaveAt) {
18 var a = moment(queuecallerleaveAt);
19 var b = moment(this.getDataValue('queuecallerjoinAt')).format("YYYY-MM-DD HH:mm:ss");
21 this.setDataValue('queuecallerleaveAt', queuecallerleaveAt);
22 this.setDataValue('holdtime', a.diff(b, 'seconds'));
25 position: DataTypes.INTEGER,
26 count: DataTypes.INTEGER,
28 type: DataTypes.BOOLEAN,
31 queuecallerabandonAt: DataTypes.DATE,
32 queuecallercomplete: {
33 type: DataTypes.BOOLEAN,
36 queuecallercompleteAt: DataTypes.DATE,
38 type: DataTypes.BOOLEAN,
41 queuecallerexitAt: DataTypes.DATE,
42 queuecallerexitreason: DataTypes.STRING,
43 originalposition: DataTypes.INTEGER,
44 channel: DataTypes.STRING,
45 channelstate: DataTypes.INTEGER,
46 channelstatedesc: DataTypes.STRING,
47 connectedlinenum: DataTypes.STRING,
48 connectedlinename: DataTypes.STRING,
49 language: DataTypes.STRING,
50 accountcode: DataTypes.STRING,
51 context: DataTypes.STRING,
52 exten: DataTypes.STRING,
53 priority: DataTypes.STRING,
54 holdtime: DataTypes.INTEGER
56 tableName: 'report_queue',