Stat.js

var mongoose = require('mongoose')
  , Schema = mongoose.Schema;

Date.prototype.getDOY = function() {
  var onejan = new Date(this.getFullYear(),0,1);
  return Math.ceil((this - onejan) / 86400000);
}

var schema = new Schema({
  date : {type : Date,default: Date.now,index : true},
  lDate : {type : Date,default: Date.now,index : true},
  dt : {type : Number,default: 10},
  mountain : String,
  
  points : {type : Number, default : 0},
  pointsDx : {type : Number, default : 0},
  pointsPm : {type : Number, default : 0},

  pins : {type : Number, default : 0},
  pinsDx : {type : Number, default : 0},
  pinsPm : {type : Number, default : 0},

  lifts : {type : Number, default : 0},
  liftsDx : {type : Number, default : 0},
  liftsPm : {type : Number, default : 0},

  photos : {type : Number, default : 0},
  photosDx : {type : Number, default : 0},
  photosPm : {type : Number, default : 0},

  DoW : Number,
  DoM : Number,
  HoD : {type : Number,index : true},
  DoY : Number,
  lDoW : Number,
  lDoM : Number,
  lHoD : Number,
  lDoY : Number
});

schema.statics.StatNames = [
  'points',
  'pins',
  'lifts',
  'photos',
];

schema.statics.Mountains = ['MtBrighton',
                 'Vail',
                 'BeaverCreek',
                 'Breck',
                 'Keystone',
                 'Canyons',
                 'Heavenly',
                 'Northstar',
                 'Kirkwood',
                 'AftonAlps'];

schema.statics.UtcOffsets = {'MtBrighton' : -5,
                 'Vail' : -7,
                 'BeaverCreek' : -7,
                 'Breck' : -7,
                 'Keystone' : -7,
                 'Canyons' : -7,
                 'Heavenly' : -8,
                 'Northstar' : -8,
                 'Kirkwood' : -7,
                 'AftonAlps' : -7};

var Stat = mongoose.model('EpicStat',schema);

schema.pre('save', function (next) {

  this.lDate = new Date((this.date.getTime() + ((Stat.UtcOffsets[this.mountain])*60*60*1000)));
  this.lDoW = this.lDate.getDay();
  this.lDoM = this.lDate.getDate();
  this.lHoD = this.lDate.getHours();
  this.lDoY = this.lDate.getDOY();

  this.DoW = this.date.getDay();
  this.DoM = this.date.getDate();
  this.HoD = this.date.getHours();
  this.DoY = this.date.getDOY();

  var self = this;
  Stat.find({ mountain : this.mountain, date : {$lt : this.date} })
      .sort({date : -1})
      .limit(1)
      .exec(function(err,docs){
        if(err || docs.length < 1)
          return next();

        var s2 = docs[0];
        self.dt = Math.round((self.date.getTime()-s2.date.getTime())/1000/60);

        Stat.StatNames.forEach(function(k){
          self[k+'Dx'] = (self[k]-s2[k]);
          self[k+'Pm'] = Math.round(self[k+'Dx']/self.dt);
        });
        next();
      });
});

module.exports = Stat;