org.silverpeas.resourcemanager.repository
Interface ReservationRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Reservation,Long>, org.springframework.data.jpa.repository.JpaRepository<Reservation,Long>, org.springframework.data.repository.PagingAndSortingRepository<Reservation,Long>, org.springframework.data.repository.Repository<Reservation,Long>

public interface ReservationRepository
extends org.springframework.data.jpa.repository.JpaRepository<Reservation,Long>

Author:

ehugonnet

Method Summary

List<Reservation>	findAllReservations(String instanceId)
List<Reservation>	findAllReservationsForCategoryInRange(String instanceId, Long categoryId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsForResourceInRange(String instanceId, Long resourceId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsForUser(String instanceId, Integer userId)
List<Reservation>	findAllReservationsForUserAndCategoryInRange(String instanceId, Integer userId, Long categoryId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsForUserAndResourceInRange(String instanceId, Integer userId, Long resourceId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsForUserInRange(String instanceId, Integer userId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsForValidation(String instanceId, Long managerId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsInRange(String instanceId, String startPeriod, String endPeriod)
List<Reservation>	findAllReservationsNotRefusedForResourceInRange(Long resourceId, String startPeriod, String endPeriod)

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

deleteAllInBatch, deleteInBatch, findAll, findAll, flush, save, saveAndFlush

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

findAll

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

count, delete, delete, delete, deleteAll, exists, findAll, findOne, save

Method Detail

findAllReservationsInRange

@Query(value="from Reservation reservation WHERE reservation.instanceId = :instanceId AND reservation.beginDate < :endPeriod AND reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsInRange(@Param(value="instanceId")
                                                   String instanceId,
                                                   @Param(value="startPeriod")
                                                   String startPeriod,
                                                   @Param(value="endPeriod")
                                                   String endPeriod)

findAllReservationsForUserInRange

@Query(value="from Reservation reservation WHERE reservation.instanceId = :instanceId AND reservation.userId= :userId AND reservation.beginDate < :endPeriod AND reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForUserInRange(@Param(value="instanceId")
                                                          String instanceId,
                                                          @Param(value="userId")
                                                          Integer userId,
                                                          @Param(value="startPeriod")
                                                          String startPeriod,
                                                          @Param(value="endPeriod")
                                                          String endPeriod)

findAllReservationsForUser

@Query(value="from Reservation reservation WHERE reservation.instanceId = :instanceId AND reservation.userId= :userId")
List<Reservation> findAllReservationsForUser(@Param(value="instanceId")
                                                   String instanceId,
                                                   @Param(value="userId")
                                                   Integer userId)

findAllReservationsForValidation

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource JOIN reservedResource.resource.managers manager WHERE reservedResource.status = \'A\' AND manager.resourceValidatorPk.managerId = :managerId AND reservedResource.reservation.instanceId = :instanceId AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForValidation(@Param(value="instanceId")
                                                         String instanceId,
                                                         @Param(value="managerId")
                                                         Long managerId,
                                                         @Param(value="startPeriod")
                                                         String startPeriod,
                                                         @Param(value="endPeriod")
                                                         String endPeriod)

findAllReservationsNotRefusedForResourceInRange

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource WHERE reservedResource.resource.id = :resourceId AND reservedResource.status != \'R\' AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsNotRefusedForResourceInRange(@Param(value="resourceId")
                                                                        Long resourceId,
                                                                        @Param(value="startPeriod")
                                                                        String startPeriod,
                                                                        @Param(value="endPeriod")
                                                                        String endPeriod)

findAllReservationsForCategoryInRange

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource WHERE reservedResource.resource.category.id = :categoryId AND reservedResource.reservation.instanceId = :instanceId AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForCategoryInRange(@Param(value="instanceId")
                                                              String instanceId,
                                                              @Param(value="categoryId")
                                                              Long categoryId,
                                                              @Param(value="startPeriod")
                                                              String startPeriod,
                                                              @Param(value="endPeriod")
                                                              String endPeriod)

findAllReservationsForUserAndCategoryInRange

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource WHERE reservedResource.resource.category.id = :categoryId AND reservedResource.reservation.instanceId = :instanceId AND reservedResource.reservation.userId = :userId AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForUserAndCategoryInRange(@Param(value="instanceId")
                                                                     String instanceId,
                                                                     @Param(value="userId")
                                                                     Integer userId,
                                                                     @Param(value="categoryId")
                                                                     Long categoryId,
                                                                     @Param(value="startPeriod")
                                                                     String startPeriod,
                                                                     @Param(value="endPeriod")
                                                                     String endPeriod)

findAllReservationsForResourceInRange

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource WHERE reservedResource.resource.id = :resourceId AND reservedResource.reservation.instanceId = :instanceId AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForResourceInRange(@Param(value="instanceId")
                                                              String instanceId,
                                                              @Param(value="resourceId")
                                                              Long resourceId,
                                                              @Param(value="startPeriod")
                                                              String startPeriod,
                                                              @Param(value="endPeriod")
                                                              String endPeriod)

findAllReservationsForUserAndResourceInRange

@Query(value="SELECT DISTINCT reservedResource.reservation FROM ReservedResource reservedResource WHERE reservedResource.resource.id = :resourceId AND reservedResource.reservation.instanceId = :instanceId AND reservedResource.reservation.userId = :userId AND reservedResource.reservation.beginDate < :endPeriod AND reservedResource.reservation.endDate > :startPeriod ")
List<Reservation> findAllReservationsForUserAndResourceInRange(@Param(value="instanceId")
                                                                     String instanceId,
                                                                     @Param(value="userId")
                                                                     Integer userId,
                                                                     @Param(value="resourceId")
                                                                     Long resourceId,
                                                                     @Param(value="startPeriod")
                                                                     String startPeriod,
                                                                     @Param(value="endPeriod")
                                                                     String endPeriod)

findAllReservations

@Query(value="SELECT DISTINCT reservation FROM Reservation reservation WHERE reservation.instanceId = :instanceId")
List<Reservation> findAllReservations(@Param(value="instanceId")
                                            String instanceId)