{"name": "CUSTOM-EHP-REPORT-AI-ทดสอบเว็บ visit แยกสิทธิ", "title": "ทดสอบเว็บ visit แยกสิทธิ", "landscape": true, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": ["date1", "date2"], "sql": "select o.vn,\no.hn,\nconcat(p.pname,p.fname,' ',p.lname) as ptname,\no.vstdate,\no.vsttime,\ncoalesce(pt.name, 'ไม่ระบุสิทธิ') as pttype_name,\nconcat(round(sc.bps),'/',round(sc.bpd)) as bp,\nsc.temperature,\nsc.rr,\ncoalesce(sc.o2sat, sc.spo2) as spo2,\nsc.bw,\nsc.height,\nsc.bmi,\ncase when sc.bps >= 140 or sc.bpd >= 90 then 1 else 0 end as high_bp,\ncase when sc.bmi >= 30 then 1 else 0 end as high_bmi,\n(select group_concat(concat(d.icd10, ' ', i.name) order by d.diagtype, d.icd10 separator '\\n') from ovstdiag d join icd101 i on i.code = d.icd10 where d.vn = o.vn) as icd10,\n(select group_concat(concat(di.name, ' ', coalesce(di.strength, ''), ' #', oi.qty) order by oi.icode separator '\\n') from opitemrece oi join drugitems di on di.icode = oi.icode where oi.vn = o.vn) as drugs,\nround(avg(sc.bmi) over (partition by coalesce(pt.name, 'ไม่ระบุสิทธิ')), 2) as group_avg_bmi\nfrom ovst o\nleft outer join patient p on p.hn = o.hn\nleft outer join pttype pt on pt.pttype = o.pttype\nleft outer join opdscreen sc on sc.vn = o.vn\nwhere o.vstdate between :date1 and :date2\norder by coalesce(pt.name, 'ไม่ระบุสิทธิ'), o.vstdate, o.vsttime"}, {"name": "Summary", "params": ["date1", "date2"], "sql": "select count(*) as visit_count, count(distinct o.hn) as person_count,\nsum(case when sc.bps >= 140 or sc.bpd >= 90 then 1 else 0 end) as high_bp_count,\nround(avg(sc.bmi), 2) as avg_bmi\nfrom ovst o\nleft outer join patient p on p.hn = o.hn\nleft outer join pttype pt on pt.pttype = o.pttype\nleft outer join opdscreen sc on sc.vn = o.vn\nwhere o.vstdate between :date1 and :date2"}], "columns": [{"field": "hn", "caption": "HN", "width": 18, "align": "taCentered"}, {"field": "ptname", "caption": "ชื่อ-สกุล", "memo": true}, {"field": "vstdate", "caption": "วันที่", "width": 19, "align": "taCentered", "thai_date": "dd/mm/yyyy"}, {"field": "vsttime", "caption": "เวลา", "width": 9, "align": "taCentered", "format": "hh:nn"}, {"field": "bp", "caption": "BP", "width": 15, "align": "taCentered"}, {"field": "temperature", "caption": "T", "width": 9, "align": "taCentered", "format": "0.0"}, {"field": "rr", "caption": "RR", "width": 8, "align": "taCentered", "format": "0"}, {"field": "spo2", "caption": "SpO2", "width": 9, "align": "taCentered", "format": "0"}, {"field": "bw", "caption": "BW", "width": 10, "align": "taCentered", "format": "0.0"}, {"field": "height", "caption": "Ht", "width": 9, "align": "taCentered", "format": "0"}, {"field": "bmi", "caption": "BMI", "width": 10, "align": "taCentered", "format": "0.00"}, {"field": "icd10", "caption": "ICD10", "width": 42, "memo": true}, {"field": "drugs", "caption": "ยาที่ได้รับ", "width": 45, "memo": true}], "highlight": [["bp", "high_bp"], ["bmi", "high_bmi"]], "group": {"field": "pttype_name", "caption": "สิทธิการรักษา :", "footer": [{"caption": "จำนวน visit :", "calc": "dcCount", "format": "#,0"}, {"caption": "BMI เฉลี่ย :", "field": "group_avg_bmi", "format": "0.00"}]}, "summary": [{"caption": "จำนวน visit ทั้งหมด", "dataview": "Summary", "field": "visit_count", "format": "#,0"}, {"caption": "จำนวนผู้รับบริการ (คน)", "dataview": "Summary", "field": "person_count", "format": "#,0"}, {"caption": "ความดันสูง (>=140/90)", "dataview": "Summary", "field": "high_bp_count", "format": "#,0"}, {"caption": "BMI เฉลี่ยทั้งหมด", "dataview": "Summary", "field": "avg_bmi", "format": "0.00"}]}