profile_system.php

<?php
class UserProfile {
    private $pdo;
    private $userId;
    private $currentTime;

    public function __construct($pdo, $userId) {
        $this->pdo = $pdo;
        $this->userId = $userId;
        $this->currentTime = '2025-06-14 12:47:29'; // Using provided UTC time
    }

    public function getProfileData() {
        $stmt = $this->pdo->prepare("
            SELECT 
                u.*,
                COUNT(DISTINCT a.id) as total_apps,
                COUNT(DISTINCT ar.id) as total_reviews,
                SUM(a.downloads_count) as total_downloads
            FROM users u
            LEFT JOIN apps a ON u.id = a.user_id
            LEFT JOIN app_ratings ar ON u.id = ar.user_id
            WHERE u.id = ?
            GROUP BY u.id
        ");
        $stmt->execute([$this->userId]);
        return $stmt->fetch();
    }

    public function getActivityTimeline() {
        $stmt = $this->pdo->prepare("
            (SELECT 
                'app_submission' as type,
                app_name as title,
                submitted_at as timestamp,
                id as reference_id
            FROM apps 
            WHERE user_id = ?)
            UNION ALL
            (SELECT 
                'app_rating' as type,
                (SELECT app_name FROM apps WHERE id = app_id) as title,
                created_at as timestamp,
                app_id as reference_id
            FROM app_ratings 
            WHERE user_id = ?)
            ORDER BY timestamp DESC
            LIMIT 10
        ");
        $stmt->execute([$this->userId, $this->userId]);
        return $stmt->fetchAll();
    }
}
?>