/* Decoded by unphp.net */


session_start();
require 'db_connection.php';
if (!isset($_SESSION['user_id'])) {
header("Location: ".($phpenable === 'true'?$login_url .'.php': $login_url));
exit;
}
$sql = "SELECT * FROM benutzer WHERE id = ".$_SESSION['user_id'];
$result = $conn->query($sql);
$user = $result->fetch_assoc();
if ($user['gesperrt'] == 1) {
session_destroy();
header("Location: ".($phpenable === 'true'?$login_url .'.php': $login_url));
exit;
}
$userId = $_SESSION['user_id'];
$ticketCreated = false;
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$ticketId = rand(10000000,99999999);
$subject = $_POST['subject'];
$message = $_POST['message'];
$sql = "INSERT INTO tickets (id, user_id, subject, message) VALUES (?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("iiss",$ticketId,$userId,$subject,$message);
$stmt->execute();
$stmt->close();
$ticketCreated = true;
}
include 'settings/config.php';
include 'settings/head.php';
include 'settings/header.php';
;echo '<br>
<section class="pt-5 bg-section-secondary">
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-lg-9">
                ';if (isset($_SESSION['success_message'])) {;echo '                    <div class="alert alert-primary" role="alert">
                        <i class="fa-solid fa-circle-exclamation"></i>
                        ';echo $_SESSION['success_message'];;echo '                    </div>
                    ';unset($_SESSION['success_message']);
;echo '                ';};echo '
                ';if (isset($_SESSION['error_message'])) {;echo '                    <div class="alert alert-danger" role="alert">
                        <i class="fa-solid fa-circle-exclamation"></i>
                        ';echo $_SESSION['error_message'];;echo '                    </div>
                    ';unset($_SESSION['error_message']);
;echo '                ';};echo '                <div class="card bg-section-dark border-0 rounded-lg" style="max-width: 100%;">
                    <h1 class="text-center mt-5">Deine Tickets</h1>

                    ';
$userId = $_SESSION['user_id'];
$sql = "SELECT id, subject, status, created_at FROM tickets WHERE user_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i",$userId);
$stmt->execute();
$stmt->bind_result($ticketId,$subject,$status,$createdAt);
if ($stmt->fetch()) {
;echo '                        <div class="table-responsive">
                            <table class="table table-cards align-items-center">
                                <thead>
                                    <tr>
                                        <th scope="col">ID</th>
                                        <th scope="col">Status</th>

                                        <th scope="col">Betreff</th>
                                        <th scope="col">Erstellt am</th>
                                    </tr>
                                </thead>
                                <tbody class="list">
                                    ';
do {
echo '<tr>';
echo '<th>'.$ticketId .'</th>';
if ($status == "offen") {
$badgeClass = "bg-success xl";
$statusText = "Offen";
}elseif ($status == "geschlossen") {
$badgeClass = "bg-danger";
$statusText = "Geschlossen";
}elseif ($status == "bearbeitung") {
$badgeClass = "bg-warning";
$statusText = "In Bearbeitung";
}else {
$badgeClass = "bg-secondary";
$statusText = "Unbekannt";
}
echo '<td><span class="badge badge-dot"><i class="'.$badgeClass .'"></i>'.$statusText .'</span></td>';
echo '<td>'.$subject .'</td>';
$datetime = new DateTime($createdAt,new DateTimeZone('Europe/Berlin'));
echo '<td>'.$datetime->format('d.m.Y H:i') .'</td>';
echo "<td class='text-right'>";
echo '<div class="dropdown float-right">
                                        <a href="'.($phpenable === 'true'?$ticketview_url .'.php?ticket_id='.$ticketId : $ticketview_url .'?ticket_id='.$ticketId) .'" role="button">
                        <i class="fas fa-eye"></i>
                    </a>';
echo '</tr>';
}while ($stmt->fetch());
;echo '                                </tbody>
                            </table>
                        </div><br>
                        ';
}else {
echo '<p class="text-center">Du hast noch keine Tickets erstellt.</p>';
}
$stmt->close();
;echo '


                </div>
                <center><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#ticketModal">
                        Ticket erstellen
                    </button></center><br>
            </div>

        </div>

    </div>
</section>

<!-- Modal -->
<div class="modal fade" tabindex="-1" role="dialog" id="ticketModal">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Ticket erstellen</h5>

            </div>
            <div class="modal-body">
                <form action="actions/create_ticket.php" method="post">
                    <div class="form-group">
                        <label for="subject">Betreff:</label>
                        <input type="text" class="form-control" id="subject" name="subject" required>
                    </div>
                    <div class="form-group">
                        <label for="message">Nachricht:</label>
                        <textarea class="form-control" id="message" name="message" rows="3" resize="none"
                            placeholder="Guten Tag," required></textarea>
                    </div>
                    <button type="submit" class="btn btn-primary">Ticket erstellen</button>
                    <button type="button" class="btn btn-danger" data-dismiss="modal">Schließen</button>
                </form>
            </div>
        </div>
    </div>
</div>

';
include 'settings/footer.php';
;