#!/usr/bin/env python3
"""
Read-only: dump every hotel booking tied to Drew Hunter, plus his travel
request(s), so we can see exactly what the two rows are and how the second
one got created. Nothing is written.

Run:  python3 ~/diag_drew_hotels.py
"""

import json, os, datetime

DB_PATH = os.path.expanduser("~/public_html/jn.com/ops/data/db.json")
LAST, FIRST = "Hunter", "Drew"

with open(DB_PATH, "r", encoding="utf-8") as f:
    db = json.load(f)

persons = db.get("persons", [])
matched = [p for p in persons
           if (p.get("lastName","").strip().lower() == LAST.lower()
               and p.get("firstName","").strip().lower().startswith(FIRST.lower()))]
pids = {p.get("id") for p in matched}

print(f"\n=== DREW HUNTER — hotel diagnostic ===")
print(f"DB: {DB_PATH}\n")

print(f"--- CREW PROFILE(S) [{len(matched)}] ---")
for p in matched:
    print(f"   id={p.get('id')!r}  {p.get('firstName')} {p.get('lastName')}  email={p.get('email')!r}")
print()

# All hotel bookings tied to him (by personId OR name on the booking)
def is_drew(h):
    if h.get("personId") in pids:
        return True
    return (h.get("lastName","").strip().lower() == LAST.lower()
            and h.get("firstName","").strip().lower().startswith(FIRST.lower()))

hbs = [h for h in db.get("hotelBookings", []) if is_drew(h)]
print(f"--- HOTEL BOOKINGS TIED TO DREW [{len(hbs)}] ---")
for h in hbs:
    print(f"   bookingId={h.get('id')!r}  show={h.get('showId')!r}  personId={h.get('personId')!r}")
    print(f"        assigned={h.get('assigned')!r}  status={h.get('status')!r}  hotel={h.get('hotel')!r}")
    print(f"        roomCode={h.get('roomCode')!r}  roomType={h.get('roomType')!r}  "
          f"checkIn={h.get('checkIn')!r}  checkOut={h.get('checkOut')!r}")
    print(f"        lastName={h.get('lastName')!r}  firstName={h.get('firstName')!r}  "
          f"loyaltyNum={h.get('loyaltyNum')!r}")
    print(f"        lastModified={h.get('lastModified')!r}")
    print()

# His travel request(s)
trs = [r for r in db.get("travelRequests", []) if r.get("personId") in pids]
print(f"--- TRAVEL REQUEST(S) [{len(trs)}] ---")
for r in trs:
    bd = r.get("bookingDetails") or {}
    print(f"   reqId={r.get('id')!r}  show={r.get('showId')!r}  status={r.get('status')!r}  "
          f"hotel={r.get('hotel')!r}  roomType={r.get('roomType')!r}")
    print(f"        bd.hotelName={bd.get('hotelName')!r}  hotelCheckIn={bd.get('hotelCheckIn')!r}  "
          f"hotelCheckOut={bd.get('hotelCheckOut')!r}")
print()