-/**
- * DIAL Model
- */
+'use strict';
var moment = require('moment');
},
duration: DataTypes.INTEGER,
enterAt: DataTypes.DATE,
- exitAt: DataTypes.DATE,
+ exitAt: {
+ type: DataTypes.DATE,
+ set: function(exitAt) {
+ var a = moment(exitAt);
+ var b = moment(this.getDataValue('enterAt'));
+ var duration = a.diff(b, 'seconds');
+
+ this.setDataValue('exitAt', exitAt);
+ this.setDataValue('duration', duration || null);
+ }
+ },
data1: DataTypes.STRING,
data2: DataTypes.STRING,
data3: DataTypes.STRING,
data4: DataTypes.STRING,
- data5: DataTypes.STRING
+ data5: DataTypes.STRING,
+ role: DataTypes.STRING,
+ internal: DataTypes.INTEGER(11),
+ uniqueid: DataTypes.STRING
}, {
- tableName: 'report_member',
- // indexes: [{
- // fields: ['membername', 'enterdate', 'exitdate']
- // }]
+ tableName: 'report_member'
});
return ReportMember;