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

print("=== Hotel Bookings with issues ===\n")
for h in db.get("hotelBookings", []):
    if h.get("showId") != "S2":
        continue
    ci = h.get("checkIn", "")
    co = h.get("checkOut", "")
    name = f"{h.get('lastName','')}, {h.get('firstName','')}"
    
    if not ci or not co:
        print(f"  MISSING DATES: {name} hotel={h.get('hotel','')} checkIn='{ci}' checkOut='{co}'")
    elif len(ci) != 10 or len(co) != 10:
        print(f"  BAD FORMAT: {name} checkIn='{ci}' (len={len(ci)}) checkOut='{co}' (len={len(co)})")
    elif co < ci:
        print(f"  CHECKOUT BEFORE CHECKIN: {name} checkIn='{ci}' checkOut='{co}'")

print(f"\n=== All S2 hotel bookings ===")
print(f"{'Name':<30} {'Hotel':<35} {'CheckIn':<12} {'CheckOut':<12} {'Assigned'}")
for h in sorted(db.get("hotelBookings", []), key=lambda x: x.get("checkIn","zzz")):
    if h.get("showId") != "S2":
        continue
    print(f"{h.get('lastName','')}, {h.get('firstName',''):<24} {h.get('hotel',''):<35} {h.get('checkIn','—'):<12} {h.get('checkOut','—'):<12} {h.get('assigned','')}")