5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportChat = sequelize.define('ReportChat', {
10 uniqueid: DataTypes.STRING,
11 timeslot: DataTypes.INTEGER,
12 websitename: DataTypes.STRING,
13 websiteaddress: DataTypes.STRING,
14 websiteid: DataTypes.INTEGER,
15 application: DataTypes.STRING,
16 memberid: DataTypes.INTEGER,
17 membername: DataTypes.STRING,
18 visitorid: DataTypes.STRING,
19 visitorname: DataTypes.STRING,
20 visitoremail: DataTypes.STRING,
21 queue: DataTypes.INTEGER,
22 queuename: DataTypes.STRING,
23 roomid: DataTypes.INTEGER,
25 type: DataTypes.STRING,
26 defaultValue: 'called'
29 type: DataTypes.STRING,
31 set: function(connectid) {
32 this.setDataValue('connectid', connectid);
33 this.setDataValue('reason', 'connect');
34 this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
37 calledAt: DataTypes.DATE,
40 set: function(rejectedAt) {
41 this.setDataValue('rejectedAt', rejectedAt);
42 this.setDataValue('reason', 'rejected');
45 connectedAt: DataTypes.DATE
47 tableName: 'report_chat'