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'
},
- 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');
+ 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"));
}
},
- agentringnoanswerAt: DataTypes.DATE,
- reason: DataTypes.STRING
+ calledAt: DataTypes.DATE,
+ rejectedAt: {
+ type: DataTypes.DATE,
+ set: function(rejectedAt) {
+ this.setDataValue('rejectedAt', rejectedAt);
+ this.setDataValue('reason', 'rejected');
+ }
+ },
+ connectedAt: DataTypes.DATE,
+ from: DataTypes.STRING
}, {
tableName: 'report_mail'
});