package com.its.op.repository;

import com.its.op.model.entity.CmtrGradClsf;
import com.its.op.model.entity.CmtrGradClsfKey;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CmtrGradClsfRepository extends JpaRepository<CmtrGradClsf, CmtrGradClsfKey> {

    //@Query(value = "select distinct p from CmtrGradClsf p inner join fetch p.sect inner join fetch p.grad where p.grad.CMMN_CLSF_CD = 'LTC' and p.grad.CMMN_CD = p.CMTR_GRAD_CD")
    @Query(value = "select distinct p from CmtrGradClsf p inner join fetch p.sect")
    List<CmtrGradClsf> findAll();

}