Interface CompanyRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<Company,Integer>, org.springframework.data.jpa.repository.JpaRepository<Company,Integer>, org.springframework.data.repository.PagingAndSortingRepository<Company,Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Company>, org.springframework.data.repository.Repository<Company,Integer>

@Repository public interface CompanyRepository extends org.springframework.data.jpa.repository.JpaRepository<Company,Integer>
Repository for queries for Company.
  • Method Summary

    Modifier and Type
    Method
    Description
    Find company by Name.
    Find company by RUC.
    Find company by RUC and Name.
    Find company by User identifier.

    Methods inherited from interface org.springframework.data.repository.CrudRepository

    count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

    Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

    deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlush

    Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

    findAll

    Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

    count, exists, findAll, findBy, findOne
  • Method Details

    • findByRuc

      Optional<Company> findByRuc(String ruc)
      Find company by RUC.
      Parameters:
      ruc - company RUC value.
      Returns:
      Company.
    • findByName

      Optional<Company> findByName(String name)
      Find company by Name.
      Parameters:
      name - company Name value.
      Returns:
      Company.
    • findByRucAndName

      Optional<Company> findByRucAndName(String ruc, String name)
      Find company by RUC and Name.
      Parameters:
      ruc - company RUC value.
      name - company Name value.
      Returns:
      Company.
    • findByUserId

      @Query("SELECT c FROM Company c LEFT JOIN UserCompany uc ON c.id = uc.company.id WHERE uc.user.id = :userId AND uc.enabled = true") Optional<Company> findByUserId(@Param("userId") String userId)
      Find company by User identifier.
      Parameters:
      userId - user identifier.
      Returns:
      Company.