File size: 930 Bytes
0dff816
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?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()]);
}
?>