Create Sales Overview Page for System Admin

[mariobehling]

Develop a Sales Overview page for the system admin, featuring two tabs to provide insights into event performance and manage invoices similar to the previous eventyay version (compare https://eventyay.com/admin/sales/invoices). The page should include detailed tables and relevant actions to streamline the administration of event sales and payments.

Requirements:

• Sales Overview Page with Two Tabs:

  a) Tab 1: Event Performance Table

  • Display events in a table format, showing key information about their performance and sales.
  • Include relevant columns such as:
    • Event Name
    • Organizer
    • Total Tickets Sold
    • Revenue Generated
    • Event Date
    • Status (e.g., Active, Completed)
    • Any additional performance metrics deemed useful for admin insights.
  • Allow sorting and filtering options to easily manage and find events.

  b) Tab 2: Invoices to Organizers

  • Display invoices issued to event organizers in a table format with the following columns:
    • Invoice Number
    • Event Name
    • Invoice Date
    • Due Date
    • Amount
    • Sent to Email
    • Status (options include: Paid, Due, Refunding, Refunded, Failed, Resolved)
      • Add functionality for the admin to change the status of an invoice directly from this table.
    • Action: “See Payment”: Provide a link to detailed payment information for each invoice.

• User Interface:

  • Design a clean, intuitive interface for the Sales Overview page with easy navigation between the two tabs.
  • Ensure tables are responsive and readable on different screen sizes.
  • Include search, filter, and sort functionalities for both tabs to facilitate data management.
  • Allow admin users to export the data in each tab as a CSV for further analysis or record-keeping.

Acceptance Criteria:

• The Sales Overview page has two tabs for Event Performance and Invoices.
• Tab 1 displays a table with detailed information about event sales and performance metrics.
• Tab 2 displays a table of invoices with columns for invoice details and payment status.
• Admins can change the status of an invoice directly from the Invoices tab.
• A "See Payment" action provides a link to detailed payment information for each invoice.
• The page is user-friendly and responsive, with search and filter options for ease of use.
• Data can be exported as a CSV from both tabs.

Additional Notes:

• Ensure that any changes made by the admin (e.g., updating invoice status) are logged for audit purposes.
• Pay attention to data privacy and security, especially regarding access to payment information.
• Provide error handling for situations where payment details may be unavailable or inaccessible.