D-Net

package eu.dnetlib.organizations.repository.readonly;

import java.util.List;

import org.springframework.data.domain.Page;

import org.springframework.data.domain.Pageable;

import org.springframework.data.jpa.repository.Query;

import org.springframework.stereotype.Repository;

import eu.dnetlib.organizations.model.BrowseEntry;

import eu.dnetlib.organizations.model.OrganizationSimpleView;

@Repository

public interface OrganizationSimpleViewRepository extends ReadOnlyRepository<OrganizationSimpleView, String> {

	Page<OrganizationSimpleView> findByNameContainingIgnoreCase(String name, Pageable pageable);

	Page<OrganizationSimpleView> findByCountry(String country, Pageable pageable);

	@Query(value = "select * from organizations_simple_view where ?1 = any(types)", countQuery = "select count(*) from types where type = ?1", nativeQuery = true)

	Page<OrganizationSimpleView> findByType(String type, Pageable pageable);

	@Query(value = "select country as value, count(*) as count from organizations group by country order by count desc", nativeQuery = true)

	List<BrowseEntry> browseCountries();

	@Query(value = "select type as value, count(*) as count from types group by type order by count desc", nativeQuery = true)

	List<BrowseEntry> browseTypes();

}