public-api L1发送消息（同步版）

{
    "code": 200,
    "message": "SUCCESS",
    "data": {
        "theme_id": "0b5ae7a1-8ad7-45b3-884a-17fe57f06875",
        "session_id": "86bf8794-d964-4673-ba2c-41db613d2fa4",
        "message_id": "448c68d4-e841-4a78-b9bc-0649b5cb7a13",
        "question": "7月呢",
        "rewritten_question": "2023年7月雪颂兰品牌会员的销售总额是多少，仅统计会员订单。",
        "answer": {
            "action": "query",
            "explain": "查询2023年7月雪颂兰品牌会员订单的销售总额，筛选条件包括品牌为雪颂兰、订单为会员订单，以及成交日期在2023年7月内。",
            "thoughts": "The question asks for the total sales amount for the Snowland brand in July 2023, specifically for member orders. This requires filtering by brand, date range, and ensuring only member orders are included.",
            "query": "SELECT SUM(`订单公司零售额`) AS `销售总额` FROM `销售表` WHERE `品牌` = '雪颂兰' AND `是否会员` = '1' AND `成交日期` >= '2023-07-01' AND `成交日期` <= '2023-07-31'",
            "language": "Chinese"
        },
        "sql": "SELECT SUM(`订单公司零售额`) AS `销售总额` FROM `销售表` WHERE `品牌` = '雪颂兰' AND `是否会员` = '1' AND `成交日期` >= '2023-07-01' AND `成交日期` <= '2023-07-31'",
        "card": {
            "dimensions": [],
            "metrics": [
                {
                    "name": "销售总额",
                    "formatType": "NUMBER"
                }
            ],
            "viz_config": null
        },
        "table": [
            {
                "table_id": "k91e9b283a34747b0b1088b8",
                "table_name": "销售表",
                "db_type": "SPARK"
            }
        ],
        "user_info": {
            "user_id": "Y2hlbm1pbmd6aG91",
            "username": "陈铭洲"
        },
        "feedback": {
            "is_collected": false,
            "vote": {
                "vote_type": null,
                "comment": null
            }
        },
        "answer_status": "success",
        "created_at": "2025-03-24 16:59:45",
        "is_insight": 0,
        "task_context": {
            "stage": "finished",
            "history": [
                {
                    "stage": "intent_recognition",
                    "content": {
                        "rewritten_question": "2023年7月雪颂兰品牌会员的销售总额是多少，仅统计会员订单。",
                        "intent": "write query"
                    },
                    "end_time": "2025-03-24 16:59:53"
                },
                {
                    "stage": "knowledge_search",
                    "content": {
                        "knowledge": [
                            "销售表: 订单日期默认使用`成交日期`字段",
                            "归属渠道: 值有：雪颂兰官方商城、线下、线上、美妆、未知。如果问题中包含“人”，“会员”，“消费者”类似的描述则使用`归属渠道`字段。否则，使用`销售渠道`字段",
                            "雪莲花特护面膜: 当且仅当完整提及'雪莲花特护面膜'时，使用条件（否则不使用）：(`物料编码` in ('5027940000','5027966000') or `商品名称` like '%雪莲花%' and `商品名称` like '%特护%' and `商品名称` like '%面膜%')",
                            "会员等级: 值有: 体验会员, 银卡会员, 金卡会员, 普通会员, 黑金卡会员, 高级会员, 见习特工, 白金卡会员, 黄金会员, VIP会员",
                            "当提问涉及“某月份某品牌新客老客销售情况如何”时，请按以下思路进行分析：\n1. 计算该月份该品牌的新客销售额，及销售额环比变化。\n2. 计算该月份该品牌的老客销售额，及销售额环比变化。\n3.销售额环比下降或上升小于5%， 则在报告中明确给予提示",
                            "纯新增多单会员: 上个时间段不是会员，这个时间段变成了多单会员的人",
                            "新增会员: 在统计周期内绑卡的会员",
                            "新增一单会员: 上个时间段不是一单会员，这个时间段变成了一单会员的人",
                            "销售额: 默认使用订单公司零售额",
                            "雪莲花冻干面膜: 当且仅当完整提及'雪莲花冻干面膜'时，使用条件（否则不使用）：(`物料编码` in ('502904801','5027912001') or `商品名称` like '%雪莲花%' and `商品名称` like '%冻干%' and `商品名称` like '%面膜%')",
                            "新入会会员: 时间段内，新绑卡的会员",
                            "集团、雪颂兰集团: 指所有品牌，集团旗下有同名的雪颂兰品牌和其他品牌。",
                            "当提问涉及“某月份某品牌会员销售情况如何”时，请按以下思路进行分析：\n1. 计算该月份该品牌的会员销售额，及销售额环比变化。\n2. 分线上线下渠道看销售额增长率，任一渠道如果增长低于3%，继续步骤3。\n3. 分新老会员统计销售额、占比及增长率，判断主要是哪部分会员导致增长不及预期。",
                            "留存率: 先计算目标时间点往前滚动13-24个月购买的人数作为分母, 再统计这些人中往前滚动12个月有购买的人数作为分子, 相除得到留存率",
                            "核心会员: `人群资产类型` in ('一单会员','多单会员')",
                            "流失激活率: 先计算统计周期前滚25-36月购买且近13-24个月未购买人数作为分母, 再统计这些人中近12个月有购买的人数作为分子, 相除得到流失激活率"
                        ]
                    },
                    "end_time": "2025-03-24 16:59:57"
                },
                {
                    "stage": "choose_table",
                    "content": {
                        "tables": [
                            {
                                "table_id": "k91e9b283a34747b0b1088b8",
                                "table_name": "销售表",
                                "db_type": "SPARK"
                            }
                        ]
                    },
                    "end_time": "2025-03-24 17:00:03"
                },
                {
                    "stage": "reply_generation",
                    "content": {
                        "thought": "The question asks for the total sales amount for the Snowland brand in July 2023, specifically for member orders. This requires filtering by brand, date range, and ensuring only member orders are included."
                    },
                    "end_time": "2025-03-24 17:00:11"
                }
            ]
        },
        "query_status": "success",
        "query_result": {
            "columns": [
                {
                    "name": "销售总额",
                    "fdType": "DOUBLE",
                    "seqNo": 0
                }
            ],
            "preview": [
                [
                    "165453.13002009067"
                ]
            ],
            "truncated": false
        },
        "query_context": null
    }
}