From 4d0bd914e7c1ee65f4036e60149a7b891906a5d3 Mon Sep 17 00:00:00 2001
From: George Abbott <george@gabbott.dev>
Date: Tue, 31 Oct 2023 17:54:07 +0000
Subject: Commit all to date.

---
 web/ma-fmt-tbl | 73 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 73 insertions(+)
 create mode 100755 web/ma-fmt-tbl

(limited to 'web/ma-fmt-tbl')

diff --git a/web/ma-fmt-tbl b/web/ma-fmt-tbl
new file mode 100755
index 0000000..639ecf1
--- /dev/null
+++ b/web/ma-fmt-tbl
@@ -0,0 +1,73 @@
+#!/usr/bin/env ruby
+# Takes a file as first argument, and formats that table which should
+# be in tab delimited form with optional comment lines beginning with # 
+# into a table for HTML.
+# The second argument is a known quantity - because we also need to calculate
+# the final fields of each entry.
+
+def kph(time)
+  time = time.to_i
+  time_h = time / (60.0 * 60.0)
+  distance = 0.47
+  return distance / time_h
+end
+
+def mph(time)
+  return kph(time) * 0.6213712
+end
+
+if ARGV[0] == nil then 
+  puts "<!-- No argument passed! ma-fmt-tbl Exitting early. -->\n"
+  exit
+end
+
+
+table=""
+
+# Sort out the header.
+table << "<table>\n"
+table << "\t<tr class=\"header\">\n"
+table << "\t\t<th>Date</th>\n"
+table << "\t\t<th>Set</th>\n"
+table << "\t\t<th>Time Taken (s)</th>\n"
+table << "\t\t<th>Heart Rate (bpm)</th>\n"
+table << "\t\t<th>Stops</th>\n"
+table << "\t\t<th>Begin Time</th>\n"
+table << "\t\t<th>End Time</th>\n"
+table << "\t\t<th>Kph</th>\n"
+table << "\t\t<th>Mph</th>\n"
+table << "\t</tr>\n"
+
+
+# Now sort out the actual file.
+
+File.foreach(ARGV[0]).with_index do |line, line_num| 
+  next if line[0] == '#'
+  next if line == "\n" or line == "\t" or line == "" or line == " "
+  table << "\t<tr>\n"
+  line.split("\t").each do |entry|
+    table << ("\t\t<td>" + entry.delete("\n") + "</td>\n")
+  end
+
+  splits = line.split("\t")
+  splits_len = splits.length
+  time = splits[2]
+  kph_v = kph(time)
+  mph_v = mph(time)
+  while splits_len < 7
+    # In case any entries are missing, pad to that amount.
+    table << "\t\t<td></td>\n"
+    splits_len += 1
+  end
+
+  table << ("\t\t<td>" + kph_v.round(2).to_s + "</td>\n")
+  table << ("\t\t<td>" + mph_v.round(2).to_s + "</td>\n")
+
+  table << "\t</tr>\n"
+end
+
+table << "</table>\n"
+
+# Echo the file. 
+puts table
+
-- 
cgit v1.2.1