| | |
| | | |
| | | @ApiModelProperty(value = "专病随访建议") |
| | | private String fuspecialadvice; |
| | | |
| | | /** |
| | | * 证件号码 |
| | | */ |
| | | @ApiModelProperty("证件号码") |
| | | @Excel(name = " 证件号码 ") |
| | | private String idcardno; |
| | | } |
| | |
| | | @ApiModelProperty(value = "结束就诊时间") |
| | | private Date endTime; |
| | | |
| | | /** |
| | | * 证件号码 |
| | | */ |
| | | @ApiModelProperty("证件号码") |
| | | @Excel(name = " 证件号码 ") |
| | | private String idcardno; |
| | | |
| | | } |
| | |
| | | b.futypecode, |
| | | b.futypedesc, |
| | | b.fuadvice, |
| | | b.fuspecialadvice |
| | | b.fuspecialadvice, |
| | | a.idcardno |
| | | FROM |
| | | pat_med_inhosp b |
| | | JOIN |
| | |
| | | <result property="guid" column="guid"/> |
| | | <result property="patno" column="patno"/> |
| | | <result property="diagcheckFlag" column="diagcheck_flag"/> |
| | | <result property="idcardno" column="idcardno"/> |
| | | <result property="remark" column="remark"/> |
| | | </resultMap> |
| | | |
| | |
| | | pmo.patname, |
| | | CONCAT(pa.age,pa.age_unit,pa.age2,pa.age_unit2) AS age, |
| | | pa.telcode, |
| | | pmo.mainsuit |
| | | pmo.mainsuit, |
| | | pa.idcardno |
| | | from pat_med_outhosp pmo left join pat_archive pa on pmo.patid = pa.id |
| | | <where> |
| | | pmo.del_flag=0 |