public-api 获取问答知识库

{
    "code": 0,
    "message": "SUCCESS",
    "data": {
        "q_a_infos": [
            {
                "id": "2498d971-187b-4fee-81c6-7db0a0774422",
                "theme_id": "497d14e7-aa67-44d4-9fb9-29e4580a5d15",
                "questions": "2023年7月雪颂兰商超渠道产生购买的白金卡会员人数",
                "answer": "SELECT COUNT(DISTINCT `消费者唯一标识`) AS `白金卡会员购买者` FROM `销售表` WHERE `品牌` = '雪颂兰' AND `成交日期` <= '2023-07-31' AND `成交日期` >= '2023-07-01' AND `是否会员` = '1' AND `销售渠道` = '商超渠道' AND `会员等级` = '白金卡会员';",
                "sql_status": 2,
                "status": 1,
                "is_preset": 1,
                "created_at": "2025-02-12 10:45:13",
                "updated_at": "2025-02-26 14:16:47",
                "query_context": null
            },
            {
                "id": "20adac0e-c1aa-4407-884c-be0b3396bfba",
                "theme_id": "497d14e7-aa67-44d4-9fb9-29e4580a5d15",
                "questions": "23年7月份雪颂兰商超渠道的首单购买人数及首单购买金额",
                "answer": "SELECT  COUNT(DISTINCT `消费者唯一标识`) AS `首单购买人数`, sum(`订单公司零售额`) as `首单购买金额`\nFROM    `销售表`\nWHERE   `品牌` = '雪颂兰'\nAND     `订单次序` = 1\nAND     `销售渠道` = '商超渠道'\nAND     `成交日期` <= '2023-07-31'\nAND    `成交日期` >= '2023-07-01'",
                "sql_status": 2,
                "status": 1,
                "is_preset": 1,
                "created_at": "2025-02-12 10:45:13",
                "updated_at": "2025-02-26 14:16:37",
                "query_context": null
            },
            {
                "id": "6dd55069-2d04-4f4c-ad03-cbb59fb85ffe",
                "theme_id": "497d14e7-aa67-44d4-9fb9-29e4580a5d15",
                "questions": "2022年12月雪颂兰电商渠道的 30天二回人数",
                "answer": "WITH `订单排名` AS (SELECT `消费者唯一标识`, `成交日期`, ROW_NUMBER() OVER (PARTITION BY `消费者唯一标识` ORDER BY `付款时间`) AS `订单排名` FROM `销售表` WHERE `品牌` = '雪颂兰' AND `销售渠道` = '电商渠道') SELECT COUNT(distinct `订单排名_2`.`消费者唯一标识`) AS `30天二回人数` FROM `订单排名` JOIN `订单排名` AS `订单排名_2` ON `订单排名`.`消费者唯一标识` = `订单排名_2`.`消费者唯一标识` AND `订单排名_2`.`订单排名` = 2 AND `订单排名_2`.`成交日期` <= '2022-12-31' AND `订单排名_2`.`成交日期` >= '2022-12-01' AND DATEDIFF(TO_DATE(TO_DATE(`订单排名_2`.`成交日期`)), TO_DATE(TO_DATE(`订单排名`.`成交日期`))) <= 30 WHERE `订单排名`.`订单排名` = 1",
                "sql_status": 2,
                "status": 1,
                "is_preset": 0,
                "created_at": "2025-02-12 10:45:13",
                "updated_at": "2025-02-24 14:14:40",
                "query_context": null
            }
        ],
        "preset_count": 3,
        "total_count": 72,
        "page_count": 24
    }
}