5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportMember = sequelize.define('ReportMember', {
10 channel: DataTypes.STRING,
11 membername: DataTypes.STRING,
12 interface: DataTypes.STRING,
14 type: DataTypes.STRING,
15 defaultValue: 'DEFAULT PAUSE'
17 duration: DataTypes.INTEGER,
18 enterAt: DataTypes.DATE,
21 set: function(exitAt) {
22 var a = moment(exitAt);
23 var b = moment(this.getDataValue('enterAt'));
24 var duration = a.diff(b, 'seconds');
26 this.setDataValue('exitAt', exitAt);
27 this.setDataValue('duration', duration || null);
30 data1: DataTypes.STRING,
31 data2: DataTypes.STRING,
32 data3: DataTypes.STRING,
33 data4: DataTypes.STRING,
34 data5: DataTypes.STRING
36 tableName: 'report_member',
38 // fields: ['membername', 'enterdate', 'exitdate']