Events – Showcase

Showcases are individual-focused events where athletes register solo to display their talents to college recruiters. They differ from tournaments (team-based) by emphasizing one-on-one evaluations and custom attendee experiences.

🎯 Purpose

  • Enable athletes to register as attendees (not teams).
  • Present athlete profiles and stats to recruiters.
  • Offer social graphics generation (Twitter, Instagram).
  • Provide exports, packets, and reporting tuned for showcases.

📦 Data Model

Showcases use the generic Event model with a type of showcase.

Relation Model Cardinality Notes
Event (type=showcase) Attendee 1-to-many Individual registrations
Event Question 1-to-many Custom registration fields
Attendee Answer 1-to-many Response to each Question
Event ShowcaseSchedule 1-to-many Scheduling templates for one-on-one slots
// In App\Models\Event
public function attendees() {
    return $this->hasMany(Attendee::class);
}
public function isShowcase(): bool {
    return $this->type === 'showcase';
}
public function socialTemplates(): array {
    // Returns ['twitter' => TemplateModel, 'instagram' => ...]
}

🚦 Routing

Public Routes

Prefix: /e

  • Event Homepage & Registration
    GET /e/{event} → redirect to new URL
    GET /e/{event}/register/{slug?} → EventViewController@show
  • Attendee List
    GET /e/{event}/attendees → AttendeeController@publicAttendeeList
  • College & Team Lists, Packets
    GET /e/{event}/colleges → CollegeController@publicCollegeList
    GET /e/{event}/packet/{token} → CollegeController@packet

Protected/Admin Routes

Under auth + role:Admin|Event Manager:

  • GET /events/{event}/attendees → EventController@indexEventAttendees
  • GET /events/{event}/show-packet → AttendeeController@showPacket
  • POST /events/{event}/create-packet → AttendeeController@postCreatePacket
  • POST /orders/{order}/generate-subscription → OrderController@generateSubscriptionCodes

🛠 Controllers & Key Methods

EventViewController

Handles public pages and legacy redirects.

class EventViewController extends Controller {
    public function show(Event $event): View {
        // Loads event, questions, dynamic pricing
        return view('public.events.show', compact('event'));
    }
}

AttendeeController

Manages attendee CRUD, exports, packets, and social graphics.

  • publicAttendeeList(Event $e, AttendeeFilters $f)
    Returns public attendee page, orders by jersey number on showcases.
  • showCreatePacket(Event $e) / postCreatePacket(Request, Event $e)
    Builds Google-Sheet packet; enqueues events:sendShowcasePackets.
  • exportAll(Request)
    Queues AllAttendeeExport to S3.
  • ballerTVExport(Event $e) → BallerTVExport.
  • store(Request)
    Creates Order + Attendee, handles Stripe session.

Console Commands

Command Responsibility
php artisan app:generate-graphic {attendee} Generate social graphics per platform
php artisan graphics:generate {website} Batch-generate for all upcoming showcases

🎨 Views & Blade Partials

Public Views

  • resources/views/public/events/show.blade.php
    Composite includes:
    • partials/description.blade.php
    • partials/countdown.blade.php
    • Registration form (Livewire Rsvp component).

Dashboard (Admin)

  • resources/views/dashboard/events/partials/event-header.blade.php
  • resources/views/dashboard/attendees/print-packet.blade.php
  • resources/views/dashboard/reports/showcase-report.blade.php
  • resources/views/dashboard/reports/showcase-upsells-table.blade.php

📊 Reporting & Exports

  • Showcase Report (/showcase-report)
    Visualizes registrations by day, upsells, drop reasons.
  • AllAttendeeExport
    Compiles attendee data across events to Excel.
  • BallerTVExport
    Formats for BallerTV API integration.

🧩 Social Graphic Workflow

  1. Retrieve live showcases (type = 'showcase', start_date >= now).
  2. For each attendee with social templates:
    • Check storage (s3) for existing graphic.
    • Call app:generate-graphic if missing.
    • Email attendee via AttendeeGraphic mailable.

✍️ Mermaid Diagrams

Entity Relationship (Showcase)

erDiagram
    EVENT }|--|{ ATTENDEE : has
    EVENT ||--o{ QUESTION : asks
    ATTENDEE ||--o{ ANSWER : provides
    EVENT ||--o{ SHOWCASE_SCHEDULE : offers

Registration Flow

sequenceDiagram
    participant User
    participant PublicSite
    participant Stripe
    participant Server
    User->>PublicSite: GET /e/{event}/register
    PublicSite->>Stripe: Create Checkout Session
    Stripe-->>User: Redirect to Payment
    Stripe->>Server: Webhook (payment.succeeded)
    Server->>Attendee: create()
    Server->>Order: create()
    Server->>User: Confirmation Email

🔌 API Endpoints

{
  "title": "Public Showcase Attendee List",
  "description": "Retrieve all attendees for a given showcase event.",
  "method": "GET",
  "baseUrl": "https://events.prephoops.com/e",
  "endpoint": "/{event}/attendees",
  "pathParams": [
    { "key": "event", "value": "Event ID", "required": true }
  ],
  "headers": [],
  "queryParams": [],
  "bodyType": "none",
  "responses": {
    "200": {
      "description": "HTML view of registered attendees.",
      "body": "<html>...attendee list...</html>"
    }
  }
}

⚙️ Dependencies & Technologies

  • Backend: PHP 8+, Laravel 8
  • Views: Blade (OneUI + Bootstrap)
  • Database: MySQL, Eloquent ORM
  • Queue & Exports: Maatwebsite Excel, Laravel Queue
  • Payments: Stripe Checkout
  • Messaging: Twilio (SMS), Braze integration
  • Graphics: Intervention Image, AWS S3

Documentation generated using code references from the Prep Network Events repository.