การใช้น้ำเกลือ

Update Delete

ID31
Parent ID29
Table Namedss_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 Cron0
Active1
Client Office Type
Create Date2015-06-12 12:59:12
Last Update2015-06-12 01:24:00