query("SELECT COUNT(*) FROM " . tn('tickets') . " WHERE status IN ('open','pending')")->fetchColumn();
$myOpenTickets = 0;
if (!$isAdmin) {
// 客服：仅统计分配给自己的待处理工单
$stmt = $db->prepare("SELECT COUNT(*) FROM " . tn('tickets') . " WHERE status IN ('open','pending') AND assignee_id = ?");
$stmt->execute([$me['id']]);
$myOpenTickets = (int) $stmt->fetchColumn();
}
$recentTickets = $db->query(
'SELECT t.*, u.username FROM ' . tn('tickets') . ' t
LEFT JOIN ' . tn('users') . ' u ON u.id = t.user_id
' . ($isAdmin ? '' : ' WHERE t.assignee_id = ' . (int)$me['id']) . '
ORDER BY t.updated_at DESC LIMIT 5'
)->fetchAll();
$statCards = [];
if ($isAdmin) {
$onSale = $db->query('SELECT COUNT(*) FROM ' . tn('products') . ' WHERE status = 1')->fetchColumn();
$orderCnt = $db->query('SELECT COUNT(*) FROM ' . tn('orders'))->fetchColumn();
$sales = $db->query("SELECT COALESCE(SUM(total),0) FROM " . tn('orders') . " WHERE status IN ('paid','shipped','completed')")->fetchColumn();
$pending = $db->query("SELECT COUNT(*) FROM " . tn('orders') . " WHERE status = 'paid'")->fetchColumn();
$annCnt = $db->query('SELECT COUNT(*) FROM ' . tn('announcements') . ' WHERE status = 1')->fetchColumn();
$groupCnt = $db->query('SELECT COUNT(*) FROM ' . tn('product_groups'))->fetchColumn();
$statCards[] = ['num' => (int)$onSale, 'label' => '在售商品'];
$statCards[] = ['num' => (int)$orderCnt, 'label' => '累计订单'];
$statCards[] = ['num' => money($sales), 'label' => '销售总额'];
$statCards[] = ['num' => (int)$pending, 'label' => '等待发货', 'warn' => true];
$statCards[] = ['num' => (int)$annCnt, 'label' => '发布公告'];
$statCards[] = ['num' => (int)$groupCnt, 'label' => '商品分组'];
}
$statCards[] = ['num' => ($isAdmin ? (int)$openTickets : $myOpenTickets), 'label' => ($isAdmin ? '待处理工单' : '我待处理工单'), 'warn' => true];
adminHeader('仪表盘', 'index');
?>
仪表盘
最新订单
query(
'SELECT o.*, u.username FROM ' . tn('orders') . ' o
LEFT JOIN ' . tn('users') . ' u ON u.id = o.user_id
ORDER BY o.created_at DESC LIMIT 5'
)->fetchAll();
?>
暂无订单。
查看全部订单 →
暂无工单。
查看全部工单 →
最新公告
query('SELECT * FROM ' . tn('announcements') . ' ORDER BY pinned DESC, created_at DESC LIMIT 5')->fetchAll();
?>
暂无公告。
管理公告 →