Include more monetary information in reports.

[iron-blogger] / render.py

diff --git a/render.py b/render.py
index f8cdd7a93e54ef57de46a68278066fee4a8bb664..0a7bf46f488d68095a370ac722467aa8631d2c82 100755 (executable)
--- a/render.py
+++ b/render.py
@@ -5,9 +5,12 @@ import datetime
 import dateutil.tz as tz
 import sys
 import os
+import os.path
+import subprocess
 from mako.template import Template
 
 START = datetime.datetime(2009, 12, 21, 6)
+HERE  = os.path.dirname(__file__)
 
 def render_template(path, week=None):
     with open('out/report.yml') as r:
@@ -37,6 +40,9 @@ def render_template(path, week=None):
         u.username = un
         u.links = rec['links']
         u.start = rec['start']
+        u.end   = rec.get('end')
+        u.skip  = [(parse(x, default=START) - START).days / 7
+                   for x in rec.get('skip', [])]
         u.weeks = report.get(un, [])
 
         userlist.append(u)
@@ -48,16 +54,42 @@ def render_template(path, week=None):
 
     for u in userlist:
         user_start = parse(u.start, default=START)
-        if user_start > week_start:
+        if u.end and parse(u.end, default=START) <= week_start:
+            continue
+
+        if week in u.skip:
+            pass
+        elif user_start > week_start:
             skip.append(u)
         elif len(u.weeks) <= week or not u.weeks[week]:
             lame.append(u)
         else:
             good.append(u)
 
+    def get_balance(acct):
+        p = subprocess.Popen(['ledger', '-f', os.path.join(HERE,'ledger'),
+                              '-n', 'balance', acct],
+                             stdout=subprocess.PIPE)
+        (out, _) = p.communicate()
+        return int(out.split()[0][1:])
+
+    p = subprocess.Popen(['ledger', '-f', os.path.join(HERE,'ledger'),
+                          '-n', 'balance', 'Pool:Owed:'],
+                         stdout=subprocess.PIPE)
+    (out, _) = p.communicate()
+    debts = []
+    for line in out.split("\n"):
+        if not line: continue
+        (val, acct) = line.split()
+        user = acct[len("Pool:Owed:"):]
+        val  = int(val[len("$"):])
+        debts.append((user, val))
+
     return Template(filename=path, output_encoding='utf-8').render(
         week=week, week_start=week_start,week_end=week_end,
-        good=good, lame=lame, skip=skip, userlist=userlist)
+        good=good, lame=lame, skip=skip, userlist=userlist,
+        pool=get_balance('Pool'), paid=get_balance('Pool:Paid'),
+        debts=debts)
 
 if __name__ == '__main__':
     if len(sys.argv) < 2: