package com.dbnt.kcscbackend.standardCode.repository;

import com.dbnt.kcscbackend.standardCode.entity.TnDocumentGroup;
import com.dbnt.kcscbackend.standardCode.service.StandardCodeTreeInterface;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface TnDocumentGroupRepository extends JpaRepository<TnDocumentGroup, Integer> {

  @Query(value = "select * from sp_get_tn_document_code_by_tree()", nativeQuery = true)
  List<StandardCodeTreeInterface> spGetTnDocumentCodeByTree();
}
