import json

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

# Find both person records
jenn = next((p for p in db["persons"] if p["id"] == "P95470217"), None)
guy = next((p for p in db["persons"] if p["id"] == "P771106255"), None)

print("BEFORE FIX:")
print(f"  P95470217: {jenn['firstName']} {jenn['lastName']} - {jenn['email']}")
print(f"  P771106255: {guy['firstName']} {guy['lastName']} - {guy['email']}")

# Save Guy's data that's currently on Jennifer's profile
guy_data = {
    "firstName": "Guy",
    "lastName": "Jones",
    "middleName": "Porter",
    "aka": "",
    "title": "Video",
    "dept": "CAMERA",
    "email": "vidguy222@gmail.com",
    "phone": "+1 661 212-3278",
    "gender": "M",
    "dob": "1958-02-22",
    "tsa": "982500664",
    "homeAirport": "LAX",
    "seatPref": "aisle",
    "loyaltyNumbers": [
        {"airline": "Delta", "number": "2071452581"},
        {"airline": "American", "number": "CNL8050"}
    ],
    "emergency": "Belinda Jones (Spouse) 213 700-5324",
    "emergencyContacts": [
        {"name": "Belinda Jones", "relationship": "Spouse", "phone": "213 700-5324"}
    ],
    "hotelRewards": "Marriot - 668207459, Hilton -836132873",
}

# Restore Jennifer's profile from her travel request data
jenn_data = {
    "firstName": "Jennifer",
    "lastName": "Naranjo",
    "middleName": "Marie",
    "aka": "Jenn",
    "title": "Travel Manager",
    "dept": "PRODUCTION",
    "email": "jn@jennifernaranjo.com",
    "phone": "+1 7146865294",
    "gender": "F",
    "dob": "1974-09-12",
    "tsa": "",
    "homeAirport": "ONT",
    "seatPref": "aisle",
    "loyaltyNumbers": [],
    "emergency": "Juan Naranjo (Dad) 714-300-4196",
    "emergencyContacts": [
        {"name": "Juan Naranjo", "relationship": "Dad", "phone": "714-300-4196"}
    ],
    "hotelRewards": "Hilton HHonors: 909005208",
    "city": "Fullerton",
    "state": "CA",
    "passport": "",
    "passportCountry": "",
    "passportExp": "",
    "prefAirline": "",
    "union": "",
    "dietary": "",
    "foodAllergies": "",
}

# Apply Jennifer's data to P95470217
for k, v in jenn_data.items():
    jenn[k] = v
print(f"\n  P95470217 restored to: {jenn['firstName']} {jenn['lastName']} - {jenn['email']}")

# Apply Guy's data to P771106255
for k, v in guy_data.items():
    guy[k] = v
print(f"  P771106255 restored to: {guy['firstName']} {guy['lastName']} - {guy['email']}")

# Check if Jennifer's travel request still exists
jenn_req = next((r for r in db["travelRequests"] if r["id"] == "R1774487025416"), None)
if jenn_req:
    print(f"\n  Jennifer's travel request R1774487025416 still exists")
else:
    print(f"\n  Jennifer's travel request was deleted - recreating...")
    db["travelRequests"].append({
        "id": "R1774487025416",
        "personId": "P95470217",
        "showId": "S2",
        "status": "submitted",
        "travelMethod": "flight",
        "selfBook": False,
        "hotel": True,
        "roomType": "double",
        "hotelRewards": "Hilton HHonors: 909005208",
        "depDate": "2026-05-15",
        "retDate": "2026-05-28",
        "depAirport": "ONT, SNA",
        "retAirport": "ATL, BHM",
        "dietary": "",
        "notes": "",
        "approvedBy": "",
        "approvedDate": "",
        "submittedName": "Jennifer Naranjo",
        "submittedEmail": "jn@jennifernaranjo.com",
        "submittedPhone": "+1 7146865294",
        "submittedDept": "PRODUCTION",
        "submittedTitle": "Travel Manager",
        "emergency": "Juan Naranjo (Dad) 714-300-4196",
        "foodAllergies": "",
        "foodPrefs": "",
        "medicalDiet": "",
        "seatPref": "aisle",
        "depTime": "Red Eye (9pm-5am)",
        "retTime": "Early Morning (5am-8am)",
        "flightNotes": "",
        "hotelCheckIn": "",
        "hotelCheckOut": "",
        "hotelNotes": "",
        "submittedDate": "2026-03-26",
        "source": "intake_form",
        "bookingDetails": {"classOfService": "ECONOMY"},
        "checklist": {}
    })
    print("  -> Recreated!")

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