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. With an organisation-level key it covers every
company, or only SPENDESK_COMPANY_ID if set.
Scopes: experimental:invoice:read, and experimental:company:read (organisation-level key) or
user:read (company-level key) to find the company.
"""
import base64, datetime as dt, json, os, sys, urllib.error, urllib.parse, urllib.request

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


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, company=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))


def companies(need_id=False):
    """The companies to cover, as (id, name, X-Company-Id header).

    Organisation-level key: every company of the organisation, or only SPENDESK_COMPANY_ID if set.
    Company-level key: the key's own company (no header needed)."""
    only = os.environ.get("SPENDESK_COMPANY_ID")
    try:
        found, page = [], 1
        while True:
            result = api("GET", "/v2/companies", {"page": page, "pageSize": 30})
            found += [(c["id"], c["name"], c["id"]) for c in result["data"]]
            if page * 30 >= result["meta"]["pagination"]["total"]:
                return [c for c in found if not only or c[0] == only]
            page += 1
    except urllib.error.HTTPError:
        if only:  # organisation-level key without experimental:company:read
            return [(only, only, only)]
        own = api("GET", "/v1/users", {"pageSize": 1})["data"][0]["companyId"] if need_id else None
        return [(own, "", None)]

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"], "stage": ["inReview", "toSettle"],
         "sortBy": "dueDate", "sort": "asc", "limit": 100}

for company_id, company_name, _ in companies(need_id=True):
    # 1. Approved invoices not fully paid, due before the cutoff, earliest first.
    #    The company goes in the path of v2 endpoints.
    invoices, cursor = [], None
    while True:
        page = api("GET", f"/v2/companies/{company_id}/invoices", dict(query, **({"cursor": cursor} if cursor else {})))
        invoices += page["data"]
        cursor = page["meta"]["pagination"]["nextCursor"]
        if not cursor:
            break

    # 2. Print them, then the total still due per currency. Amounts are in cents: divide by 100.
    if company_name:
        print(f"\n== {company_name}")
    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"{len(invoices)} invoices due by {cutoff}:",
          ", ".join(f"{amount / 100:,.2f} {currency}" for currency, amount in sorted(totals.items())) or "nothing")