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

fixes = 0
for h in db.get("hotelBookings", []):
    if h.get("showId") != "S2":
        continue
    name = f"{h.get('lastName','')}, {h.get('firstName','')}"
    
    # Fix Bontrager: 20206-05-18 -> 2026-05-18
    if h.get("checkIn") == "20206-05-18":
        h["checkIn"] = "2026-05-18"
        print(f"Fixed Bontrager checkIn: 20206-05-18 -> 2026-05-18")
        fixes += 1
    
    # Fix Bontrager missing hotel
    if "bontrager" in name.lower() and not h.get("hotel"):
        h["hotel"] = "Hilton Washington DC Capitol Hill"
        print(f"Fixed Bontrager hotel: -> Hilton Washington DC Capitol Hill")
        fixes += 1
    
    # Fix Woodson missing hotel
    if "woodson" in name.lower() and not h.get("hotel"):
        h["hotel"] = "Hilton Washington DC Capitol Hill"
        print(f"Fixed Woodson hotel: -> Hilton Washington DC Capitol Hill")
        fixes += 1
    
    # Fix Macks missing hotel
    if "macks" in name.lower() and not h.get("hotel"):
        h["hotel"] = "Hilton Washington DC Capitol Hill"
        print(f"Fixed Macks hotel: -> Hilton Washington DC Capitol Hill")
        fixes += 1
    
    # Fix Saltzer missing hotel
    if "saltzer" in name.lower() and not h.get("hotel"):
        h["hotel"] = "Hilton Washington DC Capitol Hill"
        print(f"Fixed Saltzer hotel: -> Hilton Washington DC Capitol Hill")
        fixes += 1
    
    # Fix Balton Ryan missing hotel
    if "balton" in name.lower() and "ryan" in name.lower() and not h.get("hotel"):
        h["hotel"] = "Hilton Washington DC Capitol Hill"
        print(f"Fixed Balton Ryan hotel: -> Hilton Washington DC Capitol Hill")
        fixes += 1

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