analytics_system.php

<?php
class AnalyticsSystem {
    private $pdo;
    private $currentTime = '2025-06-14 13:33:08';
    private $currentUser = 'imabutahersiddik';

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

    public function recordPageView($page, $params = []) {
        $stmt = $this->pdo->prepare("
            INSERT INTO page_views 
            (page, params, user_id, ip_address, user_agent, created_at)
            VALUES (?, ?, ?, ?, ?, ?)
        ");

        return $stmt->execute([
            $page,
            json_encode($params),
            isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null,
            $_SERVER['REMOTE_ADDR'],
            $_SERVER['HTTP_USER_AGENT'],
            $this->currentTime
        ]);
    }

    public function getAppAnalytics($appId, $period = 'last_30_days') {
        $dateRange = match($period) {
            'today' => "DATE(created_at) = CURDATE()",
            'last_7_days' => "created_at >= DATE_SUB(?, INTERVAL 7 DAY)",
            'last_30_days' => "created_at >= DATE_SUB(?, INTERVAL 30 DAY)",
            'all_time' => "1=1"
        };

        $sql = "
            SELECT 
                DATE(created_at) as date,
                COUNT(*) as views,
                COUNT(DISTINCT user_id) as unique_visitors,
                COUNT(DISTINCT CASE WHEN event_type = 'download' THEN id END) as downloads
            FROM app_events
            WHERE app_id = ? AND $dateRange
            GROUP BY DATE(created_at)
            ORDER BY date DESC
        ";

        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([$appId, $this->currentTime]);
        return $stmt->fetchAll();
    }

    public function getUserBehavior($userId) {
        $sql = "
            SELECT 
                user_actions.action_type,
                COUNT(*) as count,
                AVG(TIMESTAMPDIFF(SECOND, session_start, session_end)) as avg_duration
            FROM user_sessions
            JOIN user_actions ON user_sessions.id = user_actions.session_id
            WHERE user_sessions.user_id = ?
            GROUP BY user_actions.action_type
        ";

        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([$userId]);
        return $stmt->fetchAll();
    }
}