org.silverpeas.resourcemanager.repository
Interface ReservedResourceRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<ReservedResource,ReservedResourcePk>, org.springframework.data.jpa.repository.JpaRepository<ReservedResource,ReservedResourcePk>, org.springframework.data.repository.PagingAndSortingRepository<ReservedResource,ReservedResourcePk>, org.springframework.data.repository.Repository<ReservedResource,ReservedResourcePk>

public interface ReservedResourceRepository
extends org.springframework.data.jpa.repository.JpaRepository<ReservedResource,ReservedResourcePk>

Author:

ehugonnet

Method Summary

void	deleteAllReservedResourcesForReservation(Long currentReservationId)
void	deleteAllReservedResourcesForResource(Long currentResourceId)
List<ReservedResource>	findAllReservedResourcesForReservation(Long currentReservationId)
List<ReservedResource>	findAllReservedResourcesOfReservation(Long currentReservationId)
List<ReservedResource>	findAllReservedResourcesWithProblem(Long currentReservationId, List<Long> futureReservedResourceIds, 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

findAllReservedResourcesWithProblem

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

findAllReservedResourcesForReservation

@Query(value="SELECT DISTINCT reservedResource FROM ReservedResource reservedResource WHERE reservedResource.reservation.id = :currentReservationId")
List<ReservedResource> findAllReservedResourcesForReservation(@Param(value="currentReservationId")
                                                                    Long currentReservationId)

deleteAllReservedResourcesForReservation

@Modifying
@Query(value="DELETE ReservedResource reservedResource WHERE reservedResource.reservedResourcePk.reservationId = :currentReservationId")
void deleteAllReservedResourcesForReservation(@Param(value="currentReservationId")
                                                              Long currentReservationId)

deleteAllReservedResourcesForResource

@Modifying
@Query(value="DELETE ReservedResource reservedResource WHERE reservedResource.reservedResourcePk.resourceId = :currentResourceId")
void deleteAllReservedResourcesForResource(@Param(value="currentResourceId")
                                                           Long currentResourceId)

findAllReservedResourcesOfReservation

@Query(value="SELECT DISTINCT reservedResource FROM ReservedResource reservedResource WHERE reservedResource.reservedResourcePk.reservationId = :currentReservationId")
List<ReservedResource> findAllReservedResourcesOfReservation(@Param(value="currentReservationId")
                                                                   Long currentReservationId)