รายงาน Demo2
ID | 802 |
---|---|
Parent ID | 56 |
Table Name | demo2 |
Title | รายงาน Demo2 |
Description | |
Script | #SQL_OPTIONS# PROVIDERS=2 PROVIDER1=JHCIS PROVIDER2=HOSXP PROVIDER1_VALIDATE_TABLES=accident,admission,anc,appointment 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 t_envocc e INNER JOIN t_person_cid p ON e.CID=p.CID WHERE (SUBSTR(DIAGCODE,1,3) BETWEEN 'M00' AND 'M99' OR SUBSTR(DIAGCODE,1,3) IN('G56')) AND e.HOSPCODE ='02485' AND e.flag_y96 IN(1) AND DATE_SERV BETWEEN '2017-01-01' AND '2018-06-09' AND p.check_typearea in(1,3) AND p.NATION in(99) AND (p.DISCHARGE in(2,3,9) OR (p.DISCHARGE in(1) AND p.DDISCHARGE BETWEEN '2017-10-01' AND '2018-09-30')) AND TIMESTAMPDIFF(year,p.birth,CONCAT('2017-10-01')) BETWEEN 0 AND 199 #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; /*SQL Script สำหรับ HosXP เริ่มที่นี่ */ SELECT FROM WHERE ; /*SQL Script สำหรับ HosXP สิ้นสุดที่นี่ */ #PROVIDER2_SQL# |
Script Cron | |
Force Script Cron | 0 |
Active | 1 |
Client Office Type | |
Create Date | 2018-08-08 02:28:21 |
Last Update | 2018-08-08 02:34:01 |
- Home
- About
- Privacy Policy
- Terms of Use
- Contact Us
© 2015. All Rights Reserved.