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.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
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);
}