<?php
    require_once './Includes/auth.php';
    require_once './Includes/rbac.php';
    redirect_if_not_logged_in();

    $user_id = get_current_user_id();
    $sql = "SELECT r.pk_request, w.title AS workflow_title, r.dateInserted
            FROM workflowManager_Request r
            INNER JOIN workflowManager_Workflow w ON r.fk_Workflow_triggers = w.pk_workflow
            WHERE r.fk_User_submittedBy = $user_id
            ORDER BY r.dateInserted DESC";
    $result = mysqli_query($conn, $sql);
?>
<h2>My Requests</h2>
<table class="data-table">
    <tr><th>ID</th><th>Workflow</th><th>Date</th></tr>
    <?php while ($row = mysqli_fetch_assoc($result)): ?>
    <tr>
        <td><?= $row['pk_request'] ?></td>
        <td><?= htmlspecialchars($row['workflow_title']) ?></td>
        <td><?= htmlspecialchars($row['dateInserted']) ?></td>
    </tr>
    <?php endwhile; ?>
</table>