2026-09-26 (overdue)  Office Supplies Ltd            FA-2026-3391          1,944.00 EUR
2026-10-02            Cloud Hosting Inc              INV-88412             2,490.00 EUR

2 invoices due by 2026-10-06: 4,434.00 EUR

"""List the supplier invoices to pay in the next N days (default 7), overdue ones included.

Usage: python3 due_invoices.py [DAYS]
Needs SPENDESK_CLIENT_ID and SPENDESK_CLIENT_SECRET; SPENDESK_COMPANY_ID with an organisation-level key.
Scopes: experimental:invoice:read, user:read (to find your company ID with a company-level key).
"""
import base64, datetime as dt, json, os, sys, urllib.parse, urllib.request

BASE = os.environ.get("SPENDESK_BASE_URL", "https://public-api.spendesk.com")
COMPANY = os.environ.get("SPENDESK_COMPANY_ID")


def token():
    creds = base64.b64encode(f"{os.environ['SPENDESK_CLIENT_ID']}:{os.environ['SPENDESK_CLIENT_SECRET']}".encode()).decode()
    req = urllib.request.Request(BASE + "/v1/auth/token", data=b"grant_type=client_credentials",
                                 headers={"Authorization": "Basic " + creds, "Content-Type": "application/x-www-form-urlencoded"})
    return json.load(urllib.request.urlopen(req))["access_token"]


TOKEN = token()


def api(method, path, query=None, body=None):
    url = BASE + path + ("?" + urllib.parse.urlencode(query, doseq=True) if query else "")
    headers = {"Authorization": "Bearer " + TOKEN, "Content-Type": "application/json"}
    if COMPANY:
        headers["X-Company-Id"] = COMPANY
    req = urllib.request.Request(url, method=method, headers=headers, data=json.dumps(body).encode() if body else None)
    return json.load(urllib.request.urlopen(req))


# 1. The company ID goes in the path of v2 endpoints. A company-level key reads it from any user.
company = COMPANY or api("GET", "/v1/users", {"pageSize": 1})["data"][0]["companyId"]

# 2. Approved invoices not fully paid, due before the cutoff, earliest first.
days = int(sys.argv[1]) if len(sys.argv) > 1 else 7
cutoff = dt.date.today() + dt.timedelta(days=days)
query = {"dueBefore": str(cutoff), "paymentStatus": ["unpaid", "partiallyPaid"], "approvalStatus": ["approved"],
         "sortBy": "dueDate", "sort": "asc", "limit": 100}
invoices, cursor = [], None
while True:
    page = api("GET", f"/v2/companies/{company}/invoices", dict(query, **({"cursor": cursor} if cursor else {})))
    invoices += page["data"]
    cursor = page["meta"]["pagination"]["nextCursor"]
    if not cursor:
        break

# 3. Print them, then the total still due per currency. Amounts are in cents: divide by 100.
totals = {}
for inv in invoices:
    late = " (overdue)" if inv["dueDate"] < str(dt.date.today()) else ""
    print(f"{inv['dueDate']}{late}  {inv['supplier']['name']:<30} {inv['invoiceNumber']:<20} "
          f"{inv['amountDue'] / 100:>12,.2f} {inv['currency']}")
    totals[inv["currency"]] = totals.get(inv["currency"], 0) + inv["amountDue"]
print(f"\n{len(invoices)} invoices due by {cutoff}:",
      ", ".join(f"{amount / 100:,.2f} {currency}" for currency, amount in sorted(totals.items())) or "nothing")