173 lines
7.2 KiB
PHP
173 lines
7.2 KiB
PHP
<?php
|
|
declare(strict_types=1);
|
|
@ini_set('display_errors', '1');
|
|
@error_reporting(E_ALL);
|
|
@date_default_timezone_set('UTC');
|
|
|
|
require_once __DIR__ . '/includes/app.php';
|
|
|
|
ensure_tables();
|
|
|
|
$id = (int)($_GET['id'] ?? 0);
|
|
$statusOptions = ['queued', 'playing', 'paused', 'skipped', 'ended', 'failed'];
|
|
$statusUpdated = false;
|
|
$created = ($_GET['created'] ?? '') === '1';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST' && ($_POST['action'] ?? '') === 'update_status') {
|
|
$newStatus = trim((string)($_POST['status'] ?? ''));
|
|
if (in_array($newStatus, $statusOptions, true) && $id > 0) {
|
|
$stmt = db()->prepare('UPDATE music_requests SET status = :status WHERE id = :id');
|
|
$stmt->execute([
|
|
':status' => $newStatus,
|
|
':id' => $id,
|
|
]);
|
|
header('Location: request.php?id=' . $id . '&updated=1');
|
|
exit;
|
|
}
|
|
}
|
|
|
|
$statusUpdated = ($_GET['updated'] ?? '') === '1';
|
|
|
|
$request = null;
|
|
if ($id > 0) {
|
|
$stmt = db()->prepare('SELECT * FROM music_requests WHERE id = :id');
|
|
$stmt->execute([':id' => $id]);
|
|
$request = $stmt->fetch();
|
|
}
|
|
|
|
$projectDescription = $_SERVER['PROJECT_DESCRIPTION'] ?? '';
|
|
$projectImageUrl = $_SERVER['PROJECT_IMAGE_URL'] ?? '';
|
|
$projectName = $_SERVER['PROJECT_NAME'] ?? 'Discord Music Bot Control Center';
|
|
?>
|
|
<!doctype html>
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="utf-8" />
|
|
<meta name="viewport" content="width=device-width, initial-scale=1" />
|
|
<title><?= h($projectName) ?> — Request</title>
|
|
<?php if ($projectDescription): ?>
|
|
<meta name="description" content="<?= h($projectDescription) ?>" />
|
|
<meta property="og:description" content="<?= h($projectDescription) ?>" />
|
|
<meta property="twitter:description" content="<?= h($projectDescription) ?>" />
|
|
<?php endif; ?>
|
|
<?php if ($projectImageUrl): ?>
|
|
<meta property="og:image" content="<?= h($projectImageUrl) ?>" />
|
|
<meta property="twitter:image" content="<?= h($projectImageUrl) ?>" />
|
|
<?php endif; ?>
|
|
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous">
|
|
<link rel="stylesheet" href="assets/css/custom.css?v=<?= (int)time() ?>">
|
|
</head>
|
|
<body>
|
|
<nav class="navbar navbar-expand-lg sticky-top app-navbar">
|
|
<div class="container">
|
|
<a class="navbar-brand" href="index.php">EchoLift</a>
|
|
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navMenu" aria-controls="navMenu" aria-expanded="false" aria-label="Toggle navigation">
|
|
<span class="navbar-toggler-icon"></span>
|
|
</button>
|
|
<div class="collapse navbar-collapse" id="navMenu">
|
|
<div class="navbar-nav ms-auto">
|
|
<a class="nav-link" href="index.php">Dashboard</a>
|
|
<a class="nav-link" href="requests.php">Queue</a>
|
|
<a class="nav-link" href="logs.php">Logs</a>
|
|
<a class="nav-link" href="settings.php">Settings</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</nav>
|
|
|
|
<main class="app-shell">
|
|
<section class="container py-4 py-lg-5">
|
|
<div class="d-flex flex-column flex-md-row justify-content-between align-items-md-center gap-3 mb-4">
|
|
<div>
|
|
<p class="eyebrow">Request detail</p>
|
|
<h1 class="h3">Queue item overview</h1>
|
|
<p class="text-muted">Review the request metadata and update its status as the bot processes playback.</p>
|
|
</div>
|
|
<a class="btn btn-outline-secondary" href="requests.php">Back to queue</a>
|
|
</div>
|
|
|
|
<?php if (!$request): ?>
|
|
<div class="card app-card">
|
|
<div class="card-body">
|
|
<div class="empty-state">
|
|
<p class="mb-1">Request not found.</p>
|
|
<p class="text-muted small mb-0">Try selecting a request from the queue list.</p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<?php else: ?>
|
|
<div class="row g-4">
|
|
<div class="col-lg-8">
|
|
<div class="card app-card">
|
|
<div class="card-body">
|
|
<div class="d-flex justify-content-between align-items-start">
|
|
<div>
|
|
<h2 class="h4 mb-2"><?= h($request['query_text']) ?></h2>
|
|
<p class="text-muted mb-0">Requested by <?= h($request['requester_name']) ?> in <?= h($request['guild_name']) ?></p>
|
|
</div>
|
|
<span class="badge status-badge status-<?= h($request['status']) ?>"><?= h(ucfirst($request['status'])) ?></span>
|
|
</div>
|
|
<div class="detail-meta mt-4">
|
|
<div>
|
|
<p class="label">Source</p>
|
|
<p class="value"><?= h($request['source_type']) ?></p>
|
|
</div>
|
|
<div>
|
|
<p class="label">Voice channel</p>
|
|
<p class="value"><?= h($request['voice_channel'] ?: 'Not specified') ?></p>
|
|
</div>
|
|
<div>
|
|
<p class="label">Notes</p>
|
|
<p class="value"><?= h($request['notes'] ?: 'None') ?></p>
|
|
</div>
|
|
<div>
|
|
<p class="label">Created</p>
|
|
<p class="value"><?= h($request['created_at']) ?></p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-4">
|
|
<div class="card app-card">
|
|
<div class="card-body">
|
|
<h3 class="h6">Update status</h3>
|
|
<form method="post" action="request.php?id=<?= (int)$request['id'] ?>" class="mt-3">
|
|
<input type="hidden" name="action" value="update_status">
|
|
<div class="mb-3">
|
|
<label class="form-label" for="status">Playback status</label>
|
|
<select class="form-select" name="status" id="status">
|
|
<?php foreach ($statusOptions as $option): ?>
|
|
<option value="<?= h($option) ?>" <?= $request['status'] === $option ? 'selected' : '' ?>><?= h(ucfirst($option)) ?></option>
|
|
<?php endforeach; ?>
|
|
</select>
|
|
</div>
|
|
<button class="btn btn-primary w-100" type="submit">Save status</button>
|
|
</form>
|
|
<div class="mt-4 small text-muted">Status changes sync to the queue list automatically.</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<?php endif; ?>
|
|
</section>
|
|
</main>
|
|
|
|
<div class="toast-container position-fixed bottom-0 end-0 p-3">
|
|
<?php if ($created): ?>
|
|
<div class="toast" role="alert" aria-live="assertive" aria-atomic="true">
|
|
<div class="toast-body">Request created and queued for playback.</div>
|
|
</div>
|
|
<?php endif; ?>
|
|
<?php if ($statusUpdated): ?>
|
|
<div class="toast" role="alert" aria-live="assertive" aria-atomic="true">
|
|
<div class="toast-body">Status updated successfully.</div>
|
|
</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
|
|
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous"></script>
|
|
<script src="assets/js/main.js?v=<?= (int)time() ?>"></script>
|
|
</body>
|
|
</html>
|