userHandler.js

const { Parser } = require('@json2csv/plainjs'); // Library to create CSV for output

exports.insertUser = function(res,dbo,profile) {
	profile.suspended = false;
	profile.userType = "user";
	var dbConnect = dbo.getDb();
	dbConnect
      .collection("Users")
      .insertOne(profile);
}

exports.updateLastLoginTime = function(res,dbo,email) {
	var date = new Date().toISOString();
	var dbConnect = dbo.getDb();
	dbConnect
      .collection("Users")
      .updateOne({'emails.0.value': email}, { $set: { lastLogin: date }});
}

exports.getUsers = function(req,res,dbo,format) {
	var dbConnect = dbo.getDb();
	dbConnect
      .collection("Users")
      .find()
      .toArray(function(err,items) {
      	if (format=="text/csv") {
			const parser = new Parser({ header: true });
	        const csv = parser.parse(makeCSVOutput(items));
    	    res.set('Content-Type', 'text/csv');
        	res.send(csv);
		} else {
			res.set('Content-Type', 'application/json');
	        res.send(JSON.stringify(items, null, 4));
		}
      });
}
exports.getUser = function(req,res,dbo,id,format) {
	var dbConnect = dbo.getDb();
	dbConnect
      .collection("Users")
      .find({'id': id})
      .toArray(function(err,items) {
      	if (format=="text/csv") {
			const parser = new Parser({ header: true });
	        const csv = parser.parse(makeCSVOutput(items[0]));
    	    res.set('Content-Type', 'text/csv');
        	res.send(csv);
		} else {
			res.set('Content-Type', 'application/json');
	        res.send(JSON.stringify(items[0], null, 4));
		}
      });
}
exports.updateUser = function(req,res,dbo,id) {
	var updateRole = req.body.Role;
	var updateSuspended = req.body.Suspended;
	var dbConnect = dbo.getDb();
	dbConnect
      .collection("Users")
      .updateOne({'id': id}, { $set: { suspended: updateSuspended, userType: updateRole }},
      function(err,result) {
      	res.locals.pageTitle = "Edit user";
      	res.render('pages/editUserProfile', {userid: id, msg: "User updated"});
      });
}

function makeCSVOutput(users) {
	var output = [];
	for(i=0;i<users.length;i++) {
		var user = {};
		user = users[i]._json;
		user.suspended = users[i].suspended;
		user.type = users[i].userType;
		user.lastLogin = users[i].lastLogin;
		output.push(user);
	}
	console.log(output);
	return output;

}