3 var moment = require('moment');
5 module.exports = function(sequelize, DataTypes) {
6 return sequelize.define('ReportFax', {
7 uniqueid: DataTypes.STRING,
8 timeslot: DataTypes.INTEGER,
9 accountid: DataTypes.STRING,
10 accountname: DataTypes.STRING,
11 accountphone: DataTypes.STRING,
12 application: DataTypes.STRING,
13 memberid: DataTypes.INTEGER,
14 membername: DataTypes.STRING,
15 queue: DataTypes.INTEGER,
16 queuename: DataTypes.STRING,
17 roomid: DataTypes.INTEGER,
18 messageid: DataTypes.INTEGER,
20 type: DataTypes.STRING,
21 defaultValue: 'called'
24 type: DataTypes.STRING,
26 set: function(connectid) {
27 this.setDataValue('connectid', connectid);
28 this.setDataValue('reason', 'connect');
29 this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
32 calledAt: DataTypes.DATE,
35 set: function(rejectedAt) {
36 this.setDataValue('rejectedAt', rejectedAt);
37 this.setDataValue('reason', 'rejected');
40 connectedAt: DataTypes.DATE,
41 from: DataTypes.STRING
43 tableName: 'report_fax'