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 TypeMethodDescriptionfindByName(String name) Find company by Name.Find company by RUC.findByRucAndName(String ruc, String name) Find company by RUC and Name.findByUserId(String userId) Find company by User identifier.Methods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, saveMethods inherited from interface org.springframework.data.jpa.repository.JpaRepository
deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, saveAll, saveAllAndFlush, saveAndFlushMethods inherited from interface org.springframework.data.repository.PagingAndSortingRepository
findAllMethods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor
count, exists, findAll, findBy, findOne
-
Method Details
-
findByRuc
Find company by RUC.- Parameters:
ruc- company RUC value.- Returns:
- Company.
-
findByName
Find company by Name.- Parameters:
name- company Name value.- Returns:
- Company.
-
findByRucAndName
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.
-