<?php
require_once __DIR__ . '/auth.php';
if (!empty($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    $stmt = $pdo->prepare('SELECT image FROM activities WHERE id=?');
    $stmt->execute([$id]);
    $old = $stmt->fetchColumn();
    if ($old && file_exists(__DIR__ . '/../uploads/activities/' . $old)) unlink(__DIR__ . '/../uploads/activities/' . $old);
    $pdo->prepare('DELETE FROM activities WHERE id=?')->execute([$id]);
    redirect('activity_list.php?deleted=1');
}
$rows = $pdo->query('SELECT * FROM activities ORDER BY created_at DESC')->fetchAll();
include __DIR__ . '/header.php';
?>
<div class="page-header"><div class="container"><h1 class="fw-bold">จัดการกิจกรรม</h1><p class="mb-0">เพิ่ม แก้ไข และลบข้อมูลกิจกรรมที่แสดงหน้าเว็บไซต์</p></div></div>
<div class="container mb-5">
  <?php if (!empty($_GET['saved'])): ?><div class="alert alert-success rounded-4">บันทึกข้อมูลเรียบร้อยแล้ว</div><?php endif; ?>
  <?php if (!empty($_GET['deleted'])): ?><div class="alert alert-warning rounded-4">ลบข้อมูลเรียบร้อยแล้ว</div><?php endif; ?>
  <div class="content-card p-4">
    <div class="d-flex justify-content-between align-items-center mb-3"><h4 class="fw-bold mb-0">รายการกิจกรรม</h4><a href="activity_form.php" class="btn btn-gradient"><i class="bi bi-plus-circle me-1"></i> เพิ่มกิจกรรม</a></div>
    <div class="table-responsive"><table class="table align-middle"><thead><tr><th>รูป</th><th>ชื่อกิจกรรม</th><th>หมวดหมู่</th><th>วันที่</th><th></th></tr></thead><tbody>
      <?php foreach($rows as $r): ?><tr>
        <td style="width:110px"><?php if($r['image']): ?><img src="../uploads/activities/<?= e($r['image']) ?>" class="img-fluid rounded-3" style="height:70px;width:100px;object-fit:cover"><?php else: ?><div class="rounded-3 text-center text-white p-3" style="background:linear-gradient(90deg,#e50920,#0067ff)"><i class="bi bi-image fs-3"></i></div><?php endif; ?></td>
        <td><strong><?= e($r['title']) ?></strong><br><small class="text-muted"><?= e(mb_strimwidth($r['detail'],0,80,'...')) ?></small></td>
        <td><?= e($r['category']) ?></td><td><?= e($r['created_at']) ?></td>
        <td class="text-end"><a class="btn btn-sm btn-outline-primary rounded-pill" href="activity_form.php?id=<?= (int)$r['id'] ?>">แก้ไข</a> <a class="btn btn-sm btn-outline-danger rounded-pill" onclick="return confirm('ยืนยันการลบข้อมูลนี้?')" href="activity_list.php?delete=<?= (int)$r['id'] ?>">ลบ</a></td>
      </tr><?php endforeach; ?>
      <?php if(!$rows): ?><tr><td colspan="5" class="text-center text-muted">ยังไม่มีข้อมูล</td></tr><?php endif; ?>
    </tbody></table></div>
  </div>
</div>
<?php include __DIR__ . '/footer.php'; ?>