4 var moment = require('moment');
6 module.exports = function(sequelize, DataTypes) {
7 var ReportAgentHistory = sequelize.define('ReportAgentHistory', {
8 uniqueid: DataTypes.STRING,
9 calleridnum: DataTypes.STRING,
10 calleridname: DataTypes.STRING,
11 queue: DataTypes.STRING,
12 interface: DataTypes.STRING,
13 membername: DataTypes.STRING,
14 agentcalledAt: DataTypes.DATE,
18 return moment(this.getDataValue('agentconnectAt')).format("MM-DD-YYYY HH:mm");
21 holdtime: DataTypes.INTEGER,
23 type: DataTypes.BOOLEAN,
26 agentcompleteAt: DataTypes.DATE,
27 talktime: DataTypes.INTEGER,
29 type: DataTypes.BOOLEAN,
32 acwtime: DataTypes.INTEGER,
33 reason: DataTypes.STRING,
35 type: DataTypes.BOOLEAN,
38 agentringnoanswerAt: DataTypes.DATE,
40 type: DataTypes.BOOLEAN,
43 agentdumpAt: DataTypes.DATE,
44 lastevent: DataTypes.STRING,
45 channel: DataTypes.STRING,
46 channelstate: DataTypes.INTEGER,
47 channelstatedesc: DataTypes.STRING,
48 connectedlinenum: DataTypes.STRING,
49 connectedlinename: DataTypes.STRING,
50 language: DataTypes.STRING,
51 accountcode: DataTypes.STRING,
52 context: DataTypes.STRING,
53 exten: DataTypes.STRING,
54 priority: DataTypes.STRING,
55 destchannel: DataTypes.STRING,
56 destchannelstate: DataTypes.INTEGER,
57 destchannelstatedesc: DataTypes.STRING,
58 destcalleridnum: DataTypes.STRING,
59 destcalleridname: DataTypes.STRING,
60 destconnectedlinenum: DataTypes.STRING,
61 destconnectedlinename: DataTypes.STRING,
62 destlanguage: DataTypes.STRING,
63 destaccountcode: DataTypes.STRING,
64 destcontext: DataTypes.STRING,
65 destexten: DataTypes.STRING,
66 destpriority: DataTypes.STRING,
67 destuniqueid: DataTypes.STRING
69 tableName: 'report_agent_history'
72 ReportAgentHistory.removeAttribute('id');
73 return ReportAgentHistory;