浅念 acd6997bf0 fix(groups): 排序终判——owner 二进制字符串序(云客逐位吻合),弃 list_order ...

上版按 list_order 排不对:云客员工列表序 ≠ 群统计页员工序。真机对照
切换点员工终判:群统计员工顺序 = owner(微信号/wxid 混存)的**区分大小写
二进制字符串升序**(Nancyjade < csf7169708 < wxid_01gv…,大写在小写前,
逐位吻合),组内 room_id 字符串升序。COLLATE BINARY 双库通用,且无需
JOIN wechat_account。

726 测试绿。

Co-Authored-By: Claude Code <noreply@anthropic.com>

2026-09-10 14:23:43 +08:00

..

cassettes

feat(api): 长语音 voice_clip 后端(model+migration+scraper+sync+endpoint)

2026-08-10 18:12:28 +08:00

__init__.py

feat: db base + config tests

2026-08-01 11:04:44 +08:00

conftest.py

feat(management): 批次A六表模型——fact/宽表/通话小表+评分配置/快照/辅导

2026-09-09 12:04:54 +08:00

test_analytics_api.py

feat(analytics): 管理层指标呈现——首响回复率上墙/客户资产总览/自定义日期/排行五新列

2026-09-07 14:41:08 +08:00

test_analytics_churn_unreplied.py

fix(analytics): unreplied is_send守卫防漂移假行+真预算注释+501候选分支测试

2026-09-04 19:22:22 +08:00

test_analytics_models.py

feat(analytics): 数据分析板块四新表+迁移——stat_daily_staff/敏感词三表/fetched_at 索引

2026-09-04 15:04:33 +08:00

test_analytics_overview.py

feat(analytics): 管理层指标呈现——首响回复率上墙/客户资产总览/自定义日期/排行五新列

2026-09-07 14:41:08 +08:00

test_api_auth.py

feat: simple shared-token api auth

2026-08-01 14:30:28 +08:00

test_api_calls.py

feat(calls): 微信语音列表加今日统计卡片+通话时间范围筛选+客户跳转带通话时间定位(对齐云客)

2026-08-20 11:08:13 +08:00

test_api_customer.py

fix(api): 客户/群排序改回last_chat_time DESC(云客按最近沟通优先)

2026-08-15 14:18:42 +08:00

test_api_customers.py

fix(wa-customers): link 路径 LEFT JOIN 档案带 raw_json——WA 好友列表列空白

2026-09-09 14:08:44 +08:00

test_api_export.py

feat(staff-friends): 员工客户列表独立页——对齐云客员工详情,好友数/微信群数下钻

2026-09-08 16:14:44 +08:00

test_api_groups.py

fix(groups): 排序终判——owner 二进制字符串序(云客逐位吻合),弃 list_order

2026-09-10 14:23:43 +08:00

test_api_login.py

feat(auth): 登录页(用户名/密码换 API token)+ 前端全链路登录态

2026-09-03 15:03:20 +08:00

test_api_media.py

fix(security): 路径穿越防护+导出行数上限+并发同步锁(3 critical/important)

2026-08-12 10:37:13 +08:00

test_api_messages.py

fix(messages): 聊天记录大对话超时——DESC首屏+keyset游标+群聊直达索引

2026-09-07 16:59:04 +08:00

test_api_moments.py

test(moments): 同create_time并列时按id升序tiebreak测试(锁分页稳定契约,任务6评审遗留)

2026-08-25 16:22:44 +08:00

test_api_organization.py

feat(api): sessions加is_del过滤+filehelper置顶标记,accounts加avatar(raw_json提取)

2026-08-25 15:44:54 +08:00

test_api_search.py

feat(search): FTS5 trigram全文索引(中文搜索3.95s→0.003s,1300倍)

2026-08-21 15:08:26 +08:00

test_api_sessions.py

fix(names): 会话/统计弹窗/zip 文件名的共享好友昵称读 link 快照

2026-09-09 11:44:58 +08:00

test_api_sms.py

feat: full-field display for group/call/sms (raw_json + drawers)

2026-08-05 10:12:49 +08:00

test_api_staff_chat_stats.py

refactor(api): staff-chat-stats 确定性排序 + last_is_send=None 分支测试 + 类型标注

2026-08-07 18:37:26 +08:00

test_api_staff_stats.py

fix(staff-stats): 统计tab新客户/删除客户/红包昵称切 link——共享好友不再漏计

2026-09-09 13:45:42 +08:00

test_api_summary_paths.py

perf(api): 会话/5数字弹窗超时修复——日粒度汇总层 msg_daily_stats

2026-09-03 16:37:36 +08:00

test_api_sync.py

feat: backend read api for all entities (messages/groups/calls/sms/org/sync)

2026-08-01 16:15:40 +08:00

test_api_voice_clips.py

fix(security): CORS限制+SSRF防护+PATCH乐观锁+accounts安全cap(4 important bugs)

2026-08-12 11:41:30 +08:00

test_auto_relogin.py

feat(scraper): cookie 过期自动续期——浏览器表单重登+缓存+整实体重跑

2026-09-03 18:11:26 +08:00

test_config.py

fix(tests): 更新风控参数断言匹配新默认值(2.0/2.5/300/5-120/6)

2026-08-12 10:41:46 +08:00

test_db_base.py

feat: db base + config tests

2026-08-01 11:04:44 +08:00

test_db_fts.py

feat(search): FTS5 trigram全文索引(中文搜索3.95s→0.003s,1300倍)

2026-08-21 15:08:26 +08:00

test_employee_metrics.py

fix(management): 宽表生命周期hist改时点语义(≤as_of累积)——历史日dormant不再被未来消息虚增;补正向同源/percentile None判别+防御性flush

2026-09-09 14:44:35 +08:00

test_first_reply_facts.py

fix(management): first_reply_fact 同毫秒并列主键冲突+定序抖动——reply_msg_id 进 PK/按(ts,msg_id)排序

2026-09-09 13:18:08 +08:00

test_freshness_indexes.py

perf(analytics): 5表 updated_at 窄索引——health MAX 消除全表扫(128MB buffer pool)

2026-09-04 16:40:01 +08:00

test_lifecycle.py

feat(management): 生命周期判定纯函数——距今天数口径/7天新客/30天沉睡/历史门槛5条

2026-09-09 13:37:22 +08:00

test_management_anomalies.py

feat(management): 确定性异常规则×4——P90恶化/回复率骤降/活动骤降/过载+derive_metrics公有化

2026-09-09 18:06:08 +08:00

test_management_api.py

feat(management): 驾驶舱KPI环比(prev_kpis+delta)+异常卡带员工名跳详情+列表进详情带筛选

2026-09-10 12:20:28 +08:00

test_management_models.py

fix(management): first_reply_fact 同毫秒并列主键冲突+定序抖动——reply_msg_id 进 PK/按(ts,msg_id)排序

2026-09-09 13:18:08 +08:00

test_management_period_metrics.py

feat(management): 评分引擎——三类标准化/维度归一/样本保护/等级/四对比明细+期末active_friends接口修订

2026-09-09 17:42:57 +08:00

test_management_scoring.py

docs(management): 批次B终评收尾——validate_config补源名唯一性+遗留观察项归档

2026-09-09 19:28:48 +08:00

test_media_downloader.py

feat: media downloader + serve api

2026-08-01 14:13:50 +08:00

test_message_images_downloader.py

fix(media): image_legacy渲染+下载覆盖+WA raw_json URL回退

2026-08-13 14:02:42 +08:00

test_models.py

feat(db): moments_post 表+upsert(朋友圈实体,PK=云客data.id,create_time统一ms)

2026-08-25 13:44:54 +08:00

test_object_store.py

feat: idempotent upsert repos + object store

2026-08-01 11:55:50 +08:00

test_orchestrator.py

test: orchestrator voice sync skip/passthrough 路径覆盖

2026-08-07 09:57:34 +08:00

test_parsers.py

feat: whatsapp account/friend/message scrapers

2026-08-01 15:48:03 +08:00

test_recording_downloader.py

feat(scraper): download_call_recordings 下载通话录音到本地 Media + 回写 record_media_hash

2026-08-07 16:30:29 +08:00

test_repos.py

feat(link): customer_account_link 账号↔客户多对多——共享好友员工维度对齐云客

2026-09-08 17:17:06 +08:00

test_scheduler_analytics_tick.py

feat(management): 4h分析链接入管理域滚动段——独立事务隔离/fact活跃会话+宽表+通话滚动3天

2026-09-10 13:59:44 +08:00

test_scrape_auth_guard.py

fix(scraper): 云客鉴权失败信封统一拦截——cookie 过期响亮报错不再静默

2026-09-03 17:52:09 +08:00

test_scrape_base.py

feat: wechat friend scraper

2026-08-01 11:31:28 +08:00

test_scrape_calls.py

feat: phone-call + sms scrapers

2026-08-01 15:59:25 +08:00

test_scrape_departments.py

feat: department + wechat account/staff scrapers

2026-08-01 13:46:23 +08:00

test_scrape_group_messages.py

feat(scraper): 微信群消息抓取(368778条/750群)+浏览器守护循环+SQLite忙等

2026-08-20 09:09:32 +08:00

test_scrape_moments.py

feat(scraper): moments 实体(浏览器fetch getFriendsterInfo,秒→ms,hashNext翻页,接入full_sync+4h调度+图片media)

2026-08-25 14:07:39 +08:00

test_scrape_msg_type.py

feat(msg): 类型归一化扩展(spike判别+49拆红包/转账)+存量回填+API msg_type/q过滤

2026-08-25 15:17:21 +08:00

test_scrape_via_page_pagination.py

feat(scraper): 微信消息翻页取完整历史(paginate_chats hasLast/end游标+200页上限,移除临时skip;全量回填3478对话+95361条至2025-10)

2026-08-18 09:15:04 +08:00

test_scrape_voice_clips.py

feat(api): 长语音 voice_clip 后端(model+migration+scraper+sync+endpoint)

2026-08-10 18:12:28 +08:00

test_scrape_wa_group_messages.py

feat(scraper): WA群消息抓取(chatRecords friendUid=@g.us,chatRoomTalker=群内发送者)

2026-08-20 10:54:09 +08:00

test_scrape_wa_voice_calls.py

fix(scraper): voice body 加 departmentId/isRoom/时间窗 + sync 解析 root department_id

2026-08-07 09:49:31 +08:00

test_scrape_wechat_accounts.py

fix: wechat account scrape (form-data+dates) + frontend staff page

2026-08-01 17:11:17 +08:00

test_scrape_wechat_friends.py

feat(scraper): map customer add_time from raw_json

2026-08-05 18:44:04 +08:00

test_scrape_wechat_groups.py

feat(groups): chat_group 补 6 群主/建群列 + 复合PK迁移修复 + 存量回填

2026-08-25 14:32:12 +08:00

test_scrape_wechat_messages_group.py

feat: wechat voice-call scraper + group message coverage

2026-08-01 14:03:47 +08:00

test_scrape_wechat_messages.py

feat: RSA login encryption + confirmed wechat type codes

2026-08-01 13:37:42 +08:00

test_scrape_wechat_talkers.py

feat: wechat group+member and talker scrapers

2026-08-01 13:54:16 +08:00

test_scrape_wechat_voice_calls.py

fix(scraper): voice body 加 departmentId/isRoom/时间窗 + sync 解析 root department_id

2026-08-07 09:49:31 +08:00

test_scrape_whatsapp_accounts.py

feat: whatsapp account/friend/message scrapers

2026-08-01 15:48:03 +08:00

test_scrape_whatsapp_friends.py

fix: whatsapp businessFriendList needs page+departmentId+type

2026-08-01 17:53:26 +08:00

test_scrape_whatsapp_groups.py

feat(scraper): WA 群 scraper(businessFriendList+type=1,待风控重置后实测)

2026-08-11 16:04:03 +08:00

test_scrape_whatsapp_messages.py

feat: whatsapp account/friend/message scrapers

2026-08-01 15:48:03 +08:00

test_sensitive.py

fix(analytics): run_full水位前置防回填窗口漏扫+README/DEPLOY/脚本号收尾

2026-09-04 23:27:41 +08:00

test_smoke_script.py

chore: wechat end-to-end smoke script

2026-08-01 12:16:02 +08:00

test_staff_summary.py

feat(analytics): 首响时长+回复率数据管道——消息串算法/日汇总扩展列/员工聚合

2026-09-07 14:13:09 +08:00

test_summary_daily_stats.py

feat(analytics): 首响时长+回复率数据管道——消息串算法/日汇总扩展列/员工聚合

2026-09-07 14:13:09 +08:00

test_sync_call_recordings.py

chore(sync): Task 3 review fixes——删未用 import + module docstring 诚实化 + repr(exc) 一致 + 批处理 guard

2026-08-07 16:51:10 +08:00

test_sync_cli.py

feat: scheduler + CLI + docker-compose + README

2026-08-05 12:11:29 +08:00

test_sync_scheduler.py

fix(sync): 同步链路审计修复——水位边界白拉/全量无超时/群活跃窗判定源

2026-09-10 11:08:15 +08:00

test_watermarks.py

feat: incremental sync orchestrator + watermarks

2026-08-01 14:23:45 +08:00

test_yunke_client_stealth.py

fix(tests): 更新风控参数断言匹配新默认值(2.0/2.5/300/5-120/6)

2026-08-12 10:41:46 +08:00

test_yunke_client.py

fix: drop source header (breaks msg/chats) + context-aware talker_id

2026-08-01 16:52:48 +08:00