Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/.cursor-server/data/User/History/-1fcb2e4b/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * Get Notification Count API
 * Returns the total count of unread notifications for the current user
 */

header('Content-Type: application/json');
session_start();
require_once __DIR__ . '/../config/database.php';
require_once __DIR__ . '/../includes/security.php';

// Check authentication
if (!isset($_SESSION['user_id'])) {
    echo json_encode(['success' => false, 'message' => 'Authentication required']);
    exit;
}

$user_id = $_SESSION['user_id'];
$pdo = getDBConnection();

if (!$pdo) {
    echo json_encode(['success' => false, 'message' => 'Database connection failed']);
    exit;
}

try {
    // Count friend requests
    $stmt = $pdo->prepare("SELECT COUNT(*) FROM user_friends WHERE friend_id = ? AND status = 'pending'");
    $stmt->execute([$user_id]);
    $friend_requests = (int)$stmt->fetchColumn();
    
    // Count likes on user's tracks (excluding user's own likes)
    $stmt = $pdo->prepare("
        SELECT COUNT(*) 
        FROM track_likes tl 
        JOIN music_tracks mt ON tl.track_id = mt.id 
        WHERE mt.user_id = ? AND tl.user_id != ?
    ");
    $stmt->execute([$user_id, $user_id]);
    $likes = (int)$stmt->fetchColumn();
    
    // Count comments on user's tracks (excluding user's own comments)
    $stmt = $pdo->prepare("
        SELECT COUNT(*) 
        FROM track_comments tc 
        JOIN music_tracks mt ON tc.track_id = mt.id 
        WHERE mt.user_id = ? AND tc.user_id != ?
    ");
    $stmt->execute([$user_id, $user_id]);
    $comments = (int)$stmt->fetchColumn();
    
    $total_count = $friend_requests + $likes + $comments;
    
    echo json_encode([
        'success' => true,
        'unread_count' => $total_count,
        'breakdown' => [
            'friend_requests' => $friend_requests,
            'likes' => $likes,
            'comments' => $comments
        ]
    ]);
} catch (PDOException $e) {
    error_log("Error getting notification count: " . $e->getMessage());
    echo json_encode(['success' => false, 'message' => 'Database error occurred']);
}