5 module.exports = function(sequelize, DataTypes) {
7 var ReportCall = sequelize.define('ReportCall', {
8 accountcode: DataTypes.STRING,
9 source: DataTypes.STRING,
10 destination: DataTypes.STRING,
11 destinationcontext: DataTypes.STRING,
12 callerid: DataTypes.STRING,
13 channel: DataTypes.STRING,
14 destinationchannel: DataTypes.STRING,
15 lastapplication: DataTypes.STRING,
16 lastdata: DataTypes.STRING,
17 starttime: DataTypes.DATE,
20 set: function(answertime) {
21 if (answertime !== '') {
22 this.setDataValue('answertime', answertime);
24 this.setDataValue('answertime', null);
28 endtime: DataTypes.DATE,
29 duration: DataTypes.INTEGER,
30 billableseconds: DataTypes.INTEGER,
31 disposition: DataTypes.STRING,
32 amaflags: DataTypes.STRING,
34 type: DataTypes.STRING,
37 userfield: DataTypes.STRING,
39 tableName: 'report_call',
40 associate: function(models) {
41 ReportCall.hasMany(models.ReportQueue, {
43 foreignKey: 'uniqueid',
46 ReportCall.hasMany(models.ReportAgent, {
48 foreignKey: 'uniqueid',