Here is my entire code, and what I want to avoid are all the moveAllBank, moveAllReceipt moveAllExpense functions if possible. The code below works fine, I just wish there was a smarter way of doing it. Its really hard to understand how the different promises passes data between each other.
//
// Find all bank accounts
//
var bankModel = require('../models/bankModel');
var bankTable = mongoose.model('bankModel');
var bankArray = [];
var findAllBank = new Promise(
(resolve, reject) => {
bankTable.find({}
,function(err, data) {
if (!err) {
resolve(data);
} else {
reject(new Error('findBank ERROR : ' + err));
}
});
});
let moveAllBank = function (data) {
bankArray = data;
console.log("receiptArray Result: " + JSON.stringify(data, null, 4));
};
//
// Find the RECEIPT for each bank account
//
var receiptModel = require('../models/receiptModel');
var receiptTable = mongoose.model('receiptModel');
var receiptArray = [];
let findAllReceipts = function (accountArray) {
return Promise.all(bankArray.map(findReceipts));
};
function findReceipts(account) {
return new Promise((resolve, reject) => {
receiptTable.find({account: account._id}, function (err, data) {
if (!err) {
console.log("findReceipts Result: " + JSON.stringify(data, null, 4));
resolve(data);
} else {
reject(new Error('findReceipts ERROR : ' + err));
}
});
});
}
let moveAllReceipt = function (data) {
receiptArray = data;
console.log("receiptArray Result: " + JSON.stringify(data, null, 4));
};
//
// Find the EXPENSE for each bank account
//
var expenseModel = require('../models/expenseModel');
var expenseTable = mongoose.model('expenseModel');
var expenseArray = [];
let findAllExpense = function (accountArray) {
console.log("=====EXPENSE====")
console.log("accountArray Result: " + JSON.stringify(accountArray, null, 4));
return Promise.all(bankArray.map(findExpense));
};
function findExpense(account) {
return new Promise((resolve, reject) => {
expenseTable.find({account: account._id}, function (err, data) {
if (!err) {
console.log("findExpense Result: " + JSON.stringify(data, null, 4));
resolve(data);
} else {
reject(new Error('findExpense ERROR : ' + err));
}
});
});
}
let moveAllExpense = function (data) {
expenseArray = data;
console.log("expenseArray Result: " + JSON.stringify(data, null, 4));
};
//
// Send the result
//
let sendResult = function (data) {
res.json({error:false, "bank":bankArray, "receipt":receiptArray, "expense":expenseArray})
};
//
// Run the promises
//
findAllBank
.then(moveAllBank)
.then(findAllReceipt)
.then(moveAllReceipt)
.then(findAllExpense)
.then(moveAllExpense)
.then(sendResult)
.catch(err => {
console.error(err);
console.log("getbankAccountReport ERR: " + err);
res.json({error:true,err})
});