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

fixed = 0
for h in db.get("hotelBookings", []):
    if h.get("showId") != "S2":
        continue
    name = f"{h.get('lastName','')}, {h.get('firstName','')}"
    
    # Find matching travel request
    r = next((r for r in db["travelRequests"] if r.get("personId") == h.get("personId") and r.get("showId") == h.get("showId")), None)
    if not r:
        continue
    bd = r.get("bookingDetails", {})
    
    # Sync missing checkIn
    if not h.get("checkIn") and (bd.get("hotelCheckIn") or r.get("depDate")):
        old = h.get("checkIn", "")
        h["checkIn"] = bd.get("hotelCheckIn") or r.get("depDate", "")
        print(f"  Synced {name} checkIn: '{old}' -> '{h['checkIn']}'")
        fixed += 1
    
    # Sync missing checkOut
    if not h.get("checkOut") and (bd.get("hotelCheckOut") or r.get("retDate")):
        old = h.get("checkOut", "")
        h["checkOut"] = bd.get("hotelCheckOut") or r.get("retDate", "")
        print(f"  Synced {name} checkOut: '{old}' -> '{h['checkOut']}'")
        fixed += 1

print(f"\nSynced {fixed} dates")
json.dump(db, open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json", "w"), indent=2)
print("Done!")