捐献器官统计明细列表

sinake

10 天以前 ca29e025563fb430861d191d11dcd226b4e8e4d7

捐献器官统计明细列表

 ruoyi-project/src/main/java/com/ruoyi/project/domain/vo/ServiceTotalsOrgan.java

@@ -22,4 +22,7 @@

    @ApiModelProperty("区域")
    private String area;

    @ApiModelProperty("弃用数")
    private Integer deprecateCount;
}

 ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml

@@ -46,11 +46,13 @@
    <select id="organ" parameterType="com.ruoyi.project.domain.ServiceTotals"
            resultType="ServiceTotalsOrgan">
        SELECT DATE_FORMAT(a.organ_start_time, '%Y-%m') donateTime,a.OrganName organName, COUNT(*) getCount,c.RegisterCountyName area,
        COUNT(IF(transplantstate=3, true, NULL)) useCount   FROM  service_donationwitnessorgan a
        COUNT(IF(b.transplantstate=3, true, NULL)) useCount ,COUNT(IF(d.complete_state=4, true, NULL)) deprecateCount
        FROM  service_donationwitnessorgan a
        LEFT JOIN  service_donatecomporgan b ON a.InfoID=b.InfoID AND a.OrganName=b.OrganName
        LEFT JOIN  service_donatebaseinfo c ON a.InfoID=c.ID
        LEFT JOIN  service_donatecompletioninfo d ON d.InfoID=a.InfoID
        <where>
            a.del_flag=0
            a.del_flag=0 and b.del_flag=0 and c.del_flag=0 and d.del_flag=0
            <if test="area != null  and area != ''">
                and a.InfoID in (select id FROM service_donatecompletioninfo where RegisterCountyName>=#{area} )
            </if>
@@ -211,12 +213,13 @@

    <select id="organList" parameterType="com.ruoyi.project.domain.ServiceTotals"
            resultType="organList">
        SELECT a.id,a.case_no,a.NAME,a.RegisterCountyName,YEAR(a.donatetime) donateYear,b.OrganName,b.transplantstate,
        b.TransplantTime,b.Name,b.TransplantDoct,b.HospitalName,c.OrganGetTime,c.notgetreason
        SELECT a.id,a.case_no,a.NAME,a.RegisterCountyName,YEAR(a.donatetime) donateYear,b.OrganName,
        b.TransplantTime,b.Name,b.TransplantDoct,b.HospitalName,c.OrganGetTime,c.notgetreason,d.complete_state transplantstate
        FROM service_donatebaseinfo a LEFT JOIN service_donatecomporgan b ON a.ID=b.InfoID
        LEFT JOIN service_donationwitnessorgan c ON a.ID=c.InfoID
        LEFT JOIN  service_donatecompletioninfo d ON d.InfoID=a.id
        <where>
            a.del_flag=0 AND b.del_flag=0 AND c.del_flag=0
            a.del_flag=0 AND b.del_flag=0 AND c.del_flag=0 and d.del_flag=0
            <if test="organName != null  and organName != ''">and b.OrganName=#{organName}</if>
            <if test="area != null  and area != ''">and a.RegisterCountyName=#{area}</if>
            <if test="startTime != null  and startTime != ''">and a.donatetime>=#{startTime}</if>