"""board_dump.py DAY -- [2026-10-28] the user: "the stock board should be filled each minute for each stock in the simulator, and those are the
results to use as the reference to buy". Writes the board EXACTLY as the simulator (board_test*.py) fills it -- same library data (old-score top 30
1-min bars, quote flow, pm_history premarket high), same stock_board.Board -- one row per stock per minute 9:30-11:45:
  reports/board/<DAY>/<SYM>.csv  +  reports/board/<DAY>/index.html (every stock, every minute, buy signals highlighted, what happened after)."""
import gzip, json, sys, csv, html
from pathlib import Path
TR = Path("/var/www/screener/trade"); sys.path.insert(0, str(TR / "reports/playbook")); sys.path.insert(0, str(TR))
import v2_bar_replay as R
import stock_board as SB
from opening_patterns import CATALOG
day = sys.argv[1]; OUT = TR / f"reports/board/{day}"; OUT.mkdir(parents=True, exist_ok=True)
hm = lambda m: f"{9 + (30 + m) // 60}:{(30 + m) % 60:02d}"
d = json.load(gzip.open(R.OW / "bars" / f"bars_{day}.json.gz", "rt")); pp = R.OW / f"pm_history/{day}.json.gz"
pmh = {r["s"]: r.get("pm_high") for r in json.load(gzip.open(pp, "rt"))["rows"]} if pp.exists() else {}
cols = ["time", "close", "resistance", "support", "range_%", "position", "vol_accel", "buy_3m", "buy_15m", "3m_rising", "15m_rising", "vwap", "vs_vwap_%", "vwap_slope_%", "patterns_new", "board_state", "BUY"]
sections = []; summary = []
for s in d["top30_current"]:
    fp = R.OW / "flow" / day / f"{s}.json"; ref = R.REF.load(day, s)
    if s not in d["symbols"] or not fp.exists() or not ref or not ref.get("prev_close") or not ref.get("atr14"): continue
    bars = [x for x in R.bars_of(d["symbols"][s]["bars"]) if 0 <= R.minute(x["t"]) < 390]
    if len(bars) < 150: continue
    fl = json.loads(fp.read_text()); B = SB.Board(ref["prev_close"], ref["atr14"], bars[0]["o"], pm_high=pmh.get(s)); rows = []; buys = []
    for i, x in enumerate(bars[:-1]):
        t = R.minute(x["t"])
        if t > 135: break
        r = B.update(x, t, fl["buy"][t], fl["sell"][t])
        rows.append([hm(t), r["c"], r["res"], r["sup"], r["range_pct"], r["pos"], r["vacc"], round(r["s3"] * 100), round(r["s15"] * 100), r["s3_up"], r["s15_up"],
                     r["vwap"], r["vs_vwap"], r["vwap_slope"], " ".join(f"#{p}" for p in r["new"]), r["state"], "BUY" if r["buy"] else ""])
        if r["buy"]:
            P = bars[i + 1]["o"]; nb = bars[i + 1:i + 61]
            up = (max(z["h"] for z in nb) / P - 1) * 100; dn = (min(z["l"] for z in nb[:30]) / P - 1) * 100; c15 = (nb[min(14, len(nb) - 1)]["c"] / P - 1) * 100
            buys.append((hm(t), hm(t + 1), P, B.buys[-1]["pid"], up, dn, c15))
    with open(OUT / f"{s}.csv", "w", newline="") as fh:
        w = csv.writer(fh); w.writerow(cols); w.writerows(rows)
    summary.append((s, len(rows), buys))
    trs = "".join("<tr class='buy'>" + "".join(f"<td>{html.escape(str(v))}</td>" for v in rw) + "</tr>" if rw[-1] else
                  "<tr" + (" class='pat'" if rw[14] else "") + ">" + "".join(f"<td>{html.escape(str(v))}</td>" for v in rw) + "</tr>" for rw in rows)
    bl = "".join(f"<li><b>BUY signal {b[0]}</b> (#{b[3]} {html.escape(CATALOG[b[3]][1])}) -> bought at the {b[1]} open {b[2]:.2f} -> max rise 60 min {b[4]:+.2f}%, "
                 f"max drop 30 min {b[5]:+.2f}%, 15 min later {b[6]:+.2f}% ({'higher' if b[6] > 0 else 'NOT higher'})</li>" for b in buys) or "<li>no buy signal</li>"
    sections.append(f"<details><summary><b>{s}</b> — {len(buys)} buy signal(s)</summary><ul>{bl}</ul><div class='wrap'><table><tr>{''.join(f'<th>{c}</th>' for c in cols)}</tr>{trs}</table></div></details>")
page = f"""<!doctype html><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>Stock Board {day}</title>
<style>:root{{--bg:#fff;--fg:#1d1d1f;--line:#ddd;--buy:#c8f7c5;--pat:#fff6d6}}@media (prefers-color-scheme:dark){{:root{{--bg:#16181c;--fg:#e8e8e8;--line:#333;--buy:#1f4d22;--pat:#4a4220}}}}
body{{background:var(--bg);color:var(--fg);font:14px -apple-system,Segoe UI,Roboto,sans-serif;padding:16px;max-width:1400px;margin:auto}}
.wrap{{overflow-x:auto}}table{{border-collapse:collapse;font-size:12px}}td,th{{border-bottom:1px solid var(--line);padding:3px 6px;white-space:nowrap}}
tr.buy td{{background:var(--buy);font-weight:600}}tr.pat td{{background:var(--pat)}}summary{{cursor:pointer;padding:6px 0}}</style></head><body>
<h1>Stock Board — {day} (simulator, every stock, every minute)</h1>
<p>Exactly what the simulator sees: library 1-min bars + buy/sell flow, stock_board.Board, one row per finished minute 9:30–11:45. Yellow = a pattern confirmed that minute; green = BUY signal
(bought at the next minute's open). For each buy: what the price did next — this is one row of the results tables.</p>
<p><b>{sum(len(b) for _, _, b in summary)} buy signals</b> on {len(summary)} list stocks.</p>{''.join(sections)}</body></html>"""
(OUT / "index.html").write_text(page)
print(f"{OUT}/index.html | {len(summary)} stocks | {sum(len(b) for _, _, b in summary)} buys")
for s, n, b in summary:
    for x in b: print(f"   {s:5} BUY {x[0]} (#{x[3]}) -> rise60 {x[4]:+.2f}% drop30 {x[5]:+.2f}% 15m {x[6]:+.2f}%")
