<?php
require_login();

$groupId = $_SESSION['user_group_id'];
$userId  = $_SESSION['user_id'];

$sql = "
  SELECT
    r.pk_Request,
    w.title       AS workflow,
    s.title       AS state_title,
    hs.date_inserted,
    sa.actorType
  FROM TICKET_StateActor sa
  JOIN TICKET_State    s  ON sa.fk_State  = s.pk_State
  JOIN TICKET_Request  r  ON r.fk_State    = s.pk_State
  JOIN TICKET_Workflow w  ON r.fk_Workflow = w.pk_Workflow
  JOIN TICKET_hasState hs ON hs.fk_Request = r.pk_Request
                         AND hs.fk_State   = r.fk_State
  WHERE (sa.actorType='GROUP' AND sa.fk_Group= ?)
     OR (sa.actorType='USER'  AND sa.fk_User = ?)
  ORDER BY hs.date_inserted DESC
";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, 'ii', $groupId, $userId);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
?>
<div class="page-group-requests">
  <div class="page-header">
    <h1 class="page-title">Group Tasks</h1>
    <p class="page-subtitle">Requests assigned to you or your group</p>
  </div>
  
  <div class="requests-table-container">
    <table class="requests-table">
      <thead>
        <tr>
          <th>Request ID</th>
          <th>Workflow</th>
          <th>State</th>
          <th>Actor Type</th>
          <th>Assigned At</th>
          <th>Action</th>
        </tr>
      </thead>
      <tbody>
        <?php while ($row = mysqli_fetch_assoc($result)): ?>
          <tr>
            <td>
              <span class="request-id">#<?= $row['pk_Request'] ?></span>
            </td>
            <td>
              <span class="workflow-title"><?= htmlspecialchars($row['workflow']) ?></span>
            </td>
            <td>
              <span class="state-badge"><?= htmlspecialchars($row['state_title']) ?></span>
            </td>
            <td>
              <span class="actor-badge <?= strtolower($row['actorType']) ?>">
                <?= $row['actorType'] ?>
              </span>
            </td>
            <td>
              <span class="date-text"><?= date('M j, Y g:i A', strtotime($row['date_inserted'])) ?></span>
            </td>
            <td>
              <a href="index.php?page=request_handle&req=<?= $row['pk_Request'] ?>" class="respond-button">
                Respond
              </a>
            </td>
          </tr>
        <?php endwhile; ?>
      </tbody>
    </table>
  </div>
</div>