围产系统

http://10.80.128.182/index
admin
gysy@10086

Esb账号
APP_DianYi
0HVus1XDOTrovA7G

1. 数据在系统里导出诊断手术功能未能检索出来，系统没能找出所需的数据
2. 连接病历系统抓取基本信息在系统没看到
3. 临床检查报告项目在围产系统也没有

这3个问题，你那重点解决第3点，然后是第2点，我看了一下接口文档，这两块都有的，看看要在系统里面怎样展示比较好

select count(*) from mid_puerpera_data ;
select count(*) from mid_puerpera_diagnosis ;
select count(*) from mid_puerpera_operation ;
select * from mid_puerpera_emrfile t where t.topic like '%入院记录%';

select  (select count(*) from mid_puerpera_data) mid_puerpera_data,
        (select count(*) from mid_puerpera_diagnosis) mid_puerpera_diagnosis,
        (select count(*) from mid_puerpera_operation) mid_puerpera_operation,
        (select count(*) from mid_puerpera_emrfile) mid_puerpera_emrfile
        from dual 

围产产妇数据中间表

mid_puerpera_data：产妇数据中间表
mid_puerpera_diagnosis：产妇诊断数据中间表
mid_puerpera_emrfile：产妇病历文书数据中间表
mid_puerpera_operation：产妇手术数据中间表

杜博士导出的数据

 select * from (select a.*,
       b.patientid_chr,
       c.lastname_vchr,
       c.inpatientid_chr,
       (select reg.inpatientid_chr
          from t_opr_bih_register reg
         where a.patid = reg.patientid_chr
           and reg.type_int <> 5  and reg.status_int = 1 and reg.inpatientnotype_int = 1
           and rownum = 1)
  from temp_dims a
  left join t_bse_patientcard b
    on a.patid = b.patientid_chr
  left join t_bse_patient c
    on b.patientid_chr = c.patientid_chr
 where length(a.patid) > 6)
 where inpatientid_chr is not null
 union all 
 select a.*,
       b.patientid_chr,
       c.lastname_vchr,
       c.inpatientid_chr,
       (select reg.inpatientid_chr
          from t_opr_bih_register reg
         where a.patid = reg.patientid_chr
           and reg.type_int <> 5  and reg.status_int = 1 and reg.inpatientnotype_int = 1
           and rownum = 1)
  from temp_dims a
  left join t_bse_patient c
    on a.patid = c.inpatientid_chr
  left join t_bse_patientcard b
    on b.patientid_chr = c.patientid_chr
 where length(a.patid) <= 6;


 select mm.*, (select re.inpatientid_chr
          from t_opr_bih_registerdetail reg,
          t_opr_bih_register re 
         where c.idcard_chr = reg.idcard_chr
         and reg.registerid_chr = re.registerid_chr
           and re.type_int <> 5  and re.status_int = 1 and re.inpatientnotype_int = 1
           and rownum = 1) inpno from ( select a.*,
       b.patientid_chr,
       c.lastname_vchr,
       c.inpatientid_chr
  from temp_dims a
  left join t_bse_patientcard b
    on a.patid = b.patientid_chr
  left join t_bse_patient c
    on b.patientid_chr = c.patientid_chr
 where length(a.patid) > 6) mm
  left join t_bse_patient c
    on mm.patientid_chr = c.patientid_chr
    
  where  mm.inpatientid_chr is null 
 ;