import json
db = json.load(open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json"))
r = next((r for r in db["travelRequests"] if "stoffo" in r.get("submittedName","").lower()), None)
if r:
    bd = r.get("bookingDetails", {})
    print(f"Request: depDate={r.get('depDate','')} retDate={r.get('retDate','')}")
    print(f"  hotelCheckIn={r.get('hotelCheckIn','')} hotelCheckOut={r.get('hotelCheckOut','')}")
    print(f"  bd.hotelCheckIn={bd.get('hotelCheckIn','')} bd.hotelCheckOut={bd.get('hotelCheckOut','')}")
    
    hb = next((h for h in db.get("hotelBookings",[]) if h.get("personId") == r.get("personId") and h.get("showId") == r.get("showId")), None)
    if hb:
        print(f"  Hotel booking: checkIn={hb.get('checkIn','')} checkOut={hb.get('checkOut','')}")
    
    pd = next((p for p in db.get("perDiems",[]) if p.get("reqId") == r["id"]), None)
    if pd:
        print(f"  PD record: checkIn={pd.get('checkIn','')} checkOut={pd.get('checkOut','')}")
        print(f"    pdCheckIn={pd.get('pdCheckIn','')} pdCheckOut={pd.get('pdCheckOut','')}")
        print(f"    autoDays={pd.get('autoDays')} manualDays={pd.get('manualDays')}")