From 07252d14b8ac2f6f2d50c3ce3a33832365587f92 Mon Sep 17 00:00:00 2001
From: Ran Guin <rguin@iMac.local>
Date: Fri, 14 May 2021 20:38:11 -0700
Subject: add accounts call

---
 routes/admin.js | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

diff --git a/routes/admin.js b/routes/admin.js
index 3427888e..135ca8f6 100644
--- a/routes/admin.js
+++ b/routes/admin.js
@@ -32,4 +32,34 @@ router.get(
   })
 );
 
+// usage:  GET '/accounts'
+//
+// Returns: 
+//    { referrals: <list of referral tokens> }
+router.get(
+  "/accounts",
+  ah(async (req, res) => {
+    var referrals = await db.User
+      .findAll({
+        attributes: ['users.id', 'accounts.balance'],
+        where: {
+          '$accounts.user_id$' : '$users.id$'
+          // user_id: users.id
+          // $or: [
+          //     {'$accounts.user_id$' : $users.id$},
+          // ]
+        },
+        include: [
+          {
+            model: Account,
+            required: false
+          }
+        ]
+      });
+
+    debug('balances: ' + JSON.stringify(balances))
+    return res.send({accounts: balances})
+  })
+);
+
 module.exports = router;
-- 
cgit v1.2.3