import json, glob, os

backup_dir = "/home/rmlac2fmr/public_html/jn.com/ops/backups/"
files = sorted(glob.glob(backup_dir + "db-*.json"), reverse=True)

for f in files[:3]:
    db = json.load(open(f))
    approvals = db.get("approvals", [])
    foster = [a for a in approvals if "foster" in a.get("description","").lower() or "foster" in a.get("requestedBy","").lower() or "date" in a.get("type","").lower()]
    print(f"{os.path.basename(f)}: {len(approvals)} approvals, Foster matches: {len(foster)}")
    for a in foster:
        print(f"  {a['id']} {a['status']} {a.get('type','')} {a.get('description','')[:60]}")
    if not foster:
        # Show all in case it's under a different name
        for a in approvals:
            if a["id"] not in ["AP1774493018258","AP1774542680646","AP1774551174053","AP1774555580607","AP1774642381345","AP1774984657199"]:
                print(f"  EXTRA: {a['id']} {a['status']} {a.get('type','')} {a.get('description','')[:60]}")