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

# Find person
matches = [p for p in db["persons"] if "nunnally" in p.get("lastName","").lower()]
for p in matches:
    print(f"Person: {p['id']} {p['firstName']} {p['lastName']} email={p.get('email','')}")
    
    # Assignments
    assignments = [a for a in db["assignments"] if a["personId"] == p["id"]]
    print(f"  Assignments: {[a['showId'] for a in assignments]}")
    
    # Travel requests
    reqs = [r for r in db["travelRequests"] if r.get("personId") == p["id"]]
    print(f"  Travel requests: {len(reqs)}")
    for r in reqs:
        print(f"    {r['id']} showId={r.get('showId','')} status={r.get('status','')} submittedDate={r.get('submittedDate','')} depDate={r.get('depDate','')} retDate={r.get('retDate','')}")

    # Also check for requests by email or name that might not be linked
    orphan_reqs = [r for r in db["travelRequests"] if "nunnally" in r.get("submittedName","").lower() and r.get("personId") != p["id"]]
    if orphan_reqs:
        print(f"  ORPHANED requests (different personId):")
        for r in orphan_reqs:
            print(f"    {r['id']} personId={r.get('personId','')} status={r.get('status','')} submittedDate={r.get('submittedDate','')}")