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 "ellis" in r.get("submittedName","").lower()), None)
if r:
    pd = next((p for p in db["perDiems"] if p.get("reqId") == r["id"]), None)
    bd = r.get("bookingDetails", {})
    hb = next((h for h in db.get("hotelBookings",[]) if h.get("personId") == r.get("personId") and h.get("showId") == r.get("showId")), None)
    
    print(f"Ellis request: depDate={r.get('depDate','')} retDate={r.get('retDate','')}")
    print(f"  bd.hotelCheckIn={bd.get('hotelCheckIn','')} bd.hotelCheckOut={bd.get('hotelCheckOut','')}")
    print(f"  Hotel: checkIn={hb.get('checkIn','') if hb else 'none'} checkOut={hb.get('checkOut','') if hb else 'none'}")
    if pd:
        print(f"  PD: 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')}")
        
        # What dates did you change Travel Out to?
        print(f"\n  If you changed Travel Out on the PD grid to 05/27, the pdCheckOut should be 2026-05-27")
        print(f"  Current pdCheckOut: '{pd.get('pdCheckOut','')}'")