From 7d5a9b5a8f82fc4b6c2849dfb5b7f27a2b54a912 Mon Sep 17 00:00:00 2001
From: Adam Soltys <asoltys@gmail.com>
Date: Wed, 2 Nov 2022 19:58:00 -0700
Subject: set with_id

---
 db/models/payments.js | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'db')

diff --git a/db/models/payments.js b/db/models/payments.js
index b3ac0b74..fac8ff56 100644
--- a/db/models/payments.js
+++ b/db/models/payments.js
@@ -11,6 +11,15 @@ const attributes = {
     comment: null,
     field: "id"
   },
+  with_id: {
+    type: DataTypes.INTEGER(11),
+    allowNull: true,
+    defaultValue: null,
+    primaryKey: false,
+    autoIncrement: false,
+    comment: null,
+    field: "with_id"
+  },
   account_id: {
     type: DataTypes.INTEGER(11),
     allowNull: true,
-- 
cgit v1.2.3


From da2a1713b13b31310843136eeaabe524c4eee42c Mon Sep 17 00:00:00 2001
From: Adam Soltys <asoltys@gmail.com>
Date: Thu, 3 Nov 2022 01:28:29 -0700
Subject: with relation

---
 db/index.js        | 5 +++++
 routes/payments.js | 5 +++++
 2 files changed, 10 insertions(+)

(limited to 'db')

diff --git a/db/index.js b/db/index.js
index 8c94a4d3..81c0fe46 100644
--- a/db/index.js
+++ b/db/index.js
@@ -124,6 +124,11 @@ Payment.belongsTo(Payment, {
   foreignKey: "fee_payment_id"
 });
 
+Payment.belongsTo(User, {
+  as: "with",
+  foreignKey: "with_id"
+});
+
 db.Order = Order;
 
 export default db;
diff --git a/routes/payments.js b/routes/payments.js
index 678b646c..999cba36 100644
--- a/routes/payments.js
+++ b/routes/payments.js
@@ -125,6 +125,11 @@ app.get("/payments", auth, async (req, res) => {
       model: db.Account,
       as: "account"
     },
+    include: {
+      attrs: ["username", "profile"],
+      model: db.User,
+      as: "with"
+    },
     limit,
     offset
   });
-- 
cgit v1.2.3