developer_dashboard.php

<?php
class DeveloperDashboard {
    private $pdo;
    private $userId;

    public function __construct($pdo, $userId) {
        $this->pdo = $pdo;
        $this->userId = $userId;
    }

    public function getAppStats() {
        $stmt = $this->pdo->prepare("
            SELECT 
                a.id,
                a.app_name,
                a.views_count,
                a.downloads_count,
                a.total_rating,
                COUNT(DISTINCT ar.id) as review_count,
                (SELECT COUNT(*) 
                 FROM app_downloads 
                 WHERE app_id = a.id 
                 AND download_date >= DATE_SUB(NOW(), INTERVAL 30 DAY)
                ) as monthly_downloads
            FROM apps a
            LEFT JOIN app_ratings ar ON a.id = ar.app_id
            WHERE a.user_id = ?
            GROUP BY a.id
            ORDER BY a.downloads_count DESC
        ");
        $stmt->execute([$this->userId]);
        return $stmt->fetchAll();
    }

    public function getRevenueStats() {
        // Implement if you have a monetization system
        return [
            'total_revenue' => 0,
            'monthly_revenue' => 0,
            'pending_payments' => 0
        ];
    }
}
?>