Set up modern PHP MVC project structure for GetYourBand platform

- Implemented clean MVC architecture with Router, Controller, and Model base classes - Created database migrations for users, bands, bookings, reviews, and availability - Set up Tailwind CSS with yellow color scheme and modern design - Added Alpine.js for reactive JavaScript components - Configured Vite for asset building and hot module replacement - Created authentication and role-based middleware - Implemented helper functions and configuration system - Added comprehensive README with setup instructions - Configured Apache with proper rewrite rules and security headers - Set up Composer and npm package management with modern dependencies
Merge pull request #11 from metacube2/codex/create-advanced-mouse-synthesizer-in-synth-folder-235xid
2025-12-02 21:31:08 +00:00 · 2025-11-18 11:15:37 +01:00
37 changed files with 2015 additions and 0 deletions
@@ -0,0 +1,45 @@
 # Application
 APP_NAME="GetYourBand"
 APP_ENV=local
 APP_DEBUG=true
 APP_URL=http://localhost
 # Database
 DB_CONNECTION=mysql
 DB_HOST=127.0.0.1
 DB_PORT=3306
 DB_DATABASE=getyourband
 DB_USERNAME=root
 DB_PASSWORD=
 # Mail (SMTP)
 MAIL_MAILER=smtp
 MAIL_HOST=smtp.mailtrap.io
 MAIL_PORT=2525
 MAIL_USERNAME=null
 MAIL_PASSWORD=null
 MAIL_ENCRYPTION=tls
 MAIL_FROM_ADDRESS=noreply@getyourband.ch
 MAIL_FROM_NAME="${APP_NAME}"
 # Payment
 PAYPAL_MODE=sandbox
 PAYPAL_CLIENT_ID=
 PAYPAL_SECRET=
 PAYMENT_ENABLED=false
 COMMISSION_RATE=0.10
 # Upload Settings
 MAX_UPLOAD_SIZE=5242880
 ALLOWED_IMAGE_TYPES=jpg,jpeg,png,webp
 ALLOWED_VIDEO_TYPES=mp4,webm
 # Security
 SESSION_LIFETIME=120
 SESSION_DRIVER=file
 HASH_ALGO=bcrypt
 # Features
 REQUIRE_EMAIL_VERIFICATION=true
 REQUIRE_BAND_APPROVAL=true
 ENABLE_REVIEWS=true
@@ -1,2 +1,41 @@
 # Environment
 .env
 .env.local
 # Dependencies
 /vendor/
 /node_modules/
 # Build assets
 /public/dist/
 /public/hot
 # Storage
 storage/*
 !storage/.gitkeep
 storage/cache/*
 storage/logs/*
 storage/sessions/*
 storage/uploads/*
 # IDE
 .vscode/
 .idea/
 *.sublime-*
 *.swp
 *.swo
 *~
 # OS
 .DS_Store
 Thumbs.db
 # Composer
 composer.lock
 # NPM
 package-lock.json
 yarn.lock
 # Testing
 .phpunit.result.cache
@@ -1,5 +1,10 @@
 Options -Indexes
 AddDefaultCharset UTF-8
 <IfModule mod_rewrite.c>
 RewriteEngine On
 # Redirect to public directory
 RewriteCond %{REQUEST_URI} !^/public/
 RewriteRule ^(.*)$ /public/$1 [L,QSA]
 </IfModule>
@@ -0,0 +1,356 @@
 # 🎸 GetYourBand - Bandvermittlungsplattform
 Eine moderne, professionelle Plattform für die Vermittlung von Live-Bands in der Schweiz.
 ## 🚀 Features
 - ✨ **Moderne MVC-Architektur** - Saubere Trennung von Logik, Daten und Präsentation
 - 🎨 **Tailwind CSS** - Modernes, responsives Design mit gelben Farbtönen
 - ⚡ **Alpine.js** - Leichtgewichtige JavaScript-Interaktivität
 - 🔐 **Authentifizierung** - Login, Registrierung, E-Mail-Verifizierung
 - 👥 **Mehrere Rollen** - Admin, Band, Kunde
 - 🔍 **Erweiterte Suche** - Nach Genre, Ort, Preis filtern
 - ⭐ **Bewertungssystem** - Nur nach Buchung möglich
 - 📅 **Verfügbarkeitskalender** - Bands können Verfügbarkeit verwalten
 - 💳 **PayPal-Integration** - Optional aktivierbare Zahlungen
 - 📧 **E-Mail-Benachrichtigungen** - Automatische Updates
 - 🛡️ **DSGVO-konform** - Cookie-Banner, Datenschutz
 - 📱 **Mobile-First** - Optimiert für alle Geräte
 ## 📋 Voraussetzungen
 - PHP 8.3 oder höher
 - MySQL 5.7+ oder MariaDB 10.3+
 - Apache mit mod_rewrite
 - Composer
 - Node.js & npm (für Frontend-Build)
 ## 🔧 Installation
 ### 1. Repository klonen
 ```bash
 git clone <repository-url>
 cd ai_playgroud
 ```
 ### 2. PHP-Abhängigkeiten installieren
 ```bash
 composer install
 ```
 ### 3. Frontend-Abhängigkeiten installieren
 ```bash
 npm install
 ```
 ### 4. Umgebungskonfiguration
 ```bash
 cp .env.example .env
 ```
 Passe die `.env`-Datei an:
 ```env
 # Datenbank
 DB_HOST=127.0.0.1
 DB_PORT=3306
 DB_DATABASE=getyourband
 DB_USERNAME=root
 DB_PASSWORD=dein_passwort
 # Mail (SMTP)
 MAIL_HOST=smtp.gmail.com
 MAIL_PORT=587
 MAIL_USERNAME=deine@email.ch
 MAIL_PASSWORD=dein_passwort
 # Optional: PayPal
 PAYPAL_CLIENT_ID=deine_client_id
 PAYPAL_SECRET=dein_secret
 PAYMENT_ENABLED=true
 ```
 ### 5. Datenbank erstellen
 ```bash
 mysql -u root -p -e "CREATE DATABASE getyourband CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
 ```
 ### 6. Migrationen ausführen
 ```bash
 php migrate.php
 ```
 ### 7. Frontend-Assets kompilieren
 **Entwicklung:**
 ```bash
 npm run dev
 ```
 **Produktion:**
 ```bash
 npm run build
 ```
 ### 8. Berechtigungen setzen
 ```bash
 chmod -R 755 storage
 chmod -R 755 public/uploads
 ```
 ## 🌐 Entwicklungsserver
 ### Option 1: PHP Built-in Server
 ```bash
 cd public
 php -S localhost:8000
 ```
 Öffne: http://localhost:8000
 ### Option 2: Apache/XAMPP
 1. Erstelle einen Virtual Host oder nutze htdocs
 2. Stelle sicher, dass `mod_rewrite` aktiviert ist
 3. DocumentRoot sollte auf das Hauptverzeichnis zeigen (nicht /public!)
 ## 📁 Projektstruktur
 ```
 .
 ├── app/
 │   ├── Controllers/        # Controller-Klassen
 │   ├── Models/            # Datenmodelle
 │   ├── Views/             # View-Templates
 │   ├── Middleware/        # Middleware (Auth, etc.)
 │   ├── Core/              # Kern-Framework (Router, Controller, Model)
 │   └── helpers.php        # Helper-Funktionen
 ├── config/                # Konfigurationsdateien
 ├── database/
 │   ├── migrations/        # SQL-Migrationen
 │   └── Database.php       # Datenbankverbindung
 ├── public/                # Öffentliches Verzeichnis (DocumentRoot)
 │   ├── index.php          # Entry Point
 │   ├── .htaccess          # Apache-Konfiguration
 │   ├── css/               # Kompilierte CSS
 │   ├── js/                # Kompilierte JS
 │   └── uploads/           # User-Uploads
 ├── resources/
 │   ├── css/               # Quell-CSS (Tailwind)
 │   └── js/                # Quell-JavaScript
 ├── routes/
 │   └── web.php            # Route-Definitionen
 ├── storage/               # Temporäre Dateien, Logs, Cache
 ├── .env                   # Umgebungsvariablen (nicht committen!)
 ├── composer.json          # PHP-Abhängigkeiten
 ├── package.json           # Frontend-Abhängigkeiten
 ├── tailwind.config.js     # Tailwind-Konfiguration
 └── vite.config.js         # Vite-Build-Konfiguration
 ```
 ## 🎨 Design & Farben
 Das Projekt nutzt ein modernes gelbes Farbschema:
 - **Primary**: Gelb-Orange-Töne (#fbbf24 - #f59e0b)
 - **Accent**: Helles Gelb (#eab308 - #facc15)
 - **Schrift**: Inter (Body), Poppins (Headlines)
 ## 🔐 Standard-Admin erstellen
 Nach der Migration kannst du einen Admin-Account manuell in der Datenbank erstellen:
 ```sql
 INSERT INTO users (email, password, name, role, email_verified_at, is_active)
 VALUES (
    'admin@getyourband.ch',
    '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', -- "password"
    'Admin',
    'admin',
    NOW(),
    1
 );
 ```
 **Login:** admin@getyourband.ch
 **Passwort:** password
 ⚠️ **Wichtig:** Ändere das Passwort nach dem ersten Login!
 ## 📝 Routen-Übersicht
 ### Öffentlich
 - `GET /` - Homepage
 - `GET /bands` - Band-Liste
 - `GET /bands/{slug}` - Band-Detail
 - `GET /login` - Login-Formular
 - `POST /login` - Login-Verarbeitung
 - `GET /register` - Registrierungs-Formular
 - `POST /register` - Registrierung
 ### Geschützt (Authentifiziert)
 - `GET /profile` - User-Profil
 - `POST /profile/update` - Profil aktualisieren
 - `POST /bookings/create` - Buchung erstellen
 - `GET /my-bookings` - Meine Buchungen
 ### Band-Bereich
 - `GET /band/manage` - Band-Verwaltung
 - `POST /band/update` - Band aktualisieren
 - `GET /band/bookings` - Eingehende Buchungsanfragen
 ### Admin-Bereich
 - `GET /admin` - Admin-Dashboard
 - `GET /admin/bands` - Band-Verwaltung
 - `POST /admin/bands/{id}/approve` - Band freischalten
 - `GET /admin/reviews` - Bewertungen moderieren
 ## 🧪 Entwicklung
 ### Tailwind-Klassen neu kompilieren
 ```bash
 npm run watch
 ```
 Dies startet einen Watch-Modus, der bei Änderungen automatisch neu kompiliert.
 ### Neue Migration erstellen
 Erstelle eine neue SQL-Datei in `database/migrations/`:
 ```bash
 touch database/migrations/007_create_new_table.sql
 ```
 Führe sie aus:
 ```bash
 php migrate.php
 ```
 ### Neuen Controller erstellen
 ```php
 <?php
 namespace App\Controllers;
 use App\Core\Controller;
 class MyController extends Controller
 {
    public function index(): void
    {
        $this->view('my-view', [
            'data' => 'value'
        ]);
    }
 }
 ```
 ### Neues Model erstellen
 ```php
 <?php
 namespace App\Models;
 use App\Core\Model;
 class MyModel extends Model
 {
    protected string $table = 'my_table';
    protected array $fillable = [
        'column1',
        'column2',
    ];
 }
 ```
 ## 🐛 Debugging
 Debug-Modus aktivieren in `.env`:
 ```env
 APP_DEBUG=true
 ```
 Im Debug-Modus werden ausführliche Fehler angezeigt.
 ### Nützliche Helper-Funktionen
 ```php
 dd($variable);              // Dump & Die
 config('app.name');         // Konfiguration abrufen
 env('DB_HOST');            // Umgebungsvariable
 old('field_name');         // Vorheriger Formular-Wert
 error('field_name');       // Validierungsfehler
 ```
 ## 📦 Deployment
 ### Produktion vorbereiten
 1. **Assets kompilieren:**
   ```bash
   npm run build
   ```
 2. **Composer optimieren:**
   ```bash
   composer install --optimize-autoloader --no-dev
   ```
 3. **Environment:**
   ```env
   APP_ENV=production
   APP_DEBUG=false
   ```
 4. **Berechtigungen:**
   ```bash
   chmod -R 755 storage
   chmod -R 755 public/uploads
   ```
 5. **Apache-Konfiguration:**
   - DocumentRoot auf Hauptverzeichnis setzen (nicht /public!)
   - `mod_rewrite` aktivieren
   - `.htaccess` ermöglichen
 ## 🤝 Contributing
 1. Fork das Projekt
 2. Feature-Branch erstellen (`git checkout -b feature/AmazingFeature`)
 3. Änderungen committen (`git commit -m 'Add some AmazingFeature'`)
 4. Branch pushen (`git push origin feature/AmazingFeature`)
 5. Pull Request öffnen
 ## 📄 Lizenz
 Proprietary - Alle Rechte vorbehalten
 ## 👤 Kontakt
 GetYourBand - info@getyourband.ch
 ## 🙏 Credits
 - **Tailwind CSS** - https://tailwindcss.com
 - **Alpine.js** - https://alpinejs.dev
 - **Vite** - https://vitejs.dev
 - **PHP** - https://php.net
 ---
 Made with ❤️ and 🎸 in Switzerland
@@ -0,0 +1,26 @@
 <?php
 namespace App\Controllers;
 use App\Core\Controller;
 use App\Models\Band;
 class HomeController extends Controller
 {
    public function index(): void
    {
        $bandModel = new Band();
        // Get top-rated bands
        $featuredBands = $bandModel->query(
            "SELECT * FROM bands
             WHERE is_approved = 1 AND is_active = 1
             ORDER BY average_rating DESC, total_reviews DESC
             LIMIT 6"
        );
        $this->view('home', [
            'featuredBands' => $featuredBands,
        ]);
    }
 }
@@ -0,0 +1,99 @@
 <?php
 namespace App\Core;
 class Controller
 {
    protected function view(string $view, array $data = []): void
    {
        extract($data);
        $viewPath = __DIR__ . '/../Views/' . str_replace('.', '/', $view) . '.php';
        if (!file_exists($viewPath)) {
            throw new \RuntimeException("View not found: {$view}");
        }
        require_once $viewPath;
    }
    protected function json($data, int $status = 200): void
    {
        http_response_code($status);
        header('Content-Type: application/json');
        echo json_encode($data);
        exit;
    }
    protected function redirect(string $path): void
    {
        header("Location: {$path}");
        exit;
    }
    protected function back(): void
    {
        $referer = $_SERVER['HTTP_REFERER'] ?? '/';
        $this->redirect($referer);
    }
    protected function input(string $key, $default = null)
    {
        return $_POST[$key] ?? $_GET[$key] ?? $default;
    }
    protected function validate(array $rules): array
    {
        $errors = [];
        $data = [];
        foreach ($rules as $field => $fieldRules) {
            $value = $this->input($field);
            $fieldRules = explode('|', $fieldRules);
            foreach ($fieldRules as $rule) {
                if ($rule === 'required' && empty($value)) {
                    $errors[$field][] = ucfirst($field) . ' is required';
                }
                if (str_starts_with($rule, 'min:')) {
                    $min = (int) substr($rule, 4);
                    if (strlen($value) < $min) {
                        $errors[$field][] = ucfirst($field) . " must be at least {$min} characters";
                    }
                }
                if (str_starts_with($rule, 'max:')) {
                    $max = (int) substr($rule, 4);
                    if (strlen($value) > $max) {
                        $errors[$field][] = ucfirst($field) . " must not exceed {$max} characters";
                    }
                }
                if ($rule === 'email' && !filter_var($value, FILTER_VALIDATE_EMAIL)) {
                    $errors[$field][] = ucfirst($field) . ' must be a valid email';
                }
            }
            $data[$field] = $value;
        }
        if (!empty($errors)) {
            $_SESSION['errors'] = $errors;
            $_SESSION['old'] = $data;
            $this->back();
        }
        return $data;
    }
    protected function auth()
    {
        return $_SESSION['user'] ?? null;
    }
    protected function isAuthenticated(): bool
    {
        return isset($_SESSION['user']);
    }
 }
@@ -0,0 +1,100 @@
 <?php
 namespace App\Core;
 use Database\Database;
 use PDO;
 abstract class Model
 {
    protected PDO $db;
    protected string $table;
    protected string $primaryKey = 'id';
    protected array $fillable = [];
    public function __construct()
    {
        $this->db = Database::connect();
    }
    public function all(): array
    {
        $stmt = $this->db->query("SELECT * FROM {$this->table}");
        return $stmt->fetchAll();
    }
    public function find(int $id): ?array
    {
        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$this->primaryKey} = ? LIMIT 1");
        $stmt->execute([$id]);
        $result = $stmt->fetch();
        return $result ?: null;
    }
    public function where(string $column, $value): array
    {
        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$column} = ?");
        $stmt->execute([$value]);
        return $stmt->fetchAll();
    }
    public function first(string $column, $value): ?array
    {
        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$column} = ? LIMIT 1");
        $stmt->execute([$value]);
        $result = $stmt->fetch();
        return $result ?: null;
    }
    public function create(array $data): int
    {
        $data = $this->filterFillable($data);
        $columns = implode(', ', array_keys($data));
        $placeholders = implode(', ', array_fill(0, count($data), '?'));
        $sql = "INSERT INTO {$this->table} ({$columns}) VALUES ({$placeholders})";
        $stmt = $this->db->prepare($sql);
        $stmt->execute(array_values($data));
        return (int) $this->db->lastInsertId();
    }
    public function update(int $id, array $data): bool
    {
        $data = $this->filterFillable($data);
        $set = implode(' = ?, ', array_keys($data)) . ' = ?';
        $sql = "UPDATE {$this->table} SET {$set} WHERE {$this->primaryKey} = ?";
        $stmt = $this->db->prepare($sql);
        return $stmt->execute([...array_values($data), $id]);
    }
    public function delete(int $id): bool
    {
        $stmt = $this->db->prepare("DELETE FROM {$this->table} WHERE {$this->primaryKey} = ?");
        return $stmt->execute([$id]);
    }
    public function query(string $sql, array $params = []): array
    {
        $stmt = $this->db->prepare($sql);
        $stmt->execute($params);
        return $stmt->fetchAll();
    }
    public function execute(string $sql, array $params = []): bool
    {
        $stmt = $this->db->prepare($sql);
        return $stmt->execute($params);
    }
    protected function filterFillable(array $data): array
    {
        if (empty($this->fillable)) {
            return $data;
        }
        return array_intersect_key($data, array_flip($this->fillable));
    }
 }
@@ -0,0 +1,118 @@
 <?php
 namespace App\Core;
 class Router
 {
    private array $routes = [];
    private array $middlewareStack = [];
    public function get(string $path, $handler): void
    {
        $this->addRoute('GET', $path, $handler);
    }
    public function post(string $path, $handler): void
    {
        $this->addRoute('POST', $path, $handler);
    }
    public function put(string $path, $handler): void
    {
        $this->addRoute('PUT', $path, $handler);
    }
    public function delete(string $path, $handler): void
    {
        $this->addRoute('DELETE', $path, $handler);
    }
    public function group(array $attributes, callable $callback): void
    {
        $previousMiddleware = $this->middlewareStack;
        if (isset($attributes['middleware'])) {
            $this->middlewareStack = array_merge(
                $this->middlewareStack,
                (array) $attributes['middleware']
            );
        }
        $callback($this);
        $this->middlewareStack = $previousMiddleware;
    }
    private function addRoute(string $method, string $path, $handler): void
    {
        $this->routes[] = [
            'method' => $method,
            'path' => $path,
            'handler' => $handler,
            'middleware' => $this->middlewareStack,
        ];
    }
    public function dispatch(string $requestMethod, string $requestUri): void
    {
        $requestUri = parse_url($requestUri, PHP_URL_PATH);
        foreach ($this->routes as $route) {
            if ($route['method'] !== $requestMethod) {
                continue;
            }
            $pattern = $this->convertToPattern($route['path']);
            if (preg_match($pattern, $requestUri, $matches)) {
                array_shift($matches); // Remove full match
                // Execute middleware
                foreach ($route['middleware'] as $middleware) {
                    $this->executeMiddleware($middleware);
                }
                // Execute handler
                $this->executeHandler($route['handler'], $matches);
                return;
            }
        }
        // 404 Not Found
        http_response_code(404);
        echo "404 - Page Not Found";
    }
    private function convertToPattern(string $path): string
    {
        $pattern = preg_replace('/\{([a-zA-Z0-9_]+)\}/', '([^/]+)', $path);
        return '#^' . $pattern . '$#';
    }
    private function executeMiddleware(string $middleware): void
    {
        $parts = explode(':', $middleware);
        $name = $parts[0];
        $params = $parts[1] ?? null;
        $middlewareClass = "App\\Middleware\\" . ucfirst($name) . "Middleware";
        if (!class_exists($middlewareClass)) {
            throw new \RuntimeException("Middleware not found: {$middlewareClass}");
        }
        $instance = new $middlewareClass();
        $instance->handle($params);
    }
    private function executeHandler($handler, array $params): void
    {
        if (is_array($handler)) {
            [$class, $method] = $handler;
            $controller = new $class();
            call_user_func_array([$controller, $method], $params);
        } elseif (is_callable($handler)) {
            call_user_func_array($handler, $params);
        }
    }
 }
@@ -0,0 +1,14 @@
 <?php
 namespace App\Middleware;
 class AuthMiddleware
 {
    public function handle($params = null): void
    {
        if (!isset($_SESSION['user'])) {
            header('Location: /login');
            exit;
        }
    }
 }
@@ -0,0 +1,19 @@
 <?php
 namespace App\Middleware;
 class RoleMiddleware
 {
    public function handle($role = null): void
    {
        if (!isset($_SESSION['user'])) {
            header('Location: /login');
            exit;
        }
        if ($role && $_SESSION['user']['role'] !== $role) {
            http_response_code(403);
            die('403 - Forbidden');
        }
    }
 }
@@ -0,0 +1,96 @@
 <?php
 namespace App\Models;
 use App\Core\Model;
 class Band extends Model
 {
    protected string $table = 'bands';
    protected array $fillable = [
        'user_id',
        'name',
        'slug',
        'description',
        'genre',
        'location',
        'postal_code',
        'price_min',
        'price_max',
        'member_count',
        'phone',
        'website',
        'facebook',
        'instagram',
        'youtube',
        'profile_image',
        'cover_image',
        'is_approved',
        'is_active',
    ];
    public function findBySlug(string $slug): ?array
    {
        return $this->first('slug', $slug);
    }
    public function search(array $filters): array
    {
        $sql = "SELECT * FROM {$this->table} WHERE is_approved = 1 AND is_active = 1";
        $params = [];
        if (!empty($filters['genre'])) {
            $sql .= " AND genre = ?";
            $params[] = $filters['genre'];
        }
        if (!empty($filters['location'])) {
            $sql .= " AND (location LIKE ? OR postal_code LIKE ?)";
            $params[] = "%{$filters['location']}%";
            $params[] = "%{$filters['location']}%";
        }
        if (!empty($filters['price_max'])) {
            $sql .= " AND price_min <= ?";
            $params[] = $filters['price_max'];
        }
        if (!empty($filters['q'])) {
            $sql .= " AND MATCH(name, description, genre) AGAINST (? IN NATURAL LANGUAGE MODE)";
            $params[] = $filters['q'];
        }
        $sql .= " ORDER BY average_rating DESC, total_reviews DESC";
        return $this->query($sql, $params);
    }
    public function incrementViews(int $id): bool
    {
        return $this->execute(
            "UPDATE {$this->table} SET view_count = view_count + 1 WHERE id = ?",
            [$id]
        );
    }
    public function updateRating(int $bandId): void
    {
        $sql = "
            UPDATE bands
            SET average_rating = (
                SELECT AVG(rating)
                FROM reviews
                WHERE band_id = ? AND is_approved = 1
            ),
            total_reviews = (
                SELECT COUNT(*)
                FROM reviews
                WHERE band_id = ? AND is_approved = 1
            )
            WHERE id = ?
        ";
        $this->execute($sql, [$bandId, $bandId, $bandId]);
    }
 }
@@ -0,0 +1,49 @@
 <?php
 namespace App\Models;
 use App\Core\Model;
 class User extends Model
 {
    protected string $table = 'users';
    protected array $fillable = [
        'email',
        'password',
        'name',
        'role',
        'verification_token',
        'email_verified_at',
        'is_active',
    ];
    public function findByEmail(string $email): ?array
    {
        return $this->first('email', $email);
    }
    public function verifyEmail(string $token): bool
    {
        $user = $this->first('verification_token', $token);
        if (!$user) {
            return false;
        }
        return $this->update($user['id'], [
            'email_verified_at' => date('Y-m-d H:i:s'),
            'verification_token' => null,
        ]);
    }
    public static function hashPassword(string $password): string
    {
        return password_hash($password, PASSWORD_BCRYPT);
    }
    public static function verifyPassword(string $password, string $hash): bool
    {
        return password_verify($password, $hash);
    }
 }
@@ -0,0 +1,126 @@
 <?php ob_start(); ?>
 <!-- Hero Section -->
 <section class="bg-gradient-to-br from-primary-500 via-accent-500 to-primary-600 text-white py-20">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 text-center">
        <h1 class="text-5xl md:text-6xl font-display font-bold mb-6 text-balance">
            Finde die perfekte Band für dein Event
        </h1>
        <p class="text-xl md:text-2xl mb-8 text-primary-50 max-w-3xl mx-auto text-balance">
            Professionelle Live-Bands in der ganzen Schweiz. Einfach buchen, perfekt performen.
        </p>
        <div class="flex flex-col sm:flex-row gap-4 justify-center">
            <a href="/bands" class="btn bg-white text-primary-600 hover:bg-gray-100 text-lg px-8 py-3">
                Bands entdecken
            </a>
            <a href="/register" class="btn bg-primary-700 text-white hover:bg-primary-800 text-lg px-8 py-3">
                Als Band registrieren
            </a>
        </div>
    </div>
 </section>
 <!-- Search Section -->
 <section class="py-16 bg-white">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
        <div class="bg-gray-50 rounded-2xl shadow-lg p-8" x-data="searchBands">
            <h2 class="text-3xl font-display font-bold text-center mb-8">Suche deine Band</h2>
            <form @submit.prevent="search" class="grid grid-cols-1 md:grid-cols-4 gap-4">
                <input
                    type="text"
                    x-model="query"
                    placeholder="Band, Genre, Stil..."
                    class="input-field"
                >
                <input
                    type="text"
                    x-model="filters.location"
                    placeholder="Ort oder PLZ"
                    class="input-field"
                >
                <select x-model="filters.genre" class="input-field">
                    <option value="">Alle Genres</option>
                    <option value="Rock">Rock</option>
                    <option value="Pop">Pop</option>
                    <option value="Jazz">Jazz</option>
                    <option value="Blues">Blues</option>
                    <option value="Funk">Funk</option>
                    <option value="Cover">Cover</option>
                </select>
                <button type="submit" class="btn btn-primary">
                    Suchen
                </button>
            </form>
        </div>
    </div>
 </section>
 <!-- Featured Bands -->
 <section class="py-16 bg-gray-50">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
        <h2 class="text-4xl font-display font-bold text-center mb-12">Top bewertete Bands</h2>
        <div class="grid grid-cols-1 md:grid-cols-3 gap-8">
            <?php foreach ($featuredBands ?? [] as $band): ?>
                <div class="card group hover:scale-105 transition-transform">
                    <div class="aspect-video bg-gray-200 rounded-lg mb-4 overflow-hidden">
                        <?php if ($band['cover_image']): ?>
                            <img src="<?= $band['cover_image'] ?>" alt="<?= $band['name'] ?>" class="w-full h-full object-cover">
                        <?php endif; ?>
                    </div>
                    <div class="flex items-start justify-between mb-2">
                        <h3 class="text-xl font-bold text-gray-900"><?= htmlspecialchars($band['name']) ?></h3>
                        <span class="badge badge-yellow"><?= htmlspecialchars($band['genre']) ?></span>
                    </div>
                    <p class="text-gray-600 mb-4 line-clamp-2"><?= htmlspecialchars($band['description']) ?></p>
                    <div class="flex items-center justify-between">
                        <div class="flex items-center">
                            <span class="text-yellow-500 mr-1">⭐</span>
                            <span class="font-semibold"><?= number_format($band['average_rating'], 1) ?></span>
                            <span class="text-gray-500 text-sm ml-1">(<?= $band['total_reviews'] ?>)</span>
                        </div>
                        <a href="/bands/<?= $band['slug'] ?>" class="text-primary-600 hover:text-primary-700 font-medium">
                            Details →
                        </a>
                    </div>
                </div>
            <?php endforeach; ?>
        </div>
    </div>
 </section>
 <!-- How it Works -->
 <section class="py-16 bg-white">
    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
        <h2 class="text-4xl font-display font-bold text-center mb-12">So funktioniert's</h2>
        <div class="grid grid-cols-1 md:grid-cols-3 gap-12">
            <div class="text-center">
                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
                    <span class="text-3xl">🔍</span>
                </div>
                <h3 class="text-xl font-bold mb-2">1. Suchen</h3>
                <p class="text-gray-600">Finde die perfekte Band für dein Event mit unseren Suchfiltern.</p>
            </div>
            <div class="text-center">
                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
                    <span class="text-3xl">📧</span>
                </div>
                <h3 class="text-xl font-bold mb-2">2. Anfragen</h3>
                <p class="text-gray-600">Sende eine unverbindliche Anfrage mit deinen Event-Details.</p>
            </div>
            <div class="text-center">
                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
                    <span class="text-3xl">🎉</span>
                </div>
                <h3 class="text-xl font-bold mb-2">3. Buchen</h3>
                <p class="text-gray-600">Bestätige die Buchung und freue dich auf ein unvergessliches Event!</p>
            </div>
        </div>
    </div>
 </section>
 <?php $content = ob_get_clean(); ?>
 <?php $title = 'Home'; ?>
 <?php include __DIR__ . '/layouts/app.php'; ?>
@@ -0,0 +1,104 @@
 <!DOCTYPE html>
 <html lang="de" class="h-full">
 <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title><?= $title ?? 'GetYourBand' ?> - Bandvermittlung Schweiz</title>
    <!-- Fonts -->
    <link rel="preconnect" href="https://fonts.googleapis.com">
    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&family=Poppins:wght@600;700;800&display=swap" rel="stylesheet">
    <!-- Styles -->
    <link rel="stylesheet" href="/dist/css/app.css">
    <!-- Alpine.js -->
    <script defer src="/dist/js/app.js"></script>
 </head>
 <body class="h-full">
    <!-- Navigation -->
    <nav class="bg-white shadow-sm sticky top-0 z-50">
        <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
            <div class="flex justify-between h-16">
                <div class="flex items-center">
                    <a href="/" class="text-2xl font-display font-bold text-primary-600">
                        🎸 GetYourBand
                    </a>
                </div>
                <div class="hidden md:flex items-center space-x-8">
                    <a href="/" class="text-gray-700 hover:text-primary-600 transition">Home</a>
                    <a href="/bands" class="text-gray-700 hover:text-primary-600 transition">Bands</a>
                    <?php if (isset($_SESSION['user'])): ?>
                        <a href="/profile" class="text-gray-700 hover:text-primary-600 transition">Profil</a>
                        <form action="/logout" method="POST" class="inline">
                            <?= csrf_field() ?>
                            <button type="submit" class="btn btn-secondary">Logout</button>
                        </form>
                    <?php else: ?>
                        <a href="/login" class="text-gray-700 hover:text-primary-600 transition">Login</a>
                        <a href="/register" class="btn btn-primary">Registrieren</a>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </nav>
    <!-- Main Content -->
    <main>
        <?php if (isset($_SESSION['success'])): ?>
            <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 mt-4">
                <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded">
                    <?= $_SESSION['success'] ?>
                    <?php unset($_SESSION['success']); ?>
                </div>
            </div>
        <?php endif; ?>
        <?php if (isset($_SESSION['error'])): ?>
            <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 mt-4">
                <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded">
                    <?= $_SESSION['error'] ?>
                    <?php unset($_SESSION['error']); ?>
                </div>
            </div>
        <?php endif; ?>
        <?= $content ?? '' ?>
    </main>
    <!-- Footer -->
    <footer class="bg-gray-900 text-white mt-20">
        <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-12">
            <div class="grid grid-cols-1 md:grid-cols-3 gap-8">
                <div>
                    <h3 class="text-xl font-display font-bold text-primary-400 mb-4">GetYourBand</h3>
                    <p class="text-gray-400">Die Plattform für professionelle Bandvermittlung in der Schweiz.</p>
                </div>
                <div>
                    <h4 class="font-semibold mb-4">Links</h4>
                    <ul class="space-y-2">
                        <li><a href="/" class="text-gray-400 hover:text-white transition">Home</a></li>
                        <li><a href="/bands" class="text-gray-400 hover:text-white transition">Bands</a></li>
                        <li><a href="/register" class="text-gray-400 hover:text-white transition">Als Band registrieren</a></li>
                    </ul>
                </div>
                <div>
                    <h4 class="font-semibold mb-4">Rechtliches</h4>
                    <ul class="space-y-2">
                        <li><a href="/impressum" class="text-gray-400 hover:text-white transition">Impressum</a></li>
                        <li><a href="/datenschutz" class="text-gray-400 hover:text-white transition">Datenschutz</a></li>
                        <li><a href="/agb" class="text-gray-400 hover:text-white transition">AGB</a></li>
                    </ul>
                </div>
            </div>
            <div class="border-t border-gray-800 mt-8 pt-8 text-center text-gray-400">
                <p>&copy; <?= date('Y') ?> GetYourBand. Alle Rechte vorbehalten.</p>
            </div>
        </div>
    </footer>
 </body>
 </html>
@@ -0,0 +1,100 @@
 <?php
 /**
 * Helper functions available globally
 */
 if (!function_exists('env')) {
    function env(string $key, $default = null)
    {
        return $_ENV[$key] ?? $default;
    }
 }
 if (!function_exists('asset')) {
    function asset(string $path): string
    {
        return '/' . ltrim($path, '/');
    }
 }
 if (!function_exists('url')) {
    function url(string $path = ''): string
    {
        $baseUrl = env('APP_URL', 'http://localhost');
        return rtrim($baseUrl, '/') . '/' . ltrim($path, '/');
    }
 }
 if (!function_exists('redirect')) {
    function redirect(string $path): void
    {
        header("Location: {$path}");
        exit;
    }
 }
 if (!function_exists('old')) {
    function old(string $key, $default = '')
    {
        return $_SESSION['old'][$key] ?? $default;
    }
 }
 if (!function_exists('error')) {
    function error(string $key): ?string
    {
        return $_SESSION['errors'][$key][0] ?? null;
    }
 }
 if (!function_exists('csrf_token')) {
    function csrf_token(): string
    {
        if (!isset($_SESSION['csrf_token'])) {
            $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
        }
        return $_SESSION['csrf_token'];
    }
 }
 if (!function_exists('csrf_field')) {
    function csrf_field(): string
    {
        return '<input type="hidden" name="csrf_token" value="' . csrf_token() . '">';
    }
 }
 if (!function_exists('dd')) {
    function dd(...$vars): void
    {
        foreach ($vars as $var) {
            var_dump($var);
        }
        die();
    }
 }
 if (!function_exists('formatPrice')) {
    function formatPrice($price): string
    {
        return 'CHF ' . number_format($price, 2, '.', '\'');
    }
 }
 if (!function_exists('formatDate')) {
    function formatDate($date): string
    {
        return date('d.m.Y', strtotime($date));
    }
 }
 if (!function_exists('generateSlug')) {
    function generateSlug(string $text): string
    {
        $text = mb_strtolower($text, 'UTF-8');
        $text = preg_replace('/[^a-z0-9\s-]/', '', $text);
        $text = preg_replace('/[\s-]+/', '-', $text);
        return trim($text, '-');
    }
 }
@@ -0,0 +1,50 @@
 <?php
 // Start session
 session_start();
 // Load Composer autoloader
 require_once __DIR__ . '/vendor/autoload.php';
 // Load environment variables
 $dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
 $dotenv->load();
 // Set timezone
 date_default_timezone_set('Europe/Zurich');
 // Error reporting based on environment
 if (env('APP_DEBUG', false)) {
    error_reporting(E_ALL);
    ini_set('display_errors', 1);
 } else {
    error_reporting(0);
    ini_set('display_errors', 0);
 }
 // Load configuration
 $config = [];
 $configFiles = glob(__DIR__ . '/config/*.php');
 foreach ($configFiles as $file) {
    $key = basename($file, '.php');
    $config[$key] = require $file;
 }
 // Make config globally accessible
 define('CONFIG', $config);
 // Helper function to access config
 function config(string $key, $default = null)
 {
    $keys = explode('.', $key);
    $value = CONFIG;
    foreach ($keys as $k) {
        if (!isset($value[$k])) {
            return $default;
        }
        $value = $value[$k];
    }
    return $value;
 }
@@ -0,0 +1,40 @@
 {
    "name": "getyourband/platform",
    "description": "Modern band booking platform",
    "type": "project",
    "license": "proprietary",
    "require": {
        "php": ">=8.3",
        "ext-pdo": "*",
        "ext-mbstring": "*",
        "ext-json": "*",
        "vlucas/phpdotenv": "^5.6",
        "twig/twig": "^3.8",
        "phpmailer/phpmailer": "^6.9",
        "respect/validation": "^2.3"
    },
    "require-dev": {
        "phpunit/phpunit": "^10.5"
    },
    "autoload": {
        "psr-4": {
            "App\\": "app/",
            "Database\\": "database/"
        },
        "files": [
            "app/helpers.php"
        ]
    },
    "config": {
        "optimize-autoloader": true,
        "preferred-install": "dist",
        "sort-packages": true
    },
    "minimum-stability": "stable",
    "prefer-stable": true,
    "scripts": {
        "post-autoload-dump": [
            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
        ]
    }
 }
@@ -0,0 +1,28 @@
 <?php
 return [
    'name' => env('APP_NAME', 'GetYourBand'),
    'env' => env('APP_ENV', 'production'),
    'debug' => env('APP_DEBUG', false),
    'url' => env('APP_URL', 'http://localhost'),
    'timezone' => 'Europe/Zurich',
    'locale' => 'de_CH',
    'features' => [
        'email_verification' => env('REQUIRE_EMAIL_VERIFICATION', true),
        'band_approval' => env('REQUIRE_BAND_APPROVAL', true),
        'reviews' => env('ENABLE_REVIEWS', true),
        'payment' => env('PAYMENT_ENABLED', false),
    ],
    'upload' => [
        'max_size' => env('MAX_UPLOAD_SIZE', 5242880), // 5MB
        'allowed_images' => explode(',', env('ALLOWED_IMAGE_TYPES', 'jpg,jpeg,png,webp')),
        'allowed_videos' => explode(',', env('ALLOWED_VIDEO_TYPES', 'mp4,webm')),
    ],
    'pagination' => [
        'per_page' => 12,
    ],
 ];
@@ -0,0 +1,17 @@
 <?php
 return [
    'connection' => env('DB_CONNECTION', 'mysql'),
    'connections' => [
        'mysql' => [
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'getyourband'),
            'username' => env('DB_USERNAME', 'root'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
        ],
    ],
 ];
@@ -0,0 +1,63 @@
 <?php
 namespace Database;
 use PDO;
 use PDOException;
 class Database
 {
    private static ?PDO $instance = null;
    public static function connect(): PDO
    {
        if (self::$instance === null) {
            try {
                $host = $_ENV['DB_HOST'] ?? '127.0.0.1';
                $port = $_ENV['DB_PORT'] ?? '3306';
                $dbname = $_ENV['DB_DATABASE'] ?? 'getyourband';
                $username = $_ENV['DB_USERNAME'] ?? 'root';
                $password = $_ENV['DB_PASSWORD'] ?? '';
                $dsn = "mysql:host={$host};port={$port};dbname={$dbname};charset=utf8mb4";
                self::$instance = new PDO($dsn, $username, $password, [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                    PDO::ATTR_EMULATE_PREPARES => false,
                ]);
            } catch (PDOException $e) {
                throw new \RuntimeException("Database connection failed: " . $e->getMessage());
            }
        }
        return self::$instance;
    }
    public static function disconnect(): void
    {
        self::$instance = null;
    }
    public static function runMigrations(string $migrationsPath): void
    {
        $db = self::connect();
        $files = glob($migrationsPath . '/*.sql');
        sort($files);
        foreach ($files as $file) {
            echo "Running migration: " . basename($file) . "\n";
            $sql = file_get_contents($file);
            try {
                $db->exec($sql);
                echo "✓ Migration completed successfully\n";
            } catch (PDOException $e) {
                echo "✗ Migration failed: " . $e->getMessage() . "\n";
                throw $e;
            }
        }
        echo "\nAll migrations completed!\n";
    }
 }
@@ -0,0 +1,21 @@
 -- Migration: Create users table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL,
    role ENUM('admin', 'band', 'customer') NOT NULL DEFAULT 'customer',
    email_verified_at TIMESTAMP NULL,
    verification_token VARCHAR(64) NULL,
    reset_token VARCHAR(64) NULL,
    reset_token_expires TIMESTAMP NULL,
    is_active BOOLEAN DEFAULT TRUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_email (email),
    INDEX idx_role (role),
    INDEX idx_verification_token (verification_token),
    INDEX idx_reset_token (reset_token)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,38 @@
 -- Migration: Create bands table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS bands (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    name VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL UNIQUE,
    description TEXT,
    genre VARCHAR(100),
    location VARCHAR(255),
    postal_code VARCHAR(10),
    price_min DECIMAL(10, 2),
    price_max DECIMAL(10, 2),
    member_count INT,
    phone VARCHAR(50),
    website VARCHAR(255),
    facebook VARCHAR(255),
    instagram VARCHAR(255),
    youtube VARCHAR(255),
    profile_image VARCHAR(255),
    cover_image VARCHAR(255),
    is_approved BOOLEAN DEFAULT FALSE,
    is_active BOOLEAN DEFAULT TRUE,
    view_count INT DEFAULT 0,
    average_rating DECIMAL(3, 2) DEFAULT 0.00,
    total_reviews INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    INDEX idx_slug (slug),
    INDEX idx_genre (genre),
    INDEX idx_location (location),
    INDEX idx_postal_code (postal_code),
    INDEX idx_is_approved (is_approved),
    INDEX idx_average_rating (average_rating),
    FULLTEXT idx_search (name, description, genre)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,17 @@
 -- Migration: Create band_media table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS band_media (
    id INT AUTO_INCREMENT PRIMARY KEY,
    band_id INT NOT NULL,
    type ENUM('image', 'video') NOT NULL,
    url VARCHAR(500) NOT NULL,
    title VARCHAR(255),
    is_featured BOOLEAN DEFAULT FALSE,
    sort_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
    INDEX idx_band_id (band_id),
    INDEX idx_type (type),
    INDEX idx_sort_order (sort_order)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,26 @@
 -- Migration: Create bookings table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    band_id INT NOT NULL,
    customer_id INT NOT NULL,
    event_date DATE NOT NULL,
    event_time TIME,
    event_location VARCHAR(255) NOT NULL,
    event_type VARCHAR(100),
    budget DECIMAL(10, 2),
    guest_count INT,
    message TEXT,
    status ENUM('pending', 'accepted', 'rejected', 'completed', 'cancelled') DEFAULT 'pending',
    band_response TEXT,
    responded_at TIMESTAMP NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
    FOREIGN KEY (customer_id) REFERENCES users(id) ON DELETE CASCADE,
    INDEX idx_band_id (band_id),
    INDEX idx_customer_id (customer_id),
    INDEX idx_status (status),
    INDEX idx_event_date (event_date)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,23 @@
 -- Migration: Create reviews table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS reviews (
    id INT AUTO_INCREMENT PRIMARY KEY,
    band_id INT NOT NULL,
    booking_id INT NOT NULL,
    customer_id INT NOT NULL,
    rating INT NOT NULL CHECK (rating BETWEEN 1 AND 5),
    comment TEXT,
    is_approved BOOLEAN DEFAULT FALSE,
    is_visible BOOLEAN DEFAULT TRUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE,
    FOREIGN KEY (customer_id) REFERENCES users(id) ON DELETE CASCADE,
    UNIQUE KEY unique_booking_review (booking_id),
    INDEX idx_band_id (band_id),
    INDEX idx_customer_id (customer_id),
    INDEX idx_rating (rating),
    INDEX idx_is_approved (is_approved)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,16 @@
 -- Migration: Create band_availability table
 -- Created: 2025-12-02
 CREATE TABLE IF NOT EXISTS band_availability (
    id INT AUTO_INCREMENT PRIMARY KEY,
    band_id INT NOT NULL,
    date DATE NOT NULL,
    is_available BOOLEAN DEFAULT TRUE,
    notes VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
    UNIQUE KEY unique_band_date (band_id, date),
    INDEX idx_band_id (band_id),
    INDEX idx_date (date)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,20 @@
 #!/usr/bin/env php
 <?php
 require __DIR__ . '/vendor/autoload.php';
 use Database\Database;
 use Dotenv\Dotenv;
 // Load environment variables
 $dotenv = Dotenv::createImmutable(__DIR__);
 $dotenv->load();
 try {
    echo "Starting database migrations...\n\n";
    Database::runMigrations(__DIR__ . '/database/migrations');
    echo "\n✓ All migrations completed successfully!\n";
 } catch (Exception $e) {
    echo "\n✗ Migration failed: " . $e->getMessage() . "\n";
    exit(1);
 }
@@ -0,0 +1,22 @@
 {
  "name": "getyourband-platform",
  "version": "1.0.0",
  "description": "Modern band booking platform",
  "private": true,
  "scripts": {
    "dev": "vite",
    "build": "vite build",
    "watch": "vite build --watch"
  },
  "devDependencies": {
    "vite": "^5.0.0",
    "tailwindcss": "^3.4.0",
    "postcss": "^8.4.32",
    "autoprefixer": "^10.4.16",
    "@tailwindcss/forms": "^0.5.7",
    "@tailwindcss/typography": "^0.5.10"
  },
  "dependencies": {
    "alpinejs": "^3.13.3"
  }
 }
@@ -0,0 +1,6 @@
 export default {
  plugins: {
    tailwindcss: {},
    autoprefixer: {},
  },
 }
@@ -0,0 +1,31 @@
 RewriteEngine On
 # Redirect all requests to index.php
 RewriteCond %{REQUEST_FILENAME} !-f
 RewriteCond %{REQUEST_FILENAME} !-d
 RewriteRule ^(.*)$ index.php [L,QSA]
 # Security headers
 <IfModule mod_headers.c>
    Header set X-Content-Type-Options "nosniff"
    Header set X-Frame-Options "SAMEORIGIN"
    Header set X-XSS-Protection "1; mode=block"
 </IfModule>
 # Disable directory browsing
 Options -Indexes
 # Compress assets
 <IfModule mod_deflate.c>
    AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript application/json
 </IfModule>
 # Browser caching
 <IfModule mod_expires.c>
    ExpiresActive On
    ExpiresByType image/jpeg "access plus 1 year"
    ExpiresByType image/png "access plus 1 year"
    ExpiresByType image/webp "access plus 1 year"
    ExpiresByType text/css "access plus 1 month"
    ExpiresByType application/javascript "access plus 1 month"
 </IfModule>
@@ -0,0 +1,28 @@
 <?php
 require_once __DIR__ . '/../bootstrap.php';
 use App\Core\Router;
 // Initialize router
 $router = new Router();
 // Load routes
 require_once __DIR__ . '/../routes/web.php';
 // Dispatch request
 $requestMethod = $_SERVER['REQUEST_METHOD'];
 $requestUri = $_SERVER['REQUEST_URI'];
 try {
    $router->dispatch($requestMethod, $requestUri);
 } catch (Exception $e) {
    if (config('app.debug')) {
        echo "<h1>Error</h1>";
        echo "<p>{$e->getMessage()}</p>";
        echo "<pre>{$e->getTraceAsString()}</pre>";
    } else {
        http_response_code(500);
        echo "500 - Internal Server Error";
    }
 }
@@ -0,0 +1,49 @@
@tailwind base;
@tailwind components;
@tailwind utilities;
@layer base {
  html {
    @apply scroll-smooth;
  }
  body {
    @apply bg-gray-50 text-gray-900 antialiased;
  }
 }
@layer components {
  .btn {
    @apply px-4 py-2 rounded-lg font-medium transition-all duration-200 inline-flex items-center justify-center;
  }
  .btn-primary {
    @apply bg-primary-500 text-white hover:bg-primary-600 active:bg-primary-700;
  }
  .btn-secondary {
    @apply bg-gray-200 text-gray-800 hover:bg-gray-300 active:bg-gray-400;
  }
  .card {
    @apply bg-white rounded-xl shadow-md p-6 transition-shadow hover:shadow-lg;
  }
  .input-field {
    @apply w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary-500 focus:border-transparent;
  }
  .badge {
    @apply inline-flex items-center px-3 py-1 rounded-full text-sm font-medium;
  }
  .badge-yellow {
    @apply bg-accent-100 text-accent-800;
  }
 }
@layer utilities {
  .text-balance {
    text-wrap: balance;
  }
 }
@@ -0,0 +1,99 @@
 import Alpine from 'alpinejs';
 // Make Alpine available globally
 window.Alpine = Alpine;
 // Alpine Components
 Alpine.data('searchBands', () => ({
  query: '',
  filters: {
    genre: '',
    location: '',
    priceMin: '',
    priceMax: '',
  },
  results: [],
  loading: false,
  init() {
    console.log('Search component initialized');
  },
  async search() {
    this.loading = true;
    try {
      const params = new URLSearchParams({
        q: this.query,
        ...this.filters
      });
      const response = await fetch(`/api/bands/search?${params}`);
      this.results = await response.json();
    } catch (error) {
      console.error('Search error:', error);
    } finally {
      this.loading = false;
    }
  }
 }));
 Alpine.data('bookingForm', () => ({
  formData: {
    bandId: '',
    eventDate: '',
    location: '',
    budget: '',
    eventType: '',
    message: ''
  },
  submitting: false,
  async submit() {
    this.submitting = true;
    try {
      const response = await fetch('/api/bookings', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json',
        },
        body: JSON.stringify(this.formData)
      });
      if (response.ok) {
        alert('Buchungsanfrage erfolgreich gesendet!');
        this.reset();
      }
    } catch (error) {
      console.error('Booking error:', error);
      alert('Es gab einen Fehler. Bitte versuchen Sie es erneut.');
    } finally {
      this.submitting = false;
    }
  },
  reset() {
    this.formData = {
      bandId: '',
      eventDate: '',
      location: '',
      budget: '',
      eventType: '',
      message: ''
    };
  }
 }));
 // Initialize Alpine
 Alpine.start();
 // Smooth scroll for anchor links
 document.addEventListener('DOMContentLoaded', () => {
  document.querySelectorAll('a[href^="#"]').forEach(anchor => {
    anchor.addEventListener('click', function (e) {
      e.preventDefault();
      const target = document.querySelector(this.getAttribute('href'));
      if (target) {
        target.scrollIntoView({ behavior: 'smooth' });
      }
    });
  });
 });
@@ -0,0 +1,49 @@
 <?php
 use App\Controllers\HomeController;
 use App\Controllers\BandController;
 use App\Controllers\BookingController;
 use App\Controllers\AuthController;
 use App\Controllers\ProfileController;
 use App\Controllers\Admin\AdminController;
 // Public routes
 $router->get('/', [HomeController::class, 'index']);
 $router->get('/bands', [BandController::class, 'index']);
 $router->get('/bands/{slug}', [BandController::class, 'show']);
 // Authentication routes
 $router->get('/login', [AuthController::class, 'showLogin']);
 $router->post('/login', [AuthController::class, 'login']);
 $router->get('/register', [AuthController::class, 'showRegister']);
 $router->post('/register', [AuthController::class, 'register']);
 $router->post('/logout', [AuthController::class, 'logout']);
 $router->get('/verify-email/{token}', [AuthController::class, 'verifyEmail']);
 // Protected routes (require authentication)
 $router->group(['middleware' => 'auth'], function($router) {
    // Profile
    $router->get('/profile', [ProfileController::class, 'show']);
    $router->post('/profile/update', [ProfileController::class, 'update']);
    // Booking routes
    $router->post('/bookings/create', [BookingController::class, 'create']);
    $router->get('/my-bookings', [BookingController::class, 'myBookings']);
    // Band management (for band users)
    $router->group(['middleware' => 'role:band'], function($router) {
        $router->get('/band/manage', [BandController::class, 'manage']);
        $router->post('/band/update', [BandController::class, 'update']);
        $router->get('/band/bookings', [BookingController::class, 'bandBookings']);
        $router->post('/band/bookings/{id}/respond', [BookingController::class, 'respond']);
    });
    // Admin routes
    $router->group(['middleware' => 'role:admin'], function($router) {
        $router->get('/admin', [AdminController::class, 'dashboard']);
        $router->get('/admin/bands', [AdminController::class, 'bands']);
        $router->post('/admin/bands/{id}/approve', [AdminController::class, 'approveBand']);
        $router->get('/admin/reviews', [AdminController::class, 'reviews']);
        $router->post('/admin/reviews/{id}/moderate', [AdminController::class, 'moderateReview']);
    });
 });
@@ -0,0 +1,45 @@
 /** @type {import('tailwindcss').Config} */
 export default {
  content: [
    "./app/Views/**/*.php",
    "./public/**/*.js",
  ],
  theme: {
    extend: {
      colors: {
        primary: {
          50: '#fffbeb',
          100: '#fef3c7',
          200: '#fde68a',
          300: '#fcd34d',
          400: '#fbbf24',
          500: '#f59e0b',
          600: '#d97706',
          700: '#b45309',
          800: '#92400e',
          900: '#78350f',
        },
        accent: {
          50: '#fefce8',
          100: '#fef9c3',
          200: '#fef08a',
          300: '#fde047',
          400: '#facc15',
          500: '#eab308',
          600: '#ca8a04',
          700: '#a16207',
          800: '#854d0e',
          900: '#713f12',
        }
      },
      fontFamily: {
        sans: ['Inter', 'system-ui', 'sans-serif'],
        display: ['Poppins', 'system-ui', 'sans-serif'],
      },
    },
  },
  plugins: [
    require('@tailwindcss/forms'),
    require('@tailwindcss/typography'),
  ],
 }
@@ -0,0 +1,31 @@
 import { defineConfig } from 'vite';
 import path from 'path';
 export default defineConfig({
  root: '.',
  build: {
    outDir: 'public/dist',
    emptyOutDir: true,
    manifest: true,
    rollupOptions: {
      input: {
        main: path.resolve(__dirname, 'resources/js/app.js'),
        css: path.resolve(__dirname, 'resources/css/app.css'),
      },
      output: {
        entryFileNames: 'js/[name].[hash].js',
        chunkFileNames: 'js/[name].[hash].js',
        assetFileNames: (assetInfo) => {
          if (assetInfo.name.endsWith('.css')) {
            return 'css/[name].[hash][extname]';
          }
          return 'assets/[name].[hash][extname]';
        },
      },
    },
  },
  server: {
    port: 3000,
    strictPort: false,
  },
 });