#!/usr/bin/env python3 """ Generate an HTML candidate review page from the latest CSV. Outputs to /var/www/drafts-preview/candidates.html """ import csv import sys from datetime import datetime, timezone from pathlib import Path CSV_PATH = Path(__file__).parent / "output" / f"candidates_{datetime.now(timezone.utc).strftime('%Y-%m-%d')}.csv" OUT_PATH = Path("/var/www/drafts-preview/candidates.html") def score_color(score: float) -> str: if score >= 0.8: return "#16a34a" # green elif score >= 0.6: return "#ca8a04" # yellow else: return "#6b7280" # gray def escape(text: str) -> str: return (text or "").replace("&", "&").replace("<", "<").replace(">", ">").replace('"', """) def main(): if not CSV_PATH.exists(): print(f"CSV not found: {CSV_PATH}", file=sys.stderr) sys.exit(1) with open(CSV_PATH) as f: rows = list(csv.DictReader(f)) today = datetime.now(timezone.utc).strftime("%Y-%m-%d") cards = [] for i, r in enumerate(rows, 1): score = float(r.get("score", 0)) color = score_color(score) name = escape(r.get("name", "Unknown")) title = escape(r.get("current_title", "")) company = escape(r.get("current_company", "")) location = escape(r.get("location", "")) url = escape(r.get("profile_url", "")) work = escape(r.get("work_history", "")) desc = escape(r.get("profile_description", "")) # Truncate description for card view desc_short = desc[:300] + "..." if len(desc) > 300 else desc cards.append(f"""

#{i} {score:.2f}

{name}

{title}

{company}

📍 {location or '—'}

' + desc_short + '

' if desc_short else ''} {'

Work History

' + work.replace(' | ', '
') + '

' if work else ''} View LinkedIn Profile →

""") html = f""" OpenTrack Co. — Sales Engineer Candidates ({today})

OpenTrack Co. — Sales Engineer Candidates

{len(rows)} candidates sourced and ranked on {today}

{''.join(cards)}

""" OUT_PATH.parent.mkdir(parents=True, exist_ok=True) with open(OUT_PATH, "w") as f: f.write(html) print(f"Written {len(rows)} candidates to {OUT_PATH}") if __name__ == "__main__": main()