function updateQueryTwo(callbackFour) {
if (allClear && !isDuplicate) {
var currentDate = new Date();
var year = currentDate.getFullYear();
var month = conversions.twoDigitMonth(currentDate.getMonth());
var day = currentDate.getDate();
var milHours = conversions.convertHour(currentDate.getHours());
var minutes = conversions.convertMinute(currentDate.getMinutes());
var seconds = conversions.convertSecond(currentDate.getSeconds());
var formattedDate = year+'-'+month+'-'+day+' '+milHours+':'+minutes+':'+seconds;
connection.query('UPDATE jury_food_request SET cancelled_datetime = "'+year+'-'+month+'-'+day+' '+milHours+':'+minutes+':'+seconds+'" WHERE id='+numbers.toString()+' and random_alpha="'+letters.toString()+'"', function(err, result) {
if (err) {
console.log("FAILED TWO");
allClear = false;
} else {
console.log(result);
console.log('CANCEL TIME UPDATED');
}
callbackFour();
});
} else {
callbackFour();
}
};
exports.updateDatabase = function(info) {
var connection = mysql.createConnection({
host : 'SAppD',
user : '******',
password : '******',
database : 'jury_food'
});
connection.connect();
var refreshmentReq = {
delivery_date : info.year + '-' + conversions.twoDigitMonth(info.month) + '-' + info.day,
quantity :info.quantity,
date_entered: new Date(),
last_modified: new Date()
}
var runQuery = function() {
connection.query('INSERT INTO jury_food_refreshments SET ?', refreshmentReq ,function(err, result) {
emailer.sendEmail(info, result.insertId);
if (err) {
console.log(err);
} else {
console.log(result);
}
});
};
runQuery();
console.log('Processed Refreshment');
//window.location = "/html/successPage.html";
}; //end updateDatabase function