#!/usr/bin/env python3
"""
generate_dashboard.py — builds dashboard.html from "Application Job Tracker.xlsx".
Re-runnable and importable:
CLI: python3 "generate_dashboard.py" -> writes dashboard.html
Server: import generate_dashboard; generate_dashboard.build() -> HTML string
Never modifies the xlsx. The generated page includes interactive controls
(status change, mark-applied) that work when the page is served by
serve_dashboard.py; opened as a plain file it degrades to read-only.
Requires: openpyxl (python3 -m pip install --user openpyxl)
"""
import html
import sys
from datetime import date, datetime
from pathlib import Path
try:
import openpyxl
except ImportError:
sys.exit("openpyxl is required. Run: python3 -m pip install --user openpyxl")
def _jobdash_data_dir(_default):
"""Pi deployment: use the Nextcloud data-dir copy of the Job Search folder
when jobdash_pi.json (written by deploy_to_pi.py) sits next to this script."""
try:
import json as _json
return Path(_json.loads(
(_default / "jobdash_pi.json").read_text())["data_dir"])
except Exception:
return _default
HERE = _jobdash_data_dir(Path(__file__).resolve().parent)
XLSX = HERE / "Application Job Tracker.xlsx"
OUT = HERE / "dashboard.html"
STAGES = ["Applied", "Screen", "Interview", "Onsite", "Final", "Offer",
"Rejected", "Ghosted", "Withdrawn"]
ODDS = ["High", "Medium", "Low"]
STAGE_CLASS = {
"applied": "b-blue", "screen": "b-amber", "phone screen": "b-amber",
"interview": "b-amber", "onsite": "b-amber", "final": "b-purple",
"offer": "b-green", "rejected": "b-red", "ghosted": "b-gray",
"withdrawn": "b-gray", "closed": "b-gray",
}
ODDS_CLASS = {"high": "b-green", "medium": "b-amber", "med": "b-amber", "low": "b-red"}
# ---------- helpers ----------
def esc(v):
return html.escape(str(v).strip()) if v is not None else ""
def iso(v):
if v is None:
return ""
if isinstance(v, (datetime, date)):
return v.strftime("%Y-%m-%d")
return str(v).strip()[:10]
def nice_date(s):
try:
return datetime.strptime(s, "%Y-%m-%d").strftime("%b %-d, %Y")
except Exception:
return s
def rows_of(ws):
"""Rows as dicts keyed by header, with '_row' = real worksheet row number."""
headers = [str(c.value).strip() if c.value else "" for c in ws[1]]
out = []
for i, r in enumerate(ws.iter_rows(min_row=2, values_only=True), start=2):
if not r or r[0] in (None, ""):
continue
d = dict(zip(headers, r))
d["_row"] = i
out.append(d)
return out
def badge_class(text, table, default="b-gray"):
return table.get(str(text or "").strip().lower(), default)
def dream_dots(score):
try:
n = max(0, min(5, int(score)))
except (TypeError, ValueError):
return ""
return ('%s'
% (n, n, '' * n + "" * (5 - n)))
def status_select(kind, current, options, row, company, sheet):
"""Badge-styled native