import json

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

# Fix Donald Kent approval - P95470284 is now Douglas Fogel, Donald Kent is P771105942
for a in db["approvals"]:
    if a["id"] == "AP1774555580607":
        print(f"Fixing Donald Kent approval: {a['personId']} -> P771105942")
        a["personId"] = "P771105942"

# Fix Emily Wolfe - find her real person ID
emily = next((p for p in db["persons"] if p["lastName"].lower() == "wolfe" and p["firstName"].lower() == "emily"), None)
if emily:
    for a in db["approvals"]:
        if a["id"] == "AP1774493018258":
            print(f"Fixing Emily Wolfe approval: {a['personId']} -> {emily['id']}")
            a["personId"] = emily["id"]
else:
    print("Emily Wolfe not found in persons!")

# Fix Natoli - re-approve
for a in db["approvals"]:
    if a["id"] == "AP1774984657199":
        print(f"Fixing Natoli approval: {a['status']} -> approved")
        a["status"] = "approved"
        a["reviewedBy"] = "J.Naranjo (Coordinator)"
        a["reviewedDate"] = "2026-04-02"
        a["reason"] = "Emily is aware of the cost."

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