Interface CommerceTierPriceEntryPersistence

All Superinterfaces:
com.liferay.portal.kernel.service.persistence.BasePersistence<CommerceTierPriceEntry>, com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence<CommerceTierPriceEntry>

@ProviderType public interface CommerceTierPriceEntryPersistence extends com.liferay.portal.kernel.service.persistence.BasePersistence<CommerceTierPriceEntry>, com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence<CommerceTierPriceEntry>
The persistence interface for the commerce tier price entry service.

Caching information and settings can be found in portal.properties

See Also:
Generated:
  • Method Summary

    Modifier and Type
    Method
    Description
    int
    countByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
    Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
    int
    countByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
    Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    int
    countByC_M(long commercePriceEntryId, BigDecimal minQuantity)
    Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity = ?.
    int
    countByC_S(long commercePriceEntryId, int status)
    Returns the number of commerce tier price entries where commercePriceEntryId = ? and status = ?.
    int
    countByCommercePriceEntryId(long commercePriceEntryId)
    Returns the number of commerce tier price entries where commercePriceEntryId = ?.
    int
    countByCompanyId(long companyId)
    Returns the number of commerce tier price entries where companyId = ?.
    int
    countByERC_C(String externalReferenceCode, long companyId)
    Returns the number of commerce tier price entries where externalReferenceCode = ? and companyId = ?.
    int
    countByLtD_S(Date displayDate, int status)
    Returns the number of commerce tier price entries where displayDate < ? and status = ?.
    int
    countByLtE_S(Date expirationDate, int status)
    Returns the number of commerce tier price entries where expirationDate < ? and status = ?.
    int
    Returns the number of commerce tier price entries where uuid = ?.
    int
    countByUuid_C(String uuid, long companyId)
    Returns the number of commerce tier price entries where uuid = ? and companyId = ?.
    create(long commerceTierPriceEntryId)
    Creates a new commerce tier price entry with the primary key.
    fetchByC_LteM_First(long commercePriceEntryId, BigDecimal minQuantity, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ?.
    fetchByC_LteM_S_First(long commercePriceEntryId, BigDecimal minQuantity, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    fetchByC_M(long commercePriceEntryId, BigDecimal minQuantity)
    Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or returns null if it could not be found.
    fetchByC_M(long commercePriceEntryId, BigDecimal minQuantity, boolean useFinderCache)
    Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or returns null if it could not be found, optionally using the finder cache.
    fetchByC_S_First(long commercePriceEntryId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and status = ?.
    fetchByCommercePriceEntryId_First(long commercePriceEntryId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ?.
    fetchByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where companyId = ?.
    fetchByERC_C(String externalReferenceCode, long companyId)
    Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or returns null if it could not be found.
    fetchByERC_C(String externalReferenceCode, long companyId, boolean useFinderCache)
    Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or returns null if it could not be found, optionally using the finder cache.
    fetchByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where displayDate < ? and status = ?.
    fetchByLtE_S_First(Date expirationDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where expirationDate < ? and status = ?.
    fetchByPrimaryKey(long commerceTierPriceEntryId)
    Returns the commerce tier price entry with the primary key or returns null if it could not be found.
    fetchByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where uuid = ? and companyId = ?.
    fetchByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where uuid = ?.
    findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
    Returns all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
    findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end)
    Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
    findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
    findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
    findByC_LteM_First(long commercePriceEntryId, BigDecimal minQuantity, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ?.
    findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
    Returns all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end)
    Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    findByC_LteM_S_First(long commercePriceEntryId, BigDecimal minQuantity, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
    findByC_M(long commercePriceEntryId, BigDecimal minQuantity)
    Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or throws a NoSuchTierPriceEntryException if it could not be found.
    findByC_S(long commercePriceEntryId, int status)
    Returns all the commerce tier price entries where commercePriceEntryId = ? and status = ?.
    findByC_S(long commercePriceEntryId, int status, int start, int end)
    Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.
    findByC_S(long commercePriceEntryId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.
    findByC_S(long commercePriceEntryId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.
    findByC_S_First(long commercePriceEntryId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and status = ?.
    findByCommercePriceEntryId(long commercePriceEntryId)
    Returns all the commerce tier price entries where commercePriceEntryId = ?.
    findByCommercePriceEntryId(long commercePriceEntryId, int start, int end)
    Returns a range of all the commerce tier price entries where commercePriceEntryId = ?.
    findByCommercePriceEntryId(long commercePriceEntryId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ?.
    findByCommercePriceEntryId(long commercePriceEntryId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ?.
    findByCommercePriceEntryId_First(long commercePriceEntryId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ?.
    findByCompanyId(long companyId)
    Returns all the commerce tier price entries where companyId = ?.
    findByCompanyId(long companyId, int start, int end)
    Returns a range of all the commerce tier price entries where companyId = ?.
    findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where companyId = ?.
    findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where companyId = ?.
    findByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where companyId = ?.
    findByERC_C(String externalReferenceCode, long companyId)
    Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or throws a NoSuchTierPriceEntryException if it could not be found.
    findByLtD_S(Date displayDate, int status)
    Returns all the commerce tier price entries where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end)
    Returns a range of all the commerce tier price entries where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where displayDate < ? and status = ?.
    findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where displayDate < ? and status = ?.
    findByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where displayDate < ? and status = ?.
    findByLtE_S(Date expirationDate, int status)
    Returns all the commerce tier price entries where expirationDate < ? and status = ?.
    findByLtE_S(Date expirationDate, int status, int start, int end)
    Returns a range of all the commerce tier price entries where expirationDate < ? and status = ?.
    findByLtE_S(Date expirationDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where expirationDate < ? and status = ?.
    findByLtE_S(Date expirationDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where expirationDate < ? and status = ?.
    findByLtE_S_First(Date expirationDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where expirationDate < ? and status = ?.
    findByPrimaryKey(long commerceTierPriceEntryId)
    Returns the commerce tier price entry with the primary key or throws a NoSuchTierPriceEntryException if it could not be found.
    Returns all the commerce tier price entries where uuid = ?.
    findByUuid(String uuid, int start, int end)
    Returns a range of all the commerce tier price entries where uuid = ?.
    findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where uuid = ?.
    findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where uuid = ?.
    findByUuid_C(String uuid, long companyId)
    Returns all the commerce tier price entries where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end)
    Returns a range of all the commerce tier price entries where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns an ordered range of all the commerce tier price entries where uuid = ? and companyId = ?.
    findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
    Returns an ordered range of all the commerce tier price entries where uuid = ? and companyId = ?.
    findByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where uuid = ? and companyId = ?.
    findByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
    Returns the first commerce tier price entry in the ordered set where uuid = ?.
    remove(long commerceTierPriceEntryId)
    Removes the commerce tier price entry with the primary key from the database.
    void
    removeByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
    Removes all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? from the database.
    void
    removeByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
    Removes all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ? from the database.
    removeByC_M(long commercePriceEntryId, BigDecimal minQuantity)
    Removes the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? from the database.
    void
    removeByC_S(long commercePriceEntryId, int status)
    Removes all the commerce tier price entries where commercePriceEntryId = ? and status = ? from the database.
    void
    removeByCommercePriceEntryId(long commercePriceEntryId)
    Removes all the commerce tier price entries where commercePriceEntryId = ? from the database.
    void
    removeByCompanyId(long companyId)
    Removes all the commerce tier price entries where companyId = ? from the database.
    removeByERC_C(String externalReferenceCode, long companyId)
    Removes the commerce tier price entry where externalReferenceCode = ? and companyId = ? from the database.
    void
    removeByLtD_S(Date displayDate, int status)
    Removes all the commerce tier price entries where displayDate < ? and status = ? from the database.
    void
    removeByLtE_S(Date expirationDate, int status)
    Removes all the commerce tier price entries where expirationDate < ? and status = ? from the database.
    void
    Removes all the commerce tier price entries where uuid = ? from the database.
    void
    removeByUuid_C(String uuid, long companyId)
    Removes all the commerce tier price entries where uuid = ? and companyId = ? from the database.
    updateImpl(CommerceTierPriceEntry commerceTierPriceEntry)
     

    Methods inherited from interface com.liferay.portal.kernel.service.persistence.BasePersistence

    cacheResult, cacheResult, clearCache, clearCache, clearCache, clearCache, closeSession, countAll, countWithDynamicQuery, countWithDynamicQuery, dslQuery, dslQuery, dslQueryCount, dslQueryCount, fetchByPrimaryKey, fetchByPrimaryKeys, findAll, findAll, findAll, findAll, findByPrimaryKey, findWithDynamicQuery, findWithDynamicQuery, findWithDynamicQuery, flush, getBadColumnNames, getCurrentSession, getDataSource, getDB, getDialect, getListeners, getModelClass, openSession, processException, reassociateIfAbsent, registerListener, remove, remove, removeAll, removeByFunction, setDataSource, unregisterListener, update, update

    Methods inherited from interface com.liferay.portal.kernel.service.persistence.change.tracking.CTPersistence

    getCTColumnNames, getMappingTableNames, getTableColumnsMap, getTableName, getUniqueIndexColumnNames
  • Method Details

    • findByUuid

      List<CommerceTierPriceEntry> findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByUuid_First

      CommerceTierPriceEntry findByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where uuid = ?.
      Parameters:
      uuid - the uuid
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByUuid_First

      CommerceTierPriceEntry fetchByUuid_First(String uuid, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where uuid = ?.
      Parameters:
      uuid - the uuid
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByUuid

      void removeByUuid(String uuid)
      Removes all the commerce tier price entries where uuid = ? from the database.
      Parameters:
      uuid - the uuid
    • countByUuid

      int countByUuid(String uuid)
      Returns the number of commerce tier price entries where uuid = ?.
      Parameters:
      uuid - the uuid
      Returns:
      the number of matching commerce tier price entries
    • findByUuid_C

      List<CommerceTierPriceEntry> findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByUuid_C_First

      CommerceTierPriceEntry findByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByUuid_C_First

      CommerceTierPriceEntry fetchByUuid_C_First(String uuid, long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByUuid_C

      void removeByUuid_C(String uuid, long companyId)
      Removes all the commerce tier price entries where uuid = ? and companyId = ? from the database.
      Parameters:
      uuid - the uuid
      companyId - the company ID
    • countByUuid_C

      int countByUuid_C(String uuid, long companyId)
      Returns the number of commerce tier price entries where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      Returns:
      the number of matching commerce tier price entries
    • findByCompanyId

      List<CommerceTierPriceEntry> findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByCompanyId_First

      CommerceTierPriceEntry findByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where companyId = ?.
      Parameters:
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByCompanyId_First

      CommerceTierPriceEntry fetchByCompanyId_First(long companyId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where companyId = ?.
      Parameters:
      companyId - the company ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByCompanyId

      void removeByCompanyId(long companyId)
      Removes all the commerce tier price entries where companyId = ? from the database.
      Parameters:
      companyId - the company ID
    • countByCompanyId

      int countByCompanyId(long companyId)
      Returns the number of commerce tier price entries where companyId = ?.
      Parameters:
      companyId - the company ID
      Returns:
      the number of matching commerce tier price entries
    • findByCommercePriceEntryId

      List<CommerceTierPriceEntry> findByCommercePriceEntryId(long commercePriceEntryId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByCommercePriceEntryId_First

      CommerceTierPriceEntry findByCommercePriceEntryId_First(long commercePriceEntryId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByCommercePriceEntryId_First

      CommerceTierPriceEntry fetchByCommercePriceEntryId_First(long commercePriceEntryId, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByCommercePriceEntryId

      void removeByCommercePriceEntryId(long commercePriceEntryId)
      Removes all the commerce tier price entries where commercePriceEntryId = ? from the database.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
    • countByCommercePriceEntryId

      int countByCommercePriceEntryId(long commercePriceEntryId)
      Returns the number of commerce tier price entries where commercePriceEntryId = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      Returns:
      the number of matching commerce tier price entries
    • findByC_M

      CommerceTierPriceEntry findByC_M(long commercePriceEntryId, BigDecimal minQuantity) throws NoSuchTierPriceEntryException
      Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or throws a NoSuchTierPriceEntryException if it could not be found.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByC_M

      CommerceTierPriceEntry fetchByC_M(long commercePriceEntryId, BigDecimal minQuantity, boolean useFinderCache)
      Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or returns null if it could not be found, optionally using the finder cache.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      useFinderCache - whether to use the finder cache
      Returns:
      the matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByC_M

      CommerceTierPriceEntry removeByC_M(long commercePriceEntryId, BigDecimal minQuantity) throws NoSuchTierPriceEntryException
      Removes the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? from the database.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the commerce tier price entry that was removed
      Throws:
      NoSuchTierPriceEntryException
    • countByC_M

      int countByC_M(long commercePriceEntryId, BigDecimal minQuantity)
      Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the number of matching commerce tier price entries
    • findByC_LteM

      List<CommerceTierPriceEntry> findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
      Returns all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the matching commerce tier price entries
    • findByC_LteM

      List<CommerceTierPriceEntry> findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end)
      Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByC_LteM

      List<CommerceTierPriceEntry> findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_LteM

      List<CommerceTierPriceEntry> findByC_LteM(long commercePriceEntryId, BigDecimal minQuantity, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_LteM_First

      CommerceTierPriceEntry findByC_LteM_First(long commercePriceEntryId, BigDecimal minQuantity, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByC_LteM_First

      CommerceTierPriceEntry fetchByC_LteM_First(long commercePriceEntryId, BigDecimal minQuantity, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByC_LteM

      void removeByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
      Removes all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? from the database.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
    • countByC_LteM

      int countByC_LteM(long commercePriceEntryId, BigDecimal minQuantity)
      Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the number of matching commerce tier price entries
    • findByC_S

      List<CommerceTierPriceEntry> findByC_S(long commercePriceEntryId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_S_First

      CommerceTierPriceEntry findByC_S_First(long commercePriceEntryId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByC_S_First

      CommerceTierPriceEntry fetchByC_S_First(long commercePriceEntryId, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByC_S

      void removeByC_S(long commercePriceEntryId, int status)
      Removes all the commerce tier price entries where commercePriceEntryId = ? and status = ? from the database.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
    • countByC_S

      int countByC_S(long commercePriceEntryId, int status)
      Returns the number of commerce tier price entries where commercePriceEntryId = ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      Returns:
      the number of matching commerce tier price entries
    • findByLtD_S

      List<CommerceTierPriceEntry> findByLtD_S(Date displayDate, int status)
      Returns all the commerce tier price entries where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      Returns:
      the matching commerce tier price entries
    • findByLtD_S

      List<CommerceTierPriceEntry> findByLtD_S(Date displayDate, int status, int start, int end)
      Returns a range of all the commerce tier price entries where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByLtD_S

      List<CommerceTierPriceEntry> findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByLtD_S

      List<CommerceTierPriceEntry> findByLtD_S(Date displayDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where displayDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      displayDate - the display date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByLtD_S_First

      CommerceTierPriceEntry findByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByLtD_S_First

      CommerceTierPriceEntry fetchByLtD_S_First(Date displayDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByLtD_S

      void removeByLtD_S(Date displayDate, int status)
      Removes all the commerce tier price entries where displayDate < ? and status = ? from the database.
      Parameters:
      displayDate - the display date
      status - the status
    • countByLtD_S

      int countByLtD_S(Date displayDate, int status)
      Returns the number of commerce tier price entries where displayDate < ? and status = ?.
      Parameters:
      displayDate - the display date
      status - the status
      Returns:
      the number of matching commerce tier price entries
    • findByLtE_S

      List<CommerceTierPriceEntry> findByLtE_S(Date expirationDate, int status)
      Returns all the commerce tier price entries where expirationDate < ? and status = ?.
      Parameters:
      expirationDate - the expiration date
      status - the status
      Returns:
      the matching commerce tier price entries
    • findByLtE_S

      List<CommerceTierPriceEntry> findByLtE_S(Date expirationDate, int status, int start, int end)
      Returns a range of all the commerce tier price entries where expirationDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      expirationDate - the expiration date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByLtE_S

      List<CommerceTierPriceEntry> findByLtE_S(Date expirationDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where expirationDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      expirationDate - the expiration date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByLtE_S

      List<CommerceTierPriceEntry> findByLtE_S(Date expirationDate, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where expirationDate < ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      expirationDate - the expiration date
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByLtE_S_First

      CommerceTierPriceEntry findByLtE_S_First(Date expirationDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where expirationDate < ? and status = ?.
      Parameters:
      expirationDate - the expiration date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByLtE_S_First

      CommerceTierPriceEntry fetchByLtE_S_First(Date expirationDate, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where expirationDate < ? and status = ?.
      Parameters:
      expirationDate - the expiration date
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByLtE_S

      void removeByLtE_S(Date expirationDate, int status)
      Removes all the commerce tier price entries where expirationDate < ? and status = ? from the database.
      Parameters:
      expirationDate - the expiration date
      status - the status
    • countByLtE_S

      int countByLtE_S(Date expirationDate, int status)
      Returns the number of commerce tier price entries where expirationDate < ? and status = ?.
      Parameters:
      expirationDate - the expiration date
      status - the status
      Returns:
      the number of matching commerce tier price entries
    • findByC_LteM_S

      List<CommerceTierPriceEntry> findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
      Returns all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      Returns:
      the matching commerce tier price entries
    • findByC_LteM_S

      List<CommerceTierPriceEntry> findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end)
      Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByC_LteM_S

      List<CommerceTierPriceEntry> findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_LteM_S

      List<CommerceTierPriceEntry> findByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator, boolean useFinderCache)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      useFinderCache - whether to use the finder cache
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_LteM_S_First

      CommerceTierPriceEntry findByC_LteM_S_First(long commercePriceEntryId, BigDecimal minQuantity, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator) throws NoSuchTierPriceEntryException
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByC_LteM_S_First

      CommerceTierPriceEntry fetchByC_LteM_S_First(long commercePriceEntryId, BigDecimal minQuantity, int status, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns the first commerce tier price entry in the ordered set where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      orderByComparator - the comparator to order the set by (optionally null)
      Returns:
      the first matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByC_LteM_S

      void removeByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
      Removes all the commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ? from the database.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
    • countByC_LteM_S

      int countByC_LteM_S(long commercePriceEntryId, BigDecimal minQuantity, int status)
      Returns the number of commerce tier price entries where commercePriceEntryId = ? and minQuantity ≤ ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      status - the status
      Returns:
      the number of matching commerce tier price entries
    • findByERC_C

      CommerceTierPriceEntry findByERC_C(String externalReferenceCode, long companyId) throws NoSuchTierPriceEntryException
      Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or throws a NoSuchTierPriceEntryException if it could not be found.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the matching commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a matching commerce tier price entry could not be found
    • fetchByERC_C

      CommerceTierPriceEntry fetchByERC_C(String externalReferenceCode, long companyId, boolean useFinderCache)
      Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or returns null if it could not be found, optionally using the finder cache.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      useFinderCache - whether to use the finder cache
      Returns:
      the matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • removeByERC_C

      CommerceTierPriceEntry removeByERC_C(String externalReferenceCode, long companyId) throws NoSuchTierPriceEntryException
      Removes the commerce tier price entry where externalReferenceCode = ? and companyId = ? from the database.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the commerce tier price entry that was removed
      Throws:
      NoSuchTierPriceEntryException
    • countByERC_C

      int countByERC_C(String externalReferenceCode, long companyId)
      Returns the number of commerce tier price entries where externalReferenceCode = ? and companyId = ?.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the number of matching commerce tier price entries
    • create

      CommerceTierPriceEntry create(long commerceTierPriceEntryId)
      Creates a new commerce tier price entry with the primary key. Does not add the commerce tier price entry to the database.
      Parameters:
      commerceTierPriceEntryId - the primary key for the new commerce tier price entry
      Returns:
      the new commerce tier price entry
    • remove

      CommerceTierPriceEntry remove(long commerceTierPriceEntryId) throws NoSuchTierPriceEntryException
      Removes the commerce tier price entry with the primary key from the database. Also notifies the appropriate model listeners.
      Parameters:
      commerceTierPriceEntryId - the primary key of the commerce tier price entry
      Returns:
      the commerce tier price entry that was removed
      Throws:
      NoSuchTierPriceEntryException - if a commerce tier price entry with the primary key could not be found
    • updateImpl

      CommerceTierPriceEntry updateImpl(CommerceTierPriceEntry commerceTierPriceEntry)
    • findByPrimaryKey

      CommerceTierPriceEntry findByPrimaryKey(long commerceTierPriceEntryId) throws NoSuchTierPriceEntryException
      Returns the commerce tier price entry with the primary key or throws a NoSuchTierPriceEntryException if it could not be found.
      Parameters:
      commerceTierPriceEntryId - the primary key of the commerce tier price entry
      Returns:
      the commerce tier price entry
      Throws:
      NoSuchTierPriceEntryException - if a commerce tier price entry with the primary key could not be found
    • fetchByPrimaryKey

      CommerceTierPriceEntry fetchByPrimaryKey(long commerceTierPriceEntryId)
      Returns the commerce tier price entry with the primary key or returns null if it could not be found.
      Parameters:
      commerceTierPriceEntryId - the primary key of the commerce tier price entry
      Returns:
      the commerce tier price entry, or null if a commerce tier price entry with the primary key could not be found
    • fetchByC_M

      default CommerceTierPriceEntry fetchByC_M(long commercePriceEntryId, BigDecimal minQuantity)
      Returns the commerce tier price entry where commercePriceEntryId = ? and minQuantity = ? or returns null if it could not be found. Uses the finder cache.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      minQuantity - the min quantity
      Returns:
      the matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • fetchByERC_C

      default CommerceTierPriceEntry fetchByERC_C(String externalReferenceCode, long companyId)
      Returns the commerce tier price entry where externalReferenceCode = ? and companyId = ? or returns null if it could not be found. Uses the finder cache.
      Parameters:
      externalReferenceCode - the external reference code
      companyId - the company ID
      Returns:
      the matching commerce tier price entry, or null if a matching commerce tier price entry could not be found
    • findByUuid

      default List<CommerceTierPriceEntry> findByUuid(String uuid)
      Returns all the commerce tier price entries where uuid = ?.
      Parameters:
      uuid - the uuid
      Returns:
      the matching commerce tier price entries
    • findByUuid

      default List<CommerceTierPriceEntry> findByUuid(String uuid, int start, int end)
      Returns a range of all the commerce tier price entries where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByUuid

      default List<CommerceTierPriceEntry> findByUuid(String uuid, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where uuid = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByUuid_C

      default List<CommerceTierPriceEntry> findByUuid_C(String uuid, long companyId)
      Returns all the commerce tier price entries where uuid = ? and companyId = ?.
      Parameters:
      uuid - the uuid
      companyId - the company ID
      Returns:
      the matching commerce tier price entries
    • findByUuid_C

      default List<CommerceTierPriceEntry> findByUuid_C(String uuid, long companyId, int start, int end)
      Returns a range of all the commerce tier price entries where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByUuid_C

      default List<CommerceTierPriceEntry> findByUuid_C(String uuid, long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where uuid = ? and companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      uuid - the uuid
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByCompanyId

      default List<CommerceTierPriceEntry> findByCompanyId(long companyId)
      Returns all the commerce tier price entries where companyId = ?.
      Parameters:
      companyId - the company ID
      Returns:
      the matching commerce tier price entries
    • findByCompanyId

      default List<CommerceTierPriceEntry> findByCompanyId(long companyId, int start, int end)
      Returns a range of all the commerce tier price entries where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByCompanyId

      default List<CommerceTierPriceEntry> findByCompanyId(long companyId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where companyId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      companyId - the company ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByCommercePriceEntryId

      default List<CommerceTierPriceEntry> findByCommercePriceEntryId(long commercePriceEntryId)
      Returns all the commerce tier price entries where commercePriceEntryId = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      Returns:
      the matching commerce tier price entries
    • findByCommercePriceEntryId

      default List<CommerceTierPriceEntry> findByCommercePriceEntryId(long commercePriceEntryId, int start, int end)
      Returns a range of all the commerce tier price entries where commercePriceEntryId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByCommercePriceEntryId

      default List<CommerceTierPriceEntry> findByCommercePriceEntryId(long commercePriceEntryId, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries
    • findByC_S

      default List<CommerceTierPriceEntry> findByC_S(long commercePriceEntryId, int status)
      Returns all the commerce tier price entries where commercePriceEntryId = ? and status = ?.
      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      Returns:
      the matching commerce tier price entries
    • findByC_S

      default List<CommerceTierPriceEntry> findByC_S(long commercePriceEntryId, int status, int start, int end)
      Returns a range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      Returns:
      the range of matching commerce tier price entries
    • findByC_S

      default List<CommerceTierPriceEntry> findByC_S(long commercePriceEntryId, int status, int start, int end, com.liferay.portal.kernel.util.OrderByComparator<CommerceTierPriceEntry> orderByComparator)
      Returns an ordered range of all the commerce tier price entries where commercePriceEntryId = ? and status = ?.

      Useful when paginating results. Returns a maximum of end - start instances. start and end are not primary keys, they are indexes in the result set. Thus, 0 refers to the first result in the set. Setting both start and end to com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS will return the full result set. If orderByComparator is specified, then the query will include the given ORDER BY logic. If orderByComparator is absent, then the query will include the default ORDER BY logic from com.liferay.commerce.price.list.model.impl.CommerceTierPriceEntryModelImpl.

      Parameters:
      commercePriceEntryId - the commerce price entry ID
      status - the status
      start - the lower bound of the range of commerce tier price entries
      end - the upper bound of the range of commerce tier price entries (not inclusive)
      orderByComparator - the comparator to order the results by (optionally null)
      Returns:
      the ordered range of matching commerce tier price entries