| read | read | | Reads a row of data from Place table.
| |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing row on Place table.
| |
| insert | insert | AUTO_ID: placeID
| Creates a new row on Place table.
| |
| remove | remove | | Removes an existing row from Place table.
| |
| searchPlacesByCompartment | readmulti | READMULTI_LIM: 0
| Searches for all the Places related to a specific Compartment. | |
| searchAllPlacesByCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: Place.compartmentID = :compartmentID
AND
Place.type = :type
AND
Place.recordStatus <> :cancelStatus
| Searches for all the Places related to a specific Compartment. | |
| searchByNameAndStatus | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: Place.compartmentID = :compartmentID
AND
(UPPER(Place.name) = :name)
AND
(
Place.recordStatus <> :closeStatus
AND
Place.recordStatus <> :cancelStatus
)
| Searches for Places with the specified Place Details. | |
| searchAvailablePlacesInCompartmentForDateRange | readmulti | ORDER_BY: compartmentID
READMULTI_LIM: 0
WHERE: startDate <= :startDate
AND (:endDateEntered ='0' OR endDate is null or endDate >=:endDate)
AND compartmentID=:compartmentID
AND
placeid NOT IN
(select placeid from outofuseperiod where (:endDateEntered ='0' OR startDate<=:endDate)
AND (endDate is NULL or endDate>=:startDate))
AND
placeid NOT IN
(select placeid from placement where
recordStatus=:placementStatus
AND
(:endDateEntered ='0' OR startDate<=:placementEndDateTime)
AND
(endDate is NULL or endDate>=:placementStartDateTime)) AND recordStatus <> :recordStatus
| @superseded - searchAvailablePlacesInCompartmentForPeriod | |
| searchAvailablePlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
startDate<=:date
AND
(endDate is NULL or endDate>=:date)
AND
placeid NOT IN
(select placeid from outofuseperiod where startDate<=:date
AND (endDate is NULL or endDate>=:date))
AND
placeid NOT IN
(select placeid from placement where startDate<=:placementDatetime
AND
recordStatus=:placementStatus
AND
(endDate is NULL or endDate>=:placementDatetime)) AND recordStatus <> :recordStatus
| Searches all available Places for the Compartment as on a specific date. | |
| searchOutOfUsePlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
placeid IN
(select placeid from outofuseperiod where startDate<=:date
AND
(endDate is NULL or endDate>=:date)) AND recordStatus <> :recordStatus
| Searches all Out Of Use Places for the Compartment as on a specific date. | |
| searchOccupiedPlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
placeid IN
(select placeid from placement where
recordStatus=:placementStatus
AND
startDate<=:placementDatetime
AND (endDate is NULL or endDate>=:placementDatetime)) AND recordStatus <> :recordStatus
| Searches all Occupied Places for the Compartment as on a specific date.
@deprecated Since Curam 5.2 SP6, replaced with {@link Place#searchOccupiedPlacesForCompartmentOnCurrentDateTime(CompartmentIDAndDate)} .
This method is not performant and the method takes a long time when all occupied places for the compartment is searched.
See release note: CR00. | |
| searchClosedPlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
(endDate is not NULL and endDate<=:date) AND recordStatus <> :recordStatus
| Searches all Closed Places for the Compartment as on a specific date. | |
| searchPlacesInCompartmentForDateRange | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: startDate>=:startDate
AND (:endDateEntered ='0' OR endDate is null or endDate <=:endDate)
AND compartmentID=:compartmentID AND recordStatus <> :recordStatus
| Searches all the places in a specific Compartment for a date range. | |
| searchEmergencyPlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
| Searches all Emergency Places for the compartment. | |
| searchPlaceStatusByDateRange | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: startDate <= :startDate
AND (:endDateEntered ='0' OR endDate is null or endDate >=:endDate)
AND placeID=:placeID
AND
placeid NOT IN
(select placeid from outofuseperiod where (:endDateEntered ='0' OR startDate<=:endDate)
AND (endDate is NULL or endDate>=:startDate))
AND
placeid NOT IN
(select placeid from placement where
recordStatus=:placementStatus
AND
(:endDateEntered ='0' OR startDate<=:placementEndDateTime)
AND
(endDate is NULL or endDate>=:placementStartDateTime))
AND recordStatus <> :recordStatus
| Searches a list of available places in a given Date Range. | |
| searchForAllPlacesByCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: Place.compartmentID = :compartmentID
AND
Place.recordStatus <> :cancelStatus
| Searches for Places of all types for a Compartment. | |
| searchAvailabilityOfPlaceByReservationDateRange | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: startDate <= :startDate
AND (:endDateEntered ='0' OR endDate is null or endDate >=:endDate)
AND placeID=:placeID
AND recordStatus <> :recordStatus
AND
placeid NOT IN
(select placeid from outofuseperiod where (:endDateEntered ='0' OR startDate<=:endDate)
AND (endDate is NULL or endDate>=:startDate))
AND
placeid NOT IN
(select placeid from placement where
recordStatus=:placementStatus
AND
(:endDateEntered ='0' OR startDate<=:placementEndDateTime)
AND
(endDate is NULL or endDate>=:placementStartDateTime))
AND
placeid NOT IN
(select placeid from reservation where (:endDateEntered ='0' OR fromDate<=:reservationEndDateTime)
AND
(toDate is NULL or toDate>=:reservationStartDateTime) AND status = :reservationStatus AND placeID is NOT NULL)
| Searches a list of available places in a given Reservation Date Range. | |
| searchAvailablePlacesForCompartmentForReservationDateRange | readmulti | ORDER_BY: compartmentID
READMULTI_LIM: 0
WHERE: startDate <= :startDate
AND (:endDateEntered ='0' OR endDate is null or endDate >=:endDate)
AND compartmentID=:compartmentID
AND recordStatus <> :recordStatus
AND
placeid NOT IN
(select placeid from outofuseperiod where (:endDateEntered ='0' OR startDate<=:endDate)
AND (endDate is NULL or endDate>=:startDate))
AND
placeid NOT IN
(select placeid from placement where
recordStatus=:placementStatus
AND (:endDateEntered ='0' OR startDate<=:placementEndDateTime)
AND
(endDate is NULL or endDate>=:placementStartDateTime))
AND
placeid NOT IN
(select placeid from reservation
where (:endDateEntered ='0' OR fromDate<=:reservationEndDateTime)
AND
(toDate is NULL or toDate>=:reservationStartDateTime)
AND status = :reservationStatus
AND placeID is NOT NULL)
| Searches all available Places for the Compartment as on a specific reservation date range. | |
| searchReservedPlacesForCompartment | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: Place.compartmentID = :id
AND
Place.placeID IN
(select Reservation.placeID from Reservation where Reservation.fromDate <= :dateTime AND (Reservation.toDate is NULL OR Reservation.toDate >= :dateTime)) AND Place.recordStatus <> :recordStatus
| Searches all reserved Places for a specified compartment.
@deprecated Since Curam 5.2 SP6, replaced with {@link Place#searchReservedPlacesForCompartmentOnCurrentDateTime(SearchPlaceKey)} .
This method is not performant and the method takes a long time when all reserved Places for the compartment is searched.
See release note: CR00. | |
| searchTotalCapacityCount | nsmulti | READMULTI_LIM: 0
| Retrieves the total capacity for the provider, given for the input search criteria. The total capacity is the number of places of type designated which are either canceled or closed. | SQL |
| searchOccupiedPlacesCount | nsmulti | READMULTI_LIM: 0
| Retrieves the number of occupied places for the provider, given for the input search criteria. Number of occupied places are the places that have active placement(s), along with active overlapping reservation, if exists for the specified date. | SQL |
| searchReservedPlacesCount | nsmulti | READMULTI_LIM: 0
| Retrieves the number of reserved places for the provider, given for the input search criteria. Number of reserved places are the places that have active reservation(s) exclusive of placement. | SQL |
| searchAvailablePlacesCount | nsmulti | READMULTI_LIM: 0
| Retrieves the number of available places for the provider, given for the input search criteria. | SQL |
| searchAvailablePlacesInCompartmentForPeriod | readmulti | ORDER_BY: compartmentID
READMULTI_LIM: 0
WHERE: startDate <= :startDate
AND ((:endDateEntered ='1'AND endDate >=:endDate) OR endDate IS NULL)
AND compartmentID=:compartmentID
AND recordStatus = :recordStatus
AND type = :placeType
AND
placeID NOT IN
(SELECT placeID FROM Placement WHERE recordStatus= :placementStatus
AND
((startDate <= :placementStartDateTime AND (:placementStartDateTime <= endDate OR endDate IS NULL))
OR
(startDate <= :placementEndDateTime AND (:placementEndDateTime <= endDate OR endDate IS NULL))
OR
(:placementStartDateTime < startDate AND (:placementEndDateTime > endDate OR :endDateEntered = '0') AND (:placementStartDateTime < endDate OR endDate IS NULL))
OR
(endDate IS NULL AND :endDateEntered = '1' AND :placementEndDateTime >= startDate)))
AND
placeID NOT IN
(SELECT placeID FROM Reservation WHERE status= :reservationStatus
AND
((fromDate <= :reservationStartDateTime AND (:reservationStartDateTime <= toDate OR toDate IS NULL))
OR
(fromDate <= :reservationEndDateTime AND (:reservationEndDateTime <= toDate OR toDate IS NULL))
OR
(:reservationStartDateTime < fromDate AND (:reservationEndDateTime > toDate OR :endDateEntered = '0') AND (:reservationStartDateTime < toDate OR toDate IS NULL))
OR
(toDate is NULL AND :endDateEntered = '1' AND :reservationEndDateTime >= fromDate)))
AND
placeID NOT IN
(SELECT placeID FROM OutOfUsePeriod WHERE
(startDate <= :startDate AND (:startDate <= endDate OR endDate IS NULL))
OR
(startDate <= :endDate AND (:endDate <= endDate OR endDate IS NULL))
OR
(:startDate < startDate AND (:startDate > endDate OR :endDateEntered = '0') AND (:startDate < endDate OR endDate IS NULL))
OR
(endDate IS NULL AND :endDateEntered = '1' AND :endDate >= startDate))
| Searches all available places in a compartment for the specified period. | |
| searchAvailablePlacesForCompartmentInDateTimeRange | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
startDate<=:date
AND
(endDate is NULL or endDate>=:date)
AND recordStatus <> :recordStatus
AND
NOT EXISTS
(select placeid from outofuseperiod where Outofuseperiod.placeid = Place.placeid AND ((startDateTime IS NULL AND startDate<=:date) OR
(startDateTime <= :placementDatetime )) AND
(endDateTime IS NULL AND (endDate IS NULL OR endDate>=:date)) OR
(endDateTime>= :placementDatetime ))
AND
NOT EXISTS
(select placeid from placement where Placement.placeid = Place.placeid AND startDate<=:placementDatetime
AND
recordStatus=:placementStatus
AND
(endDate is NULL or endDate>=:placementDatetime))
| Searches all available Places for the Compartment as on a specific reservation date range. While checking for out of use
period it checks for Date Time instead of Date. | |
| searchOutOfUsePlacesForCompartmentInDateTime | readmulti | ORDER_BY: placeID
READMULTI_LIM: 0
WHERE: compartmentId =:compartmentID
AND
placeid IN
(select placeid from outofuseperiod where ((startDateTime IS NULL AND startDate<=:date) OR
(startDateTime <= :placementDatetime )) AND
(endDateTime IS NULL AND (endDate IS NULL OR endDate>=:date)) OR
(endDateTime>= :placementDatetime )) AND recordStatus <> :recordStatus
| Searches out of use places for compartment in date time instead of date.
@deprecated Since Curam 5.2 SP6, replaced with {@link Place#searchOutOfUsePlacesForCompartmentOnCurrentDateTime(CompartmentIDAndDate)} .
This method is not performant and the method takes a long time when all out of use places for the compartment is searched.
See release note: CR00. | |
| searchAvailablePlacesForCompartmentAtCurrentDateTime | nsmulti | READMULTI_LIM: 0
| Gets the list of available places for a compartment at current time. | SQL |
| searchOccupiedPlacesForCompartmentAtCurrentDateTime | nsmulti | READMULTI_LIM: 0
| Gets the list of occupied places for a compartment at current time. | SQL |
| searchOutOfUsePlacesForCompartmentAtCurrentDateTime | nsmulti | READMULTI_LIM: 0
| Gets the list of out of use places for a compartment at current time. | SQL |
| searchEmergencyPlacesForCompartmentAtCurrentDateTime | nsmulti | READMULTI_LIM: 0
| Gets the list of emergency places for a compartment at current time. | SQL |
| searchReservedPlacesForCompartmentAtCurrentDateTime | nsmulti | READMULTI_LIM: 0
| Gets the list of reserved places for a compartment at current time. | SQL |
| searchOccupiedPlacesForCompartmentOnCurrentDateTime | nsmulti | | Searches all occupied places for the compartment as on a specific date. | SQL |
| searchOutOfUsePlacesForCompartmentOnCurrentDateTime | nsmulti | | Searches out of use places for compartment in date time instead of date. | SQL |
| searchReservedPlacesForCompartmentOnCurrentDateTime | nsmulti | | Searches all reserved places for a specified compartment. | SQL |
| searchByNotClosedPlacesForCompartmentAtCurrentDate | readmulti | WHERE: Place.compartmentID = :compartmentID AND Place.recordStatus = :recordStatus AND (Place.endDate is NULL OR endDate>=:endDate)
| Searches all not closed places for the compartment at current date. | |
| searchByStatusForCompartment | readmulti | WHERE: Place.compartmentID = :compartmentID AND Place.recordStatus = :recordStatus
| Searches all the places based on the record status for the compartment. | |
