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/-293ddee6/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
session_start();
header('Content-Type: application/json');

require_once '../config/database.php';

try {
    $pdo = getDBConnection();
    
    $artist_id = $_GET['artist_id'] ?? null;
    $type = $_GET['type'] ?? 'all';
    
    if (!$artist_id) {
        throw new Exception('Artist ID is required');
    }
    
    // Build query based on type
    $where_clause = "WHERE mt.user_id = ? AND mt.is_public = 1";
    if ($type === 'completed') {
        $where_clause .= " AND mt.status = 'complete'";
    } elseif ($type === 'tracks') {
        // All tracks (including processing, failed, etc.)
    }
    
    // Get current user ID for variation preferences (if logged in)
    $current_user_id = $_SESSION['user_id'] ?? 0;
    
    $stmt = $pdo->prepare("
        SELECT 
            mt.id,
            mt.title,
            mt.prompt,
            mt.duration,
            mt.audio_url,
            mt.status,
            mt.created_at,
            mt.music_type,
            mt.metadata,
            mt.user_id,
            u.name as artist_name,
            MAX(uvp.variation_id) as preferred_variation_id
        FROM music_tracks mt
        JOIN users u ON mt.user_id = u.id
        LEFT JOIN user_variation_preferences uvp ON mt.id = uvp.track_id AND uvp.user_id = ? AND uvp.is_main_track = TRUE
        $where_clause
        GROUP BY mt.id, mt.title, mt.prompt, mt.duration, mt.audio_url, mt.status, mt.created_at, mt.music_type, mt.metadata, mt.user_id, u.name
        ORDER BY mt.created_at DESC
    ");
    
    $stmt->execute([$current_user_id, $artist_id]);
    $tracks = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Process tracks for display with variation selection logic
    // Priority: 1) Track metadata selected_variation, 2) user_variation_preferences, 3) default track audio
    $processed_tracks = [];
    foreach ($tracks as $track) {
        // Determine preferred audio URL based on variation selection
        $preferred_audio_url = $track['audio_url']; // Default to original track
        $preferred_duration = $track['duration']; // Default to original track duration
        
        // First, check track metadata for selected_variation (set by track owner in library.php)
        $trackMetadata = json_decode($track['metadata'] ?? '{}', true) ?: [];
        $selectedVariationIndex = $trackMetadata['selected_variation'] ?? null;
        
        if ($selectedVariationIndex !== null) {
            // Get the selected variation from audio_variations table (including duration)
            $var_stmt = $pdo->prepare("SELECT audio_url, duration FROM audio_variations WHERE track_id = ? AND variation_index = ?");
            $var_stmt->execute([$track['id'], $selectedVariationIndex]);
            $variation = $var_stmt->fetch(PDO::FETCH_ASSOC);
            
            if ($variation && $variation['audio_url']) {
                $preferred_audio_url = $variation['audio_url'];
                // Use variation duration if available, otherwise keep main track duration
                if (!empty($variation['duration'])) {
                    $preferred_duration = $variation['duration'];
                }
            }
        } elseif ($track['preferred_variation_id']) {
            // Fallback to user_variation_preferences if no metadata selection
            $var_stmt = $pdo->prepare("SELECT audio_url, duration FROM audio_variations WHERE id = ?");
            $var_stmt->execute([$track['preferred_variation_id']]);
            $variation = $var_stmt->fetch(PDO::FETCH_ASSOC);
            
            if ($variation && $variation['audio_url']) {
                $preferred_audio_url = $variation['audio_url'];
                // Use variation duration if available, otherwise keep main track duration
                if (!empty($variation['duration'])) {
                    $preferred_duration = $variation['duration'];
                }
            }
        }
        
        // Only include tracks with audio URLs (either original or variation)
        if ($preferred_audio_url) {
            // Parse metadata for additional info
            $metadata = json_decode($track['metadata'] ?: '{}', true);
            
            // IMPORTANT: Use main track audio_url, NOT preferred_audio_url
            // preferred_audio_url might be a preview variation (44 seconds)
            // We want the full track for playlist playback
            $processed_tracks[] = [
                'id' => $track['id'],
                'title' => $track['title'] ?: 'Untitled Track',
                'duration' => $preferred_duration,
                'audio_url' => $preferred_audio_url,
                'status' => $track['status'],
                'created_at' => $track['created_at'],
                'music_type' => $track['music_type'] ?: 'music',
                'genre' => $metadata['genre'] ?? 'Unknown',
                'description' => $track['prompt'] ?: '',
                'artist_name' => $track['artist_name'] ?: 'Unknown Artist',
                'user_id' => $track['user_id']
            ];
        }
    }
    
    echo json_encode([
        'success' => true,
        'tracks' => $processed_tracks,
        'count' => count($processed_tracks)
    ]);
    
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode([
        'success' => false,
        'error' => $e->getMessage()
    ]);
}
?>