From 41d919a53f1fe8acb9fdcd9b060831334e4aafed Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Wed, 6 Mar 2024 01:30:22 +0530
Subject: [PATCH] Transaction balance

---
 librevax.py                     | 8 +++++++-
 templates/transaction-view.html | 1 +
 2 files changed, 8 insertions(+), 1 deletion(-)

diff --git a/librevax.py b/librevax.py
index 26dd90d..1d623b3 100644
--- a/librevax.py
+++ b/librevax.py
@@ -324,7 +324,13 @@ def transaction_view(action, id=None):
                 (ok, item)=inventory.read(cursor, id)
                 if(not ok):
                     raise Exception(item)
-                return render_template("transaction-view.html", data=data, item=item, action=action)
+                balance=0
+                for entry in data:
+                    if(entry["action"]=="IN"):
+                        balance=balance+int(float(entry["target"]))
+                    elif(entry["action"]=="OUT"):
+                        balance=balance-int(float(entry["target"]))
+                return render_template("transaction-view.html", data=data, item=item, balance=balance, action=action)
             else:
                 raise Exception("Invalid parameter")
         elif(action=="view"):
diff --git a/templates/transaction-view.html b/templates/transaction-view.html
index 7805617..d99581e 100644
--- a/templates/transaction-view.html
+++ b/templates/transaction-view.html
@@ -27,6 +27,7 @@ You should have received a copy of the GNU General Public License along with Lib
     {% for rec in data %}
     <tr><td><a href="/transaction/view/{{rec["tid"]}}">{{rec["date"]|format_date}}</a></td><td><a href="/transaction/view/{{rec["tid"]}}">{{rec["action"]}}</a></td><td><a href="/transaction/view/{{rec["tid"]}}">{{rec["target"]}}</a></td></tr>
     {% endfor %}
+    <tr><th>Balance</th><td></td><td>{{balance}}</td></tr>
   </table>
 
   {% endif %}
-- 
2.39.5