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

print("=== Saltzer Travel Requests ===")
for r in db.get("travelRequests", []):
    if "saltzer" in (r.get("submittedName","") + r.get("lastName","")).lower():
        bd = r.get("bookingDetails", {})
        print(f"  ReqID: {r['id']}, PersonID: {r.get('personId','')}, Show: {r.get('showId','')}")
        print(f"  Dates: {r.get('depDate','')} - {r.get('retDate','')}")
        print(f"  Hotel dates: {bd.get('hotelCheckIn','')} - {bd.get('hotelCheckOut','')}")

print("\n=== Saltzer Hotel Bookings ===")
for h in db.get("hotelBookings", []):
    if "saltzer" in (h.get("lastName","")).lower():
        print(f"  HotelID: {h['id']}, PersonID: {h.get('personId','')}, Show: {h.get('showId','')}")
        print(f"  Dates: {h.get('checkIn','')} - {h.get('checkOut','')}")
        print(f"  Hotel: {h.get('hotel','')}, Conf: {h.get('conf','')}")
        print()