ใบสั่งยา แสดงค่าใช้จ่ายเบิกไม่ได้ ตามสิทธิการรักษา
select
(case when op.paidst in (’01’,’02’,’04’) and sp.pttype is null then ‘àºÔ¡ä´é’ else round(op.sum_price,2) end)
as paid,
(case when op.paidst in (’03’,’01’) and sp.pttype is not null then ‘àºÔ¡äÁèä´é’ else round(d1.item_price,2) end)as paid2,
v1.pttype,v1.pcode,op.paidst,(sp.pttype)as payman,nd.billcode,op.icode,d1.*,v1.*,o1.*,oapp.nextdate,oapp.app_cause,
p.drugallergy,i1.name as pdx_name ,
concat(hpc.hosptype,” “,hpc.name) as hpcna ,
concat(hpc1.hosptype,” “,hpc1.name) as hpcna1
from doctor_order_print d1
left outer join vn_stat v1 on v1.vn=d1.vn
left outer join ovst o1 on o1.vn=d1.vn
left outer join patient p on p.hn = v1.hn
left outer join icd101 i1 on i1.code=v1.main_pdx
left outer join hospcode hpc on hpc.hospcode=v1.hospmain
left outer join hospcode hpc1 on hpc1.hospcode=v1.hospsub
left outer join oapp on oapp.nextdate=d1.vn and oapp.app_cause=d1.vn
left outer join opitemrece op on op.vn=d1.vn and op.icode=d1.icode
left outer join nondrugitems nd on nd.icode=op.icode
left outer join service_pay sp on sp.icode=d1.icode and sp.pttype=v1.pttype
where /* op.paidst =’03’ and v1.vstdate = ‘2014-06-04’ and */ d1.drug_name like ‘%ANALGES%’
/* where d1.vn=”570827155200″ and d1.print_server=”OPD” */
order by d1.item_no
limit 1000
———————————————————————————-
select
(case when op.paidst in (’01’,’02’,’04’) and sp.pttype is null then ‘àºÔ¡ä´é’ else round(op.sum_price,2) end)
as paid,
(case when op.paidst in (’03’,’01’) and sp.pttype in (’01’,’09’,’74’,’75’,’76’,’77’,’78’,’79’,’94’,’98’) then ‘àºÔ¡äÁèä´é’
when op.icode=’3003012′ then ‘àºÔ¡äÁèä´é’
else round(d1.item_price,2) end)as paid2,
v1.pttype,v1.pcode,op.paidst,(sp.pttype)as payman,nd.billcode,op.icode,d1.*,v1.*,o1.*,oapp.nextdate,oapp.app_cause,
p.drugallergy,i1.name as pdx_name ,
concat(hpc.hosptype,” “,hpc.name) as hpcna ,
concat(hpc1.hosptype,” “,hpc1.name) as hpcna1
from doctor_order_print d1
left outer join vn_stat v1 on v1.vn=d1.vn
left outer join ovst o1 on o1.vn=d1.vn
left outer join patient p on p.hn = v1.hn
left outer join icd101 i1 on i1.code=v1.main_pdx
left outer join hospcode hpc on hpc.hospcode=v1.hospmain
left outer join hospcode hpc1 on hpc1.hospcode=v1.hospsub
left outer join oapp on oapp.nextdate=d1.vn and oapp.app_cause=d1.vn
left outer join opitemrece op on op.vn=d1.vn and op.icode=d1.icode
left outer join nondrugitems nd on nd.icode=op.icode
left outer join service_pay sp on sp.icode=d1.icode and sp.pttype=v1.pttype
/* where op.paidst =’03’ and v1.vstdate = ‘2014-06-04’ and d1.drug_name like ‘%ANALGES%’ /*
where d1.vn=”570827155200″ and d1.print_server=”OPD” */
order by d1.item_no
limit 1000
ความเห็นล่าสุด