From b75a06ea0dadcb7ad2416e900e15276661e065be Mon Sep 17 00:00:00 2001 From: Adam Soltys Date: Thu, 26 Mar 2020 10:19:58 -0700 Subject: filter payments --- routes/payments.js | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'routes') diff --git a/routes/payments.js b/routes/payments.js index 7cb51d02..0e829029 100644 --- a/routes/payments.js +++ b/routes/payments.js @@ -1,5 +1,6 @@ const BitcoinCore = require("bitcoin-core"); const lnd = require("../lib/lnd"); +const { Op } = require("sequelize"); (async () => { bc = new BitcoinCore(config.bitcoin); @@ -37,7 +38,15 @@ const lnd = require("../lib/lnd"); app.get("/payments", auth, async (req, res) => { const payments = await db.Payment.findAll({ - where: { user_id: req.user.id }, + where: { + user_id: req.user.id, + [Op.or]: { + received: true, + amount: { + [Op.lt]: 0, + }, + }, + }, order: [["id", "DESC"]] }); -- cgit v1.2.3