jweb/ac1/src/api/get_tickets.php

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

if (!isset($_SESSION['logged_in']) || $_SESSION['logged_in'] !== true) {
    http_response_code(401);
    echo json_encode([]);
    exit;
}

include_once '../../db.php';
include_once '../models/User.php';
include_once '../models/SupportTicket.php';

try {
    $database = new Database();
    $db = $database->getConnection();
    
    $user = new User($db);
    $user_id = $user->syncUser(
        $_SESSION['username'],
        $_SESSION['email'],
        $_SESSION['tier'],
        $_SESSION['package']
    );
    
    $ticket = new SupportTicket($db);
    $stmt = $ticket->getUserTickets($user_id);
    
    $tickets = [];
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $tickets[] = $row;
    }
    
    echo json_encode($tickets);
    
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode(['error' => $e->getMessage()]);
}
?>