diff options
Diffstat (limited to 'lib/utils.js')
| -rw-r--r-- | lib/utils.js | 79 |
1 files changed, 53 insertions, 26 deletions
diff --git a/lib/utils.js b/lib/utils.js index 7784ae5c..7b4b1668 100644 --- a/lib/utils.js +++ b/lib/utils.js @@ -1,30 +1,57 @@ const { Op } = require("sequelize"); -module.exports = { - async getUser(username) { - return db.User.findOne({ - include: [ - { - model: db.Payment, - as: "payments", - order: [["id", "DESC"]], - where: { - [Op.or]: { - received: true, - amount: { - [Op.lt]: 0 - } +getUser = async username => { + return db.User.findOne({ + include: [ + { + model: db.Payment, + as: "payments", + order: [["id", "DESC"]], + where: { + [Op.or]: { + received: true, + amount: { + [Op.lt]: 0 } - }, - limit: 12 + } }, - { - model: db.Account, - as: "accounts" - } - ], - where: - { [Op.or]: { username, id: username }} - }); - } -}; + limit: 12 + }, + { + model: db.Account, + as: "accounts" + }, + { + model: db.Account, + as: "account" + } + ], + where: { username }, + }); +} + +getUserById = async id => { + return db.User.findOne({ + include: [ + { + model: db.Payment, + as: "payments", + order: [["id", "DESC"]], + where: { + [Op.or]: { + received: true, + amount: { + [Op.lt]: 0 + } + } + }, + limit: 12 + }, + { + model: db.Account, + as: "accounts" + } + ], + where: { id } + }); +} |
