5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportChat = sequelize.define('ReportChat', {
11 uniqueid: DataTypes.STRING,
12 timeslot: DataTypes.INTEGER,
13 websitename: DataTypes.STRING,
14 websiteaddress: DataTypes.STRING,
15 websiteid: DataTypes.INTEGER,
16 application: DataTypes.STRING,
17 agentid: DataTypes.INTEGER,
18 agentname: DataTypes.STRING,
19 visitorid: DataTypes.STRING,
20 visitorname: DataTypes.STRING,
21 visitoremail: DataTypes.STRING,
22 queueid: DataTypes.INTEGER,
23 queuename: DataTypes.STRING,
24 roomid: DataTypes.INTEGER,
26 type: DataTypes.STRING,
27 defaultValue: 'called'
30 type: DataTypes.STRING,
32 set: function(agentconnectedAt) {
33 this.setDataValue('connectid', this.uniqueid);
34 this.setDataValue('reason', 'connect');
35 this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
38 calledAt: DataTypes.DATE,
39 connectedAt: DataTypes.DATE
41 tableName: 'report_chat'