<?php
/**
 * 后台 · 总览
 */
$stats = [
    ['users', '注册用户', DB::count('users'), '☺'],
    ['posts', '帖子', DB::count('posts'), '✎'],
    ['comments', '评论', DB::count('comments'), '💬'],
    ['categories', '板块', DB::count('categories'), '▦'],
];
$pendingReports = DB::count('reports', 'status = 0');
$pendingVerify = DB::count('users', 'verify_status = 1');
$pendingReviews = post_review_pending_count();
$todayPosts = DB::val('SELECT COUNT(*) FROM ' . DB::table('posts') . ' WHERE created_at >= ?', [date('Y-m-d')], 0);
$newUsers = DB::val('SELECT COUNT(*) FROM ' . DB::table('users') . ' WHERE created_at >= ?', [date('Y-m-d')], 0);
$recentPosts = DB::all('SELECT p.*, u.nickname, u.username FROM ' . DB::table('posts') . ' p
                        LEFT JOIN ' . DB::table('users') . ' u ON u.id = p.user_id
                        ORDER BY p.id DESC LIMIT 8');
$recentUsers = DB::all('SELECT * FROM ' . DB::table('users') . ' ORDER BY id DESC LIMIT 8');
$analytics = DB::all('SELECT * FROM ' . DB::table('analytics_daily') . ' ORDER BY day DESC LIMIT 14');
$todayRow = $analytics && $analytics[0]['day'] === date('Y-m-d') ? $analytics[0] : ['pv' => 0, 'uv' => 0, 'posts' => 0, 'comments' => 0];
$maxPv = 1;
foreach ($analytics as $a) { $maxPv = max($maxPv, (int) $a['pv']); }
?>
<div class="admin-head">
  <div>
    <h1>总览</h1>
    <p>今日新增 <?= (int) $todayPosts ?> 帖 · <?= (int) $newUsers ?> 位茶客</p>
  </div>
  <div class="admin-quick">
    <a class="btn-mini" href="<?= e(page_url('compose')) ?>">写新帖</a>
    <a class="btn-mini ghost" href="<?= e(admin_url('settings')) ?>">站点设置</a>
  </div>
</div>

<section class="stat-grid">
  <?php foreach ($stats as $st): ?>
    <div class="stat-card">
      <span class="stat-icon"><?= $st[3] ?></span>
      <div><b><?= (int) $st[2] ?></b><span><?= $st[1] ?></span></div>
    </div>
  <?php endforeach; ?>
</section>

<section class="panel analytics-panel">
  <div class="panel-head row"><h2>访问与活跃</h2><span class="muted">今日 PV <?= (int) $todayRow['pv'] ?> · UV <?= (int) $todayRow['uv'] ?></span></div>
  <?php if (!$analytics): ?>
    <?php empty_state('还没有访问统计', '开启统计后，访客进入首页会自动记录'); ?>
  <?php else: ?>
    <div class="analytics-bars">
      <?php foreach (array_reverse($analytics) as $a): ?>
        <div class="ab-col" title="<?= e($a['day']) ?> PV <?= (int) $a['pv'] ?> / UV <?= (int) $a['uv'] ?>">
          <i style="height:<?= max(3, round((int) $a['pv'] / $maxPv * 100)) ?>%"></i>
          <span><?= e(substr($a['day'], 5)) ?></span>
        </div>
      <?php endforeach; ?>
    </div>
    <div class="analytics-note">柱高为 PV；今日新增 <?= (int) $todayRow['posts'] ?> 帖、<?= (int) $todayRow['comments'] ?> 条评论。</div>
  <?php endif; ?>
</section>

<?php if ($pendingReports || $pendingVerify || $pendingReviews): ?>
<section class="admin-alerts">
  <?php if ($pendingReports): ?>
    <a class="alert-row" href="<?= e(admin_url('reports')) ?>">⚑ 有 <?= $pendingReports ?> 条举报待处理 <span>去处理 →</span></a>
  <?php endif; ?>
  <?php if ($pendingVerify): ?>
    <a class="alert-row" href="<?= e(admin_url('verify')) ?>">✓ 有 <?= $pendingVerify ?> 份认证申请待审核 <span>去审核 →</span></a>
  <?php endif; ?>
  <?php if ($pendingReviews): ?>
    <a class="alert-row" href="<?= e(admin_url('reviews')) ?>">🛡 有 <?= $pendingReviews ?> 篇帖子待审核 <span>去审核 →</span></a>
  <?php endif; ?>
</section>
<?php endif; ?>

<section class="admin-two">
  <div class="panel">
    <div class="panel-head row"><h2>最新帖子</h2><a class="admin-all-btn" href="<?= e(admin_url('posts')) ?>">全部</a></div>
    <div class="admin-table compact">
      <?php foreach ($recentPosts as $p): ?>
        <div class="at-row dash-post-row">
          <div class="at-main"><a href="<?= e(page_url('post', ['id' => $p['id']])) ?>"><?= e(post_display_title($p, 80)) ?></a>
            <span><?= e(display_name($p)) ?> · <?= e(time_ago($p['created_at'])) ?></span></div>
          <span class="tag"><?= (int) $p['views'] ?> 阅</span>
        </div>
      <?php endforeach; ?>
    </div>
  </div>
  <div class="panel">
    <div class="panel-head row"><h2>新注册</h2><a class="admin-all-btn" href="<?= e(admin_url('users')) ?>">全部</a></div>
    <div class="admin-table compact">
      <?php foreach ($recentUsers as $u): ?>
        <div class="at-row dash-user-row">
          <?= avatar_html($u, 'at-avatar') ?>
          <div class="at-main"><a href="<?= e(page_url('user', ['id' => $u['id']])) ?>"><?= e(display_name($u)) ?></a>
            <span><?= e($u['username']) ?> · <?= e(time_ago($u['created_at'])) ?></span></div>
          <span class="tag"><?= e(gender_text($u['gender'])) ?></span>
        </div>
      <?php endforeach; ?>
    </div>
  </div>
</section>