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

names = ["kent", "carney", "odze", "schaff", "wolfe"]
for name in names:
    r = next((r for r in db["travelRequests"] if name in r.get("submittedName","").lower()), None)
    pd = next((p for p in db.get("perDiems",[]) if r and p.get("reqId") == r["id"]), None) if r else None
    p = next((p for p in db["persons"] if name in (p.get("firstName","")+p.get("lastName","")).lower()), None)
    
    print(f"\n=== {name.upper()} ===")
    if r:
        bd = r.get("bookingDetails", {})
        print(f"  Request: {r['id']} status:{r.get('status','?')}")
        print(f"  depDate:{r.get('depDate','NONE')} retDate:{r.get('retDate','NONE')}")
        print(f"  hotelCheckIn:{r.get('hotelCheckIn','NONE')} hotelCheckOut:{r.get('hotelCheckOut','NONE')}")
        print(f"  bd.hotelCheckIn:{bd.get('hotelCheckIn','NONE')} bd.hotelCheckOut:{bd.get('hotelCheckOut','NONE')}")
        print(f"  checklist pd_ineligible:{r.get('checklist',{}).get('pd_ineligible',False)}")
        print(f"  bd.pdEligible:{bd.get('pdEligible','not set')}")
    else:
        print(f"  NO TRAVEL REQUEST")
    
    if pd:
        print(f"  PD record: autoDays:{pd.get('autoDays')} manualDays:{pd.get('manualDays')} autoRate:{pd.get('autoRate')} manualRate:{pd.get('manualRate')}")
    else:
        print(f"  NO PD RECORD")
    
    # Check hotel booking dates
    hb = next((h for h in db.get("hotelBookings",[]) if r and h.get("personId") == r.get("personId") and h.get("showId") == r.get("showId")), None) if r else None
    if hb:
        print(f"  Hotel: checkIn:{hb.get('checkIn','NONE')} checkOut:{hb.get('checkOut','NONE')}")