From 2f18ab0b0fdf1923bda92723866cd9946c323786 Mon Sep 17 00:00:00 2001
From: Ranabir Guin <ran@Ranabirs-MacBook-Pro.local>
Date: Fri, 14 May 2021 23:10:21 -0700
Subject: tweak admin route queries

---
 routes/admin.js | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'routes/admin.js')

diff --git a/routes/admin.js b/routes/admin.js
index b17e5aa4..b691dcbc 100644
--- a/routes/admin.js
+++ b/routes/admin.js
@@ -39,8 +39,9 @@ router.get(
 router.get(
   "/accounts",
   ah(async (req, res) => {
-    var accounts = await db.Accounts.findAll({
-      include: [ db.User ]
+    var accounts = await db.Account.findAll({
+      include: [
+        { model: db.User, as: 'User' ]
     })
 
     debug('accounts: ' + JSON.stringify(accounts))
@@ -65,7 +66,11 @@ router.get(
   "/user_transactions",
   ah(async (req, res) => {
     var transactions = await db.User.findAll({
-      include: [ db.Invoice, db.Payment, db.Order ]
+      include: [
+        { model: db.Invoice, as: 'Invoices' },
+        { model: db.Payment, as: 'Payments' },
+        { model: db.Order, as: 'Orders'
+      ]
     })
 
     debug('transactions: ' + JSON.stringify(transactions))
-- 
cgit v1.2.3