package com.estate.expert.admin.domain.exam.record;

import com.estate.expert.admin.domain.common.EntityBaseRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface RecordRepository extends EntityBaseRepository<Record> {

    @Query("select r.problem.id, count(r) from Record r " +
            "where r.deleted = false " +
            "and r.device is null " +
            "and r.problem is not null " +
            "and r.problem.id in :problemIds " +
            "and r.checkTask.id in :taskIds " +
            "group by r.problem.id")
    List<Object[]> countSystemChecksByTaskIdsAndProblemIds(@Param("taskIds") List<Integer> taskIds,
                                                           @Param("problemIds") List<Integer> problemIds);

    @Query(value = "select r.device_id, r.problem_id, count(*) " +
            "from record r " +
            "where r.deleted = false " +
            "and r.device_id is not null " +
            "and r.problem_id is not null " +
            "and r.check_task_id in (:taskIds) " +
            "group by r.device_id, r.problem_id", nativeQuery = true)
    List<Object[]> countDeviceChecksByTaskIds(@Param("taskIds") List<Integer> taskIds);
}