รายงานทะเบียนยาที่เปิดใช้งาน
CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน · demo-103 · deployed
คำสั่ง: job:1
ประวัติ deploy
| เวลา | v | ปลายทาง | ผล |
|---|---|---|---|
| 2026-10-14T17:52:27 | 7 | demo-103 | ok |
| 2026-10-14T17:13:21 | 6 | demo-103 | ok |
| 2026-10-14T16:50:21 | 5 | demo-103 | ok |
| 2026-10-14T16:50:20 | 4 | demo-103 | ok |
| 2026-10-14T16:47:17 | 3 | demo-103 | ok |
| 2026-10-14T16:45:41 | 2 | demo-103 | ok |
| 2026-10-14T16:40:40 | 1 | demo-103 | ok |
เวอร์ชัน
v7 2026-10-14T17:52:26
{"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, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": true, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 20.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": [], "header_sql": "SELECT hospitalcode, concat(hospitalcode, ' : ', hospitalname) as hospital_name, '' as address from opdconfig", "font": {"name": "Tahoma", "size": 11, "title_size": 16}, "footer": {"page_align": "center"}}v6 2026-10-14T17:13:21
{"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, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 20.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": [], "header_sql": "SELECT hospitalcode, concat(hospitalcode, ' : ', hospitalname) as hospital_name, '' as address from opdconfig", "font": {"name": "Tahoma", "size": 11, "title_size": 16}, "footer": {"page_align": "center"}}v5 2026-10-14T16:50:20
{"name": "CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน", "title": "รายงานทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": []}v4 2026-10-14T16:50:20
{"name": "CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน", "title": "รายงานทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": []}v3 2026-10-14T16:47:17
{"name": "CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน", "title": "รายงานทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": []}v2 2026-10-14T16:45:41
{"name": "CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน", "title": "รายงานทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": []}v1 2026-10-14T16:40:40
{"name": "CUSTOM-EHP-REPORT-AI-รายงานทะเบียนยาที่เปิดใช้งาน", "title": "รายงานทะเบียนยาที่เปิดใช้งาน", "landscape": false, "variables": [{"name": "date1", "prompt": "ตั้งแต่วันที่ (date1)", "sample": "2026-01-01"}, {"name": "date2", "prompt": "ถึงวันที่ (date2)", "sample": "2026-12-31"}], "dataviews": [{"name": "Master", "master": true, "params": [], "sql": "SELECT drugitems.icode AS icode, drugitems.name AS drug_name, drugitems.strength AS strength, drugitems.dosageform AS dosageform, drugitems.units AS unit, drugitems.unitcost AS unit_cost, drugitems.istatus AS status FROM drugitems WHERE drugitems.istatus = 'Y'"}], "columns": [{"field": "icode", "caption": "รหัสยา", "align": "taCentered", "memo": false, "width": 15.0}, {"field": "drug_name", "caption": "ชื่อยา", "align": "taLeftJustified", "memo": true}, {"field": "strength", "caption": "ความแรง", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "dosageform", "caption": "รูปแบบยา", "align": "taLeftJustified", "memo": false, "width": 25.0}, {"field": "unit", "caption": "หน่วยนับ", "align": "taCentered", "memo": false, "width": 25.0}, {"field": "unit_cost", "caption": "ราคาทุนต่อหน่วย", "align": "taRightJustified", "memo": false, "format": "#,0.00", "width": 25.0}, {"field": "status", "caption": "status", "align": "taCentered", "memo": false, "width": 20.0}], "highlight": []}