-- Start of DDL Script for View SD_HOSPITAL.VW_YF_DJDDY
-- Generated 9-三月-2023 17:59:37 from SD_HOSPITAL@zpxzyy

CREATE OR REPLACE VIEW vw_yf_djddy (
   cflsh0,
   cfid00,
   cfmx00 )
AS
select a.CFLSH0,-1,rpad('挂号号:'||Trim(a.GHH000),18,' ')||
       rpad('姓名:'||Trim(a.BRXM00),15,' ')||rpad('性别:'||Trim(a.XB0000),8,' ')||
       rpad('年龄:'||Trim(SF_YF_CSRQTONL(a.CSRQ00,a.SRRQ00)),10,' ')||
       rpad('处方号:'||Trim(a.CFLSH0),15,' ')
from YF_MZCF00 a
union all-- CFID00=-1~-10的为页头
select a.CFLSH0,-2,rpad('代煎剂数:'||Trim(a.ZYDJS0),16,' ')||
       rpad('代煎费:'||(Select to_char(sum(F.HJJE00),'999990.00') HJJE00 from SF_FYMX00 F where F.DJH000=A.FJFDJH and F.XMBH00=(select Trim(VALUE0) from xt_xtcs00 where name00='YF_ZYJYF_SFDM')),20,' ')||
       rpad('用法:'||(Select Trim(X.YPYFMC)||Trim(X.YFSMMC) YYFF00 from YF_MZCFMX X where a.CFLSH0=x.CFLSH0 and rownum=1),25,' ')
from YF_MZCF00 a
union all
SELECT CFLSH0,-3,rpad('服药时间:',17,' ')
FROM  YF_MZCF00
union all
SELECT a.CFLSH0,-4,rpad('备注:',15,' ')
FROM YF_MZCF00 a
union all
SELECT a.CFLSH0,-5,'医师:       '||
        rpad('调剂:',15,' ')||rpad('煎药:',15,' ')||
        '打印日期:'||to_char(sysdate,'YYYY-MM-DD')
FROM YF_MZCF00 a
union all
SELECT a.CFLSH0,-7,--rpad('电话:'||(select nvl(brdh00,brlxdh) from bm_brxxb0 where brid00=a.brid00),30,' ')||
       rpad('地址:'||(select nvl(brjtdz,brlxdz) from bm_brxxb0 where brid00=a.brid00),100,' ')       
FROM YF_MZCF00 a
union all
SELECT a.CFLSH0,-6,rpad('电话:'||(select nvl(brdh00,brlxdh) from bm_brxxb0 where brid00=a.brid00),30,' ')
       --||rpad('地址:'||(select nvl(brjtdz,brlxdz) from bm_brxxb0 where brid00=a.brid00),100,' ')
FROM YF_MZCF00 a       
/

-- End of DDL Script for View SD_HOSPITAL.VW_YF_DJDDY