import json

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

# P95470284 should be Douglas Fogel (has Doug's email but Donald's name)
doug_profile = next((p for p in db["persons"] if p["id"] == "P95470284"), None)
# P771105942 should be Donald Kent (has Donald's email but empty data)
donald_profile = next((p for p in db["persons"] if p["id"] == "P771105942"), None)

# Get travel request data for both
doug_req = next((r for r in db["travelRequests"] if r["id"] == "R1774536797235"), None)
donald_req = next((r for r in db["travelRequests"] if r["id"] == "R1774555580607"), None)

print("BEFORE:")
print(f"  P95470284: {doug_profile['firstName']} {doug_profile['lastName']} - {doug_profile['email']}")
print(f"  P771105942: {donald_profile['firstName']} {donald_profile['lastName']} - {donald_profile['email']}")

# Fix Douglas Fogel profile - use his travel request data
if doug_profile and doug_req:
    doug_profile["firstName"] = "Douglas"
    doug_profile["lastName"] = "Fogel"
    doug_profile["email"] = "fugdogel@gmail.com"
    doug_profile["phone"] = doug_req.get("submittedPhone", "")
    doug_profile["title"] = doug_req.get("submittedTitle", "")
    doug_profile["dept"] = doug_req.get("submittedDept", "")
    if doug_req.get("emergency"): doug_profile["emergency"] = doug_req["emergency"]
    if doug_req.get("seatPref"): doug_profile["seatPref"] = doug_req["seatPref"]
    if doug_req.get("hotelRewards"): doug_profile["hotelRewards"] = doug_req["hotelRewards"]
    if doug_req.get("foodAllergies"): doug_profile["foodAllergies"] = doug_req["foodAllergies"]
    if doug_req.get("dietary"): doug_profile["dietary"] = doug_req["dietary"]
    print(f"\n  P95470284 fixed -> Douglas Fogel - fugdogel@gmail.com")

# Fix Donald Kent profile - use his travel request data
if donald_profile and donald_req:
    donald_profile["firstName"] = "Donald"
    donald_profile["lastName"] = "Kent"
    donald_profile["email"] = "skipkent@gmail.com"
    donald_profile["phone"] = donald_req.get("submittedPhone", "")
    donald_profile["title"] = donald_req.get("submittedTitle", "")
    donald_profile["dept"] = donald_req.get("submittedDept", "")
    if donald_req.get("emergency"): donald_profile["emergency"] = donald_req["emergency"]
    if donald_req.get("seatPref"): donald_profile["seatPref"] = donald_req["seatPref"]
    if donald_req.get("hotelRewards"): donald_profile["hotelRewards"] = donald_req["hotelRewards"]
    if donald_req.get("foodAllergies"): donald_profile["foodAllergies"] = donald_req["foodAllergies"]
    if donald_req.get("dietary"): donald_profile["dietary"] = donald_req["dietary"]
    print(f"  P771105942 fixed -> Donald Kent - skipkent@gmail.com")

json.dump(db, open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json", "w"), indent=2)
print("\nDone!")