以mongodb报道(Reporting in mongodb)

 我在first节点应用程序中report generating 。 我用mongodb和express 。 我有三个集合： salary rule ， Leave和Employee 。 我想通过使用这些集合来生成employees salary 。 
 
 我发现phantomjs导出pdf。 我用ejs模板生成html。 
 
 我从以下场景中获得了json值。 
 
 
 
 找工资规则 
 
 
 找到所有员工 
 
 
 按日期范围查找所有叶子。 
 
 
 按员工ID匹配员工和离职并计算薪水。 
 
 
 将结果json放入数组并通过ejs生成html 
 
 
 使用phantomjs将html导出为pdf。 
 
 
 我很困惑，这种情况可能会hit performance和error-prone 。 我在node和mongodb找不到任何合适的导出示例。 
 
 我的问题是 - 
 
 
 
 在这种情况下使用mongodb或者它是normal flow是不是一个bad idea ？ 
 
 
 或者我是否需要更改我的mongodb collection schema ？ 
 
 
 离开 
 
var schema = new mongoose.Schema({
    date: { type: Date, default: Date.now },
    description: String,
    type: String, // paid or unpaid
    empName : String,
    empId : String
});
 
 雇员 
 
var schema = new mongoose.Schema({
    id: String,
    name: String,
    basicSalary: Number,
    active: Boolean
});
 
 薪资规则 
 
var schema = new mongoose.Schema({
    totalHoliday: Number,
    overtimeFee: Number,
    unpaidLeaveFee: Number
});

I have report generating in my first node application. I used mongodb and express. I have three collections: salary rule, Leave and Employee. I want to generate employees salary by using these collections. 
 
I found phantomjs to export pdf. I used ejs template to generate html.
 
I got json values from the following scenario.
 
 
 
find Salary rule
 
 
find All Employees
 
 
find all Leaves by date range.
 
 
Match employees and leaves by employee id and calculate the salary.
 
 
put the result json into the array and generate html by ejs
 
 
export html to pdf by using phantomjs.
 
 
I am confused that this scenario could be hit performance and error-prone. I cannot find any suitable examples for exporting in node and mongodb.
 
My question is-
 
 
 
Is it bad idea to use mongodb in this scenario or is it normal flow? 
 
 
Or do I need to change my mongodb collection schema?
 
 
Leave
 
var schema = new mongoose.Schema({
    date: { type: Date, default: Date.now },
    description: String,
    type: String, // paid or unpaid
    empName : String,
    empId : String
});
 
Employee
 
var schema = new mongoose.Schema({
    id: String,
    name: String,
    basicSalary: Number,
    active: Boolean
});
 
Salary Rule
 
var schema = new mongoose.Schema({
    totalHoliday: Number,
    overtimeFee: Number,
    unpaidLeaveFee: Number
});

原文：https://stackoverflow.com/questions/39617663