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/domains/soundstudiopro.com/private_html/api/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * Get Artist's Public Crates (CrateList)
 * For display on artist profile pages
 * GET: artist_id (required)
 * Returns: { success: bool, crates: array }
 */
session_start();
header('Content-Type: application/json');

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

$artist_id = isset($_GET['artist_id']) ? (int)$_GET['artist_id'] : 0;

if (!$artist_id) {
    echo json_encode(['success' => false, 'error' => 'Artist ID is required']);
    exit;
}

try {
    $pdo = getDBConnection();
    
    // Check if is_description_public column exists
    $checkDescCol = $pdo->query("SHOW COLUMNS FROM artist_playlists LIKE 'is_description_public'");
    $hasDescPublicColumn = $checkDescCol->rowCount() > 0;
    $descPublicField = $hasDescPublicColumn ? ", ap.is_description_public" : "";
    
    // Get all public crates for this artist with track counts and durations
    $stmt = $pdo->prepare("
        SELECT 
            ap.id,
            ap.name,
            ap.description,
            ap.created_at,
            ap.updated_at $descPublicField,
            COUNT(DISTINCT pt.track_id) as track_count,
            COALESCE(SUM(mt.duration), 0) as total_duration,
            COALESCE(SUM(CASE 
                WHEN mt.duration >= 300 THEN 2.5 
                ELSE mt.duration * 0.5 / 60 
            END), 0) as set_duration_minutes,
            u.name as artist_name,
            u.id as artist_id
        FROM artist_playlists ap
        JOIN users u ON ap.user_id = u.id
        LEFT JOIN playlist_tracks pt ON ap.id = pt.playlist_id
        LEFT JOIN music_tracks mt ON pt.track_id = mt.id AND mt.status = 'complete'
        WHERE ap.user_id = ? AND ap.is_public = 1
        GROUP BY ap.id, ap.name, ap.description, ap.created_at, ap.updated_at, u.name, u.id
        ORDER BY ap.updated_at DESC
    ");
    
    $stmt->execute([$artist_id]);
    $crates = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Filter out hidden descriptions
    foreach ($crates as &$crate) {
        $descPublic = $hasDescPublicColumn ? ($crate['is_description_public'] ?? 1) : 1;
        if (!$descPublic) {
            $crate['description'] = null;
        }
    }
    unset($crate);
    
    // Calculate 2-hour set progress for each crate
    foreach ($crates as &$crate) {
        $setDuration = floatval($crate['set_duration_minutes']);
        $crate['is_2_hour_set'] = $setDuration >= 120;
        $crate['set_progress_percent'] = min(100, ($setDuration / 120) * 100);
        $crate['tracks_needed_for_2h'] = $setDuration < 120 ? max(0, ceil((120 - $setDuration) / 2.5)) : 0;
        
        // Format duration as human readable
        $totalSeconds = intval($crate['total_duration']);
        $hours = floor($totalSeconds / 3600);
        $minutes = floor(($totalSeconds % 3600) / 60);
        $crate['duration_formatted'] = $hours > 0 
            ? sprintf('%dh %dm', $hours, $minutes)
            : sprintf('%dm', $minutes);
    }
    
    echo json_encode([
        'success' => true,
        'crates' => $crates,
        'artist_id' => $artist_id
    ]);
    
} catch (Exception $e) {
    error_log("Error getting artist public crates: " . $e->getMessage());
    echo json_encode(['success' => false, 'error' => 'Failed to load crates']);
}