【丽水】手术出院时间

陈昶聿

3 天以前 dbadc28c8f67e76c64b9d3ee502cb247aad98f68

【丽水】手术出院时间

 smartor/src/main/java/com/smartor/domain/PatMedOperationItem.java

@@ -263,5 +263,9 @@
    @ApiModelProperty("住院记录流水号")
    @Excel(name = "住院记录流水号")
    private String serialnum;

    @ApiModelProperty(value = "出院时间")
    private String inhospEndtime;

}


 smartor/src/main/resources/mapper/smartor/PatMedOperationItemMapper.xml

@@ -30,6 +30,7 @@
            <result property="opercheckFlag" column="opercheck_flag"/>
            <result property="longTaskReason" column="long_task_reason"/>
            <result property="inhospstate" column="inhospstate"/>
            <result property="inhospEndtime" column="inhosp_endtime"/>
            <result property="serialnum" column="serialnum"/>

            <result property="deptcode" column="deptcode"/>
@@ -452,10 +453,12 @@
        pmo.deptcode, pmo.deptname, pmo.hospitaldistrictcode, pmo.hospitaldistrictname,
        pmo.leaveldeptcode, pmo.leaveldeptname, pmo.leavehospitaldistrictcode, pmo.leavehospitaldistrictname, pmo.patid,
        pmo.drcode, pmo.drname, pmo.nurse_id, pmo.nurse_name,
        pmo.inhospstate, pmo.serialnum
        pmo.serialnum, pmi.inhospstate
        from pat_med_operation pmo
        join pat_med_operation_item pmoi
        on pmoi.opid = pmo.opid
        left join pat_med_inhosp pmi
        on pmo.serialnum = pmi.serialnum
        where
        pmo.del_flag = '0'
        and pmoi.del_flag = '0'
@@ -510,7 +513,7 @@
            and pmoi.pid = #{pid}
        </if>
        <if test="inhospstate != null and inhospstate != ''">
            and pmo.inhospstate = #{inhospstate}
            and pmi.inhospstate = #{inhospstate}
        </if>
        <if test="serialnum != null and serialnum != ''">
            and pmo.serialnum = #{serialnum}