public class OrderQueries
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CLASS_VERSION
Class version string
|
protected static java.util.ResourceBundle |
sResourceBundle
Resource Bundle
|
Constructor and Description |
---|
OrderQueries()
Constructs an OrderQueries object.
|
Modifier and Type | Method and Description |
---|---|
protected Query |
getDateRangeQuery(java.util.Date pFrom,
java.util.Date pTo)
Given two dates, contructs a query constrained by the range of these dates
|
int |
getOrderCountForCostCenterInState(java.lang.String pCostCenterId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds)
Returns the count of orders whose state matches the pStates list for the given cost center id
and sites.
|
int |
getOrderCountForProfile(java.lang.String pProfileId)
Returns the count of orders for the passed in profile id.
|
int |
getOrderCountForProfileInState(java.lang.String pProfileId,
int[] pStates)
Returns the count of orders whose state matches the pStates list for the given profile id.
|
int |
getOrderCountForProfileInState(java.lang.String pProfileId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds)
Returns the count of orders whose state matches the pStates list for the given profile id
and sites.
|
int |
getOrderCountForProfileInState(java.lang.String pProfileId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds,
java.util.Collection<java.lang.String> pOrganizationIds)
Returns the count of orders whose state matches the pStates list for the
given profile id and sites.
|
int |
getOrderCountForQuoteOrderHistory(java.lang.String pOrderId)
Returns the count of quote history for an order
|
int |
getOrderCountForQuoteOrderHistory(java.lang.String pOrderId,
int[] pStates)
Returns the count of quote history for an order
|
int |
getOrderCountForQuoteOrderHistoryInState(java.lang.String pOrderId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds)
Returns the count of the quote order history whose state matches the pStates list and sites
|
java.util.List |
getOrderIdsForCostCenter(java.lang.String pCostCenterId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns pNumOrders of the order ids for the given cost center id, in any of the given states, for any
of the given sites, optionally ordered by the given property, starting at pStartIndex.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId)
Returns all the order ids for the given profile id.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pState)
Returns all the order ids for the given profile id in the given state.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int[] pStates)
Returns all the order ids for the given profile id in any of the given states.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the order ids for the given profile id in any of the given states optionally ordered
by the given property.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders)
Returns pNumOrders of the order ids for the given profile id starting at pStartIndex.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int pState)
Returns pNumOrders of the order ids for the given profile id in the given state starting
at pStartIndex
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates)
Returns pNumOrders of the order ids for the given profile id in any of the given states
starting at pStartIndex/
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns pNumOrders of the order ids for the given profile id in any of the given states optionally ordered
by the given property, starting at pStartIndex.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns pNumOrders of the order ids for the given profile id, in any of the given states, for any
of the given sites, optionally ordered by the given property, starting at pStartIndex.
|
java.util.List<java.lang.String> |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds,
java.util.Collection<java.lang.String> pOrganizationIds)
Returns pNumOrders of the order ids for the given profile id, in any of the
given states, for any of the given sites for any of the given
organizations, optionally ordered by the given property, starting at
pStartIndex.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int pState,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns pNumOrders of the order ids for the given profile id in the given state optionally ordered by the given
property, starting at pStartIndex.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the order ids for the given profile id optionally ordered by the given property.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
int pState,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the order ids for the given profile id in the given state optionally ordered by the given
property.
|
java.util.List |
getOrderIdsForProfile(java.lang.String pProfileId,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the order ids for the given profile id optionally ordered by the given property.
|
java.util.List |
getOrderIdsForProfileWithinDateRange(java.lang.String pProfileId,
java.util.Date pFrom,
java.util.Date pTo)
Returns a List of orders that were submitted within the given range of dates
and owned by a given user
|
java.util.List |
getOrderIdsForQuoteOrderHistory(java.lang.String pOrderId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns pNumOrders of the order ids that are related to the given order id in the context of a quote, in any of the given states,
optionally ordered by the given property, starting at pStartIndex.
|
java.util.List |
getOrderIdsForQuoteOrderHistory(java.lang.String pOrderId,
int pStartIndex,
int pNumOrders,
int pState,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns pNumOrders of the order ids of quote history in the given state optionally ordered by the given
property, starting at pStartIndex.
|
java.util.List |
getOrderIdsWithinDateRange(java.util.Date pFrom,
java.util.Date pTo)
Returns a List of orders that were submitted within the given range of dates
|
OrderManager |
getOrderManager()
Returns property orderManager
|
Query |
getOrderQueryForCostCenter(java.lang.String pCostCenterId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds,
RepositoryView pView)
Generates a query to find all orders for a given cost center
|
Query |
getOrderQueryForProfile(java.lang.String pProfileId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds,
java.util.Collection<java.lang.String> pOrganizationIds,
RepositoryView pView)
Returns the RQL query that can be executed to get the orders for the given
profile in the given states for the given list of organization ids.
|
Query |
getOrderQueryForProfile(java.lang.String pProfileId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds,
RepositoryView pView)
Returns the RQL query that can be executed to get the orders for the given profile
in the given states for the given sites
|
Query |
getOrderQueryForProfile(java.lang.String pProfileId,
int[] pStates,
RepositoryView pView)
Returns the RQL query that can be executed to get the orders for the given profile
in the given states
|
Query |
getOrderQueryForQuoteOrderHistory(java.lang.String pOrderId,
int[] pStates,
java.util.Collection<java.lang.String> pSiteIds,
RepositoryView pView)
Returns the RQL query that can be executed to get the order history in the context of a quote.
|
java.util.List |
getOrdersForCostCenterInState(java.lang.String pCostCenterId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns all the orders for the given cost center id in any of the given states in any of the given sites,
optionally ordered by the given property.
|
java.util.List |
getOrdersForProfile(java.lang.String pProfileId)
Returns all the orders for the given profile id.
|
java.util.List |
getOrdersForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders)
Returns pNumOrders of the orders for the given profile id, starting with the order
at position pStartIndex
|
java.util.List |
getOrdersForProfile(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns pNumOrders of the orders for the given profile id, starting with the order
at position pStartIndex.
|
java.util.List |
getOrdersForProfile(java.lang.String pProfileId,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the orders for the given profile id optionally ordered by the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pState)
Returns all the orders for the given profile id in the given state.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int[] pStates)
Returns all the orders for the given profile id in any of the given states.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the orders for the given profile id in any of the given states optionally ordered by
the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int pState)
Returns pNumOrders of the orders for the given profile id in the given state, starting at the order
with index pStartIndex
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates)
Returns pNumOrders of the orders for the given profile id in any of the given states
starting at index pStartIndex
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the orders for the given profile id in any of the given states optionally ordered by
the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns all the orders for the given profile id in any of the given states in any of the given sites,
optionally ordered by the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds,
java.util.Collection<java.lang.String> pOrganizationIds)
Returns all the orders for the given profile Id in any of the given states,
in any of the given sites, in any of the given organizations, optionally
ordered by the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pStartIndex,
int pNumOrders,
int pState,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns pNumOrders of the orders for the given profile id in the given state optionally
ordered by the given property.
|
java.util.List |
getOrdersForProfileInState(java.lang.String pProfileId,
int pState,
java.lang.String pOrderByProperty,
boolean pAscending)
Returns all the orders for the given profile id in the given state optionally ordered by the given property.
|
OrderTools |
getOrderTools()
Returns property orderTools
|
java.util.List |
getQuoteOrderHistory(java.lang.String pOrderId,
int pStartIndex,
int pNumOrders,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns pNumOrders of the orders for the given profile id, starting with the order
at position pStartIndex.
|
java.util.List |
getQuoteOrderHistoryInState(java.lang.String pOrderId,
int pStartIndex,
int pNumOrders,
int[] pStates,
java.lang.String pOrderByProperty,
boolean pAscending,
java.util.Collection<java.lang.String> pSiteIds)
Returns all the order quote history for a given order id in any of the given states optionally ordered by
the given property.
|
protected java.util.List |
loadOrdersForIds(java.util.List pOrderIds)
Deprecated.
Use OrderManager#loadOrders
|
void |
setOrderManager(OrderManager pOrderManager)
Sets property orderManager
|
void |
setOrderTools(OrderTools pOrderTools)
Sets property orderTools
|
public static java.lang.String CLASS_VERSION
protected static java.util.ResourceBundle sResourceBundle
public OrderTools getOrderTools()
public void setOrderTools(OrderTools pOrderTools)
pOrderTools
- the value to set for property orderToolspublic OrderManager getOrderManager()
public void setOrderManager(OrderManager pOrderManager)
pOrderManager
- the value to set for property orderManagerpublic java.util.List getOrdersForProfile(java.lang.String pProfileId) throws CommerceException
pProfileId
- the Profile idInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic int getOrderCountForProfile(java.lang.String pProfileId) throws CommerceException
pProfileId
- - the id of the profile whose orders are queried.CommerceException
public int getOrderCountForProfileInState(java.lang.String pProfileId, int[] pStates) throws CommerceException
pProfileId
- - the id of the profile whose orders are countedpStates
- - the list of states that are being queried for.CommerceException
public int getOrderCountForProfileInState(java.lang.String pProfileId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pProfileId
- - the id of the profile whose orders are countedpStates
- - the list of states that are being queried for.pSiteIds
- - the sites the orders should belong to, null for all sitesCommerceException
public int getOrderCountForProfileInState(java.lang.String pProfileId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds, java.util.Collection<java.lang.String> pOrganizationIds) throws CommerceException
pProfileId
- - the id of the profile whose orders are countedpStates
- - the list of states that are being queried for.pSiteIds
- - the sites the orders should belong to, null for all sitespOrganizationIds
- specifies what organizations the orders should belong to, empty
list for all organizations.throws
- CommerceExceptionCommerceException
public int getOrderCountForQuoteOrderHistory(java.lang.String pOrderId, int[] pStates) throws CommerceException
pOrderId
- - the id of the order whose quote history are queried.pStates
- - the list of states that are being queried for.CommerceException
public int getOrderCountForQuoteOrderHistory(java.lang.String pOrderId) throws CommerceException
pOrderId
- - the id of the order whose quote history are queried.CommerceException
public int getOrderCountForQuoteOrderHistoryInState(java.lang.String pOrderId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pOrderId
- - the active quote id whose orders are countedpStates
- - the list of states that are being queried for.pSiteIds
- - the sites the orders should belong to, null for all sitesCommerceException
public int getOrderCountForCostCenterInState(java.lang.String pCostCenterId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pCostCenterId
- - the id of the cost center whose orders are countedpStates
- - the list of states that are being queried for.pSiteIds
- - the sites the orders should belong to, null for all sitesCommerceException
public java.util.List getOrdersForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfile(java.lang.String pProfileId, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pState) throws CommerceException
pProfileId
- the Profile idpState
- specifies what state the orders should be in, if -1 then no constraint is added to the queryInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int pState) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpState
- specifies what state the orders should be in, if -1 then no constraint is added to the queryInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pState, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpState
- specifies what state the orders should be in, if -1 then no constraint is added to the querypOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int pState, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpState
- specifies what state the orders should be in, if -1 then no constraint is added to the querypOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int[] pStates) throws CommerceException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getQuoteOrderHistoryInState(java.lang.String pOrderId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pOrderId
- the order idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getQuoteOrderHistory(java.lang.String pOrderId, int pStartIndex, int pNumOrders, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pOrderId
- the order idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForQuoteOrderHistory(java.lang.String pOrderId, int pStartIndex, int pNumOrders, int pState, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pOrderId
- the order idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpState
- specifies what state the orders should be in, if -1 then no constraint is added to the querypOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForCostCenterInState(java.lang.String pCostCenterId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pCostCenterId
- the cost center idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId) throws CommerceException
pProfileId
- the Profile idInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pState) throws CommerceException
pProfileId
- the Profile idpState
- specifies what state the orders should be in, if -1 then no constraint is added to the queryInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int pState) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpState
- specifies what state the orders should be in, if -1 then no constraint is added to the queryInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int[] pStates) throws CommerceException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pState, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpState
- specifies what state the orders should be in, if -1 then no constraint is added to the querypOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int pState, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpState
- specifies what state the orders should be in, if -1 then no constraint is added to the querypOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForCostCenter(java.lang.String pCostCenterId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pCostCenterId
- the Cost Center idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForQuoteOrderHistory(java.lang.String pOrderId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds) throws CommerceException
pOrderId
- the order idpStartIndex
- the index of the first order to return. (This is an index into the result set
return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false for descendingpSiteIds
- specifies what sites the orders should belong to, null for all sitesInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic Query getOrderQueryForProfile(java.lang.String pProfileId, int[] pStates, RepositoryView pView) throws RepositoryException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inpView
- the order RepositoryViewCommerceException
- thrown if an exception occurs while accessing the repositoryRepositoryException
public Query getOrderQueryForProfile(java.lang.String pProfileId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds, RepositoryView pView) throws RepositoryException
pProfileId
- the Profile idpStates
- specifies what states the orders should be inpSiteIds
- specifies what sites the orders should belong to, null for all sitespView
- the order RepositoryViewCommerceException
- thrown if an exception occurs while accessing the repositoryRepositoryException
public Query getOrderQueryForCostCenter(java.lang.String pCostCenterId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds, RepositoryView pView) throws RepositoryException
pCostCenterId
- The cost center IdpStates
- Specifies what state the orders should be inpSiteIds
- Specifies what sites the orders should belong topView
- the order repository viewRepositoryException
public Query getOrderQueryForQuoteOrderHistory(java.lang.String pOrderId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds, RepositoryView pView) throws RepositoryException, CommerceException
pOrderId
- specifies the order id which links orders relating to the same quotepStates
- Specifies what state the orders should be inpSiteIds
- specifies what sites the orders should belong to, null for all sitespView
- the order RepositoryViewCommerceException
- thrown if an exception occurs while accessing the repositoryRepositoryException
public java.util.List getOrderIdsWithinDateRange(java.util.Date pFrom, java.util.Date pTo) throws CommerceException
pFrom
- the lower date limitpTo
- the upper date limitInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrderIdsForProfileWithinDateRange(java.lang.String pProfileId, java.util.Date pFrom, java.util.Date pTo) throws CommerceException
pProfileId
- the profile to which the orders pertainpFrom
- the lower date limitpTo
- the upper date limitInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositoryprotected Query getDateRangeQuery(java.util.Date pFrom, java.util.Date pTo) throws CommerceException
pFrom
- the lower date limitpTo
- the upper date limitInvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositoryprotected java.util.List loadOrdersForIds(java.util.List pOrderIds) throws CommerceException
pOrderIds
- a List of order IDsCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List getOrdersForProfileInState(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds, java.util.Collection<java.lang.String> pOrganizationIds) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the
result set return by the repository query.)pNumOrders
- the number of orders to returnpStates
- specifies what states the orders should be inpOrderByProperty
- order the results by the given item descriptor property or nullpAscending
- if pOrderByProperty is not null, true for ascending order, false
for descendingpSiteIds
- specifies what sites the orders should belong to, null for all
sites.pOrganizationIds
- specifies what organizations the orders should belong to or null
for all organizations.InvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repositorypublic java.util.List<java.lang.String> getOrderIdsForProfile(java.lang.String pProfileId, int pStartIndex, int pNumOrders, int[] pStates, java.lang.String pOrderByProperty, boolean pAscending, java.util.Collection<java.lang.String> pSiteIds, java.util.Collection<java.lang.String> pOrganizationIds) throws CommerceException
pProfileId
- the Profile idpStartIndex
- the index of the first order to return. (This is an index into the
result set returned by the repository query.)pNumOrders
- the number of orders to return.pStates
- specifies what states the orders should be in.pOrderByProperty
- order the results by the given item descriptor property or null.pAscending
- if pOrderByProperty is not null, true for ascending order, false
for descending.pSiteIds
- specifies what sites the orders should belong to, null for all
sites.pOrganizationIds
- specifies what organizations the orders should belong to or null
for all organizations.InvalidParameterException
- thrown if any of the parameters are null or empty stringCommerceException
- thrown if an exception occurs while accessing the repository.public Query getOrderQueryForProfile(java.lang.String pProfileId, int[] pStates, java.util.Collection<java.lang.String> pSiteIds, java.util.Collection<java.lang.String> pOrganizationIds, RepositoryView pView) throws RepositoryException
pProfileId
- the Profile idpStates
- specifies what states the orders should be in.pSiteIds
- specifies what sites the orders should belong to, null for all
sitespOrganizationIds
- specifies what organizations the orders should belong to, null for
all organizations.pView
- the order RepositoryViewCommerceException
- thrown if an exception occurs while accessing the repositoryRepositoryException