subline/controllers/transactionData.js

const Transaction = require("../models/transaction");
const Purchase = require("../models/purchase");

module.exports = {
    getTransactions: function(req, res){
        if(!req.session.user){
            req.session.error = "You must be logged in to view that page";
            return res.redirect("/");
        }

        let date = new Date();
        let firstDay = new Date(date.getFullYear(), date.getMonth(), 1);
        let lastDay = new Date(date.getFullYear(), date.getMonth() + 1, 0);

        Transaction.find({merchant: req.session.user, date: {$gte: firstDay, $lt: lastDay}})
            .then((transactions)=>{
                return res.json(transactions);
            })
            .catch((err)=>{
                return res.json("Error: could not retrieve sales data");
            });
    },

    getPurchases: function(req, res){
        if(!req.session.user){
            req.session.error = "You must be logged in to view that page";
            return res.redirect("/");
        }

        Purchase.find({merchant: req.session.user})
            .then((purchases)=>{
                return res.json(purchases);
            })
            .catch((err)=>{
                return res.json("Error: could not retrieve purchases data");
            })
    }
}

// {merchant: req.session.user, date: {$gte: firstDay, $lt: lastDay}}