Package sk.iway.iwcm.components.basket.jpa

Interface BasketInvoiceItemsRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<BasketInvoiceItemEntity,Long>, DomainIdRepository<BasketInvoiceItemEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<BasketInvoiceItemEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<BasketInvoiceItemEntity>, org.springframework.data.repository.PagingAndSortingRepository<BasketInvoiceItemEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<BasketInvoiceItemEntity>, org.springframework.data.repository.Repository<BasketInvoiceItemEntity,Long>

@Repository
public interface BasketInvoiceItemsRepository
extends DomainIdRepository<BasketInvoiceItemEntity,Long>

Method Summary

Modifier and Type	Method	Description
List<BasketInvoiceItemEntity>	findAllByBrowserIdAndDomainId(Long browserId, Integer domainId)
List<BasketInvoiceItemEntity>	findAllByBrowserIdAndItemsBasketInvoiceNullAndDomainId(Long browserId, Integer domainId)
List<BasketInvoiceItemEntity>	findAllByInvoiceIdAndDomainId(Long invoiceId, Integer domainId)
org.springframework.data.domain.Page<BasketInvoiceItemEntity>	findAllByInvoiceIdAndDomainId(Long invoiceId, Integer domainId, org.springframework.data.domain.Pageable pageable)
List<BasketInvoiceItemEntity>	findBasketItem(Long itemId, Long browserId, Integer domainId, Integer invoiceId)
List<BasketInvoiceItemEntity>	findBasketItem(Long itemId, Long browserId, Integer domainId, Integer invoiceId, String itemNote)
List<BasketInvoiceItemEntity>	findBasketItemInvoiceNull(Long itemId, Long browserId, Integer domainId)
List<BasketInvoiceItemEntity>	findBasketItemInvoiceNull(Long itemId, Long browserId, Integer domainId, String itemNote)
Optional<BasketInvoiceItemEntity>	findByInvoiceIdAndItemIdAndDomainId(Long invoiceId, Long itemId, Integer domainId)
Optional<Long>	getBrowserIdByInvoiceId(Long invoiceId, Integer domainId)
void	updateInvoiceId(Long invoiceId, Long browserId, Integer domainId)

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

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

Methods inherited from interface sk.iway.iwcm.system.datatable.spring.DomainIdRepository

findAllByDomainId, findAllByDomainId, findFirstByIdAndDomainId

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

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

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

count, findAll, findAll, findAll, findOne

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

findAllByInvoiceIdAndDomainId

org.springframework.data.domain.Page<BasketInvoiceItemEntity> findAllByInvoiceIdAndDomainId(Long invoiceId,
 Integer domainId,
 org.springframework.data.domain.Pageable pageable)

findAllByInvoiceIdAndDomainId

List<BasketInvoiceItemEntity> findAllByInvoiceIdAndDomainId(Long invoiceId,
 Integer domainId)

findAllByBrowserIdAndDomainId

List<BasketInvoiceItemEntity> findAllByBrowserIdAndDomainId(Long browserId,
 Integer domainId)

findAllByBrowserIdAndItemsBasketInvoiceNullAndDomainId

List<BasketInvoiceItemEntity> findAllByBrowserIdAndItemsBasketInvoiceNullAndDomainId(Long browserId,
 Integer domainId)

findBasketItemInvoiceNull

@Query("SELECT biie FROM BasketInvoiceItemEntity biie WHERE biie.itemId = :itemId AND biie.browserId = :browserId AND biie.domainId = :domainId AND biie.itemsBasketInvoice IS NULL")
List<BasketInvoiceItemEntity> findBasketItemInvoiceNull(@Param("itemId")
 Long itemId,
 @Param("browserId")
 Long browserId,
 @Param("domainId")
 Integer domainId)

findBasketItem

@Query("SELECT biie FROM BasketInvoiceItemEntity biie WHERE biie.itemId = :itemId AND biie.browserId = :browserId AND biie.domainId = :domainId AND biie.invoiceId = :invoiceId")
List<BasketInvoiceItemEntity> findBasketItem(@Param("itemId")
 Long itemId,
 @Param("browserId")
 Long browserId,
 @Param("domainId")
 Integer domainId,
 @Param("invoiceId")
 Integer invoiceId)

findBasketItemInvoiceNull

@Query("SELECT biie FROM BasketInvoiceItemEntity biie WHERE biie.itemId = :itemId AND biie.browserId = :browserId AND biie.domainId = :domainId AND biie.itemNote = :itemNote AND biie.itemsBasketInvoice IS NULL")
List<BasketInvoiceItemEntity> findBasketItemInvoiceNull(@Param("itemId")
 Long itemId,
 @Param("browserId")
 Long browserId,
 @Param("domainId")
 Integer domainId,
 @Param("itemNote")
 String itemNote)

findBasketItem

@Query("SELECT biie FROM BasketInvoiceItemEntity biie WHERE biie.itemId = :itemId AND biie.browserId = :browserId AND biie.domainId = :domainId AND biie.invoiceId = :invoiceId AND biie.itemNote = :itemNote")
List<BasketInvoiceItemEntity> findBasketItem(@Param("itemId")
 Long itemId,
 @Param("browserId")
 Long browserId,
 @Param("domainId")
 Integer domainId,
 @Param("invoiceId")
 Integer invoiceId,
 @Param("itemNote")
 String itemNote)

updateInvoiceId

@Transactional
@Modifying
@Query("UPDATE BasketInvoiceItemEntity biie SET biie.invoiceId = :invoiceId WHERE biie.browserId = :browserId AND biie.invoiceId IS NULL AND biie.domainId = :domainId")
void updateInvoiceId(@Param("invoiceId")
 Long invoiceId,
 @Param("browserId")
 Long browserId,
 @Param("domainId")
 Integer domainId)

getBrowserIdByInvoiceId

@Query("SELECT DISTINCT biie.browserId FROM BasketInvoiceItemEntity biie WHERE biie.invoiceId = :invoiceId AND biie.domainId = :domainId")
Optional<Long> getBrowserIdByInvoiceId(@Param("invoiceId")
 Long invoiceId,
 @Param("domainId")
 Integer domainId)

findByInvoiceIdAndItemIdAndDomainId

Optional<BasketInvoiceItemEntity> findByInvoiceIdAndItemIdAndDomainId(Long invoiceId,
 Long itemId,
 Integer domainId)