1 files changed, 78 insertions, 0 deletions
diff --git a/app/models/pPost.js b/app/models/pPost.js
new file mode 100644
index 0000000..1f53984
--- /dev/null
+++ b/app/models/pPost.js
@@ -0,0 +1,78 @@
+
+/**
+ * Module dependencies
+ */
+
+var mongoose = require('mongoose')
+  , Schema = mongoose.Schema;
+
+var pPostSchema = new Schema({
+    user: { type: Schema.ObjectId, ref: 'User' },
+    for: { type: Schema.ObjectId, ref: 'User' },
+    project: { type: Schema.ObjectId, ref: 'Project' },
+    what: { type: String, default: '', trim: true },
+    comment: { type: String, default: '', trim: true },
+    participants: [],
+    value: { type: Number, defailt: 0 },
+    file: { type: String, default: '', trim: true },
+    currency: { type: String, default: 'kr', trim: true },
+    created: { type: Date, default: Date.now },
+    updated: { type: Date, default: Date.now },
+    when: { type: Date, default: Date.now }
+});
+
+
+
+
+pPostSchema.statics = {
+
+   /**
+    * Find post by id
+    *
+    * @param {ObjectId} id
+    * @param {Function} callback
+    * @api private
+    */
+
+    load: function(id, callback) {
+        this.findOne({ _id: id })
+          .populate({ path: 'user', select: '_id, name'})
+          .exec(callback);
+    },
+
+
+          /**
+    * Find all posts that belong to a project, by project id
+    *
+    * @param {ObjectId} project
+    * @param {Function} callback
+    * @api private
+    */
+
+    loadProject: function(project, callback) {
+        this.find({ project: project })
+          .populate('user')
+          .sort({ 'when': -1, 'created': -1 })
+          .exec(callback);
+    },
+
+
+   /**
+    * Find last ten posts belonging projects a user is part of, by project ids
+    *
+    * @param {Array[ObjectId]} projects
+    * @param {Function} callback
+    * @api private
+    */
+
+    loadByProjects: function(projects, callback) {
+        this.find({ project: { $in: projects } })
+          .populate({ path: 'user', select: '_id name' })
+          .populate({ path: 'project', select: 'name shortURL' })
+          .sort({ 'when': -1, 'created': -1 })
+          .exec(callback);
+    }
+
+}
+
+mongoose.model('pPost', pPostSchema);