X-Git-Url: https://git.auder.net/js/rpsls.js?a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=b2a99e0571556c47e8cc41478aa3f57cb1988ac0;hb=cf742aaf8995ca8be8fc1f2751e4cf28de5d69b6;hp=a36ab683487fd7d9d6bc8761ee105536e0c9ca42;hpb=625022fdcf750f0aff8fcd699f7e9b89730e1d10;p=vchess.git diff --git a/server/models/User.js b/server/models/User.js index a36ab683..b2a99e05 100644 --- a/server/models/User.js +++ b/server/models/User.js @@ -1,7 +1,7 @@ var db = require("../utils/database"); -var maild = require("../utils/mailer.js"); var genToken = require("../utils/tokenGenerator"); var params = require("../config/parameters"); +var sendEmail = require('../utils/mailer'); /* * Structure: @@ -16,6 +16,24 @@ var params = require("../config/parameters"); const UserModel = { + checkNameEmail: function(o) + { + if (typeof o.name === "string") + { + if (o.name.length == 0) + return "Empty name"; + if (!o.name.match(/^[\w]+$/)) + return "Bad characters in name"; + } + if (typeof o.email === "string") + { + if (o.email.length == 0) + return "Empty email"; + if (!o.email.match(/^[\w.+-]+@[\w.+-]+$/)) + return "Bad characters in email"; + } + }, + // NOTE: parameters are already cleaned (in controller), thus no sanitization here create: function(name, email, notify, callback) { @@ -45,6 +63,16 @@ const UserModel = }); }, + getByIds: function(ids, cb) { + db.serialize(function() { + const query = + "SELECT id, name " + + "FROM Users " + + "WHERE id IN (" + ids + ")"; + db.all(query, cb); + }); + }, + ///////// // MODIFY @@ -96,6 +124,22 @@ const UserModel = db.run(query, cb); }); }, + + ///////////////// + // NOTIFICATIONS + + tryNotify: function(oppId, message) + { + UserModel.getOne("id", oppId, (err,opp) => { + if (!err || !opp.notify) + return; //error is ignored here (TODO: should be logged) + const subject = "vchess.club - notification"; + const body = "Hello " + opp.name + "!\n" + message; + sendEmail(params.mail.noreply, opp.email, subject, body, err => { + res.json(err || {}); + }); + }); + } } module.exports = UserModel;