"""LOG356：5つの現場の results_*.json から、記事に載せる表を出す。
- 標準の条件で、ロボットの台数を変えたとき
- 公表されていない値（止まる割合・引っかかる回数・空振り・介入の回数）を動かしたとき
- 施設の広さ（病院・ホテル・警備・屋外配送）を変えたとき（このとき以外は、真ん中の広さ）
使い方: python3 summary.py <results_*.json のあるフォルダ>
"""
import json
import sys
from pathlib import Path

D = Path(sys.argv[1] if len(sys.argv) > 1 else ".")


def rows(name):
    return json.load(open(D / f"results_{name}.json", encoding="utf-8"))["rows"]


def find(rs, zero, **kw):
    if kw.get("robots") == 0:
        kw = {**kw, **zero}
    hit = [r for r in rs if all(r[k] == v for k, v in kw.items())]
    assert len(hit) == 1, (kw, len(hit))
    return hit[0]


def table(title, head, lines):
    print(f"\n### {title}")
    print("| " + " | ".join(head) + " |")
    print("|" + "---|" * len(head))
    for l in lines:
        print("| " + " | ".join(str(x) for x in l) + " |")


f1 = lambda x: f"{x:.1f}"
f0 = lambda x: f"{x:.0f}"
pc = lambda x: f"{x * 100:.0f}%"

# ---- 病院
H = rows("hospital"); HZ = {"stop_rate": 0.0, "dispatch": "now", "speed": 0.9}
base = dict(scale="mid", demand=1, floors="same", stop_rate=0.05, dispatch="now", busy=0.6, speed=0.9)
table("病院搬送：ロボットの台数（荷物の量 普通・同じ階・すぐ出す・速さ0.9m/秒・忙しさ6割・止まる5%）",
      ["台数", "届くまで（分）", "遅い方の1割（分）", "15分超え", "人が搬送に使った分/日", "ほかの仕事の待ち（分）", "便数/日", "人を呼んだ回数"],
      [[n, f1(r["wait_mean"]), f1(r["wait_p90"]), pc(r["late_share"]), f0(r["staff_tr_min"]), f1(r["other_wait"]), f1(r["robot_trips"]), f1(r["calls"])]
       for n in [0, 1, 2] for r in [find(H, HZ, **{**base, "robots": n})]])
table("病院搬送：ロボットの速さ（1台・ほかは上と同じ）", ["速さ（m/秒）", "届くまで（分）", "15分超え", "人が搬送に使った分/日"],
      [[s, f1(r["wait_mean"]), pc(r["late_share"]), f0(r["staff_tr_min"])] for s in [0.6, 0.9, 1.2] for r in [find(H, HZ, **{**base, "robots": 1, "speed": s})]])
table("病院搬送：途中で止まる割合（1台）", ["止まる割合", "届くまで（分）", "人が搬送に使った分/日", "人を呼んだ回数"],
      [[pc(s), f1(r["wait_mean"]), f0(r["staff_tr_min"]), f1(r["calls"])] for s in [0.0, 0.05, 0.15] for r in [find(H, HZ, **{**base, "robots": 1, "stop_rate": s})]])
table("病院搬送：階をまたぐ（エレベーター）", ["台数", "届くまで（分）", "15分超え", "人が搬送に使った分/日"],
      [[n, f1(r["wait_mean"]), pc(r["late_share"]), f0(r["staff_tr_min"])] for n in [0, 1, 2] for r in [find(H, HZ, **{**base, "robots": n, "floors": "elev"})]])

# ---- 清掃
C = rows("cleaning"); CZ = {"eff": 0.8, "stuck_per_h": 0.0, "dock": False}
clk = lambda m: f"{(22 * 60 + round(m)) // 60 % 24}:{(22 * 60 + round(m)) % 60:02d}"
for fac, st in [("office", 1), ("mall", 3), ("large", 4)]:
    lines = []
    for sh in [0.3, 0.5, 0.7, 0.9]:
        z = find(C, CZ, facility=fac, staff=st, robots=0, share=sh)
        line = [pc(sh), f"{z['staff_hours']:.1f}時間・{clk(z['finish'])}"]
        for n in [1, 2, 3]:
            r = find(C, CZ, facility=fac, staff=st, robots=n, share=sh, eff=0.8, stuck_per_h=0.5, dock=False)
            line.append(f"{pc(1 - r['staff_hours'] / z['staff_hours'])}減・呼んだ{r['calls']:.1f}回")
        lines.append(line)
    table(f"夜間清掃：{fac}・スタッフ{st}人（速さ8割・引っかかり0.5回/時・水は人が入れ替える）", ["広い床の割合", "ロボットなし", "1台", "2台", "3台"], lines)
table("夜間清掃：引っかかる回数と充電台（商業施設・2人・2台・広い床70%・速さ8割）",
      ["引っかかり/時", "充電台", "人の作業（時間）", "人を呼んだ回数", "呼ばれて使った分", "ロボットが待った分"],
      [[s, "自動" if d else "人", f1(r["staff_hours"]), f1(r["calls"]), f0(r["call_min"]), f0(r["robot_wait"])]
       for s in [0.0, 0.5, 1.5] for d in [False, True] for r in [find(C, CZ, facility="mall", staff=2, robots=2, share=0.7, eff=0.8, stuck_per_h=s, dock=d)]])

# ---- ホテル
T = rows("hotel"); TZ = {"link": "system", "stop_rate": 0.0, "multi": 1}
lines = []
for fr in [2, 3]:
    for dm, n_req in zip([0, 1, 2], [25, 45, 80]):
        z = find(T, TZ, scale="mid", front=fr, robots=0, demand=dm)
        line = [fr, n_req, f"{f1(z['deliv_mean'])}分・離れる{f0(z['away_min'])}分・CI {f1(z['checkin_mean'])}分"]
        for n, lk in [(1, "system"), (1, "arm"), (2, "system")]:
            r = find(T, TZ, scale="mid", front=fr, robots=n, demand=dm, link=lk, stop_rate=0.05, multi=1)
            line.append(f"{f1(r['deliv_mean'])}分・離れる{f0(r['away_min'])}分・CI {f1(r['checkin_mean'])}分・呼んだ{f1(r['calls'])}回")
        lines.append(line)
table("ホテル：届くまで・フロントを離れた分・チェックインの待ち（止まる5%・1件ずつ）", ["フロント", "依頼/日", "ロボットなし", "1台・建物とつなぐ", "1台・腕でボタン", "2台・建物とつなぐ"], lines)
table("ホテル：1回に運ぶ依頼（フロント2人・80件/日・腕でボタン・1台）", ["1回に運ぶ", "届くまで（分）", "遅い方の1割（分）", "動いている割合"],
      [[m, f1(r["deliv_mean"]), f1(r["deliv_p90"]), pc(r["robot_util"])] for m in [1, 2] for r in [find(T, TZ, scale="mid", front=2, robots=1, demand=2, link="arm", stop_rate=0.05, multi=m)]])

# ---- 警備
S = rows("security"); SZ = {"false_per_h": 0.0, "rmode": "sched"}
lines = []
for g in [1, 2, 3]:
    z = find(S, SZ, scale="mid", guards=g, robots=0, incidents=6)
    line = [g, f"着くまで{f0(z['reach_mean'])}分・空白{f0(z['max_gap'])}分・センター空き{f0(z['center_empty'])}分"]
    for n in [1, 2]:
        for m in ["sched", "cont"]:
            r = find(S, SZ, scale="mid", guards=g, robots=n, incidents=6, false_per_h=0.5, rmode=m)
            line.append(f"{f0(r['reach_mean'])}分・空白{f0(r['max_gap'])}分・空き{f0(r['center_empty'])}分・呼んだ{f1(r['calls'])}回")
    lines.append(line)
table("警備：異常に人が着くまで・巡回の最長の空白・センターが空いた分（異常6件/晩・空振り0.5回/時）",
      ["警備員", "ロボットなし", "1台・2時間ごと", "1台・回り続ける", "2台・2時間ごと", "2台・回り続ける"], lines)
table("警備：空振りの知らせ（警備員1人・1台・回り続ける・異常6件）", ["空振り/時", "人を呼んだ回数", "うち空振り", "センターが空いた分", "着くまで（分）"],
      [[fp, f1(r["calls"]), f1(r["false_calls"]), f0(r["center_empty"]), f1(r["reach_mean"])] for fp in [0.0, 0.5, 1.5]
       for r in [find(S, SZ, scale="mid", guards=1, robots=1, incidents=6, false_per_h=fp, rmode="cont")]])

# ---- 屋外配送
O = rows("outdoor")
for w in [10, 4]:
    lines = []
    for od in [20, 60, 120, 200]:
        for ir in [0.05, 0.2, 0.5]:
            line = [od, ir]
            for n in [1, 2, 4, 6, 10]:
                r = find(O, {}, scale="mid", robots=n, operators=1, orders=od, int_rate=ir, watch=w)
                line.append(f"{f0(r['lead_mean'])}分・待ち{r['int_wait'] * 60:.0f}秒・{pc(r['op_util'])}")
            lines.append(line)
    table(f"屋外配送：届くまで・介入でオペレーターを待った秒・オペレーターがかかりきりの割合（オペレーター1人・1人{w}台まで）",
          ["注文/日", "介入/片道", "1台", "2台", "4台", "6台", "10台"], lines)

# ---- 施設の広さ（真ん中以外の広さも、標準の条件で比べる）
table("病院搬送：病院の広さ（1台・ほかは標準）", ["広さ", "台数", "届くまで（分）", "15分超え", "人が搬送に使った分/日", "人を呼んだ回数"],
      [[sc, n, f1(r["wait_mean"]), pc(r["late_share"]), f0(r["staff_tr_min"]), f1(r["calls"])]
       for sc in ["small", "mid", "large"] for n in [0, 1, 2] for r in [find(H, HZ, **{**base, "scale": sc, "robots": n})]])
table("ホテル：ホテルの広さ（依頼 普通・建物とつなぐ・止まる5%・1件ずつ）", ["広さ", "フロント", "台数", "届くまで（分）", "フロントを離れた分", "チェックインの待ち（分）", "人を呼んだ回数"],
      [[sc, fr, n, f1(r["deliv_mean"]), f0(r["away_min"]), f1(r["checkin_mean"]), f1(r["calls"])]
       for sc, fr in [("small", 1), ("small", 2), ("mid", 2), ("large", 3)] for n in [0, 1, 2]
       for r in [find(T, TZ, scale=sc, front=fr, robots=n, demand=1, link="system", stop_rate=0.05, multi=1)]])
table("警備：ビルの広さ（警備員2人・異常6件・空振り0.5回/時・回り続ける）", ["広さ", "台数", "着くまで（分）", "巡回の最長の空白（分）", "警備員が外にいた分", "人を呼んだ回数"],
      [[sc, n, f1(r["reach_mean"]), f0(r["max_gap"]), f0(r["foot_min"]), f1(r["calls"])]
       for sc in ["small", "mid", "large"] for n in [0, 1, 2] for r in [find(S, SZ, scale=sc, guards=2, robots=n, incidents=6, false_per_h=0.5, rmode="cont")]])
table("屋外配送：配達エリアの広さ（オペレーター1人・1人10台まで・介入0.2回/片道）", ["広さ", "注文/日", "2台", "4台", "6台", "10台"],
      [[sc, od] + [f"{f0(r['lead_mean'])}分・{pc(r['robot_util'])}" for n in [2, 4, 6, 10] for r in [find(O, {}, scale=sc, robots=n, operators=1, orders=od, int_rate=0.2, watch=10)]]
       for sc in ["near", "mid", "wide"] for od in [20, 60, 120]])
