{
    "data": {
        "monthlyTrend": [],
        "paymentMethods": [
            {
                "label": "현금",
                "value": 0
            },
            {
                "label": "카드",
                "value": 0
            },
            {
                "label": "이체",
                "value": 0
            }
        ],
        "ageGenderPayment": [],
        "topDiagnosis": [],
        "topTreatments": [],
        "weeklyAnalysis": [],
        "doctorPayments": [],
        "staffPayments": [],
        "arpuByGrade": [],
        "topCustomers": [],
        "topUnpaidCustomers": []
    },
    "debug": {
        "data": {
            "sql": [
                "[SYNC] SELECT LEFT(PA08, 7) as month, SUM(PA27) as amount FROM PA WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' GROUP BY month ORDER BY month ASC",
                "[SYNC] SELECT SUM(PA23) as cash, SUM(PA24) as card, SUM(PA25) as transfer FROM PA WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23'",
                "[SYNC] SELECT CASE WHEN CS.CS12 < 10 THEN ' 10대 미만' WHEN CS.CS12 >= 70 THEN '70대 이상' ELSE CONCAT(FLOOR(CS.CS12 \/ 10) * 10, '대') END as age_group, CS.CS11 as gender, SUM(PA.PA27) as amount FROM PA LEFT JOIN CS ON PA.PA07 = CS.CS01 WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' GROUP BY age_group, gender ORDER BY age_group ASC",
                "[SYNC] SELECT PA1.PA103 as name, COUNT(*) as count FROM PA JOIN PA1 ON PA.PA01 = PA1.PA101 WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' AND PA1.PA102 = 1 AND PA1.PA103 != '' GROUP BY name ORDER BY count DESC LIMIT 5",
                "[SYNC] SELECT PA1.PA104 as name, COUNT(*) as count FROM PA JOIN PA1 ON PA.PA01 = PA1.PA101 WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' AND PA1.PA102 = 1 AND PA1.PA104 != '' GROUP BY name ORDER BY count DESC LIMIT 5",
                "[SYNC] SELECT DAYOFWEEK(PA08) as wday, SUM(PA27) as amount FROM PA WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' GROUP BY wday ORDER BY wday ASC",
                "[SYNC] SELECT PA13 as name, SUM(PA27) as amount FROM PA WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' AND PA13 != '' GROUP BY PA13 ORDER BY amount DESC LIMIT 5",
                "[SYNC] SELECT PA15 as name, SUM(PA27) as amount FROM PA WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' AND PA15 != '' GROUP BY PA15 ORDER BY amount DESC LIMIT 5",
                "[SYNC] SELECT IF(NULLIF(CS.CS16, '') IS NULL, '미지정', CS.CS16) as grade, SUM(PA.PA27) as total_amt, COUNT(DISTINCT PA.PA07) as user_cnt FROM PA LEFT JOIN CS ON PA.PA07 = CS.CS01 WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 BETWEEN '2026-10-01' AND '2026-10-23' GROUP BY grade",
                "[SYNC] SELECT CS.CS08 as name, SUM(PA.PA27) as amount FROM PA LEFT JOIN CS ON PA.PA07 = CS.CS01 WHERE PA.PA02 = 1 AND PA.PA03 = 1 AND PA.PA08 >= '2021-01-01' GROUP BY PA.PA07 ORDER BY amount DESC LIMIT 5",
                "[SYNC] SELECT CS.CS08 as name, (SUM(PA.PA22) - SUM(PA.PA27) - SUM(PA.PA31)) as amount FROM PA LEFT JOIN CS ON PA.PA07 = CS.CS01 WHERE PA.PA02 = 1 AND PA.PA03 = 1 GROUP BY PA.PA07 HAVING amount > 0 ORDER BY amount DESC LIMIT 5"
            ],
            "debug_client": false,
            "debug_server": true,
            "trace_log": false,
            "query_log": true,
            "sms_log": true,
            "sms_send": false,
            "delaytime": "0.0552s"
        },
        "post": []
    }
}