Poll User Workspaces Invoices.

[elraphty]

Context

Currently, we poll Workspace budget invoices using the /poll/invoices/{uuid} route, to achieve this a user has to click the Manage button on a single Workspace on the sphinx-tribes frontend app before the Workspace budget can be updated.

Design

We want to create a new endpoint /poll/{user_pubkey}/workspaces/invoices, that will add the functionality of updating the Workspaces budget on the Workspace list on the front end. The user will not have to click on a single Workspace to get the revised budget.

To Achieve This:

• We will get the user public key from the route params
• Search for all the workspaces the user is an admin or has the Role to view workspace budget
• Then will loop through all the pending invoices that are not expired, if the invoice is paid we will add the invoice amount to the workspace budget.
• If the invoice is not paid and expired we will prune the invoice from the invoice_lists table
• if the invoice has not been paid, and hasn't expired, we will keep the invoice on the invoice_lists table.

This Issue is blocked by Issue #1679.

Acceptance Criteria

• I've tested on Chrome
• I've created a test that...
• I have rebased and tested locally before submitting my PR
• I can submit a PR within 2 days of taking the bounty

Here is an example backend test