package com.gkhy.labRiskManage.domain.riskReport.repository.jpa;
|
|
import com.gkhy.labRiskManage.domain.riskReport.entity.ReportRiskAssessInfo;
|
import com.gkhy.labRiskManage.domain.riskReport.model.dto.ReportDTO;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
|
import org.springframework.data.jpa.repository.Modifying;
|
import org.springframework.data.jpa.repository.Query;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
|
/**
|
* 风险评估报告
|
*/
|
@Repository
|
public interface ReportRiskAssessInfoRepository extends JpaRepository<ReportRiskAssessInfo, Long>, JpaSpecificationExecutor<ReportRiskAssessInfo> {
|
|
/**
|
* 风险评估报告 - 查询 by id
|
*/
|
@Query(value = "select t from ReportRiskAssessInfo t where t.id = :id and t.deleteStatus = 0")
|
ReportRiskAssessInfo getReportById(Long id);
|
/**
|
* 风险评估报告 - 报告结束
|
*/
|
@Query(value = "update ReportRiskAssessInfo set approve_plan_status = :reportDTO.approvePlanStatus where id = :reportId" , nativeQuery = true)
|
ReportRiskAssessInfo report(ReportDTO reportDTO);
|
/**
|
* 风险评估报告 - 通过id列表查询
|
*/
|
@Query(value = "select t from ReportRiskAssessInfo t where t.id in (?1) and t.deleteStatus = 0")
|
List<ReportRiskAssessInfo> listRiskReport(List<Long> idList);
|
|
@Query(value = "select t from ReportRiskAssessInfo t where t.experimentId = :id and t.deleteStatus = 0")
|
ReportRiskAssessInfo getByExperimentId(Long id);
|
|
@Query(value = "select t from ReportRiskAssessInfo t where t.assessLevel = :assessLevel and t.deleteStatus = 0")
|
List<ReportRiskAssessInfo> getByLevel(Byte assessLevel);
|
|
@Query(value = "update ReportRiskAssessInfo a set a.deleteStatus = 1 , a.updateByUserId =:updateByUserId where a.id = :reportId")
|
@Modifying
|
Integer delReport(Long updateByUserId, Long reportId);
|
}
|