"""rule_losers.py NAME N SEED -- [2026-10-25] the user: N random LOSERS of a rule test (NAME_feat.json, 2024-26, old-score top 30)
as charts with the buy / sell and a table of every indicator minute by minute from the open to the close.
    python3 rule_losers.py r11 5 1025  -> NAME_losers_<seed>.pdf"""
import gzip, json, random, sys
from datetime import timedelta
from pathlib import Path
from zoneinfo import ZoneInfo
import matplotlib; matplotlib.use("Agg")
import matplotlib.dates as mdates, matplotlib.pyplot as plt
from matplotlib.backends.backend_pdf import PdfPages
HERE = Path(__file__).resolve().parent
sys.path.insert(0, str(HERE)); sys.path.insert(0, "/var/www/screener/trade/reports/playbook"); sys.path.insert(0, "/var/www/screener/trade")
import v2_bar_replay as R
from queue_test import Day
from sim_2y import sim as c3_sim
import r11_setup, r12_setup
ET = ZoneInfo("America/New_York"); hm = lambda m: f"{9 + (30 + m) // 60}:{(30 + m) % 60:02d}"
name, N, seed = sys.argv[1], int(sys.argv[2]), int(sys.argv[3])
MOD = {"r11": r11_setup, "r12": r12_setup}[name]
X = [x for x in json.load(open(HERE / f"{name}_feat.json")) if x["c3"] < 0]
random.seed(seed); pick = sorted(random.sample(X, N), key=lambda x: x["day"])
with PdfPages(HERE / f"{name}_losers_{seed}.pdf") as pdf:
    for k, t in enumerate(pick, 1):
        day, s = t["day"], t["sym"]
        d = json.load(gzip.open(R.OW / "bars" / f"bars_{day}.json.gz", "rt")); ref = R.REF.load(day, s) or {}
        b = [x for x in R.bars_of(d["symbols"][s]["bars"]) if 0 <= R.minute(x["t"]) < 390]; M = [R.minute(x["t"]) for x in b]
        fl = json.loads((R.OW / "flow" / day / f"{s}.json").read_text()); D = Day(b, M, fl, ref)
        ti = M.index(t["m"]); bi = ti + 1; P = b[bi]["o"]
        cfg = {kk: vv for kk, vv in zip(("turn_bs", "bs5_min", "under_vwap", "off_max"), (0.60, 0.60, 2.0, 5.0))} if name == "r11" else {}
        ok, info = MOD.check(b[:ti + 1], fl, ref, t["m"], cfg)
        stop = min(max(info["support"] * 0.998, P * 0.96), P * 0.995)
        pl, j, why = c3_sim(D, bi, P, stop, 2.0, "C3"); xp = P * (1 + (pl + 0.2) / 100)
        tt = [x["t"].astimezone(ET) for x in b]; vw = D.vw
        fig = plt.figure(figsize=(11.7, 8.3)); gs = fig.add_gridspec(2, 1, height_ratios=[3, 1], hspace=0.12)
        a1 = fig.add_subplot(gs[0]); a2 = fig.add_subplot(gs[1], sharex=a1)
        for i, x in enumerate(b):
            col = "#2e7d32" if x["c"] >= x["o"] else "#c62828"
            a1.plot([tt[i], tt[i]], [x["l"], x["h"]], color=col, lw=0.6); a1.plot([tt[i], tt[i]], [x["o"], x["c"]], color=col, lw=2)
        a1.plot(tt, vw, color="#7b1fa2", lw=1.1, ls="--", label="VWAP")
        a1.axhline(b[0]["o"], color="#1565c0", lw=0.7, ls=":", label=f"open {b[0]['o']}")
        for key, col in (("prev_close", "#9e9e9e"), ("prev_low", "#ef6c00")):
            if ref.get(key):
                a1.axhline(ref[key], color=col, lw=0.7, ls=":", label=f"{key.replace('_', ' ')} {ref[key]}")
        a1.plot([tt[bi], tt[j]], [stop, stop], color="#c62828", lw=1, ls=":", label=f"stop {stop:.3f}")
        if info.get("support_m") in M:
            ks = M.index(info["support_m"]); a1.scatter([tt[ks]], [b[ks]["l"]], s=70, facecolor="none", edgecolor="#c62828", zorder=5, label=f"the low {info['support']:.3f} {hm(info['support_m'])}")
        a1.scatter([tt[bi]], [P], marker="^", s=170, color="#1565c0", edgecolor="white", zorder=6, label=f"BUY {hm(M[bi])} {P:.3f} (trigger {hm(t['m'])})")
        a1.scatter([tt[j]], [xp], marker="v", s=170, color="#c62828", edgecolor="white", zorder=6, label=f"SELL {hm(M[j])} {xp:.3f} {pl:+.2f}% [{why}]")
        a1.axvspan(tt[bi], tt[j], color="#ffcdd2", alpha=0.35)
        a1.set_title(f"{name.upper()} LOSER #{k}  {s}  {day}   gap {t['gap']:+.1f}%  ATR {t['atr']:.1f}%   at the trigger: {t['vs_vwap']:+.1f}% vs VWAP, "
                     f"{t['vs_open']:+.1f}% vs open, buy share 5m {t['bs5']:.0%} 15m {t['bs15']:.0%}, RVOL {t['rvol'] or 0:.2f}x", fontsize=8.5, loc="left")
        a1.legend(fontsize=6.8, loc="best", framealpha=0.9); a1.grid(alpha=0.25); plt.setp(a1.get_xticklabels(), visible=False); a1.tick_params(labelsize=7)
        a2.bar(tt, [fl["buy"][m] for m in M], width=timedelta(seconds=50), color="#43a047"); a2.bar(tt, [-fl["sell"][m] for m in M], width=timedelta(seconds=50), color="#e53935")
        a2.axhline(0, color="black", lw=0.5); a2.axvspan(tt[bi], tt[j], color="#ffcdd2", alpha=0.35); a2.set_ylabel("buy / sell", fontsize=7)
        a2.xaxis.set_major_formatter(mdates.DateFormatter("%H:%M", tz=ET)); a2.tick_params(labelsize=7); a2.grid(alpha=0.25)
        pdf.savefig(fig); plt.close(fig)
        vpm = ref.get("vol_per_min") or []
        def bs(m, n):
            B = sum(fl["buy"][max(0, m - n + 1):m + 1]); S = sum(fl["sell"][max(0, m - n + 1):m + 1]); return f"{B / (B + S):.0%}" if B + S else "-"
        rows = []; cv = 0.0; hi = 0; lo = 1e9
        for i, x in enumerate(b):
            m = M[i]; cv += x["v"]; hi = max(hi, x["h"]); lo = min(lo, x["l"])
            norm = sum(vpm[:m + 1]) if len(vpm) > m else 0
            tag = "TRIGGER" if i == ti else "BUY" if i == bi else "SELL" if i == j else "low" if m == info.get("support_m") else ""
            rows.append([hm(m), f"{x['o']:.3f}", f"{x['h']:.3f}", f"{x['l']:.3f}", f"{x['c']:.3f}", f"{x['v']:,.0f}",
                         f"{x['v'] / vpm[m]:.1f}x" if len(vpm) > m and vpm[m] else "-", f"{cv / norm:.2f}x" if norm else "-",
                         f"{fl['buy'][m]:,.0f}", f"{fl['sell'][m]:,.0f}", bs(m, 1), bs(m, 5), bs(m, 15), f"{vw[i]:.3f}",
                         f"{(x['c'] / vw[i] - 1) * 100:+.2f}%", f"{(x['c'] / b[0]['o'] - 1) * 100:+.2f}%", f"{lo:.3f}", f"{hi:.3f}",
                         f"{(x['c'] / P - 1) * 100:+.2f}%" if bi <= i <= j else "", tag])
        head = ["time", "open", "high", "low", "close", "volume", "vol x norm", "RVOL so far", "buy vol", "sell vol", "buy% 1m", "buy% 5m",
                "buy% 15m", "VWAP", "vs VWAP", "vs open", "day low", "day high", "vs buy", ""]
        colr = {"TRIGGER": "#fff9c4", "BUY": "#bbdefb", "SELL": "#ffcdd2", "low": "#f3e5f5"}
        for p0 in range(0, len(rows), 40):
            fig = plt.figure(figsize=(11.7, 8.3)); ax = fig.add_subplot(111); ax.axis("off")
            ax.set_title(f"{name.upper()} LOSER #{k} {s} {day} -- every minute {rows[p0][0]}..{rows[min(p0 + 39, len(rows) - 1)][0]} "
                         f"(prev close {ref.get('prev_close')}, prev low {ref.get('prev_low')}, ATR {t['atr']:.1f}%)", fontsize=8, loc="left")
            tb = ax.table(cellText=rows[p0:p0 + 40], colLabels=head, loc="upper center", cellLoc="center")
            tb.auto_set_font_size(False); tb.set_fontsize(5.6); tb.scale(1, 1.05)
            for (r_, c_), cell in tb.get_celld().items():
                if r_ == 0:
                    cell.set_facecolor("#eceff1"); cell.set_text_props(weight="bold")
                elif rows[p0 + r_ - 1][-1] in colr:
                    cell.set_facecolor(colr[rows[p0 + r_ - 1][-1]])
            pdf.savefig(fig); plt.close(fig)
        print(f"#{k} {s} {day} trigger {hm(t['m'])} buy {hm(M[bi])} {P:.3f} -> sell {hm(M[j])} {xp:.3f} {pl:+.2f}% [{why}] | low {info['support']:.3f} "
              f"({info['low_vs_vwap']:+.1f}% vs VWAP) | gap {t['gap']:+.1f}% vs_open {t['vs_open']:+.1f}% bs5 {t['bs5']:.0%} bs15 {t['bs15']:.0%} rvol {t['rvol'] or 0:.2f}")
        R.REF._CACHE.clear()
