การใช้น้ำเกลือ
ID | 31 |
---|---|
Parent ID | 29 |
Table Name | dss_use |
Title | การใช้น้ำเกลือ |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=2 PROVIDER1=JHCIS PROVIDER2=HOSXP PROVIDER1_VALIDATE_TABLES=visitanc,visitancpregnancy,visit PROVIDER2_VALIDATE_TABLES=person_anc_service,ovst,ovst_seq SCRIPT_FLOW=SQL #SQL_OPTIONS# #PROVIDER1_SQL# SET @provcode = :provcode; SET @rep_year = :rep_year; SET @hoscode = :hoscode; SET @hosname = :hosname; SET @hostype = :hostype; SET @address = :address; SET @subdistcode = :subdistcode; SET @distcode = :distcode; SET @level_service = :level_service; SELECT FROM WHERE ; #PROVIDER1_SQL# #PROVIDER2_SQL# SET @provcode = :provcode; SET @rep_year = :rep_year; SET @hoscode = :hoscode; SET @hosname = :hosname; SET @hostype = :hostype; SET @address = :address; SET @subdistcode = :subdistcode; SET @distcode = :distcode; SET @level_service = :level_service; SELECT d.icode as icode,d.`name`as name ,sum(o.qty) as total,w.`name` as ward_name FROM drugitems d LEFT JOIN opitemrece o ON o.icode=d.icode LEFT JOIN ipt i ON i.an=o.an LEFT JOIN ward w ON w.ward=i.ward WHERE d.icode IN ('1000576','1000575','1000590','1000581','1000580','1000583','1000582','1000584','1000585','1000586','1000589','1000588','1000587','1000572','10003605','1550109','1000610') AND o.vstdate BETWEEN '2015-01-01' AND '2015-01-01' GROUP BY i.ward,d.`name` ; #PROVIDER2_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2015-06-12 12:59:12 |
Last Update | 2015-06-12 01:24:00 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.