46 lines
2.3 KiB
PHP
46 lines
2.3 KiB
PHP
<?php
|
|
require_once __DIR__ . "/../includes/functions.php";
|
|
require_once __DIR__ . "/../includes/auth.php";
|
|
$adminPage = "dash";
|
|
$pageTitle = "仪表盘";
|
|
require __DIR__ . "/_layout.php";
|
|
|
|
$articles = (int)db()->query("SELECT COUNT(*) FROM articles")->fetchColumn();
|
|
$comments = (int)db()->query("SELECT COUNT(*) FROM comments")->fetchColumn();
|
|
$categories = (int)db()->query("SELECT COUNT(*) FROM categories")->fetchColumn();
|
|
$tags = (int)db()->query("SELECT COUNT(*) FROM tags")->fetchColumn();
|
|
$views = (int)db()->query("SELECT COALESCE(SUM(views),0) FROM articles")->fetchColumn();
|
|
$recent = db()->query("SELECT a.id, a.title, a.created_at, c.name AS cat FROM articles a LEFT JOIN categories c ON a.category_id=c.id ORDER BY a.created_at DESC LIMIT 8")->fetchAll();
|
|
?>
|
|
|
|
<div class="admin-head">
|
|
<h1>仪表盘</h1>
|
|
<a class="glass-btn primary" href="article_edit.php">写文章</a>
|
|
</div>
|
|
|
|
<div class="stat-grid">
|
|
<div class="card glass stat-card"><div class="num"><?php echo $articles; ?></div><div class="label">文章</div></div>
|
|
<div class="card glass stat-card"><div class="num"><?php echo $comments; ?></div><div class="label">评论</div></div>
|
|
<div class="card glass stat-card"><div class="num"><?php echo $views; ?></div><div class="label">总阅读</div></div>
|
|
<div class="card glass stat-card"><div class="num"><?php echo $categories; ?></div><div class="label">分类</div></div>
|
|
<div class="card glass stat-card"><div class="num"><?php echo $tags; ?></div><div class="label">标签</div></div>
|
|
</div>
|
|
|
|
<div class="card glass">
|
|
<h3>最近文章</h3>
|
|
<table class="admin-table">
|
|
<thead><tr><th>标题</th><th>分类</th><th>发布时间</th><th>操作</th></tr></thead>
|
|
<tbody>
|
|
<?php if (!$recent): ?><tr><td colspan="4" class="text-muted">暂无文章</td></tr><?php endif; ?>
|
|
<?php foreach ($recent as $a): ?>
|
|
<tr>
|
|
<td><?php echo e($a["title"]); ?></td>
|
|
<td class="text-muted"><?php echo e($a["cat"] ?: "未分类"); ?></td>
|
|
<td class="text-muted"><?php echo e($a["created_at"]); ?></td>
|
|
<td><div class="actions"><a href="article_edit.php?id=<?php echo $a["id"]; ?>">编辑</a><a href="article_delete.php?id=<?php echo $a["id"]; ?>" data-confirm="确定删除该文章？">删除</a></div></td>
|
|
</tr>
|
|
<?php endforeach; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<?php require __DIR__ . "/_tail.php"; ?>
|