Package es.kukenan.smartfi.microservice.smartficore.repository

Interface ConciliationFileRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<ConciliationFile,String>, org.springframework.data.jpa.repository.JpaRepository<ConciliationFile,String>, org.springframework.data.repository.PagingAndSortingRepository<ConciliationFile,String>, org.springframework.data.repository.query.QueryByExampleExecutor<ConciliationFile>, org.springframework.data.repository.Repository<ConciliationFile,String>
@Repository public interface ConciliationFileRepository extends org.springframework.data.jpa.repository.JpaRepository<ConciliationFile,String>
Repository for queries for Conciliation File.

  • Method Summary

    Modifier and Type
    Method
    Description
    Optional<ConciliationFile>
    findByIdAndCompanyId(String id, Integer companyId)
    Find Conciliation File by Id and Company.
    es.kukenan.smartfi.microservice.backoffice.dtos.core.conciliation.ConciliationFileCardsDto
    findConciliationFilesCards(Integer companyId, Integer status)
    Find conciliation files cards for company.
    Optional<LocalDateTime>
    findLastEndDateByCompanyId(Integer companyId)
    Find last conciliation date by company.

    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

    • findByIdAndCompanyId

      Optional<ConciliationFile> findByIdAndCompanyId(String id, Integer companyId)
      Find Conciliation File by Id and Company.
      Parameters:
      id - Conciliation file identifier.
      companyId - Company identifier.
      Returns:
      Conciliation file.

    • findLastEndDateByCompanyId

      @Query("SELECT MAX(c.endDate) FROM ConciliationFile c WHERE c.company.id = :companyId ") Optional<LocalDateTime> findLastEndDateByCompanyId(@Param("companyId") Integer companyId)
      Find last conciliation date by company.
      Parameters:
      companyId - company identifier.
      Returns:
      Optional Date if exist previous conciliation.

    • findConciliationFilesCards

      @Query("SELECT new es.kukenan.smartfi.microservice.backoffice.dtos.core.conciliation.ConciliationFileCardsDto(sum(c.count), sum(c.total), c.status) FROM ConciliationFile c WHERE c.company.id = :companyId AND c.status = :status GROUP BY c.status") es.kukenan.smartfi.microservice.backoffice.dtos.core.conciliation.ConciliationFileCardsDto findConciliationFilesCards(@Param("companyId") Integer companyId, @Param("status") Integer status)
      Find conciliation files cards for company.
      Parameters:
      companyId - Company Identifier.
      status - status identifier.
      Returns:
      Objects of conciliation cards.