kinda working time overview script

5 files changed, 125 insertions, 13 deletions

diff --git a/.gitignore b/.gitignore
index efdebb8..efae07a 100644
--- a/.gitignore
+++ b/.gitignore
@@ -25,6 +25,7 @@
 *.d
 *.nav
 *.snm
+*-SAVE-ERROR
 
 # output files
 *.pdf
diff --git a/makefile b/makefile
index 6c234ba..02c583e 100644
--- a/makefile
+++ b/makefile
@@ -12,3 +12,5 @@ LATEXMKFLAGS += -interaction=nonstopmode
 %.tex: %.txt
 	./time2tex.py $< > $@
 
+timerep.pdf: time.tex
+
diff --git a/time.txt b/time.txt
index c80fabf..2d38f62 100644
--- a/time.txt
+++ b/time.txt
@@ -1,13 +1,13 @@
 # <who>: <when> <how long> <what>
 loek: 2024-09-02 1h4m repository scaffolding
 loek: 2024-09-03 25m repository scaffolding
-loek: 2024-09-03 1h30m repository scaffolding / engine repository, unit testing
-loek: 2024-09-04 1h30m repository scaffolding / latex example code
-loek: 2024-09-04 50m poc / dynamic library linking test example
-loek: 2024-09-04 45m repository scaffolding / visual studio code latex configuration
-loek: 2024-09-04 20m repository scaffolding / visual studio code cmake configuration
-loek: 2024-09-05 15m repository scaffolding / additional latex contributing guidelines
+loek: 2024-09-03 1h30m repository scaffolding :: engine repository, unit testing
+loek: 2024-09-04 1h30m repository scaffolding :: latex example code
+loek: 2024-09-04 50m poc :: dynamic library linking test example
+loek: 2024-09-04 45m repository scaffolding :: visual studio code latex configuration
+loek: 2024-09-04 20m repository scaffolding :: visual studio code cmake configuration
+loek: 2024-09-05 15m repository scaffolding :: additional latex contributing guidelines
 loek: 2024-09-05 1h40m project meeting
+loek: 2024-09-05 1h24m time report script
 
 # vim:ft=cfg
-
diff --git a/time2tex.py b/time2tex.py
index 3244b8f..6c8b097 100755
--- a/time2tex.py
+++ b/time2tex.py
@@ -1,17 +1,126 @@
 #!/bin/python3
 import sys
+from datetime import datetime
 
+def fmt_duration(sec):
+  mins = (sec + 59) // 60 # integer divide, round up
+  out = []
 
-if __name__ == "__main__":
-  if len(sys.argv) != 2:
-    print("usage: time2tex <input>")
-    exit(1)
+  if mins == 0:
+    return "--"
+
+  hour = mins // 60
+  if hour > 0:
+    out.append("%02dh" % (hour, ))
+    mins = mins % 60
+
+  out.append("%02dm" % (mins, ))
+
+  return "\\,".join(out)
+
+def fmt_member_overview(times):
+  members = {}
+  total_time = 0
+  for time in times:
+    if not time["name"] in members:
+      members[time["name"]] = 0
+    members[time["name"]] += time["duration"]
+    total_time += time["duration"]
+  print("""\\section{Member overview}\n
+\\begin{table}
+\\centering
+\\begin{tabular}{lr}
+\\toprule
+\\textbf{Member} & \\textbf{Tracked}\\\\
+\\midrule""")
+  for name, tracked in members.items():
+    print(f"{name} & {fmt_duration(tracked)}\\\\")
+  print("\\midrule")
+  print(f"& sum\\quad {fmt_duration(total_time)}\\\\")
+  print("""\\bottomrule
+\\end{tabular}
+\\caption{Tracked time per group member}
+\\label{tab:time-member}
+\\end{table}""")
+
+def duration2secs(duration):
+  out = 0 # output (seconds)
+  cur = 0 # current figure (unknown)
+  for c in duration:
+    if c.isdigit():
+      cur = cur * 10 + int(c)
+      continue
+    if c == "h":
+      out += cur * 3600
+      cur = 0
+      continue
+    if c == "m":
+      out += cur * 60
+      cur = 0
+      continue
+    if c == "s":
+      out += cur * 1
+      cur = 0
+      continue
+
+    raise Exception("invalid duration format")
+  if cur != 0: raise Exception("invalid duration format")
+  return out
+
+def line2data(line):
+  # parse fields from input string
+  data = {}
+  next = line.find(':')
+  data["name"] = line[0:next].strip()
+  line = line[next+1:].strip()
+  next = line.find(' ')
+  data["date"] = line[0:next].strip()
+  line = line[next+1:].strip()
+  next = line.find(' ')
+  data["duration"] = line[0:next].strip()
+  line = line[next+1:].strip()
+  data["description"] = line
 
+  # deserialize parsed fields
+  data["name"] = data["name"].title()
+  data["date"] = datetime.strptime(data["date"], '%Y-%m-%d')
+  data["duration"] = duration2secs(data["duration"])
+  data["description"] = [el.strip() for el in data["description"].split("::")]
+
+  return data
+
+def parse(content):
+  # split content at newlines
+  lines = content.split("\n")
+  out = []
+  for i, line in enumerate(lines):
+    line = line.strip()
+    if line.startswith("#"): continue
+    if len(line) == 0: continue
+
+    try: out.append(line2data(line))
+    except Exception as e: raise Exception(f"line {i+1}: {e}")
+  return out
+
+def fmt(times):
+  fmt_member_overview(times)
+
+def main():
   input_file = sys.argv[1]
   content = ""
   with open(input_file, "r") as file:
     content = file.read()
-  parsed = parse(content)
 
+  try: parsed = parse(content)
+  except Exception as e:
+    print(f"{input_file}: {e}")
+    exit(1)
 
+  fmt(parsed)
+
+if __name__ == "__main__":
+  if len(sys.argv) != 2:
+    print("usage: time2tex <input>")
+    exit(1)
+  main()
 
diff --git a/timerep.tex b/timerep.tex
index dfde932..7590217 100644
--- a/timerep.tex
+++ b/timerep.tex
@@ -5,7 +5,7 @@
 
 \begin{document}
 
-AHOIHJSAIDHOISAJDSAJDJAOIS
+\input{time.tex}
 
 \end{document}