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

for name in ["brown", "nowak"]:
    r = next((r for r in db["travelRequests"] if name in r.get("submittedName","").lower()), None)
    if r:
        pd = next((p for p in db["perDiems"] if p.get("reqId") == r["id"]), None)
        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"\n=== {r.get('submittedName','')} ===")
        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"  PD pdCheckIn={pd.get('pdCheckIn','')} pdCheckOut={pd.get('pdCheckOut','')}")
            print(f"  autoDays={pd.get('autoDays')} manualDays={pd.get('manualDays')}")