{"name": "CUSTOM-EHP-REPORT-AI-รายงานสัญญาณชีพผู้ป่วยนอก", "title": "รายงานสัญญาณชีพผู้ป่วยนอก", "landscape": true, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "sql": "SELECT ov.vstdate, ov.hn, CONCAT(p.pname, p.fname, ' ', p.lname) AS pt_name, ops.bpd, ops.bps, ops.pulse, ops.temperature, ops.rr, ops.bw, ops.height, ops.fbs AS bmi, ops.cc FROM ovst ov LEFT JOIN opdscreen ops ON ov.vn = ops.vn LEFT JOIN patient p ON ov.hn = p.hn WHERE ov.vstdate BETWEEN :date1 AND :date2", "params": ["date1", "date2"]}], "columns": [{"field": "vstdate", "caption": "วันที่", "width": 25, "align": "taCentered", "thai_date": "dd/mm/yy"}, {"field": "hn", "caption": "HN", "width": 25, "align": "taLeftJustified"}, {"field": "pt_name", "caption": "ชื่อผู้ป่วย", "width": 25, "align": "taLeftJustified"}, {"field": "bpd", "caption": "BP-D", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "bps", "caption": "BP-S", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "pulse", "caption": "ชีพจร", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "temperature", "caption": "อุณหภูมิ", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "rr", "caption": "การหายใจ", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "bw", "caption": "น้ำหนัก", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "height", "caption": "ส่วนสูง", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "bmi", "caption": "BMI", "width": 25, "align": "taCentered", "format": "0.00"}, {"field": "cc", "caption": "อาการสำคัญ", "align": "taLeftJustified", "memo": true}], "highlight": []}