router.get('/dashboard', function(req, res) {
    verifyLogin(req, function(loggedIn, userObj, uid) {
        if (loggedIn) {
            console.log("steppp 1 " + JSON.stringify(userObj));
            var soldProducts = [];
            var boughtProducts = [];
            var sellerProducts = [];




            //TODO POST BETA UNCOMMENT SO USERS HAVE TO SELECT A PLAN - also still need to change above to mongo

            // if (userObj.chosenPlan == false) {
            //     res.redirect('/subscribe');
            // } else {
            var totalCreds = userObj.totalCredits;
            var totalPurchases = totalCreds + userObj.creditsProcessing;
            var totalSales = totalCreds - userObj.creditsAvailable;

            userObj['totalPurchases'] = totalPurchases;
            userObj['totalSales'] = totalSales;


            grabListedProducts();
            // }

            function grabListedProducts() {

                var qSelect = "SELECT title, picture, price, dailySalesCount, dailySalesLimit, totalSalesCount, sellStartDate, sellEndDate, paused FROM PRODUCT WHERE sellerId = ?";
                var qValues = [uid];
                var qCall = mysql.format(qSelect, qValues);

                connection.query(qCall, function(err, sellerProducts, fields) {
                    if (err) {
                        console.log("get dashboard products: " + err);

                        return res.json({ statusCode: alertErrors.mysql });
                    } else {
                        grabTransactions(sellerProducts);

                    }
                });

            }

            function grabTransactions(sellerProducts) {


                var qSelect = "SELECT title, price, orderId, datePurchased, status FROM PURCHASE WHERE sellerId = ? AND status BETWEEN 1 AND 4";
                var qValues = [uid];
                var qCall = mysql.format(qSelect, qValues);

                connection.query(qCall, function(err, purchaseProducts, fields) {
                    if (err) {
                        console.log("get dashboard transactions: " + err);

                        return res.json({ statusCode: alertErrors.mysql });
                    }

                    sendResponse(purchaseProducts);


                });

                connection.end();

                function sendResponse() {
                       return res.render('dashboard', {
                            title: titleOfPage,
                            loggedIn: loggedIn,
                            userInfo: userObj,
                            sellerProducts: sellerProducts,
                            productTransactions: purchaseProducts
                        });

                }
            }

        } else {
            takeToLogin(res);
        }
    });


});