fix(admin): show zero revenue for incomplete reward videos

## 改动
- 将领券记录表格的「点位成功率」列改名为「百分比」
- 全部点位成功的 x/x 使用与「完成」相同的绿色
- 未全部成功的 x/x 使用与「中途退出」相同的警示色
- 保留点击 x/x 查看点位明细的交互

## 验证
- 提交前已执行 git pull --rebase --autostash origin main
- npm run build

---------

Co-authored-by: linkeyu <798648091@qq.com>
Reviewed-on: #61
Co-authored-by: linkeyu <linkeyu@wonderable.ai>
Co-committed-by: linkeyu <linkeyu@wonderable.ai>

src/app/(main)/ad-revenue-report/page.tsx

@@ -66,21 +66,101 @@ const APP_TAG: Record<string, { color: string; label: string }> = {
   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' },
+const REWARD_STATUS_HINT: Record<string, string> = {
+  granted: '已完成金币发放',
+  capped: '次数超限，未发金币',
+  ecpm_missing: '缺少有效 eCPM，未发金币',
+  too_short: '播放时长未达到发奖条件，未发金币',
+  closed_early: '用户提前关闭广告，未发金币',
+};
+
+const PLAYBACK_STATUS_TAG: Record<string, { color: string; label: string }> = {
+  completed: { color: 'green', label: '已完成' },
   too_short: { color: 'gold', label: '未满10秒' },
   closed_early: { color: 'default', label: '提前关闭' },
+  unknown: { color: 'default', label: '未知' },
 };
-const STATUS_HINT: Record<string, string> = {
-  granted: '已满足当前客户端发奖条件并完成金币发放。',
-  too_short: '旧版 Draw 信息流观看不足 10 秒，不发金币；新版按观看比例发放时会记为已发。',
-  closed_early: '用户在达到发奖条件前主动关闭，不发金币。',
-  capped: '已达到次数上限，不再发金币。',
-  ecpm_missing: '缺少有效 eCPM，无法计算金币。',
-};
+
+const ZERO_REVENUE_REWARD_VIDEO_STATUSES = new Set(['closed_early', 'too_short']);
+
+function rewardStatuses(row: AdRevenueRow): string[] {
+  if (row.sub_rewards?.length) return row.sub_rewards.map((reward) => reward.status);
+  return row.status ? [row.status] : [];
+}
+
+function effectiveRevenueYuan(row: AdRevenueRow): number {
+  if (
+    row.ad_type === 'reward_video'
+    && rewardStatuses(row).some((status) => ZERO_REVENUE_REWARD_VIDEO_STATUSES.has(status))
+  ) {
+    return 0;
+  }
+  return row.row_revenue_yuan ?? row.revenue_yuan;
+}
+
+function rewardStatusTag(row: AdRevenueRow) {
+  const statuses = rewardStatuses(row);
+  if (!row.has_reward || statuses.length === 0) {
+    return { color: 'default', label: '无记录', hint: '仅记录到广告展示，没有对应发奖记录。' };
+  }
+
+  const grantedCount = statuses.filter((status) => status === 'granted').length;
+  const reasonSummary = Object.entries(
+    statuses
+      .filter((status) => status !== 'granted')
+      .reduce<Record<string, number>>((counts, status) => {
+        counts[status] = (counts[status] ?? 0) + 1;
+        return counts;
+      }, {}),
+  )
+    .map(([status, count]) => `${REWARD_STATUS_HINT[status] ?? status} ${count} 条`)
+    .join('；');
+
+  if (grantedCount === statuses.length) {
+    return { color: 'green', label: '已发', hint: `已完成金币发放${statuses.length > 1 ? ` ${statuses.length} 条` : ''}。` };
+  }
+  if (grantedCount > 0) {
+    return {
+      color: 'blue',
+      label: '部分已发',
+      hint: `已发 ${grantedCount} 条，未发 ${statuses.length - grantedCount} 条${reasonSummary ? `；${reasonSummary}` : ''}。`,
+    };
+  }
+  return { color: 'default', label: '未发', hint: reasonSummary ? `${reasonSummary}。` : '未发放金币。' };
+}
+
+function playbackStatusTag(row: AdRevenueRow) {
+  const statuses = rewardStatuses(row);
+  if (statuses.length === 0) {
+    return row.has_impression
+      ? { color: 'blue', label: '仅展示', hint: '记录到广告展示，但没有对应的播放结果。' }
+      : { color: 'default', label: '无记录', hint: '没有可用的广告播放记录。' };
+  }
+
+  const playbackCounts = statuses.reduce<Record<string, number>>((counts, status) => {
+    const playbackStatus =
+      status === 'too_short' || status === 'closed_early'
+        ? status
+        : status === 'granted' || status === 'capped' || status === 'ecpm_missing'
+          ? 'completed'
+          : 'unknown';
+    counts[playbackStatus] = (counts[playbackStatus] ?? 0) + 1;
+    return counts;
+  }, {});
+  const entries = Object.entries(playbackCounts);
+  if (entries.length === 1) {
+    const [status, count] = entries[0];
+    const tag = PLAYBACK_STATUS_TAG[status];
+    return {
+      ...tag,
+      hint: `${tag.label}${count > 1 ? ` ${count} 条` : ''}。`,
+    };
+  }
+  const hint = entries
+    .map(([status, count]) => `${PLAYBACK_STATUS_TAG[status].label} ${count} 条`)
+    .join('；');
+  return { color: 'purple', label: '混合状态', hint: `${hint}。` };
+}
 
 const fmtFactorRange = (a: number | null, b: number | null) => {
   if (a == null) return '-';
@@ -300,6 +380,8 @@ export default function AdRevenueReportPage() {
   const { message } = App.useApp();
   const [range, setRange] = useState<[Dayjs, Dayjs]>([dayjs().subtract(1, 'day'), dayjs().subtract(1, 'day')]);
   const [userId, setUserId] = useState<number | null>(null);
+  const [appEnv, setAppEnv] = useState<'prod' | 'test' | 'all'>('prod');
+  const [revenueScope, setRevenueScope] = useState<'business' | 'all'>('business');
   const [adType, setAdType] = useState<string | undefined>();
   // 「场景」作为后端全局筛选(feed_scene):同时影响明细 / 合计 / 趋势,与「用户 / 类型」一致,点「查询」生效。
   const [scene, setScene] = useState<string | undefined>();
@@ -333,6 +415,8 @@ export default function AdRevenueReportPage() {
           date_from: from,
           date_to: to,
           user_id: userId ?? undefined,
+          app_env: appEnv === 'all' ? undefined : appEnv,
+          revenue_scope: revenueScope,
           ad_type: adType ?? undefined,
           feed_scene: scene ?? undefined,
           granularity: gran,
@@ -374,7 +458,7 @@ export default function AdRevenueReportPage() {
         setLoading(false);
       }
     },
-    [range, userId, adType, scene, granularity, limit, sortBy],
+    [range, userId, appEnv, revenueScope, adType, scene, granularity, limit, sortBy],
   );
 
   useEffect(() => {
@@ -474,19 +558,25 @@ export default function AdRevenueReportPage() {
       width: 110,
       align: 'right',
       // 一次比价/领券聚合行用 row_revenue_yuan(该次发奖广告 eCPM 折算之和),其它行用展示侧 revenue_yuan
-      render: (v: number, r: AdRevenueRow) => {
-        const rev = r.row_revenue_yuan ?? v;
-        return rev.toFixed(4);
-      },
+      // 激励视频提前关闭/时长不足时防御性显示 0，与后端有效收益口径一致。
+      render: (_v: number, r: AdRevenueRow) => effectiveRevenueYuan(r).toFixed(4),
     },
     {
       title: '发奖状态',
-      dataIndex: 'status',
+      key: 'reward_status',
       width: 100,
-      render: (s: string | null) => {
-        if (!s) return <Tooltip title="仅记录广告展示，没有对应发奖事件。"><Tag>仅展示</Tag></Tooltip>;
-        const t = STATUS_TAG[s] ?? { color: 'default', label: s };
-        return <Tooltip title={STATUS_HINT[s]}><Tag color={t.color}>{t.label}</Tag></Tooltip>;
+      render: (_: unknown, row: AdRevenueRow) => {
+        const tag = rewardStatusTag(row);
+        return <Tooltip title={tag.hint}><Tag color={tag.color}>{tag.label}</Tag></Tooltip>;
+      },
+    },
+    {
+      title: '广告播放状态',
+      key: 'playback_status',
+      width: 120,
+      render: (_: unknown, row: AdRevenueRow) => {
+        const tag = playbackStatusTag(row);
+        return <Tooltip title={tag.hint}><Tag color={tag.color}>{tag.label}</Tag></Tooltip>;
       },
     },
     {
@@ -528,7 +618,8 @@ export default function AdRevenueReportPage() {
     'ecpm_yuan',
     'revenue_yuan',
     'actual_coin',
-    'status',
+    'reward_status',
+    'playback_status',
     'ad_type',
     'app_env',
     'our_code_id',
@@ -614,13 +705,14 @@ export default function AdRevenueReportPage() {
               <br />
               <br />
               「预估收益」为客户端在广告展示(onAdShow)时上报 eCPM 折算的预估值(每千次展示 ÷1000
-              累加),<b>只要广告展示就计入、不论是否看完发奖</b>;穿山甲会过滤无效/过短曝光,故预估值可能偏高,
+              累加);<b>激励视频提前关闭或播放时长不足时按 0 计</b>,其他有效展示按 eCPM 折算。穿山甲仍可能过滤无效曝光,
               <b>实际收益一律以穿山甲后台结算为准</b>。测试应用多为 0。「广告位ID / 来源应用」为本期新增,历史记录留空。
               <br />
               <br />
               核心指标里的<b>「穿山甲后台收益(T+1)」</b>来自穿山甲 GroMore 数据 API(后台结算口径,次日出数):
               <b>穿山甲预估收益</b>=接口 revenue、<b>收益API</b>=各 ADN 回传更接近结算。穿山甲不提供分用户/类型/场景维度,
-              故仅在<b>全量视图</b>(未按用户/类型/场景筛选)展示;逐条事件行仍是客户端预估,不受其影响。
+              故仅在<b>可对账视图</b>(未按用户/类型/场景筛选)展示;环境和数据范围会同时作用于客户端与穿山甲汇总。
+              默认“正式 + 业务代码位”用于同口径对账;切到“全部代码位”会包含广告测试等非业务曝光。
             </div>
           }
         >
@@ -655,6 +747,31 @@ export default function AdRevenueReportPage() {
               style={{ width: 130 }}
             />
           </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">环境</Typography.Text>
+            <Select
+              value={appEnv}
+              onChange={setAppEnv}
+              style={{ width: 130 }}
+              options={[
+                { value: 'prod', label: '正式(prod)' },
+                { value: 'test', label: '测试(dev)' },
+                { value: 'all', label: '全部' },
+              ]}
+            />
+          </Space>
+          <Space size={6}>
+            <Typography.Text type="secondary">数据范围</Typography.Text>
+            <Select
+              value={revenueScope}
+              onChange={setRevenueScope}
+              style={{ width: 150 }}
+              options={[
+                { value: 'business', label: '业务代码位' },
+                { value: 'all', label: '全部代码位' },
+              ]}
+            />
+          </Space>
           <Space size={6}>
             <Typography.Text type="secondary">类型</Typography.Text>
             <Select

src/app/(main)/comparison-records/page.tsx

@@ -1,6 +1,6 @@
 'use client';
 
-import { useEffect, useMemo, useState } from 'react';
+import { useEffect, useState } from 'react';
 import type { CSSProperties, ReactNode } from 'react';
 import {
   App, Button, Card, Col, Collapse, DatePicker, Descriptions, Divider, Drawer, Input, InputNumber,
@@ -9,8 +9,13 @@ import {
 import type { ColumnsType } from 'antd/es/table';
 import dayjs, { type Dayjs } from 'dayjs';
 import { api, errMsg } from '@/lib/api';
-import { formatWallTime, percentile, yuan } from '@/lib/format';
-import type { ComparisonRecordDetail, ComparisonRecordListItem, CursorPage } from '@/lib/types';
+import { formatWallTime, yuan } from '@/lib/format';
+import type {
+  ComparisonRecordDetail,
+  ComparisonRecordListItem,
+  ComparisonRecordsSummary,
+  CursorPage,
+} from '@/lib/types';
 
 const { RangePicker } = DatePicker;
 
@@ -105,8 +110,11 @@ export default function ComparisonRecordsPage() {
     date_from: dayjs().subtract(1, 'day').format('YYYY-MM-DD'),
     date_to: dayjs().subtract(1, 'day').format('YYYY-MM-DD'),
   });
-  const [allItems, setAllItems] = useState<ComparisonRecordListItem[]>([]);
-  const [loading, setLoading] = useState(false);
+  const [items, setItems] = useState<ComparisonRecordListItem[]>([]);
+  const [total, setTotal] = useState(0);
+  const [overview, setOverview] = useState<ComparisonRecordsSummary | null>(null);
+  const [listLoading, setListLoading] = useState(false);
+  const [summaryLoading, setSummaryLoading] = useState(false);
   const [page, setPage] = useState(1);
   const [pageSize, setPageSize] = useState(20);
   // LLM 单价(元/百万 token),本地持久化;仅用于前端估算成本,不入库、不影响其它页面
@@ -125,7 +133,8 @@ export default function ComparisonRecordsPage() {
   const [detail, setDetail] = useState<ComparisonRecordDetail | null>(null);
   const [detailLoading, setDetailLoading] = useState(false);
 
-  const search = () =>
+  const search = () => {
+    setPage(1);
     setApplied({
       date_from: range[0].format('YYYY-MM-DD'),
       date_to: range[1].format('YYYY-MM-DD'),
@@ -135,6 +144,7 @@ export default function ComparisonRecordsPage() {
       store: store.trim() || undefined,
       product: product.trim() || undefined,
     });
+  };
 
   const reset = () => {
     setUserId(null);
@@ -143,6 +153,7 @@ export default function ComparisonRecordsPage() {
     setStore('');
     setProduct('');
     const yesterday = dayjs().subtract(1, 'day');
+    setPage(1);
     setRange([yesterday, yesterday]);
     setApplied({
       date_from: yesterday.format('YYYY-MM-DD'),
@@ -152,49 +163,50 @@ export default function ComparisonRecordsPage() {
 
   useEffect(() => {
     let alive = true;
-    const loadAll = async () => {
-      setLoading(true);
+    const loadPage = async () => {
+      setListLoading(true);
       try {
-        const serverFilters = { ...applied };
-        delete serverFilters.date_from;
-        delete serverFilters.date_to;
-        const rows: ComparisonRecordListItem[] = [];
-        let cursor = 0;
-        for (let pageIndex = 0; pageIndex < 200; pageIndex += 1) {
-          const { data } = await api.get<CursorPage<ComparisonRecordListItem>>(
-            '/admin/api/comparison-records',
-            { params: { ...serverFilters, limit: 100, cursor } },
-          );
-          rows.push(...data.items);
-          if (data.next_cursor == null || data.items.length === 0) break;
-          cursor = data.next_cursor;
-        }
+        const { data } = await api.get<CursorPage<ComparisonRecordListItem>>(
+          '/admin/api/comparison-records',
+          { params: { ...applied, limit: pageSize, cursor: (page - 1) * pageSize } },
+        );
         if (alive) {
-          setAllItems(rows);
-          setPage(1);
+          setItems(data.items);
+          setTotal(data.total ?? 0);
         }
       } catch (e) {
         if (alive) message.error(errMsg(e));
       } finally {
-        if (alive) setLoading(false);
+        if (alive) setListLoading(false);
       }
     };
-    loadAll();
+    loadPage();
+    return () => {
+      alive = false;
+    };
+  }, [applied, message, page, pageSize]);
+
+  useEffect(() => {
+    let alive = true;
+    const loadSummary = async () => {
+      setSummaryLoading(true);
+      try {
+        const { data } = await api.get<ComparisonRecordsSummary>(
+          '/admin/api/comparison-records/summary',
+          { params: applied },
+        );
+        if (alive) setOverview(data);
+      } catch (e) {
+        if (alive) message.error(errMsg(e));
+      } finally {
+        if (alive) setSummaryLoading(false);
+      }
+    };
+    loadSummary();
     return () => {
       alive = false;
     };
   }, [applied, message]);
-
-  const filteredItems = useMemo(() => {
-    const from = String(applied.date_from ?? '');
-    const to = String(applied.date_to ?? '');
-    return allItems.filter((item) => {
-      const date = dayjs(item.created_at).format('YYYY-MM-DD');
-      return (!from || date >= from) && (!to || date <= to);
-    });
-  }, [allItems, applied]);
-  const total = filteredItems.length;
-  const items = filteredItems.slice((page - 1) * pageSize, page * pageSize);
   const onChange = (nextPage: number, nextPageSize: number) => {
     setPageSize(nextPageSize);
     setPage(nextPageSize === pageSize ? nextPage : 1);
@@ -218,46 +230,6 @@ export default function ComparisonRecordsPage() {
     setDetailLoading(false);
   };
 
-  const overview = useMemo(() => {
-    const completed = filteredItems.filter(
-      (item) => item.status === 'success' || item.status === 'failed',
-    );
-    const cancelled = filteredItems.filter((item) => item.status === 'cancelled');
-    const success = filteredItems.filter((item) => item.status === 'success');
-    const successRateDenominator = filteredItems.length - cancelled.length;
-    const completedDurations = completed
-      .map((item) => item.total_ms)
-      .filter((value): value is number => value != null);
-    const cancelledDurations = cancelled
-      .map((item) => item.total_ms)
-      .filter((value): value is number => value != null);
-    const costs = filteredItems
-      .map((item) => item.llm_cost_yuan)
-      .filter((value): value is number => value != null);
-    const avg = (values: number[]) =>
-      values.length ? values.reduce((sum, value) => sum + value, 0) / values.length : null;
-    return {
-      started: filteredItems.length,
-      completed: completed.length,
-      success: success.length,
-      successRate: successRateDenominator ? success.length / successRateDenominator : null,
-      avgTokenCost: avg(costs),
-      lowerPriceRate: success.length
-        ? success.filter((item) => (item.saved_amount_cents ?? 0) > 0).length / success.length
-        : null,
-      avgMs: avg(completedDurations),
-      p5Ms: percentile(completedDurations, 0.05),
-      p50Ms: percentile(completedDurations, 0.5),
-      p95Ms: percentile(completedDurations, 0.95),
-      p99Ms: percentile(completedDurations, 0.99),
-      cancelled: cancelled.length,
-      cancelledRate: filteredItems.length ? cancelled.length / filteredItems.length : null,
-      cancelledP5Ms: percentile(cancelledDurations, 0.05),
-      cancelledP50Ms: percentile(cancelledDurations, 0.5),
-      cancelledP95Ms: percentile(cancelledDurations, 0.95),
-    };
-  }, [filteredItems]);
-
   const columns: ColumnsType<ComparisonRecordListItem> = [
     { title: '时间', dataIndex: 'created_at', width: 150, render: (v: string) => formatWallTime(v) },
     {
@@ -424,28 +396,28 @@ export default function ComparisonRecordsPage() {
         </Space>
       </Card>
 
-      <Card size="small" style={{ marginBottom: 16 }} loading={loading}>
+      <Card size="small" style={{ marginBottom: 16 }} loading={summaryLoading}>
         <Divider orientation="left" plain style={{ marginTop: 0 }}>数据概览</Divider>
         <Row gutter={[16, 16]}>
-          <Col xs={12} md={6}><Statistic title="比价发起数" value={overview.started} /></Col>
-          <Col xs={12} md={6}><Statistic title="比价完成数" value={overview.completed} /></Col>
-          <Col xs={12} md={6}><Statistic title="比价成功次数" value={overview.success} /></Col>
-          <Col xs={12} md={6}><Statistic title="比价成功率" value={fmtRate(overview.successRate)} /></Col>
-          <Col xs={12} md={6}><Statistic title="平均 TOKEN 成本" value={overview.avgTokenCost ?? '-'} precision={4} prefix="¥" /></Col>
-          <Col xs={12} md={6}><Statistic title="比出更低价率" value={fmtRate(overview.lowerPriceRate)} /></Col>
-          <Col xs={12} md={6}><Statistic title="耗时平均数" value={fmtMs(overview.avgMs)} /></Col>
-          <Col xs={12} md={6}><Statistic title="耗时 5 分位" value={fmtMs(overview.p5Ms)} /></Col>
-          <Col xs={12} md={6}><Statistic title="耗时 50 分位" value={fmtMs(overview.p50Ms)} /></Col>
-          <Col xs={12} md={6}><Statistic title="耗时 95 分位" value={fmtMs(overview.p95Ms)} /></Col>
-          <Col xs={12} md={6}><Statistic title="耗时 99 分位" value={fmtMs(overview.p99Ms)} /></Col>
+          <Col xs={12} md={6}><Statistic title="比价发起数" value={overview?.started ?? 0} /></Col>
+          <Col xs={12} md={6}><Statistic title="比价完成数" value={overview?.completed ?? 0} /></Col>
+          <Col xs={12} md={6}><Statistic title="比价成功次数" value={overview?.success ?? 0} /></Col>
+          <Col xs={12} md={6}><Statistic title="比价成功率" value={fmtRate(overview?.success_rate ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="平均 TOKEN 成本" value={overview?.avg_token_cost ?? '-'} precision={4} prefix="¥" /></Col>
+          <Col xs={12} md={6}><Statistic title="比出更低价率" value={fmtRate(overview?.lower_price_rate ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="耗时平均数" value={fmtMs(overview?.avg_duration_ms ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="耗时 5 分位" value={fmtMs(overview?.p5_duration_ms ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="耗时 50 分位" value={fmtMs(overview?.p50_duration_ms ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="耗时 95 分位" value={fmtMs(overview?.p95_duration_ms ?? null)} /></Col>
+          <Col xs={12} md={6}><Statistic title="耗时 99 分位" value={fmtMs(overview?.p99_duration_ms ?? null)} /></Col>
         </Row>
         <Divider orientation="left" plain>中途退出</Divider>
         <Row gutter={[16, 16]}>
-          <Col xs={12} md={6}><Statistic title="中途退出次数" value={overview.cancelled} /></Col>
-          <Col xs={12} md={6}><Statistic title="中途退出率" value={fmtRate(overview.cancelledRate)} /></Col>
-          <Col xs={12} md={6}><Statistic title="退出耗时 5 分位" value={fmtMs(overview.cancelledP5Ms)} /></Col>
-          <Col xs={12} md={6}><Statistic title="退出耗时 50 分位" value={fmtMs(overview.cancelledP50Ms)} /></Col>
-          <Col xs={12} md={6}><Statistic title="退出耗时 95 分位" value={fmtMs(overview.cancelledP95Ms)} /></Col>
+          <Col flex="1 1 180px"><Statistic title="中途退出次数" value={overview?.cancelled ?? 0} /></Col>
+          <Col flex="1 1 180px"><Statistic title="中途退出率" value={fmtRate(overview?.cancelled_rate ?? null)} /></Col>
+          <Col flex="1 1 180px"><Statistic title="退出耗时 5 分位" value={fmtMs(overview?.cancelled_p5_ms ?? null)} /></Col>
+          <Col flex="1 1 180px"><Statistic title="退出耗时 50 分位" value={fmtMs(overview?.cancelled_p50_ms ?? null)} /></Col>
+          <Col flex="1 1 180px"><Statistic title="退出耗时 95 分位" value={fmtMs(overview?.cancelled_p95_ms ?? null)} /></Col>
         </Row>
       </Card>
 
@@ -453,7 +425,7 @@ export default function ComparisonRecordsPage() {
         rowKey="id"
         columns={columns}
         dataSource={items}
-        loading={loading}
+        loading={listLoading}
         pagination={{
           current: page,
           pageSize,

src/app/(main)/coupon-data/page.tsx

@@ -10,9 +10,11 @@ import {
   DatePicker,
   Divider,
   Input,
+  Popover,
   Row,
   Select,
   Space,
+  Spin,
   Statistic,
   Table,
   Tag,
@@ -72,9 +74,23 @@ interface CouponDataRow {
   app_env: string | null;
   started_at: string;
   claimed_count: number | null;
+  point_success_count: number | null;
+  point_total_count: number | null;
+  // 兼容旧后端的内嵌明细；新后端不再返回，改为点击后按 trace 加载。
+  point_details?: CouponPointDetail[];
   trace_url: string | null;
   ad_revenue_yuan: number | null; // 本次领券看的信息流广告预估收益(元);未填充为 null
 }
+interface CouponPointDetail {
+  coupon_id: string;
+  coupon_name: string | null;
+  status: string;
+  reason: string | null;
+}
+interface CouponPointDetailsOut {
+  trace_id: string;
+  items: CouponPointDetail[];
+}
 interface CouponDataReport {
   date_from: string;
   date_to: string;
@@ -116,6 +132,100 @@ const STATUS_TAG: Record<string, { color: string; label: string }> = {
   abandoned: { color: 'orange', label: '中途退出' },
 };
 
+const POINT_STATUS_TAG: Record<string, { color: string; label: string }> = {
+  success: { color: 'success', label: '成功' },
+  already_claimed: { color: 'processing', label: '已领' },
+  failed: { color: 'error', label: '失败' },
+  skipped: { color: 'default', label: '跳过' },
+};
+
+function PointScorePopover({ row }: { row: CouponDataRow }) {
+  const { message } = App.useApp();
+  const [details, setDetails] = useState<CouponPointDetail[] | null>(row.point_details ?? null);
+  const [loading, setLoading] = useState(false);
+  const [loadError, setLoadError] = useState<string | null>(null);
+
+  if (row.point_success_count == null || row.point_total_count == null || row.point_total_count <= 0) {
+    return <Typography.Text type="secondary">-</Typography.Text>;
+  }
+  const score = `${row.point_success_count}/${row.point_total_count}`;
+  const scoreColor =
+    row.point_success_count === row.point_total_count
+      ? STATUS_TAG.completed.color
+      : STATUS_TAG.abandoned.color;
+  const loadDetails = async () => {
+    if (details !== null || loading) return;
+    setLoading(true);
+    setLoadError(null);
+    try {
+      const response = await api.get<CouponPointDetailsOut>('/admin/api/coupon-data/point-details', {
+        params: { trace_id: row.trace_id },
+      });
+      setDetails(response.data.items);
+    } catch (error) {
+      const errorMessage = errMsg(error);
+      setLoadError(errorMessage);
+      message.error(errorMessage);
+    } finally {
+      setLoading(false);
+    }
+  };
+
+  return (
+    <Popover
+      trigger="click"
+      placement="bottomLeft"
+      title={`点位明细（${score}）`}
+      onOpenChange={(open) => {
+        if (open) void loadDetails();
+      }}
+      content={(
+        <div style={{ width: 380, maxHeight: 360, overflowY: 'auto' }}>
+          {loading || (details === null && loadError === null) ? (
+            <Spin size="small" style={{ display: 'block', margin: '24px auto' }} />
+          ) : loadError ? (
+            <Typography.Text type="danger">明细加载失败，请关闭后重试</Typography.Text>
+          ) : details && details.length > 0 ? details.map((point, index) => {
+            const status = POINT_STATUS_TAG[point.status] ?? {
+              color: 'default', label: point.status,
+            };
+            return (
+              <div
+                key={`${point.coupon_id}-${index}`}
+                style={{
+                  padding: '8px 0',
+                  borderBottom: index < details.length - 1 ? '1px solid #f0f0f0' : undefined,
+                }}
+              >
+                <div style={{ display: 'flex', alignItems: 'flex-start', gap: 12 }}>
+                  <div style={{ flex: 1, minWidth: 0 }}>
+                    <Typography.Text>{point.coupon_name || point.coupon_id}</Typography.Text>
+                    {point.coupon_name ? (
+                      <div><Typography.Text type="secondary">{point.coupon_id}</Typography.Text></div>
+                    ) : null}
+                  </div>
+                  <Tag color={status.color} style={{ marginInlineEnd: 0 }}>{status.label}</Tag>
+                </div>
+                {point.reason ? (
+                  <div style={{ marginTop: 4 }}>
+                    <Typography.Text type="danger">原因：{point.reason}</Typography.Text>
+                  </div>
+                ) : null}
+              </div>
+            );
+          }) : (
+            <Typography.Text type="secondary">暂无点位明细</Typography.Text>
+          )}
+        </div>
+      )}
+    >
+      <Button type="link" size="small" style={{ height: 'auto', padding: 0, color: scoreColor }}>
+        {score}
+      </Button>
+    </Popover>
+  );
+}
+
 // ms → "1.5s"(空值显示 -)
 const fmtSec = (ms: number | null | undefined): string =>
   ms == null ? '-' : `${(ms / 1000).toFixed(1)}s`;
@@ -492,20 +602,10 @@ export default function CouponDataPage() {
       render: (v: number | null) => fmtSec(v),
     },
     {
-      title: '点位成功率',
+      title: '百分比',
       key: 'point_success_rate',
       width: 110,
-      render: (_: unknown, r: CouponDataRow) => (
-        <Tooltip title="当前接口未返回本场应领点位及逐点结果，前端不使用全局均值冒充本场成功率。">
-          {r.trace_url ? (
-            <a href={r.trace_url} target="_blank" rel="noreferrer">
-              查看明细
-            </a>
-          ) : (
-            <Typography.Text type="secondary">待埋点</Typography.Text>
-          )}
-        </Tooltip>
-      ),
+      render: (_: unknown, r: CouponDataRow) => <PointScorePopover row={r} />,
     },
     {
       title: '广告收益',

src/app/(main)/dashboard/page.tsx

@@ -499,12 +499,7 @@ export default function DashboardPage() {
   const tokenCostYuan = periodData?.comparison.token_cost_total_yuan ?? null;
   const couponRewardCoinTotal = periodData?.coins.coupon_reward_coin_total;
   const comparisonRewardCoinTotal = periodData?.coins.comparison_reward_coin_total;
-  const signinCoinTotal = periodData?.coins.signin_coin_total;
-  const signinBoostCoinTotal = periodData?.coins.signin_boost_coin_total;
-  const taskCoinTotal = periodData?.coins.task_coin_total;
-  const regularTaskCoinTotal =
-    periodData?.coins.regular_task_coin_total ??
-    ((signinCoinTotal ?? 0) + (signinBoostCoinTotal ?? 0) + (taskCoinTotal ?? 0));
+  const regularTaskCoinTotal = periodData?.coins.regular_task_coin_total;
   const cpsAvailable = data?.cps.available === true;
   const meituanCpsCommissionCents = data?.cps.meituan_commission_cents;
   const jdCpsCommissionCents = data?.cps.jd_commission_cents;
@@ -1077,6 +1072,7 @@ export default function DashboardPage() {
             value={fmtInt(regularTaskCoinTotal)}
             delta={regularTaskCoinRatio.value}
             deltaTone={regularTaskCoinRatio.tone}
+            hint="每日签到、历史签到膨胀、通知/其他任务、上报更低价和反馈采纳的实发金币之和。"
           />
           <StatCard
             title="本期提现金额"

src/app/(main)/feedbacks/page.tsx

@@ -20,6 +20,7 @@ import type { Dayjs } from 'dayjs';
 import { api } from '@/lib/api';
 import { canDo } from '@/lib/auth';
 import { formatWallTime } from '@/lib/format';
+import { refreshReviewBadge } from '@/lib/reviewBadge';
 import { usePagedList } from '@/lib/usePagedList';
 import type { Feedback, FeedbackSummary } from '@/lib/types';
 import FeedbackHandleDrawer from './FeedbackHandleDrawer';
@@ -431,7 +432,11 @@ export default function FeedbacksPage() {
         feedback={drawerFb}
         open={drawerOpen}
         onClose={() => setDrawerOpen(false)}
-        onDone={() => { reload(); loadSummary(); }}
+        onDone={() => {
+          reload();
+          loadSummary();
+          refreshReviewBadge('/feedbacks');
+        }}
       />
 
       <UserRecordsDrawer<Feedback>

src/app/(main)/layout.tsx

@@ -1,6 +1,6 @@
 'use client';
 
-import { useEffect, useState } from 'react';
+import { useEffect, useRef, useState } from 'react';
 import { usePathname, useRouter } from 'next/navigation';
 import {
   BarChartOutlined,
@@ -25,7 +25,16 @@ import {
 import { Avatar, Dropdown, Layout, Tooltip } from 'antd';
 import { api } from '@/lib/api';
 import { clearAuth, getAdmin, getToken, setAuth } from '@/lib/auth';
-import type { AdminInfo } from '@/lib/types';
+import {
+  REVIEW_BADGE_REFRESH_EVENT,
+  type ReviewBadgeKey,
+} from '@/lib/reviewBadge';
+import type {
+  AdminInfo,
+  FeedbackSummary,
+  PriceReportSummary,
+  WithdrawSummary,
+} from '@/lib/types';
 
 const { Sider, Header, Content } = Layout;
 
@@ -96,6 +105,8 @@ export default function MainLayout({ children }: { children: React.ReactNode })
   const pathname = usePathname();
   const [admin, setAdmin] = useState<AdminInfo | null>(null);
   const [collapsed, setCollapsed] = useState(false);
+  const [pendingReviewCounts, setPendingReviewCounts] = useState<Partial<Record<ReviewBadgeKey, number>>>({});
+  const reviewRefreshVersion = useRef<Partial<Record<ReviewBadgeKey, number>>>({});
 
   useEffect(() => {
     const token = getToken();
@@ -114,6 +125,44 @@ export default function MainLayout({ children }: { children: React.ReactNode })
       .catch(() => {});
   }, [router]);
 
+  useEffect(() => {
+    if (!admin) return;
+    const canAccess = (page: string) =>
+      admin.role === 'super_admin' || !admin.pages || admin.pages.includes(page);
+
+    const refresh = async (key: ReviewBadgeKey) => {
+      if (!canAccess(key.slice(1))) return;
+      const version = (reviewRefreshVersion.current[key] ?? 0) + 1;
+      reviewRefreshVersion.current[key] = version;
+      let count: number;
+      if (key === '/withdraws') {
+        count = (await api.get<WithdrawSummary>('/admin/api/withdraws/summary')).data.reviewing_count;
+      } else if (key === '/price-reports') {
+        count = (await api.get<PriceReportSummary>('/admin/api/price-reports/summary')).data.pending;
+      } else {
+        count = (await api.get<FeedbackSummary>('/admin/api/feedbacks/summary')).data.pending;
+      }
+      if (reviewRefreshVersion.current[key] !== version) return;
+      setPendingReviewCounts((current) => ({ ...current, [key]: count }));
+    };
+
+    const refreshSafely = (key: ReviewBadgeKey) => refresh(key).catch(() => {});
+    void Promise.all([
+      refreshSafely('/withdraws'),
+      refreshSafely('/price-reports'),
+      refreshSafely('/feedbacks'),
+    ]);
+
+    const onReviewCompleted = (event: Event) => {
+      const key = (event as CustomEvent<ReviewBadgeKey>).detail;
+      if (key) void refreshSafely(key);
+    };
+    window.addEventListener(REVIEW_BADGE_REFRESH_EVENT, onReviewCompleted);
+    return () => {
+      window.removeEventListener(REVIEW_BADGE_REFRESH_EVENT, onReviewCompleted);
+    };
+  }, [admin]);
+
   if (!admin) return null; // 守卫期间不闪烁内容
 
   // 选中态:取路径一级(/users/123 -> /users)
@@ -132,6 +181,20 @@ export default function MainLayout({ children }: { children: React.ReactNode })
     hasChildren(group) ? group.children : [group],
   );
 
+  const reviewBadge = (key: string) => {
+    const count = pendingReviewCounts[key as ReviewBadgeKey] ?? 0;
+    if (count <= 0) return null;
+    return (
+      <span
+        className="nav-review-badge"
+        aria-label={`${count} 条未审核`}
+        title={`${count} 条未审核`}
+      >
+        {count}
+      </span>
+    );
+  };
+
   const logout = () => {
     clearAuth();
     router.replace('/login');
@@ -166,6 +229,7 @@ export default function MainLayout({ children }: { children: React.ReactNode })
                     aria-label={item.label}
                   >
                     {item.icon}
+                    {reviewBadge(item.key)}
                   </button>
                 </Tooltip>
               ))
@@ -183,7 +247,8 @@ export default function MainLayout({ children }: { children: React.ReactNode })
                       onClick={() => router.push(group.key)}
                     >
                       <span className="nav-primary-icon">{group.icon}</span>
-                      <span>{group.label}</span>
+                      <span className="nav-item-label">{group.label}</span>
+                      {reviewBadge(group.key)}
                     </button>
                   );
                 }
@@ -202,7 +267,8 @@ export default function MainLayout({ children }: { children: React.ReactNode })
                           onClick={() => router.push(child.key)}
                         >
                           <span className="nav-child-icon">{child.icon}</span>
-                          <span>{child.label}</span>
+                          <span className="nav-item-label">{child.label}</span>
+                          {reviewBadge(child.key)}
                         </button>
                       ))}
                     </div>
@@ -269,6 +335,29 @@ export default function MainLayout({ children }: { children: React.ReactNode })
           color: rgba(255, 255, 255, 0.72);
           font-size: 16px;
         }
+        .nav-item-label {
+          min-width: 0;
+          flex: 1;
+        }
+        .nav-review-badge {
+          display: inline-flex;
+          align-items: center;
+          justify-content: center;
+          box-sizing: border-box;
+          flex: 0 0 auto;
+          min-width: 18px;
+          height: 18px;
+          padding: 0 5px;
+          border-radius: 9px;
+          background: #ff4d4f;
+          color: #fff;
+          font-size: 11px;
+          font-weight: 600;
+          line-height: 18px;
+          white-space: nowrap;
+          font-variant-numeric: tabular-nums;
+          box-shadow: 0 0 0 1px rgba(0, 0, 0, 0.08);
+        }
         .nav-direct,
         .nav-child,
         .nav-icon-button {
@@ -332,6 +421,7 @@ export default function MainLayout({ children }: { children: React.ReactNode })
           padding: 0 8px 14px;
         }
         .nav-icon-button {
+          position: relative;
           display: inline-flex;
           align-items: center;
           justify-content: center;
@@ -342,6 +432,11 @@ export default function MainLayout({ children }: { children: React.ReactNode })
           color: rgba(255, 255, 255, 0.72);
           font-size: 17px;
         }
+        .nav-icon-button .nav-review-badge {
+          position: absolute;
+          top: 1px;
+          right: -6px;
+        }
         .nav-icon-button:hover,
         .nav-icon-button.is-selected {
           background: #1677ff;

src/app/(main)/price-reports/page.tsx

@@ -22,6 +22,7 @@ import dayjs from 'dayjs';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
 import { mediaUrl } from '@/lib/media';
+import { refreshReviewBadge } from '@/lib/reviewBadge';
 import { usePagedList } from '@/lib/usePagedList';
 import type { PriceReport, PriceReportSummary } from '@/lib/types';
 import UserRecordsDrawer from '@/components/UserRecordsDrawer';
@@ -202,6 +203,7 @@ export default function PriceReportsPage() {
       onOk: async () => {
         try {
           await api.post(`/admin/api/price-reports/${r.id}/approve`);
+          refreshReviewBadge('/price-reports');
           message.success('已通过，已发放 1000 金币');
           refreshAfterChange();
         } catch (e) {
@@ -220,6 +222,7 @@ export default function PriceReportsPage() {
     }
     try {
       await api.post(`/admin/api/price-reports/${rejecting.id}/reject`, { reason });
+      refreshReviewBadge('/price-reports');
       message.success('已拒绝');
       setRejecting(null);
       setRejectReason('');

src/app/(main)/withdraws/page.tsx

@@ -39,6 +39,7 @@ import dayjs, { type Dayjs } from 'dayjs';
 import { api, errMsg } from '@/lib/api';
 import { canDo } from '@/lib/auth';
 import { formatUtcTime, utcDayjs, utcFromNow, yuan } from '@/lib/format';
+import { refreshReviewBadge } from '@/lib/reviewBadge';
 import { usePagedList } from '@/lib/usePagedList';
 import type {
   AuditLog,
@@ -332,6 +333,7 @@ export default function WithdrawsPage() {
       onOk: async () => {
         try {
           await api.post(`/admin/api/withdraws/${o.out_bill_no}/approve`);
+          refreshReviewBadge('/withdraws');
           message.success('已通过审核并发起打款');
           await refreshAfterChange(o.out_bill_no);
         } catch (e) {
@@ -362,6 +364,7 @@ export default function WithdrawsPage() {
         await api.post(`/admin/api/withdraws/${targets[0].out_bill_no}/reject`, { reason: trimmed });
         message.success('已拒绝并退回余额');
       }
+      refreshReviewBadge('/withdraws');
       setRejecting(null);
       setBulkRejecting([]);
       setRejectReason('');
@@ -400,6 +403,7 @@ export default function WithdrawsPage() {
           const { data } = await api.post<WithdrawBulkResult>('/admin/api/withdraws/bulk/approve', {
             out_bill_nos: selectedReviewing.map((item) => item.out_bill_no),
           });
+          refreshReviewBadge('/withdraws');
           const text = bulkResultText('批量通过完成', data);
           if (data.failed) message.warning(text);
           else message.success(text);

src/lib/reviewBadge.ts

@@ -0,0 +1,10 @@
+export type ReviewBadgeKey = '/withdraws' | '/price-reports' | '/feedbacks';
+
+export const REVIEW_BADGE_REFRESH_EVENT = 'review-badge-refresh';
+
+export function refreshReviewBadge(key: ReviewBadgeKey) {
+  if (typeof window === 'undefined') return;
+  window.dispatchEvent(
+    new CustomEvent<ReviewBadgeKey>(REVIEW_BADGE_REFRESH_EVENT, { detail: key }),
+  );
+}

src/lib/types.ts

@@ -364,6 +364,25 @@ export interface ComparisonRecordListItem {
   created_at: string;
 }
 
+export interface ComparisonRecordsSummary {
+  started: number;
+  completed: number;
+  success: number;
+  success_rate: number | null;
+  avg_token_cost: number | null;
+  lower_price_rate: number | null;
+  avg_duration_ms: number | null;
+  p5_duration_ms: number | null;
+  p50_duration_ms: number | null;
+  p95_duration_ms: number | null;
+  p99_duration_ms: number | null;
+  cancelled: number;
+  cancelled_rate: number | null;
+  cancelled_p5_ms: number | null;
+  cancelled_p50_ms: number | null;
+  cancelled_p95_ms: number | null;
+}
+
 // 单次 LLM 调用明细(pricebot chat() 收口落盘,server 按 trace 拉来)
 export interface LlmCall {
   ts?: number;
@@ -469,7 +488,7 @@ export interface AdRevenueRow {
   has_impression: boolean; // 是否有广告展示(信息流逐条展示=true,纯发奖行=false)
   impressions: number; // 本行展示条数 1/0(供日汇总、趋势图复用)
   ecpm: string | null; // 分/千次;展示行取展示值,纯发奖行取发奖采用值
-  revenue_yuan: number; // 本次展示预估收益(元);纯发奖行=0
+  revenue_yuan: number; // 本次有效展示预估收益(元);纯发奖、激励视频提前关闭/时长不足=0
   row_revenue_yuan?: number | null; // 主表逐行显示用:一次比价/领券聚合行=该次发奖广告 eCPM 折算之和;其它行空(回退 revenue_yuan)
   adn: string | null; // 实际填充 ADN;纯发奖行为空
   slot_id: string | null; // 底层 mediation rit;纯发奖行为空