5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportMail = sequelize.define('ReportMail', {
10 uniqueid: DataTypes.INTEGER,
11 sorting: DataTypes.INTEGER,
12 timeslot: DataTypes.INTEGER,
13 subject: DataTypes.STRING,
14 from: DataTypes.STRING,
16 attachment: DataTypes.BOOLEAN,
17 accountname: DataTypes.STRING,
18 accountaddress: DataTypes.STRING,
19 application: DataTypes.STRING,
20 fullname: DataTypes.STRING,
21 membername: DataTypes.STRING,
22 agentid: DataTypes.INTEGER,
23 mailqueuename: DataTypes.STRING,
24 mailroomid: DataTypes.INTEGER,
25 lastevent: DataTypes.STRING,
26 agentcalledAt: DataTypes.DATE,
28 type: DataTypes.INTEGER,
31 agentconnectedAt: DataTypes.DATE,
33 type: DataTypes.BOOLEAN,
35 set: function(agentconnectedAt) {
36 this.setDataValue('connectId', this.uniqueid);
37 this.setDataValue('agentconnectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
38 this.setDataValue('reason', 'agent');
39 this.setDataValue('lastevent', 'agent');
42 agentringnoanswerAt: DataTypes.DATE,
43 reason: DataTypes.STRING
45 tableName: 'report_mail'