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

search = ["wertz", "valk", "gilmour", "webb", "boer", "castro", "wilson", "haber"]

for name in search:
    print(f"\n=== {name.upper()} ===")
    for p in db.get("persons", []):
        last = (p.get("lastName","") or "").lower()
        first = (p.get("firstName","") or "").lower()
        if name in last or name in first:
            trs = [r for r in db["travelRequests"] if r.get("personId") == p["id"] and r.get("showId") == "S3"]
            print(f"  {p.get('firstName','')} {p.get('lastName','')} (ID: {p['id']})")
            print(f"    ACF TRs: {len(trs)}")
            if trs:
                print(f"    TR status: {trs[0].get('status','')}")