import json
db = json.load(open("/home/rmlac2fmr/public_html/jn.com/talentops/server/db.json"))

print("=== Hotel Records ===")
print(f"Total: {len(db.get('hotelRecords', []))}")

bad_dates = []
all_dates = []
for h in db.get("hotelRecords", []):
    ci = h.get("checkIn", "")
    co = h.get("checkOut", "")
    show = h.get("showId", "?")
    name = f"{h.get('lastName', h.get('legalLastName', ''))}, {h.get('firstName', h.get('legalFirstName', ''))}"
    tid = h.get("travelerId", "?")
    
    if ci: all_dates.append(ci)
    if co: all_dates.append(co)
    
    # Check for bad years
    for d, label in [(ci, "checkIn"), (co, "checkOut")]:
        if d:
            year = d[:4] if len(d) >= 4 else "????"
            if not year.startswith("202") or len(year) != 4:
                bad_dates.append(f"  BAD {label}: '{d}' for {name} (show={show})")
            elif int(year) < 2024 or int(year) > 2027:
                bad_dates.append(f"  SUSPICIOUS {label}: '{d}' for {name} (show={show})")

if bad_dates:
    print(f"\n⚠ BAD DATES FOUND ({len(bad_dates)}):")
    for b in bad_dates:
        print(b)
else:
    print("  No bad dates found")

if all_dates:
    all_dates.sort()
    print(f"\n  Date range: {all_dates[0]} to {all_dates[-1]}")
    from datetime import datetime
    try:
        d1 = datetime.strptime(all_dates[0][:10], "%Y-%m-%d")
        d2 = datetime.strptime(all_dates[-1][:10], "%Y-%m-%d")
        span = (d2 - d1).days
        print(f"  Span: {span} days")
        if span > 60:
            print(f"  ⚠ SPAN IS {span} DAYS — tally generates {span} columns, this WILL freeze the browser")
    except:
        print("  Could not parse dates")

print(f"\n=== Shows ===")
for s in db.get("shows", []):
    archived = "ARCHIVED" if s.get("archived") else "ACTIVE"
    print(f"  {s.get('name', '?')} (ID: {s.get('id', '?')}) — {archived}")
    recs = [h for h in db.get("hotelRecords", []) if h.get("showId") == s.get("id")]
    print(f"    Hotel records: {len(recs)}")