3 var moment = require('moment');
5 module.exports = function(sequelize, DataTypes) {
7 var ReportMember = sequelize.define('ReportMember', {
8 channel: DataTypes.STRING,
9 membername: DataTypes.STRING,
10 interface: DataTypes.STRING,
12 type: DataTypes.STRING,
13 defaultValue: 'DEFAULT PAUSE'
15 duration: DataTypes.INTEGER,
16 enterAt: DataTypes.DATE,
19 set: function(exitAt) {
20 if (!this.getDataValue('duration')) {
21 var a = moment(exitAt);
22 var b = moment(this.getDataValue('enterAt'));
23 var duration = a.diff(b, 'seconds');
24 this.setDataValue('duration', duration || null);
27 this.setDataValue('exitAt', exitAt);
30 data1: DataTypes.STRING,
31 data2: DataTypes.STRING,
32 data3: DataTypes.STRING,
33 data4: DataTypes.STRING,
34 data5: DataTypes.STRING,
35 role: DataTypes.STRING,
36 internal: DataTypes.INTEGER(11),
37 uniqueid: DataTypes.STRING
39 tableName: 'report_member'