pass('administrator')) { throw new Typecho_Widget_Exception(_t('禁止访问'), 403); } $options = \Typecho\Widget::widget('Widget_Options'); $themeDir = __TYPECHO_ROOT_DIR__ . '/usr/themes/' . $options->theme; $coreFile = $themeDir . '/common/functions/core.php'; if (file_exists($coreFile)) { require_once $coreFile; } $functionsFile = $themeDir . '/common/functions/pay.php'; if (file_exists($functionsFile)) { require_once $functionsFile; } $db = \Typecho\Db::get(); $security = \Typecho\Widget::widget('Widget_Security'); $ordersTable = Mirai_payTable('orders'); $panelName = 'MiraiCore/Orders/manage-orders.php'; $panelUrl = $options->adminUrl('extending.php?panel=' . urlencode($panelName), true); $total = 0; $totalPages = 1; $page = 1; $pageSize = 20; $status = ''; $keyword = ''; $orders = []; $stats = []; $userMap = []; if (!Mirai_payDbCheck()) { $error = '支付功能相关数据表未正确初始化，请尝试禁用并重新启用主题。'; } else { $action = isset($_GET['action']) ? trim((string)$_GET['action']) : ''; $orderNo = isset($_GET['order_no']) ? trim((string)$_GET['order_no']) : ''; if ($action !== '' && $orderNo !== '') { try { $security->protect(); if (!preg_match('/^MR[A-Fa-f0-9]{20}$/', $orderNo)) { throw new \Exception('订单号格式错误'); } $order = $db->fetchRow($db->select('order_no', 'status')->from($ordersTable)->where('order_no = ?', $orderNo)->limit(1)); if (!$order) { throw new \Exception('订单不存在'); } if ($action === 'delete') { if (!in_array($order['status'], ['pending', 'closed'], true)) { throw new \Exception('只能删除未支付或已关闭的订单'); } $db->query($db->delete($ordersTable)->where('order_no = ?', $orderNo)); \Typecho\Widget::widget('Widget_Notice')->set(_t('订单已删除'), 'success'); } elseif ($action === 'close') { if ($order['status'] !== 'pending') { throw new \Exception('只能关闭待支付的订单'); } $db->query($db->update($ordersTable)->rows(['status' => 'closed'])->where('order_no = ?', $orderNo)->where('status = ?', 'pending')); \Typecho\Widget::widget('Widget_Notice')->set(_t('订单已关闭'), 'success'); } header('Location: ' . $_SERVER['HTTP_REFERER']); exit; } catch (\Exception $e) { \Typecho\Widget::widget('Widget_Notice')->set($e->getMessage(), 'error'); header('Location: ' . $_SERVER['HTTP_REFERER']); exit; } } $status = isset($_GET['status']) ? trim((string)$_GET['status']) : ''; $keyword = isset($_GET['keyword']) ? trim((string)$_GET['keyword']) : ''; $page = isset($_GET['page']) ? max(1, (int)$_GET['page']) : 1; $result = Mirai_payAdminGetOrders($page, $pageSize, [ 'status' => $status, 'keyword' => $keyword ]); $orders = $result['list']; $total = (int)$result['total']; $totalPages = max(1, (int)ceil($total / $pageSize)); $page = min($page, $totalPages); if ($page < 1) { $page = 1; } $stats = Mirai_payAdminGetStatistics(); $uids = []; foreach ($orders as $order) { $uid = isset($order['uid']) ? (int)$order['uid'] : 0; if ($uid > 0) { $uids[] = $uid; } } $userMap = Mirai_payAdminGetUsersMap($uids); } ?>

订单管理

总订单：

已支付：

总金额：￥

今日金额：￥

getTokenUrl($panelUrl . '&action=delete&order_no=' . rawurlencode((string)$order['order_no']) . '&status=' . rawurlencode($status) . '&keyword=' . rawurlencode($keyword)); $closeUrl = $security->getTokenUrl($panelUrl . '&action=close&order_no=' . rawurlencode((string)$order['order_no']) . '&status=' . rawurlencode($status) . '&keyword=' . rawurlencode($keyword)); $orderUser = $userMap[(int)$order['uid']] ?? null; $userName = $orderUser ? ($orderUser['screenName'] ?: $orderUser['name']) : '游客'; $userId = (int)$order['uid']; $authorId = isset($order['author_id']) ? (int)$order['author_id'] : 0; $incomePrice = isset($order['income_price']) ? (float)$order['income_price'] : 0; $incomeStatus = isset($order['income_status']) ? (int)$order['income_status'] : 0; $gateway = Mirai_payChannelGateway((string)$order['payment_method']); $gatewayLabel = Mirai_payGatewayLabel($gateway !== '' ? $gateway : (string)$order['payment_method']); $detailData = [ '商品名称' => Mirai_payOrderTitle($order), '订单类型' => Mirai_payOrderTypeLabel((string)$order['order_type']), '创建时间' => (new \Typecho\Date((int)$order['created']))->format('Y-m-d H:i:s'), '订单号' => (string)$order['order_no'], '支付流水号' => isset($order['trade_no']) && $order['trade_no'] !== '' ? (string)$order['trade_no'] : '-', '支付金额' => number_format((float)$order['amount'], 2) . ' ' . Mirai_payCurrencyName(), '完成支付时间' => (int)$order['paid_at'] > 0 ? (new \Typecho\Date((int)$order['paid_at']))->format('Y-m-d H:i:s') : '-', '订单状态' => $statusText, '支付方式' => Mirai_payMethodLabel((string)$order['payment_method']), '支付网关' => $gatewayLabel, '用户' => $userName . ' (ID: ' . $userId . ')', '内容ID' => (int)$order['cid'] > 0 ? (int)$order['cid'] : '-', '作者ID' => $authorId > 0 ? $authorId : '-', '分成金额' => $incomePrice > 0 ? ('￥' . number_format($incomePrice, 2)) : '-', '分成状态' => $incomePrice > 0 ? Mirai_payIncomeStatusLabel($incomeStatus) : '-', 'IP地址' => $ip ]; $detailJson = htmlspecialchars(json_encode($detailData, JSON_UNESCAPED_UNICODE), ENT_QUOTES, 'UTF-8'); ?>



			ID:				format('Y-m-d H:i:s'); ?> IP:

1): ?>