-- ============================================================
-- M22 运营后台页面种子数据
--   PRD 扩展页面从数据库读取展示数据；正式接入业务表前用可维护的种子数据承载原型。
-- ============================================================

CREATE TABLE admin_page_data
(
    page_key     VARCHAR(64)  NOT NULL,
    payload_json LONGTEXT     NOT NULL,
    status       TINYINT      NOT NULL DEFAULT 1,
    updated_at   DATETIME(3)  NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
    PRIMARY KEY (page_key)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT '运营后台页面数据';

INSERT INTO admin_page_data (page_key, payload_json, status)
VALUES
('tenantAudits', '{"title":"入驻审核中心","desc":"企业入驻资料、营业执照、法人身份与试用开通统一核验","primary":"新建入驻申请","workflow":["资料提交","证照核验","法人核身","试用开通","审计归档"],"metrics":[{"label":"待初审","value":"4","hint":"平均等待 1.2 小时"},{"label":"证照异常","value":"2","hint":"执照或法人信息不一致"},{"label":"今日通过","value":"9","hint":"已开通试用 7 家"},{"label":"需补件","value":"3","hint":"授权书/身份证缺失"}],"filters":["审核状态","证照状态","法人核身","试用包"],"columns":[{"prop":"company","label":"企业名称","minWidth":180},{"prop":"creditCode","label":"统一社会信用代码","minWidth":190},{"prop":"legalPerson","label":"法人","width":100},{"prop":"licenseStatus","label":"营业执照","width":120,"tag":true},{"prop":"identityStatus","label":"身份核验","width":120,"tag":true},{"prop":"contact","label":"联系人","width":110},{"prop":"trialPlan","label":"拟开通套餐","width":130,"tag":true},{"prop":"risk","label":"风险结论","width":120,"tag":true},{"prop":"status","label":"审核状态","width":120,"tag":true}],"rows":[{"id":"AUD20260526001","company":"星火互动文化","creditCode":"91310115MA1K4X2C8Q","legalPerson":"李敏","licenseStatus":"已验真","identityStatus":"人证一致","contact":"李女士","phone":"138****1001","submittedAt":"2026-05-26 09:12","businessScope":"广播电视节目制作、数字内容服务","trialPlan":"专业版试用","risk":"低风险","status":"待复核"},{"id":"AUD20260525018","company":"青石影像工作室","creditCode":"92440106MA9Y8N3L2G","legalPerson":"王磊","licenseStatus":"待补件","identityStatus":"身份证缺失","contact":"王先生","phone":"136****3001","submittedAt":"2026-05-25 18:30","businessScope":"摄影扩印、影视策划","trialPlan":"免费版","risk":"需人工确认","status":"需退回"},{"id":"AUD20260525007","company":"环声传媒","creditCode":"91440300MA5G9P6W1R","legalPerson":"赵晴","licenseStatus":"已验真","identityStatus":"人脸通过","contact":"赵女士","phone":"139****2001","submittedAt":"2026-05-25 14:05","businessScope":"文化传媒、短视频制作、广告投放","trialPlan":"团队版试用","risk":"低风险","status":"待开通"}],"cards":[{"title":"入驻核验清单","value":"营业执照 / 法人身份 / 授权关系","items":["统一社会信用代码需通过格式与重复校验","法人姓名需与证照主体一致","非法人经办需上传企业授权书"]},{"title":"通过后动作","value":"开通租户 + 试用资源 + 审计留痕","items":["生成企业租户与 Owner 账号","按试用包配置额度和并发上限","记录审核人、审核意见和开通时间"]}]}', 1),
('ordersInvoices', '{"title":"订单与发票","desc":"交易订单、退款审批、发票申请统一处理","primary":"新建线下订单","workflow":["订单创建","支付核验","资源入账","开票归档"],"metrics":[{"label":"今日订单","value":"56","hint":"已支付 42 笔"},{"label":"待退款审批","value":"2","hint":"涉及 ¥3,498"},{"label":"待开票","value":"4","hint":"最早申请 09:20"}],"filters":["订单状态","支付时间","发票状态","企业名称"],"columns":[{"prop":"orderNo","label":"订单号","minWidth":170},{"prop":"company","label":"所属企业","minWidth":180},{"prop":"package","label":"资源包","width":130},{"prop":"amount","label":"实付金额","width":120},{"prop":"invoice","label":"发票状态","width":120,"tag":true},{"prop":"status","label":"支付状态","width":120,"tag":true}],"rows":[{"orderNo":"O202605260091","company":"星火互动文化","package":"专业版","amount":"¥1,999","invoice":"待开具","status":"已支付"},{"orderNo":"O202605250218","company":"环声传媒","package":"积分加油包","amount":"¥299","invoice":"无需发票","status":"已支付"},{"orderNo":"O202605240087","company":"青石影像工作室","package":"团队版","amount":"¥4,999","invoice":"已邮寄","status":"退款中"}],"cards":[{"title":"财务处理","value":"退款与开票","items":["退款需二次确认并记录原因","发票支持录入抬头与快递单号","订单状态联动资源台账"]}]}', 1),
('warnings', '{"title":"运营预警表","desc":"沉睡客户、资源不足、即将过期与欠费风险集中干预","primary":"导出预警名单","workflow":["风险扫描","生成预警","负责人跟进","关闭风险"],"metrics":[{"label":"沉睡客户","value":"23","hint":"30 天未登录"},{"label":"资源不足","value":"15","hint":"低于阈值 20%"},{"label":"即将过期","value":"8","hint":"7 天内到期"},{"label":"欠费预警","value":"3","hint":"存在逾期订单"}],"filters":["预警类型","风险等级","客户阶段","负责人"],"columns":[{"prop":"company","label":"企业名称","minWidth":180},{"prop":"type","label":"预警类型","width":130,"tag":true},{"prop":"level","label":"风险等级","width":110,"tag":true},{"prop":"reason","label":"触发原因","minWidth":220},{"prop":"owner","label":"负责人","width":110}],"rows":[{"company":"灵感短剧社","type":"资源不足","level":"高","reason":"剩余积分 12%，最近 7 天消耗加速","owner":"陈运营"},{"company":"星轨传媒","type":"即将过期","level":"中","reason":"企业版 3 天后到期","owner":"周商务"},{"company":"南风影业","type":"沉睡客户","level":"中","reason":"45 天未登录，近 60 天无项目产出","owner":"林客服"}],"cards":[{"title":"干预建议","value":"3 类动作","items":["资源不足客户优先推送续费包","沉睡客户进入客服回访队列","欠费订单同步商务跟进"]}]}', 1),
('reports', '{"title":"数据报表中心","desc":"留存、活跃、消耗、销售漏斗的多维分析与算法口径管理","primary":"生成月报","workflow":["数据汇总","指标计算","规则校验","趋势分析","月报输出"],"metrics":[{"label":"付费转化率","value":"18.6%","hint":"注册到付费企业"},{"label":"复购率","value":"31.4%","hint":"90 天内二次购买"},{"label":"平均客单价","value":"¥2,810","hint":"已支付订单均值"},{"label":"积分消耗","value":"826万","hint":"成功模型调用合计"}],"filters":["时间范围","资源包","行业","销售归属"],"columns":[{"prop":"name","label":"报表名称","minWidth":180},{"prop":"scope","label":"统计口径","minWidth":180},{"prop":"dataSource","label":"数据来源","minWidth":180},{"prop":"updatedAt","label":"更新时间","minWidth":150},{"prop":"owner","label":"负责人","minWidth":110},{"prop":"status","label":"状态","minWidth":110,"tag":true}],"rows":[{"name":"付费转化漏斗","scope":"注册 / 试用 / 付费 / 复购","dataSource":"租户、订单、资源流水","updatedAt":"2026-05-26 08:00","owner":"系统","status":"已生成"},{"name":"资源消耗结构","scope":"剧本 / 图片 / 视频 / 配音 / 素材","dataSource":"模型调用流水、任务表","updatedAt":"2026-05-26 08:00","owner":"系统","status":"已生成"},{"name":"企业活跃度分层","scope":"DAU / WAU / MAU / 沉睡客户","dataSource":"登录日志、项目、任务","updatedAt":"2026-05-25 23:30","owner":"系统","status":"计算中"},{"name":"销售归因与客单价","scope":"销售负责人 / 套餐 / 订单金额","dataSource":"租户、订单与发票","updatedAt":"2026-05-25 20:00","owner":"财务运营","status":"已生成"}],"logicRules":[{"name":"付费转化率","scope":"衡量注册企业在统计周期内完成首笔支付的比例。排除测试租户、已删除租户和退款全额冲销订单。","formula":"付费转化率 = 首次支付企业数 / 新注册企业数 * 100%","owner":"运营负责人","editable":"可调整排除条件","notes":"常用于销售漏斗与投放质量评估。"},{"name":"复购率","scope":"企业首次付费后 90 天内产生第二笔已支付订单即记为复购。积分赠送、手工补偿不计入复购。","formula":"复购率 = 90天内复购企业数 / 已付费企业数 * 100%","owner":"计费负责人","editable":"可调整观察窗口","notes":"默认窗口为 90 天，企业版可单独分析。"},{"name":"资源消耗结构","scope":"按实际成功的模型调用流水统计，失败任务、取消任务和回滚流水不纳入消耗。","formula":"模型消耗 = SUM(resource_ledger.amount where operation = consume and success = true)","owner":"财务运营","editable":"只允许调整维度分组","notes":"用于模型成本复盘和资源包定价。"},{"name":"企业活跃分层","scope":"按登录、项目编辑、任务生成三类行为综合判断企业活跃度。","formula":"活跃企业 = 近7天登录或近14天有项目/任务行为；沉睡企业 = 30天无有效行为","owner":"客服主管","editable":"可调整天数阈值","notes":"沉睡企业会进入运营预警与客服回访。"},{"name":"平均客单价","scope":"仅统计已支付订单金额，退款中订单按原金额计入，已全额退款订单剔除。","formula":"平均客单价 = 已支付订单实付金额合计 / 已支付订单数","owner":"财务运营","editable":"可调整退款处理口径","notes":"用于套餐定价和销售归因分析。"},{"name":"月报生成规则","scope":"每月 1 日生成上月数据，支持人工重算。重算会记录操作者、时间和规则版本。","formula":"月报 = 按规则快照汇总 tenants / orders / ledger / tasks / tickets","owner":"系统","editable":"需管理员确认","notes":"规则变更后建议重算最近一个自然月。"}],"cards":[{"title":"规则管理","value":"6 个核心算法口径","items":["转化、复购、客单价、活跃分层、资源消耗和月报生成均有明确公式","每条规则标注负责人和可调整范围","规则变更后进入审计日志并可触发报表重算"]},{"title":"数据来源","value":"租户 / 订单 / 流水 / 任务 / 工单","items":["模型消耗来自资源流水而非前端展示值","活跃度同时参考登录、项目和任务行为","财务指标默认排除测试租户和全额退款订单"]}]}', 1),
('tickets', '{"title":"工单工作台","desc":"企业咨询、问题反馈、转派与 SLA 跟踪","primary":"新建工单","workflow":["待分配","处理中","已解决","已关闭"],"metrics":[{"label":"待分配","value":"9","hint":"紧急 2 条"},{"label":"处理中","value":"18","hint":"平均 1.4 小时"},{"label":"今日解决","value":"31","hint":"解决率 93%"},{"label":"超时风险","value":"3","hint":"需立即跟进"}],"filters":["工单状态","优先级","工单分类","处理人"],"columns":[{"prop":"ticketNo","label":"工单号","minWidth":150},{"prop":"company","label":"企业","minWidth":160},{"prop":"category","label":"分类","width":110,"tag":true},{"prop":"priority","label":"优先级","width":110,"tag":true},{"prop":"assignee","label":"处理人","width":110},{"prop":"status","label":"状态","width":110,"tag":true}],"rows":[{"ticketNo":"TK20260526001","company":"星火互动文化","category":"资源","priority":"紧急","assignee":"林客服","status":"处理中"},{"ticketNo":"TK20260526002","company":"南风影业","category":"账号","priority":"普通","assignee":"待分配","status":"待分配"},{"ticketNo":"TK20260525018","company":"环声传媒","category":"功能","priority":"加急","assignee":"陈客服","status":"已解决"}],"cards":[{"title":"流转规则","value":"待分配 -> 处理中 -> 已解决 -> 已关闭","items":["支持人工转派","可调用话术库快速回复","超时自动进入预警"]}]}', 1),
('scriptLibrary', '{"title":"话术库管理","desc":"面向 AI 短剧 SaaS 的客服标准回复、升级规则与工单处理知识库","primary":"新增话术","workflow":["创建草稿","质检审核","发布启用","工单调用","效果复盘"],"metrics":[{"label":"话术总数","value":"9","hint":"覆盖入驻/计费/生成/发票"},{"label":"已发布","value":"7","hint":"可在工单中调用"},{"label":"待审核","value":"2","hint":"本周新增"},{"label":"命中场景","value":"6","hint":"客服高频问题"}],"filters":["分类","适用场景","启用状态","关键词"],"columns":[{"prop":"title","label":"话术标题","minWidth":220},{"prop":"category","label":"分类","minWidth":120,"tag":true},{"prop":"scene","label":"适用场景","minWidth":150},{"prop":"targetRole","label":"适用对象","minWidth":120,"tag":true},{"prop":"triggerKeywords","label":"触发关键词","minWidth":220},{"prop":"updatedBy","label":"维护人","minWidth":110},{"prop":"status","label":"状态","minWidth":100,"tag":true}],"rows":[{"title":"入驻资料补件说明","category":"入驻审核","scene":"证照/法人资料缺失","targetRole":"企业管理员","triggerKeywords":"营业执照、法人身份证、授权书、补件","replyTemplate":"您好，当前入驻资料还缺少必要核验材料。请补充营业执照清晰图片、法人身份证正反面或经办人授权书。资料提交后运营会在 1 个工作小时内复核，审核通过后会自动开通试用资源。","handoffRule":"涉及证照主体不一致时转运营审核；客户催办超过 30 分钟转客服主管。","updatedBy":"林客服","status":"已发布"},{"title":"积分消耗异常解释","category":"计费结算","scene":"客户质疑积分扣减","targetRole":"企业管理员","triggerKeywords":"积分少了、扣费、消耗异常、账单不对","replyTemplate":"您好，平台积分会按实际调用的模型、输入素材与输出时长记录流水。您可以在企业后台的资源流水中按项目、模型和日期核对。若发现重复扣减，请提供项目名和任务时间，我们会提交财务与技术联合复核。","handoffRule":"单笔差异超过 5000 积分或涉及退款时转财务值班。","updatedBy":"陈客服","status":"已发布"},{"title":"视频生成排队说明","category":"生成任务","scene":"视频任务等待过久","targetRole":"企业成员","triggerKeywords":"排队、生成慢、一直等待、任务卡住","replyTemplate":"您好，视频生成会根据当前并发额度和模型队列依次处理。企业版/团队版支持更高并发；如果任务超过 30 分钟没有进入执行，请提供项目 ID，我们会检查任务状态并协助重试。","handoffRule":"任务失败或等待超过 30 分钟转技术值班。","updatedBy":"周客服","status":"已发布"},{"title":"模型生成失败安抚与重试","category":"生成任务","scene":"图片/视频/剧本生成失败","targetRole":"企业成员","triggerKeywords":"失败、报错、重试、生成不了","replyTemplate":"您好，生成失败通常与素材格式、提示词安全策略或上游模型临时波动有关。系统不会对失败任务重复扣减成功消耗积分。请先检查素材格式和提示词；如仍失败，我们可以协助发起一次任务重试。","handoffRule":"连续失败 2 次以上转技术值班并关联任务 ID。","updatedBy":"周客服","status":"已发布"},{"title":"发票开具与退款进度说明","category":"订单发票","scene":"开票/退款咨询","targetRole":"企业管理员","triggerKeywords":"发票、退款、付款、订单、抬头","replyTemplate":"您好，发票申请会在支付核验后进入财务处理，专票需确认纳税人识别号、注册地址和开户行信息。退款申请需要先冻结对应资源额度，再由财务在 1-3 个工作日内处理。","handoffRule":"退款中状态超过 2 个工作日转财务值班。","updatedBy":"赵财务","status":"已发布"},{"title":"成员邀请失败处理","category":"账号组织","scene":"组织成员无法加入","targetRole":"企业管理员","triggerKeywords":"邀请失败、成员、邮箱、权限、加入团队","replyTemplate":"您好，请确认成员邮箱或手机号未加入其他企业，并检查当前套餐成员上限。若成员上限不足，可先移除不再使用的账号或升级套餐。我们也可以协助您核对账号归属。","handoffRule":"跨租户账号归属问题转运营人员处理。","updatedBy":"陈客服","status":"已发布"},{"title":"套餐升级权益说明","category":"套餐资源","scene":"升级/扩容咨询","targetRole":"企业管理员","triggerKeywords":"升级、套餐、并发、成员上限、资源包","replyTemplate":"您好，套餐升级后会同步提升成员数、项目数、月积分和并发任务上限。升级前已购买的资源余额会保留，系统会按新套餐规则继续累计消耗。","handoffRule":"企业版报价或合同条款转商务跟进。","updatedBy":"周商务","status":"待审核"},{"title":"内容安全拦截说明","category":"风控合规","scene":"提示词或素材被拦截","targetRole":"企业成员","triggerKeywords":"敏感、违规、审核不通过、内容安全","replyTemplate":"您好，平台会对提示词、素材和生成结果进行内容安全校验。若出现拦截，请调整涉及暴力、色情、侵权、真实人物冒用等内容。若您认为误判，可提交项目 ID 由运营复核。","handoffRule":"客户申诉误判时转内容运营复核。","updatedBy":"内容运营","status":"待审核"},{"title":"API 调用额度说明","category":"开放接口","scene":"API 接入/额度咨询","targetRole":"技术管理员","triggerKeywords":"API、接口、密钥、额度、限流","replyTemplate":"您好，API 调用与企业后台任务共用积分余额，并受套餐并发和频控限制。请在企业后台查看 API Key、调用日志和模型消耗明细；若需要更高限流，请联系商务配置企业版额度。","handoffRule":"接口报错附 requestId 转技术值班。","updatedBy":"技术支持","status":"已发布"}],"cards":[{"title":"管理规则","value":"审核后发布 + 工单调用","items":["新增话术先进入草稿/待审核状态","发布后可在工单工作台按分类和关键词检索","话术需包含升级规则，避免客服停留在手工判断"]},{"title":"覆盖场景","value":"入驻 / 计费 / 生成 / 财务 / 风控","items":["入驻审核资料补件","模型消耗与资源流水解释","视频生成排队、失败与重试","订单发票与退款处理"]}]}', 1),
('supportPerformance', '{"title":"客服绩效看板","desc":"响应时效、处理量、解决率与超时风险统计","primary":"导出绩效","workflow":["工单进入","首响统计","解决统计","SLA 复盘"],"metrics":[{"label":"平均首响","value":"11 分钟","hint":"SLA 达成 96%"},{"label":"平均解决","value":"2.6 小时","hint":"环比 -8%"},{"label":"解决率","value":"93%","hint":"近 30 天"},{"label":"满意度","value":"4.8","hint":"满分 5 分"}],"filters":["客服人员","时间范围","工单分类","优先级"],"columns":[{"prop":"agent","label":"客服","width":120},{"prop":"handled","label":"处理量","width":110},{"prop":"firstResponse","label":"首响时长","width":130},{"prop":"resolution","label":"解决率","width":110},{"prop":"risk","label":"超时风险","width":120,"tag":true}],"rows":[{"agent":"林客服","handled":"86","firstResponse":"9 分钟","resolution":"95%","risk":"低"},{"agent":"陈客服","handled":"72","firstResponse":"13 分钟","resolution":"91%","risk":"中"},{"agent":"周客服","handled":"64","firstResponse":"16 分钟","resolution":"89%","risk":"中"}],"cards":[{"title":"绩效口径","value":"处理量 / 首响 / 解决率","items":["支持按人员与团队查看","超时工单进入预警表","导出用于月度复盘"]}]}', 1),
('manuals', '{"title":"使用手册管理","desc":"企业侧创作手册与运营侧处理手册统一维护、发布和复盘","primary":"新建文档","workflow":["编辑文档","版本校对","发布上线","阅读分析"],"metrics":[{"label":"文档总数","value":"8","hint":"企业侧 5 篇 / 运营侧 3 篇"},{"label":"已发布","value":"6","hint":"可在帮助中心查看"},{"label":"待发布","value":"2","hint":"运营流程补充中"},{"label":"本周阅读","value":"326","hint":"计费文档最高"}],"filters":["目录","发布状态","适用端","关键词"],"columns":[{"prop":"title","label":"文档标题","minWidth":220},{"prop":"category","label":"目录","minWidth":130,"tag":true},{"prop":"scope","label":"适用端","minWidth":110,"tag":true},{"prop":"version","label":"版本","minWidth":100},{"prop":"owner","label":"负责人","minWidth":110},{"prop":"updatedAt","label":"更新时间","minWidth":150},{"prop":"status","label":"状态","minWidth":100,"tag":true}],"rows":[{"title":"企业端：创建 AI 短剧项目","category":"创作入门","scope":"企业侧","version":"v1.0","owner":"内容运营","updatedAt":"2026-05-26 09:30","summary":"说明从新建项目、导入剧本到选择画幅和清晰度的完整流程。","content":"1. 进入项目页创建短剧项目；2. 上传 doc、docx、txt、pdf 或 md 剧本；3. 选择 Agent 模式或人工模式；4. 设置画幅、分辨率和预览风格；5. 创建任务后在项目列表查看生成进度。","status":"已发布"},{"title":"企业端：剧本生成与改写","category":"剧本生产","scope":"企业侧","version":"v1.0","owner":"内容运营","updatedAt":"2026-05-26 09:40","summary":"介绍剧本生短剧、人工模式、提示词安全和结果二次编辑。","content":"支持上传原始剧本后自动拆解剧情、角色和分镜。生成前请避免真实人物冒用、侵权情节和敏感内容。结果可进入人工模式修改分镜、台词和镜头说明。","status":"已发布"},{"title":"企业端：资产与素材管理","category":"资产管理","scope":"企业侧","version":"v1.0","owner":"产品运营","updatedAt":"2026-05-25 16:20","summary":"说明角色图、配音素材、品牌素材和项目资产的复用规则。","content":"资产可按项目沉淀并复用。建议统一命名角色、场景、Logo 和配音文件。素材上传后会进入项目资产库，视频生成时可作为输入素材参与模型调用。","status":"已发布"},{"title":"企业端：积分消耗与模型计费","category":"计费结算","scope":"企业侧","version":"v1.1","owner":"财务运营","updatedAt":"2026-05-26 10:00","summary":"解释资源流水、模型维度消耗、失败任务和发票申请。","content":"积分按实际模型调用、素材输入和输出时长计量。可在资源流水中按项目、用户、模型、日期筛选。失败任务不会按成功结果重复计费；开票需在订单支付完成后提交发票信息。","status":"已发布"},{"title":"企业端：成员与权限配置","category":"团队协作","scope":"企业侧","version":"v1.0","owner":"产品运营","updatedAt":"2026-05-24 14:10","summary":"说明 Owner、管理员、成员的权限差异和邀请限制。","content":"Owner 可管理套餐、资源和成员；管理员可管理项目和资产；成员主要负责创作任务。邀请成员前请确认套餐成员上限，跨企业账号需先解除原企业绑定。","status":"已发布"},{"title":"运营端：入驻审核处理规范","category":"运营审核","scope":"运营侧","version":"v0.9","owner":"运营主管","updatedAt":"2026-05-26 11:00","summary":"规范营业执照、法人身份、授权书、风险结论和试用开通动作。","content":"审核需检查统一社会信用代码、营业执照主体、法人姓名和经办人授权。低风险客户可开通试用包；证照不一致或授权缺失需退回补件；审核结果写入审计日志。","status":"待发布"},{"title":"运营端：订单发票与退款处理","category":"订单计费","scope":"运营侧","version":"v0.8","owner":"财务运营","updatedAt":"2026-05-25 18:30","summary":"规范线下订单、支付核验、资源入账、发票和退款流程。","content":"线下订单需上传支付凭证并核对企业名称。支付确认后资源入账；专票需校验税号、开户行和地址电话；退款需冻结对应资源额度并记录退款原因。","status":"待发布"},{"title":"运营端：预警与客服工单联动","category":"客户服务","scope":"运营侧","version":"v1.0","owner":"客服主管","updatedAt":"2026-05-24 19:00","summary":"说明资源不足、沉睡客户、超时工单和话术库调用规则。","content":"资源不足客户进入续费提醒；沉睡客户进入回访队列；超时工单同步预警表。客服处理时优先调用话术库，无法解决时按升级规则转交运营、财务或技术。","status":"已发布"}],"cards":[{"title":"发布管理","value":"版本 + 状态 + 适用端","items":["文档按企业侧/运营侧区分展示","待发布文档经校对后再上线","版本更新保留负责人和更新时间"]},{"title":"内容范围","value":"创作流程 + 运营流程","items":["企业端覆盖项目、剧本、素材、计费和团队协作","运营端覆盖入驻审核、订单发票、预警和工单联动","文档可挂载附件或封面图"]}]}', 1),
('announcements', '{"title":"政策与新闻","desc":"公告、政策、计费变更与强制阅读配置","primary":"发布公告","workflow":["撰写公告","设置策略","发布通知","阅读确认"],"metrics":[{"label":"已发布","value":"36","hint":"本月 4 篇"},{"label":"定时发布","value":"3","hint":"最近 06-01"},{"label":"强制阅读","value":"2","hint":"需企业确认"}],"filters":["公告类型","发布状态","是否强制","发布时间"],"columns":[{"prop":"title","label":"标题","minWidth":240},{"prop":"type","label":"类型","width":110,"tag":true},{"prop":"publishAt","label":"发布时间","minWidth":150},{"prop":"readMode","label":"阅读要求","width":120,"tag":true},{"prop":"status","label":"状态","width":100,"tag":true}],"rows":[{"title":"视频生成计费规则更新说明","type":"政策","publishAt":"2026-05-26 10:00","readMode":"强制确认","status":"已发布"},{"title":"端午节服务保障公告","type":"新闻","publishAt":"2026-05-25 18:00","readMode":"普通阅读","status":"定时中"},{"title":"企业版套餐权益调整","type":"政策","publishAt":"2026-05-21 09:00","readMode":"强制确认","status":"已发布"}],"cards":[{"title":"发布策略","value":"立即 / 定时 / 强制确认","items":["重大政策可要求登录确认","支持分类归档","发布动作进入审计日志"]}]}', 1),
('globalSettings', '{"title":"全局参数配置","desc":"预警阈值、灰度开关、积分单价与平台安全策略","primary":"保存配置","workflow":["配置编辑","风险校验","保存生效","审计留痕"],"metrics":[{"label":"预警阈值","value":"20%","hint":"资源不足触发线"},{"label":"到期提醒","value":"7 天","hint":"二次提醒 3 天"},{"label":"灰度开关","value":"3","hint":"2 个已启用"}],"filters":["配置分组","状态","维护人","关键词"],"columns":[{"prop":"key","label":"配置项","minWidth":200},{"prop":"group","label":"分组","width":120,"tag":true},{"prop":"value","label":"当前值","minWidth":140},{"prop":"owner","label":"维护人","width":110},{"prop":"status","label":"状态","width":100,"tag":true}],"rows":[{"key":"资源不足预警阈值","group":"预警","value":"20%","owner":"超级管理员","status":"启用"},{"key":"资源到期提醒天数","group":"预警","value":"7 / 3 天","owner":"超级管理员","status":"启用"},{"key":"新版计费订单灰度","group":"灰度","value":"企业版白名单","owner":"超级管理员","status":"启用"}],"cards":[{"title":"安全要求","value":"高危配置二次确认","items":["配置变更记录快照","支持灰度开关","影响资损的规则需审批"]}]}', 1)
ON DUPLICATE KEY UPDATE
    payload_json = VALUES(payload_json),
    status = VALUES(status);
