OrderController.js

var bodyParser = require('body-parser');
var db = require('../config/db.js');
var authorize = require(__dirname + '/authorize.js');

module.exports = function (app) {
    //Find all orders by username
    app.get('/api/orders', function (req, res) {
        authorize(req)
        .then(function (foundUser) {
            db.orders.findAll({where: {userId: foundUser.id}})
                .then(function (orders) {
                    res.json({message: 'OK', body: orders});
                });
        }), function (err) {
            res.status(200).send('User not found');
        }
    });

    //Add new order
    app.post('/api/order', function (req, res) {
        authorize(req).then(function (foundUser) {
            var newOrder = {};
            newOrder.startDate = req.body.startDate;
            newOrder.stopDate = req.body.stopDate;
            var parkPriceRate = 1;
            newOrder.price = parkPriceRate;
            var parkTotalMin = (req.body.stopDate - req.body.startDate) / 1000 / 60;
            var parkRegPeriod = parkTotalMin / 30;
            parkRegPeriod = Math.round(parkRegPeriod);
            newOrder.totalPrice = parkRegPeriod * parkPriceRate;
            newOrder.userId = foundUser.id;
            db.orders.create(newOrder).then(function (order) {
                db.orders.findAll({where: {userId: foundUser.id}})
                    .then(function (orders) {
                        var ordersList = [];
                        orders.forEach(function (item, i, arr) {
                            var order = {};
                            order.id = item['id'];
                            order.startDate = item['startDate'];
                            order.stopDate = item['stopDate'];
                            order.price = item['price'];
                            order.totalPrice = item['totalPrice'];
                            ordersList.push(order);
                        })
                        res.json({message: 'order added', body: ordersList});
                    });
            });
        }), function (err) {
            res.status(200).send('User not found');
        }
    })
}