修复：业务收益详情继承广告收益筛选口径

修复：统一领券与比价广告数百分位口径 (#92 )
## 改动说明 - 将单次领券、比价广告数从线性插值百分位改为 nearest-rank 离散百分位 - 百分位结果始终取自真实观测样本，不再出现 13.5 条这类小数广告数 - 指标展示改为整数 ## 线上数据复算 2026-07-24 正式业务口径： - 领券 P5/P50/P95：`1/7/13.5` 修正为 `1/7/15` - 比价 P5/P50/P95：`1/2/8.3` 修正为 `1/2/9` ## 验证 - 线上数据完整分组复算通过 - 空样本、单样本边界校验通过 - `npm run build` 通过（含 TypeScript 类型检查） --------- Co-authored-by: guke <guke@wonderable.ai> Co-authored-by: linkeyu <798648091@qq.com> Reviewed-on: #92 Co-authored-by: linkeyu <linkeyu@wonderable.ai> Co-committed-by: linkeyu <linkeyu@wonderable.ai>
2026-07-28 13:55:17 +08:00 · 2026-07-28 13:50:40 +08:00 · 2026-07-28 13:50:14 +08:00
5 changed files with 106 additions and 19 deletions
@@ -32,9 +32,24 @@ interface Props {
  onClose: () => void;
  userId: number | null;
  phone: string | null; // 报表行已有的手机号:概览拉取失败时兜底展示
+  dateFrom: string | null;
+  dateTo: string | null;
+  appEnv?: 'prod' | 'test';
+  revenueScope: 'business' | 'all';
+  feedScene?: 'comparison' | 'coupon' | 'welfare';
 }

-export default function UserAdRevenueDrawer({ open, onClose, userId, phone }: Props) {
+export default function UserAdRevenueDrawer({
+  open,
+  onClose,
+  userId,
+  phone,
+  dateFrom,
+  dateTo,
+  appEnv,
+  revenueScope,
+  feedScene,
+}: Props) {
  // UserRewardPanel 的 user 快照:它只读 phone/nickname/wechat_nickname/created_at,其余按 snapshot 形状补齐。
  const [user, setUser] = useState<WithdrawUserSnapshot | null>(null);

@@ -82,7 +97,19 @@ export default function UserAdRevenueDrawer({ open, onClose, userId, phone }: Pr
    >
      {/* userId 就绪即渲染;UserRewardPanel 内部按 userId 自行拉统计与金币记录,user 基本信息随后补上。
          statsVariant="ad":统计区只显示 6 项看广告统计(累计提现/现金余额/激励视频观看数+eCPM/draw观看数+eCPM) */}
-      {userId != null && <UserRewardPanel userId={userId} user={user} statsVariant="ad" />}
+      {userId != null && (
+        <UserRewardPanel
+          key={`${userId}-${dateFrom}-${dateTo}-${appEnv}-${revenueScope}-${feedScene}`}
+          userId={userId}
+          user={user}
+          statsVariant="ad"
+          initialDateFrom={dateFrom ?? undefined}
+          initialDateTo={dateTo ?? undefined}
+          appEnv={appEnv}
+          revenueScope={revenueScope}
+          feedScene={feedScene}
+        />
+      )}
    </Drawer>
  );
 }
@@ -30,7 +30,7 @@ import {
 } from '@ant-design/icons';
 import dayjs, { type Dayjs } from 'dayjs';
 import { api, errMsg } from '@/lib/api';
-import { formatUtcTime, percentile } from '@/lib/format';
+import { formatUtcTime, nearestRankPercentile } from '@/lib/format';
 import type {
  AdRevenueDaily,
  AdRevenueHourly,
@@ -470,7 +470,27 @@ export default function AdRevenueReportPage() {
  const [loading, setLoading] = useState(false);
  const [formulaOpen, setFormulaOpen] = useState(false);
  // 点用户手机号弹出的「用户广告收益详情」半屏抽屉(userId + 手机号;null=关闭)
-  const [userDrawer, setUserDrawer] = useState<{ userId: number; phone: string | null } | null>(null);
+  const [userDrawer, setUserDrawer] = useState<{
+    userId: number;
+    phone: string | null;
+    dateFrom: string;
+    dateTo: string;
+    appEnv?: 'prod' | 'test';
+    revenueScope: 'business' | 'all';
+    feedScene?: 'comparison' | 'coupon' | 'welfare';
+  } | null>(null);
+  const [queriedDetailFilters, setQueriedDetailFilters] = useState<{
+    dateFrom: string;
+    dateTo: string;
+    appEnv?: 'prod' | 'test';
+    revenueScope: 'business' | 'all';
+    feedScene?: 'comparison' | 'coupon' | 'welfare';
+  }>({
+    dateFrom: range[0].format('YYYY-MM-DD'),
+    dateTo: range[1].format('YYYY-MM-DD'),
+    appEnv: 'prod',
+    revenueScope: 'business',
+  });

  // 当前选择是否跨多天:跨多天时「按小时」无意义,粒度强制按天
  const rangeMultiDay = range[0].format('YYYY-MM-DD') !== range[1].format('YYYY-MM-DD');
@@ -503,6 +523,13 @@ export default function AdRevenueReportPage() {
          },
        });
        setData(res.data);
+        setQueriedDetailFilters({
+          dateFrom: from,
+          dateTo: to,
+          appEnv: appEnv === 'all' ? undefined : appEnv,
+          revenueScope,
+          feedScene: scene as 'comparison' | 'coupon' | 'welfare' | undefined,
+        });
        setPage(targetPage);
        setQueriedLimit(targetLimit);
        setQueriedGranularity(gran);
@@ -551,7 +578,7 @@ export default function AdRevenueReportPage() {
      width: 150,
      render: (phone: string | null, r: AdRevenueRow) => (
        // 点手机号/用户 → 打开该用户「广告收益详情」半屏抽屉(统计卡 + 金币记录)
-        <a onClick={() => setUserDrawer({ userId: r.user_id, phone })}>
+        <a onClick={() => setUserDrawer({ userId: r.user_id, phone, ...queriedDetailFilters })}>
          {phone ? (
            <span>
              {phone}
@@ -758,9 +785,9 @@ export default function AdRevenueReportPage() {
        .filter((item) => item.feed_scene === sceneName)
        .map((item) => item.sub_count ?? 1);
      return {
-        p5: percentile(counts, 0.05, false),
-        p50: percentile(counts, 0.5, false),
-        p95: percentile(counts, 0.95, false),
+        p5: nearestRankPercentile(counts, 0.05),
+        p50: nearestRankPercentile(counts, 0.5),
+        p95: nearestRankPercentile(counts, 0.95),
      };
    };
    return { coupon: summarize('coupon'), comparison: summarize('comparison') };
@@ -1083,12 +1110,12 @@ export default function AdRevenueReportPage() {
            </Typography.Text>
          </Divider>
          <Row gutter={[16, 12]}>
-            <Col span={4}><Statistic title="单次领券广告数 P5" value={sessionAdCounts.coupon.p5 ?? '-'} precision={1} /></Col>
-            <Col span={4}><Statistic title="单次领券广告数 P50" value={sessionAdCounts.coupon.p50 ?? '-'} precision={1} /></Col>
-            <Col span={4}><Statistic title="单次领券广告数 P95" value={sessionAdCounts.coupon.p95 ?? '-'} precision={1} /></Col>
-            <Col span={4}><Statistic title="单次比价广告数 P5" value={sessionAdCounts.comparison.p5 ?? '-'} precision={1} /></Col>
-            <Col span={4}><Statistic title="单次比价广告数 P50" value={sessionAdCounts.comparison.p50 ?? '-'} precision={1} /></Col>
-            <Col span={4}><Statistic title="单次比价广告数 P95" value={sessionAdCounts.comparison.p95 ?? '-'} precision={1} /></Col>
+            <Col span={4}><Statistic title="单次领券广告数 P5" value={sessionAdCounts.coupon.p5 ?? '-'} precision={0} /></Col>
+            <Col span={4}><Statistic title="单次领券广告数 P50" value={sessionAdCounts.coupon.p50 ?? '-'} precision={0} /></Col>
+            <Col span={4}><Statistic title="单次领券广告数 P95" value={sessionAdCounts.coupon.p95 ?? '-'} precision={0} /></Col>
+            <Col span={4}><Statistic title="单次比价广告数 P5" value={sessionAdCounts.comparison.p5 ?? '-'} precision={0} /></Col>
+            <Col span={4}><Statistic title="单次比价广告数 P50" value={sessionAdCounts.comparison.p50 ?? '-'} precision={0} /></Col>
+            <Col span={4}><Statistic title="单次比价广告数 P95" value={sessionAdCounts.comparison.p95 ?? '-'} precision={0} /></Col>
          </Row>
        </Card>
      )}
@@ -1284,6 +1311,11 @@ export default function AdRevenueReportPage() {
        open={!!userDrawer}
        userId={userDrawer?.userId ?? null}
        phone={userDrawer?.phone ?? null}
+        dateFrom={userDrawer?.dateFrom ?? null}
+        dateTo={userDrawer?.dateTo ?? null}
+        appEnv={userDrawer?.appEnv}
+        revenueScope={userDrawer?.revenueScope ?? 'all'}
+        feedScene={userDrawer?.feedScene}
        onClose={() => setUserDrawer(null)}
      />
    </div>
@@ -44,6 +44,11 @@ interface Props {
  withdrawSource?: 'coin_cash' | 'invite_cash';
  // 统计区字段集:withdraw(默认,提现详情:含提现细分) / ad(广告收益详情:只看看广告观看统计,对齐参考图 6 项)
  statsVariant?: 'withdraw' | 'ad';
+  initialDateFrom?: string;
+  initialDateTo?: string;
+  appEnv?: 'prod' | 'test';
+  revenueScope?: 'business' | 'all';
+  feedScene?: 'comparison' | 'coupon' | 'welfare';
 }

 /** 用户看广告/提现详情:基本信息 + 互斥时间筛选 + 统计区(按 statsVariant 取字段集)+ 金币发放记录表。 */
@@ -52,9 +57,17 @@ export default function UserRewardPanel({
  user,
  withdrawSource,
  statsVariant = 'withdraw',
+  initialDateFrom,
+  initialDateTo,
+  appEnv,
+  revenueScope = 'all',
+  feedScene,
 }: Props) {
-  const [mode, setMode] = useState<'all' | 'range'>('all'); // all=注册至今 / range=自定义区间
-  const [range, setRange] = useState<[Dayjs, Dayjs] | null>(null);
+  const hasInitialRange = Boolean(initialDateFrom && initialDateTo);
+  const [mode, setMode] = useState<'all' | 'range'>(hasInitialRange ? 'range' : 'all');
+  const [range, setRange] = useState<[Dayjs, Dayjs] | null>(() =>
+    hasInitialRange ? [dayjs(initialDateFrom), dayjs(initialDateTo)] : null,
+  );
  const [stats, setStats] = useState<UserRewardStats | null>(null);
  const [statsLoading, setStatsLoading] = useState(false);

@@ -80,6 +93,9 @@ export default function UserRewardPanel({
        params: {
          ...JSON.parse(paramsKey),
          ...(withdrawSource ? { withdraw_source: withdrawSource } : {}),
+          ...(appEnv ? { app_env: appEnv } : {}),
+          revenue_scope: revenueScope,
+          ...(feedScene ? { feed_scene: feedScene } : {}),
        },
      });
      setStats(data);
@@ -88,7 +104,7 @@ export default function UserRewardPanel({
    } finally {
      setStatsLoading(false);
    }
-  }, [userId, paramsKey, withdrawSource]);
+  }, [userId, paramsKey, withdrawSource, appEnv, revenueScope, feedScene]);

  const loadRecords = useCallback(
    async (p: number) => {
@@ -236,7 +252,7 @@ export default function UserRewardPanel({
      </Descriptions>
      <Text type="secondary" style={{ fontSize: 12 }}>
        {statsVariant === 'ad'
-          ? '统计随上方时间筛选(现金余额除外,为当前快照);次数仅统计成功发奖记录,信息流按奖励份数统计;eCPM 为预估值。'
+          ? '统计继承广告收益页已查询的日期、环境、业务代码位和场景;次数仅统计成功发奖记录,信息流按奖励份数统计;Draw eCPM 按全部实际展示统计(含未发奖)。'
          : '统计随上方时间筛选(现金余额除外,为当前快照);提现按申请提交时间统计;累计收益为已发金币按当前汇率折算,不代表实际已提现金额;eCPM 为预估值。'}
      </Text>

@@ -37,6 +37,18 @@ export function percentile(values: readonly number[], q: number, round = true):
  return round ? Math.round(result) : result;
 }

+/**
+ * 离散计数分位数（nearest-rank）。
+ * 广告条数等不可拆分的计数不做线性插值，结果始终取自真实样本。
+ */
+export function nearestRankPercentile(values: readonly number[], q: number): number | null {
+  if (!values.length) return null;
+  const sorted = [...values].sort((a, b) => a - b);
+  const quantile = Math.min(1, Math.max(0, q));
+  const rank = Math.max(1, Math.ceil(quantile * sorted.length));
+  return sorted[rank - 1];
+}
+
 const hasTz = (v: string) => /(?:Z|[+-]\d{2}:?\d{2})$/i.test(v);

 /** 把 UTC 口径字符串解析为带时区的 dayjs(无时区后缀的补 Z 当 UTC)。 */
@@ -233,7 +233,7 @@ export interface UserRewardStats {
  reward_video_avg_ecpm: number; // 平均激励视频 eCPM(分/千次)
  reward_video_cash_cents: number; // 激励视频提现
  feed_count: number; // 累计信息流广告数(份)
-  feed_avg_ecpm: number; // 平均信息流广告 eCPM(分/千次)
+  feed_avg_ecpm: number; // 全部 Draw/feed 实际展示的平均 eCPM(分/千次,含未发奖展示)
  feed_cash_cents: number; // 信息流广告提现
 }