Package sk.iway.iwcm.components.restaurant_menu.jpa

Interface RestaurantMenuRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<RestaurantMenuEntity,Long>, DomainIdRepository<RestaurantMenuEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<RestaurantMenuEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<RestaurantMenuEntity>, org.springframework.data.repository.PagingAndSortingRepository<RestaurantMenuEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<RestaurantMenuEntity>, org.springframework.data.repository.Repository<RestaurantMenuEntity,Long>
@Repository public interface RestaurantMenuRepository extends DomainIdRepository<RestaurantMenuEntity,Long>

  • Method Summary

    Modifier and Type
    Method
    Description
    List<RestaurantMenuEntity>
    findAllByDayDateAndDomainId(Date dayDate, Integer domainId)
     
    List<RestaurantMenuEntity>
    findAllByDayDateBetweenAndDomainId(Date from, Date to, Integer domainId)
     
    Optional<Integer>
    findMaxPriorityByCathegory(String cathegory, Date dayDate, 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

    • findAllByDayDateAndDomainId

      List<RestaurantMenuEntity> findAllByDayDateAndDomainId(Date dayDate, Integer domainId)

    • findMaxPriorityByCathegory

      @Query("SELECT MAX(rm.priority) FROM RestaurantMenuEntity rm INNER JOIN RestaurantMenuMealsEntity rmm WHERE rm.mealId = rmm.id AND rmm.cathegory = :cathegory AND rm.dayDate = :dayDate AND rm.domainId = :domainId") Optional<Integer> findMaxPriorityByCathegory(@Param("cathegory") String cathegory, @Param("dayDate") Date dayDate, @Param("domainId") Integer domainId)

    • findAllByDayDateBetweenAndDomainId

      List<RestaurantMenuEntity> findAllByDayDateBetweenAndDomainId(Date from, Date to, Integer domainId)