ConstructionCost/modules/fees/models/fees_db.js

/**
 * Created by CSL on 2017-03-29.
 */

var mg = require('mongoose');
var dbm = require("../../../config/db/db_manager");
var umDB = dbm.getCfgConnection("projectFees");

var ratesSchema = new mg.Schema({
    ID: Number,
    ParentID: Number,
    name: String,
    rate: Number,
    memo: String
});

var feeRatesSchema = new mg.Schema({
    ID: Number,
    libID: Number,
    libName: String,
    rates: [ratesSchema]
});

var feeRatesModel = umDB.model('feeRates', feeRatesSchema, 'feeRates');

var FeeRateFile = function(){};

FeeRateFile.prototype.rates = function(fileID, controllerFun){
    feeRatesModel.find({"ID": fileID}, ["rates"], function(err, data){
        if(data.length){
            controllerFun(data);
        }
        else{
            controllerFun(false);
        }
    })
};

module.exports = new FeeRateFile();