Just dipping my toes into the coding world and currently working on a web app that's like a dashboard. I'm using node js, express, and mongoose.
I've set up my schemas and collecting user data. There's some data I need to crunch numbers with for calculations.
This is what my model looks like:
var mongoose = require("mongoose"),
math = require('mathjs');
//*****DATABASE CONFIG*******
// Demog Database
var headcountSchema = new mongoose.Schema({
headct_start: Number,
headct_end: Number,
m_mgr: Number,
f_mgr: Number,
m_stf: Number,
f_stf: Number,
m_ops: Number,
f_ops: Number,
m_mru: Number,
f_mru: Number,
m_intl: Number,
etc....
created: {type: Date, default: Date.now},
user: {
id: {
type: mongoose.Schema.Types.ObjectId,
ref: "User"
},
username: String
}
});
module.exports = mongoose.model("Headcount", headcountSchema);
When it comes to performing calculations, I'm following this format:
headcountSchema.virtual('totalmanager').get(function() {
return math.eval(this.m_mgr + this.f_mgr);
});
It's puzzling why it works for some fields but not others despite being in the same format.
For instance, it calculates correctly for 'totalmanager' but fails for these:
headcountSchema.virtual('totalintl').get(function() {
return math.eval(this.m_intl + this.f_intl);
});
headcountSchema.virtual('totalmru').get(function() {
return math.eval(this.m_mru + this.f_mru);
});
When I try to display these values in my ejs file, nothing shows up:
<div class="four wide column grid ui statistic">
<div class="value">
<%=headcounts.totalmru%>
</div>
<div class="label">
Employees in Mru
</div>
Also, how do I handle divisions? When I add "" or (), the values become invalid and no calculation occurs. (Additionally, if I divide by a number, the number turns red)