<?php
/**
 * MYASSET API - User Asset Tree Structure
 * =======================================
 * 
 * DESKRIPSI:
 * ==========
 * API untuk mendapatkan struktur tree asset user berdasarkan grup dan license.
 * Mengembalikan hierarchical data user -> groups -> licenses dalam format JSON.
 * 
 * METHOD: GET
 * ENDPOINT: /api/myasset
 * AUTHENTICATION: Required (Bearer token atau session)
 * 
 * RESPONSE SUCCESS (200):
 * =======================
 * {
 *   "success": true,
 *   "data": {
 *     "username": "dayansgi",
 *     "fullName": "SGI Kutai",
 *     "groups": [
 *       {
 *         "userGroupID": "713",
 *         "groupName": "Group Name",
 *         "licenses": [
 *           {
 *             "license": "BM 9613 RC",
 *             "tid": "862292051351138"
 *           }
 *         ]
 *       }
 *     ]
 *   },
 *   "statistics": {...},
 *   "processing_info": {...}
 * }
 * 
 * BUSINESS LOGIC:
 * ===============
 * 1. Get user groups berdasarkan username dari session
 * 2. Untuk setiap group, get licenses yang valid (endTime > now)
 * 3. Filter licenses berdasarkan customerID range (MinNo - MaxNo)
 * 4. Return dalam format JSON clean tanpa HTML
 * 5. Set session variables untuk group mapping (optional)
 * 
 * DATABASE TABLES:
 * ================
 * - tbUserGroupMulti: User group relationships
 * - tbUserGroup: Group definitions dengan MinNo/MaxNo
 * - tbLicenseTran: License transactions dengan customerID dan endTime
 * 
 * AUTHOR: Rodhi
 * DATE: 2026-01-19
 * VERSION: 1.0
 */

require_once __DIR__.'/../models/database.php';
require_once __DIR__.'/../helpers/session_helper.php';
require_once __DIR__.'/../auth/middleware.php';

if (!headers_sent()) {
    header('Access-Control-Allow-Origin: *');
    header('Access-Control-Allow-Methods: GET, POST, OPTIONS');
    header('Access-Control-Allow-Headers: Content-Type, Authorization, X-Auth-Token');
    header('Access-Control-Allow-Credentials: true');
    header('Content-Type: application/json');
}

// Set content type
header('Content-Type: application/json');

// Handle CORS preflight
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit;
}

// Only allow GET method
if ($_SERVER['REQUEST_METHOD'] !== 'GET') {
    http_response_code(405);
    echo json_encode([
        'error' => 'Method not allowed',
        'allowed_methods' => ['GET']
    ]);
    exit;
}

// Start performance monitoring
$startTime = microtime(true);
$startMemory = memory_get_usage(true);

// Debug: Log API access
// error_log("MyAsset API accessed");
// error_log("Request method: " . $_SERVER['REQUEST_METHOD']);

try {
    // Require authentication
    $user = authRequired();
    
    // Debug: Log authenticated user
    // error_log("MyAsset API - Authenticated user: " . $user);

    // Get database connection
    $pdo = Database::getConnection();
    
    // Get user information from session data (dari login response)
    $fullName = $user; // Default to username
    
    // Try to get fullName from session or use username
    // Note: fullName biasanya sudah ada di login response
    
    // Initialize response data
    $responseData = array(
        'username' => $user,
        'fullName' => $fullName,
        'groups' => array()
    );
    
    // Debug: Log user groups query
    // error_log("MyAsset API - Getting user groups for: " . $user);
    
    // Step 1: Get user groups (berdasarkan original SQL)
    $sql1 = "SELECT tbUserGroupMulti.userGroupID, tbUserGroup.des 
             FROM tbUserGroupMulti 
             INNER JOIN tbUserGroup ON tbUserGroupMulti.userGroupID = tbUserGroup.userGroupID 
             WHERE userName = ? 
             ORDER BY tbUserGroup.des ASC";
    
    $stmt1 = $pdo->prepare($sql1);
    $stmt1->execute([$user]);
    $userGroups = $stmt1->fetchAll(PDO::FETCH_ASSOC);
    
    // Debug: Log found groups
    // error_log("MyAsset API - Found " . count($userGroups) . " groups for user: " . $user);
    
    // Process each group
    foreach ($userGroups as $group) {
        $groupData = array(
            'userGroupID' => $group['userGroupID'],
            'groupName' => $group['des'],
            'licenses' => array()
        );
        
        // Add to HTML tree
        // $htmlTree .= '<li class="jstree-open">';
        // $htmlTree .= '<a href="#"><img src="media/folder.png" />&nbsp;<b>' . htmlspecialchars($group['des']) . '</b></a>';
        // $htmlTree .= '<ul>';
        
        // Debug: Log license query for group
        // error_log("MyAsset API - Getting licenses for group: " . $group['userGroupID']);
        
        // Step 2: Get licenses untuk group ini (berdasarkan original SQL)
        $sql2 = "SELECT license, tid 
                 FROM tbLicenseTran 
                 WHERE customerID BETWEEN 
                     (SELECT MinNo FROM tbUserGroup WHERE userGroupID = ?) 
                     AND 
                     (SELECT MaxNo FROM tbUserGroup WHERE userGroupID = ?) 
                 AND endTime > ? 
                 ORDER BY tbLicenseTran.license ASC";
        
        $currentDateTime = date("Y-m-d H:i:s");
        $stmt2 = $pdo->prepare($sql2);
        $stmt2->execute([$group['userGroupID'], $group['userGroupID'], $currentDateTime]);
        $licenses = $stmt2->fetchAll(PDO::FETCH_ASSOC);
        
        // Debug: Log found licenses
        // error_log("MyAsset API - Found " . count($licenses) . " licenses for group: " . $group['userGroupID']);
        
        // Process each license
        foreach ($licenses as $license) {
            // Add to group data
            $groupData['licenses'][] = array(
                'license' => $license['license'],
                'tid' => $license['tid']
            );
            
            // Set session variable (berdasarkan original code)
            // $_SESSION['group' . $license['license']] = $group['des'];
            
            // Add to HTML tree
            // $htmlTree .= '<li>';
            // $htmlTree .= '<a href="javascript:temukan(\'' . htmlspecialchars($license['license']) . '\')">';
            // $htmlTree .= '<img src="media/file.png" />&nbsp;' . htmlspecialchars($license['license']);
            // $htmlTree .= '</a>';
            // $htmlTree .= '</li>';
        }
        
        // $htmlTree .= '</ul>';
        // $htmlTree .= '</li>';
        
        // Add group to response data
        $responseData['groups'][] = $groupData;
    }
    
    // $htmlTree .= '</ul>';
    // $htmlTree .= '</li>';
    // $htmlTree .= '</ul>';
    
    // Calculate statistics
    $totalGroups = count($responseData['groups']);
    $totalLicenses = 0;
    foreach ($responseData['groups'] as $group) {
        $totalLicenses += count($group['licenses']);
    }
    
    // Performance monitoring
    $endTime = microtime(true);
    $endMemory = memory_get_usage(true);
    $processingTime = round($endTime - $startTime, 2);
    $memoryUsed = round(($endMemory - $startMemory) / 1024 / 1024, 2);
    
    // Debug: Log performance metrics
    // error_log("MyAsset API - Processing completed in {$processingTime}s, Memory: {$memoryUsed}MB");
    // error_log("MyAsset API - Total groups: {$totalGroups}, Total licenses: {$totalLicenses}");
    
    // Return success response (JSON only)
    http_response_code(200);
    echo json_encode([
        'success' => true,
        'data' => $responseData,
        'statistics' => [
            'total_groups' => $totalGroups,
            'total_licenses' => $totalLicenses,
            'user' => $user
        ],
        'processing_info' => [
            'processing_time' => $processingTime . " seconds",
            'memory_usage' => $memoryUsed . " MB",
            'timestamp' => date('Y-m-d H:i:s'),
            'query_count' => 1 + count($responseData['groups']) // 1 for groups + 1 per group for licenses
        ]
    ]);

} catch (Exception $e) {
    // Log error dengan detail
    $errorTime = microtime(true);
    $errorMemory = memory_get_usage(true);
    
    error_log("MyAsset API Error: " . $e->getMessage());
    error_log("Error occurred at: " . round($errorTime - $startTime, 2) . " seconds");
    error_log("Memory at error: " . number_format($errorMemory / 1024 / 1024, 2) . " MB");
    error_log("Error trace: " . $e->getTraceAsString());
    
    http_response_code(500);
    echo json_encode([
        'error' => 'Internal server error during asset retrieval',
        'message' => $e->getMessage(),
        'processing_time' => round($errorTime - $startTime, 2) . " seconds",
        'memory_usage' => number_format(($errorMemory - $startMemory) / 1024 / 1024, 2) . " MB"
        // Debug version dengan detail error:
        // 'error_details' => [
        //     'message' => $e->getMessage(),
        //     'file' => $e->getFile(),
        //     'line' => $e->getLine(),
        //     'trace' => $e->getTraceAsString()
        // ]
    ]);
} finally {
    // Cleanup memory
    gc_collect_cycles();
}