expenses.js

var mysql = require('./db');
var transactionsBL = require('./bl/transactions');

exports.saveExpense = function() {
	return function(request, response) {
		transactionsBL.saveExpense(
			request.body.userId,
			request.body.expenseType,
			request.body.amount,
			request.body.creditDebit,
			request.body.date,
			request.body.description,
			request.body.labels,
			(error, rows, fields) => {
				if (error && error.status != 3) {
					console.log(error);
					response.status(500).send("Server error");
					return;
				} else if (error && error.status == 3) {
					console.log(error);
					response.status(200).send({
						"status": 3,
						"message": "Failed to attach labels"
					});
				} else {
					console.log("Expense added");
					response.status(200).send({
						"status": 0
					});
				}
			}
		);
	};
};

exports.getExpenses = function() {
	return function(request, response) {
		transactionsBL.getExpenses(request.query.userId, (error, rows, fields) => {
			if (error) {
				console.log(error)
				response.status(500).send("Server error");
			} else {
				response.status(200).send({
					"expenses": rows
				});
			}
		});
	};
};

exports.getExpenseTypes = function() {
	return function(request, response) {
		var queryString, queryData = [];
		queryString = prepareGetExpenseTypes(request.query.parentId);
		// connection.connect();
		if (request.query.parentId) {
			queryData = [request.query.parentId];
		}
		console.log(queryString, queryData);
		mysql.query(queryString, queryData, function(error, rows, fields) {
			if (error) {
				console.log(error);
				response.status(500).send("Server error");
			} else {
				console.log(rows);
				response.status(200).send({
					"status": 0,
					"expenseTypes": rows
				});
			}
		});
	};
};

function prepareGetExpenseTypes(subType) {
	return subType ? 
		'SELECT * FROM ExpenseType WHERE parentId=?' :
		'SELECT * FROM ExpenseType WHERE parentId IS NULL';
};

function prepareSaveExpense() {
	return 'INSERT INTO Expenses SET ?';
};

/*
 * parameters:
 *  expenseType
 *  amount
 *  date
 *  creditDebit
 *  transactionName
 *  description
 *  userId
 */
function prepareExpenseData(parameters) {
	var data = {
		"type": parameters.expenseType,
		"amount": parameters.amount,
		"credit_debit": parameters.creditDebit,
		"user": parameters.userId
	};

	if (parameters.date) {
		data.date = parameters.date;
	}

	if (parameters.transactionName) {
		data.transaction_name = parameters.transactionName;
	}

	if (parameters.description) {
		data.description = parameters.description;
	}

	return data;
};