{"name": "CUSTOM-EHP-REPORT-AI-รายงานผู้ป่วยวินิจฉัย Common Cold (Principal Diagnosis)", "title": "รายงานผู้ป่วยวินิจฉัยเดือน ตุลาคม 2569", "landscape": true, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-10-01", "preset": "2026-10-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-10-31", "preset": "2026-10-31"}], "dataviews": [{"name": "Master", "master": true, "sql": "select o.vstdate, o.hn, concat(p.pname, p.fname, ' ', p.lname) as pt_name, v.age_y as age, d.name as doctor_name, d.licenseno as doctor_license, s.bpd, s.bps, s.temperature, s.rr, s.spo2, s.bw, s.height, s.bmi, s.cc, s.hpi, od.icd10, i.name as icd10_name from ovst o join ovstdiag od on od.vn = o.vn join vn_stat v on v.vn = o.vn left join patient p on p.hn = o.hn left join doctor d on d.code = od.doctor join icd101 i on i.code = od.icd10 left join opdscreen s on s.vn = o.vn where o.vstdate between :date1 and :date2 and od.diagtype = '1' order by o.vstdate, o.vsttime", "params": ["date1", "date2"]}], "columns": [{"field": "vstdate", "caption": "วันที่รับบริการ", "align": "taCentered", "memo": false, "thai_date": "dd mmm yy", "width": 20.0}, {"field": "hn", "caption": "HN", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "pt_name", "caption": "ชื่อ-สกุล", "align": "taLeftJustified", "memo": true, "width": 30.0}, {"field": "age", "caption": "อายุ", "align": "taCentered", "memo": false, "format": "#,0", "width": 15.0}, {"field": "doctor_name", "caption": "แพทย์", "align": "taLeftJustified", "memo": true, "width": 25.0}, {"field": "doctor_license", "caption": "ว.แพทย์", "align": "taCentered", "memo": false, "width": 20.0}, {"field": "icd10", "caption": "ICD10", "align": "taCentered", "memo": false, "width": 20.0}, {"field": "icd10_name", "caption": "ชื่อโรค", "align": "taLeftJustified", "memo": true, "width": 30.0}, {"field": "bps", "caption": "SBP", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "bpd", "caption": "DBP", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "temperature", "caption": "Temp", "align": "taCentered", "memo": false, "format": "#,0.0", "width": 15.0}, {"field": "rr", "caption": "RR", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "spo2", "caption": "SpO2", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "bw", "caption": "BW", "align": "taCentered", "memo": false, "format": "#,0.0", "width": 15.0}, {"field": "height", "caption": "Ht", "align": "taCentered", "memo": false, "format": "#,0", "width": 15.0}, {"field": "bmi", "caption": "BMI", "align": "taCentered", "memo": false, "format": "#,0.00", "width": 15.0}, {"field": "cc", "caption": "CC", "align": "taLeftJustified", "memo": true, "width": 30.0}, {"field": "hpi", "caption": "HPI", "align": "taLeftJustified", "memo": true}], "highlight": [], "header_sql": "select h.hospitalcode,concat(o.hosptype,o.name) as hospital_name,\nconcat(' ต. ',t.name,' อ. ',t1.name,' จ. ',t2.name) as address\nfrom  opdconfig h\nleft outer join hospcode o on h.hospitalcode=o.hospcode\nleft outer join thaiaddress t on t.tmbpart=o.tmbpart and t.amppart=o.amppart  and t.chwpart=o.chwpart and t.codetype='3'\nleft outer join thaiaddress t1 on t1.amppart=o.amppart and t1.chwpart=o.chwpart and t1.codetype='2'\nleft outer join thaiaddress t2 on t2.chwpart=o.chwpart and t2.codetype='1'", "footer": {"page_align": "center"}, "font": {"size": 11}, "row_line": "dashed", "props": [{"id": "LnReportName", "prop": "Font.Color", "value": "clBlue"}, {"id": "DBTextpt_name", "prop": "mmLeft", "value": 44000}, {"id": "LnReportName", "prop": "Font.Size", "value": 16}, {"id": "DBTextdoctor_name", "prop": "mmLeft", "value": 78000}]}