feat(cps): CPS 分发与对账后台页

群/活动管理 + 生成带 sid 短链(/c/{code}) + 对账统计(点击 PV/UV + 下单/佣金)。 Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
feat(ad-revenue): 广告数据报表页(替换金币审计页) (#11 )
2026-06-17 10:01:08 +08:00 · 2026-06-15 23:13:22 +08:00 · 2026-06-14 22:54:24 +08:00 · 2026-06-13 23:43:52 +08:00 · 2026-06-12 00:51:51 +08:00 · 2026-06-10 22:26:41 +08:00
20 changed files with 3026 additions and 530 deletions
@@ -2438,7 +2438,7 @@
    },
    "node_modules/@next/swc-win32-x64-msvc": {
      "version": "15.5.19",
-      "resolved": "https://registry.npmmirror.com/@next/swc-win32-x64-msvc/-/swc-win32-x64-msvc-15.5.19.tgz",
+      "resolved": "https://registry.npmjs.org/@next/swc-win32-x64-msvc/-/swc-win32-x64-msvc-15.5.19.tgz",
      "integrity": "sha512-PhmojAHyqMne56HBLGu9dhDnHPuFmEjrXSQMM/nW0J6j849lk3ESrVtqNJcCk8CKOV7brpTTbaYAjwKPzKM69w==",
      "cpu": [
        "x64"
@@ -1,227 +0,0 @@
-'use client';
-
-import { useCallback, useEffect, useState } from 'react';
-import type { ColumnsType } from 'antd/es/table';
-import {
-  Alert,
-  Button,
-  Card,
-  DatePicker,
-  InputNumber,
-  Select,
-  Space,
-  Table,
-  Tag,
-  Typography,
-  message,
-} from 'antd';
-import dayjs, { type Dayjs } from 'dayjs';
-import { api, errMsg } from '@/lib/api';
-import type { AdCoinAudit, AdCoinAuditRow } from '@/lib/types';
-
-const dt = (v: string) => new Date(v).toLocaleString('zh-CN');
-
-const SCENE_TAG: Record<string, { color: string; label: string }> = {
-  reward_video: { color: 'blue', label: '看视频' },
-  feed: { color: 'purple', label: '信息流' },
-};
-
-const STATUS_TAG: Record<string, string> = {
-  granted: 'green',
-  capped: 'orange',
-  ecpm_missing: 'red',
-};
-
-const fmtFactorRange = (a: number | null, b: number | null) => {
-  if (a == null) return '-';
-  return a === b || b == null ? String(a) : `${a}→${b}`;
-};
-
-const fmtIndexRange = (a: number | null, b: number | null) => {
-  if (a == null) return '-';
-  return a === b ? String(a) : `${a}–${b}`;
-};
-
-export default function AdAuditPage() {
-  const [date, setDate] = useState<Dayjs>(dayjs());
-  const [userId, setUserId] = useState<number | null>(null);
-  const [scene, setScene] = useState<string | undefined>();
-  const [limit, setLimit] = useState<number>(100);
-  const [data, setData] = useState<AdCoinAudit | null>(null);
-  const [loading, setLoading] = useState(false);
-
-  const load = useCallback(async () => {
-    setLoading(true);
-    try {
-      const res = await api.get<AdCoinAudit>('/admin/api/ad-coin-audit', {
-        params: {
-          date: date.format('YYYY-MM-DD'),
-          user_id: userId ?? undefined,
-          scene: scene ?? undefined,
-          limit,
-        },
-      });
-      setData(res.data);
-    } catch (e) {
-      message.error(errMsg(e));
-    } finally {
-      setLoading(false);
-    }
-  }, [date, userId, scene, limit]);
-
-  useEffect(() => {
-    load();
-    // 仅首次自动拉今天;之后由「查询」按钮触发
-    // eslint-disable-next-line react-hooks/exhaustive-deps
-  }, []);
-
-  const columns: ColumnsType<AdCoinAuditRow> = [
-    {
-      title: '场景',
-      dataIndex: 'scene',
-      width: 90,
-      render: (s: string) => {
-        const t = SCENE_TAG[s] ?? { color: 'default', label: s };
-        return <Tag color={t.color}>{t.label}</Tag>;
-      },
-    },
-    { title: '时间', dataIndex: 'created_at', render: dt, width: 175 },
-    { title: '用户', dataIndex: 'user_id', width: 70 },
-    {
-      title: '状态',
-      dataIndex: 'status',
-      width: 110,
-      render: (s: string) => <Tag color={STATUS_TAG[s] ?? 'default'}>{s}</Tag>,
-    },
-    { title: 'eCPM', dataIndex: 'ecpm', width: 90, render: (v: string | null) => v ?? '-' },
-    {
-      title: '因子1',
-      dataIndex: 'ecpm_factor',
-      width: 70,
-      render: (v: number | null) => v ?? '-',
-    },
-    { title: '份数', dataIndex: 'units', width: 60 },
-    {
-      title: 'LT累计条数',
-      key: 'lt_index',
-      width: 100,
-      render: (_: unknown, r: AdCoinAuditRow) => fmtIndexRange(r.lt_index_start, r.lt_index_end),
-    },
-    {
-      title: '因子2',
-      key: 'lt_factor',
-      width: 90,
-      render: (_: unknown, r: AdCoinAuditRow) => fmtFactorRange(r.lt_factor_start, r.lt_factor_end),
-    },
-    {
-      title: '应发金币',
-      dataIndex: 'expected_coin',
-      width: 100,
-      render: (v: number) => <b>{v}</b>,
-    },
-    { title: '实发金币', dataIndex: 'actual_coin', width: 100 },
-    {
-      title: '一致',
-      dataIndex: 'matched',
-      width: 70,
-      render: (m: boolean) =>
-        m ? <Tag color="green">✓</Tag> : <Tag color="red">✗ 不符</Tag>,
-    },
-  ];
-
-  return (
-    <div>
-      <h2>看广告金币审计</h2>
-      <Typography.Paragraph type="secondary" style={{ marginBottom: 16 }}>
-        把「看视频赚金币」和「比价信息流广告」的发奖记录,用与正式发奖相同的公式复算一遍,核对实发金币是否按公式计算。纯只读对账。
-      </Typography.Paragraph>
-
-      {data && (
-        <Card size="small" style={{ marginBottom: 16 }}>
-          <Typography.Text strong>金币公式:</Typography.Text>{' '}
-          <Typography.Text code>{data.formula.description}</Typography.Text>
-          <div style={{ marginTop: 8, color: '#666', fontSize: 13 }}>
-            <div>
-              eCPM 口径:{data.formula.ecpm_unit},计算时 ÷100 转元;金币:元 ={' '}
-              {data.formula.coin_per_yuan}:1;信息流每 {data.formula.feed_unit_seconds} 秒折 1 条。两个点位「LT累计条数」各自独立计数。
-            </div>
-            <div style={{ marginTop: 4 }}>
-              因子1(按 eCPM 元判档,阈值单位:元):
-              {data.formula.ecpm_factor_tiers
-                .map(([f, lo, hi]) => `${lo}~${hi ?? '∞'}元→${f}`)
-                .join('  |  ')}
-            </div>
-            <div style={{ marginTop: 4 }}>
-              因子2(LT 累计条数):
-              {data.formula.lt_factor_tiers
-                .map(([f, lo, hi]) => `${lo}${hi != null && hi !== lo ? `~${hi}` : ''}→${f}`)
-                .join('  |  ')}
-            </div>
-          </div>
-        </Card>
-      )}
-
-      <Space style={{ marginBottom: 16 }} wrap>
-        <DatePicker value={date} onChange={(d) => d && setDate(d)} allowClear={false} />
-        <InputNumber
-          placeholder="用户 ID(可空)"
-          value={userId ?? undefined}
-          onChange={(v) => setUserId(v ?? null)}
-          style={{ width: 140 }}
-        />
-        <Select
-          placeholder="场景(全部)"
-          value={scene}
-          onChange={setScene}
-          allowClear
-          style={{ width: 140 }}
-          options={[
-            { value: 'reward_video', label: '看视频' },
-            { value: 'feed', label: '信息流' },
-          ]}
-        />
-        <Select
-          value={limit}
-          onChange={setLimit}
-          style={{ width: 120 }}
-          options={[50, 100, 200, 500].map((n) => ({ value: n, label: `${n} 条` }))}
-        />
-        <Button type="primary" onClick={load} loading={loading}>
-          查询
-        </Button>
-      </Space>
-
-      {data && (
-        <div style={{ marginBottom: 12 }}>
-          {data.mismatch_count > 0 ? (
-            <Alert
-              type="error"
-              message={`共 ${data.total} 条,其中 ${data.mismatch_count} 条复算与实发不一致(✗)——公式可能未生效或发奖有问题`}
-            />
-          ) : (
-            <Alert
-              type="success"
-              message={`共 ${data.total} 条,全部按公式发放(无不一致)`}
-            />
-          )}
-        </div>
-      )}
-
-      <Table
-        rowKey={(r) => `${r.scene}-${r.record_id}`}
-        columns={columns}
-        dataSource={data?.items ?? []}
-        loading={loading}
-        pagination={false}
-        size="small"
-        scroll={{ x: 1100 }}
-        rowClassName={(r) => (r.matched ? '' : 'row-mismatch')}
-      />
-      <style jsx global>{`
-        .row-mismatch > td {
-          background: #fff1f0 !important;
-        }
-      `}</style>
-    </div>
-  );
-}
@@ -0,0 +1,746 @@
+'use client';
+
+import { useCallback, useEffect, useState } from 'react';
+import type { ColumnsType } from 'antd/es/table';
+import {
+  Alert,
+  Button,
+  Card,
+  Col,
+  DatePicker,
+  Divider,
+  InputNumber,
+  Modal,
+  Popover,
+  Row,
+  Select,
+  Space,
+  Statistic,
+  Table,
+  Tag,
+  Typography,
+  message,
+} from 'antd';
+import {
+  FallOutlined,
+  InfoCircleOutlined,
+  QuestionCircleOutlined,
+  RiseOutlined,
+} from '@ant-design/icons';
+import dayjs, { type Dayjs } from 'dayjs';
+import { api, errMsg } from '@/lib/api';
+import { formatUtcTime } from '@/lib/format';
+import type {
+  AdRevenueDaily,
+  AdRevenueImpression,
+  AdRevenueRecord,
+  AdRevenueReport,
+  AdRevenueRow,
+} from '@/lib/types';
+
+const { RangePicker } = DatePicker;
+
+// 广告类型标签
+const TYPE_TAG: Record<string, { color: string; label: string }> = {
+  reward_video: { color: 'blue', label: '激励视频' },
+  feed: { color: 'purple', label: '信息流' },
+  draw: { color: 'geekblue', label: 'Draw 信息流' },
+};
+
+// 我们的应用环境标签
+const APP_TAG: Record<string, { color: string; label: string }> = {
+  prod: { color: 'green', label: '傻瓜比价(正式)' },
+  test: { color: 'default', label: '测试应用' },
+};
+
+// 发奖状态 → 颜色 + 中文(含「不发金币的原因」:提前关闭/未满10秒/缺eCPM/次数超限)
+const STATUS_TAG: Record<string, { color: string; label: string }> = {
+  granted: { color: 'green', label: '已发' },
+  capped: { color: 'orange', label: '次数超限' },
+  ecpm_missing: { color: 'red', label: '缺 eCPM' },
+  too_short: { color: 'gold', label: '未满10秒' },
+  closed_early: { color: 'default', label: '提前关闭' },
+};
+
+const fmtFactorRange = (a: number | null, b: number | null) => {
+  if (a == null) return '-';
+  return a === b || b == null ? String(a) : `${a}→${b}`;
+};
+
+const fmtIndexRange = (a: number | null, b: number | null) => {
+  if (a == null) return '-';
+  return a === b ? String(a) : `${a}–${b}`;
+};
+
+// 金币计算公式(写死,展示用)——与后端 app/core/rewards.py 同源,改动以后端常量为准。
+// 单次奖励(元) = (eCPM元 ÷ 1000) × 因子1(eCPM 元档) × 因子2(LT 累计条数);1 元 = 10000 金币,四舍五入取整。
+const COIN_PER_YUAN = 10000;
+// 因子1:按 eCPM(元/千次)判档,对应 AD_ECPM_FACTOR_TABLE
+const ECPM_FACTOR_ROWS = [
+  { key: '4', range: '> 400', factor: 0.6 },
+  { key: '3', range: '201 – 400', factor: 0.4 },
+  { key: '2', range: '101 – 200', factor: 0.3 },
+  { key: '1', range: '0 – 100', factor: 0.1 },
+];
+// 因子2:按该账号累计第几条/份(不按天重置),对应 AD_LT_FACTOR_TABLE
+const LT_FACTOR_ROWS = [
+  { key: '1', lt: '第 1 条', factor: 2.0 },
+  { key: '2', lt: '第 2 条', factor: 1.5 },
+  { key: '3', lt: '第 3 条', factor: 1.3 },
+  { key: '4', lt: '4 – 10 条', factor: 1.1 },
+  { key: '5', lt: '第 11 条及以后', factor: 1.0 },
+];
+
+// 展开行 - 展示明细:每条广告展示一行(时间/eCPM/收益/adn/底层位)
+const IMPRESSION_COLUMNS: ColumnsType<AdRevenueImpression> = [
+  { title: '时间', dataIndex: 'created_at', render: (v: string) => formatUtcTime(v), width: 165 },
+  { title: 'eCPM（分）', dataIndex: 'ecpm', width: 100 },
+  { title: '预估收益(元)', dataIndex: 'revenue_yuan', width: 120, render: (v: number) => v.toFixed(4) },
+  {
+    title: 'adn',
+    dataIndex: 'adn',
+    width: 90,
+    render: (v: string | null) => v ?? '-',
+  },
+  {
+    title: '底层代码位ID',
+    dataIndex: 'slot_id',
+    render: (v: string | null) => v ?? '-',
+  },
+];
+
+// 展开行 - 发奖明细:该组的逐条发奖复算明细(还原原金币审计的 eCPM/因子1/份数/LT/因子2 等列)
+const DETAIL_COLUMNS: ColumnsType<AdRevenueRecord> = [
+  { title: '时间', dataIndex: 'created_at', render: (v: string) => formatUtcTime(v), width: 165 },
+  {
+    title: '状态',
+    dataIndex: 'status',
+    width: 110,
+    render: (s: string) => {
+      const t = STATUS_TAG[s] ?? { color: 'default', label: s };
+      return <Tag color={t.color}>{t.label}</Tag>;
+    },
+  },
+  { title: 'eCPM（分）', dataIndex: 'ecpm', width: 90, render: (v: string | null) => v ?? '-' },
+  { title: '因子1', dataIndex: 'ecpm_factor', width: 70, render: (v: number | null) => v ?? '-' },
+  { title: '份数', dataIndex: 'units', width: 60 },
+  {
+    title: 'LT累计条数',
+    key: 'lt_index',
+    width: 100,
+    render: (_: unknown, r: AdRevenueRecord) => fmtIndexRange(r.lt_index_start, r.lt_index_end),
+  },
+  {
+    title: '因子2',
+    key: 'lt_factor',
+    width: 90,
+    render: (_: unknown, r: AdRevenueRecord) => fmtFactorRange(r.lt_factor_start, r.lt_factor_end),
+  },
+  { title: '应发金币', dataIndex: 'expected_coin', width: 100, render: (v: number) => <b>{v}</b> },
+  { title: '实发金币', dataIndex: 'actual_coin', width: 100 },
+  {
+    title: '一致',
+    dataIndex: 'matched',
+    width: 80,
+    render: (m: boolean) => (m ? <Tag color="green">✓</Tag> : <Tag color="red">✗ 不符</Tag>),
+  },
+];
+
+// 趋势图(纯 SVG,零依赖):柱=展示条数(左轴),线=预估收益元(右轴)。x 轴按传入点序。
+const CHART_BAR = '#69b1ff';
+const CHART_LINE = '#fa8c16';
+
+interface TrendPoint {
+  label: string; // x 轴刻度文案(小时数 / MM-DD)
+  tip: string; // hover 原生 tooltip 全文
+  impressions: number;
+  revenue: number;
+}
+
+// 按小时聚合(0–23),数据源是 items(被 limit 截断时会偏少,调用处给警告)
+function aggregateHourly(rows: AdRevenueRow[]): TrendPoint[] {
+  const byHour = Array.from({ length: 24 }, (_, h) => ({ hour: h, impressions: 0, revenue: 0 }));
+  for (const r of rows) {
+    if (r.hour == null || r.hour < 0 || r.hour > 23) continue;
+    byHour[r.hour].impressions += r.impressions;
+    byHour[r.hour].revenue += r.revenue_yuan;
+  }
+  return byHour.map((b) => ({
+    label: String(b.hour),
+    tip: `${String(b.hour).padStart(2, '0')}:00　展示 ${b.impressions} 条 · 预估收益 ${b.revenue.toFixed(4)} 元`,
+    impressions: b.impressions,
+    revenue: b.revenue,
+  }));
+}
+
+// 按天聚合,数据源是 daily(全量,不受 limit 影响);用 from..to 补齐空缺日为 0,轴连续
+function aggregateDaily(dateFrom: string, dateTo: string, daily: AdRevenueDaily[]): TrendPoint[] {
+  const map = new Map(daily.map((d) => [d.date, d]));
+  const out: TrendPoint[] = [];
+  let cur = dayjs(dateFrom);
+  let guard = 0;
+  while (cur.format('YYYY-MM-DD') <= dateTo && guard < 400) {
+    const ds = cur.format('YYYY-MM-DD');
+    const d = map.get(ds);
+    const impressions = d?.impressions ?? 0;
+    const revenue = d?.revenue_yuan ?? 0;
+    out.push({
+      label: ds.slice(5),
+      tip: `${ds}　展示 ${impressions} 条 · 预估收益 ${revenue.toFixed(4)} 元`,
+      impressions,
+      revenue,
+    });
+    cur = cur.add(1, 'day');
+    guard += 1;
+  }
+  return out;
+}
+
+function TrendChart({ points }: { points: TrendPoint[] }) {
+  const n = points.length;
+  const maxImp = Math.max(1, ...points.map((p) => p.impressions));
+  const maxRev = Math.max(1e-9, ...points.map((p) => p.revenue));
+
+  const W = 960;
+  const H = 280;
+  const padL = 48;
+  const padR = 56;
+  const padT = 16;
+  const padB = 32;
+  const plotW = W - padL - padR;
+  const plotH = H - padT - padB;
+  const step = plotW / Math.max(1, n);
+  const barW = Math.min(28, step * 0.55);
+  const yBase = padT + plotH;
+
+  const barX = (i: number) => padL + i * step + (step - barW) / 2;
+  const cx = (i: number) => padL + i * step + step / 2;
+  const impH = (v: number) => (v / maxImp) * plotH;
+  const revY = (v: number) => yBase - (v / maxRev) * plotH;
+  const linePts = points.map((p, i) => `${cx(i)},${revY(p.revenue)}`).join(' ');
+  const labelEvery = Math.max(1, Math.ceil(n / 12)); // 至多 ~12 个 x 标签,避免拥挤
+
+  return (
+    <svg viewBox={`0 0 ${W} ${H}`} width="100%" style={{ display: 'block' }} role="img" aria-label="趋势图">
+      {[0, 0.25, 0.5, 0.75, 1].map((t) => {
+        const y = yBase - t * plotH;
+        return (
+          <g key={t}>
+            <line x1={padL} y1={y} x2={W - padR} y2={y} stroke="#f0f0f0" />
+            <text x={padL - 8} y={y + 4} textAnchor="end" fontSize={11} fill={CHART_BAR}>
+              {Math.round(maxImp * t)}
+            </text>
+            <text x={W - padR + 8} y={y + 4} textAnchor="start" fontSize={11} fill={CHART_LINE}>
+              {(maxRev * t).toFixed(2)}
+            </text>
+          </g>
+        );
+      })}
+      {points.map((p, i) => (
+        <rect
+          key={i}
+          x={barX(i)}
+          y={yBase - impH(p.impressions)}
+          width={barW}
+          height={impH(p.impressions)}
+          fill={CHART_BAR}
+          rx={2}
+        >
+          <title>{p.tip}</title>
+        </rect>
+      ))}
+      <polyline points={linePts} fill="none" stroke={CHART_LINE} strokeWidth={2} />
+      {points.map((p, i) => (
+        <circle key={i} cx={cx(i)} cy={revY(p.revenue)} r={2.5} fill={CHART_LINE}>
+          <title>{p.tip}</title>
+        </circle>
+      ))}
+      {points.map((p, i) =>
+        i % labelEvery === 0 || i === n - 1 ? (
+          <text key={i} x={cx(i)} y={H - 14} textAnchor="middle" fontSize={11} fill="#999">
+            {p.label}
+          </text>
+        ) : null,
+      )}
+    </svg>
+  );
+}
+
+// 广告数据页:单表 —— 按 用户×类型×应用×代码位 聚合,一行同时给出
+// 展示条数 / 收益 / 应发金币 / 实发金币 / 是否一致(发奖对账下沉到聚合级)。
+export default function AdRevenuePage() {
+  const [range, setRange] = useState<[Dayjs, Dayjs]>([dayjs(), dayjs()]);
+  const [userId, setUserId] = useState<number | null>(null);
+  const [adType, setAdType] = useState<string | undefined>();
+  const [granularity, setGranularity] = useState<'day' | 'hour'>('day');
+  const [limit, setLimit] = useState<number>(500);
+  const [queriedGranularity, setQueriedGranularity] = useState<'day' | 'hour'>('day'); // 本次结果对应的粒度,决定是否显示「小时」列
+  const [queriedMultiDay, setQueriedMultiDay] = useState(false); // 本次结果是否跨多天,决定显示「日期」列 + 按天/按小时图
+  const [data, setData] = useState<AdRevenueReport | null>(null);
+  const [queriedLimit, setQueriedLimit] = useState<number>(500);
+  const [loading, setLoading] = useState(false);
+  const [formulaOpen, setFormulaOpen] = useState(false);
+
+  // 当前选择是否跨多天:跨多天时「按小时」无意义,粒度强制按天
+  const rangeMultiDay = range[0].format('YYYY-MM-DD') !== range[1].format('YYYY-MM-DD');
+
+  const load = useCallback(async () => {
+    const from = range[0].format('YYYY-MM-DD');
+    const to = range[1].format('YYYY-MM-DD');
+    const multiDay = from !== to;
+    const gran = multiDay ? 'day' : granularity; // 跨多天强制按天
+    setLoading(true);
+    try {
+      const res = await api.get<AdRevenueReport>('/admin/api/ad-revenue-report', {
+        params: {
+          date_from: from,
+          date_to: to,
+          user_id: userId ?? undefined,
+          ad_type: adType ?? undefined,
+          granularity: gran,
+          limit,
+        },
+      });
+      setData(res.data);
+      setQueriedLimit(limit);
+      setQueriedGranularity(gran);
+      setQueriedMultiDay(multiDay);
+    } catch (e) {
+      message.error(errMsg(e));
+    } finally {
+      setLoading(false);
+    }
+  }, [range, userId, adType, granularity, limit]);
+
+  useEffect(() => {
+    load();
+    // 仅首次自动拉今天;之后由「查询」按钮触发
+    // eslint-disable-next-line react-hooks/exhaustive-deps
+  }, []);
+
+  const columns: ColumnsType<AdRevenueRow> = [
+    ...(queriedMultiDay
+      ? [{ title: '日期', dataIndex: 'report_date', width: 110, fixed: 'left' } as ColumnsType<AdRevenueRow>[number]]
+      : []),
+    { title: '用户', dataIndex: 'user_id', width: 80 },
+    ...(queriedGranularity === 'hour'
+      ? [
+          {
+            title: '小时',
+            dataIndex: 'hour',
+            width: 90,
+            render: (h: number | null) =>
+              h == null ? '-' : `${String(h).padStart(2, '0')}:00`,
+          } as ColumnsType<AdRevenueRow>[number],
+        ]
+      : []),
+    {
+      title: '广告类型',
+      dataIndex: 'ad_type',
+      width: 120,
+      render: (s: string) => {
+        const t = TYPE_TAG[s] ?? { color: 'default', label: s };
+        return <Tag color={t.color}>{t.label}</Tag>;
+      },
+    },
+    {
+      title: '来源应用',
+      dataIndex: 'app_env',
+      width: 150,
+      render: (v: string | null) => {
+        if (!v) return <Typography.Text type="secondary">未知</Typography.Text>;
+        const t = APP_TAG[v] ?? { color: 'default', label: v };
+        return <Tag color={t.color}>{t.label}</Tag>;
+      },
+    },
+    {
+      title: '广告位ID',
+      dataIndex: 'our_code_id',
+      width: 120,
+      render: (v: string | null) =>
+        v ? <Typography.Text code>{v}</Typography.Text> : <Typography.Text type="secondary">-</Typography.Text>,
+    },
+    { title: '展示条数', dataIndex: 'impressions', width: 90, align: 'right' },
+    {
+      title: '预估收益(元)',
+      dataIndex: 'revenue_yuan',
+      width: 120,
+      align: 'right',
+      render: (v: number) => v.toFixed(4),
+    },
+    {
+      title: '应发金币',
+      dataIndex: 'expected_coin',
+      width: 100,
+      align: 'right',
+      render: (v: number) => <b>{v}</b>,
+    },
+    { title: '实发金币', dataIndex: 'actual_coin', width: 100, align: 'right' },
+    {
+      title: '一致',
+      dataIndex: 'matched',
+      width: 80,
+      align: 'center',
+      render: (m: boolean) => (m ? <Tag color="green">✓</Tag> : <Tag color="red">✗ 不符</Tag>),
+    },
+    {
+      title: '底层 ADN',
+      dataIndex: 'adns',
+      render: (v: string[]) =>
+        v.length ? v.map((a) => <Tag key={a}>{a}</Tag>) : <Typography.Text type="secondary">-</Typography.Text>,
+    },
+  ];
+
+  // 派生指标(全部基于全量 total_* 字段,不受 limit 截断影响,准):
+  // 平均 eCPM = 收益÷展示×1000;发奖成本(元)= 实发金币÷汇率;预估毛利 = 收益−发奖成本;
+  // 发奖占收益比 = 发奖成本÷收益;应发实发差额(金币)= 应发−实发(正=少发/负=多发)。
+  const derived = data
+    ? {
+        avgEcpm: data.total_impressions
+          ? (data.total_revenue_yuan / data.total_impressions) * 1000
+          : 0,
+        payoutYuan: data.total_actual_coin / COIN_PER_YUAN,
+        grossProfit: data.total_revenue_yuan - data.total_actual_coin / COIN_PER_YUAN,
+        payoutRatioPct:
+          data.total_revenue_yuan > 0
+            ? (data.total_actual_coin / COIN_PER_YUAN / data.total_revenue_yuan) * 100
+            : null,
+        coinGap: data.total_expected_coin - data.total_actual_coin,
+      }
+    : null;
+
+  return (
+    <div>
+      <Space align="center" style={{ display: 'flex', marginBottom: 16 }}>
+        <h2 style={{ margin: 0 }}>广告数据</h2>
+        <Button
+          type="link"
+          size="small"
+          icon={<QuestionCircleOutlined />}
+          onClick={() => setFormulaOpen(true)}
+        >
+          金币计算规则
+        </Button>
+        <Popover
+          placement="bottomLeft"
+          title="收益口径说明"
+          content={
+            <div style={{ maxWidth: 360, fontSize: 13, lineHeight: 1.7 }}>
+              「预估收益」为客户端在广告展示(onAdShow)时上报 eCPM 折算的预估值(每千次展示 ÷1000
+              累加),<b>只要广告展示就计入、不论是否看完发奖</b>;穿山甲会过滤无效/过短曝光,故预估值可能偏高,
+              <b>实际收益一律以穿山甲后台结算为准</b>。测试应用多为 0。「广告位ID / 来源应用」为本期新增,历史记录留空。
+            </div>
+          }
+        >
+          <Button type="link" size="small" icon={<InfoCircleOutlined />}>
+            收益口径
+          </Button>
+        </Popover>
+      </Space>
+
+      <Card size="small" style={{ marginBottom: 16 }}>
+        <Space wrap size="middle" align="center">
+          <Space size={6}>
+            <Typography.Text type="secondary">日期</Typography.Text>
+            <RangePicker
+              value={range}
+              onChange={(v) => v && v[0] && v[1] && setRange([v[0], v[1]])}
+              allowClear={false}
+              presets={[
+                { label: '今天', value: [dayjs(), dayjs()] },
+                { label: '近 7 天', value: [dayjs().subtract(6, 'day'), dayjs()] },
+                { label: '近 30 天', value: [dayjs().subtract(29, 'day'), dayjs()] },
+              ]}
+            />
+          </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">用户</Typography.Text>
+            <InputNumber
+              placeholder="可空"
+              value={userId ?? undefined}
+              onChange={(v) => setUserId(v ?? null)}
+              style={{ width: 130 }}
+            />
+          </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">类型</Typography.Text>
+            <Select
+              placeholder="全部"
+              value={adType}
+              onChange={setAdType}
+              allowClear
+              style={{ width: 150 }}
+              options={[
+                { value: 'reward_video', label: '激励视频' },
+                { value: 'feed', label: '信息流' },
+                { value: 'draw', label: 'Draw 信息流' },
+              ]}
+            />
+          </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">粒度</Typography.Text>
+            <Select
+              value={rangeMultiDay ? 'day' : granularity}
+              onChange={setGranularity}
+              disabled={rangeMultiDay}
+              style={{ width: 110 }}
+              title={rangeMultiDay ? '跨多天仅支持按天' : undefined}
+              options={[
+                { value: 'day', label: '按天' },
+                { value: 'hour', label: '按小时' },
+              ]}
+            />
+          </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">条数</Typography.Text>
+            <Select
+              value={limit}
+              onChange={setLimit}
+              style={{ width: 110 }}
+              options={[100, 200, 500, 1000].map((n) => ({ value: n, label: `${n} 组` }))}
+            />
+          </Space>
+          <Button type="primary" onClick={load} loading={loading}>
+            查询
+          </Button>
+        </Space>
+      </Card>
+
+      {data && derived && (
+        <Card size="small" style={{ marginBottom: 16 }}>
+          <Divider orientation="left" plain style={{ marginTop: 0, marginBottom: 16 }}>
+            <Typography.Text type="secondary" style={{ fontSize: 12 }}>
+              广告展示与收益
+            </Typography.Text>
+          </Divider>
+          <Row gutter={[16, 12]}>
+            <Col span={6}>
+              <Statistic title="展示条数合计" value={data.total_impressions} />
+            </Col>
+            <Col span={6}>
+              <Statistic title="平均 eCPM(元/千次)" value={derived.avgEcpm} precision={2} />
+            </Col>
+            <Col span={6}>
+              <Statistic title="预估收益合计(元)" value={data.total_revenue_yuan} precision={4} />
+            </Col>
+            <Col span={6}>
+              <Statistic title="聚合组数" value={data.total} />
+            </Col>
+          </Row>
+          <Divider orientation="left" plain style={{ marginTop: 20, marginBottom: 16 }}>
+            <Typography.Text type="secondary" style={{ fontSize: 12 }}>
+              发奖与对账
+            </Typography.Text>
+          </Divider>
+          <Row gutter={[16, 12]}>
+            <Col span={6}>
+              <Statistic title="应发金币合计" value={data.total_expected_coin} />
+            </Col>
+            <Col span={6}>
+              <Statistic title="实发金币合计" value={data.total_actual_coin} />
+            </Col>
+            <Col span={6}>
+              <Statistic title="发奖成本(元)" value={derived.payoutYuan} precision={4} />
+            </Col>
+            <Col span={6}>
+              <Statistic
+                title="预估毛利(元)"
+                value={derived.grossProfit}
+                precision={4}
+                prefix={derived.grossProfit >= 0 ? <RiseOutlined /> : <FallOutlined />}
+                valueStyle={{ color: derived.grossProfit >= 0 ? '#3f8600' : '#cf1322' }}
+              />
+              <Typography.Text type="secondary" style={{ fontSize: 12 }}>
+                发奖占收益{' '}
+                {derived.payoutRatioPct == null ? '—' : `${derived.payoutRatioPct.toFixed(0)}%`}
+              </Typography.Text>
+            </Col>
+          </Row>
+        </Card>
+      )}
+
+      {data && (
+        <Space direction="vertical" style={{ width: '100%', marginBottom: 12 }}>
+          {data.mismatch_count > 0 ? (
+            <Alert
+              type="error"
+              showIcon
+              message={`共 ${data.total} 组,其中 ${data.mismatch_count} 组应发≠实发(✗);应发−实发 合计 ${
+                derived && derived.coinGap >= 0 ? '+' : ''
+              }${derived?.coinGap ?? 0} 金币(正=少发/负=多发)——公式可能未生效或发奖有问题。定位到具体记录可用后端逐条审计接口。`}
+            />
+          ) : (
+            <Alert type="success" showIcon message={`共 ${data.total} 组,应发与实发全部一致。`} />
+          )}
+          {data.truncated && (
+            <Alert
+              type="warning"
+              showIcon
+              message={`聚合明细已截断到 ${queriedLimit} 组,还有更多未显示——请按用户/类型/日期缩小范围,或调大「组数」。合计数字不受影响。`}
+            />
+          )}
+        </Space>
+      )}
+
+      {data &&
+        (queriedMultiDay
+          ? (data.daily?.length ?? 0) > 0
+          : queriedGranularity === 'hour' && (data.items?.length ?? 0) > 0) && (
+        <Card
+          size="small"
+          title={queriedMultiDay ? '按天趋势' : '按小时趋势'}
+          style={{ marginBottom: 16 }}
+          extra={
+            <Space size={16}>
+              <span style={{ fontSize: 12, color: '#666' }}>
+                <span
+                  style={{
+                    display: 'inline-block',
+                    width: 10,
+                    height: 10,
+                    background: CHART_BAR,
+                    borderRadius: 2,
+                    marginRight: 4,
+                  }}
+                />
+                展示条数
+              </span>
+              <span style={{ fontSize: 12, color: '#666' }}>
+                <span
+                  style={{
+                    display: 'inline-block',
+                    width: 14,
+                    borderTop: `2px solid ${CHART_LINE}`,
+                    marginRight: 4,
+                    verticalAlign: 'middle',
+                  }}
+                />
+                预估收益(元)
+              </span>
+            </Space>
+          }
+        >
+          {/* 按小时图由 items 聚合,会被 limit 截断;按天图用 daily(全量)不受影响,故只在按小时时警告 */}
+          {!queriedMultiDay && data.truncated && (
+            <Alert
+              type="warning"
+              showIcon
+              style={{ marginBottom: 12 }}
+              message={`图表按小时聚合的是已截断到 ${queriedLimit} 组的明细,可能少算——调大「条数」或缩小筛选可还原真实趋势。`}
+            />
+          )}
+          {queriedMultiDay ? (
+            <TrendChart points={aggregateDaily(data.date_from, data.date_to, data.daily)} />
+          ) : (
+            <TrendChart points={aggregateHourly(data.items)} />
+          )}
+        </Card>
+      )}
+
+      <Table
+        rowKey={(r) => `${r.report_date}-${r.user_id}-${r.ad_type}-${r.app_env ?? ''}-${r.our_code_id ?? ''}-${r.hour ?? ''}`}
+        columns={columns}
+        dataSource={data?.items ?? []}
+        loading={loading}
+        pagination={false}
+        size="small"
+        scroll={{ x: 1100 }}
+        rowClassName={(r) => (r.matched ? '' : 'row-mismatch')}
+        expandable={{
+          rowExpandable: (r) =>
+            (r.impression_records?.length ?? 0) > 0 || (r.records?.length ?? 0) > 0,
+          expandedRowRender: (r) => {
+            const imps = r.impression_records ?? [];
+            const recs = r.records ?? [];
+            return (
+              <Space direction="vertical" size="middle" style={{ width: '100%' }}>
+                <div>
+                  <Typography.Text strong>展示明细</Typography.Text>{' '}
+                  <Typography.Text type="secondary">({imps.length} 条)</Typography.Text>
+                  <Table<AdRevenueImpression>
+                    style={{ marginTop: 8 }}
+                    rowKey="id"
+                    columns={IMPRESSION_COLUMNS}
+                    dataSource={imps}
+                    pagination={false}
+                    size="small"
+                    scroll={{ x: 700 }}
+                  />
+                </div>
+                <div>
+                  <Typography.Text strong>发奖明细</Typography.Text>{' '}
+                  <Typography.Text type="secondary">({recs.length} 条)</Typography.Text>
+                  <Table<AdRevenueRecord>
+                    style={{ marginTop: 8 }}
+                    rowKey="record_id"
+                    columns={DETAIL_COLUMNS}
+                    dataSource={recs}
+                    pagination={false}
+                    size="small"
+                    scroll={{ x: 900 }}
+                    rowClassName={(d) => (d.matched ? '' : 'row-mismatch')}
+                    locale={{ emptyText: '该组无发奖记录(只有展示,未发奖)' }}
+                  />
+                </div>
+              </Space>
+            );
+          },
+        }}
+      />
+      <Modal
+        title="金币计算规则"
+        open={formulaOpen}
+        onCancel={() => setFormulaOpen(false)}
+        footer={null}
+        width={680}
+      >
+        <Typography.Paragraph>
+          <b>单次奖励(元)</b> ＝（单次 eCPM<sub>元</sub> ÷ 1000)× <b>因子1</b>(eCPM 档)× <b>因子2</b>(LT 累计条数)
+        </Typography.Paragraph>
+        <Typography.Paragraph type="secondary" style={{ fontSize: 13 }}>
+          · eCPM 取自穿山甲 SDK <Typography.Text code>getEcpm()</Typography.Text> 原值,单位「分/千次展示」,计算时 ÷100 转元;单次收益按「每千次 ÷1000」折到每次。
+          <br />· 金币汇率:<b>1 元 ＝ {COIN_PER_YUAN.toLocaleString()} 金币</b>,最终四舍五入取整。
+          <br />· 因子2「LT 累计条数」按该账号累计第几条计(不按天重置);激励视频每次 1 条,信息流每满 10 秒折 1 条。
+          <br />· 本表与发奖后端同源,本页「应发金币」即按此复算并与「实发金币」对账。
+        </Typography.Paragraph>
+        <Row gutter={16}>
+          <Col span={12}>
+            <Typography.Text strong>因子1 ·按 eCPM(元/千次)判档</Typography.Text>
+            <Table
+              style={{ marginTop: 8 }}
+              size="small"
+              pagination={false}
+              dataSource={ECPM_FACTOR_ROWS}
+              columns={[
+                { title: 'eCPM 范围(元)', dataIndex: 'range' },
+                { title: '因子1', dataIndex: 'factor', width: 80 },
+              ]}
+            />
+          </Col>
+          <Col span={12}>
+            <Typography.Text strong>因子2 ·按账号 LT 累计条数</Typography.Text>
+            <Table
+              style={{ marginTop: 8 }}
+              size="small"
+              pagination={false}
+              dataSource={LT_FACTOR_ROWS}
+              columns={[
+                { title: 'LT 累计条数', dataIndex: 'lt' },
+                { title: '因子2', dataIndex: 'factor', width: 80 },
+              ]}
+            />
+          </Col>
+        </Row>
+        <Typography.Paragraph type="secondary" style={{ fontSize: 13, marginTop: 12, marginBottom: 0 }}>
+          示例:eCPM ＝ 300 元/千次、账号第 1 条 → 0.3 × 0.4 × 2.0 ＝ 0.24 元 ＝ 2,400 金币。
+        </Typography.Paragraph>
+      </Modal>
+
+      <style jsx global>{`
+        .row-mismatch > td {
+          background: #fff1f0 !important;
+        }
+      `}</style>
+    </div>
+  );
+}
@@ -4,6 +4,7 @@ import { useEffect, useState } from 'react';
 import type { ColumnsType } from 'antd/es/table';
 import { Button, Form, Input, Modal, Select, Table, Tag, message } from 'antd';
 import { api, errMsg } from '@/lib/api';
+import { formatUtcTime } from '@/lib/format';
 import type { AdminInfo } from '@/lib/types';

 const ROLES = [
@@ -11,7 +12,8 @@ const ROLES = [
  { value: 'finance', label: 'finance' },
  { value: 'operator', label: 'operator' },
 ];
-const dt = (v: string | null) => (v ? new Date(v).toLocaleString('zh-CN') : '从未');
+// last_login_at 为 UTC 口径(datetime.now(utc)),按北京显示(勿用 new Date().toLocaleString)
+const dt = (v: string | null) => (v ? formatUtcTime(v, 'YYYY-MM-DD HH:mm:ss') : '从未');

 export default function AdminsPage() {
  const [admins, setAdmins] = useState<AdminInfo[]>([]);
@@ -3,19 +3,18 @@
 import { useState } from 'react';
 import type { ColumnsType } from 'antd/es/table';
 import { Button, Input, Space, Table, Tag } from 'antd';
-import { useCursorList } from '@/lib/useCursorList';
+import { formatUtcTime } from '@/lib/format';
+import { usePagedList } from '@/lib/usePagedList';
 import type { AuditLog } from '@/lib/types';

-const dt = (v: string) => new Date(v).toLocaleString('zh-CN');
+// 审计 created_at 为 UTC 口径(server_default now()),按北京显示(勿用 new Date().toLocaleString)
+const dt = (v: string) => formatUtcTime(v, 'YYYY-MM-DD HH:mm:ss');

 export default function AuditLogsPage() {
  const [action, setAction] = useState('');
  const [filters, setFilters] = useState<Record<string, unknown>>({});
-  const { items, nextCursor, loading, loadMore } = useCursorList<AuditLog>(
-    '/admin/api/audit-logs',
-    filters,
-    50,
-  );
+  const { items, total, page, pageSize, loading, onChange: onPageChange } =
+    usePagedList<AuditLog>('/admin/api/audit-logs', filters, 50);

  const search = () => setFilters({ action: action || undefined });

@@ -59,14 +58,16 @@ export default function AuditLogsPage() {
        columns={columns}
        dataSource={items}
        loading={loading}
-        pagination={false}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 条`,
+          onChange: onPageChange,
+        }}
        scroll={{ x: 1000 }}
      />
-      <div style={{ marginTop: 16, textAlign: 'center' }}>
-        <Button onClick={loadMore} disabled={!nextCursor} loading={loading}>
-          {nextCursor ? '加载更多' : '没有更多了'}
-        </Button>
-      </div>
    </div>
  );
 }
@@ -0,0 +1,719 @@
+'use client';
+
+// CPS 优惠券分发与对账(当前仅美团)。单页 Tabs:对账统计 / 群管理 / 活动管理 / 订单明细。
+// 群管理生成带 sid 的券链接 → 发群 → 对账按 sid 拉回订单/佣金归群统计。
+import { useCallback, useEffect, useState } from 'react';
+import type { ColumnsType } from 'antd/es/table';
+import {
+  Button,
+  Card,
+  Form,
+  Input,
+  InputNumber,
+  Modal,
+  Select,
+  Space,
+  Statistic,
+  Table,
+  Tabs,
+  Tag,
+  Typography,
+  message,
+} from 'antd';
+import { api, errMsg } from '@/lib/api';
+import { canDo } from '@/lib/auth';
+import { formatUtcTime, yuan } from '@/lib/format';
+import { usePagedList } from '@/lib/usePagedList';
+import type {
+  CpsActivity,
+  CpsGroup,
+  CpsGroupStat,
+  CpsOrder,
+  CpsReconcileResult,
+  CpsReferralLink,
+  CpsStats,
+} from '@/lib/types';
+
+const MT_STATUS: Record<string, { text: string; color: string }> = {
+  '2': { text: '已付款', color: 'blue' },
+  '3': { text: '已完成', color: 'cyan' },
+  '4': { text: '已取消', color: 'red' },
+  '5': { text: '风控', color: 'orange' },
+  '6': { text: '已结算', color: 'green' },
+};
+
+const LINK_TYPE_NAME: Record<string, string> = {
+  '1': 'H5 长链',
+  '2': '短链(微信可发)',
+  '3': 'deeplink(唤起 App)',
+};
+
+const fmtRate = (r: string | null) => (r ? `${Number(r) / 100}%` : '-');
+
+export default function CpsPage() {
+  return (
+    <div>
+      <h2>CPS 优惠券分发与对账</h2>
+      <Typography.Paragraph type="secondary" style={{ marginTop: -8 }}>
+        当前仅接美团联盟。每群一个 sid:在「群管理」给群生成带 sid 的券链接发群,「对账统计」按 sid
+        拉回订单与佣金归群。点击数需独立跳转服务(第二期)。
+      </Typography.Paragraph>
+      <Tabs
+        defaultActiveKey="stats"
+        destroyInactiveTabPane
+        items={[
+          { key: 'stats', label: '对账统计', children: <StatsTab /> },
+          { key: 'groups', label: '群管理', children: <GroupsTab /> },
+          { key: 'activities', label: '活动管理', children: <ActivitiesTab /> },
+          { key: 'orders', label: '订单明细', children: <OrdersTab /> },
+        ]}
+      />
+    </div>
+  );
+}
+
+// ───────────── 对账统计 ─────────────
+function StatsTab() {
+  const [days, setDays] = useState(30);
+  const [data, setData] = useState<CpsStats | null>(null);
+  const [loading, setLoading] = useState(false);
+  const [reconciling, setReconciling] = useState(false);
+  const canReconcile = canDo(['finance']);
+
+  const load = useCallback(async (d: number) => {
+    setLoading(true);
+    try {
+      const resp = await api.get<CpsStats>('/admin/api/cps/stats', { params: { days: d } });
+      setData(resp.data);
+    } catch (e) {
+      message.error(errMsg(e));
+    } finally {
+      setLoading(false);
+    }
+  }, []);
+
+  useEffect(() => {
+    load(days);
+  }, [days, load]);
+
+  const reconcile = async () => {
+    setReconciling(true);
+    try {
+      const resp = await api.post<CpsReconcileResult>('/admin/api/cps/orders/reconcile', null, {
+        params: { days },
+      });
+      const r = resp.data;
+      message.success(`对账完成:拉取 ${r.fetched} 单(新增 ${r.inserted}、更新 ${r.updated})`);
+      load(days);
+    } catch (e) {
+      message.error(errMsg(e));
+    } finally {
+      setReconciling(false);
+    }
+  };
+
+  const columns: ColumnsType<CpsGroupStat> = [
+    { title: '群', dataIndex: 'name', width: 160, ellipsis: true },
+    {
+      title: 'sid',
+      dataIndex: 'sid',
+      width: 130,
+      render: (v: string | null) => (v ? <Typography.Text copyable>{v}</Typography.Text> : '-'),
+    },
+    { title: '人数', dataIndex: 'member_count', width: 70, render: (v) => v ?? '-' },
+    { title: '点击', dataIndex: 'click_pv', width: 70 },
+    { title: '独立访客', dataIndex: 'click_uv', width: 80 },
+    { title: '有效单', dataIndex: 'order_count', width: 70 },
+    {
+      title: '取消/风控',
+      dataIndex: 'canceled_count',
+      width: 85,
+      render: (v: number) => (v ? <span style={{ color: '#cf1322' }}>{v}</span> : 0),
+    },
+    {
+      title: '点击→下单',
+      key: 'rate',
+      width: 90,
+      render: (_, r) =>
+        r.click_uv ? `${((r.order_count / r.click_uv) * 100).toFixed(0)}%` : '-',
+    },
+    { title: '成交额', dataIndex: 'gmv_cents', width: 110, render: (v: number) => yuan(v) },
+    {
+      title: '预估佣金',
+      dataIndex: 'est_commission_cents',
+      width: 110,
+      sorter: (a, b) => a.est_commission_cents - b.est_commission_cents,
+      render: (v: number) => <b>{yuan(v)}</b>,
+    },
+    {
+      title: '已结算佣金',
+      dataIndex: 'settled_commission_cents',
+      width: 110,
+      render: (v: number) => <span style={{ color: '#3f8600' }}>{yuan(v)}</span>,
+    },
+  ];
+
+  return (
+    <div>
+      <Space style={{ marginBottom: 16 }} wrap>
+        <span>统计区间</span>
+        <Select
+          value={days}
+          onChange={setDays}
+          style={{ width: 120 }}
+          options={[
+            { value: 7, label: '近 7 天' },
+            { value: 30, label: '近 30 天' },
+            { value: 90, label: '近 90 天' },
+          ]}
+        />
+        {canReconcile && (
+          <Button type="primary" loading={reconciling} onClick={reconcile}>
+            刷新对账(拉美团订单)
+          </Button>
+        )}
+        <Typography.Text type="secondary">
+          佣金为美团预估口径,实际以「已结算」为准
+        </Typography.Text>
+      </Space>
+
+      <Space size="large" style={{ marginBottom: 16 }} wrap>
+        <Card size="small">
+          <Statistic title="有效订单数" value={data?.total_order_count ?? 0} />
+        </Card>
+        <Card size="small">
+          <Statistic
+            title="预估佣金"
+            value={(data?.total_est_commission_cents ?? 0) / 100}
+            precision={2}
+            prefix="¥"
+          />
+        </Card>
+        <Card size="small">
+          <Statistic
+            title="已结算佣金"
+            value={(data?.total_settled_commission_cents ?? 0) / 100}
+            precision={2}
+            prefix="¥"
+            valueStyle={{ color: '#3f8600' }}
+          />
+        </Card>
+      </Space>
+
+      <Table
+        rowKey={(r) => r.sid ?? `gid-${r.group_id ?? 'none'}`}
+        columns={columns}
+        dataSource={data?.groups ?? []}
+        loading={loading}
+        pagination={false}
+        scroll={{ x: 1120 }}
+      />
+    </div>
+  );
+}
+
+// ───────────── 群管理 ─────────────
+function GroupsTab() {
+  const [keyword, setKeyword] = useState('');
+  const [applied, setApplied] = useState<Record<string, unknown>>({});
+  const { items, total, page, pageSize, loading, onChange, reload } = usePagedList<CpsGroup>(
+    '/admin/api/cps/groups',
+    applied,
+  );
+  const canManage = canDo(['operator']);
+
+  const [editing, setEditing] = useState<CpsGroup | null>(null); // null=不开,{} 新建用单独标志
+  const [createOpen, setCreateOpen] = useState(false);
+  const [linkGroup, setLinkGroup] = useState<CpsGroup | null>(null);
+
+  const columns: ColumnsType<CpsGroup> = [
+    { title: 'ID', dataIndex: 'id', width: 70 },
+    { title: '群名', dataIndex: 'name', width: 180, ellipsis: true },
+    {
+      title: 'sid',
+      dataIndex: 'sid',
+      width: 150,
+      render: (v: string) => <Typography.Text copyable>{v}</Typography.Text>,
+    },
+    { title: '人数', dataIndex: 'member_count', width: 80, render: (v) => v ?? '-' },
+    {
+      title: '状态',
+      dataIndex: 'status',
+      width: 90,
+      render: (s: string) => <Tag color={s === 'active' ? 'green' : 'default'}>{s}</Tag>,
+    },
+    { title: '备注', dataIndex: 'remark', width: 160, ellipsis: true, render: (v) => v || '-' },
+    { title: '创建时间', dataIndex: 'created_at', width: 150, render: (v: string) => formatUtcTime(v) },
+    {
+      title: '操作',
+      key: 'op',
+      fixed: 'right',
+      width: 170,
+      render: (_, g) => (
+        <Space onClick={(e) => e.stopPropagation()}>
+          {canManage && <a onClick={() => setLinkGroup(g)}>生成链接</a>}
+          {canManage && <a onClick={() => setEditing(g)}>编辑</a>}
+        </Space>
+      ),
+    },
+  ];
+
+  return (
+    <div>
+      <Space style={{ marginBottom: 16 }} wrap>
+        <Input
+          placeholder="群名/sid"
+          value={keyword}
+          onChange={(e) => setKeyword(e.target.value)}
+          onPressEnter={() => setApplied({ keyword: keyword || undefined })}
+          allowClear
+          style={{ width: 180 }}
+        />
+        <Button type="primary" onClick={() => setApplied({ keyword: keyword || undefined })}>
+          查询
+        </Button>
+        {canManage && (
+          <Button onClick={() => setCreateOpen(true)}>新建群</Button>
+        )}
+      </Space>
+
+      <Table
+        rowKey="id"
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 个群`,
+          onChange,
+        }}
+        scroll={{ x: 1050 }}
+      />
+
+      <GroupFormModal
+        open={createOpen}
+        group={null}
+        onClose={() => setCreateOpen(false)}
+        onDone={reload}
+      />
+      <GroupFormModal
+        open={!!editing}
+        group={editing}
+        onClose={() => setEditing(null)}
+        onDone={reload}
+      />
+      <ReferralLinkModal group={linkGroup} onClose={() => setLinkGroup(null)} />
+    </div>
+  );
+}
+
+function GroupFormModal({
+  open,
+  group,
+  onClose,
+  onDone,
+}: {
+  open: boolean;
+  group: CpsGroup | null;
+  onClose: () => void;
+  onDone: () => void;
+}) {
+  const [form] = Form.useForm();
+  const isEdit = !!group;
+
+  useEffect(() => {
+    if (open) {
+      if (group) {
+        form.setFieldsValue({
+          name: group.name,
+          member_count: group.member_count,
+          remark: group.remark,
+          status: group.status,
+        });
+      } else {
+        form.resetFields();
+      }
+    }
+  }, [open, group, form]);
+
+  const submit = async () => {
+    const v = await form.validateFields();
+    try {
+      if (isEdit && group) {
+        await api.patch(`/admin/api/cps/groups/${group.id}`, v);
+        message.success('已更新群');
+      } else {
+        await api.post('/admin/api/cps/groups', v);
+        message.success('已新建群');
+      }
+      onClose();
+      onDone();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
+  return (
+    <Modal
+      title={isEdit ? '编辑群' : '新建群'}
+      open={open}
+      onOk={submit}
+      onCancel={onClose}
+      destroyOnHidden
+    >
+      <Form form={form} layout="vertical">
+        <Form.Item name="name" label="群名" rules={[{ required: true, message: '请输入群名' }]}>
+          <Input placeholder="如:宝妈优惠群1" />
+        </Form.Item>
+        {!isEdit && (
+          <Form.Item
+            name="sid"
+            label="sid(渠道标识,留空自动生成 g+ID)"
+            rules={[{ pattern: /^[A-Za-z0-9]+$/, message: '仅字母和数字' }]}
+          >
+            <Input placeholder="留空自动生成;或自定义如 baoma1" maxLength={64} />
+          </Form.Item>
+        )}
+        <Form.Item name="member_count" label="群人数(用于估算转化率)">
+          <InputNumber style={{ width: '100%' }} min={0} placeholder="如 200" />
+        </Form.Item>
+        {isEdit && (
+          <Form.Item name="status" label="状态">
+            <Select
+              options={[
+                { value: 'active', label: 'active(启用)' },
+                { value: 'archived', label: 'archived(归档)' },
+              ]}
+            />
+          </Form.Item>
+        )}
+        <Form.Item name="remark" label="备注">
+          <Input.TextArea rows={2} maxLength={256} />
+        </Form.Item>
+      </Form>
+    </Modal>
+  );
+}
+
+function ReferralLinkModal({ group, onClose }: { group: CpsGroup | null; onClose: () => void }) {
+  const [activities, setActivities] = useState<CpsActivity[]>([]);
+  const [activityId, setActivityId] = useState<number | undefined>();
+  const [result, setResult] = useState<CpsReferralLink | null>(null);
+  const [loading, setLoading] = useState(false);
+
+  useEffect(() => {
+    if (!group) {
+      setActivityId(undefined);
+      setResult(null);
+      return;
+    }
+    api
+      .get('/admin/api/cps/activities', { params: { status: 'active', limit: 100 } })
+      .then((r) => setActivities(r.data.items as CpsActivity[]))
+      .catch((e) => message.error(errMsg(e)));
+  }, [group]);
+
+  const generate = async () => {
+    if (!group || !activityId) {
+      message.warning('请选择活动');
+      return;
+    }
+    setLoading(true);
+    try {
+      const resp = await api.post<CpsReferralLink>('/admin/api/cps/referral-link', {
+        group_id: group.id,
+        activity_id: activityId,
+      });
+      setResult(resp.data);
+    } catch (e) {
+      message.error(errMsg(e));
+    } finally {
+      setLoading(false);
+    }
+  };
+
+  return (
+    <Modal
+      title={`生成券链接 - ${group?.name ?? ''}(sid=${group?.sid ?? ''})`}
+      open={!!group}
+      onCancel={onClose}
+      onOk={generate}
+      okText="生成"
+      confirmLoading={loading}
+      destroyOnHidden
+      width={640}
+    >
+      <Form layout="vertical">
+        <Form.Item label="选择活动" required>
+          <Select
+            placeholder="选要推广的活动"
+            value={activityId}
+            onChange={setActivityId}
+            options={activities.map((a) => ({
+              value: a.id,
+              label: `${a.name}${a.act_id ? ` (actId=${a.act_id})` : ''}`,
+            }))}
+            notFoundContent="无活动,请先到「活动管理」新建"
+          />
+        </Form.Item>
+      </Form>
+
+      {result && (
+        <div style={{ marginTop: 8 }}>
+          <Typography.Text strong>👇 发群就用这条链接(已带 sid={result.sid},点击会被统计):</Typography.Text>
+          <div
+            style={{
+              marginTop: 8,
+              padding: 12,
+              background: '#f6ffed',
+              border: '1px solid #b7eb8f',
+              borderRadius: 6,
+            }}
+          >
+            <Typography.Text
+              copyable={{ text: result.redirect_url }}
+              style={{ fontSize: 15, wordBreak: 'break-all' }}
+            >
+              {result.redirect_url}
+            </Typography.Text>
+          </div>
+          {!result.redirect_url.startsWith('http') && (
+            <Typography.Text type="warning" style={{ fontSize: 12 }}>
+              ⚠️ 后端未配 CPS_REDIRECT_BASE,这是相对路径;请在 .env 配跳转域名后重启
+            </Typography.Text>
+          )}
+          <Typography.Paragraph type="secondary" style={{ marginTop: 14, marginBottom: 4, fontSize: 12 }}>
+            美团原始链接(参考/备用,直接发不带点击统计):
+          </Typography.Paragraph>
+          {Object.entries(result.link_map).map(([type, url]) => (
+            <div key={type} style={{ marginBottom: 4 }}>
+              <Tag>{LINK_TYPE_NAME[type] ?? type}</Tag>
+              <Typography.Text
+                copyable={{ text: url }}
+                style={{ fontSize: 12, color: '#999', wordBreak: 'break-all' }}
+              >
+                {url.length > 56 ? `${url.slice(0, 56)}…` : url}
+              </Typography.Text>
+            </div>
+          ))}
+        </div>
+      )}
+    </Modal>
+  );
+}
+
+// ───────────── 活动管理 ─────────────
+function ActivitiesTab() {
+  const { items, total, page, pageSize, loading, onChange, reload } = usePagedList<CpsActivity>(
+    '/admin/api/cps/activities',
+    {},
+  );
+  const canManage = canDo(['operator']);
+  const [createOpen, setCreateOpen] = useState(false);
+
+  const columns: ColumnsType<CpsActivity> = [
+    { title: 'ID', dataIndex: 'id', width: 70 },
+    { title: '平台', dataIndex: 'platform', width: 90, render: (v: string) => <Tag>{v}</Tag> },
+    { title: '活动名', dataIndex: 'name', width: 220, ellipsis: true },
+    {
+      title: 'actId',
+      dataIndex: 'act_id',
+      width: 120,
+      render: (v: string | null) => v || '-',
+    },
+    {
+      title: 'productViewSign',
+      dataIndex: 'product_view_sign',
+      width: 160,
+      ellipsis: true,
+      render: (v: string | null) => v || '-',
+    },
+    {
+      title: '状态',
+      dataIndex: 'status',
+      width: 90,
+      render: (s: string) => <Tag color={s === 'active' ? 'green' : 'default'}>{s}</Tag>,
+    },
+    { title: '创建时间', dataIndex: 'created_at', width: 150, render: (v: string) => formatUtcTime(v) },
+  ];
+
+  return (
+    <div>
+      {canManage && (
+        <Space style={{ marginBottom: 16 }}>
+          <Button type="primary" onClick={() => setCreateOpen(true)}>
+            新建活动
+          </Button>
+        </Space>
+      )}
+      <Table
+        rowKey="id"
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 个活动`,
+          onChange,
+        }}
+        scroll={{ x: 1000 }}
+      />
+      <ActivityFormModal open={createOpen} onClose={() => setCreateOpen(false)} onDone={reload} />
+    </div>
+  );
+}
+
+function ActivityFormModal({
+  open,
+  onClose,
+  onDone,
+}: {
+  open: boolean;
+  onClose: () => void;
+  onDone: () => void;
+}) {
+  const [form] = Form.useForm();
+
+  useEffect(() => {
+    if (open) form.resetFields();
+  }, [open, form]);
+
+  const submit = async () => {
+    const v = await form.validateFields();
+    if (!v.act_id && !v.product_view_sign) {
+      message.warning('actId 与 productViewSign 至少填一个');
+      return;
+    }
+    try {
+      await api.post('/admin/api/cps/activities', v);
+      message.success('已新建活动');
+      onClose();
+      onDone();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
+  return (
+    <Modal title="新建活动" open={open} onOk={submit} onCancel={onClose} destroyOnHidden>
+      <Form form={form} layout="vertical" initialValues={{ platform: 'meituan' }}>
+        <Form.Item name="name" label="活动名" rules={[{ required: true }]}>
+          <Input placeholder="如:点我领取大额红包" />
+        </Form.Item>
+        <Form.Item name="platform" label="平台">
+          <Select
+            options={[
+              { value: 'meituan', label: '美团(已支持)' },
+              { value: 'taobao', label: '淘宝(待接入)', disabled: true },
+              { value: 'jd', label: '京东(待接入)', disabled: true },
+            ]}
+          />
+        </Form.Item>
+        <Form.Item name="act_id" label="actId(美团活动物料 ID,推荐)">
+          <Input placeholder="美团联盟「我要推广-活动推广」第一列 ID,如 792" maxLength={64} />
+        </Form.Item>
+        <Form.Item name="product_view_sign" label="productViewSign(商品券,与 actId 二选一)">
+          <Input maxLength={128} />
+        </Form.Item>
+        <Form.Item name="remark" label="备注">
+          <Input.TextArea rows={2} maxLength={256} />
+        </Form.Item>
+      </Form>
+    </Modal>
+  );
+}
+
+// ───────────── 订单明细 ─────────────
+function OrdersTab() {
+  const [sid, setSid] = useState('');
+  const [status, setStatus] = useState<string | undefined>();
+  const [applied, setApplied] = useState<Record<string, unknown>>({});
+  const { items, total, page, pageSize, loading, onChange } = usePagedList<CpsOrder>(
+    '/admin/api/cps/orders',
+    applied,
+  );
+
+  const columns: ColumnsType<CpsOrder> = [
+    {
+      title: '订单号',
+      dataIndex: 'order_id',
+      width: 200,
+      ellipsis: true,
+      render: (v: string) => <Typography.Text copyable>{v}</Typography.Text>,
+    },
+    { title: 'sid', dataIndex: 'sid', width: 120, render: (v) => v || '-' },
+    { title: '商品', dataIndex: 'product_name', width: 200, ellipsis: true, render: (v) => v || '-' },
+    {
+      title: '成交额',
+      dataIndex: 'pay_price_cents',
+      width: 100,
+      render: (v: number | null) => (v != null ? yuan(v) : '-'),
+    },
+    {
+      title: '佣金',
+      dataIndex: 'commission_cents',
+      width: 90,
+      render: (v: number | null) => (v != null ? yuan(v) : '-'),
+    },
+    { title: '佣金率', dataIndex: 'commission_rate', width: 80, render: fmtRate },
+    {
+      title: '状态',
+      dataIndex: 'mt_status',
+      width: 90,
+      render: (s: string | null) => {
+        const m = s ? MT_STATUS[s] : null;
+        return m ? <Tag color={m.color}>{m.text}</Tag> : s || '-';
+      },
+    },
+    { title: '支付时间', dataIndex: 'pay_time', width: 150, render: (v) => formatUtcTime(v) },
+  ];
+
+  const search = () => setApplied({ sid: sid || undefined, mt_status: status });
+
+  return (
+    <div>
+      <Space style={{ marginBottom: 16 }} wrap>
+        <Input
+          placeholder="sid"
+          value={sid}
+          onChange={(e) => setSid(e.target.value)}
+          onPressEnter={search}
+          allowClear
+          style={{ width: 150 }}
+        />
+        <Select
+          placeholder="状态"
+          value={status}
+          onChange={setStatus}
+          allowClear
+          style={{ width: 120 }}
+          options={Object.entries(MT_STATUS).map(([v, m]) => ({ value: v, label: m.text }))}
+        />
+        <Button type="primary" onClick={search}>
+          查询
+        </Button>
+      </Space>
+      <Table
+        rowKey="id"
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 单`,
+          onChange,
+        }}
+        scroll={{ x: 1030 }}
+      />
+    </div>
+  );
+}
@@ -53,6 +53,7 @@ const yuan = (cents: number) => (cents / 100).toFixed(2);
 export default function HomeMarqueeSeeds() {
  const [seeds, setSeeds] = useState<Seed[]>([]);
  const [loading, setLoading] = useState(true);
+  const [selectedRowKeys, setSelectedRowKeys] = useState<number[]>([]); // 批量操作选中行

  const [modalOpen, setModalOpen] = useState(false);
  const [editing, setEditing] = useState<Seed | null>(null);
@@ -70,6 +71,8 @@ export default function HomeMarqueeSeeds() {
    try {
      const { data } = await api.get<Seed[]>('/admin/api/marquee-seeds');
      setSeeds(data);
+      // 列表刷新后清掉已不存在的选中 id(单行删除/外部变更后防悬空,顶部计数与批量操作才准)
+      setSelectedRowKeys((prev) => prev.filter((k) => data.some((s) => s.id === k)));
    } finally {
      setLoading(false);
    }
@@ -175,6 +178,33 @@ export default function HomeMarqueeSeeds() {
    }
  };

+  // ===== 批量操作(对选中多行)=====
+  const batchDelete = async () => {
+    try {
+      const { data } = await api.post<{ deleted: number }>('/admin/api/marquee-seeds/batch-delete', {
+        ids: selectedRowKeys,
+      });
+      message.success(`已删除 ${data.deleted} 条`);
+      setSelectedRowKeys([]);
+      load();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+  const batchSetEnabled = async (enabled: boolean) => {
+    try {
+      const { data } = await api.post<{ updated: number }>('/admin/api/marquee-seeds/batch-enable', {
+        ids: selectedRowKeys,
+        enabled,
+      });
+      message.success(`已${enabled ? '启用' : '停用'} ${data.updated} 条`);
+      setSelectedRowKeys([]);
+      load();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
  const columns = [
    {
      title: '用户名',
@@ -229,7 +259,7 @@ export default function HomeMarqueeSeeds() {
        首页「用户xxx 比价后节省xx元」轮播的兜底假数据。真实比价记录不足时随机抽取这些补齐;停用的不参与混播。
        用户名留空则每次展示随机合成;金额为区间则每次随机取值。
      </p>
-      <Space style={{ marginBottom: 12 }}>
+      <Space style={{ marginBottom: 12 }} wrap>
        <Button type="primary" size="small" onClick={openAdd}>
          新增种子
        </Button>
@@ -239,11 +269,34 @@ export default function HomeMarqueeSeeds() {
        <Button size="small" onClick={openPreview}>
          预览效果
        </Button>
+        <span style={{ borderLeft: '1px solid #eee', height: 18 }} />
+        <Button size="small" disabled={!selectedRowKeys.length} onClick={() => batchSetEnabled(true)}>
+          批量启用
+        </Button>
+        <Button size="small" disabled={!selectedRowKeys.length} onClick={() => batchSetEnabled(false)}>
+          批量停用
+        </Button>
+        <Popconfirm
+          title={`确认删除选中的 ${selectedRowKeys.length} 条种子?`}
+          onConfirm={batchDelete}
+          disabled={!selectedRowKeys.length}
+        >
+          <Button size="small" danger disabled={!selectedRowKeys.length}>
+            批量删除
+          </Button>
+        </Popconfirm>
+        {selectedRowKeys.length > 0 && (
+          <span style={{ color: '#999', fontSize: 12 }}>已选 {selectedRowKeys.length} 条</span>
+        )}
      </Space>
      <Table
        rowKey="id"
        size="small"
        loading={loading}
+        rowSelection={{
+          selectedRowKeys,
+          onChange: (keys) => setSelectedRowKeys(keys.map(Number)),
+        }}
        columns={columns}
        dataSource={seeds}
        pagination={false}
@@ -7,6 +7,7 @@ import {
  Checkbox,
  Col,
  InputNumber,
+  Modal,
  Popconfirm,
  Radio,
  Row,
@@ -18,6 +19,7 @@ import {
  message,
 } from 'antd';
 import { api, errMsg } from '@/lib/api';
+import { formatUtcTime } from '@/lib/format';

 interface StatItem {
  metric: string; // help_users / total_compares / total_saved
@@ -32,7 +34,7 @@ interface StatItem {
  random_kind: 'mult' | 'add'; // 自增长方式:×倍率 / +绝对增量
  random_step_min: number; // 绝对增量区间(基础单位)
  random_step_max: number;
-  real_offset: number; // 真实值基数偏移(基础单位)
+  real_offset: number; // 真实值保底值(基础单位):展示=max(真实,保底)。沿用 real_offset 列名(语义已改)
  allow_decrease: boolean; // 是否允许展示值下降
  random_current: number | null;
  random_last_tick_at: string | null;
@@ -54,7 +56,7 @@ function decomposeInterval(sec: number): { num: number; unit: IntervalUnit } {
 interface Edit {
  mode: 'real' | 'manual' | 'random';
  manual: number | null; // 展示单位
-  realOffset: number; // 真实值偏移(展示单位)
+  realOffset: number; // 真实值保底值(展示单位)
  growthKind: 'mult' | 'add'; // 自增长方式
  multMin: number; // 1.0 ~
  multMax: number;
@@ -127,7 +129,7 @@ function predictNext(it: StatItem): string | null {
    const hi = Math.floor((cur * it.random_mult_max) / 1000);
    return `${d(lo)} ~ ${d(hi)} ${u}`;
  }
-  const target = it.mode === 'real' ? it.real_value + it.real_offset : it.manual_value ?? cur;
+  const target = it.mode === 'real' ? Math.max(it.real_value, it.real_offset) : it.manual_value ?? cur;
  const eff = !it.allow_decrease && target < cur ? cur : target;
  return `${it.mode === 'real' ? '≈ ' : ''}${d(eff)} ${u}`;
 }
@@ -150,6 +152,101 @@ function nextRefreshLabel(tickSeconds: number, anchorMinutes: number): string {
  });
 }

+// ===== 三者关系「智能校验」(劝阻式,非硬拦)=====
+// 触发阈值比「理想区间」宽,只在明显离谱时弹窗;理想区间在弹窗里作为建议展示。
+const REL_PER_USER = { min: 2, max: 20, ideal: '4~8 次/人' }; // 人均比价 = 完成比价 / 帮助用户
+const REL_PER_COMPARE = { min: 2, max: 30, ideal: '5~12 元/次' }; // 每次省额 = 累计节省(元) / 完成比价
+
+function fmtNum(n: number): string {
+  return n >= 10000 ? `${(n / 10000).toFixed(2).replace(/\.?0+$/, '')}万` : String(Math.round(n));
+}
+
+// 只增不减护栏的前端镜像:目标低于现值且未允许下降时,实际仍显示现值。
+function guardedBase(allowDecrease: boolean, current: number | null, target: number | null): number | null {
+  if (target == null) return current;
+  if (!allowDecrease && current != null && target < current) return current;
+  return target;
+}
+
+// 本次保存后,该指标「大概会显示」的值(基础单位:total_saved 为分)。
+function intendedBase(it: StatItem, e: Edit): number | null {
+  const cur = it.random_current;
+  if (e.mode === 'manual') {
+    const t = e.manual != null ? (dispToBase(it.metric, e.manual) as number) : cur;
+    return guardedBase(e.allowDecrease, cur, t);
+  }
+  if (e.mode === 'real') {
+    const t = Math.max(it.real_value, (dispToBase(it.metric, e.realOffset) as number) ?? 0);
+    return guardedBase(e.allowDecrease, cur, t);
+  }
+  // random:填了初始基数=设起点(过护栏);留空=保持现展示值
+  if (e.initial != null) return guardedBase(e.allowDecrease, cur, dispToBase(it.metric, e.initial) as number);
+  return cur;
+}
+
+// 校验三者关系。返回 null=数据不全无法判断(跳过校验);否则 warnings 为空=合理。
+// 被改的指标用「本次要设的目标值」,另两个用各自当前展示值 random_current。
+function checkRelations(
+  items: StatItem[],
+  edits: Record<string, Edit>,
+): { warnings: string[]; users: number; compares: number; savedYuan: number } | null {
+  const valBase = (metric: string): number | null => {
+    const it = items.find((x) => x.metric === metric);
+    const e = it ? edits[metric] : undefined;
+    return it && e ? intendedBase(it, e) : null;
+  };
+  const users = valBase('help_users');
+  const compares = valBase('total_compares');
+  const savedBase = valBase('total_saved');
+  if (users == null || compares == null || savedBase == null) return null;
+  if (users <= 0 || compares <= 0 || savedBase <= 0) return null;
+
+  const savedYuan = savedBase / 100;
+  const warnings: string[] = [];
+  if (compares < users) {
+    warnings.push(`完成比价(${fmtNum(compares)})少于帮助用户(${fmtNum(users)}),正常应「次数 ≥ 人数」`);
+  }
+  const perUser = compares / users;
+  if (perUser < REL_PER_USER.min || perUser > REL_PER_USER.max) {
+    warnings.push(
+      `人均比价 ${perUser.toFixed(1)} 次/人,${perUser < REL_PER_USER.min ? '偏低' : '偏高'}(建议 ${REL_PER_USER.ideal})`,
+    );
+  }
+  const perCompare = savedYuan / compares;
+  if (perCompare < REL_PER_COMPARE.min || perCompare > REL_PER_COMPARE.max) {
+    warnings.push(
+      `每次省 ${perCompare.toFixed(1)} 元/次,${perCompare < REL_PER_COMPARE.min ? '偏低' : '偏高'}(建议 ${REL_PER_COMPARE.ideal})`,
+    );
+  }
+  return { warnings, users, compares, savedYuan };
+}
+
+// 把某指标的编辑态打包成 PATCH body(三项共用,逐个指标各打一份)。
+function buildBody(metric: string, e: Edit, immediate: boolean): Record<string, number | string | boolean> {
+  // 自定义不暴露间隔,固定为每天(每日「更新时间」刷新一次);其余模式用所选间隔。
+  const intervalSec =
+    e.mode === 'manual'
+      ? 86400
+      : Math.max(60, Math.round(e.intervalNum) * UNIT_SECONDS[e.intervalUnit]);
+  const anchorMin = e.anchorHour * 60 + e.anchorMinute; // 更新时间(全天 HH:MM),后端按间隔取相位
+  const body: Record<string, number | string | boolean> = {
+    mode: e.mode,
+    random_mult_min: Math.round(e.multMin * 1000),
+    random_mult_max: Math.round(e.multMax * 1000),
+    random_tick_seconds: intervalSec,
+    random_anchor_minutes: anchorMin,
+    random_kind: e.growthKind,
+    random_step_min: (dispToBase(metric, e.stepMin) as number) ?? 0,
+    random_step_max: (dispToBase(metric, e.stepMax) as number) ?? 0,
+    real_offset: (dispToBase(metric, e.realOffset) as number) ?? 0,
+    allow_decrease: e.allowDecrease,
+  };
+  if (e.manual != null) body.manual_value = dispToBase(metric, e.manual) as number;
+  if (e.initial != null) body.random_initial = dispToBase(metric, e.initial) as number;
+  if (immediate) body.apply_now = true;
+  return body;
+}
+
 /** 首页三门面数字(帮助用户/完成比价/累计节省)的展示模式配置。作为「数据大盘」页的一个区块。 */
 export default function HomeStatsConfig() {
  const [items, setItems] = useState<StatItem[]>([]);
@@ -188,52 +285,67 @@ export default function HomeStatsConfig() {
  const patch = (metric: string, p: Partial<Edit>) =>
    setEdits((s) => ({ ...s, [metric]: { ...s[metric], ...p } }));

-  // immediate=true:点「立即更新」,保存配置 + 马上刷新展示值(不等更新钟点)。
-  const save = async (it: StatItem, immediate = false) => {
-    const e = edits[it.metric];
-    // 自定义不暴露间隔,固定为每天(每日「更新时间」刷新一次);其余模式用所选间隔。
-    const intervalSec =
-      e.mode === 'manual'
-        ? 86400
-        : Math.max(60, Math.round(e.intervalNum) * UNIT_SECONDS[e.intervalUnit]);
-    const anchorMin = e.anchorHour * 60 + e.anchorMinute; // 更新时间(全天 HH:MM),后端按间隔取相位
-    const body: Record<string, number | string | boolean> = {
-      mode: e.mode,
-      random_mult_min: Math.round(e.multMin * 1000),
-      random_mult_max: Math.round(e.multMax * 1000),
-      random_tick_seconds: intervalSec,
-      random_anchor_minutes: anchorMin,
-      random_kind: e.growthKind,
-      random_step_min: (dispToBase(it.metric, e.stepMin) as number) ?? 0,
-      random_step_max: (dispToBase(it.metric, e.stepMax) as number) ?? 0,
-      real_offset: (dispToBase(it.metric, e.realOffset) as number) ?? 0,
-      allow_decrease: e.allowDecrease,
-    };
-    if (e.manual != null) body.manual_value = dispToBase(it.metric, e.manual) as number;
-    if (e.initial != null) body.random_initial = dispToBase(it.metric, e.initial) as number;
-    if (immediate) body.apply_now = true;
-
-    setSaving(it.metric);
-    try {
-      // PATCH 返回更新后的该指标;只就地替换这一项 + 重置它的输入态,不整页 reload(消除闪烁)。
-      const { data } = await api.patch<StatItem>(`/admin/api/dashboard-display/${it.metric}`, body);
-      setItems((prev) => prev.map((x) => (x.metric === it.metric ? data : x)));
-      setEdits((s) => ({ ...s, [it.metric]: toEdit(data) }));
-      if (immediate) {
-        message.success('已立即更新,客户端下次进首页即可见');
-      } else {
-        const lastTickMs = data.random_last_tick_at ? new Date(data.random_last_tick_at).getTime() : 0;
-        const effectiveNow = Date.now() - lastTickMs < 10_000;
+  // 三项共享:一次保存 / 立即更新全部三个指标(各打一份 PATCH)。
+  // 校验三者最终关系,不合理则弹窗劝阻、确认才提交。
+  const saveAll = async (immediate = false) => {
+    const proceed = async () => {
+      setSaving('__all__');
+      // 逐个 PATCH(顺序提交,各自 commit 一行)。results 在 try 外声明,半失败时也能把已成功的合并进 state。
+      const results: StatItem[] = [];
+      try {
+        for (const it of items) {
+          const { data } = await api.patch<StatItem>(
+            `/admin/api/dashboard-display/${it.metric}`,
+            buildBody(it.metric, edits[it.metric], immediate),
+          );
+          results.push(data);
+        }
        message.success(
-          effectiveNow
-            ? '已保存,客户端下次进首页即可见'
-            : `已保存,展示值将于北京时间 ${nextRefreshLabel(data.random_tick_seconds, data.random_anchor_minutes)} 刷新后生效`,
+          immediate
+            ? '三项已立即更新,客户端下次进首页即可见'
+            : '三项配置已保存,展示值将按各自「更新时间」刷新后生效(自定义/立即更新即时生效)',
        );
+      } catch (err) {
+        // 前 results.length 项后端已 commit,失败的是第 results.length+1 项
+        message.error(`第 ${results.length + 1} 项保存失败(前 ${results.length} 项已成功): ${errMsg(err)}`);
+      } finally {
+        // 半失败也把已成功的就地合并进 state,避免前端显旧值与后端撕裂
+        if (results.length > 0) {
+          setItems((prev) => prev.map((x) => results.find((r) => r.metric === x.metric) ?? x));
+          setEdits((s) => ({ ...s, ...Object.fromEntries(results.map((d) => [d.metric, toEdit(d)])) }));
+        }
+        setSaving(null);
      }
-    } catch (err) {
-      message.error(errMsg(err));
-    } finally {
-      setSaving(null);
+    };
+
+    // 智能校验:按下后三者大概会呈现的关系是否合理,不合理则弹窗劝阻、确认才提交。
+    const rel = checkRelations(items, edits);
+    if (rel && rel.warnings.length > 0) {
+      Modal.confirm({
+        title: '数据关系校验',
+        width: 480,
+        okText: '仍要这样设置',
+        cancelText: '返回修改',
+        content: (
+          <div style={{ fontSize: 13 }}>
+            <div style={{ marginBottom: 8 }}>检测到三项门面数据关系不太真实:</div>
+            <ul style={{ paddingLeft: 18, margin: '0 0 8px' }}>
+              {rel.warnings.map((w, i) => (
+                <li key={i} style={{ color: '#d4380d', marginBottom: 2 }}>
+                  {w}
+                </li>
+              ))}
+            </ul>
+            <div style={{ color: '#888' }}>
+              当前预计:帮助用户 {fmtNum(rel.users)} · 完成比价 {fmtNum(rel.compares)} · 累计节省{' '}
+              {fmtNum(rel.savedYuan)}元
+            </div>
+          </div>
+        ),
+        onOk: proceed,
+      });
+    } else {
+      await proceed();
    }
  };

@@ -241,7 +353,7 @@ export default function HomeStatsConfig() {
    <div style={{ marginTop: 24 }}>
      <h3 style={{ marginBottom: 4 }}>首页数据配置</h3>
      <p style={{ color: '#999', marginTop: 0 }}>
-        客户端首页三个门面数字。每个指标独立选模式:<b>真实值</b>(实时查库,可加基数偏移)/{' '}
+        客户端首页三个门面数字。每个指标独立选模式:<b>真实值</b>(实时查库,可设保底值)/{' '}
        <b>自定义</b>(固定值)/ <b>自增长</b>(到对齐钟点按倍率或固定增量增长)。
        默认<b>只增不减</b>(防门面缩水);每次改动进审计日志。
      </p>
@@ -260,6 +372,20 @@ export default function HomeStatsConfig() {
              e.manual != null &&
              it.random_current != null &&
              (dispToBase(it.metric, e.manual) as number) < it.random_current;
+            // real 同理:max(真实值,保底值) 低于当前展示值且未允许下降 → 立即更新会被只增不减护栏挡住
+            const realTargetBase = Math.max(it.real_value, (dispToBase(it.metric, e.realOffset) as number) ?? 0);
+            const realBlocked =
+              e.mode === 'real' &&
+              !e.allowDecrease &&
+              it.random_current != null &&
+              realTargetBase < it.random_current;
+            // 自增长:填的初始基数低于当前展示值且未允许下降 → 会被只增不减护栏挡住(保持现值)
+            const initialBlocked =
+              e.mode === 'random' &&
+              !e.allowDecrease &&
+              e.initial != null &&
+              it.random_current != null &&
+              (dispToBase(it.metric, e.initial) as number) < it.random_current;
            return (
              <Col key={it.metric} xs={24} md={12} xl={8}>
                <Card
@@ -307,19 +433,26 @@ export default function HomeStatsConfig() {
                    )}

                    {e.mode === 'real' && (
-                      <Space wrap>
-                        <span>基数偏移:</span>
-                        <InputNumber
-                          value={e.realOffset}
-                          min={0}
-                          onChange={(v) => patch(it.metric, { realOffset: v ?? 0 })}
-                          style={{ width: 160 }}
-                        />
-                        <span style={{ color: '#666' }}>{u}</span>
-                        <Tooltip title="展示值 = 真实值 + 此基数。冷启动期真实数字小,加个体面的基数,且仍随真实增长。">
-                          <span style={{ color: '#999', cursor: 'help' }}>ⓘ</span>
-                        </Tooltip>
-                      </Space>
+                      <div>
+                        <Space wrap>
+                          <span>保底值:</span>
+                          <InputNumber
+                            value={e.realOffset}
+                            min={0}
+                            onChange={(v) => patch(it.metric, { realOffset: v ?? 0 })}
+                            style={{ width: 160 }}
+                          />
+                          <span style={{ color: '#666' }}>{u}</span>
+                          <Tooltip title="展示值 = max(真实值, 保底值)。冷启动期真实数字小,显示保底撑场面;真实值涨过保底后显示纯真实、零差距。留 0 = 纯真实值。">
+                            <span style={{ color: '#999', cursor: 'help' }}>ⓘ</span>
+                          </Tooltip>
+                        </Space>
+                        {realBlocked && (
+                          <div style={{ color: '#fa8c16', fontSize: 12, marginTop: 4 }}>
+                            真实值与保底取大后仍低于当前展示值,默认不下调(如需下调请勾「允许数字下降」)
+                          </div>
+                        )}
+                      </div>
                    )}

                    {e.mode === 'random' && (
@@ -431,17 +564,26 @@ export default function HomeStatsConfig() {
                    </Space>

                    {e.mode === 'random' && (
-                      <Space wrap>
-                        <span>初始基数:</span>
-                        <InputNumber
-                          value={e.initial}
-                          min={0}
-                          onChange={(v) => patch(it.metric, { initial: v })}
-                          style={{ width: 200 }}
-                          placeholder="留空=用真实值播种"
-                        />
-                        <span style={{ color: '#666' }}>{u}</span>
-                      </Space>
+                      <div>
+                        <Space wrap>
+                          <span>初始基数:</span>
+                          <InputNumber
+                            value={e.initial}
+                            min={0}
+                            onChange={(v) => patch(it.metric, { initial: v })}
+                            style={{ width: 200 }}
+                          />
+                          <span style={{ color: '#666' }}>{u}</span>
+                          <Tooltip title="填值=把展示值设为该数作为增长起点(受『只增不减』限制:低于当前展示值需先勾「允许数字下降」)。留空=保持现有展示值不变、继续按增量增长;仅当该指标从未启用过(还没有展示值)时,留空才用真实值播种。">
+                            <span style={{ color: '#999', cursor: 'help' }}>ⓘ</span>
+                          </Tooltip>
+                        </Space>
+                        {initialBlocked && (
+                          <div style={{ color: '#fa8c16', fontSize: 12, marginTop: 4 }}>
+                            低于当前展示值,默认不下调(如需下调请勾「允许数字下降」)
+                          </div>
+                        )}
+                      </div>
                    )}

                    <Checkbox
@@ -460,7 +602,7 @@ export default function HomeStatsConfig() {
                        </span>
                        {it.updated_at && (
                          <span style={{ color: '#bbb' }}>
-                            更新于 {new Date(it.updated_at).toLocaleString('zh-CN')}
+                            更新于 {formatUtcTime(it.updated_at, 'YYYY-MM-DD HH:mm:ss')}
                          </span>
                        )}
                      </Space>
@@ -474,21 +616,10 @@ export default function HomeStatsConfig() {
                      )}
                    </Space>

-                    <Space>
-                      <Button type="primary" loading={saving === it.metric} onClick={() => save(it)}>
-                        保存
-                      </Button>
-                      <Popconfirm
-                        title="立即更新会马上推进一次(自增长走一档),不等更新时间。确定?"
-                        onConfirm={() => save(it, true)}
-                      >
-                        <Button loading={saving === it.metric}>立即更新</Button>
-                      </Popconfirm>
-                      <Tag color={it.mode === 'real' ? 'green' : it.mode === 'manual' ? 'orange' : 'blue'}>
-                        线上当前:
-                        {it.mode === 'real' ? '真实值' : it.mode === 'manual' ? '自定义' : '自增长'}
-                      </Tag>
-                    </Space>
+                    <Tag color={it.mode === 'real' ? 'green' : it.mode === 'manual' ? 'orange' : 'blue'}>
+                      线上当前:
+                      {it.mode === 'real' ? '真实值' : it.mode === 'manual' ? '自定义' : '自增长'}
+                    </Tag>
                  </Space>
                </Card>
              </Col>
@@ -496,6 +627,22 @@ export default function HomeStatsConfig() {
          })}
        </Row>
      )}
+      {!loading && (
+        <div style={{ marginTop: 16 }}>
+          <Space>
+            <Button type="primary" loading={saving != null} onClick={() => saveAll(false)}>
+              保存
+            </Button>
+            <Popconfirm
+              title="立即更新会马上把三项都推进一次(自增长各走一档),不等更新时间。确定?"
+              onConfirm={() => saveAll(true)}
+            >
+              <Button loading={saving != null}>立即更新</Button>
+            </Popconfirm>
+            <span style={{ color: '#999', fontSize: 12 }}>三项配置共用,一次保存全部生效</span>
+          </Space>
+        </div>
+      )}
    </div>
  );
 }
@@ -0,0 +1,101 @@
+'use client';
+
+import type { ColumnsType } from 'antd/es/table';
+import { Button, Modal, Popconfirm, Space, Table, message } from 'antd';
+import { api, errMsg } from '@/lib/api';
+import { canDo } from '@/lib/auth';
+import { formatUtcTime } from '@/lib/format';
+import { useCursorList } from '@/lib/useCursorList';
+import type { DeviceOnboardingItem } from '@/lib/types';
+
+// completed_at 为 UTC 口径(server_default now()),按北京显示(勿用 new Date().toLocaleString)
+const dt = (v: string) => formatUtcTime(v);
+const EMPTY: Record<string, unknown> = {};
+
+export default function DevicesPage() {
+  // 后端按设备聚合、全量返回(next_cursor 恒 null),故无筛选/加载更多。
+  const { items, loading, reload } = useCursorList<DeviceOnboardingItem>(
+    '/admin/api/onboarding/devices',
+    EMPTY,
+  );
+  const canReset = canDo(['operator']);
+
+  const resetDevice = async (d: DeviceOnboardingItem) => {
+    try {
+      await api.post(`/admin/api/onboarding/devices/${encodeURIComponent(d.device_id)}/reset`);
+      message.success('已重置:该设备所有账号下次打开 App 重走引导');
+      reload();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
+  const resetAll = () => {
+    Modal.confirm({
+      title: '确认全部重设新手引导?',
+      content:
+        '清空所有设备的引导完成记录,库里所有用户下次打开 App 都会重走一遍新手引导。此操作不可逆。',
+      okText: '确认全部重设',
+      okButtonProps: { danger: true },
+      cancelText: '取消',
+      onOk: async () => {
+        try {
+          await api.post('/admin/api/onboarding/reset-all', { confirm: true });
+          message.success('已全部重设:所有用户下次打开 App 会重走引导');
+          reload();
+        } catch (e) {
+          message.error(errMsg(e));
+        }
+      },
+    });
+  };
+
+  const columns: ColumnsType<DeviceOnboardingItem> = [
+    { title: '设备(ANDROID_ID)', dataIndex: 'device_id' },
+    { title: '走过引导的账号数', dataIndex: 'account_count', width: 160 },
+    { title: '最近完成引导', dataIndex: 'last_completed_at', render: dt, width: 200 },
+    {
+      title: '操作',
+      key: 'op',
+      width: 120,
+      render: (_: unknown, d: DeviceOnboardingItem) =>
+        canReset ? (
+          <Popconfirm
+            title="重走引导?"
+            description="该设备上所有账号下次打开 App 会重看一次。"
+            onConfirm={() => resetDevice(d)}
+            okText="确认"
+            cancelText="取消"
+          >
+            <a>重走引导</a>
+          </Popconfirm>
+        ) : (
+          <span style={{ color: '#ccc' }}>-</span>
+        ),
+    },
+  ];
+
+  return (
+    <div>
+      <h2>设备管理</h2>
+      <p style={{ color: '#888', marginBottom: 16 }}>
+        列出走过新手引导的设备(按硬件 ANDROID_ID 聚合)。「重走引导」删除该设备的引导完成记录,
+        使其上所有账号下次打开 App 重走一遍。没走过引导的设备本就会引导,不在此列。
+      </p>
+      {canReset && (
+        <Space style={{ marginBottom: 16 }}>
+          <Button type="primary" danger onClick={resetAll}>
+            全部重设新手引导
+          </Button>
+        </Space>
+      )}
+      <Table
+        rowKey="device_id"
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={false}
+      />
+    </div>
+  );
+}
@@ -1,23 +1,98 @@
 'use client';

-import { useState } from 'react';
+import { useEffect, useState } from 'react';
+import type { Key } from 'react';
 import type { ColumnsType } from 'antd/es/table';
-import { Button, Select, Space, Table, Tag, message } from 'antd';
+import type { SorterResult } from 'antd/es/table/interface';
+import {
+  Button,
+  DatePicker,
+  Image,
+  Input,
+  Modal,
+  Select,
+  Space,
+  Table,
+  Tag,
+  Typography,
+  message,
+} from 'antd';
+import type { Dayjs } from 'dayjs';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
-import { useCursorList } from '@/lib/useCursorList';
+import { formatUtcTime } from '@/lib/format';
+import { usePagedList } from '@/lib/usePagedList';
 import type { Feedback } from '@/lib/types';

-const dt = (v: string) => new Date(v).toLocaleString('zh-CN');
+const { Text, Paragraph } = Typography;
+const { RangePicker } = DatePicker;
+
+// 截图是 app-server 的 /media 相对路径,本地由 :8770 提供(NEXT_PUBLIC_MEDIA_BASE);生产同域走 nginx 代理。
+const MEDIA_BASE = process.env.NEXT_PUBLIC_MEDIA_BASE || '';
+const mediaUrl = (p: string) => (p.startsWith('http') ? p : MEDIA_BASE + p);
+
+type SortField = 'id' | 'created_at';

 export default function FeedbacksPage() {
+  // 筛选草稿:点「查询」才应用(避免输入即刷新)
  const [status, setStatus] = useState<string | undefined>();
-  const [filters, setFilters] = useState<Record<string, unknown>>({});
-  const { items, nextCursor, loading, loadMore, reload } = useCursorList<Feedback>(
-    '/admin/api/feedbacks',
-    filters,
-  );
+  const [userId, setUserId] = useState('');
+  const [content, setContent] = useState('');
+  const [createdRange, setCreatedRange] = useState<[Dayjs, Dayjs] | null>(null);
+  const [applied, setApplied] = useState<Record<string, unknown>>({});
+  // 排序(服务端):点列头即时生效,与「查询」按钮分开
+  const [sortBy, setSortBy] = useState<SortField>('id');
+  const [sortOrder, setSortOrder] = useState<'asc' | 'desc'>('desc');
+
+  const filters: Record<string, unknown> = { ...applied, sort_by: sortBy, sort_order: sortOrder };
+  const filterKey = JSON.stringify(filters);
+  const { items, total, page, pageSize, loading, onChange: onPageChange, reload } =
+    usePagedList<Feedback>('/admin/api/feedbacks', filters);
+
  const canHandle = canDo(['operator']);
+  const [selectedRowKeys, setSelectedRowKeys] = useState<Key[]>([]);
+
+  // 筛选/排序变化后清空已选(避免选中项跨筛选错位)
+  useEffect(() => {
+    setSelectedRowKeys([]);
+  }, [filterKey]);
+
+  const search = () =>
+    setApplied({
+      status,
+      user_id: userId.trim() ? Number(userId.trim()) : undefined,
+      content: content.trim() || undefined,
+      created_from: createdRange?.[0] ? createdRange[0].startOf('day').toISOString() : undefined,
+      created_to: createdRange?.[1] ? createdRange[1].endOf('day').toISOString() : undefined,
+    });
+
+  const resetFilters = () => {
+    setStatus(undefined);
+    setUserId('');
+    setContent('');
+    setCreatedRange(null);
+    setSortBy('id');
+    setSortOrder('desc');
+    setApplied({});
+  };
+
+  const onTableChange = (
+    _pagination: unknown,
+    _filters: unknown,
+    sorter: SorterResult<Feedback> | SorterResult<Feedback>[],
+  ) => {
+    const s = Array.isArray(sorter) ? sorter[0] : sorter;
+    if (s && s.order && s.field) {
+      setSortBy(s.field as SortField);
+      setSortOrder(s.order === 'ascend' ? 'asc' : 'desc');
+    } else {
+      setSortBy('id');
+      setSortOrder('desc');
+    }
+  };
+
+  const sortOrderOf = (field: SortField) =>
+    sortBy === field ? (sortOrder === 'asc' ? 'ascend' : 'descend') : null;

  const handle = async (f: Feedback) => {
    try {
@@ -29,18 +104,90 @@ export default function FeedbacksPage() {
    }
  };

+  const selectedNew = items.filter(
+    (f) => selectedRowKeys.includes(f.id) && f.status === 'new',
+  );
+
+  // 批量:循环调现有逐条 /handle 接口(各自已带审计),Promise.allSettled 汇总成败,不新增 bulk 端点
+  const bulkHandle = () => {
+    if (!selectedNew.length) {
+      message.warning('没有可处理的选中项(仅待处理 new 态生效)');
+      return;
+    }
+    Modal.confirm({
+      title: `确认批量标记处理 ${selectedNew.length} 条反馈?`,
+      content: '仅对选中的待处理(new)反馈生效',
+      onOk: async () => {
+        const results = await Promise.allSettled(
+          selectedNew.map((f) => api.post(`/admin/api/feedbacks/${f.id}/handle`)),
+        );
+        const ok = results.filter((r) => r.status === 'fulfilled').length;
+        const fail = results.length - ok;
+        if (fail) message.warning(`批量标记处理完成:成功 ${ok}/${results.length},失败 ${fail}`);
+        else message.success(`批量标记处理完成:${ok} 条`);
+        setSelectedRowKeys([]);
+        reload();
+      },
+    });
+  };
+
  const columns: ColumnsType<Feedback> = [
-    { title: 'ID', dataIndex: 'id', width: 70 },
+    { title: 'ID', dataIndex: 'id', width: 70, sorter: true, sortOrder: sortOrderOf('id') },
    { title: '用户', dataIndex: 'user_id', width: 80 },
-    { title: '内容', dataIndex: 'content' },
-    { title: '联系方式', dataIndex: 'contact', width: 140 },
+    {
+      title: '内容',
+      dataIndex: 'content',
+      width: 360,
+      render: (v: string) =>
+        v ? (
+          <Paragraph
+            style={{ marginBottom: 0, whiteSpace: 'pre-wrap', wordBreak: 'break-word' }}
+            ellipsis={{ rows: 3, expandable: true, symbol: '展开', tooltip: true }}
+          >
+            {v}
+          </Paragraph>
+        ) : (
+          <Text type="secondary">-</Text>
+        ),
+    },
+    {
+      title: '截图',
+      dataIndex: 'images',
+      width: 180,
+      render: (imgs: string[] | null) =>
+        imgs && imgs.length ? (
+          <Image.PreviewGroup>
+            <Space size={4} wrap>
+              {imgs.map((src, i) => (
+                <Image
+                  key={i}
+                  src={mediaUrl(src)}
+                  width={44}
+                  height={44}
+                  style={{ objectFit: 'cover', borderRadius: 4 }}
+                />
+              ))}
+            </Space>
+          </Image.PreviewGroup>
+        ) : (
+          <Text type="secondary">无</Text>
+        ),
+    },
+    { title: '联系方式', dataIndex: 'contact', width: 140, render: (v: string) => v || '-' },
    {
      title: '状态',
      dataIndex: 'status',
      width: 90,
      render: (s: string) => <Tag color={s === 'new' ? 'orange' : 'green'}>{s}</Tag>,
    },
-    { title: '时间', dataIndex: 'created_at', render: dt, width: 180 },
+    {
+      title: '时间',
+      dataIndex: 'created_at',
+      width: 180,
+      sorter: true,
+      sortOrder: sortOrderOf('created_at'),
+      render: (v: string) => formatUtcTime(v),
+    },
    {
      title: '操作',
      key: 'op',
@@ -57,28 +204,82 @@ export default function FeedbacksPage() {
  return (
    <div>
      <h2>反馈工单</h2>
-      <Space style={{ marginBottom: 16 }}>
+      <Space style={{ marginBottom: 16 }} wrap>
        <Select
          placeholder="状态"
          value={status}
-          onChange={(v) => {
-            setStatus(v);
-            setFilters({ status: v });
-          }}
+          onChange={setStatus}
          allowClear
-          style={{ width: 140 }}
+          style={{ width: 120 }}
          options={[
            { value: 'new', label: '待处理' },
            { value: 'handled', label: '已处理' },
          ]}
        />
-      </Space>
-      <Table rowKey="id" columns={columns} dataSource={items} loading={loading} pagination={false} />
-      <div style={{ marginTop: 16, textAlign: 'center' }}>
-        <Button onClick={loadMore} disabled={!nextCursor} loading={loading}>
-          {nextCursor ? '加载更多' : '没有更多了'}
+        <Input
+          placeholder="用户ID"
+          value={userId}
+          onChange={(e) => setUserId(e.target.value.replace(/\D/g, ''))}
+          onPressEnter={search}
+          allowClear
+          style={{ width: 120 }}
+        />
+        <Input
+          placeholder="内容(模糊)"
+          value={content}
+          onChange={(e) => setContent(e.target.value)}
+          onPressEnter={search}
+          allowClear
+          style={{ width: 180 }}
+        />
+        <RangePicker
+          placeholder={['提交起', '提交止']}
+          value={createdRange}
+          onChange={(v) => setCreatedRange(v as [Dayjs, Dayjs] | null)}
+          allowClear
+        />
+        <Button type="primary" onClick={search}>
+          查询
        </Button>
-      </div>
+        <Button onClick={resetFilters}>重置</Button>
+      </Space>
+
+      {canHandle && selectedNew.length > 0 && (
+        <Space style={{ marginBottom: 12, width: '100%' }} wrap>
+          <span style={{ color: '#888' }}>已选 {selectedNew.length} 条待处理</span>
+          <Button type="primary" onClick={bulkHandle}>
+            批量标记处理
+          </Button>
+          <Button type="link" onClick={() => setSelectedRowKeys([])}>
+            清空选择
+          </Button>
+        </Space>
+      )}
+
+      <Table
+        rowKey="id"
+        rowSelection={
+          canHandle
+            ? {
+                selectedRowKeys,
+                onChange: setSelectedRowKeys,
+                getCheckboxProps: (f) => ({ disabled: f.status !== 'new' }),
+              }
+            : undefined
+        }
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 条反馈`,
+          onChange: onPageChange,
+        }}
+        onChange={onTableChange}
+      />
    </div>
  );
 }
@@ -3,14 +3,16 @@
 import { useEffect, useState } from 'react';
 import { usePathname, useRouter } from 'next/navigation';
 import {
+  BarChartOutlined,
  DashboardOutlined,
  FileSearchOutlined,
  FlagOutlined,
-  FundProjectionScreenOutlined,
  LogoutOutlined,
  MessageOutlined,
+  MobileOutlined,
  MoneyCollectOutlined,
  SettingOutlined,
+  ShareAltOutlined,
  TeamOutlined,
  UserOutlined,
 } from '@ant-design/icons';
@@ -23,10 +25,12 @@ const { Sider, Header, Content } = Layout;
 const MENU = [
  { key: '/dashboard', icon: <DashboardOutlined />, label: '数据大盘' },
  { key: '/users', icon: <UserOutlined />, label: '用户管理' },
+  { key: '/devices', icon: <MobileOutlined />, label: '设备管理' },
  { key: '/withdraws', icon: <MoneyCollectOutlined />, label: '提现管理' },
  { key: '/price-reports', icon: <FlagOutlined />, label: '上报审核' },
  { key: '/feedbacks', icon: <MessageOutlined />, label: '反馈工单' },
-  { key: '/ad-audit', icon: <FundProjectionScreenOutlined />, label: '金币审计' },
+  { key: '/ad-revenue', icon: <BarChartOutlined />, label: '广告数据' },
+  { key: '/cps', icon: <ShareAltOutlined />, label: 'CPS 分发' },
  { key: '/config', icon: <SettingOutlined />, label: '系统配置' },
  { key: '/admins', icon: <TeamOutlined />, label: '管理员', superOnly: true },
  { key: '/audit-logs', icon: <FileSearchOutlined />, label: '审计日志' },
@@ -20,7 +20,7 @@ import { CheckCircleOutlined, CloseCircleOutlined } from '@ant-design/icons';
 import dayjs from 'dayjs';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
-import { useCursorList } from '@/lib/useCursorList';
+import { usePagedList } from '@/lib/usePagedList';
 import type { PriceReport, PriceReportSummary } from '@/lib/types';

 const { Text } = Typography;
@@ -65,10 +65,8 @@ export default function PriceReportsPage() {
  const filters: Record<string, unknown> = {};
  if (activeStatus !== 'all') filters.status = activeStatus;

-  const { items, nextCursor, loading, loadMore, reload } = useCursorList<PriceReport>(
-    '/admin/api/price-reports',
-    filters,
-  );
+  const { items, total, page, pageSize, loading, onChange: onPageChange, reload } =
+    usePagedList<PriceReport>('/admin/api/price-reports', filters);

  const canReview = canDo(['operator']);

@@ -277,14 +275,16 @@ export default function PriceReportsPage() {
          columns={columns}
          dataSource={items}
          loading={loading}
-          pagination={false}
+          pagination={{
+            current: page,
+            pageSize,
+            total,
+            showSizeChanger: true,
+            showTotal: (t) => `共 ${t} 条`,
+            onChange: onPageChange,
+          }}
          scroll={{ x: 1100 }}
        />
-        <div style={{ marginTop: 16, textAlign: 'center' }}>
-          <Button onClick={loadMore} disabled={!nextCursor} loading={loading}>
-            {nextCursor ? '加载更多' : '没有更多了'}
-          </Button>
-        </div>
      </Card>

      <Modal
@@ -1,32 +1,94 @@
 'use client';

-import { useEffect, useState } from 'react';
+import { useCallback, useEffect, useState } from 'react';
 import { useParams } from 'next/navigation';
 import type { ColumnsType } from 'antd/es/table';
-import { Card, Col, Descriptions, Row, Spin, Statistic, Table, Tabs, Tag } from 'antd';
-import { api } from '@/lib/api';
+import {
+  Button,
+  Card,
+  Col,
+  Descriptions,
+  Modal,
+  Result,
+  Row,
+  Space,
+  Spin,
+  Statistic,
+  Table,
+  Tabs,
+  Tag,
+  message,
+} from 'antd';
+import { api, errMsg } from '@/lib/api';
+import { canDo } from '@/lib/auth';
+import { formatUtcTime, formatWallTime, yuan } from '@/lib/format';
 import { useCursorList } from '@/lib/useCursorList';
-import type { CoinTxn, UserOverview, WithdrawOrder } from '@/lib/types';
-
-const yuan = (c: number) => `¥${(c / 100).toFixed(2)}`;
-const dt = (v: string) => new Date(v).toLocaleString('zh-CN');
+import { AdjustCashModal, AdjustCoinModal } from '@/components/AdjustBalanceModals';
+import type { CashTxn, CoinTxn, UserOverview, WithdrawOrder } from '@/lib/types';

 export default function UserDetailPage() {
  const params = useParams<{ id: string }>();
  const uid = Number(params.id);
  const [data, setData] = useState<UserOverview | null>(null);
+  const [err, setErr] = useState<string | null>(null);
+  const [coinOpen, setCoinOpen] = useState(false);
+  const [cashOpen, setCashOpen] = useState(false);

-  useEffect(() => {
-    api.get<UserOverview>(`/admin/api/users/${uid}`).then((r) => setData(r.data));
+  const loadData = useCallback(() => {
+    setErr(null);
+    api
+      .get<UserOverview>(`/admin/api/users/${uid}`)
+      .then((r) => setData(r.data))
+      .catch((e) => setErr(errMsg(e, '加载用户详情失败')));
  }, [uid]);

+  useEffect(() => {
+    loadData();
+  }, [loadData]);
+
  const coins = useCursorList<CoinTxn>('/admin/api/wallet/coin-transactions', { user_id: uid });
+  const cash = useCursorList<CashTxn>('/admin/api/wallet/cash-transactions', { user_id: uid });
  const withdraws = useCursorList<WithdrawOrder>('/admin/api/withdraws', { user_id: uid });

+  const canCoins = canDo(['finance']);
+  const canStatus = canDo(['operator']);
+
+  const toggleStatus = () => {
+    if (!data) return;
+    const next = data.user.status === 'active' ? 'disabled' : 'active';
+    Modal.confirm({
+      title: `确认${next === 'disabled' ? '封禁' : '解封'}用户 ${data.user.phone}?`,
+      onOk: async () => {
+        try {
+          await api.post(`/admin/api/users/${uid}/status`, { status: next });
+          message.success('已更新状态');
+          loadData();
+        } catch (e) {
+          message.error(errMsg(e));
+        }
+      },
+    });
+  };
+
+  if (err) {
+    return (
+      <Result
+        status="error"
+        title="加载失败"
+        subTitle={err}
+        extra={
+          <Button type="primary" onClick={loadData}>
+            重试
+          </Button>
+        }
+      />
+    );
+  }
  if (!data) return <Spin style={{ display: 'block', marginTop: 80 }} />;

  const coinCols: ColumnsType<CoinTxn> = [
-    { title: '时间', dataIndex: 'created_at', render: dt },
+    // 金币流水为北京 wall-clock 口径,原样显示
+    { title: '时间', dataIndex: 'created_at', render: (v: string) => formatWallTime(v) },
    {
      title: '变动',
      dataIndex: 'amount',
@@ -42,17 +104,58 @@ export default function UserDetailPage() {
    { title: '备注', dataIndex: 'remark', render: (v: string | null) => v || '-' },
  ];

+  const cashCols: ColumnsType<CashTxn> = [
+    // 现金流水为北京 wall-clock 口径,原样显示
+    { title: '时间', dataIndex: 'created_at', render: (v: string) => formatWallTime(v) },
+    {
+      title: '变动',
+      dataIndex: 'amount_cents',
+      render: (v: number) => (
+        <span style={{ color: v > 0 ? '#3f8600' : '#cf1322' }}>
+          {v > 0 ? '+' : ''}
+          {yuan(v)}
+        </span>
+      ),
+    },
+    { title: '余额', dataIndex: 'balance_after_cents', render: yuan },
+    { title: '类型', dataIndex: 'biz_type' },
+    { title: '备注', dataIndex: 'remark', render: (v: string | null) => v || '-' },
+  ];
+
  const wdCols: ColumnsType<WithdrawOrder> = [
-    { title: '时间', dataIndex: 'created_at', render: dt },
+    // 提现单为 UTC 口径
+    { title: '时间', dataIndex: 'created_at', render: (v: string) => formatUtcTime(v) },
    { title: '金额', dataIndex: 'amount_cents', render: yuan },
    { title: '状态', dataIndex: 'status', render: (s: string) => <Tag>{s}</Tag> },
    { title: '单号', dataIndex: 'out_bill_no' },
    { title: '失败原因', dataIndex: 'fail_reason', render: (v: string | null) => v || '-' },
  ];

+  const loadMoreLink = (list: { loadMore: () => void; nextCursor: number | null }) => (
+    <div style={{ marginTop: 12, textAlign: 'center' }}>
+      <a
+        onClick={list.loadMore}
+        style={{ pointerEvents: list.nextCursor ? 'auto' : 'none', opacity: list.nextCursor ? 1 : 0.4 }}
+      >
+        加载更多
+      </a>
+    </div>
+  );
+
  return (
    <div>
-      <h2>用户详情 #{uid}</h2>
+      <Space style={{ width: '100%', justifyContent: 'space-between', marginBottom: 16 }} wrap>
+        <h2 style={{ margin: 0 }}>用户详情 #{uid}</h2>
+        <Space wrap>
+          {canCoins && <Button onClick={() => setCoinOpen(true)}>调金币</Button>}
+          {canCoins && <Button onClick={() => setCashOpen(true)}>调现金</Button>}
+          {canStatus && data.user.status !== 'deleted' && (
+            <Button danger={data.user.status === 'active'} onClick={toggleStatus}>
+              {data.user.status === 'active' ? '封禁' : '解封'}
+            </Button>
+          )}
+        </Space>
+      </Space>
      <Card style={{ marginBottom: 16 }}>
        <Descriptions column={3}>
          <Descriptions.Item label="手机号">{data.user.phone}</Descriptions.Item>
@@ -64,7 +167,7 @@ export default function UserDetailPage() {
          <Descriptions.Item label="微信绑定">
            {data.user.wechat_openid ? '已绑定' : '未绑定'}
          </Descriptions.Item>
-          <Descriptions.Item label="注册时间">{dt(data.user.created_at)}</Descriptions.Item>
+          <Descriptions.Item label="注册时间">{formatUtcTime(data.user.created_at)}</Descriptions.Item>
        </Descriptions>
      </Card>

@@ -115,11 +218,23 @@ export default function UserDetailPage() {
                  loading={coins.loading}
                  pagination={false}
                />
-                <div style={{ marginTop: 12, textAlign: 'center' }}>
-                  <a onClick={coins.loadMore} style={{ pointerEvents: coins.nextCursor ? 'auto' : 'none', opacity: coins.nextCursor ? 1 : 0.4 }}>
-                    加载更多
-                  </a>
-                </div>
+                {loadMoreLink(coins)}
+              </>
+            ),
+          },
+          {
+            key: 'cash',
+            label: '现金流水',
+            children: (
+              <>
+                <Table
+                  rowKey="id"
+                  columns={cashCols}
+                  dataSource={cash.items}
+                  loading={cash.loading}
+                  pagination={false}
+                />
+                {loadMoreLink(cash)}
              </>
            ),
          },
@@ -138,6 +253,25 @@ export default function UserDetailPage() {
          },
        ]}
      />
+
+      <AdjustCoinModal
+        user={data.user}
+        open={coinOpen}
+        onClose={() => setCoinOpen(false)}
+        onDone={() => {
+          loadData();
+          coins.reload();
+        }}
+      />
+      <AdjustCashModal
+        user={data.user}
+        open={cashOpen}
+        onClose={() => setCashOpen(false)}
+        onDone={() => {
+          loadData();
+          cash.reload();
+        }}
+      />
    </div>
  );
 }
@@ -1,57 +1,100 @@
 'use client';

-import { useState } from 'react';
+import { useEffect, useState } from 'react';
+import type { Key } from 'react';
 import { useRouter } from 'next/navigation';
 import type { ColumnsType } from 'antd/es/table';
-import {
-  Button,
-  Form,
-  Input,
-  InputNumber,
-  Modal,
-  Select,
-  Space,
-  Table,
-  Tag,
-  message,
-} from 'antd';
+import type { SorterResult } from 'antd/es/table/interface';
+import { Button, DatePicker, Input, Modal, Select, Space, Table, Tag, message } from 'antd';
+import dayjs, { type Dayjs } from 'dayjs';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
-import { useCursorList } from '@/lib/useCursorList';
+import { formatUtcTime } from '@/lib/format';
+import { usePagedList } from '@/lib/usePagedList';
+import { AdjustCashModal, AdjustCoinModal } from '@/components/AdjustBalanceModals';
 import type { UserListItem } from '@/lib/types';

+const { RangePicker } = DatePicker;
+
 const STATUS_COLOR: Record<string, string> = { active: 'green', disabled: 'red', deleted: 'default' };

+type SortField = 'id' | 'created_at' | 'last_login_at';
+
 export default function UsersPage() {
  const router = useRouter();
+
+  // 筛选草稿:点「查询」才应用(避免输入即刷新);状态/渠道/日期一并随查询提交
  const [phone, setPhone] = useState('');
+  const [nickname, setNickname] = useState('');
  const [status, setStatus] = useState<string | undefined>();
-  const [filters, setFilters] = useState<Record<string, unknown>>({});
-  const { items, nextCursor, loading, loadMore, reload } = useCursorList<UserListItem>(
-    '/admin/api/users',
-    filters,
-  );
+  const [channel, setChannel] = useState<string | undefined>();
+  const [regRange, setRegRange] = useState<[Dayjs, Dayjs] | null>(null);
+  const [loginRange, setLoginRange] = useState<[Dayjs, Dayjs] | null>(null);
+  const [applied, setApplied] = useState<Record<string, unknown>>({});
+  // 排序(服务端):点列头即时生效,与「查询」按钮分开
+  const [sortBy, setSortBy] = useState<SortField>('id');
+  const [sortOrder, setSortOrder] = useState<'asc' | 'desc'>('desc');
+
+  const filters: Record<string, unknown> = { ...applied, sort_by: sortBy, sort_order: sortOrder };
+  const filterKey = JSON.stringify(filters);
+  const { items, total, page, pageSize, loading, onChange: onPageChange, reload } =
+    usePagedList<UserListItem>('/admin/api/users', filters);

  const canCoins = canDo(['finance']);
  const canStatus = canDo(['operator']);

  const [coinUser, setCoinUser] = useState<UserListItem | null>(null);
-  const [coinForm] = Form.useForm();
+  const [cashUser, setCashUser] = useState<UserListItem | null>(null);
+  const [selectedRowKeys, setSelectedRowKeys] = useState<Key[]>([]);

-  const search = () => setFilters({ phone: phone || undefined, status });
+  // 筛选/排序变化后清空已选(避免选中项跨筛选错位)
+  useEffect(() => {
+    setSelectedRowKeys([]);
+  }, [filterKey]);

-  const submitCoins = async () => {
-    const v = await coinForm.validateFields();
-    try {
-      await api.post(`/admin/api/users/${coinUser!.id}/coins`, v);
-      message.success('已调整金币');
-      setCoinUser(null);
-      coinForm.resetFields();
-    } catch (e) {
-      message.error(errMsg(e));
+  const search = () =>
+    setApplied({
+      phone: phone || undefined,
+      nickname: nickname || undefined,
+      status,
+      register_channel: channel || undefined,
+      created_from: regRange?.[0] ? regRange[0].startOf('day').toISOString() : undefined,
+      created_to: regRange?.[1] ? regRange[1].endOf('day').toISOString() : undefined,
+      last_login_from: loginRange?.[0] ? loginRange[0].startOf('day').toISOString() : undefined,
+      last_login_to: loginRange?.[1] ? loginRange[1].endOf('day').toISOString() : undefined,
+    });
+
+  const resetFilters = () => {
+    setPhone('');
+    setNickname('');
+    setStatus(undefined);
+    setChannel(undefined);
+    setRegRange(null);
+    setLoginRange(null);
+    setSortBy('id');
+    setSortOrder('desc');
+    setApplied({});
+  };
+
+  const onTableChange = (
+    _pagination: unknown,
+    _filters: unknown,
+    sorter: SorterResult<UserListItem> | SorterResult<UserListItem>[],
+  ) => {
+    const s = Array.isArray(sorter) ? sorter[0] : sorter;
+    if (s && s.order && s.field) {
+      setSortBy(s.field as SortField);
+      setSortOrder(s.order === 'ascend' ? 'asc' : 'desc');
+    } else {
+      // 取消排序 → 回默认(ID 倒序)
+      setSortBy('id');
+      setSortOrder('desc');
    }
  };

+  const sortOrderOf = (field: SortField) =>
+    sortBy === field ? (sortOrder === 'asc' ? 'ascend' : 'descend') : null;
+
  const toggleStatus = (u: UserListItem) => {
    const next = u.status === 'active' ? 'disabled' : 'active';
    Modal.confirm({
@@ -87,10 +130,72 @@ export default function UsersPage() {
    });
  };

+  const selectedUsers = items.filter((u) => selectedRowKeys.includes(u.id));
+  const selectedActive = selectedUsers.filter((u) => u.status === 'active');
+  const selectedDisabled = selectedUsers.filter((u) => u.status === 'disabled');
+
+  // 批量:循环调现有逐用户接口(各自已带审计),Promise.allSettled 汇总成败,不新增 bulk 端点
+  const runBulk = async (
+    targets: UserListItem[],
+    label: string,
+    call: (u: UserListItem) => Promise<unknown>,
+  ) => {
+    const results = await Promise.allSettled(targets.map(call));
+    const ok = results.filter((r) => r.status === 'fulfilled').length;
+    const fail = results.length - ok;
+    if (fail) message.warning(`${label}完成:成功 ${ok}/${results.length},失败 ${fail}`);
+    else message.success(`${label}完成:${ok} 个`);
+    setSelectedRowKeys([]);
+    reload();
+  };
+
+  const bulkStatus = (target: 'disabled' | 'active') => {
+    const targets = target === 'disabled' ? selectedActive : selectedDisabled;
+    const label = target === 'disabled' ? '批量封禁' : '批量解封';
+    if (!targets.length) {
+      message.warning(`没有可${target === 'disabled' ? '封禁(active)' : '解封(disabled)'}的选中用户`);
+      return;
+    }
+    Modal.confirm({
+      title: `确认${label} ${targets.length} 个用户?`,
+      content: target === 'disabled' ? '仅对选中的 active 用户生效' : '仅对选中的 disabled 用户生效',
+      okButtonProps: { danger: target === 'disabled' },
+      onOk: () =>
+        runBulk(targets, label, (u) =>
+          api.post(`/admin/api/users/${u.id}/status`, { status: target }),
+        ),
+    });
+  };
+
+  const bulkDebugTrace = (enabled: boolean) => {
+    // 只对「非 deleted 且当前态不同」的选中用户操作,避免无谓请求
+    const targets = selectedUsers.filter(
+      (u) => u.status !== 'deleted' && u.debug_trace_enabled !== enabled,
+    );
+    const label = enabled ? '批量开调试链接' : '批量关调试链接';
+    if (!targets.length) {
+      message.warning('没有需要变更的选中用户');
+      return;
+    }
+    Modal.confirm({
+      title: `确认${label} ${targets.length} 个用户?`,
+      onOk: () =>
+        runBulk(targets, label, (u) =>
+          api.post(`/admin/api/users/${u.id}/debug-trace`, { enabled }),
+        ),
+    });
+  };
+
  const columns: ColumnsType<UserListItem> = [
-    { title: 'ID', dataIndex: 'id', width: 70 },
-    { title: '手机号', dataIndex: 'phone' },
-    { title: '昵称', dataIndex: 'nickname', render: (v: string | null) => v || '-' },
+    { title: 'ID', dataIndex: 'id', width: 80, sorter: true, sortOrder: sortOrderOf('id') },
+    { title: '手机号', dataIndex: 'phone', width: 130 },
+    {
+      title: '昵称',
+      dataIndex: 'nickname',
+      width: 150,
+      ellipsis: true,
+      render: (v: string | null) => v || '-',
+    },
    { title: '渠道', dataIndex: 'register_channel', width: 90 },
    {
      title: '状态',
@@ -101,15 +206,29 @@ export default function UsersPage() {
    {
      title: '注册时间',
      dataIndex: 'created_at',
-      render: (v: string) => new Date(v).toLocaleString('zh-CN'),
+      width: 160,
+      sorter: true,
+      sortOrder: sortOrderOf('created_at'),
+      render: (v: string) => formatUtcTime(v),
+    },
+    {
+      title: '最近登录',
+      dataIndex: 'last_login_at',
+      width: 160,
+      sorter: true,
+      sortOrder: sortOrderOf('last_login_at'),
+      render: (v: string) => formatUtcTime(v),
    },
    {
      title: '操作',
      key: 'op',
+      fixed: 'right',
+      width: 300,
      render: (_: unknown, u: UserListItem) => (
-        <Space>
+        <Space wrap={false} onClick={(e) => e.stopPropagation()}>
          <a onClick={() => router.push(`/users/${u.id}`)}>详情</a>
          {canCoins && <a onClick={() => setCoinUser(u)}>调金币</a>}
+          {canCoins && <a onClick={() => setCashUser(u)}>调现金</a>}
          {canStatus && u.status !== 'deleted' && (
            <a onClick={() => toggleStatus(u)}>{u.status === 'active' ? '封禁' : '解封'}</a>
          )}
@@ -133,47 +252,105 @@ export default function UsersPage() {
          onChange={(e) => setPhone(e.target.value)}
          onPressEnter={search}
          allowClear
-          style={{ width: 160 }}
+          style={{ width: 150 }}
+        />
+        <Input
+          placeholder="昵称(模糊)"
+          value={nickname}
+          onChange={(e) => setNickname(e.target.value)}
+          onPressEnter={search}
+          allowClear
+          style={{ width: 150 }}
        />
        <Select
          placeholder="状态"
          value={status}
          onChange={setStatus}
          allowClear
-          style={{ width: 120 }}
+          style={{ width: 110 }}
          options={[
            { value: 'active', label: 'active' },
            { value: 'disabled', label: 'disabled' },
            { value: 'deleted', label: 'deleted' },
          ]}
        />
+        <Select
+          placeholder="渠道"
+          value={channel}
+          onChange={setChannel}
+          allowClear
+          style={{ width: 110 }}
+          options={[
+            { value: 'sms', label: 'sms' },
+            { value: 'wechat', label: 'wechat' },
+          ]}
+        />
+        <RangePicker
+          placeholder={['注册起', '注册止']}
+          value={regRange}
+          onChange={(v) => setRegRange(v as [Dayjs, Dayjs] | null)}
+          allowClear
+        />
+        <RangePicker
+          placeholder={['最近登录起', '最近登录止']}
+          value={loginRange}
+          onChange={(v) => setLoginRange(v as [Dayjs, Dayjs] | null)}
+          allowClear
+        />
        <Button type="primary" onClick={search}>
          查询
        </Button>
+        <Button onClick={resetFilters}>重置</Button>
      </Space>
-      <Table rowKey="id" columns={columns} dataSource={items} loading={loading} pagination={false} />
-      <div style={{ marginTop: 16, textAlign: 'center' }}>
-        <Button onClick={loadMore} disabled={!nextCursor} loading={loading}>
-          {nextCursor ? '加载更多' : '没有更多了'}
-        </Button>
-      </div>

-      <Modal
-        title={`调整金币 - ${coinUser?.phone ?? ''}`}
-        open={!!coinUser}
-        onOk={submitCoins}
-        onCancel={() => setCoinUser(null)}
-        destroyOnClose
-      >
-        <Form form={coinForm} layout="vertical">
-          <Form.Item name="amount" label="金币变动(正=增加,负=扣减)" rules={[{ required: true }]}>
-            <InputNumber style={{ width: '100%' }} />
-          </Form.Item>
-          <Form.Item name="reason" label="原因(入审计)" rules={[{ required: true }]}>
-            <Input.TextArea rows={2} />
-          </Form.Item>
-        </Form>
-      </Modal>
+      {canStatus && selectedUsers.length > 0 && (
+        <Space style={{ marginBottom: 12, width: '100%' }} wrap>
+          <span style={{ color: '#888' }}>
+            已选 {selectedUsers.length} 个(active {selectedActive.length}、disabled{' '}
+            {selectedDisabled.length})
+          </span>
+          <Button danger disabled={!selectedActive.length} onClick={() => bulkStatus('disabled')}>
+            批量封禁
+          </Button>
+          <Button disabled={!selectedDisabled.length} onClick={() => bulkStatus('active')}>
+            批量解封
+          </Button>
+          <Button onClick={() => bulkDebugTrace(true)}>批量开调试链接</Button>
+          <Button onClick={() => bulkDebugTrace(false)}>批量关调试链接</Button>
+          <Button type="link" onClick={() => setSelectedRowKeys([])}>
+            清空选择
+          </Button>
+        </Space>
+      )}
+
+      <Table
+        rowKey="id"
+        rowSelection={
+          canStatus
+            ? {
+                selectedRowKeys,
+                onChange: setSelectedRowKeys,
+                getCheckboxProps: (u) => ({ disabled: u.status === 'deleted' }),
+              }
+            : undefined
+        }
+        columns={columns}
+        dataSource={items}
+        loading={loading}
+        pagination={{
+          current: page,
+          pageSize,
+          total,
+          showSizeChanger: true,
+          showTotal: (t) => `共 ${t} 个用户`,
+          onChange: onPageChange,
+        }}
+        scroll={{ x: 1160 }}
+        onChange={onTableChange}
+      />
+
+      <AdjustCoinModal user={coinUser} open={!!coinUser} onClose={() => setCoinUser(null)} />
+      <AdjustCashModal user={cashUser} open={!!cashUser} onClose={() => setCashUser(null)} />
    </div>
  );
 }
@@ -36,11 +36,10 @@ import {
  SyncOutlined,
 } from '@ant-design/icons';
 import dayjs, { type Dayjs } from 'dayjs';
-import relativeTime from 'dayjs/plugin/relativeTime';
-import 'dayjs/locale/zh-cn';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
-import { useCursorList } from '@/lib/useCursorList';
+import { formatUtcTime, formatWallTime, utcDayjs, utcFromNow, yuan } from '@/lib/format';
+import { usePagedList } from '@/lib/usePagedList';
 import type {
  AuditLog,
  CashTxn,
@@ -52,19 +51,12 @@ import type {
  WxpayHealthCheck,
 } from '@/lib/types';

-dayjs.extend(relativeTime);
-dayjs.locale('zh-cn');
-
 const { Text } = Typography;
 const { RangePicker } = DatePicker;

-const yuan = (c: number) => `¥${(c / 100).toFixed(2)}`;
-const apiTime = (v: string) => {
-  const hasTimezone = /(?:Z|[+-]\d{2}:?\d{2})$/i.test(v);
-  return dayjs(hasTimezone ? v : `${v}Z`);
-};
-const dt = (v: string) => apiTime(v).format('YYYY-MM-DD HH:mm');
-const ago = (v: string) => apiTime(v).fromNow();
+// 提现单 / 审计 / 用户均为 UTC 口径(server_default=func.now());现金流水为北京 wall-clock。
+const dt = (v: string) => formatUtcTime(v);
+const ago = (v: string) => utcFromNow(v);

 const STATUS_COLOR: Record<string, string> = {
  reviewing: 'gold',
@@ -161,7 +153,7 @@ function riskTags(detail: WithdrawDetail | null) {
  const tags: string[] = [];
  if (!detail.order.user_name) tags.push('缺少提现实名');
  if (detail.user?.status && detail.user.status !== 'active') tags.push(`账号状态:${detail.user.status}`);
-  if (detail.user && dayjs().diff(apiTime(detail.user.created_at), 'hour') < 24) tags.push('新注册用户');
+  if (detail.user && dayjs().diff(utcDayjs(detail.user.created_at), 'hour') < 24) tags.push('新注册用户');
  if ((detail.user?.withdraw_total || 0) >= 3) tags.push('多次提现用户');
  if (detail.recent_withdraws.some((o) => o.status === 'rejected' || o.status === 'failed')) {
    tags.push('历史异常单');
@@ -181,6 +173,7 @@ export default function WithdrawsPage() {
  const [summary, setSummary] = useState<WithdrawSummary | null>(null);
  const [health, setHealth] = useState<WxpayHealthCheck | null>(null);
  const [ledger, setLedger] = useState<WithdrawLedgerCheck | null>(null);
+  const [ledgerLoading, setLedgerLoading] = useState(false);
  const [drawerOpen, setDrawerOpen] = useState(false);
  const [detail, setDetail] = useState<WithdrawDetail | null>(null);
  const [detailLoading, setDetailLoading] = useState(false);
@@ -188,7 +181,6 @@ export default function WithdrawsPage() {
  const [bulkRejecting, setBulkRejecting] = useState<WithdrawOrder[]>([]);
  const [rejectReason, setRejectReason] = useState('');
  const [selectedRowKeys, setSelectedRowKeys] = useState<Key[]>([]);
-  const [pageSize, setPageSize] = useState(20);
  const [searchDraft, setSearchDraft] = useState('');
  const [keyword, setKeyword] = useState('');
  const [dateRange, setDateRange] = useState<[Dayjs, Dayjs] | null>(null);
@@ -209,11 +201,8 @@ export default function WithdrawsPage() {
  filters.sort_by = sortBy;
  filters.sort_order = sortOrder;
  const filterKey = JSON.stringify(filters);
-  const { items, nextCursor, loading, loadMore, reload } = useCursorList<WithdrawOrder>(
-    '/admin/api/withdraws',
-    filters,
-    pageSize,
-  );
+  const { items, total, page, pageSize, loading, onChange: onPageChange, reload } =
+    usePagedList<WithdrawOrder>('/admin/api/withdraws', filters, 20);
  const canManage = canDo(['finance']);
  const selectedOrders = items.filter((item) => selectedRowKeys.includes(item.id));
  const selectedReviewing = selectedOrders.filter((item) => item.status === 'reviewing');
@@ -255,19 +244,28 @@ export default function WithdrawsPage() {
    }
  }, []);

-  const loadChecks = useCallback(async () => {
+  const loadHealth = useCallback(async () => {
    try {
-      const [{ data: healthData }, { data: ledgerData }] = await Promise.all([
-        api.get<WxpayHealthCheck>('/admin/api/withdraws/health-check'),
-        api.get<WithdrawLedgerCheck>('/admin/api/withdraws/ledger-check'),
-      ]);
-      setHealth(healthData);
-      setLedger(ledgerData);
+      const { data } = await api.get<WxpayHealthCheck>('/admin/api/withdraws/health-check');
+      setHealth(data);
    } catch (e) {
      message.error(errMsg(e));
    }
  }, []);

+  // 账本校验是全表对账、相对重,故只在进页时拉一次 + 提供手动按钮,不随每次写操作重算。
+  const loadLedger = useCallback(async () => {
+    setLedgerLoading(true);
+    try {
+      const { data } = await api.get<WithdrawLedgerCheck>('/admin/api/withdraws/ledger-check');
+      setLedger(data);
+    } catch (e) {
+      message.error(errMsg(e));
+    } finally {
+      setLedgerLoading(false);
+    }
+  }, []);
+
  const loadDetail = useCallback(async (outBillNo: string) => {
    setDetailLoading(true);
    try {
@@ -282,17 +280,19 @@ export default function WithdrawsPage() {

  useEffect(() => {
    void loadSummary();
-    void loadChecks();
-  }, [loadChecks, loadSummary]);
+    void loadHealth();
+    void loadLedger();
+  }, [loadHealth, loadLedger, loadSummary]);

  useEffect(() => {
    setSelectedRowKeys([]);
-  }, [filterKey, pageSize]);
+  }, [filterKey, page, pageSize]);

  const refreshAfterChange = async (outBillNo?: string) => {
    setSelectedRowKeys([]);
    reload();
-    await Promise.all([loadSummary(), loadChecks()]);
+    // 账本校验偏重,写操作后不重算(只刷 summary + health);需要时点账本 Alert 上的「重新校验」。
+    await Promise.all([loadSummary(), loadHealth()]);
    if (outBillNo && drawerOpen && detail?.order.out_bill_no === outBillNo) {
      await loadDetail(outBillNo);
    }
@@ -595,7 +595,8 @@ export default function WithdrawsPage() {
    },
    { title: '余额', dataIndex: 'balance_after_cents', width: 100, render: yuan },
    { title: '备注', dataIndex: 'remark', render: (v: string | null) => v || '-' },
-    { title: '时间', dataIndex: 'created_at', width: 150, render: dt },
+    // 现金流水是北京 wall-clock 口径,原样显示,不能当 UTC 再 +8
+    { title: '时间', dataIndex: 'created_at', width: 150, render: (v: string) => formatWallTime(v) },
  ];

  const recentWithdrawColumns: ColumnsType<WithdrawOrder> = [
@@ -686,6 +687,16 @@ export default function WithdrawsPage() {
                  ? `账户余额合计 ${yuan(ledger.cash_balance_total_cents)}，现金流水净额 ${yuan(ledger.cash_transaction_total_cents)}`
                  : ledgerIssues.join('；')
              }
+              action={
+                <Button
+                  size="small"
+                  icon={<ReloadOutlined />}
+                  loading={ledgerLoading}
+                  onClick={() => void loadLedger()}
+                >
+                  重新校验
+                </Button>
+              }
            />
          )}
        </Space>
@@ -872,31 +883,6 @@ export default function WithdrawsPage() {
            </Space>
          </Space>
        )}
-        <Space
-          wrap
-          style={{
-            width: '100%',
-            justifyContent: 'space-between',
-            marginBottom: 12,
-          }}
-        >
-          <Text type="secondary">
-            当前已加载 {items.length} 条{nextCursor ? '，还有更多' : '，已到最后一页'}
-          </Text>
-          <Space>
-            <Text type="secondary">每次加载</Text>
-            <Select
-              value={pageSize}
-              style={{ width: 96 }}
-              onChange={(value: number) => setPageSize(value)}
-              options={[
-                { value: 20, label: '20 条' },
-                { value: 50, label: '50 条' },
-                { value: 100, label: '100 条' },
-              ]}
-            />
-          </Space>
-        </Space>
        <Table
          rowKey="id"
          rowSelection={
@@ -913,18 +899,21 @@ export default function WithdrawsPage() {
          columns={columns}
          dataSource={items}
          loading={loading}
-          pagination={false}
+          pagination={{
+            current: page,
+            pageSize,
+            total,
+            showSizeChanger: true,
+            pageSizeOptions: [20, 50, 100],
+            showTotal: (t) => `共 ${t} 条`,
+            onChange: onPageChange,
+          }}
          scroll={{ x: 1350 }}
          onRow={(record) => ({
            onClick: () => openDetail(record),
            style: { cursor: 'pointer' },
          })}
        />
-        <div style={{ marginTop: 16, textAlign: 'center' }}>
-          <Button onClick={loadMore} disabled={!nextCursor} loading={loading}>
-            {nextCursor ? `继续加载 ${pageSize} 条` : '没有更多了'}
-          </Button>
-        </div>
      </Card>

      <Drawer
@@ -12,7 +12,17 @@ export function Providers({ children }: { children: React.ReactNode }) {
  return (
    <AntdRegistry>
      {/* wave 禁用:消除 antd 5 波纹在 Next15 dev 下的 React 版本兼容误报(纯噪音,后台不需要波纹) */}
-      <ConfigProvider locale={zhCN} wave={{ disabled: true }}>
+      {/* 全局主题:统一圆角到 8、页面底色用偏冷的浅灰,让白色卡片更有层次(全站生效) */}
+      <ConfigProvider
+        locale={zhCN}
+        wave={{ disabled: true }}
+        theme={{
+          token: {
+            borderRadius: 8,
+            colorBgLayout: '#f0f2f5',
+          },
+        }}
+      >
        {children}
      </ConfigProvider>
    </AntdRegistry>
@@ -0,0 +1,201 @@
+'use client';
+
+// 调金币 / 调现金弹窗(受控)。列表页与用户详情页共用,避免两处各写一套。
+// 每个弹窗自带「增减 / 设为指定值」两种模式;打开时拉一次 360 概览展示当前余额。
+import { useEffect, useState } from 'react';
+import { Form, Input, InputNumber, Modal, Segmented, message } from 'antd';
+import { api, errMsg } from '@/lib/api';
+import { yuan } from '@/lib/format';
+import type { UserOverview } from '@/lib/types';
+
+export type AdjustTargetUser = { id: number; phone: string };
+
+interface ModalProps {
+  user: AdjustTargetUser | null;
+  open: boolean;
+  onClose: () => void;
+  onDone?: () => void; // 调整成功后回调(刷新余额/列表)
+}
+
+const balanceLine = (balances: { coin: number; cashCents: number } | null) => (
+  <p style={{ color: '#888', marginBottom: 12 }}>
+    当前余额:金币 {balances ? balances.coin : '…'} ｜ 现金 {balances ? yuan(balances.cashCents) : '…'}
+  </p>
+);
+
+// 弹窗打开时拉一次该用户余额;用户切换/关闭时丢弃过期响应(alive 标记防竞态)。
+function useBalances(userId: number | undefined, open: boolean) {
+  const [balances, setBalances] = useState<{ coin: number; cashCents: number } | null>(null);
+  useEffect(() => {
+    if (!open || userId == null) {
+      setBalances(null);
+      return;
+    }
+    let alive = true;
+    setBalances(null);
+    api
+      .get<UserOverview>(`/admin/api/users/${userId}`)
+      .then((r) => {
+        if (alive) setBalances({ coin: r.data.coin_balance, cashCents: r.data.cash_balance_cents });
+      })
+      .catch(() => {});
+    return () => {
+      alive = false;
+    };
+  }, [userId, open]);
+  return balances;
+}
+
+export function AdjustCoinModal({ user, open, onClose, onDone }: ModalProps) {
+  const [form] = Form.useForm();
+  const [mode, setMode] = useState<'delta' | 'set'>('delta');
+  const balances = useBalances(user?.id, open);
+
+  useEffect(() => {
+    if (open) {
+      setMode('delta');
+      form.resetFields();
+    }
+  }, [open, form]);
+
+  const submit = async () => {
+    if (!user) return;
+    const v = await form.validateFields();
+    try {
+      await api.post(`/admin/api/users/${user.id}/coins`, { mode, ...v });
+      message.success(mode === 'set' ? '已设置金币' : '已调整金币');
+      onClose();
+      onDone?.();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
+  return (
+    <Modal
+      title={`调整金币 - ${user?.phone ?? ''}`}
+      open={open}
+      onOk={submit}
+      onCancel={onClose}
+      destroyOnHidden
+    >
+      {balanceLine(balances)}
+      <Form form={form} layout="vertical">
+        <Form.Item label="操作方式">
+          <Segmented
+            value={mode}
+            onChange={(v) => setMode(v as 'delta' | 'set')}
+            options={[
+              { label: '增减', value: 'delta' },
+              { label: '设为指定值', value: 'set' },
+            ]}
+          />
+        </Form.Item>
+        <Form.Item
+          name="amount"
+          label={mode === 'set' ? '目标金币值(直接设为该值)' : '金币变动(正=增加,负=扣减)'}
+          rules={[
+            { required: true },
+            ...(mode === 'set' ? [{ type: 'number' as const, min: 0, message: '目标值不能为负' }] : []),
+          ]}
+        >
+          <InputNumber style={{ width: '100%' }} min={mode === 'set' ? 0 : undefined} />
+        </Form.Item>
+        <Form.Item name="reason" label="原因(入审计)" rules={[{ required: true }]}>
+          <Input.TextArea rows={2} />
+        </Form.Item>
+      </Form>
+    </Modal>
+  );
+}
+
+export function AdjustCashModal({ user, open, onClose, onDone }: ModalProps) {
+  const [form] = Form.useForm();
+  const [mode, setMode] = useState<'delta' | 'set'>('delta');
+  const balances = useBalances(user?.id, open);
+
+  useEffect(() => {
+    if (open) {
+      setMode('delta');
+      form.resetFields();
+    }
+  }, [open, form]);
+
+  // 输入元,×100 转分后调后端(主要给无现金用户发钱直接测试提现)
+  const submit = async () => {
+    if (!user) return;
+    const v = await form.validateFields();
+    const amountCents = Math.round(Number(v.amount_yuan) * 100);
+    if (mode === 'delta' && amountCents === 0) {
+      message.warning('金额不能为 0(且不小于 1 分)');
+      return;
+    }
+    if (mode === 'set' && amountCents < 0) {
+      message.warning('目标金额不能为负');
+      return;
+    }
+    try {
+      await api.post(`/admin/api/users/${user.id}/cash`, {
+        mode,
+        amount_cents: amountCents,
+        reason: v.reason,
+      });
+      message.success(
+        mode === 'set'
+          ? `已设为 ¥${(amountCents / 100).toFixed(2)} 现金`
+          : `已${amountCents > 0 ? '发放' : '扣减'} ¥${(Math.abs(amountCents) / 100).toFixed(2)} 现金`,
+      );
+      onClose();
+      onDone?.();
+    } catch (e) {
+      message.error(errMsg(e));
+    }
+  };
+
+  return (
+    <Modal
+      title={`调现金 - ${user?.phone ?? ''}`}
+      open={open}
+      onOk={submit}
+      onCancel={onClose}
+      destroyOnHidden
+    >
+      {balanceLine(balances)}
+      <Form form={form} layout="vertical">
+        <Form.Item label="操作方式">
+          <Segmented
+            value={mode}
+            onChange={(v) => setMode(v as 'delta' | 'set')}
+            options={[
+              { label: '增减', value: 'delta' },
+              { label: '设为指定值', value: 'set' },
+            ]}
+          />
+        </Form.Item>
+        <Form.Item
+          name="amount_yuan"
+          label={
+            mode === 'set'
+              ? '目标现金(元,直接设为该值,须≥0)'
+              : '现金变动(元,正=发放,负=扣减;不可扣成负)'
+          }
+          rules={[
+            { required: true },
+            ...(mode === 'set' ? [{ type: 'number' as const, min: 0, message: '目标值不能为负' }] : []),
+          ]}
+        >
+          <InputNumber
+            style={{ width: '100%' }}
+            step={0.01}
+            precision={2}
+            suffix="元"
+            min={mode === 'set' ? 0 : undefined}
+          />
+        </Form.Item>
+        <Form.Item name="reason" label="原因(入审计)" rules={[{ required: true }]}>
+          <Input.TextArea rows={2} />
+        </Form.Item>
+      </Form>
+    </Modal>
+  );
+}
@@ -0,0 +1,47 @@
+// 全站统一的金额 / 时间格式化。
+//
+// 后端有两种时间口径,序列化后从字符串无法区分,必须按字段语义选对函数:
+//   1. UTC 口径:`server_default=func.now()` 的字段(用户/提现单/审计日志/广告发奖记录)。
+//      入库是 UTC,SQLite 下序列化不带时区、Postgres 下带 +00:00。统一当 UTC 解析后转北京显示。
+//   2. 北京 wall-clock 口径:钱包流水(coin_transaction / cash_transaction)。入库即
+//      `datetime.now(CN_TZ).replace(tzinfo=None)`,字面就是北京时间且无时区,**不能再做时区换算**。
+// 历史上各页面混用 `new Date().toLocaleString`(按本地解析)与 `apiTime`(补 Z 当 UTC),
+// 导致提现详情里现金流水时间快 8 小时。此模块收口,按口径区分。
+import dayjs from 'dayjs';
+import utc from 'dayjs/plugin/utc';
+import timezone from 'dayjs/plugin/timezone';
+import relativeTime from 'dayjs/plugin/relativeTime';
+import 'dayjs/locale/zh-cn';
+
+dayjs.extend(utc);
+dayjs.extend(timezone);
+dayjs.extend(relativeTime);
+dayjs.locale('zh-cn');
+
+const TZ = 'Asia/Shanghai';
+
+/** 金额:分 → ¥元(两位小数)。 */
+export const yuan = (cents: number) => `¥${(cents / 100).toFixed(2)}`;
+
+const hasTz = (v: string) => /(?:Z|[+-]\d{2}:?\d{2})$/i.test(v);
+
+/** 把 UTC 口径字符串解析为带时区的 dayjs(无时区后缀的补 Z 当 UTC)。 */
+export const utcDayjs = (v: string) => dayjs(hasTz(v) ? v : `${v}Z`);
+
+/** UTC 口径时间 → 北京时间显示(用户/提现单/审计/广告发奖记录)。 */
+export function formatUtcTime(v?: string | null, fmt = 'YYYY-MM-DD HH:mm'): string {
+  if (!v) return '-';
+  return utcDayjs(v).tz(TZ).format(fmt);
+}
+
+/** UTC 口径相对时间(如「3 分钟前」)。 */
+export function utcFromNow(v?: string | null): string {
+  if (!v) return '-';
+  return utcDayjs(v).fromNow();
+}
+
+/** 北京 wall-clock 口径时间 → 原样格式化,不做时区换算(钱包金币/现金流水)。 */
+export function formatWallTime(v?: string | null, fmt = 'YYYY-MM-DD HH:mm'): string {
+  if (!v) return '-';
+  return dayjs(v).format(fmt);
+}
@@ -19,6 +19,7 @@ export interface LoginResponse {
 export interface CursorPage<T> {
  items: T[];
  next_cursor: number | null;
+  total?: number | null; // offset 分页时为符合筛选条件的总条数(页码分页用);加载更多接口可能没有
 }

 export interface UserListItem {
@@ -34,6 +35,13 @@ export interface UserListItem {
  last_login_at: string;
 }

+// 设备维度新手引导:一台设备(ANDROID_ID)聚合,走过引导的账号数 + 最近完成时间。
+export interface DeviceOnboardingItem {
+  device_id: string;
+  account_count: number;
+  last_completed_at: string;
+}
+
 export interface UserOverview {
  user: UserListItem;
  coin_balance: number;
@@ -180,39 +188,72 @@ export interface AuditLog {
  created_at: string;
 }

-export interface AdCoinAuditRow {
-  scene: string; // reward_video / feed
-  record_id: number;
-  user_id: number;
+// 广告收益报表聚合行下钻的单条展示明细
+export interface AdRevenueImpression {
+  id: number;
  created_at: string;
-  status: string; // granted / capped / ecpm_missing
+  ecpm: string; // 分/千次展示
+  revenue_yuan: number; // 本次展示预估收益(元)
+  adn: string | null;
+  slot_id: string | null; // 底层 mediation rit
+}
+
+// 广告收益报表聚合行下钻的单条发奖复算明细
+export interface AdRevenueRecord {
+  record_id: number;
+  created_at: string;
+  status: string; // granted / capped / ecpm_missing / too_short / closed_early
  ecpm: string | null;
-  ecpm_factor: number | null;
-  units: number;
+  ecpm_factor: number | null; // 因子1
+  units: number; // 份数
  lt_index_start: number | null;
  lt_index_end: number | null;
-  lt_factor_start: number | null;
+  lt_factor_start: number | null; // 因子2
  lt_factor_end: number | null;
  expected_coin: number;
  actual_coin: number;
  matched: boolean;
 }

-export interface AdCoinFormula {
-  description: string;
-  coin_per_yuan: number;
-  ecpm_unit: string;
-  feed_unit_seconds: number;
-  ecpm_factor_tiers: [number, number, number | null][];
-  lt_factor_tiers: [number, number, number | null][];
+// 广告收益报表:按日期汇总的一天(按天趋势图用;全量,不受 limit 影响)
+export interface AdRevenueDaily {
+  date: string; // 北京时间 YYYY-MM-DD
+  impressions: number;
+  revenue_yuan: number;
+  expected_coin: number;
+  actual_coin: number;
 }

-export interface AdCoinAudit {
-  date: string;
-  formula: AdCoinFormula;
-  total: number;
-  mismatch_count: number;
-  items: AdCoinAuditRow[];
+// 广告收益报表:按 日期 × 用户 × 广告类型 × 应用 × 代码位 聚合
+export interface AdRevenueRow {
+  report_date: string; // 该组所属日期 北京时间 YYYY-MM-DD
+  user_id: number;
+  ad_type: string; // reward_video / feed / draw
+  app_env: string | null; // prod(傻瓜比价) / test(测试);旧数据为空
+  our_code_id: string | null; // 我们配置的代码位 104xxx;旧数据为空
+  hour: number | null; // 北京时间小时 0–23(按小时粒度时有值;按天为 null)
+  impressions: number; // 展示条数(轮播每条各计一次)
+  revenue_yuan: number; // 收益(元),预估口径
+  expected_coin: number; // 应发金币(公式复算,与金币审计同源)
+  actual_coin: number; // 实发金币(实际入账)
+  matched: boolean; // 该组应发==实发
+  adns: string[]; // 底层填充 ADN 子渠道集合
+  impression_records: AdRevenueImpression[]; // 该组逐条展示明细(展开下钻)
+  records: AdRevenueRecord[]; // 该组逐条发奖复算明细(展开下钻)
+}
+
+export interface AdRevenueReport {
+  date_from: string; // 起始日 北京时间 YYYY-MM-DD
+  date_to: string; // 结束日 北京时间 YYYY-MM-DD(闭区间;单日时与 date_from 相同)
+  daily: AdRevenueDaily[]; // 按日期汇总序列(全量,供按天趋势图)
+  total: number; // 聚合组总数(全量,不受 limit 影响)
+  truncated: boolean;
+  total_impressions: number;
+  total_revenue_yuan: number;
+  total_expected_coin: number;
+  total_actual_coin: number;
+  mismatch_count: number; // 应发≠实发的组数
+  items: AdRevenueRow[];
 }

 export interface DashboardOverview {
@@ -262,3 +303,78 @@ export interface PriceReportSummary {
  rejected: number;
  total: number;
 }
+
+// ===== CPS 分发与对账 =====
+export interface CpsGroup {
+  id: number;
+  sid: string; // 美团二级渠道追踪位,每群唯一
+  name: string;
+  member_count: number | null;
+  status: string; // active / archived
+  remark: string | null;
+  created_at: string;
+}
+
+export interface CpsActivity {
+  id: number;
+  platform: string; // meituan / taobao / jd
+  name: string;
+  act_id: string | null; // 美团活动物料 ID
+  product_view_sign: string | null;
+  status: string;
+  remark: string | null;
+  created_at: string;
+}
+
+export interface CpsOrder {
+  id: number;
+  order_id: string;
+  sid: string | null;
+  act_id: string | null;
+  pay_price_cents: number | null;
+  commission_cents: number | null;
+  commission_rate: string | null; // "300"=3% "10"=0.1%
+  mt_status: string | null; // 2付款 3完成 4取消 5风控 6结算
+  invalid_reason: string | null;
+  product_name: string | null;
+  pay_time: string | null;
+}
+
+export interface CpsReferralLink {
+  redirect_url: string; // ★ 我们的群发短链(/c/{code}),发群用这个,点击经我们统计
+  code: string;
+  sid: string;
+  group_name: string;
+  activity_name: string;
+  target_url: string; // 实际 302 跳转的美团短链
+  link_map: Record<string, string>; // 美团原始 1长链/2短链/3deeplink(参考)
+}
+
+export interface CpsReconcileResult {
+  fetched: number;
+  inserted: number;
+  updated: number;
+  pages: number;
+}
+
+export interface CpsGroupStat {
+  group_id: number | null; // null = 未归群的 sid
+  sid: string | null;
+  name: string;
+  member_count: number | null;
+  click_pv: number; // 点击总次数
+  click_uv: number; // 独立点击(ip+ua 近似去重)
+  order_count: number; // 有效单(不含取消/风控)
+  settled_count: number;
+  canceled_count: number;
+  gmv_cents: number;
+  est_commission_cents: number;
+  settled_commission_cents: number;
+}
+
+export interface CpsStats {
+  groups: CpsGroupStat[];
+  total_order_count: number;
+  total_est_commission_cents: number;
+  total_settled_commission_cents: number;
+}
@@ -0,0 +1,75 @@
+'use client';
+
+import { useCallback, useEffect, useRef, useState } from 'react';
+import { api } from './api';
+import type { CursorPage } from './types';
+
+/**
+ * 页码分页列表 hook(对接后端 offset 分页 + total)。
+ * 与 useCursorList(「加载更多」)并存:需要页码/跳页/共 N 条的主列表页用本 hook。
+ *
+ * 约定:后端 cursor 即 offset,本 hook 按 (page-1)*pageSize 计算;CursorPage.total 为符合
+ * 筛选条件的总条数(供 antd Table pagination 渲染)。filters 变化自动回第 1 页重载。
+ */
+export function usePagedList<T>(
+  url: string,
+  filters: Record<string, unknown>,
+  initialPageSize = 20,
+) {
+  const [items, setItems] = useState<T[]>([]);
+  const [total, setTotal] = useState(0);
+  const [page, setPage] = useState(1);
+  const [pageSize, setPageSize] = useState(initialPageSize);
+  const [loading, setLoading] = useState(false);
+  const requestSeq = useRef(0);
+
+  const filtersKey = JSON.stringify(filters);
+
+  const load = useCallback(
+    async (p: number, ps: number) => {
+      const seq = requestSeq.current + 1;
+      requestSeq.current = seq;
+      setLoading(true);
+      try {
+        const params = { ...JSON.parse(filtersKey), limit: ps, cursor: (p - 1) * ps };
+        const { data } = await api.get<CursorPage<T>>(url, { params });
+        if (requestSeq.current !== seq) return; // 丢弃过期响应(快速切页/筛选)
+        setItems(data.items);
+        setTotal(data.total ?? 0);
+      } finally {
+        if (requestSeq.current === seq) setLoading(false);
+      }
+    },
+    [url, filtersKey],
+  );
+
+  // 筛选变化:回第 1 页重载
+  useEffect(() => {
+    setPage(1);
+    load(1, pageSize);
+    // eslint-disable-next-line react-hooks/exhaustive-deps
+  }, [load]);
+
+  // antd Table pagination.onChange(page, pageSize):页变或每页条数变都走这里
+  const onChange = (p: number, ps: number) => {
+    if (ps !== pageSize) {
+      // 每页条数变 → 回第 1 页,避免越界空页
+      setPageSize(ps);
+      setPage(1);
+      load(1, ps);
+    } else {
+      setPage(p);
+      load(p, ps);
+    }
+  };
+
+  return {
+    items,
+    total,
+    page,
+    pageSize,
+    loading,
+    onChange,
+    reload: () => load(page, pageSize), // 写操作后刷新当前页
+  };
+}
Author	SHA1	Message	Date
marco	9134ea9255	feat(cps): CPS 分发与对账后台页群/活动管理 + 生成带 sid 短链(/c/{code}) + 对账统计(点击 PV/UV + 下单/佣金)。 Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>	2026-06-17 10:01:08 +08:00
ouzhou	f82f511b84	feat(ad-revenue): 广告数据报表页(替换金币审计页) (#11 ) - 新增 /ad-revenue:聚合表 + 派生指标(平均 eCPM/毛利/发奖占比)+ 零依赖 SVG 趋势图 + 行展开下钻展示明细/发奖复算明细 - 删除旧 /ad-audit 页;侧栏「金币审计」→「广告数据」 - feedbacks 由「加载更多」改 antd 页码分页(usePagedList),内容列 3 行省略可展开 - types 用 AdRevenue* 替换 AdCoinAudit*;providers 统一主题圆角/页面底色 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: OuYingJun1024 <1034284404@qq.com> Reviewed-on: #11 Co-authored-by: ouzhou <ouzhou@wonderable.ai> Co-committed-by: ouzhou <ouzhou@wonderable.ai>	2026-06-15 23:13:22 +08:00
ouzhou	05a1d06e61	fix(admin-web): 时间渲染收口到 formatUtcTime,消灭 new Date().toLocaleString (#10 ) review 发现 4 处仍用 new Date(v).toLocaleString 渲染后端 UTC 口径时间戳—— 正是 lib/format.ts 头注释明令消灭的反模式(SQLite 本地/非中国浏览器会差 8h, 生产靠 +00:00 偏移侥幸正确)。统一改用 formatUtcTime 按北京显示: - admins: last_login_at - audit-logs: created_at - devices: completed_at - dashboard/HomeStatsConfig: ops_stat_config.updated_at 均为 server_default now()/datetime.now(utc) 的 UTC 口径字段。 HomeStatsConfig 的「下个更新时刻」用 epoch ms + 强制 Asia/Shanghai,正确,不动。 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: OuYingJun1024 <1034284404@qq.com> Reviewed-on: #10 Co-authored-by: ouzhou <ouzhou@wonderable.ai> Co-committed-by: ouzhou <ouzhou@wonderable.ai>	2026-06-14 22:54:24 +08:00
ouzhou	94d550db9b	feat(admin-web): 余额设值/批量、时区与复用整顿、用户列表排序筛选 (#9 ) - 调金币/现金:新增「设为指定值」模式;修 InputNumber addonAfter 废弃告警; 弹窗抽成共享组件 AdjustBalanceModals(列表页/详情页复用,内含防竞态余额拉取) - 新增 lib/format.ts 统一金额/时间格式化:区分 UTC 字段与钱包流水(北京 wall-clock), 修正提现详情现金流水快 8 小时、用户注册时间慢 8 小时等偏差 - 提现页:账本校验(ledger-check)改按需触发,写操作后不再重算;现金流水时区修正 - 用户详情页:加载失败 Result 兜底(不再永久转圈)+ 现金流水 tab + 调金币/现金/封禁入口 - 金币审计页:加「只看不一致」过滤;截断提示改用后端精确 truncated 旗标 - 用户列表:注册/最近登录/ID 列排序 + 渠道/昵称/时间范围筛选 + 批量封禁解封/开关调试链接 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: OuYingJun1024 <1034284404@qq.com> Reviewed-on: #9 Co-authored-by: ouzhou <ouzhou@wonderable.ai> Co-committed-by: ouzhou <ouzhou@wonderable.ai>	2026-06-13 23:43:52 +08:00
marco	2eff4a71be	feat(onboarding): 删「按用户强制引导」UI + 新增设备管理页 - users 页删 force_onboarding 操作 + types 字段 - 新增设备管理页(/devices): 按设备列表 + 行内「重走引导」+「全部重设」危险操作 + 菜单项 Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>	2026-06-12 00:51:51 +08:00
zhuzihao	c66d90a6e1	feat(force-onboarding): 用户列表加「开启新手引导」一次性操作 (#8 ) 点一下把该用户标记为未看过引导:Ta 下次打开 App 重走一遍新手引导,看完后端自动恢复(只触发这一次);未消费前显示「待重看」可撤销。operator 角色可见。 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: zzhyyyyy <2685922758@qq.com> Reviewed-on: #8 Co-authored-by: zhuzihao <zhuzihao@wonderable.ai> Co-committed-by: zhuzihao <zhuzihao@wonderable.ai>	2026-06-10 22:26:41 +08:00
ouzhou	1717ee8b6a	feat(dashboard): 首页三数共享保存+智能校验+保底;轮播种子批量操作 (#7 ) - HomeStatsConfig: 三指标共享保存/立即更新;智能关系校验弹窗;真实值保底;初始基数护栏提示;saveAll 半失败合并 - HomeMarqueeSeeds: 勾选 + 批量启用/停用/删除 - 附带并行会话 WIP:users 页 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com> --------- Co-authored-by: OuYingJun1024 <1034284404@qq.com> Reviewed-on: #7 Co-authored-by: ouzhou <ouzhou@wonderable.ai> Co-committed-by: ouzhou <ouzhou@wonderable.ai>	2026-06-10 22:26:36 +08:00