12:09:36.508 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload:{}
12:09:36.518 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select a.cflsh0,a.ghid00,a.ghh000, b.xm0000 brxm00,b.csrq00,replace(sf_bq_csrqtonl(b.csrq00),'岁','') nl0000,
(select yyid00 from bm_bmbm00 where bmbh00 = a.ghks00) yyid00,
(select yyjc00 from xt_yyxx00 y,bm_bmbm00 bm where y.yyid00 =bm.yyid00 and bm.bmbh00 = a.ghks00) yymc00
from ys_cfxxb0 a,sf_brxxb0 b where 1=1 and a.ghid00 = b.ghid00
and a.SRRQ00 = to_char(sysdate,'yyyyMMdd')
and a.SRSJ00 >= to_char(sysdate-interval '5' minute,'hh24:mi:ss')--5分钟推送一次数据5分钟内的数据======params:ts0000=0,======span:4ms
12:09:36.518 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> data------:[[CFLSH0:17341529, GHID00:25256072, GHH000:25256072, BRXM00:罗允潇, CSRQ00:20211004, NL0000:3, YYID00:229112, YYMC00:福建省龙岩人民医院], [CFLSH0:17341527, GHID00:25256614, GHH000:25256614, BRXM00:张子妍, CSRQ00:20130507, NL0000:11, YYID00:229112, YYMC00:福建省龙岩人民医院], [CFLSH0:17341528, GHID00:25254967, GHH000:25254967, BRXM00:陈伊桐, CSRQ00:20170416, NL0000:7, YYID00:229112, YYMC00:福建省龙岩人民医院], [CFLSH0:17341666, GHID00:25250391, GHH000:25250391, BRXM00:孔卓, CSRQ00:19880303, NL0000:36, YYID00:229112, YYMC00:福建省龙岩人民医院], [CFLSH0:17341716, GHID00:25250391, GHH000:25250391, BRXM00:孔卓, CSRQ00:19880303, NL0000:36, YYID00:229112, YYMC00:福建省龙岩人民医院]]
12:09:36.520 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select d.CFLSH0, decode(d.YPDLBH,'0','01','1','01','2','10') CFLB00, decode(d.YPDLBH,'0','门诊处方笺','1','门诊处方笺','2','中医科') CFLBMC
from YF_MZCF00 d where ghid00 = :ghid00
and d.cfzt00 = '1'======params:ghid00=25256072,======span:2ms
12:09:36.520 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> ysfdata------:null
12:09:36.522 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM,
a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM,
b.CFID00,
'03' YPLBBH,
'10' CFLX00,
'门诊西药' CFLXMC,
'' BZ0000,
b.PCID00,
(select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00,
b.YYSJ00||b.YYSJDW TS0000,
b.Yfid00,
(select YPYFMC from bm_ypyf00 where yfid00 = b.yfid00) YFMC00,
b.csl000,
b.jldw00,
b.ypzsl0,
b.CFDW00,
b.ypzsl0 lyl000,
b.CFDW00 lydw00,
'' BZXH00,
b.ypnm00,
b.ypmc00,
b.lsdj00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
decode(d.PSZT00,'0','false','1','true') SFPS00,--是否皮试
decode(d.PSZT00,'2','false','3','true') SFSY00,--是否适应
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00, --备注
b.cflsh0 yzid00,
b.cfid00 yzmxid,
round(b.csl000,4) cjl000
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.YPDLBH in ('0','1')======params:cflsh0=17341529,======span:2ms
12:09:36.522 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> xcydata------:[CFID00:29140060, CFLSH0:17341529, KFSJ00:20250109120923, KFYS00:136, KFYSXM:凌武育, KFKS00:108, KFKSMC:门诊儿科, SHSJ00:null, SHYS00:null, SHYSXM:null, YPLBBH:03, CFLX00:10, CFLXMC:门诊西药, BZ0000:null, PCID00:62, PCMC00:qd, TS0000:3天, YFID00:303, YFMC00:餐前口服, CSL000:0.133, JLDW00:g, YPZSL0:1, CFDW00:盒, LYL000:1, LYDW00:盒, BZXH00:null, YPNM00:9006018699, YPMC00:●阿奇霉素干混悬剂$G9, LSDJ00:3.06, YBLB00:4, YBLBMC:甲类药品, ZXKS00:140, ZXKSMC:门诊药房, SFPS00:false, SFSY00:null, YYTBS0:0, SFBS00:0, CFZJE0:87.04, ZTNR00:null, YZID00:17341529, YZMXID:29140060, CJL000:0.133]
12:09:36.524 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM, a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM, b.CFID00,
a.YPDLBH YPLB00, '10' CFLX00,
'中医科' CFLXMC, '' BZ0000, b.PCID00, (select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00, b.ypzsl0, b.ypzsl0||b.CFDW00 CFDW00, '' BZXH00, '' ZL0000,
'' ZLDW00, b.ypnm00, b.ypmc00, a.JYFS00 YFID00,--ZJYFID中药整剂用法ID
(select JYFSMC from YS_JYFS00 where BH0000 = a.JYFS00) YFMC00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
'false' SFFS00,--是否与付数有关
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00 --嘱托内容
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.ghid00 = :ghid00
and a.YPDLBH = '2'======params:ghid00=25256072,cflsh0=17341529,======span:2ms
12:09:36.524 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> cydata------:null
12:09:36.524 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> wsParams------:
?
-
-
-
-
-
-
取值
-
-
●阿奇霉素干混悬剂$G9
●阿奇霉素干混悬剂$G9
3
-
治疗肠胃问题
取值
-
药品名称
-
药品名称
-
药品名称
-
-
-
]]>
12:09:36.563 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> status------:200
12:09:36.563 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> title------:OK
12:09:36.563 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload------:[Body:[HIPMessageServerResponse:[HIPMessageServerResult:[MCCI_IN000002UV01:[@ITSVersion:XML_1.0, @schemaLocation:urn:hl7-org:v3 ../multicacheschemas/MCCI_IN000002UV01.xsd, id:[@extension:3CD896C1-A64B-4F11-998E-F4BBF6F54E1C], creationTime:[@value:20250109120936], interactionId:[@root:2.16.840.1.113883.1.6, @extension:MCCI_IN000002UV01], processingCode:[@code:P], processingModeCode:[@code:R], acceptAckCode:[@code:AL], receiver:[@typeCode:RCV, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99998.8734]]], sender:[@typeCode:JHIP, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99999.4567]]], acknowledgement:[@typeCode:AA, targetMessage:[id:[@extension:6475bc47-0a10-469f-a63d-584ea9006e7a]], acknowledgementDetail:[text:集成平台成功接收JH0308处方服务事件]]]]]]]
12:09:36.565 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select d.CFLSH0, decode(d.YPDLBH,'0','01','1','01','2','10') CFLB00, decode(d.YPDLBH,'0','门诊处方笺','1','门诊处方笺','2','中医科') CFLBMC
from YF_MZCF00 d where ghid00 = :ghid00
and d.cfzt00 = '1'======params:ghid00=25256614,======span:2ms
12:09:36.565 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> ysfdata------:null
12:09:36.568 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM,
a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM,
b.CFID00,
'03' YPLBBH,
'10' CFLX00,
'门诊西药' CFLXMC,
'' BZ0000,
b.PCID00,
(select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00,
b.YYSJ00||b.YYSJDW TS0000,
b.Yfid00,
(select YPYFMC from bm_ypyf00 where yfid00 = b.yfid00) YFMC00,
b.csl000,
b.jldw00,
b.ypzsl0,
b.CFDW00,
b.ypzsl0 lyl000,
b.CFDW00 lydw00,
'' BZXH00,
b.ypnm00,
b.ypmc00,
b.lsdj00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
decode(d.PSZT00,'0','false','1','true') SFPS00,--是否皮试
decode(d.PSZT00,'2','false','3','true') SFSY00,--是否适应
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00, --备注
b.cflsh0 yzid00,
b.cfid00 yzmxid,
round(b.csl000,4) cjl000
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.YPDLBH in ('0','1')======params:cflsh0=17341527,======span:3ms
12:09:36.568 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> xcydata------:[CFID00:29140049, CFLSH0:17341527, KFSJ00:20250109120444, KFYS00:131, KFYSXM:黄炳暖, KFKS00:108, KFKSMC:门诊儿科, SHSJ00:null, SHYS00:null, SHYSXM:null, YPLBBH:03, CFLX00:10, CFLXMC:门诊西药, BZ0000:null, PCID00:69, PCMC00:tid, TS0000:3天, YFID00:1, YFMC00:餐后口服, CSL000:1, JLDW00:支, YPZSL0:1, CFDW00:盒, LYL000:1, LYDW00:盒, BZXH00:null, YPNM00:9006018621, YPMC00:射麻口服液, LSDJ00:47.76, YBLB00:4, YBLBMC:甲类药品, ZXKS00:141, ZXKSMC:中药房, SFPS00:false, SFSY00:null, YYTBS0:0, SFBS00:2, CFZJE0:47.76, ZTNR00:null, YZID00:17341527, YZMXID:29140049, CJL000:1]
12:09:36.571 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM, a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM, b.CFID00,
a.YPDLBH YPLB00, '10' CFLX00,
'中医科' CFLXMC, '' BZ0000, b.PCID00, (select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00, b.ypzsl0, b.ypzsl0||b.CFDW00 CFDW00, '' BZXH00, '' ZL0000,
'' ZLDW00, b.ypnm00, b.ypmc00, a.JYFS00 YFID00,--ZJYFID中药整剂用法ID
(select JYFSMC from YS_JYFS00 where BH0000 = a.JYFS00) YFMC00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
'false' SFFS00,--是否与付数有关
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00 --嘱托内容
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.ghid00 = :ghid00
and a.YPDLBH = '2'======params:ghid00=25256614,cflsh0=17341527,======span:2ms
12:09:36.571 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> cydata------:null
12:09:36.572 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> wsParams------:
?
-
-
-
-
-
-
取值
-
-
射麻口服液
射麻口服液
48
-
治疗肠胃问题
取值
-
药品名称
-
药品名称
-
药品名称
-
-
-
]]>
12:09:36.606 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> status------:200
12:09:36.606 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> title------:OK
12:09:36.606 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload------:[Body:[HIPMessageServerResponse:[HIPMessageServerResult:[MCCI_IN000002UV01:[@ITSVersion:XML_1.0, @schemaLocation:urn:hl7-org:v3 ../multicacheschemas/MCCI_IN000002UV01.xsd, id:[@extension:16862C0D-A1A4-45C4-BE55-A572CC72EC55], creationTime:[@value:20250109120936], interactionId:[@root:2.16.840.1.113883.1.6, @extension:MCCI_IN000002UV01], processingCode:[@code:P], processingModeCode:[@code:R], acceptAckCode:[@code:AL], receiver:[@typeCode:RCV, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99998.8734]]], sender:[@typeCode:JHIP, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99999.4567]]], acknowledgement:[@typeCode:AA, targetMessage:[id:[@extension:863f4ff8-9192-46f1-afef-6fe487f0da81]], acknowledgementDetail:[text:集成平台成功接收JH0308处方服务事件]]]]]]]
12:09:36.608 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select d.CFLSH0, decode(d.YPDLBH,'0','01','1','01','2','10') CFLB00, decode(d.YPDLBH,'0','门诊处方笺','1','门诊处方笺','2','中医科') CFLBMC
from YF_MZCF00 d where ghid00 = :ghid00
and d.cfzt00 = '1'======params:ghid00=25254967,======span:2ms
12:09:36.608 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> ysfdata------:[CFLSH0:17341528, CFLB00:01, CFLBMC:门诊处方笺]
12:09:36.611 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM,
a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM,
b.CFID00,
'03' YPLBBH,
'10' CFLX00,
'门诊西药' CFLXMC,
'' BZ0000,
b.PCID00,
(select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00,
b.YYSJ00||b.YYSJDW TS0000,
b.Yfid00,
(select YPYFMC from bm_ypyf00 where yfid00 = b.yfid00) YFMC00,
b.csl000,
b.jldw00,
b.ypzsl0,
b.CFDW00,
b.ypzsl0 lyl000,
b.CFDW00 lydw00,
'' BZXH00,
b.ypnm00,
b.ypmc00,
b.lsdj00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
decode(d.PSZT00,'0','false','1','true') SFPS00,--是否皮试
decode(d.PSZT00,'2','false','3','true') SFSY00,--是否适应
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00, --备注
b.cflsh0 yzid00,
b.cfid00 yzmxid,
round(b.csl000,4) cjl000
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.YPDLBH in ('0','1')======params:cflsh0=17341528,======span:3ms
12:09:36.611 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> xcydata------:[CFID00:29140056, CFLSH0:17341528, KFSJ00:20250109120728, KFYS00:3019, KFYSXM:曾志刚, KFKS00:109, KFKSMC:门耳鼻喉科, SHSJ00:null, SHYS00:null, SHYSXM:null, YPLBBH:03, CFLX00:10, CFLXMC:门诊西药, BZ0000:null, PCID00:69, PCMC00:tid, TS0000:6天, YFID00:1, YFMC00:餐后口服, CSL000:15, JLDW00:mg, YPZSL0:1, CFDW00:盒, LYL000:1, LYDW00:盒, BZXH00:null, YPNM00:9006018425, YPMC00:●▲盐酸氨溴索片X2, LSDJ00:1.5, YBLB00:4, YBLBMC:甲类药品, ZXKS00:140, ZXKSMC:门诊药房, SFPS00:false, SFSY00:null, YYTBS0:0, SFBS00:1, CFZJE0:102.24, ZTNR00:null, YZID00:17341528, YZMXID:29140056, CJL000:15]
12:09:36.614 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM, a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM, b.CFID00,
a.YPDLBH YPLB00, '10' CFLX00,
'中医科' CFLXMC, '' BZ0000, b.PCID00, (select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00, b.ypzsl0, b.ypzsl0||b.CFDW00 CFDW00, '' BZXH00, '' ZL0000,
'' ZLDW00, b.ypnm00, b.ypmc00, a.JYFS00 YFID00,--ZJYFID中药整剂用法ID
(select JYFSMC from YS_JYFS00 where BH0000 = a.JYFS00) YFMC00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
'false' SFFS00,--是否与付数有关
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00 --嘱托内容
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.ghid00 = :ghid00
and a.YPDLBH = '2'======params:ghid00=25254967,cflsh0=17341528,======span:2ms
12:09:36.614 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> cydata------:null
12:09:36.615 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> wsParams------:
?
-
-
-
-
-
-
取值
-
-
●▲盐酸氨溴索片X2
●▲盐酸氨溴索片X2
2
-
治疗肠胃问题
取值
-
药品名称
-
药品名称
-
药品名称
-
-
-
]]>
12:09:36.646 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> status------:200
12:09:36.646 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> title------:OK
12:09:36.647 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload------:[Body:[HIPMessageServerResponse:[HIPMessageServerResult:[MCCI_IN000002UV01:[@ITSVersion:XML_1.0, @schemaLocation:urn:hl7-org:v3 ../multicacheschemas/MCCI_IN000002UV01.xsd, id:[@extension:CB06DBA3-85C7-4CE1-85AB-047EB4DAAA72], creationTime:[@value:20250109120936], interactionId:[@root:2.16.840.1.113883.1.6, @extension:MCCI_IN000002UV01], processingCode:[@code:P], processingModeCode:[@code:R], acceptAckCode:[@code:AL], receiver:[@typeCode:RCV, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99998.8734]]], sender:[@typeCode:JHIP, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99999.4567]]], acknowledgement:[@typeCode:AA, targetMessage:[id:[@extension:bbb91949-5d05-4621-877f-7dbd28a9a1c6]], acknowledgementDetail:[text:集成平台成功接收JH0308处方服务事件]]]]]]]
12:09:36.649 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select d.CFLSH0, decode(d.YPDLBH,'0','01','1','01','2','10') CFLB00, decode(d.YPDLBH,'0','门诊处方笺','1','门诊处方笺','2','中医科') CFLBMC
from YF_MZCF00 d where ghid00 = :ghid00
and d.cfzt00 = '1'======params:ghid00=25250391,======span:2ms
12:09:36.649 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> ysfdata------:[CFLSH0:17341666, CFLB00:01, CFLBMC:门诊处方笺]
12:09:36.652 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM,
a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM,
b.CFID00,
'03' YPLBBH,
'10' CFLX00,
'门诊西药' CFLXMC,
'' BZ0000,
b.PCID00,
(select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00,
b.YYSJ00||b.YYSJDW TS0000,
b.Yfid00,
(select YPYFMC from bm_ypyf00 where yfid00 = b.yfid00) YFMC00,
b.csl000,
b.jldw00,
b.ypzsl0,
b.CFDW00,
b.ypzsl0 lyl000,
b.CFDW00 lydw00,
'' BZXH00,
b.ypnm00,
b.ypmc00,
b.lsdj00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
decode(d.PSZT00,'0','false','1','true') SFPS00,--是否皮试
decode(d.PSZT00,'2','false','3','true') SFSY00,--是否适应
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00, --备注
b.cflsh0 yzid00,
b.cfid00 yzmxid,
round(b.csl000,4) cjl000
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.YPDLBH in ('0','1')======params:cflsh0=17341666,======span:3ms
12:09:36.652 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> xcydata------:[CFID00:29142680, CFLSH0:17341666, KFSJ00:20250109120456, KFYS00:4551, KFYSXM:胡小芹, KFKS00:199, KFKSMC:门诊产科, SHSJ00:null, SHYS00:null, SHYSXM:null, YPLBBH:03, CFLX00:10, CFLXMC:门诊西药, BZ0000:null, PCID00:62, PCMC00:qd, TS0000:28天, YFID00:1, YFMC00:餐后口服, CSL000:2, JLDW00:片, YPZSL0:2, CFDW00:瓶, LYL000:2, LYDW00:瓶, BZXH00:null, YPNM00:9006018514, YPMC00:碳酸钙D3片(Ⅰ), LSDJ00:27.16, YBLB00:7, YBLBMC:非医保药品, ZXKS00:140, ZXKSMC:门诊药房, SFPS00:false, SFSY00:null, YYTBS0:0, SFBS00:1, CFZJE0:128.12, ZTNR00:null, YZID00:17341666, YZMXID:29142680, CJL000:2]
12:09:36.655 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM, a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM, b.CFID00,
a.YPDLBH YPLB00, '10' CFLX00,
'中医科' CFLXMC, '' BZ0000, b.PCID00, (select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00, b.ypzsl0, b.ypzsl0||b.CFDW00 CFDW00, '' BZXH00, '' ZL0000,
'' ZLDW00, b.ypnm00, b.ypmc00, a.JYFS00 YFID00,--ZJYFID中药整剂用法ID
(select JYFSMC from YS_JYFS00 where BH0000 = a.JYFS00) YFMC00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
'false' SFFS00,--是否与付数有关
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00 --嘱托内容
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.ghid00 = :ghid00
and a.YPDLBH = '2'======params:ghid00=25250391,cflsh0=17341666,======span:3ms
12:09:36.655 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> cydata------:null
12:09:36.656 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> wsParams------:
?
-
-
-
-
-
-
取值
-
-
碳酸钙D3片(Ⅰ)
碳酸钙D3片(Ⅰ)
27
-
治疗肠胃问题
取值
-
药品名称
-
药品名称
-
药品名称
-
-
-
]]>
12:09:36.687 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> status------:200
12:09:36.687 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> title------:OK
12:09:36.687 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload------:[Body:[HIPMessageServerResponse:[HIPMessageServerResult:[MCCI_IN000002UV01:[@ITSVersion:XML_1.0, @schemaLocation:urn:hl7-org:v3 ../multicacheschemas/MCCI_IN000002UV01.xsd, id:[@extension:2BA2092A-C2A4-4BE6-BA49-97A137207D35], creationTime:[@value:20250109120936], interactionId:[@root:2.16.840.1.113883.1.6, @extension:MCCI_IN000002UV01], processingCode:[@code:P], processingModeCode:[@code:R], acceptAckCode:[@code:AL], receiver:[@typeCode:RCV, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99998.8734]]], sender:[@typeCode:JHIP, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99999.4567]]], acknowledgement:[@typeCode:AA, targetMessage:[id:[@extension:5e512cee-4a61-48b7-aa97-143ecf0c3cf5]], acknowledgementDetail:[text:集成平台成功接收JH0308处方服务事件]]]]]]]
12:09:36.689 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select d.CFLSH0, decode(d.YPDLBH,'0','01','1','01','2','10') CFLB00, decode(d.YPDLBH,'0','门诊处方笺','1','门诊处方笺','2','中医科') CFLBMC
from YF_MZCF00 d where ghid00 = :ghid00
and d.cfzt00 = '1'======params:ghid00=25250391,======span:2ms
12:09:36.689 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> ysfdata------:[CFLSH0:17341666, CFLB00:01, CFLBMC:门诊处方笺]
12:09:36.692 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM,
a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM,
b.CFID00,
'03' YPLBBH,
'10' CFLX00,
'门诊西药' CFLXMC,
'' BZ0000,
b.PCID00,
(select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00,
b.YYSJ00||b.YYSJDW TS0000,
b.Yfid00,
(select YPYFMC from bm_ypyf00 where yfid00 = b.yfid00) YFMC00,
b.csl000,
b.jldw00,
b.ypzsl0,
b.CFDW00,
b.ypzsl0 lyl000,
b.CFDW00 lydw00,
'' BZXH00,
b.ypnm00,
b.ypmc00,
b.lsdj00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
decode(d.PSZT00,'0','false','1','true') SFPS00,--是否皮试
decode(d.PSZT00,'2','false','3','true') SFSY00,--是否适应
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00, --备注
b.cflsh0 yzid00,
b.cfid00 yzmxid,
round(b.csl000,4) cjl000
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.YPDLBH in ('0','1')======params:cflsh0=17341666,======span:3ms
12:09:36.692 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> xcydata------:[CFID00:29142680, CFLSH0:17341666, KFSJ00:20250109120456, KFYS00:4551, KFYSXM:胡小芹, KFKS00:199, KFKSMC:门诊产科, SHSJ00:null, SHYS00:null, SHYSXM:null, YPLBBH:03, CFLX00:10, CFLXMC:门诊西药, BZ0000:null, PCID00:62, PCMC00:qd, TS0000:28天, YFID00:1, YFMC00:餐后口服, CSL000:2, JLDW00:片, YPZSL0:2, CFDW00:瓶, LYL000:2, LYDW00:瓶, BZXH00:null, YPNM00:9006018514, YPMC00:碳酸钙D3片(Ⅰ), LSDJ00:27.16, YBLB00:7, YBLBMC:非医保药品, ZXKS00:140, ZXKSMC:门诊药房, SFPS00:false, SFSY00:null, YYTBS0:0, SFBS00:1, CFZJE0:128.12, ZTNR00:null, YZID00:17341666, YZMXID:29142680, CJL000:2]
12:09:36.695 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.utils.dynamic.db.JdbcHelper
> select b.cfid00,a.CFLSH0,a.SRRQ00||to_char(to_date(a.SRSJ00,'hh24:mi:ss'),'hh24miss') KFSJ00,a.czy000 KFYS00,(select zwxm00 from bm_ygbm00 where ygbh00 = a.czy000) KFYSXM, a.ghks00 KFKS00,(select bmmc00 from bm_bmbm00 where bmbh00 = a.ghks00) KFKSMC,'' SHSJ00,'' SHYS00, '' SHYSXM, b.CFID00,
a.YPDLBH YPLB00, '10' CFLX00,
'中医科' CFLXMC, '' BZ0000, b.PCID00, (select PCMC00 from bm_pc0000 where pcid00 = b.pcid00) PCMC00, b.ypzsl0, b.ypzsl0||b.CFDW00 CFDW00, '' BZXH00, '' ZL0000,
'' ZLDW00, b.ypnm00, b.ypmc00, a.JYFS00 YFID00,--ZJYFID中药整剂用法ID
(select JYFSMC from YS_JYFS00 where BH0000 = a.JYFS00) YFMC00,
b.YBLB00,
decode(b.YBLB00,'4','甲类药品', '5','乙类药品' ,'6','民族药品', '7','非医保药品','未知') YBLBMC,
'false' SFFS00,--是否与付数有关
d.yfbmbh zxks00,
(select BMMC00 from bm_bmbm00 where bmbh00 = d.yfbmbh) ZXKSMC,
'0' YYTBS0,--银医通标识
d.CFZT00 SFBS00,--收费标识
d.CFZJE0,--处方总金额
d.BZ0000 ZTNR00 --嘱托内容
from ys_cfxxb0 a,ys_cfmx00 b,bm_yd0000 c,YF_MZCF00 d
where a.cflsh0 = b.cflsh0 and b.ypnm00 = c.ypnm00 and a.cflsh0 = d.cflsh0
and a.cflsh0 = :cflsh0
and a.ghid00 = :ghid00
and a.YPDLBH = '2'======params:ghid00=25250391,cflsh0=17341666,======span:2ms
12:09:36.695 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> cydata------:null
12:09:36.696 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> wsParams------:
?
-
-
-
-
-
-
取值
-
-
碳酸钙D3片(Ⅰ)
碳酸钙D3片(Ⅰ)
27
-
治疗肠胃问题
取值
-
药品名称
-
药品名称
-
药品名称
-
-
-
]]>
12:09:36.727 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> status------:200
12:09:36.727 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> title------:OK
12:09:36.728 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> payload------:[Body:[HIPMessageServerResponse:[HIPMessageServerResult:[MCCI_IN000002UV01:[@ITSVersion:XML_1.0, @schemaLocation:urn:hl7-org:v3 ../multicacheschemas/MCCI_IN000002UV01.xsd, id:[@extension:53E40D7B-4727-45A9-BFA9-14AE5D5C69BE], creationTime:[@value:20250109120936], interactionId:[@root:2.16.840.1.113883.1.6, @extension:MCCI_IN000002UV01], processingCode:[@code:P], processingModeCode:[@code:R], acceptAckCode:[@code:AL], receiver:[@typeCode:RCV, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99998.8734]]], sender:[@typeCode:JHIP, device:[@classCode:DEV, @determinerCode:INSTANCE, id:[@root:1.2.840.114350.1.13.99999.4567]]], acknowledgement:[@typeCode:AA, targetMessage:[id:[@extension:4b4385a7-c847-4112-8d6c-3b35f94d56a3]], acknowledgementDetail:[text:集成平台成功接收JH0308处方服务事件]]]]]]]
12:09:36.728 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> 总5条。成功推送5条。
12:09:36.728 [8f91a2fb12894bd5a6454aecb758bf43]|INFO |loomBoundedElastic-2136749|com.ylz.common.groovy.GroovyManage
> response:SimpleResponse(status=200, title=成功, payload=总5条。成功推送5条。)