JSFiddle - React, Tailwind, and code Playground
JavaScript
function sendGame(req, res, sales, settings, categories) {
var game = new Object();
game.sales = sales;
game.settings = settings;
game.categories = categories;
JSONgame = JSON.stringify(game);
res.writeHead(200, {
'Access-Control-Allow-Origin': 'http://localhost',
'Content-Length': JSONgame.length,
'Content-Type': 'application/json'
});
res.write(JSONgame);
res.end();
console.log('Game: ' + JSON.stringify(game, null, 4));
console.log('--------------------------------------');
console.log('User ' + req.body.username + ' successfully retrieved game!');
}
function retrieveSales(req, connection, timeFrame) {
console.log('User ' + req.body.username + ' retrieving sales...');
connection.query('select * from sales_entries where date BETWEEN ? AND ?', timeFrame,
function (err, rows, fields) {
if (err) {
callback(new Error('Failed to connect'), null);
} else {
sales = [];
for (x = 0; x < rows.length; x++) {
sales.push(rows[x]);
}
//console.log('Sales: ' + JSON.stringify(sales, null, 4));
return sales;
}
});
}
function retrieveSettings(req, connection) {
console.log('User ' + req.body.username + ' retrieving settings...');
connection.query('select * from sales_settings',
function (err, rows, fields) {
if (err) {
callback(new Error('Failed to connect'), null);
} else {
settings = [];
for (x = 0; x < rows.length; x++) {
settings.push(rows[x]);
}
//console.log('Settings: ' + JSON.stringify(settings, null, 4));
return settings;
}
});
}
function retrieveCategories(req, connection) {
console.log('User ' + req.body.username + ' retrieving categories...');
connection.query('select * from sales_categories',
function (err, rows,...