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

for pd in db.get("perDiems", []):
    if pd.get("showId") != "S2":
        continue
    person = next((p for p in db["persons"] if p["id"] == pd.get("personId")), None)
    if person and "josserand" in person.get("lastName","").lower():
        req = next((r for r in db["travelRequests"] if r["id"] == pd.get("reqId")), None)
        days = pd.get("manualDays") if pd.get("manualDays") is not None else pd.get("autoDays", 0)
        rate = pd.get("manualRate") if pd.get("manualRate") is not None else pd.get("autoRate", 0)
        print(f"PD ID: {pd['id']}")
        print(f"  PersonID: {pd.get('personId','')}")
        print(f"  ReqID: {pd.get('reqId','')}")
        print(f"  Name: {person.get('firstName','')} {person.get('lastName','')}")
        print(f"  Dates: {pd.get('checkIn','')}-{pd.get('checkOut','')}")
        print(f"  Days: {days}, Rate: {rate}, Total: ${days*rate}")
        if req:
            bd = req.get("bookingDetails", {})
            cl = req.get("checklist", {})
            print(f"  Req status: {req.get('status','')}, show: {req.get('showId','')}")
            print(f"  pdEligible: {bd.get('pdEligible','not set')}")
            print(f"  pd_ineligible: {cl.get('pd_ineligible','not set')}")
        else:
            print(f"  ** NO MATCHING TRAVEL REQUEST **")
        print()