ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewinitiateController.java

@@ -92,7 +92,10 @@
    @GetMapping(value = "/getInfo/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id) {
        ServiceEthicalreviewinitiate serviceEthicalreviewinitiate= serviceEthicalreviewinitiateService.getById(id);

        QueryWrapper<ServiceEthicalreviewopinions> ethicalreviewopinionsWrapper=new QueryWrapper<>();
        ethicalreviewopinionsWrapper.eq("nitiate_Id",id);
        List<ServiceEthicalreviewopinions>  ethicalreviewopinionsList= serviceEthicalreviewopinionsService.list(ethicalreviewopinionsWrapper);
        serviceEthicalreviewinitiate.setEthicalreviewopinionsList(ethicalreviewopinionsList);
        return AjaxResult.success(serviceEthicalreviewinitiate);
    }


 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceEthicalreviewopinionsController.java

@@ -16,6 +16,7 @@
import com.ruoyi.project.domain.ServiceEthicalreviewinitiate;
import com.ruoyi.project.domain.ServiceEthicalreviewopinions;
import com.ruoyi.project.domain.vo.EthicalReviewVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsStateTotalVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsTotalVO;
import com.ruoyi.project.service.IServiceEthicalreviewinitiateService;
import com.ruoyi.project.service.IServiceEthicalreviewopinionsService;
@@ -157,13 +158,18 @@
        return toAjax(serviceEthicalreviewopinionsService.update(serviceEthicalreviewopinions,ethicalreviewopinionsWrapper));
    }

    /**
     * èŽ·å–伦理审查专家数量
     */

    @ApiOperation("专家统计详情")
    @GetMapping(value = "/expertTotal")
    public List<EthicalreviewopinionsTotalVO> expertTotal(String expertNo) {
        return serviceEthicalreviewopinionsService.expertTotal(expertNo);
    }


    @ApiOperation("专家状态统计")
    @GetMapping(value = "/stateTotal")
    public List<EthicalreviewopinionsStateTotalVO> stateTotal(String expertNo) {
        return serviceEthicalreviewopinionsService.stateTotal(expertNo);
    }

}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,19 @@
package com.ruoyi.project.domain.vo;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

@Data
public class EthicalreviewopinionsStateTotalVO {
    @ApiModelProperty("总审查量")
    private String count;

    @ApiModelProperty("审查通过")
    private String throughCount;

    @ApiModelProperty("审查驳回")
    private String rejectCount;

    @ApiModelProperty("已放弃")
    private String waiveCount;
}

 ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceEthicalreviewopinionsMapper.java

@@ -5,6 +5,7 @@
import java.util.List;
import com.ruoyi.project.domain.ServiceEthicalreviewopinions;
import com.ruoyi.project.domain.vo.EthicalReviewVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsStateTotalVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsTotalVO;
import com.ruoyi.project.domain.vo.TimeVO;
import org.apache.ibatis.annotations.Mapper;
@@ -30,7 +31,9 @@

    Integer countNumber(TimeVO timeVO);

    List<EthicalreviewopinionsTotalVO> expertTotal(String DonorNo);
    List<EthicalreviewopinionsTotalVO> expertTotal(String expertNo);

    Integer updateTimeOut();

    List<EthicalreviewopinionsStateTotalVO> stateTotal(String expertNo);
}

 ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceEthicalreviewopinionsService.java

@@ -6,6 +6,7 @@
import com.baomidou.mybatisplus.extension.service.IService;
import com.ruoyi.project.domain.ServiceEthicalreviewopinions;
import com.ruoyi.project.domain.vo.EthicalReviewVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsStateTotalVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsTotalVO;

/**
@@ -28,7 +29,9 @@

    List<EthicalReviewVO> selectVOList(EthicalReviewVO ethicalReviewVO);

    List<EthicalreviewopinionsTotalVO> expertTotal(String DonorNo);
    List<EthicalreviewopinionsTotalVO> expertTotal(String expertNo);

    Integer updateTimeOut();

    List<EthicalreviewopinionsStateTotalVO> stateTotal(String expertNo);
}

 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceEthicalreviewopinionsServiceImpl.java

@@ -14,6 +14,7 @@
import com.ruoyi.project.common.CalculateDateUtils;
import com.ruoyi.project.domain.ServiceDonationwitness;
import com.ruoyi.project.domain.vo.EthicalReviewVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsStateTotalVO;
import com.ruoyi.project.domain.vo.EthicalreviewopinionsTotalVO;
import com.ruoyi.project.domain.vo.MedicalEvaluationVO;
import com.ruoyi.project.mapper.ServiceDonationwitnessMapper;
@@ -207,4 +208,9 @@
        return serviceEthicalreviewopinionsMapper.updateTimeOut();
    }

    public List<EthicalreviewopinionsStateTotalVO> stateTotal(String expertNo) {

        return serviceEthicalreviewopinionsMapper.stateTotal(expertNo);
    }

}

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

@@ -209,4 +209,17 @@
        WHERE end_time IS NOT NULL AND end_time &lt;= NOW()
    </update>

    <select id="stateTotal" resultType="com.ruoyi.project.domain.vo.EthicalreviewopinionsStateTotalVO">
        SELECT COUNT(*) count,SUM(CASE WHEN receive_status = 5 THEN 1 ELSE 0 END) AS throughCount,
        SUM(CASE WHEN receive_status =4  THEN 1 ELSE 0 END) AS rejectCount,
        SUM(CASE WHEN receive_status =3  THEN 1 ELSE 0 END) AS waiveCount

        FROM service_ethicalreviewopinions
        <where>
            <if test="expertNo != null ">expert_no = #{expertNo}</if>
        </where>

        GROUP BY receive_status
    </select>

</mapper>