SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

user_id

INTEGER

op_type

INTEGER

act_user_id

INTEGER

repo_id

INTEGER

comment_id

INTEGER

is_deleted

INTEGER NOT NULL (default 0

ref_name

TEXT

is_private

INTEGER NOT NULL (default 0

content

{"Commits":[{"Sha1":"0ebe6fb5c4cc802d6d6f53fba830ec5fbf64f3d7","Message":"fix(field-contract): P1 批次十三条收口——键名/量纲映射级断链修复\n\n响应侧映射修复：\n- campaigns：getCampaignStats 从后端真实 {overview,channels} 派生 summary/channelBreakdown\n  （渠道真数据此前被键名错位丢弃恒空）；getStats 分组数组转对象（业务线 Tab 计数恒 0）+\n  totalSpent 键对齐\n- leads /:id/score：拆分 controller 回完整评分对象（此前与 /score-details 共用剥壳 handler\n  只回裸数组，评分卡恒 0 分）；shared 类型补 calculatedAt 真源键并重建 dist\n- tickets：stage-history 路由接 ticket_stage_history 真源 handler（此前 alias 到 timeline\n  被旁路，渲染「初始状态：undefined」）；getReplies 补 adapter（回复人恒 '-' 修复）\n- satisfaction /analytics：adapter 归一 responseRate/avgCSAT/avgNPS/npsBreakdown\n  （分析页半页恒 '-'）；情感分布/类型统计无后端真源，保持 undefined 失败关闭\n- commissions：my-stats adapter（四张统计卡恒 ¥0）；listRecords/getMyRecords/\n  getSettlementById 补 user/rule/settlement/records DTO 映射（含 org_units 部门），\n  顺手修掉 where 层 camel 死键（userId/businessDate 等触发 Prisma 未知列的潜伏 500）\n- financial-reports：KPI 卡读 actualValue/targetValue 真源键（恒 '-' 修复）；\n  逾期率去掉二次 ×100（12.5% 曾显示 1250%）\n- ap-ledger：service 层补 supplier/owner 语义键映射（两列恒 '-'）\n\n请求侧修复：\n- opportunities：statsQuerySchema 补 transform 唯一转换点（snake schema × camel service，\n  stats/funnel/forecast 三端点 owner/日期筛选静默失效返回全量口径）\n- sla clocks：schema 补 status（此前被 Zod 剥离）+ service 消费 ticketId/clockType/breached\n  （收而不筛的假筛选）\n\n附带：LeadAssignmentResult.assignedTo nullable 化后类型连坐揪出分配历史列第三处\n无守卫消费，一并加守卫。\n\n证据：双端类型检查干净；后端单测 640/8795 全绿；前端六域 RTL 20 文件/72 用例全绿；\nlive curl 实锤：opportunities funnel bogus owner 309→0、stats 2099 区间→0、\nleads score 返回完整对象键、sla clocks bogus status→0、campaigns/commissions wire\n形状确认。分诊台账 P1 段已标记收口。\n\nCo-Authored-By: Claude Fable 5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"luoguoguo@gmail.com","AuthorName":"luoguoguo","CommitterEmail":"luoguoguo@gmail.com","CommitterName":"luoguoguo","Timestamp":"2026-07-12T07:01:41-07:00"}],"HeadCommit":{"Sha1":"0ebe6fb5c4cc802d6d6f53fba830ec5fbf64f3d7","Message":"fix(field-contract): P1 批次十三条收口——键名/量纲映射级断链修复\n\n响应侧映射修复：\n- campaigns：getCampaignStats 从后端真实 {overview,channels} 派生 summary/channelBreakdown\n  （渠道真数据此前被键名错位丢弃恒空）；getStats 分组数组转对象（业务线 Tab 计数恒 0）+\n  totalSpent 键对齐\n- leads /:id/score：拆分 controller 回完整评分对象（此前与 /score-details 共用剥壳 handler\n  只回裸数组，评分卡恒 0 分）；shared 类型补 calculatedAt 真源键并重建 dist\n- tickets：stage-history 路由接 ticket_stage_history 真源 handler（此前 alias 到 timeline\n  被旁路，渲染「初始状态：undefined」）；getReplies 补 adapter（回复人恒 '-' 修复）\n- satisfaction /analytics：adapter 归一 responseRate/avgCSAT/avgNPS/npsBreakdown\n  （分析页半页恒 '-'）；情感分布/类型统计无后端真源，保持 undefined 失败关闭\n- commissions：my-stats adapter（四张统计卡恒 ¥0）；listRecords/getMyRecords/\n  getSettlementById 补 user/rule/settlement/records DTO 映射（含 org_units 部门），\n  顺手修掉 where 层 camel 死键（userId/businessDate 等触发 Prisma 未知列的潜伏 500）\n- financial-reports：KPI 卡读 actualValue/targetValue 真源键（恒 '-' 修复）；\n  逾期率去掉二次 ×100（12.5% 曾显示 1250%）\n- ap-ledger：service 层补 supplier/owner 语义键映射（两列恒 '-'）\n\n请求侧修复：\n- opportunities：statsQuerySchema 补 transform 唯一转换点（snake schema × camel service，\n  stats/funnel/forecast 三端点 owner/日期筛选静默失效返回全量口径）\n- sla clocks：schema 补 status（此前被 Zod 剥离）+ service 消费 ticketId/clockType/breached\n  （收而不筛的假筛选）\n\n附带：LeadAssignmentResult.assignedTo nullable 化后类型连坐揪出分配历史列第三处\n无守卫消费，一并加守卫。\n\n证据：双端类型检查干净；后端单测 640/8795 全绿；前端六域 RTL 20 文件/72 用例全绿；\nlive curl 实锤：opportunities funnel bogus owner 309→0、stats 2099 区间→0、\nleads score 返回完整对象键、sla clocks bogus status→0、campaigns/commissions wire\n形状确认。分诊台账 P1 段已标记收口。\n\nCo-Authored-By: Claude Fable 5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"luoguoguo@gmail.com","AuthorName":"luoguoguo","CommitterEmail":"luoguoguo@gmail.com","CommitterName":"luoguoguo","Timestamp":"2026-07-12T07:01:41-07:00"},"CompareURL":"luoanwu/juhi-omni-knowledge-hub/compare/34599f92fc238176604126d3b0af3ac05efe051a...0ebe6fb5c4cc802d6d6f53fba830ec5fbf64f3d7","Len":1}

TEXT

created_unix

INTEGER

Update row 17108 in action