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

for pid in ["P24483299od2", "P97394751"]:
    p = next((x for x in db["persons"] if x["id"] == pid), None)
    if not p: continue
    print(f"\n=== {p.get('firstName','')} {p.get('lastName','')} ({pid}) ===")
    print(f"  Email: {p.get('email','')}")
    print(f"  Dept: {p.get('dept','')}, Title: {p.get('title','')}")
    print(f"  Phone: {p.get('phone','')}")
    
    trs = [r for r in db["travelRequests"] if r.get("personId") == pid]
    print(f"  Travel Requests: {len(trs)}")
    for r in trs:
        print(f"    {r['id']}: show={r.get('showId','')}, status={r.get('status','')}")
    
    hbs = [h for h in db["hotelBookings"] if h.get("personId") == pid]
    print(f"  Hotel Bookings: {len(hbs)}")
    for h in hbs:
        print(f"    {h['id']}: {h.get('hotel','')[:30]} {h.get('checkIn','')}-{h.get('checkOut','')}")
    
    pds = [pd for pd in db["perDiems"] if pd.get("personId") == pid]
    print(f"  PD Records: {len(pds)}")
    for pd in pds:
        print(f"    {pd['id']}: show={pd.get('showId','')}")
    
    assigns = [a for a in db["assignments"] if a.get("personId") == pid]
    print(f"  Assignments: {len(assigns)}")
    for a in assigns:
        print(f"    show={a.get('showId','')}")